EOCF_DE_LOG(SQL Table) |
Index Back |
|---|---|
rule engine logActive Analytics Framework rule engine log record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOCF_LOG_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework log ID field |
| 2 | EOCF_DE_LOGSEQ |
Number(6,0) | INTEGER NOT NULL | log entry order |
| 3 | EOCF_DE_LOGTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Policy Engine Log Type
00=Message 01=Action Count 02=Event Time 03=Bind Value 04=Event Policy Count 05=Policy Time 06=Term Time 07=Policy Result 08=Action Combinations 09=Actions Received 10=Terminal Action 11=Terminals Ignored 12=Forwarded Actions 13=Action Timings 14=Context Driver Keys 15=Trace Step 16=Term Values 17=Log Summary 18=Actions Combined Detail 19=Actions Received Detail 20=Actions Ignored Detail 21=Log Driver Detail 22=Data Library Log 23=Data Library Log Detail |
| 4 | EOCF_DE_LOG_USER | Character(30) | VARCHAR2(30) NOT NULL | user id for logging |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 6 | EOCF_TIMESTAMP | DateTime(26) | TIMESTAMP | timestamp |
| 7 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context |
| 8 | EOCF_CONTEXT_VAR | Number(3,0) | SMALLINT NOT NULL | seqnum for context variables |
| 9 | EOCF_EVENT_ID | Number(31,0) | DECIMAL(31) NOT NULL | unique identifier for an event definition |
| 10 | EOCF_RULE_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework unique identifier for a policy |
| 11 | EOCF_ACTION_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework Action ID field |
| 12 | 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. |
| 13 | EOCF_DE_LOG_DTL_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework log object detail ID field |
| 14 | EOCF_MSGNUM | Number(5,0) | INTEGER NOT NULL | Active Analytics Framework message number field |
| 15 | EOCF_MSGSET | Number(5,0) | INTEGER NOT NULL | Active Analytics Framework message set number field |
| 16 | EOCF_LOGGED_VALUE | Long Character | CLOB | Value |