BUS_CAL_HOL_DFN

(SQL Table)
 Index Back

Business Calendar

This calendar is used by a few of the Financials packages. The ones I know of are Treasury, GL and AP

  • Related Language Record: BUS_CAL_HOL_LNG

  • Parent Record Of BUSCALHOL_TAO BUS_CAL_HOLIDAY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.

    Prompt Table: BUS_CAL_HOL_VW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 MON Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: Y

    4 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday
    5 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: Y

    6 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday
    7 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: Y

    8 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday
    9 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: Y

    10 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday
    11 FRI Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: Y

    12 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday
    13 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: N

    14 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday
    15 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: N

    16 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday