GP_RPT_CAL_RUNEMPLIDCAL_RUN_IDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDHGA_RTRCAL_VW(SQL View) |
Index Back |
|---|---|
Retro calendars viewView for Retro calendars used in Absence Analytics Preprocessing |
| SELECT DISTINCT B.CAL_RUN_ID , A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_VER_NUM , A.RSLT_REV_NUM , A.PRC_ORD_TS FROM PS_GP_PYE_PRC_STAT A , PS_HGA_RSLTACM_TMP B WHERE B.ORIG_CAL_RUN_ID <> B.CAL_RUN_ID AND A.EMPLID= B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.RSLT_VER_NUM = ( SELECT MAX(A1.RSLT_VER_NUM) FROM PS_GP_PYE_PRC_STAT A1 WHERE A.EMPLID= A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD AND A.GP_PAYGROUP = A1.GP_PAYGROUP AND A.CAL_ID = A1.CAL_ID) AND A.RSLT_REV_NUM = ( SELECT MAX(A1.RSLT_REV_NUM) FROM PS_GP_PYE_PRC_STAT A1 WHERE A.EMPLID= A1.EMPLID AND A.EMPL_RCD = A1.EMPL_RCD AND A.GP_PAYGROUP = A1.GP_PAYGROUP AND A.CAL_ID = A1.CAL_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_RPT_CAL_RUN |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 8 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 9 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 10 | PRC_ORD_TS | DateTime(26) | TIMESTAMP | Process Order Timestamp |