GPAU_EE_FRGN(SQL Table) |
Index Back |
---|---|
Frgn Empl Paymt Summ CertfThis 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 |