EOCF_RULCAT_LVW

(SQL View)
 Index Back

Policy category view

Policy category view

SELECT A.EOCF_RULE_ID , B.LANGUAGE_CD , B.EOCF_IACATEGORY_NM FROM PS_EOCF_RULE_DEFN A , PS_EOCF_IACAT_LNG B ,PS_EOCF_IACATEGORY C WHERE A.EOCF_IACATEGORY_ID = B.EOCF_IACATEGORY_ID AND B.EOCF_IACATEGORY_ID = C.EOCF_IACATEGORY_ID AND C.STATUS = 'A'

  • Related Language Record for EOCF_RULCAT_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_IACATEGORY_NM Character(80) VARCHAR2(80) NOT NULL user-defined name to identify the characteristics of a particular action