RUN_CNTL_CPYDEF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | LN_RPT_FORM_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Loan Report Form ID
Prompt Table: LN_RPT_SRCH_VW |
| 4 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: LN_RPT_SRCH_VW.AID_YEAR Prompt Table: LN_RPT_ITEM |
| 5 | 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 Default Value: LN_RPT_ITEM.LN_OUT_TYPE |
| 6 | NEW_LN_RPT_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL | New Loan Report Form ID |
| 7 | NEW_AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
New Aid Year
Prompt Table: FED_AID_YR_TBL |
| 8 | NEW_LN_OUT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
New Loan Output Type
D=Delimited E=External F=Fixed format record P=Positional on pre-printed form |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Description
Default Value: LN_RPT_SRCH_VW.DESCR |
| 10 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: LN_RPT_SRCH_VW.DESCR |