GPAU_TFN_EL_VW (SQL View)	Index Back
Empl Payment Summ Certificate This record holds the employee's payment summary per tax year. The payment summary is keyed by emplid, pay enity and balance group id.

GPAU_TFN_EL_VW

(SQL View)

Empl Payment Summ Certificate

This record holds the employee's payment summary per tax year. The payment summary is keyed by emplid, pay enity and balance group id.

SELECT PROCESS_INSTANCE ,EMPLID ,PAY_ENTITY ,BALANCE_GRP_NUM ,GPAU_TFN ,BIRTHDATE ,LAST_NAME ,FIRST_NAME ,MIDDLE_NAME ,GPAU_PREV_LAST_NM ,GPAU_PREV_FIRST_NM ,GPAU_PREV_MIDDL_NM ,ADDRESS1 ,ADDRESS2 ,CITY ,STATE ,POSTAL ,COUNTRY ,COUNTRY_NM ,GPAU_TERM_EMP_YN ,GPAU_TAX_SCALE ,GPAU_PAYMENT_BASIS ,GPAU_FTB_REBATE ,GPAU_OTHER_REBATE ,GPAU_HECS_YN ,GPAU_SFSS_YN ,GPAU_TFN_SIGNED_YN ,GPAU_TFN_SIGNED_DT ,GPAU_TFN_DISCLOSE FROM PS_GPAU_TFN_EL_TAO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

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.

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

6 BIRTHDATE Date(10) DATE Date of Birth

7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

9 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME

10 GPAU_PREV_LAST_NM Character(30) VARCHAR2(30) NOT NULL Previous Last Name - for Taxation Reporting

11 GPAU_PREV_FIRST_NM Character(30) VARCHAR2(30) NOT NULL Previous First Name for Taxation Reporting

12 GPAU_PREV_MIDDL_NM Character(30) VARCHAR2(30) NOT NULL Previous Middle Name - for Taxation Reporting

13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

15 CITY Character(30) VARCHAR2(30) NOT NULL City

16 STATE Character(6) VARCHAR2(6) NOT NULL State

17 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

19 COUNTRY_NM Character(30) VARCHAR2(30) NOT NULL Country Name

20 GPAU_TERM_EMP_YN Character(1) VARCHAR2(1) NOT NULL Include Terminated Employees

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

22 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
50=Pension/Annuity

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

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

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

26 GPAU_SFSS_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if payee should be paying SFSS contributions or not.

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
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.
5	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.
6	BIRTHDATE	Date(10)	DATE	Date of Birth
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
10	GPAU_PREV_LAST_NM	Character(30)	VARCHAR2(30) NOT NULL	Previous Last Name - for Taxation Reporting
11	GPAU_PREV_FIRST_NM	Character(30)	VARCHAR2(30) NOT NULL	Previous First Name for Taxation Reporting
12	GPAU_PREV_MIDDL_NM	Character(30)	VARCHAR2(30) NOT NULL	Previous Middle Name - for Taxation Reporting
13	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
14	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
15	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
16	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
17	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
18	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
19	COUNTRY_NM	Character(30)	VARCHAR2(30) NOT NULL	Country Name
20	GPAU_TERM_EMP_YN	Character(1)	VARCHAR2(1) NOT NULL	Include Terminated Employees
21	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.
22	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 50=Pension/Annuity
23	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.
24	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.
25	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.
26	GPAU_SFSS_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if payee should be paying SFSS contributions or not.
27	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.
28	GPAU_TFN_SIGNED_DT	Date(10)	DATE	This is the date when the employee has signed the TFN Declaration Form.
29	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.