LN_RPT_LNK (SQL Table)	Index Back
Loan rpt outpt package members This table is linked from the parent LN_RPT_PKG. This specifies the report output ID members of the package.

LN_RPT_LNK

(SQL Table)

Loan rpt outpt package members

This table is linked from the parent LN_RPT_PKG. This specifies the report output ID members of the package.

Parent record: 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

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 LN_RPT_PKG_SEQ Number(3,0) SMALLINT NOT NULL Loan Rpt Pkg Seq
Default Value: 1

5 LN_RPT_FORM_ID Character(10) VARCHAR2(10) NOT NULL Loan Report Form ID
Prompt Table: LN_RPT_ITEM_VW

6 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key

#	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
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	LN_RPT_PKG_SEQ	Number(3,0)	SMALLINT NOT NULL	Loan Rpt Pkg Seq Default Value: 1
5	LN_RPT_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Loan Report Form ID Prompt Table: LN_RPT_ITEM_VW
6	TABLE_ID	Character(1)	VARCHAR2(1) NOT NULL	Child Table Key