WM_BUS_CAL_VW

(SQL View)
 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

SELECT A.BUSINESS_UNIT , B.HOLIDAY_LIST_ID , B.DESCR , B.MON , B.MON_HRS , B.TUES , B.TUES_HRS , B.WED , B.WED_HRS , B.THURS , B.THURS_HRS , B.FRI , B.FRI_HRS , B.SAT , B.SAT_HRS , B.SUN , B.SUN_HRS FROM PS_BUS_UNIT_TBL_WM A , PS_BUS_CAL_HOL_DFN B WHERE A.HOLIDAY_LIST_ID = B.HOLIDAY_LIST_ID

  • Related Language Record: WM_BUCAL_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 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

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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