LVL_LD_RULE_TBL

(SQL Table)
 Index Back

Academic Level/Load Rule Table

Level Status Rule determines which set of Academic Level and Load rules apply to a given Academic Program.

  • Related Language Record: LVL_LD_RULE_LNG

  • Parent Record Of ACAD_LEVEL_TBL ACAD_LOAD2_TBL ACAD_LOAD_TBL ACAD_LOAD_TBLVW FA_LOAD_VW SFA_ACAD_LVL_VW SFA_GRNTACLVLVW SSR_ACADLOD_AUS SSR_LVLLOAD_AUS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID_CAREER

    Prompt Table: SETID_TBL

    2 LEVEL_LOAD_RULE Character(5) VARCHAR2(5) NOT NULL Academic Level Rule
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LVL_LD_RULE_TBL.DESCR

    7 LEVEL_DETERMINER Character(2) VARCHAR2(2) NOT NULL Level Determination
    D=Default
    M=Manually Input
    T=Term Progression
    U=Base On Units

    Default Value: U

    8 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
    00=Not Set
    01=First Year
    02=Second Year
    03=Third Year
    04=Fourth Year
    05=Fifth Year
    06=Sixth Year
    10=Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GR=Graduate
    GRA=Graduate AUS
    HON=Honours
    IE=Industrial Experience
    MAS=Masters
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PHD=PhD
    9 LOAD_DETERMINER Character(2) VARCHAR2(2) NOT NULL Load Determination
    D=Default
    L=Units By Level
    M=Manually Input
    U=Base On Units

    Default Value: U

    10 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time
    11 ACAD_LVL_FIRST_FR Character(3) VARCHAR2(3) NOT NULL Academic Level

    Prompt Table: XLAT_SA_VW

    12 ACAD_LEVEL_IPEDS Character(3) VARCHAR2(3) NOT NULL IPEDS Academic Level
    00=Not Set
    10=Freshman
    1F=First Time Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GF=First Time Graduate
    GR=Graduate
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PF=First Time Professional