EMPLIDEMPL_RCDHOLIDAY_SCHEDULESCH_HOLIDAY_VW(SQL View) |
Index Back |
|---|
| SELECT J.EMPLID , J.EMPL_RCD , H.HOLIDAY_SCHEDULE , S.HOLIDAY , S.DESCR FROM PS_JOB J , PS_HOLIDAY_TBL H , PS_HOLIDAY_DATE S WHERE J.HOLIDAY_SCHEDULE = H.HOLIDAY_SCHEDULE AND H.HOLIDAY_SCHEDULE = S.HOLIDAY_SCHEDULE AND J.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_JOB C WHERE C.EMPLID = J.EMPLID AND C.EMPL_RCD = J.EMPL_RCD AND C.EFFDT = J.EFFDT) AND J.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JOB B WHERE B.EMPLID = J.EMPLID AND B.EMPL_RCD = J.EMPL_RCD AND B.EFFDT <= %CurrentDateIn ) |
| # | 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 | HOLIDAY_SCHEDULE |
Character(6) | VARCHAR2(6) NOT NULL | Holiday Schedule |
| 4 | HOLIDAY | Date(10) | DATE | Holiday |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |