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 | 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 | 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 |