LN_TYPE_DOC_VW

(SQL View)
 Index Back

Loan Report Output specs

Prompt view to link a Loan Type with it's associated documents.

Select DISTINCT A. AID_YEAR, A.LN_RPT_FORM_ID, B.DESCR, B.LN_DCMNT_TYPE, B.LN_OUT_TYPE, B.NBR_DOCS_TOPRINT FROM PS_LN_RPT_LNK A, PS_LN_RPT_ITEM B WHERE A.AID_YEAR = B.AID_YEAR AND A.LN_RPT_FORM_ID = B.LN_RPT_FORM_ID AND B.LN_DCMNT_TYPE IN ('T','P', 'M')

  • Related Language Record: LNTYPEDOCVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: FED_AID_YR_TBL

    2 LN_RPT_FORM_ID Character(10) VARCHAR2(10) NOT NULL Loan Report Form ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 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
    5 LN_OUT_TYPE Character(1) VARCHAR2(1) NOT NULL This is the spec for the output type generated for this report. It can be a file with a delimiter between column values, a fixed format file, a file for input to Jetform, or print to a pre-printed form with exact location formatting.
    D=Delimited Fields
    E=External Product
    F=Fixed Length
    P=Positional Print
    6 NBR_DOCS_TOPRINT Number(1,0) SMALLINT NOT NULL Nbr Copies to Print