WHEREUSEDRUNCTL(SQL Table) |
Index Back |
|---|---|
Where Used Run ControlHR Split cross reference job run control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | PS_HOME | Character(254) | VARCHAR2(254) NOT NULL | PS_HOME Directory |
| 4 | SCAN_LIST_IN | Number(9,0) | DECIMAL(9) NOT NULL |
Scan List Input
Prompt Table: CC_SCAN_TBL |
| 5 | SCAN_LIST_OUT | Number(9,0) | DECIMAL(9) NOT NULL |
Scan List Output
Prompt Table: CC_SCAN_TBL |
| 6 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
| 7 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Project Name (see PSPROJECTDEFN).
Prompt Table: PSPROJECTDEFN |
| 8 | RUN_WHEREUSED | Character(1) | VARCHAR2(1) NOT NULL |
Run Where Used
Y/N Table Edit Default Value: Y |
| 9 | RUN_CASCADE | Character(1) | VARCHAR2(1) NOT NULL |
Run Cascade
Y/N Table Edit Default Value: Y |
| 10 | RUN_PROJ_GEN | Character(1) | VARCHAR2(1) NOT NULL |
Run Project Generation
Y/N Table Edit Default Value: Y |