EOCF_ACTNDEF_VW

(SQL View)
Index Back

action definition View

action definition View

SELECT A.EOCF_ACTION_SET_ID , B.EOCF_ACTION_ID , A.EOCF_ORDERNUM , B.EOCF_ACTION_NAME , A.STATUS , B.EOCF_ACTION_TYP_ID , B.EOCF_ACTION_OBJ_ID , %subrec(EOCF_AUDIT_SBR,B) FROM PS_EOCF_ACTION_SET A , PS_EOCF_ACTION_DEF B WHERE A.EOCF_ACTION_ID = B.EOCF_ACTION_ID

  • Related Language Record: EOCF_ACTDEF_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_ACTION_SET_ID Number(31,0) DECIMAL(31) NOT NULL set of actions to be run from an event
    2 EOCF_ACTION_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework Action ID field
    3 EOCF_ORDERNUM Number(3,0) SMALLINT NOT NULL sequence number for line item rows
    4 EOCF_ACTION_NAME Character(80) VARCHAR2(80) NOT NULL user-defined name to identify the characteristics of a particular action
    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 EOCF_ACTION_TYP_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier pointing to a discreet action type configuration

    Prompt Table: EOCF_ACTN_TYPE

    7 EOCF_ACTION_OBJ_ID Number(31,0) DECIMAL(31) NOT NULL Action Id

    Prompt Table: EOCF_ACTION_OBJ

    8 EOCF_CREATEDTTM DateTime(26) TIMESTAMP CLAF - Created DateTime
    9 EOCF_CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    10 EOCF_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    11 EOCF_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.