GPAU_EE_PSMRCN(SQL Table) |
Index Back |
|---|---|
Empl Payment Summ CertificateThis record holds the employee's payment summary per tax year for STP reconciliation. 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_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 |
| 6 | GPAU_SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | 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 |
| 8 | 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. |
| 9 | GPAU_CNTRCTR_YN | Character(1) | VARCHAR2(1) NOT NULL | Yes/No flag. This will identify if the payee is a contractor or not. |
| 10 | GPAU_ABN | Character(11) | VARCHAR2(11) NOT NULL | A unique number used by the ATO to identify a contractor. |
| 11 | GPAU_EE_START_DT | Date(10) | DATE | Start Date |
| 12 | GPAU_EE_END_DT | Date(10) | DATE | End Date |
| 13 | GPAU_AMENDED_IND | Character(1) | VARCHAR2(1) NOT NULL |
Amended Payment Summary Indicator
Y/N Table Edit Default Value: N |
| 14 | GPAU_PSM_TAX_WHELD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Tax Withheld - End of Year Processing |
| 15 | GPAU_PSM_GROSS_PAY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gross Pay - End of Year Processing |
| 16 | GPAU_PSM_CDEP_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | CDEP Salary and Wages - End of Year Processing |
| 17 | GPAU_PSM_OTHER_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Pay - End of Year Processing |
| 18 | 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. |
| 19 | GPAU_PSM_LUMPA | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum A Payments - End of Year Processing |
| 20 | GPAU_PSM_LUMPB | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum B Payments - End of Year Processing |
| 21 | GPAU_PSM_LUMPD | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum D Payments - End of Year Processing |
| 22 | GPAU_PSM_LUMPE | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum E Payments - End of Year Processing |
| 23 | GPAU_PSM_FBT_EARNS | Number(16,2) | DECIMAL(15,2) NOT NULL | Reportable FBT Earnings - End of Year Processing |
| 24 | GPAU_PSM_ALLOW1 | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 1 Payments - End of Year Processing |
| 25 | GPAU_PSM_ALLOW1_NM | Character(30) | VARCHAR2(30) NOT NULL | Allowance Name - End of year processing |
| 26 | GPAU_PSM_ALLOW2 | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 2 Payments - End of Year Processing |
| 27 | GPAU_PSM_ALLOW2_NM | Character(30) | VARCHAR2(30) NOT NULL | Allowance Name - End of year processing |
| 28 | GPAU_PSM_ALLOW3 | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 3 Payments - End of Year Processing |
| 29 | GPAU_PSM_ALLOW3_NM | Character(30) | VARCHAR2(30) NOT NULL | Allowance Name - End of year processing |
| 30 | GPAU_PSM_ALLOW4 | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 4 Payments - End of Year Processing |
| 31 | GPAU_PSM_ALLOW4_NM | Character(30) | VARCHAR2(30) NOT NULL | Allowance Name - End of year processing |
| 32 | GPAU_PSM_TOTALLOW | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 1 Payments - 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 01 |
| 36 | GPAU_PSM_UNION_NM1 | Character(50) | VARCHAR2(50) NOT NULL | Union Fees Name 01 |
| 37 | GPAU_PSM_TOTUNION | Number(11,2) | DECIMAL(10,2) NOT NULL | Union Fees - End of Year Processing |
| 38 | GPAU_PSS_WRK_PLC | Number(11,2) | DECIMAL(10,2) NOT NULL | Workplace Giving |
| 39 | GPAU_PSM_WRK_PL_NM | Character(50) | VARCHAR2(50) NOT NULL | Workplace Giving name |
| 40 | GPAU_PSS_WRK_PLC1 | Number(11,2) | DECIMAL(10,2) NOT NULL | Workplace Giving |
| 41 | GPAU_PSM_WHOLD_RT | Number(8,2) | DECIMAL(7,2) NOT NULL | Tax Witholding Rate for Contractors |
| 42 | GPAU_PSM_INCOM_TYP | Character(1) | VARCHAR2(1) NOT NULL |
To identify Gross Payment Type of an individual for PSM reporting
H=Working Holiday Maker P=Pensioners S=Salaried Default Value: S |
| 43 | GPAU_PSM_FBT_EXERN | Number(16,2) | DECIMAL(15,2) NOT NULL | Reportable FBT Earnings - End of Year Processing |
| 44 | 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 |
| 45 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |