WHEREUSEDRUNCTL

(SQL Table)
Index Back

Where Used Run Control

HR 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