GPAU_EE_TAX_TFN (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.

GPAU_EE_TAX_TFN

(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.

Parent Record Of GPAU_EE_TAX_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 GPAU_TFN_STATUS Character(2) VARCHAR2(2) NOT NULL This field will be used to identify whether an employee has supplied its TFN, deliberately not supplied the TFN, applying for TFN, under 18 years of age, pensioner, etc.
10=Applied For
20=Not Supplied
30=Under 18 Years
40=Full/Part Pensioner
50=Incorrect TFN Given
60=TFN Provided
70=TFN Not Required

4 GPAU_TFN_XMPT_STRT Date(10) DATE This will be the start date of the 28 days that the payee is allowed not to supply his TFN before being taxed at a higher rate.

5 GPAU_TFN_XMPT_END Date(10) DATE This will be the end of the 28 days that the payee is allowed not to supply his TFN before being taxed at a higher rate. This date is usually 28 days after the start date.

6 GPAU_TFN Character(9) VARCHAR2(9) NOT NULL This is the payee's tax file number. This is the payee's unique identification number for tax purposes.

7 GPAU_RE_ENTER_TFN Character(1) VARCHAR2(1) NOT NULL This field will be used to re-enter the payee's tax file number.
Y/N Table Edit
Default Value: N

8 GPAU_TFN_DISCLOSE Character(1) VARCHAR2(1) NOT NULL This will determine whether the payee has given the payer an authority to disclose its TFN to the Superannuation Funds.
Y/N Table Edit
Default Value: N

9 GPAU_ATO_SENT Character(1) VARCHAR2(1) NOT NULL TFN Declaration sent to ATO
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPAU_TFN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify whether an employee has supplied its TFN, deliberately not supplied the TFN, applying for TFN, under 18 years of age, pensioner, etc. 10=Applied For 20=Not Supplied 30=Under 18 Years 40=Full/Part Pensioner 50=Incorrect TFN Given 60=TFN Provided 70=TFN Not Required
4	GPAU_TFN_XMPT_STRT	Date(10)	DATE	This will be the start date of the 28 days that the payee is allowed not to supply his TFN before being taxed at a higher rate.
5	GPAU_TFN_XMPT_END	Date(10)	DATE	This will be the end of the 28 days that the payee is allowed not to supply his TFN before being taxed at a higher rate. This date is usually 28 days after the start date.
6	GPAU_TFN	Character(9)	VARCHAR2(9) NOT NULL	This is the payee's tax file number. This is the payee's unique identification number for tax purposes.
7	GPAU_RE_ENTER_TFN	Character(1)	VARCHAR2(1) NOT NULL	This field will be used to re-enter the payee's tax file number. Y/N Table Edit Default Value: N
8	GPAU_TFN_DISCLOSE	Character(1)	VARCHAR2(1) NOT NULL	This will determine whether the payee has given the payer an authority to disclose its TFN to the Superannuation Funds. Y/N Table Edit Default Value: N
9	GPAU_ATO_SENT	Character(1)	VARCHAR2(1) NOT NULL	TFN Declaration sent to ATO Y/N Table Edit Default Value: N