OPRIDRUN_CNTL_IDPrompt Table: RB_VLD_ACTV_VW
RB_AAF_RUNCNTL(SQL Table) |
Index Back |
|---|---|
Run Control Record for CLA WFRun Control Record for CLA Workflow |
| # | 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 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
| 4 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 5 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 6 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 7 | SEARCH_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 8 | EOCF_ACTION_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework Action ID field |
| 9 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 12 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |
| 13 | KEYLIST | Character(254) | VARCHAR2(254) NOT NULL | KeyList |
| 14 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 15 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: RB_VLD_ACTV_VW |
| 16 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 17 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 18 | RB_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Alternate fieldto strore values as 'VALUE' is reserved word in DB2. |
| 19 | DESCR_ACTIVITY | Character(30) | VARCHAR2(30) NOT NULL | This field is used to temporarily store the description of a Business Project phase. |
| 20 | SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 21 | EMAILTEXT | Long Character | CLOB | Email Text |
| 22 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 23 | CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 24 | MEMBERS | Character(254) | VARCHAR2(254) NOT NULL | Members |
| 25 | DESCR_TASK | Character(30) | VARCHAR2(30) NOT NULL | This field is used to temporarily store the description of a Business Project task. |
| 26 | RB_WF_GRP_NAME | Character(30) | VARCHAR2(30) NOT NULL | Group Worklist Nameg |
| 27 | CHECK_DUPS | Character(254) | VARCHAR2(254) NOT NULL | This field is used for checking duplicate group member names for remove from worklist workflow |