CAL_RUN_IDEMPLIDEMPL_RCDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMFICT_CAL_IDFICT_CAL_RUN_IDFICT_RSLT_SEG_NUMGP_AUDIT_SEG_VW(SQL View) |
Index Back |
|---|---|
Payee Resolution Segment ViewPayee Resolution Segment View |
| SELECT DISTINCT A.CAL_RUN_ID , A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , B.RSLT_SEG_NUM , A.FICT_CAL_ID , A.FICT_CAL_RUN_ID , A.FICT_RSLT_SEG_NUM , B.RSLT_VER_NUM , B.RSLT_REV_NUM , B.SEG_BGN_DT , B.SEG_END_DT FROM PS_GP_AUDIT_TBL A , PS_GP_PYE_SEG_STAT B WHERE A.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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 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 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 7 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 8 | FICT_CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | Ficitious Cal ID |
| 9 | FICT_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Group ID of Fictitious Calculation; used when data for both Present and Fictitious Calc are present |
| 10 | FICT_RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Fictitious Segment Number |
| 11 | RSLT_VER_NUM | Number(4,0) | SMALLINT NOT NULL | Result Version Number |
| 12 | RSLT_REV_NUM | Number(4,0) | SMALLINT NOT NULL | Result Revision Number |
| 13 | SEG_BGN_DT | Date(10) | DATE | Payee Process Segment's Begin Date |
| 14 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |