OPRIDRUN_CNTL_IDPrompt Table: BUSPROCNAME_VW
Prompt Table: WORKLISTNAME_VW
Prompt Table: WF_MON_SETUP
Prompt Table: MASS_RPT_HDR
RUN_CNTL_WF(SQL Table) |
Index Back |
|---|---|
Run Control for WorkflowThis record is used to provide examples of how to use the Process Scheduler tool. |
| # | 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 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 4 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: WORKLISTNAME_VW |
| 5 | DTTM_AVAIL_FROM | DateTime(26) | TIMESTAMP NOT NULL | Available Datetime From |
| 6 | DTTM_AVAIL_TO | DateTime(26) | TIMESTAMP NOT NULL | Available Datetime To |
| 7 | DTTM_WORKED_FROM | DateTime(26) | TIMESTAMP NOT NULL | Worked Datetime From |
| 8 | DTTM_WORKED_TO | DateTime(26) | TIMESTAMP NOT NULL | Worked Datetime To |
| 9 | WF_MON_SETUP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Workflow Monitor Setup ID
Prompt Table: WF_MON_SETUP |
| 10 | MASS_REPORT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mass Report ID
Prompt Table: MASS_RPT_HDR |
| 11 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |