EOCF_BND_ACT_VW

(SQL View)
 Index Back

view of Bundle Action Types

view of action Types in an Action bundle

SELECT A.EOCF_ACTION_TYP_ID , A.EOCF_ACT_TYP_NAME FROM PS_EOCF_ACTN_TYPE A WHERE NOT EXISTS ( SELECT B.EOCF_ACTION_TYP_ID FROM PS_EOCF_ACT_BUNDLE B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID) AND A.EOCF_IS_CMBIN_FLAG = 'Y'

  • Related Language Record: EOCF_BNDACT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_ACTION_TYP_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier pointing to a discreet action type configuration
    2 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action