RS_SCHED_HDAYVW

(SQL View)
 Index Back

RM Holiday Dates for Resources

All holiday dates that are available for assignable resources. SUJ--Included SYSTEM_SOURCE field

SELECT A.EMPLID , H.HOLIDAY , C.SYSTEM_SOURCE , 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 M.SYSTEM_SOURCE = C.SYSTEM_SOURCE AND M.EFFDT <= %CurrentDateIn) 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 K.EFFDT <= %CurrentDateIn) 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 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

Default Value: RS

4 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
5 HOL_TIME_START Time(15) TIMESTAMP Start Time
6 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description