GPAU_EE_FRGNRCN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	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.
4	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
5	GPAU_SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	GPAU_PSM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Type of Payment Summary - Non-Business or Voluntary 10=PAYG Non-Business 20=PAYG Voluntary 30=PAYG Foreign
7	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.
8	GPAU_CNTRCTR_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee is a contractor or not.
9	GPAU_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
10	GPAU_EE_START_DT	Date(10)	DATE	Start Date
11	GPAU_EE_END_DT	Date(10)	DATE	End Date
12	GPAU_AMENDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Amended Payment Summary Indicator Y/N Table Edit Default Value: N
13	GPAU_PSM_TAX_WHELD	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Tax Withheld - End of Year Processing
14	GPAU_PSM_GROSS_PAY	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Gross Pay - End of Year Processing
15	GPAU_PSM_CDEP_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	CDEP Salary and Wages - End of Year Processing
16	GPAU_PSM_OTHER_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Other Pay - End of Year Processing
17	GPAU_PSM_ER_SC	Number(14,2)	DECIMAL(13,2) NOT NULL	This field is used to record the reportable employer Superannuation Contributions on Payment Summary.
18	GPAU_PSM_LUMPA	Number(11,2)	DECIMAL(10,2) NOT NULL	Lump Sum A Payments - End of Year Processing
19	GPAU_PSM_LUMPB	Number(11,2)	DECIMAL(10,2) NOT NULL	Lump Sum B Payments - End of Year Processing
20	GPAU_PSM_LUMPD	Number(11,2)	DECIMAL(10,2) NOT NULL	Lump Sum D Payments - End of Year Processing
21	GPAU_PSM_LUMPE	Number(11,2)	DECIMAL(10,2) NOT NULL	Lump Sum E Payments - End of Year Processing
22	GPAU_PSM_FBT_EARNS	Number(16,2)	DECIMAL(15,2) NOT NULL	Reportable FBT Earnings - End of Year Processing
23	GPAU_PSM_ALLOW1	Number(11,2)	DECIMAL(10,2) NOT NULL	Allowance 1 Payments - End of Year Processing
24	GPAU_PSM_ALLOW1_NM	Character(30)	VARCHAR2(30) NOT NULL	Allowance Name - End of year processing
25	GPAU_PSM_ALLOW2	Number(11,2)	DECIMAL(10,2) NOT NULL	Allowance 2 Payments - End of Year Processing
26	GPAU_PSM_ALLOW2_NM	Character(30)	VARCHAR2(30) NOT NULL	Allowance Name - End of year processing
27	GPAU_PSM_ALLOW3	Number(11,2)	DECIMAL(10,2) NOT NULL	Allowance 3 Payments - End of Year Processing
28	GPAU_PSM_ALLOW3_NM	Character(30)	VARCHAR2(30) NOT NULL	Allowance Name - End of year processing
29	GPAU_PSM_ALLOW4	Number(11,2)	DECIMAL(10,2) NOT NULL	Allowance 4 Payments - End of Year Processing
30	GPAU_PSM_ALLOW4_NM	Character(30)	VARCHAR2(30) NOT NULL	Allowance Name - End of year processing
31	GPAU_PSM_UNION	Number(11,2)	DECIMAL(10,2) NOT NULL	Union Fees - End of Year Processing
32	GPAU_PSM_UNION_NM	Character(50)	VARCHAR2(50) NOT NULL	Union Name - End of year processing
33	GPAU_PSM_UNION1	Number(11,2)	DECIMAL(10,2) NOT NULL	Union Fees 01
34	GPAU_PSM_UNION_NM1	Character(50)	VARCHAR2(50) NOT NULL	Union Fees Name 01
35	GPAU_PSS_WRK_PLC	Number(11,2)	DECIMAL(10,2) NOT NULL	Workplace Giving
36	GPAU_PSM_WRK_PL_NM	Character(50)	VARCHAR2(50) NOT NULL	Workplace Giving name
37	GPAU_PSM_WHOLD_RT	Number(8,2)	DECIMAL(7,2) NOT NULL	Tax Witholding Rate for Contractors
38	GPAU_FBT_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	This field is to capture if the employer is exempt from FBT under section 57A of the FBTAA 1986
39	GPAU_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Additional Component - End of Year Processing 00=Entered 10=Created 20=Processed 30=Issued 40=Sent to ATO
40	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp