LN_LOAN_TYPE_VW

(SQL View)
 Index Back

Loan Type Prompt Table

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 A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.LOAN_TYPE, B.DESCRSHORT FROM PS_LOAN_ORIGNATN A, PS_LN_TYPE_TBL B where A.INSTITUTION=B.INSTITUTION and A.AID_YEAR=B.AID_YEAR and A.LOAN_TYPE=B.LOAN_TYPE

  • Related Language Record: LN_LOAN_TP_VWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description