GPAU_FRN_EL_TAO

(SQL Table)
 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.

# 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_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
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 BIRTHDATE Date(10) DATE Date of Birth
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
11 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
18 COUNTRY_NM Character(30) VARCHAR2(30) NOT NULL Country Name
19 GPAU_CNTRCTR_YN Character(1) VARCHAR2(1) NOT NULL Yes/No flag. This will identify if the payee is a contractor or not.

Y/N Table Edit

Default Value: N

20 GPAU_ABN Character(11) VARCHAR2(11) NOT NULL A unique number used by the ATO to identify a contractor.
21 GPAU_EE_START_DT Date(10) DATE Start Date
22 GPAU_EE_END_DT Date(10) DATE End Date
23 GPAU_AMENDED_IND Character(1) VARCHAR2(1) NOT NULL Amended Payment Summary Indicator
24 GPAU_PSM_TAX_WHELD Signed Number(17,2) DECIMAL(15,2) NOT NULL Tax Withheld - End of Year Processing
25 GPAU_PSM_GROSS_PAY Signed Number(17,2) DECIMAL(15,2) NOT NULL Gross Pay - End of Year Processing
26 GPAU_GROSS_TYPE Character(1) VARCHAR2(1) NOT NULL Gross Income Type
27 GPAU_PSM_CDEP_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL CDEP Salary and Wages - End of Year Processing
28 GPAU_PSM_OTHER_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay - End of Year Processing
29 GPAU_PSM_LUMPA Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum A Payments - End of Year Processing
30 GPAU_PSM_LUMPB Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum B Payments - End of Year Processing
31 GPAU_PSM_LUMPD Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum D Payments - End of Year Processing
32 GPAU_PSM_LUMPE Number(11,2) DECIMAL(10,2) NOT NULL Lump Sum E Payments - End of Year Processing
33 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.
34 GPAU_PSS_WRK_PLC Number(11,2) DECIMAL(10,2) NOT NULL Workplace Giving
35 GPAU_PSM_ALLOW_TOT Signed Number(15,2) DECIMAL(13,2) NOT NULL Total of all Allownaces - Payment Summary
36 GPAU_PSM_FBT_EARNS Number(16,2) DECIMAL(15,2) NOT NULL Reportable FBT Earnings - End of Year Processing
37 GPAU_PSM_UNION Number(11,2) DECIMAL(10,2) NOT NULL Union Fees - End of Year Processing
38 GPAU_PSM_WHOLD_RT Number(8,2) DECIMAL(7,2) NOT NULL Tax Witholding Rate for Contractors
39 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
40 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