EOCF_ACTION_IDEOCF_TERM_ALIASORG=Original Value
ORGD=Original Value - Description
VAL=Current Value
VALD=Current Value - Description
Default Value: VALD
RC_HIST_ACT_TRM(SQL Table) |
Index Back |
|---|---|
Case History Action - TermsTerms that are being used in case history descriptions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_ACTION_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework Action ID field |
| 2 | EOCF_TERM_ALIAS |
Character(30) | VARCHAR2(30) NOT NULL | Term Alias |
| 3 | EOCF_IS_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Do Actions of this Action Type need to be configured |
| 4 | EOCF_LIB_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements. |
| 5 | EOCF_CONFIG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
| 6 | TERM_DISPLAY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
used for AAF terms to indicate how you would like that term to be displayed. (original value, current value)
ORG=Original Value ORGD=Original Value - Description VAL=Current Value VALD=Current Value - Description Default Value: VALD |
| 7 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
| 8 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 9 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 10 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |