RUN_CNTL_3CENG(SQL Table) |
Index Back |
|---|---|
Letter Generation Run ControlRUN_CNTL_LTRGEN contains fields that are used as input parameters for the Letter Generation Process. Input data is retrieved from this record when the Letter Generation Process is requested from the Process Scheduler. |
| # | 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 | SCCPS_POP_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.
Y/N Table Edit Default Value: Y |
| 4 | SCCPS_TOOL_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Tool ID - the unique key for a pop select tool
Prompt Table: SCCPS_TOOL_VW |
| 5 | SCCPS_QUERY_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Query / Section name used by population selection
Prompt Table: %EDITTABLE |
| 6 | SCCPS_CNTXT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Context ID - the unique key that identifies the pop selection context
Prompt Table: SCCPS_CNTXT_VW |
| 7 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 8 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 9 | SCCPS_FILE_PATH | Character(254) | VARCHAR2(254) NOT NULL | Pop Select File Path and Name |
| 10 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 11 | ADMIN_FUNCTION | Character(4) | VARCHAR2(4) NOT NULL |
Administrative Function
Prompt Table: ADM_FUNCTN_TBL |
| 12 | EVENT_3CS_ID | Character(10) | VARCHAR2(10) NOT NULL |
3Cs event ID
Prompt Table: EVNT_3C_GRP_VW |
| 13 | PROCESS_3CS | Character(1) | VARCHAR2(1) NOT NULL |
Process 3Cs
B=Both M=Mass Change T=Trigger Default Value: B |
| 14 | MC_DEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
| 15 | PROCESS_JOINT | Character(1) | VARCHAR2(1) NOT NULL |
Used by the Run_Cntl_3CEng page to capture run control parameters for the 3C Engine to branch off and call the Joint Rules Engine.
A=Yes, all Joint IDs B=Yes, if match exists N=No Joint Processing Default Value: N |
| 16 | SCC_3C_MASS_CHANGE | Character(1) | VARCHAR2(1) NOT NULL |
Select Mass Change for processing 3c's
Y/N Table Edit |
| 17 | SCC_3C_POP_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Select Population Selection for processing 3c's
Y/N Table Edit |
| 18 | SCC_3C_TRIGGER | Character(1) | VARCHAR2(1) NOT NULL |
Select Trigger for processing 3c's
Y/N Table Edit |