SSF_SL_RUNCTL(SQL Table) |
Index Back |
|---|---|
StudyLink Run control |
| # | 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: OPR_DEF_TBL_CS.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SSF_SL_INPUT_DIR | Character(127) | VARCHAR2(127) NOT NULL | Location of the input file. |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: SSF_SL_INST |
| 5 | OUTPUTDEST | Character(127) | VARCHAR2(127) NOT NULL | Output Destination |
| 6 | SSF_REPORT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to allow the user to choose between a detailed report and a sumary report.
D=Detailed Report S=Summmary Report Default Value: D |
| 7 | SSF_VOS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Defines selection criteria for running the VOS process.
F=Full VOS S=Selected Students Default Value: F |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SSF_SL_BUS_UNIT |
| 9 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: SF_TERM_VW2 |
| 10 | SSF_SL_START_DATE | Date(10) | DATE | Start date for the studylink loan. |
| 11 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SSF_SL_PPL_SRCH |
| 12 | REPORT_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Report Only
N=Final Y=Review Default Value: Y |
| 13 | ALL_BUSINESS_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
All Business Unit's
Y/N Table Edit Default Value: Y |
| 14 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 15 | SSF_ERROR_WARN | Character(1) | VARCHAR2(1) NOT NULL |
Field to hold translate values for Message Types - Error/Warning/Message
E=Error M=Message W=Warning |
| 16 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 17 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 18 | SSF_SL_DISP_MSG | Character(1) | VARCHAR2(1) NOT NULL | Display messages. |