RBB_OUTCOME

(SQL Table)
Index Back

Outcome Definition Table

External Business Process Outcome Definition Table

  • Related Language Record: RBB_OUTCOME_LNG
  • Parent Record Of RBB_OUTCOME_CD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RBB_OUTCOME_ID Character(30) VARCHAR2(30) NOT NULL Business Process Outcome ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 RBB_OUTCOME_LABEL Character(50) VARCHAR2(50) NOT NULL External Worklist Outcome Short Label
    4 RBB_LONG_DESCR Character(254) VARCHAR2(254) NOT NULL Application Mapping Long Description
    5 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name

    Prompt Table: RBB_PAGENAME_VW

    6 RBB_REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Outcome Code is required for the Response

    Y/N Table Edit

    Default Value: Y

    7 RBB_FORCE_OUTCOME Character(1) VARCHAR2(1) NOT NULL Force User to Activity Status page to receive Responses

    Y/N Table Edit

    Default Value: N

    8 RBB_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Maintenance Owner of BPEL related objects
    0=Peoplesoft
    1=Modified
    2=Customer
    9 RBB_SYSD_APP_01 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 01
    N=No
    S=Sample Data
    Y=Yes
    10 RBB_SYSD_APP_02 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 02
    N=No
    S=Sample Data
    Y=Yes
    11 RBB_SYSD_APP_03 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 03
    N=No
    S=Sample Data
    Y=Yes
    12 RBB_SYSD_APP_04 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 04
    N=No
    S=Sample Data
    Y=Yes
    13 RBB_SYSD_APP_05 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 05
    N=No
    S=Sample Data
    Y=Yes
    14 RBB_SYSD_APP_06 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 06
    N=No
    S=Sample Data
    Y=Yes
    15 RBB_SYSD_APP_07 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 07
    N=No
    S=Sample Data
    Y=Yes
    16 RBB_SYSD_APP_08 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 08
    N=No
    S=Sample Data
    Y=Yes
    17 RBB_SYSD_APP_09 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 09
    N=No
    S=Sample Data
    Y=Yes
    18 RBB_SYSD_APP_10 Character(1) VARCHAR2(1) NOT NULL Application Flag for Application 10
    N=No
    S=Sample Data
    Y=Yes
    19 RBB_ROWADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    20 RBB_ROWADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    21 RBB_ROWUPD_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    22 RBB_ROWUPD_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    23 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.
    24 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time