GPAU_EE_TAX_DTL (SQL Table)	Index Back
Payee Tax Info - Australia This table will be used to record the payee's tax information that would be used for the calculation of its tax withholding amount. This table record the payee's tax file number (TFN), tax scale, total rebates, Medicare levy exemptions, tax adjustments, etc. Each combination of Employee ID, Pay Entity, and Contract Num should have its own row of data in this record. This record is a child record of GPAU_EE_TAX_TFN

GPAU_EE_TAX_DTL

(SQL Table)

Payee Tax Info - Australia

This table will be used to record the payee's tax information that would be used for the calculation of its tax withholding amount. This table record the payee's tax file number (TFN), tax scale, total rebates, Medicare levy exemptions, tax adjustments, etc. Each combination of Employee ID, Pay Entity, and Contract Num should have its own row of data in this record. This record is a child record of GPAU_EE_TAX_TFN

Parent record: GPAU_EE_TAX_TFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: GPAU_EE_TAX_TFN.EMPLID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: GPAU_EE_TAX_TFN.EFFDT

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GPAU_EEPYENT_VW

4 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.
Prompt Table: GPAU_EEBLGRP_VW

5 GPAU_TAX_SCALE Character(3) VARCHAR2(3) NOT NULL This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax.
Prompt Table: GPAU_TAX_SCALES

6 GPAU_PAYMENT_BASIS Character(2) VARCHAR2(2) NOT NULL This is the payee's basis of payment. It identiy whether the payment was made from full time, part time, casual, or labour hire employment, This field is part of the TFN Declaration form to be filled in by the employee.
10=Casual
20=Full Time
30=Labour Hire
40=Part Time
Default Value: 20

7 GPAU_FTB_REBATE Signed Number(8,0) DECIMAL(7) NOT NULL This is the Family Tax Benefit rebate that a payee is entitled to. This field comes from the TFN Declaration form filled it by the payee.

8 GPAU_OTHER_REBATE Signed Number(8,0) DECIMAL(7) NOT NULL This field is the sum of all rebates other than FTB. This includes Dependent Spouse rabate, Zone rebate, Special rebates, etc.

9 GPAU_TOTAL_REBATE Signed Number(8,0) DECIMAL(7) NOT NULL This is the sum of the FTB and Other rebates. This is the amount the will be used in the calculation of the payee's tax.

10 GPAU_CALC_MLA_YN Character(1) VARCHAR2(1) NOT NULL This field will be used to override the calculation of the Medicare Levy adjustments. If this field is set to 'No', then medicare levy adjustment will not be calculated even if the employee is entitled for a medicare levy adjustment. If it is set to 'Y', then medicare levy adjustments will be calculated according to the legislation.
Y/N Table Edit
Default Value: N

11 GPAU_SPOUSE_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse.
Y/N Table Edit
Default Value: N

12 GPAU_CMBND_INC_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee's combined income with the spouse is below the threshold as set by the government to allow any Medicare levy exemptions.
Y/N Table Edit
Default Value: N

13 GPAU_NOOF_DPNDNTS Number(2,0) SMALLINT NOT NULL This is the number of dependents that will affect the payee's medicare levy adjustments

14 GPAU_TAX_ADJ_TYP Character(2) VARCHAR2(2) NOT NULL This will identify the type of adjustment that will be applied to the tax calculation. Valied values are A for additional, N for no override, and O of override.
10=Additional Tax
20=No Tax Adjustment
30=Override Tax
Default Value: 20

15 GPAU_TAX_ADJ_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This is the amount that will either be added to the calculated tax amount or replace this amount.

16 GPAU_TAX_ADJ_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This is the rate that will either be added to or override the calculated tax amount, This rate will be applied to the total gross earnings.

17 GPAU_HECS_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee should be paying HECS payments or not.
Y/N Table Edit
Default Value: N

18 GPAU_SFSS_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if payee should be paying SFSS contributions or not.
Y/N Table Edit
Default Value: N

19 GPAU_FL_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if payee should be paying Flood Levy contributions or not.
Y/N Table Edit
Default Value: N

20 GPAU_CNTRCTR_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee is a contractor or not.
Y/N Table Edit
Default Value: N

21 GPAU_ABN Character(11) VARCHAR2(11) NOT NULL A unique number used by the ATO to identify a contractor.

22 GPAU_ABN_BRANCH Number(3,0) SMALLINT NOT NULL ABN Branch is issued by the ATO to payers that wush to sub-divide their activities. Valid values iare 001 - 999. Default value is 001.

23 GPAU_TFN_SIGNED_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will determine whether the payee has signed the TFN Declaration form that was submitted to the employer.
Y/N Table Edit
Default Value: N

24 GPAU_TFN_SIGNED_DT Date(10) DATE This is the date when the employee has signed the TFN Declaration Form.

25 GPAU_PAYG_ADJ_IND Character(1) VARCHAR2(1) NOT NULL This field would be used to identify if the PAYG Calculation would be overriden or not. This is a Yes/No field, with Yes, indicating that there is an adjustment necessary. The default would be set to No.
Y/N Table Edit
Default Value: N

26 GPAU_PAYG_OVRD_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field would be used to store the PAYG override percent.

27 GPAU_PAYG_OVRD_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the Override Amount.

28 GPAU_PAYG_ADDL_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field willl be used to store the additional percent that would added into the normal calculation

29 GPAU_PAYG_ADDL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the amount that would be added on top of the normal calculation.

30 GPAU_ANNL_ADJ_IND Character(1) VARCHAR2(1) NOT NULL This field would be used to indicate if the Annualised Tax calculation would be adjusted or not. This is a Yes/No field, with Yes indicating that an adjustment is necessary. This would have a default of No.
Y/N Table Edit
Default Value: N

31 GPAU_ANNL_OVRD_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field would be used to store the override percent.

32 GPAU_ANNL_OVRD_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the Override Amount.

33 GPAU_ANNL_ADDL_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field willl be used to store the additional percent that would added into the normal calculation

34 GPAU_ANNL_ADDL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the amount that would be added on top of the normal calculation.

35 GPAU_HECS_ADJ_IND Character(1) VARCHAR2(1) NOT NULL This field would be used to indicate if the HECS calculation would be adjusted or not. This is a Yes/No field, with Yes indicating that an adjustment is necessary. This would have a default of No.
Y/N Table Edit
Default Value: N

36 GPAU_HECS_OVRD_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field would be used to store the override percent.

37 GPAU_HECS_OVRD_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the Override Amount.

38 GPAU_HECS_ADDL_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field willl be used to store the additional percent that would added into the normal calculation

39 GPAU_HECS_ADDL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the amount that would be added on top of the normal calculation.

40 GPAU_SFSS_ADJ_IND Character(1) VARCHAR2(1) NOT NULL This field would be used to indicate if the SFSS calculation would be adjusted or not. This is a Yes/No field, with Yes indicating that an adjustment is necessary. This would have a default of No.
Y/N Table Edit
Default Value: N

41 GPAU_SFSS_OVRD_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field would be used to store the override percent.

42 GPAU_SFSS_OVRD_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the Override Amount.

43 GPAU_SFSS_ADDL_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL This field willl be used to store the additional percent that would added into the normal calculation

44 GPAU_SFSS_ADDL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL This field will be used to store the amount that would be added on top of the normal calculation.

45 GPAU_FL_ADJ_IND Character(1) VARCHAR2(1) NOT NULL Flood Levy Adjustment
Y/N Table Edit
Default Value: N

46 GPAU_FL_OVRD_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL FL Override Percent

47 GPAU_FL_OVRD_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL FL Override Amount

48 GPAU_FL_ADDL_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL FL Additional Percent

49 GPAU_FL_ADDL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL FL Additional Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: GPAU_EE_TAX_TFN.EMPLID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: GPAU_EE_TAX_TFN.EFFDT
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GPAU_EEPYENT_VW
4	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee. Prompt Table: GPAU_EEBLGRP_VW
5	GPAU_TAX_SCALE	Character(3)	VARCHAR2(3) NOT NULL	This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax. Prompt Table: GPAU_TAX_SCALES
6	GPAU_PAYMENT_BASIS	Character(2)	VARCHAR2(2) NOT NULL	This is the payee's basis of payment. It identiy whether the payment was made from full time, part time, casual, or labour hire employment, This field is part of the TFN Declaration form to be filled in by the employee. 10=Casual 20=Full Time 30=Labour Hire 40=Part Time Default Value: 20
7	GPAU_FTB_REBATE	Signed Number(8,0)	DECIMAL(7) NOT NULL	This is the Family Tax Benefit rebate that a payee is entitled to. This field comes from the TFN Declaration form filled it by the payee.
8	GPAU_OTHER_REBATE	Signed Number(8,0)	DECIMAL(7) NOT NULL	This field is the sum of all rebates other than FTB. This includes Dependent Spouse rabate, Zone rebate, Special rebates, etc.
9	GPAU_TOTAL_REBATE	Signed Number(8,0)	DECIMAL(7) NOT NULL	This is the sum of the FTB and Other rebates. This is the amount the will be used in the calculation of the payee's tax.
10	GPAU_CALC_MLA_YN	Character(1)	VARCHAR2(1) NOT NULL	This field will be used to override the calculation of the Medicare Levy adjustments. If this field is set to 'No', then medicare levy adjustment will not be calculated even if the employee is entitled for a medicare levy adjustment. If it is set to 'Y', then medicare levy adjustments will be calculated according to the legislation. Y/N Table Edit Default Value: N
11	GPAU_SPOUSE_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse. Y/N Table Edit Default Value: N
12	GPAU_CMBND_INC_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee's combined income with the spouse is below the threshold as set by the government to allow any Medicare levy exemptions. Y/N Table Edit Default Value: N
13	GPAU_NOOF_DPNDNTS	Number(2,0)	SMALLINT NOT NULL	This is the number of dependents that will affect the payee's medicare levy adjustments
14	GPAU_TAX_ADJ_TYP	Character(2)	VARCHAR2(2) NOT NULL	This will identify the type of adjustment that will be applied to the tax calculation. Valied values are A for additional, N for no override, and O of override. 10=Additional Tax 20=No Tax Adjustment 30=Override Tax Default Value: 20
15	GPAU_TAX_ADJ_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This is the amount that will either be added to the calculated tax amount or replace this amount.
16	GPAU_TAX_ADJ_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This is the rate that will either be added to or override the calculated tax amount, This rate will be applied to the total gross earnings.
17	GPAU_HECS_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee should be paying HECS payments or not. Y/N Table Edit Default Value: N
18	GPAU_SFSS_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if payee should be paying SFSS contributions or not. Y/N Table Edit Default Value: N
19	GPAU_FL_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if payee should be paying Flood Levy contributions or not. Y/N Table Edit Default Value: N
20	GPAU_CNTRCTR_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee is a contractor or not. Y/N Table Edit Default Value: N
21	GPAU_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
22	GPAU_ABN_BRANCH	Number(3,0)	SMALLINT NOT NULL	ABN Branch is issued by the ATO to payers that wush to sub-divide their activities. Valid values iare 001 - 999. Default value is 001.
23	GPAU_TFN_SIGNED_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will determine whether the payee has signed the TFN Declaration form that was submitted to the employer. Y/N Table Edit Default Value: N
24	GPAU_TFN_SIGNED_DT	Date(10)	DATE	This is the date when the employee has signed the TFN Declaration Form.
25	GPAU_PAYG_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	This field would be used to identify if the PAYG Calculation would be overriden or not. This is a Yes/No field, with Yes, indicating that there is an adjustment necessary. The default would be set to No. Y/N Table Edit Default Value: N
26	GPAU_PAYG_OVRD_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field would be used to store the PAYG override percent.
27	GPAU_PAYG_OVRD_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the Override Amount.
28	GPAU_PAYG_ADDL_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field willl be used to store the additional percent that would added into the normal calculation
29	GPAU_PAYG_ADDL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the amount that would be added on top of the normal calculation.
30	GPAU_ANNL_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	This field would be used to indicate if the Annualised Tax calculation would be adjusted or not. This is a Yes/No field, with Yes indicating that an adjustment is necessary. This would have a default of No. Y/N Table Edit Default Value: N
31	GPAU_ANNL_OVRD_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field would be used to store the override percent.
32	GPAU_ANNL_OVRD_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the Override Amount.
33	GPAU_ANNL_ADDL_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field willl be used to store the additional percent that would added into the normal calculation
34	GPAU_ANNL_ADDL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the amount that would be added on top of the normal calculation.
35	GPAU_HECS_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	This field would be used to indicate if the HECS calculation would be adjusted or not. This is a Yes/No field, with Yes indicating that an adjustment is necessary. This would have a default of No. Y/N Table Edit Default Value: N
36	GPAU_HECS_OVRD_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field would be used to store the override percent.
37	GPAU_HECS_OVRD_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the Override Amount.
38	GPAU_HECS_ADDL_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field willl be used to store the additional percent that would added into the normal calculation
39	GPAU_HECS_ADDL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the amount that would be added on top of the normal calculation.
40	GPAU_SFSS_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	This field would be used to indicate if the SFSS calculation would be adjusted or not. This is a Yes/No field, with Yes indicating that an adjustment is necessary. This would have a default of No. Y/N Table Edit Default Value: N
41	GPAU_SFSS_OVRD_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field would be used to store the override percent.
42	GPAU_SFSS_OVRD_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the Override Amount.
43	GPAU_SFSS_ADDL_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	This field willl be used to store the additional percent that would added into the normal calculation
44	GPAU_SFSS_ADDL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	This field will be used to store the amount that would be added on top of the normal calculation.
45	GPAU_FL_ADJ_IND	Character(1)	VARCHAR2(1) NOT NULL	Flood Levy Adjustment Y/N Table Edit Default Value: N
46	GPAU_FL_OVRD_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	FL Override Percent
47	GPAU_FL_OVRD_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	FL Override Amount
48	GPAU_FL_ADDL_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	FL Additional Percent
49	GPAU_FL_ADDL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	FL Additional Amount