PROCESS_INSTANCEA=All IDs
E=All Person IDs
O=One Org ID
P=Population Selection
R=All Org IDs
S=One Person ID
SCC_CGRESET_AET(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 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | PROCESSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | 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 |
| 6 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 7 | SEQ_3C | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 10 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 11 | SCC_TOT_RECS_RESET | Number(9,0) | DECIMAL(9) NOT NULL | Total Checklists Deleted |