Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value

Table CALLING_LIST_METRIC_FACT

Description


In partitioned databases, this table is partitioned.


Each row represents a set of outbound campaign calling list metrics, calculated by Outbound Contact Server in configurable snapshots. Rows in this table are not updated; they are inserted or deleted only.

Column List

Legend

Column Data Type P M F DV

CALLING_LIST_METRIC_FACT_KEY

NUMBER(19) X X

TENANT_KEY

NUMBER(10) X X

CREATE_AUDIT_KEY

NUMBER(19) X X

UPDATE_AUDIT_KEY

NUMBER(19) X X

CAMPAIGN_KEY

NUMBER(10) X X

CALLING_LIST_KEY

NUMBER(10) X X

START_DATE_TIME_KEY

NUMBER(10) X X

CAMP_GROUP_SESS_FACT_SDT_KEY

NUMBER(10)

CAMP_GROUP_SESSION_FACT_KEY

NUMBER(19) X

GMT_TS

NUMBER(10)

TOTAL_RECORDS

NUMBER(10)

NOT_PROCESSED_RECORDS

NUMBER(10)

TOTAL_CONTACTS

NUMBER(10)

NOT_PROCESSED_CONTACTS

NUMBER(10)

ACTIVE_FLAG

NUMBER(1)

PURGE_FLAG

NUMBER(1)

CALLING_LIST_METRIC_FACT_KEY


The primary key of this table.

TENANT_KEY


The surrogate key that is used to join the TENANT dimension to the fact tables.

CREATE_AUDIT_KEY


The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.

UPDATE_AUDIT_KEY


The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.

CAMPAIGN_KEY


The surrogate key that is used to join the CAMPAIGN dimension to the fact tables.

CALLING_LIST_KEY


The surrogate key that is used to join the CALLING_LIST dimension to the fact tables.

START_DATE_TIME_KEY


Identifies the start of a 15-minute interval in which the fact began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension.

CAMP_GROUP_SESS_FACT_SDT_KEY


The value of the START_DATE_TIME_KEY field of the record in the CAMPAIGN_GROUP_ SESSION_FACT table. On a partitioned database, CAMP_GROUP_SESS_FACT_SDT_KEY in combination with CAMP_GROUP_SESSION_FACT_KEY forms a value of the composite primary key for the CAMPAIGN_GROUP_SESSION_FACT table.

CAMP_GROUP_SESSION_FACT_KEY


The value of the primary key of the CAMPAIGN_GROUP_SESSION_FACT table.

GMT_TS


The GMT-equivalent date and time at which measurement occurred, as the number of seconds that have elapsed since midnight on January 1, 1970.

TOTAL_RECORDS


The total number of records in the calling list.

NOT_PROCESSED_RECORDS


The total number of records in the calling list that are ready to be processed and that have never been processed as part of this calling list.

TOTAL_CONTACTS


The total number of contacts in the calling list (where a set of chained records for the same customer is considered to be one contact).

NOT_PROCESSED_CONTACTS


The total number of contacts in the calling list that have not been processed (where a set of chained records for the same customer is considered to be one contact).

ACTIVE_FLAG


Indicates whether the calling list metric is currently active. Always 0.

PURGE_FLAG


This field is reserved.


Index List

CODE U C Description

I_CLMF_SDT

Improves access time, based on the Start Date Time key.

I_CLMF_TNT

Improves access time, based on the Tenant.

Index I_CLMF_SDT

Field Sort Comment
START_DATE_TIME_KEY Ascending

Index I_CLMF_TNT

Field Sort Comment
TENANT_KEY Ascending

Subject Areas

  • Facts - Represents the relationships between subject area facts.

 

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 14:57.