GPAU_EE_PSM_RPT(SQL Table) |
Index Back |
|---|---|
Payment Summary Data for SSPayment Summary Data for SS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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_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 |
| 7 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 8 | GPAU_EE_START_DT | Date(10) | DATE | Start Date |
| 9 | GPAU_EE_END_DT | Date(10) | DATE | End Date |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 12 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 13 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 14 | NAME_FORMAL_TXT | Character(100) | VARCHAR2(100) NOT NULL | used to show the rules for NAME_FORMAL format |
| 15 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 16 | 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. |
| 17 | GPAU_REGISTERED_NM | Character(200) | VARCHAR2(200) NOT NULL | This is the pay entity's registered name (company registered name). |
| 18 | GPAU_ABN | Character(11) | VARCHAR2(11) NOT NULL | A unique number used by the ATO to identify a contractor. |
| 19 | GPAU_ABN_BRANCH | Number(3,0) | SMALLINT NOT NULL | ABN Branch is issued by the ATO to payers that wush to sub-divide their activities. Valid values iare 001 - 999. Default value is 001. |
| 20 | GPAU_SIGNATORY | Character(40) | VARCHAR2(40) NOT NULL | This is the pay entity's signatory that will be on the payee's payment summary. |
| 21 | GPAU_PSM_TAX_WHELD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Tax Withheld - End of Year Processing |
| 22 | GPAU_PSM_GROSS_PAY | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Gross Pay - End of Year Processing |
| 23 | GPAU_PSM_CDEP_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | CDEP Salary and Wages - End of Year Processing |
| 24 | GPAU_PSM_OTHER_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Pay - End of Year Processing |
| 25 | 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. |
| 26 | GPAU_PSM_LUMPA | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum A Payments - End of Year Processing |
| 27 | GPAU_PSM_LUMPB | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum B Payments - End of Year Processing |
| 28 | GPAU_PSM_LUMPD | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum D Payments - End of Year Processing |
| 29 | GPAU_PSM_LUMPE | Number(11,2) | DECIMAL(10,2) NOT NULL | Lump Sum E Payments - End of Year Processing |
| 30 | GPAU_PSM_FBT_EARNS | Number(16,2) | DECIMAL(15,2) NOT NULL | Reportable FBT Earnings - End of Year Processing |
| 31 | GPAU_PSM_ALLOW1 | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 1 Payments - End of Year Processing |
| 32 | GPAU_PSM_ALLOW1_NM | Character(30) | VARCHAR2(30) NOT NULL | Allowance Name - End of year processing |
| 33 | GPAU_PSM_ALLOW2 | Number(11,2) | DECIMAL(10,2) NOT NULL | Allowance 2 Payments - End of Year Processing |
| 34 | GPAU_PSM_ALLOW2_NM | Character(30) | VARCHAR2(30) NOT NULL | Allowance Name - End of year processing |
| 35 | GPAU_PSM_UNION | Number(11,2) | DECIMAL(10,2) NOT NULL | Union Fees - End of Year Processing |
| 36 | GPAU_PSM_UNION_NM | Character(50) | VARCHAR2(50) NOT NULL | Union Name - End of year processing |
| 37 | GPAU_PSM_UNION1 | Number(11,2) | DECIMAL(10,2) NOT NULL | Union Fees 01 |
| 38 | GPAU_PSM_UNION_NM1 | Character(50) | VARCHAR2(50) NOT NULL | Union Fees Name 01 |
| 39 | GPAU_AMENDED_IND | Character(1) | VARCHAR2(1) NOT NULL | Amended Payment Summary Indicator |
| 40 | GPAU_PSS_WRK_PLC | Number(11,2) | DECIMAL(10,2) NOT NULL | Workplace Giving |
| 41 | GPAU_PSM_WRK_PL_NM | Character(50) | VARCHAR2(50) NOT NULL | Workplace Giving name |
| 42 | GPAU_PSM_WHOLD_RT | Number(8,2) | DECIMAL(7,2) NOT NULL | Tax Witholding Rate for Contractors |
| 43 | 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 |
| 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 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 46 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 47 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 48 | GPAU_FRGN_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Foreign Employment Type |
| 49 | GPAU_GROSS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Gross Income Type |
| 50 | GPAU_PSM_EMPL_SW | Character(1) | VARCHAR2(1) NOT NULL | Part of Year End Processing. To determine if the Employee requires optional notice on the back of the Payment Summary. |
| 51 | ACTION_DATE | Date(10) | DATE | Date of action |
| 52 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 53 | END_DATE | Date(10) | DATE | End Date |
| 54 | GPAU_PSM_FBT_EXERN | Number(16,2) | DECIMAL(15,2) NOT NULL | Reportable FBT Earnings - End of Year Processing |
| 55 | HCSC_SS_RPT_DT | Date(10) | DATE | Self Service Report Last Seen Date |
| 56 | HCSC_ALERT_DT | Date(10) | DATE | Push Notification Alert Sent Date |
| 57 | HCSC_REPORT_DT | Date(10) | DATE | Self Service Report Availability Date |
| 58 | RAWXML | Long Character | CLOB | Raw XML |