LN_RPT_LNK02(SQL Table) |
Index Back |
|---|---|
Loan Package Documents 2001-02Specifies the Loan Documents/PNotes that belong to a given package. This table is a child of 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_DCMNT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Indicates the type of document to be produced for the given Loan Type.
C=Cover Letter H=Health Professional PNote I=Total Indebtedness K=Perkins PNote M=Master PNote P=Promissory Note T=Truth-in-Lending U=University Loan PNote |
| 6 | LN_RPT_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Loan Report Form ID
Prompt Table: LN_RPT_ITEM_VW |
| 7 | TABLE_ID | Character(1) | VARCHAR2(1) NOT NULL | Child Table Key |
| 8 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 9 | LOAN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Loan Type Cd
Prompt Table: LN_TYPE_VW_RPT |