LN_RPT_PKG_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_RPT_PKG_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, descr, descrshort from PS_LN_RPT_PKG

Related Language Record: LNRPTPKGVWLNG

# 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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

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