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

LN_RPT_SRCH_VW

(SQL View)

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.

Select A.LN_RPT_FORM_ID, A.DESCR, A.AID_YEAR, A.LN_OUT_TYPE from PS_LN_RPT_ITEM A

Related Language Record: LNRPTSRCHVWLNG

# 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

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

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

4 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

#	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
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
4	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