RG_HIST_ACT_TRM(SQL Table) |
Index Back |
---|---|
Change History Action - TermsTerms that are being used in Change Request 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 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
6 | EOCF_CONFIG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
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. |