EOCF_TMRULE_VW

(SQL View)
 Index Back

Term Intel. Action Association

Term Intelligent Action Association View

SELECT DISTINCT D.EOCF_LIB_TERM_ID , B.EOCF_RULE_ID , B.EOCF_RULE_NAME , B.EOCF_RULE_STATUS , C.EOCF_PHRASE_ID FROM PS_EOCF_PHRASE_XPR A , PS_EOCF_RULE_DEFN B , PS_EOCF_PHRASE_DFN C , PS_EOCF_TERM_DEFN D WHERE A.EOCF_PHRASE_ID = B.EOCF_PHRASE_ID AND A.EOCF_PHRASE_ID = C.EOCF_PHRASE_ID AND C.EOCF_PHRASE_STATUS = 'A' AND ((A.EOCF_LHS1_TYPE = '01' AND A.EOCF_LHS1_ELEM_ID = D.EOCF_LIB_TERM_ID) OR (A.EOCF_RHS1_TYPE = '01' AND A.EOCF_RHS1_TERM_ID = D.EOCF_LIB_TERM_ID) OR (A.EOCF_RHS2_TYPE = '01' AND A.EOCF_RHS2_TERM_ID = D.EOCF_LIB_TERM_ID))

  • Related Language Record: EOCF_TMRULE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_LIB_TERM_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements.
    2 EOCF_RULE_ID Number(31,0) DECIMAL(31) NOT NULL Active Analytics Framework unique identifier for a policy
    3 EOCF_RULE_NAME Character(80) VARCHAR2(80) NOT NULL the name of a policy if the policy is named
    4 EOCF_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL data library term status, possible values are Active, Inactive, Under Construction
    A=Active
    U=In Design
    5 EOCF_PHRASE_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier for a phrase definition (ignoring versioning)