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
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

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

numeric(19) X X

TENANT_KEY

int X X

CREATE_AUDIT_KEY

numeric(19) X X

UPDATE_AUDIT_KEY

numeric(19) X X

CAMPAIGN_KEY

int X X

CALLING_LIST_KEY

int X X

START_DATE_TIME_KEY

int X X

CAMP_GROUP_SESS_FACT_SDT_KEY

int X

CAMP_GROUP_SESSION_FACT_KEY

numeric(19) X

GMT_TS

int

TOTAL_RECORDS

int

NOT_PROCESSED_RECORDS

int

TOTAL_CONTACTS

int

NOT_PROCESSED_CONTACTS

int

ACTIVE_FLAG

numeric(1)

PURGE_FLAG

numeric(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.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 10 August 2017, at 06:42.