EOCF_RULEVT_LVW

(SQL View)
 Index Back

IA Event Search rel lang view

Active Analytics Framework IA Event Search related language view

SELECT C.EOCF_RSET_ITEM_ID , B.LANGUAGE_CD , B.EOCF_EVENT_NAME , D.EOCF_CTX_NAME FROM PS_EOCF_EVENT_SEQ A , PS_EOCF_EVENT_LNG B , PS_EOCF_RSET_SEQ C , PS_EOCF_CTX_LANG D , PS_EOCF_EVENT_DEFN E WHERE A.EOCF_EVENT_ID = B.EOCF_EVENT_ID AND B.EOCF_EVENT_ID = E.EOCF_EVENT_ID AND A.EOCF_RULESET_ID = C.EOCF_RULESET_ID AND C.EOCF_RULE_ITEM_TYP = '00' AND E.EOCF_CONTEXT_ID = D.EOCF_CONTEXT_ID AND B.LANGUAGE_CD = D.LANGUAGE_CD

  • Related Language Record for EOCF_RULEVT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EOCF_EVENT_NAME Character(80) VARCHAR2(80) NOT NULL user-defined name to identify the characteristics of a particular action

    Prompt Table: EOCF_EVTDFN_LVW

    4 EOCF_CTX_NAME Character(50) VARCHAR2(50) NOT NULL context name

    Prompt Table: EOCF_CTXDFN_LVW