LN_PKG_ADD_VW (SQL View)	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.

LN_PKG_ADD_VW

(SQL View)

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.

Select LN_RPT_PKG_ID, AID_YEAR, LN_OUT_TYPE from PS_LN_RPT_PKG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LN_RPT_PKG_ID Character(10) VARCHAR2(10) NOT NULL Report Package

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