CAL_DEFN_TBL

(SQL Table)
 Index Back

Calendars

Calendars Definitions from General Ledger

  • Parent Record Of CAL_BP_TBL CAL_DETP_TBL EG_CAL_DETP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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
    S=Summary Calendar
    5 DETAIL_CALENDAR Character(2) VARCHAR2(2) NOT NULL Detail Calendar
    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