RBB_AAF_CMPLWL(SQL Table) |
Index Back |
---|---|
Worklist CompletionCompletion for External Worklist Entry via AAF action |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_ACTION_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework Action ID field |
2 | EOCF_ACTION_NAME | Character(80) | VARCHAR2(80) NOT NULL | user-defined name to identify the characteristics of a particular action |
3 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context |
4 | EOCF_CTX_NAME | Character(50) | VARCHAR2(50) NOT NULL | context name |
5 | RBB_SERV_OPR_ID | Character(100) | VARCHAR2(100) NOT NULL |
Service Operation ID
Prompt Table: PSOPERATION |
6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
7 | RECIPIENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Recipient Type
PER=Person PROV=Provider Group |
8 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: RBB_AAF_BPROC_V |
9 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: RBB_AAF_ACTV_VW |
10 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: RBB_VLD_EVNT_VW |
11 | RB_PACKAGE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Package |
12 | RB_PACKAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Package Name
Prompt Table: RBB_PACKAGE_VW |
13 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
14 | EOCF_LIB_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements. |
15 | EOCF_LIB_TERM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Term in the library |
16 | MSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
Prompt Table: RBB_MSGDEFN_VW |
17 | APMSGVER | Character(30) | VARCHAR2(30) NOT NULL |
Message Version
Prompt Table: RBB_MSGVERVW |
18 | EOCF_PHRASE_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
19 | EOCF_CONFIG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
20 | RBB_ROWADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
21 | RBB_ROWADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
22 | RBB_ROWUPD_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
23 | RBB_ROWUPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
24 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
25 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |