GP_PI_SRCH_VW1(SQL View) |
Index Back |
|---|---|
GP Positive input Search ViewGP Positive input Search View for Segstats. |
| SELECT OTHP.EMPLID , OTHP.EMPL_RCD , OTHP.CAL_RUN_ID , OTHP.GP_PAYGROUP , OTHP.CAL_ID , OTHP.RSLT_VER_NUM , OTHP.RSLT_REV_NUM , OTHP.GP_CALC_TS , OTHP.ORIG_CAL_RUN_ID , OTHP.RSLT_SEG_NUM ,OTHP.PYE_CALC_STAT FROM PS_GP_PYE_SEG_STAT OTHP WHERE OTHP.RSLT_VER_NUM =( SELECT MAX(VER.RSLT_VER_NUM) FROM PS_GP_PYE_SEG_STAT VER WHERE VER.EMPLID=OTHP.EMPLID AND VER.EMPL_RCD=OTHP.EMPL_RCD AND VER.CAL_ID=OTHP.CAL_ID AND VER.GP_PAYGROUP=OTHP.GP_PAYGROUP ) AND OTHP.RSLT_REV_NUM = ( SELECT MAX(REV.RSLT_REV_NUM) FROM PS_GP_PYE_SEG_STAT REV WHERE REV.EMPLID=OTHP.EMPLID AND REV.EMPL_RCD=OTHP.EMPL_RCD AND REV.CAL_ID=OTHP.CAL_ID AND REV.GP_PAYGROUP=OTHP.GP_PAYGROUP AND REV.RSLT_VER_NUM=OTHP.RSLT_VER_NUM ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 5 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 6 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 7 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 8 | GP_CALC_TS | DateTime(26) | TIMESTAMP | Indicates when something (a segment) was calculated |
| 9 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 10 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 11 | PYE_CALC_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Status: field indicates the processing status of a segment (payment)
00=Identified 02=Calculation Error 03=Calculation Error - Bypassed 04=Calculation Error - By Rule 11=No Segment Created 50=Calculation Successful 55=Frozen For Further Calc 70=Finalized 75=Finalized - With Banking |