EOCF_RULACTYPVW

(SQL View)
 Index Back

Action Types for IA

Action Types for Intelligent action

SELECT A.EOCF_RULE_ID , D.EOCF_ACTION_TYP_ID , D.EOCF_ACT_TYP_NAME , E.EOCF_ACTION_OBJ_ID , E.EOCF_ACTION_OBJ_NM FROM PS_EOCF_RULE_DEFN A , PS_EOCF_ACTION_SET B , PS_EOCF_ACTION_DEF C , PS_EOCF_ACTN_TYPE D , PS_EOCF_ACTION_OBJ E WHERE A.EOCF_ACTION_SET_ID = B.EOCF_ACTION_SET_ID AND B.EOCF_ACTION_ID = C.EOCF_ACTION_ID AND C.EOCF_ACTION_TYP_ID = D.EOCF_ACTION_TYP_ID AND C.EOCF_ACTION_OBJ_ID (+)= E.EOCF_ACTION_OBJ_ID AND E.STATUS = 'A'

  • Related Language Record: EOCF_RULACTPLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_RULE_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework unique identifier for a policy
    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_ACTTYP_VW

    3 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action
    4 EOCF_ACTION_OBJ_ID Number(31,0) DECIMAL(31) NOT NULL Action Id

    Prompt Table: EOCF_ACTOBJN_VW

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