SFA_ACAD_LVL_VW

(SQL View)
 Index Back

Academic Level Table

This Table defines the relationship between Academic Level and the Total Units required within a Level Status Rule and SetID.

SELECT A.SETID ,A.LEVEL_LOAD_RULE ,A.UNT_CUM_TOTAL ,A.ACADEMIC_LEVEL ,A.NSLDS_LOAN_YEAR ,A.DIR_LND_YR FROM PS_ACAD_LEVEL_TBL A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ACAD_LEVEL_TBL A2 WHERE A2.SETID = A.SETID AND A2.LEVEL_LOAD_RULE = A.LEVEL_LOAD_RULE AND A2.UNT_CUM_TOTAL = A.UNT_CUM_TOTAL AND A2.ACADEMIC_LEVEL = A.ACADEMIC_LEVEL AND A2.EFFDT <= %CurrentDateIn)

  • Parent record: LVL_LD_RULE_TBL

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

    Prompt Table: LVL_LD_RULE_TBL

    3 UNT_CUM_TOTAL Number(9,3) DECIMAL(8,3) NOT NULL Cum Units/Terms
    4 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
    5 NSLDS_LOAN_YEAR Character(1) VARCHAR2(1) NOT NULL NSLDS Loan Year
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year+
    A=1st Year Graduate
    B=2nd Year Graduate
    C=3rd Year Graduate
    D=4th or more Graduate
    G=Graduate/Professional
    6 DIR_LND_YR Character(2) VARCHAR2(2) NOT NULL Direct Lending Year
    01=First Year,never attended
    02=First Year,previously attnd
    03=Second Year
    04=Third Year
    05=Fourth Year
    06=Fifth Year+ Undergrad
    07=First Yr, Grad/Prof
    08=Second Yr, Grad/Prof
    09=Third Yr, Grad/Prof
    10=Fourth Yr+,Grad/Prof