EOCF_IACAT_VW

(SQL View)
Index Back

Intell. Action Category View

Intelligent Action Category View

SELECT EOCF_IACATEGORY_ID , EOCF_IACATEGORY_NM , STATUS FROM PS_EOCF_IACATEGORY WHERE STATUS = 'A'

  • Related Language Record: EOCF_IACAT_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_IACATEGORY_ID Number(31,0) DECIMAL(31) NOT NULL Action Id
    2 EOCF_IACATEGORY_NM Character(80) VARCHAR2(80) NOT NULL user-defined name to identify the characteristics of a particular action
    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A