GPAU_FRN_E1_TAO

(SQL Table)
 Index Back

Frgn Pymnt Summ Certificate

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

# 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 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
9 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
10 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
11 GPAU_CNTRCTR_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee is a contractor or not.
12 GPAU_ABN Character(11) VARCHAR2(11) NOT NULL A unique number used by the ATO to identify a contractor.
13 GPAU_EE_START_DT Date(10) DATE Start Date
14 GPAU_EE_END_DT Date(10) DATE End Date
15 GPAU_PSM_TAX_WHELD Signed Number(17,2) DECIMAL(15,2) NOT NULL Tax Withheld - End of Year Processing
16 GPAU_PSM_GROSS_PAY Signed Number(17,2) DECIMAL(15,2) NOT NULL Gross Pay - End of Year Processing
17 GPAU_PSM_CDEP_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL CDEP Salary and Wages - End of Year Processing
18 GPAU_PSM_OTHER_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay - End of Year Processing
19 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.
20 GPAU_PSM_LUMPA Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum A Payments - End of Year Processing
21 GPAU_PSM_LUMPB Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum B Payments - End of Year Processing
22 GPAU_PSM_LUMPD Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum D Payments - End of Year Processing
23 GPAU_PSM_LUMPE Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum E Payments - End of Year Processing
24 GPAU_PSM_FBT_EARNS Number(16,2) DECIMAL(15,2) NOT NULL Reportable FBT Earnings - End of Year Processing
25 GPAU_PSM_ALLOW1 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 1 Payments - End of Year Processing
26 GPAU_PSM_ALLOW1_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
27 GPAU_PSM_ALLOW2 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 2 Payments - End of Year Processing
28 GPAU_PSM_ALLOW2_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
29 GPAU_PSM_ALLOW3 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 3 Payments - End of Year Processing
30 GPAU_PSM_ALLOW3_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
31 GPAU_PSM_ALLOW4 Number(11,2) DECIMAL(10,2) NOT NULL Allowance 4 Payments - End of Year Processing
32 GPAU_PSM_ALLOW4_NM Character(30) VARCHAR2(30) NOT NULL Allowance Name - End of year processing
33 GPAU_PSM_UNION Number(11,2) DECIMAL(10,2) NOT NULL Union Fees - End of Year Processing
34 GPAU_PSM_UNION_NM Character(50) VARCHAR2(50) NOT NULL Union Name - End of year processing
35 GPAU_PSM_UNION1 Number(11,2) DECIMAL(10,2) NOT NULL Union Fees
36 GPAU_PSM_UNION_NM1 Character(50) VARCHAR2(50) NOT NULL Union Name
37 GPAU_PSS_WRK_PLC Number(11,2) DECIMAL(10,2) NOT NULL Workplace Giving
38 GPAU_PSM_WRK_PL_NM Character(50) VARCHAR2(50) NOT NULL Workplace Giving name
39 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr