RC_EVENT_SET

(SQL Table)
 Index Back

Event Set Definition

old event set definitions - obsolete

  • Related Language Record: RC_EVENTSET_LNG

  • Parent Record Of RC_EVENTSET_ITM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 EVENT_SET_ID Character(15) VARCHAR2(15) NOT NULL Event Set ID
    3 MARKET Character(3) VARCHAR2(3) NOT NULL Market

    Default Value: GBL

    4 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: RC_EVENT_MODEL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 RC_EVENT_SET_TYPE Character(4) VARCHAR2(4) NOT NULL Event Set Type
    ACTN=Case History
    BP=Business Project Tracking
    CREL=Case Relationship
    ENBL=Entitlement Balances
    SLA=Service Level Agreement Work
    UPSL=Upsell Opportunities
    WF=Workflow

    Default Value: WF

    7 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    12 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.
    13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    14 DESCRLONG Long Character CLOB Long Description