STDNT_AGR_LMTVW

(SQL View)
 Index Back

Stdnt Aggr Aid/Aggr Limit Join

This view joins STDNT_AGGR_LIFE with AGGR_LIMIT_TBL and is used as a level 2 record on the Aggregate Aid inquiry page.

SELECT A.EMPLID , A.AGGREGATE_AREA , A.AID_YEAR , B.EFF_STATUS , B.DESCR , B.FIN_AID_TYPE , B.FEDERAL_ID , B.LOAN_PROGRAM , B.UNDRGRAD_LIMIT , B.GRADUATE_LIMIT , B.MAX_TERMS , B.GRAD_LIMIT_RULE , A.UNDRGRAD_TOTAL , A.GRADUATE_TOTAL , A.TOTAL_TERMS , A.SFA_NSLDS_AGGR_AMT , A.SFA_PKG_DEP_STAT , A.PAR_CREDIT_WORTHY , A.DL_HEAL_LN_SW , 0 , A.SFA_NSLDS_GRAD_AMT , A.SFA_PRCNT_USED_TOT FROM PS_STDNT_AGGR_LIFE A , PS_AGGR_LIMIT_TBL B WHERE A.AGGREGATE_AREA = B.AGGREGATE_AREA AND A.AID_YEAR = B.AID_YEAR AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_AGGR_LIMIT_TBL B1 WHERE B1.AGGREGATE_AREA=B.AGGREGATE_AREA AND B1.AID_YEAR =B.AID_YEAR)

  • Related Language Record: STDNT_AGRLMT_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 AGGREGATE_AREA Character(10) VARCHAR2(10) NOT NULL Aggregate Area
    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 FIN_AID_TYPE Character(4) VARCHAR2(4) NOT NULL Fin Aid Type
    A=Athletic
    B=Bursary
    F=Fellowship
    G=Grant
    L=Loan
    S=Scholarship
    V=Waiver
    W=Work/Study
    7 FEDERAL_ID Character(4) VARCHAR2(4) NOT NULL Federal ID
    ACG=Academic Competitiveness Grant
    FWSP=Federal Work Study Program
    GAAN=Grad Assistance in Natl Need
    GPLS=Graduate PLUS Loan
    HEAL=Health Education Assistance Ln
    HPSL=Health Profession Student Loan
    IASA=Iraq/Afghan Service Award
    JVTS=Jacob K Javits Fellowship
    LDS=Loans for Disadvantaged Stdnts
    NIH=National Institute of Health
    NSF=National Science Foundation
    NURS=Nursing Loan
    OTHR=Other Federal Fund
    PCL=Primary Care Loan
    PELL=Federal PELL Grant
    PERK=Federal Perkins Loan Program
    PLUS=Federal Stafford Loan, PLUS
    SEOG=Federal SEOG
    SMRT=National Smart Grant
    STFS=Fed Stafford Loan - Subsidized
    STFU=Fed Stafford Loan-Unsubsidized
    TCH=TEACH Grant
    8 LOAN_PROGRAM Character(1) VARCHAR2(1) NOT NULL Loan Program
    A=Alternative
    D=Direct Lending
    F=FFELP
    H=Health Professions
    P=Perkins
    S=State
    U=University
    9 UNDRGRAD_LIMIT Number(12,2) DECIMAL(11,2) NOT NULL Undergrad Lifetime
    10 GRADUATE_LIMIT Number(12,2) DECIMAL(11,2) NOT NULL Graduate Lifetime
    11 MAX_TERMS Number(2,0) SMALLINT NOT NULL Max Terms
    12 GRAD_LIMIT_RULE Character(1) VARCHAR2(1) NOT NULL Graduate Limit Rule
    C=Cumulative
    D=Distinct

    Default Value: D

    13 UNDRGRAD_TOTAL Number(12,2) DECIMAL(11,2) NOT NULL Total Undergrad
    14 GRADUATE_TOTAL Number(12,2) DECIMAL(11,2) NOT NULL Total Graduate
    15 TOTAL_TERMS Number(2,0) SMALLINT NOT NULL Total Terms
    16 SFA_NSLDS_AGGR_AMT Number(12,2) DECIMAL(11,2) NOT NULL FA-Aggregate: NSLDS Total
    17 SFA_PKG_DEP_STAT Character(1) VARCHAR2(1) NOT NULL FA-Aggregates: Dependency Status used during Award Packaging
    D=Dependent
    I=Independent
    M=Married
    S=Sole Support
    18 PAR_CREDIT_WORTHY Character(1) VARCHAR2(1) NOT NULL Parent Credit Worthiness
    I=Institutional Override

    Y/N Table Edit

    19 DL_HEAL_LN_SW Character(1) VARCHAR2(1) NOT NULL HEAL Eligible
    20 SFA_AGGR_RPT_TOL Number(9,0) DECIMAL(9) NOT NULL Discrepancy Tolerance
    21 SFA_NSLDS_GRAD_AMT Number(12,2) DECIMAL(11,2) NOT NULL FA-Aggregate: NSLDS Graduate Total
    22 SFA_PRCNT_USED_TOT Number(8,4) DECIMAL(7,4) NOT NULL Total Percent Scheduled Used