PROCESS_INSTANCEEMPLIDPAY_ENTITYBALANCE_GRP_NUM10=PAYG Non-Business
20=PAYG Voluntary
30=PAYG Foreign
GPAU_PSM_E1_VW(SQL View) |
Index Back |
|---|---|
Empl Payment Summ CertificateThis record holds temp table for the employee's payment summary per tax year. The payment summary is keyed by emplid, pay enity and balance group id. |
| SELECT PROCESS_INSTANCE ,EMPLID ,PAY_ENTITY ,BALANCE_GRP_NUM ,GP_PAYGROUP ,GPAU_PSM_TYPE ,GPAU_TFN ,CAL_RUN_ID ,CAL_ID ,RSLT_SEG_NUM ,GPAU_CNTRCTR_YN ,GPAU_ABN ,GPAU_EE_START_DT ,GPAU_EE_END_DT ,GPAU_PSM_TAX_WHELD ,GPAU_PSM_GROSS_PAY ,GPAU_PSM_CDEP_PAY ,GPAU_PSM_OTHER_PAY ,GPAU_PSM_ER_SC ,GPAU_PSM_LUMPA ,GPAU_PSM_LUMPB ,GPAU_PSM_LUMPD ,GPAU_PSM_LUMPE ,GPAU_PSM_FBT_EARNS ,GPAU_PSM_ALLOW1 ,GPAU_PSM_ALLOW1_NM ,GPAU_PSM_ALLOW2 ,GPAU_PSM_ALLOW2_NM ,GPAU_PSM_ALLOW3 ,GPAU_PSM_ALLOW3_NM ,GPAU_PSM_ALLOW4 ,GPAU_PSM_ALLOW4_NM ,GPAU_PSM_UNION ,GPAU_PSM_UNION_NM ,GPAU_PSS_WRK_PLC ,GPAU_PSM_WRK_PL_NM ,EMPL_RCD FROM PS_GPAU_PSM_E1_TAO |
| # | 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(14,2) | DECIMAL(13,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_PSS_WRK_PLC | Number(11,2) | DECIMAL(10,2) NOT NULL | Workplace Giving |
| 36 | GPAU_PSM_WRK_PL_NM | Character(50) | VARCHAR2(50) NOT NULL | Workplace Giving name |
| 37 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |