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 | SetID |
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 |