EMPLIDCAL_RUN_IDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDCAL_PRD_IDPRD_BGN_DTPRD_END_DTGPFR_ACM_PRV_VW(SQL View) |
Index Back |
|---|---|
To fetch previous accum valueTo fetch previous accumulator value. |
| SELECT A1.EMPLID , A1.CAL_RUN_ID , A1.GP_PAYGROUP , A1.CAL_ID , A1.ORIG_CAL_RUN_ID , A1.CAL_PRD_ID , A1.PRD_BGN_DT , A1.PRD_END_DT , P1.SLICE_BGN_DT , P1.SLICE_END_DT , P1.PIN_NUM , P1.CALC_RSLT_VAL , P1.CALC_VAL , P1.USER_ADJ_VAL , P1.USER_KEY1 , P1.USER_KEY2 FROM PS_GP_PYE_PRC_STAT A1 , PS_GP_PYE_SEG_STAT B1 , PS_GP_RSLT_ACUM P1 WHERE B1.CAL_RUN_ID=A1.CAL_RUN_ID AND B1.EMPLID=A1.EMPLID AND B1.EMPL_RCD=A1.EMPL_RCD AND B1.GP_PAYGROUP=A1.GP_PAYGROUP AND B1.CAL_ID=A1.CAL_ID AND B1.ORIG_CAL_RUN_ID=A1.ORIG_CAL_RUN_ID AND B1.PYE_CALC_STAT>='50' AND B1.CALC_ACTION='C' AND P1.CAL_RUN_ID=A1.CAL_RUN_ID AND P1.EMPLID=A1.EMPLID AND P1.EMPL_RCD=A1.EMPL_RCD AND P1.GP_PAYGROUP=A1.GP_PAYGROUP AND P1.CAL_ID=A1.CAL_ID AND P1.ORIG_CAL_RUN_ID=A1.ORIG_CAL_RUN_ID AND P1.RSLT_SEG_NUM=B1.RSLT_SEG_NUM AND A1.RSLT_VER_NUM=( SELECT MAX(V1.RSLT_VER_NUM) FROM PS_GP_PYE_PRC_STAT V1 WHERE V1.EMPLID=A1.EMPLID AND V1.EMPL_RCD=A1.EMPL_RCD AND V1.PRC_ORD_TS=A1.PRC_ORD_TS AND V1.COUNTRY=A1.COUNTRY ) AND A1.RSLT_REV_NUM=( SELECT MAX(W1.RSLT_REV_NUM) FROM PS_GP_PYE_PRC_STAT W1 WHERE W1.EMPLID=A1.EMPLID AND W1.EMPL_RCD=A1.EMPL_RCD AND W1.PRC_ORD_TS=A1.PRC_ORD_TS AND W1.COUNTRY=A1.COUNTRY AND W1.RSLT_VER_NUM=A1.RSLT_VER_NUM ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 4 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 6 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 7 | PRD_BGN_DT |
Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT |
Date(10) | DATE | Pay Period End Date |
| 9 | SLICE_BGN_DT | Date(10) | DATE | Element Slice Begin Date |
| 10 | SLICE_END_DT | Date(10) | DATE | Element Slice End Date |
| 11 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 12 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 13 | CALC_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Value |
| 14 | USER_ADJ_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | User Adjustment Value |
| 15 | USER_KEY1 | Character(25) | VARCHAR2(25) NOT NULL | User Key 1 |
| 16 | USER_KEY2 | Character(25) | VARCHAR2(25) NOT NULL | User Key 2 |