RBB_AAF_CMPLWL

(SQL Table)
Index Back

Worklist Completion

Completion for External Worklist Entry via AAF action

  • Related Language Record: RBB_AAF_WS_LG
  • # 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