HGA_HOL_DESC_VW

(SQL View)
 Index Back

Holiday Dates

Holiday dates and descriptions for a holiday schedule.

SELECT DISTINCT %Sql(FUNCLIB_HR_DATE_MONTH,HOLIDAY) ,%Sql(FUNCLIB_HR_DATE_YEAR,HOLIDAY) ,HOLIDAY_SCHEDULE ,HOLIDAY ,DESCR FROM PS_HOLIDAY_DATE

  • Parent record: HOLIDAY_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    2 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year
    3 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    4 HOLIDAY Date(10) DATE NOT NULL Holiday
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description