TERM_SESSION_V2

(SQL View)
 Index Back

Term Session View

This is the search record for the Sections Combined Table panelgroup. Sections Combined IDs can only be created for Sessions that exist in the Session Table. Exclude OEE session code.

SELECT DISTINCT a.institution , b.strm , b.descrshort , a.session_code FROM ps_session_tbl a , PS_TERM_VAL_TBL b WHERE a.strm = b.strm AND A.SESSION_CODE <> 'OEE'

  • Related Language Record: TERMSESSIONV2LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2

    Prompt Table: TERM_SESSION_V2