EOCF_RULCAT_VW

(SQL View)
 Index Back

Policy Category View

Policy Category View

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

  • Related Language Record: EOCF_RULCAT_LVW

    • # 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_IACATEGORY_ID Number(31,0) DECIMAL(31) NOT NULL Action Id

    Prompt Table: EOCF_CATNM_VW

    3 EOCF_IACATEGORY_NM Character(80) VARCHAR2(80) NOT NULL user-defined name to identify the characteristics of a particular action