LN_RPT_FORM_IDAID_YEARSEQUENCE_NBR_6Default Value: 1
Prompt Table: %EDITTABLE
Prompt Table: LN_TBL_VW
Default Value: LN_RPT_COL.FIELDNAME
Default Value: ^FIELD
Default Value: 1
Default Value: 1
LN_RPT_COL(SQL Table) |
Index Back |
|---|---|
Loan Report output columnsThis table specifies the table and column names containing the values to be retrieved for the report. It also has output specifications depending on the particular output format specified in the parent table LN_RPT_ITEM. |
| # | 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 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 3 | SEQUENCE_NBR_6 |
Number(6,0) | INTEGER NOT NULL | Sequence |
| 4 | OUT_SEQ | Number(3,0) | SMALLINT NOT NULL |
Ln Output Seq
Default Value: 1 |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: %EDITTABLE |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: LN_TBL_VW |
| 7 | TARGET_COLUMN | Character(30) | VARCHAR2(30) NOT NULL |
Output Target Col
Default Value: LN_RPT_COL.FIELDNAME |
| 8 | FLD_OUTPUT_TAG | Character(12) | VARCHAR2(12) NOT NULL |
Field Output Tag
Default Value: ^FIELD |
| 9 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL |
Page #
Default Value: 1 |
| 10 | LINE_NUM | Number(2,0) | SMALLINT NOT NULL | Line # |
| 11 | START_POS | Number(4,0) | SMALLINT NOT NULL | Start Position |
| 12 | END_POS | Number(4,0) | SMALLINT NOT NULL | End Postion |
| 13 | LN_COL_OCCURS | Number(1,0) | SMALLINT NOT NULL |
Loan Rpt Column Occurs
Default Value: 1 |