GPAU_EE_FRGN

(SQL Table)
Index Back

Frgn Empl Paymt Summ Certf

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

# 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_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
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_CNTRCTR_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee is a contractor or not.
8 GPAU_ABN Character(11) VARCHAR2(11) NOT NULL A unique number used by the ATO to identify a contractor.
9 GPAU_EE_START_DT Date(10) DATE Start Date
10 GPAU_EE_END_DT Date(10) DATE End Date
11 GPAU_AMENDED_IND Character(1) VARCHAR2(1) NOT NULL Amended Payment Summary Indicator

Y/N Table Edit

Default Value: N

12 GPAU_PSM_TAX_WHELD Signed Number(17,2) DECIMAL(15,2) NOT NULL Tax Withheld - End of Year Processing
13 GPAU_PSM_GROSS_PAY Signed Number(17,2) DECIMAL(15,2) NOT NULL Gross Pay - End of Year Processing
14 GPAU_PSM_CDEP_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL CDEP Salary and Wages - End of Year Processing
15 GPAU_PSM_OTHER_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay - End of Year Processing
16 GPAU_PSM_ER_SC Number(11,2) DECIMAL(10,2) NOT NULL This field is used to record the reportable employer superannuation contributions on Payment Summary.
17 GPAU_PSM_LUMPA Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum A Payments - End of Year Processing
18 GPAU_PSM_LUMPB Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum B Payments - End of Year Processing
19 GPAU_PSM_LUMPD Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum D Payments - End of Year Processing
20 GPAU_PSM_LUMPE Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum E Payments - End of Year Processing
21 GPAU_PSM_FBT_EARNS Number(16,2) DECIMAL(15,2) NOT NULL Reportable FBT Earnings - End of Year Processing
22 GPAU_PSM_ALLOW1 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 1 Payments - End of Year Processing
23 GPAU_PSM_ALLOW1_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
24 GPAU_PSM_ALLOW2 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 2 Payments - End of Year Processing
25 GPAU_PSM_ALLOW2_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
26 GPAU_PSM_ALLOW3 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 3 Payments - End of Year Processing
27 GPAU_PSM_ALLOW3_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
28 GPAU_PSM_ALLOW4 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 4 Payments - End of Year Processing
29 GPAU_PSM_ALLOW4_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
30 GPAU_PSM_UNION Number(11,2) DECIMAL(10,2) NOT NULL Union Fees - End of Year Processing
31 GPAU_PSM_UNION_NM Character(50) VARCHAR2(50) NOT NULL Union Name - End of year processing
32 GPAU_PSM_UNION1 Number(11,2) DECIMAL(10,2) NOT NULL Union Fees
33 GPAU_PSM_UNION_NM1 Character(50) VARCHAR2(50) NOT NULL Union Name
34 GPAU_PSS_WRK_PLC Number(11,2) DECIMAL(10,2) NOT NULL Workplace Giving
35 GPAU_PSM_WRK_PL_NM Character(50) VARCHAR2(50) NOT NULL Workplace Giving name
36 GPAU_PSM_WHOLD_RT Number(8,2) DECIMAL(7,2) NOT NULL Tax Witholding Rate for Contractors
37 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
38 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp