RS_SCHED_HDY2VW

(SQL View)
 Index Back

RM Holiday Dates for Resources

All holiday dates that are available for assignable resources.

SELECT A.EMPLID , H.HOLIDAY , H.HOLIDAY_SCHEDULE , H.HOL_TIME_START , H.HOLIDAY_HRS , H.DESCR FROM %Table(JOB) J , %Table(RS_WRKR_EFFDT) C , %Table(RS_WORKER_TBL) A , %Table(HOLIDAY_DATE) H WHERE A.EMPLID = C.EMPLID AND C.EFFDT = ( SELECT MAX(M.EFFDT) FROM %Table(RS_WRKR_EFFDT) M WHERE M.EMPLID = A.EMPLID) AND C.EMPLID = J.EMPLID AND C.EMPL_RCD = J.EMPL_RCD AND J.EFFDT = ( SELECT MAX(K.EFFDT) FROM %Table(JOB) K WHERE J.EMPLID = K.EMPLID AND J.EMPL_RCD = K.EMPL_RCD AND K.EMPL_STATUS = 'A') AND J.EFFSEQ = ( SELECT MAX(I.EFFSEQ) FROM %Table(JOB) I WHERE J.EMPLID = I.EMPLID AND J.EMPL_RCD = I.EMPL_RCD AND J.EFFDT = I.EFFDT AND I.EMPL_STATUS = 'A' ) AND J.EMPL_STATUS = 'A' AND J.HOLIDAY_SCHEDULE = H.HOLIDAY_SCHEDULE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 HOLIDAY Date(10) DATE NOT NULL Holiday
3 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
4 HOL_TIME_START Time(15) TIMESTAMP Start Time
5 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description