LN_RPT_PKG

(SQL Table)
 Index Back

Loan Report Output Packages

Loan Reports can be run together in packages, with a mix of both report types and output formats. Output can be to a fixed format file, a field delimited file, a file for input to Jetform, or print to a pre-printed form with pre-defined print field locations. Each package has a unique ID, and each report output spec within the package has its own ID. This table defines the report packages. The report ID members in the package are specified in table LN_RPT_LNK.

  • Related Language Record: LN_RPT_PKG_LNG

  • Parent Record Of LN_RPT_LNK LN_RPT_LNK02

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LN_RPT_PKG_ID Character(10) VARCHAR2(10) NOT NULL Report Package

    Prompt Table: LN_RPT_PKG_SRCH

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

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: FED_AID_YR_TBL

    3 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: LN_RPT_PKG.DESCR

    6 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
    7 LN_OUTPUT_DELIMTR Character(1) VARCHAR2(1) NOT NULL Field Delimiter
    A=Asterisk
    C=Comma
    8 LN_EXT_PARMS Character(50) VARCHAR2(50) NOT NULL External Package Override Parm