RUN_CNTL_ITMUPD(SQL Table) |
Index Back |
|---|---|
Chklst Item Update 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). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | DATA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Selection
M=General Materials S=Test Scores T=Transcripts Default Value: S |
| 4 | CHKLST_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL |
Checklist Item Code
Prompt Table: %EDITTABLE6 |
| 5 | ALL_ID | Character(1) | VARCHAR2(1) NOT NULL |
Process All IDs
Y/N Table Edit Default Value: Y |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE |
| 7 | ALL_TEST_ID | Character(1) | VARCHAR2(1) NOT NULL |
Process All Test IDs
Y/N Table Edit Default Value: N |
| 8 | TEST_ID | Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: %EDITTABLE2 |
| 9 | ALL_EXT_ORG | Character(1) | VARCHAR2(1) NOT NULL |
Process All Organizations
Y/N Table Edit Default Value: N |
| 10 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: %EDITTABLE3 |
| 11 | ALL_GENL_MATERIALS | Character(1) | VARCHAR2(1) NOT NULL |
Process All General Materials
Y/N Table Edit Default Value: N |
| 12 | GENL_MATL_GROUP | Character(8) | VARCHAR2(8) NOT NULL |
Material Group
Prompt Table: %EDITTABLE4 |
| 13 | GENL_MATL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Material Type
Prompt Table: %EDITTABLE5 |