WCS_ECM_RUNCNTL(SQL Table) |
Index Back |
|---|---|
Run ControlRun 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 | TREE_STRCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Name (see PSTREESTRCT).
Prompt Table: PSTREESTRCTMVW |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 5 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | TREE_CATEGORY | Character(18) | VARCHAR2(18) NOT NULL |
Category name for the Tree
Prompt Table: PSTREECATGVW |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 10 | WCS_PARENT_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Parent Field
Prompt Table:
PSRECFIELD
|
| 11 | WCS_CHILD_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Child Field
Prompt Table:
PSRECFIELD
|
| 12 | FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL |
Field Value
Prompt Table:
%EDITTABLE
|
| 13 | DEBUG | Character(1) | VARCHAR2(1) NOT NULL |
Show Program Names
Y/N Table Edit Default Value: N |
| 14 | BUDGET_ID | Character(10) | VARCHAR2(10) NOT NULL |
Budget ID
Prompt Table: WCS_ECM_CYC_VW1 |
| 15 | BUDGET_START_DT | Date(10) | DATE |
Budget Start Date
Prompt Table: WCS_ECM_CYC_CFG |
| 16 | WCS_RECALC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Recalculate Cycle
Y/N Table Edit Default Value: N |
| 17 | WCS_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Report Type |
| 18 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 19 | NODE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Used by the Integration Broker installation verification test to indicate whether they are setting up the source or target node |
| 20 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 21 | PROCESS_DT | Date(10) | DATE |
Process Date
Default Value: %date |
| 22 | ALL_SELECTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | all selected |