LN_DCMNT_VIEW

(SQL View)
 Index Back

Loan Promissory Note View

Select against LN_PNOTE_TBL

select institution, aid_year, loan_type, ln_rpt_form_id, ln_dcmnt_type from PS_LN_PNOTE_TBL where ln_dcmnt_type = 'M' or ln_dcmnt_type ='P'

  • Parent record: LN_TYPE_TBL

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    4 LN_RPT_FORM_ID Character(10) VARCHAR2(10) NOT NULL Loan Report Form ID

    Prompt Table: LN_TYPE_DOC_VW

    5 LN_DCMNT_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates the type of document to be produced for the given Loan Type.
    C=Cover Letter
    H=Health Professional PNote
    I=Total Indebtedness
    K=Perkins PNote
    M=Master PNote
    P=Promissory Note
    T=Truth-in-Lending
    U=University Loan PNote

    Default Value: LN_TYPE_DOC_VW.LN_DCMNT_TYPE