EOCF_IACATEGORY(SQL Table) |
Index Back |
---|---|
Intelligent Action CategoryIntelligent Action Category |
# | 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 |
4 | DESCRLONG | Long Character | CLOB | Long Description |
5 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
6 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
7 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
8 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |