EOCF_IACAT_VW(SQL View) |
Index Back |
|---|---|
Intell. Action Category ViewIntelligent Action Category View |
| SELECT EOCF_IACATEGORY_ID , EOCF_IACATEGORY_NM , STATUS FROM PS_EOCF_IACATEGORY WHERE STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |