CAL_DEFN_TBL_VW

(SQL View)
 Index Back

Calendar Defn TBL View


SELECT SETID ,CALENDAR_ID ,DESCR ,CALENDAR_TYPE ,DETAIL_CALENDAR ,NUMBER_OF_PERIODS ,DEPR_CAL_SW ,DAILY_CALENDAR ,DESCRLONG FROM PS_CAL_DEFN_TBL

  • Related Language Record: CAL_DEFN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CALENDAR_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Calendar
    B=Budget Calendar
    D=Detail Calendar
    I=Summary Budget Period Calendar
    P=Budget Period Calendar
    S=Summary Calendar
    T=Promo Mgmt Sales Calendar
    5 DETAIL_CALENDAR Character(2) VARCHAR2(2) NOT NULL Detail Calendar

    Prompt Table: %EDITTABLE
    Set Control Field: SETID

    6 NUMBER_OF_PERIODS Number(3,0) SMALLINT NOT NULL Periods in a Year
    7 DEPR_CAL_SW Character(1) VARCHAR2(1) NOT NULL Used for depreciation

    Y/N Table Edit

    Default Value: N

    8 DAILY_CALENDAR Character(1) VARCHAR2(1) NOT NULL Daily Calendar

    Y/N Table Edit

    Default Value: N

    9 DESCRLONG Long Character CLOB Long Description