LN_RPT_ITEM

(SQL Table)
 Index Back

Loan Report Output specs

This table contains the specific report output format ID, and the values for the specific output type, and the output file names and delimiter spec as required. It links back up to parent table LN_RPT_LNK, and down to the report column specs in table LN_RPT_COL.

  • Related Language Record: LN_RPT_ITEM_LNG

  • Parent Record Of LN_RPT_COL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LN_RPT_FORM_ID Character(10) VARCHAR2(10) NOT NULL Loan Report Form ID

    Prompt Table: LN_RPT_SRCH_VW

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

    Prompt Table: FED_AID_YR_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LN_RPT_ITEM.DESCR

    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 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code

    Prompt Table: SCC_CKLSITM_TBL

    7 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Default Value: LOAN

    Prompt Table: ADM_FUNCTN_TBL

    8 NBR_DOCS_TOPRINT Number(1,0) SMALLINT NOT NULL Nbr Copies to Print

    Default Value: 1

    9 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