AID_YEARLN_OUT_TYPED=Delimited Fields
E=External Product
F=Fixed Length
P=Positional Print
LN_RPT_FORM_IDLN_RPT_ITEM_VW(SQL View) |
Index Back |
|---|---|
Loan Report Output specsThis 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.AID_YEAR, A.LN_OUT_TYPE, A.LN_RPT_FORM_ID, A.DESCR, A.CHKLST_ITEM_CD from PS_LN_RPT_ITEM A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 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_FORM_ID |
Character(10) | VARCHAR2(10) NOT NULL | Loan Report Form ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CHKLST_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |