TERM_VAL_TBL_VW

(SQL View)
Index Back

Term Value Table View

This is a view of the Term Value Table.

SELECT strm , descr , descrshort , next_class_no , SSR_SSCLS_STD_BDT , SSR_SSCLS_STD_EDT , SSR_SSCLS_INSR_BDT , SSR_SSCLS_INSR_EDT FROM PS_TERM_VAL_TBL

  • 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