AGGR_LVL_XREF

(SQL Table)
 Index Back

Aggregate Level X-Ref

Aggr Level X-Ref Vw shows the NSLDS Loan Year and flag to indicate the Graduate Level.

  • Related Language Record: AGGR_LVLXREFLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGGREGATE_LEVEL Character(2) VARCHAR2(2) NOT NULL Aggregate Level
    2 GRADUATE_LVL_IND Character(1) VARCHAR2(1) NOT NULL Graduate Level

    Y/N Table Edit

    3 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: AGGR_LVL_XREF.DESCR

    6 SFA_ASG_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year
    6=Grad/Professional - 1st Year
    7=Grad/Professional - Continuing