TERM_VAL_TBL

(SQL Table)
Index Back

Term Value Table

The term value table contains data that relates to an institutions quarter/semester definitions regardless of academic unit.

  • Related Language Record: TERM_VAL_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TERM_VAL_TBL.DESCR

    4 NEXT_CLASS_NO Number(5,0) INTEGER NOT NULL Next Class Nbr

    Default Value: 1001

    5 SSR_SSCLS_STD_BDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date
    6 SSR_SSCLS_STD_EDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date
    7 SSR_SSCLS_INSR_BDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date
    8 SSR_SSCLS_INSR_EDT Date(10) DATE NOT NULL Show term in Self Service Planner begin date