LN_RPT_PKG_VW_3 (SQL View)	Index Back
Loan Report Packages View 3 This view is used on a prompt edit to retrieve all Package IDs for a given Aid Year and Output Type.

LN_RPT_PKG_VW_3

(SQL View)

Loan Report Packages View 3

This view is used on a prompt edit to retrieve all Package IDs for a given Aid Year and Output Type.

select aid_year, ln_out_type, ln_rpt_pkg_id from PS_LN_RPT_PKG

# 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_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

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

#	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_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
3	LN_RPT_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Report Package