EOCF_DL_LOG(SQL Table) |
Index Back |
---|---|
Data Library LogData Library Log |
# | 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 |
2 | EOCF_SEQNUM_6 | Number(6,0) | INTEGER NOT NULL | sequence number for line item rows |
3 | EOCF_DL_LOGTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Rule Engine Log Type
00=Processing Messages 0100=Term Resolution 0200=Context Generation 0300=Bind Substitution 0400=Cache Management 0500=Object Factory Processing |
4 | EOCF_DL_LOGBINDTYP | Character(4) | VARCHAR2(4) NOT NULL |
Rule Engine Log Type
0100=Term Functional Bind 0200=Term Contextual Bind 0300=Implementation / Resolution |
5 | EOCF_LOG_DTTM | DateTime(26) | TIMESTAMP | Log Entry Datetime |
6 | EOCF_PERF_TIME | Number(13,6) | DECIMAL(12,6) NOT NULL | Elapsed Time |
7 | EOCF_LIB_TERM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework 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. |
8 | EOCF_CONFIG_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
9 | EOCF_CONTEXT_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework ID value for a configured context |
10 | EOCF_IMPL_ID | Number(31,0) | DECIMAL(31) NOT NULL | the ID value uniquely identifying a term implementation |
11 | EOCF_RES_MTHD_ID | Number(31,0) | DECIMAL(31) NOT NULL | data library - resolution method id |
12 | EOCF_CONTEXT_VAR | Number(3,0) | SMALLINT NOT NULL | Active Analytics Framework sequence number for context variables |
13 | EOCF_BIND_ORDERNUM | Number(3,0) | SMALLINT NOT NULL | bind order number |
14 | EOCF_CACHE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
data library term status, possible values are Active, Inactive, Under Construction
C=Component G=Global N=Do not cache T=Trigger Point |
15 | EOCF_MSGNUM | Number(5,0) | INTEGER NOT NULL | Active Analytics Framework message number |
16 | EOCF_MSGSET | Number(5,0) | INTEGER NOT NULL | Active Analytics Framework message set number |
17 | EOCF_LOGGED_VALUE | Long Character | CLOB | Active Analytics Framework logged value |