AGGR_LN_TYPE_VW

(SQL View)
 Index Back

Aggregate Loan Type Vw

Record used to define Loan Types, by Aid Year. Criteria include, but are not limited to, Loan Program, Category, Interest Rate, number of Promissory Notes.

Select LOAN_TYPE, DESCR, LOAN_PROGRAM from PS_LN_TYPE_TBL

  • Related Language Record: LN_TYPE_LANG_VW

  • Parent record: AID_YEAR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 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