EMPLIDEMPL_RCDCAL_RUN_IDGPGB_CO_VW(SQL View) |
Index Back |
|---|---|
GPGB_CO_VWCourt order view created for Retrieving Employee records 0 and 1 |
| SELECT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.CAL_ID , A.PRD_BGN_DT , A.PRD_END_DT FROM PS_GP_PYE_PRC_STAT A WHERE A.EMPL_RCD= ( SELECT MAX(EMPL_RCD) FROM PS_JOB B WHERE B.EMPLID = A.EMPLID AND B.PAY_SYSTEM_FLG='GP' AND B.EFFDT= ( SELECT MAX (C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = B.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND C.EFFDT <= A.PRD_END_DT) AND B.EMPL_STATUS='A') GROUP BY A.EMPLID, A.EMPL_RCD, A.CAL_RUN_ID, A.CAL_ID, A.PRD_BGN_DT, A.PRD_END_DT |
| # | 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 Rcd Nbr |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 6 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |