SSR_NSC_TERM

(SQL Table)
 Index Back

NSC Term Setup Table

NSC Term Setup Table

  • Parent record: INSTITUTION_TBL

    • # 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

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 TERM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Term Category
    0=Full Year
    1=1st Semester
    2=2nd Semester
    3=Summer Session AUS
    4=Winter Session AUS
    C=Medical Clinical
    I=Intersession Term
    M=Medical Level 1
    R=Regular Term
    S=Summer Term
    W=Winter Term
    4 SSR_NSC_TERM_SKIP Character(1) VARCHAR2(1) NOT NULL NSC - Identify if term category should be skipped.

    Y/N Table Edit

    Default Value: Y