EOCF_EVTACT_PVW

(SQL View)
 Index Back

Valid action types/ trig type

Valid action types for a trigger type

SELECT DISTINCT A.EOCF_EVENT_TYPE_ID , A.EOCF_ACTION_TYP_ID , B.EOCF_ACT_TYP_NAME FROM PS_EOCF_ACT_EV_TYP A , PS_EOCF_ACTN_TYPE B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID

  • Related Language Record: EOCF_EVTACTPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_EVENT_TYPE_ID Number(31,0) DECIMAL(31) NOT NULL what kind of event is this
    2 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

    3 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action