LN_TYPE_VW_RPT

(SQL View)
 Index Back

Loan Type View for Rpt Package

Used on a Prompt Edit to retrieve all Loan Type Codes for a given Aid Year

SELECT DISTINCT AID_YEAR , LOAN_TYPE , DESCR FROM PS_LN_TYPE_TBL GROUP BY AID_YEAR , LOAN_TYPE , DESCR

  • Related Language Record: LNTYPEVWRPTLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    2 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description