HOLIDAY_DATE

(SQL Table)
 Index Back

Holiday Dates

Holiday dates and descriptions for a holiday schedule.

  • Related Language Record: HOLIDAY_DTE_LNG

  • Parent record: HOLIDAY_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    2 HOLIDAY Date(10) DATE NOT NULL Holiday
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 HOLIDAY_HRS Number(5,2) DECIMAL(4,2) NOT NULL Holiday Hours
    5 HOLIDAY_TYPE Character(4) VARCHAR2(4) NOT NULL Holiday Type
    BRG=Bridge Day
    CAN=Canadian Statutory Holiday
    HALF=1/2 Day Holiday
    HIGH=High Holiday
    HKGS=Hong Kong Statutory Holiday
    LOW=Low Holiday
    STD=Standard
    USA=U.S. Statutory Holiday
    VERY=Very High

    Default Value: STD

    6 HOL_TIME_START Time(15) TIMESTAMP Start Time
    7 HOL_TIME_END Time(15) TIMESTAMP Time End