Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= Table CALLING_LIST_METRIC_FACT =
 
= Table CALLING_LIST_METRIC_FACT =
  
 +
{{PDMColumn
 +
|colName=CALLING_LIST_METRIC_FACT_KEY
 +
|colDesc=The primary key of this table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TENANT_KEY
 +
|colDesc=The surrogate key that is used to join the TENANT dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CREATE_AUDIT_KEY
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=UPDATE_AUDIT_KEY
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMPAIGN_KEY
 +
|colDesc=The surrogate key that is used to join the CAMPAIGN dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CALLING_LIST_KEY
 +
|colDesc=The surrogate key that is used to join the CALLING_LIST dimension to the fact tables.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=START_DATE_TIME_KEY
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMP_GROUP_SESS_FACT_SDT_KEY
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=CAMP_GROUP_SESSION_FACT_KEY
 +
|colDesc=The value of the primary key of the CAMPAIGN_GROUP_SESSION_FACT table.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=GMT_TS
 +
|colDesc=The GMT-equivalent date and time at which measurement occurred, as the number of seconds that have elapsed since midnight on January 1, 1970.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TOTAL_RECORDS
 +
|colDesc=The total number of records in the calling list.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=NOT_PROCESSED_RECORDS
 +
|colDesc=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.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=TOTAL_CONTACTS
 +
|colDesc=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).
 +
}}
 +
 +
{{PDMColumn
 +
|colName=NOT_PROCESSED_CONTACTS
 +
|colDesc=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).
 +
}}
 +
 +
{{PDMColumn
 +
|colName=ACTIVE_FLAG
 +
|colDesc=Indicates whether the calling list metric is currently active. Always 0.
 +
}}
 +
 +
{{PDMColumn
 +
|colName=PURGE_FLAG
 +
|colDesc=This field is reserved.
 +
}}
  
 
[[Category:V:GIM:8.5DRAFT]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 13:38, May 5, 2016

Table CALLING_LIST_METRIC_FACT

Comments or questions about this documentation? Contact us for support!