EOCF_DE_LOG

(SQL Table)
Index Back

rule engine log

Active 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