RUNCTL_FATIVRTN(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). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 5 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 6 | ACTIVE_SWITCH | Character(1) | VARCHAR2(1) NOT NULL |
Active Switch
Y/N Table Edit Default Value: Y |
| 7 | RTN_TIV_CAR_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Proc Selected Careers
Y/N Table Edit |
| 8 | RTN_TIV_GEN_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Generate Withdrawal Worksheet
Y/N Table Edit |
| 9 | RTN_TIV_DTL | Character(1) | VARCHAR2(1) NOT NULL |
Detailed Report
Y/N Table Edit |
| 10 | RTN_TIV_PROC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Report Structured By
D=By Date N=By Name R=Date Range/Name Default Value: D |
| 11 | RTN_TIV_PROC_WHO | Character(1) | VARCHAR2(1) NOT NULL |
Process Students
A=New and Pending Withdrawals C=Completed Withdrawals N=New Withdrawals Only P=Pending Withdrawals Default Value: A |
| 12 | TOTAL_RTN_STUDENTS | Number(6,0) | INTEGER NOT NULL | Total Students Processed |
| 13 | TOTAL_RTN_0_TO_10 | Number(6,0) | INTEGER NOT NULL | Students 0-10 Days |
| 14 | TOTAL_RTN_11_TO_20 | Number(6,0) | INTEGER NOT NULL | Students 11-20 Days |
| 15 | TOTAL_RTN_21_TO_30 | Number(6,0) | INTEGER NOT NULL | Students 21-30 Days |
| 16 | TOTAL_RTN_OVER_30 | Number(6,0) | INTEGER NOT NULL | Students Over 30 Days |
| 17 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 18 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 19 | RTRN_TIV_PGM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Program Type (Credit/Clock Hr)
L=Clock Hour Program R=Credit Hour Program Default Value: R |