EOCF_EVENT_DEFN

(SQL Table)
Index Back

event definition

defines an event

  • Related Language Record: EOCF_EVENT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_EVENT_ID Number(31,0) DECIMAL(31) NOT NULL unique identifier for an event definition
    2 EOCF_EVENT_NAME Character(80) VARCHAR2(80) NOT NULL user-defined name to identify the characteristics of a particular action
    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    4 EOCF_EVENT_TYPE_ID Number(31,0) DECIMAL(31) NOT NULL what kind of event is this

    Prompt Table: EOCF_EVTYPSELVW

    5 EOCF_CONTEXT_ID Number(31,0) DECIMAL(31) NOT NULL the ID value for a configured context

    Prompt Table: EOCF_CONTEXT

    6 EOCF_BUSDOM_ID Number(31,0) DECIMAL(31) NOT NULL subject filing for library object

    Prompt Table: EOCF_BUSDOM_PVW

    7 DESCRLONG Long Character CLOB Long Description
    8 EOCF_CODE_NAME Character(18) VARCHAR2(18) NOT NULL code name for terms and phrases
    9 EOCF_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL data library - Maint Owner, possible values are Peoplesoft, Customer, Modified
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    10 EOCF_IS_SYSTEM Character(1) VARCHAR2(1) NOT NULL data library - is system data
    11 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    12 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    13 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    14 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.