OPRIDRUN_CNTL_IDPrompt Table: SCC_CG_CLRPRCVW
A=All IDs
E=All Person IDs
O=One Org ID
P=Population Selection
R=All Org IDs
S=One Person ID
Default Value: A
Prompt Table: SCC_CG_CLRPERVW
Prompt Table: SCC_CG_CLRORGVW
SCC_CG_RUNRESET(SQL Table) |
Index Back |
|---|---|
CommGen Reset Run ControlSCC_CG_RUNRESET holds run control parameters for clearing COMMGEN processing tables and resetting Communication records. |
| # | 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 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: SCC_CG_CLRPRCVW |
| 4 | CG_COMM_ID_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Communication ID Select Option
A=All IDs E=All Person IDs O=One Org ID P=Population Selection R=All Org IDs S=One Person ID Default Value: A |
| 5 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SCC_CG_CLRPERVW |
| 7 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: SCC_CG_CLRORGVW |
| 8 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |