GPAU_STP_ETP_VW(SQL View) |
Index Back |
|---|---|
ETP XML ViewETP View created to populate ETP Collection of STP PAYEVNTEMP Xml |
| SELECT B.PROCESS_INSTANCE , A.CAL_RUN_ID , A.EMPLID_BGRP , A.GPAU_ETP_PY_TYPE , A.GPAU_STP_INC_TYPE , A.PYMT_DT , SUM(A.GPAU_STP_AMOUNT) , SUM(A.GPAU_STP_TAXABLE) , SUM(A.GPAU_STP_TAXFREE) FROM PS_GPAU_STP_TMPETP A , PS_GPAU_STP_TMPSTG B WHERE A.EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.USER_KEY1 = B.PAY_ENTITY AND A.USER_KEY2 = B.BALANCE_GRP_NUM AND A.CAL_ID = B.CAL_ID AND A.RSLT_SEG_NUM = B.RSLT_SEG_NUM AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.GPAU_ETP_PY_TYPE IN ('B','D','N','O','P','R','S','T') GROUP BY B.PROCESS_INSTANCE, A.CAL_RUN_ID, A.EMPLID_BGRP, A.GPAU_ETP_PY_TYPE, A.GPAU_STP_INC_TYPE, A.PYMT_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPLID_BGRP |
Character(14) | VARCHAR2(14) NOT NULL | Emplid |
| 4 | GPAU_ETP_PY_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
ETP Payment Type.
N=Non Transitional O=Non-Excluded ETP R=Excluded ETP T=Transitional |
| 5 | GPAU_STP_INC_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
STP Income Types
CHP=Closely Held Payees FEI=Foreign Employment IAA=Inbound Assignees to Australia LAB=Labour-Hire OSP=Other Specified Payments SAW=Salary and Wages SWP=Seasonal Worker Programme VOL=Voluntary Agreement WHM=Working Holiday Makers |
| 6 | PYMT_DT | Date(10) | DATE | Payment Date |
| 7 | GPAU_STP_AMOUNT_CH | Character(20) | VARCHAR2(20) NOT NULL | Amount of Iterative Categories - Single Touch Payroll |
| 8 | GPAU_STP_TAXABL_CH | Character(20) | VARCHAR2(20) NOT NULL | Superannuation Taxable Component - Single Touch Payroll |
| 9 | GPAU_STP_TAXFRE_CH | Character(20) | VARCHAR2(20) NOT NULL | Superannuation Tax Free Component - Single Touch Payroll |