|
|
| Line 1: |
Line 1: |
| − | = View CALLING_LIST_TO_CAMP_FACT =
| |
| | | | |
| − | <onlyinclude>
| |
| − |
| |
| − | {{PDMView
| |
| − | |viewName = CALLING_LIST_TO_CAMP_FACT
| |
| − | |shortDesc =
| |
| − | |viewDesc =
| |
| − | |introduced =
| |
| − | |SQL = <source lang="xml">select
| |
| − | CALLING_LIST_TO_CAMP_FACT_KEY,
| |
| − | TENANT_KEY,
| |
| − | CALLING_LIST_KEY,
| |
| − | CAMPAIGN_KEY,
| |
| − | START_DATE_TIME_KEY,
| |
| − | END_DATE_TIME_KEY,
| |
| − | CREATE_AUDIT_KEY,
| |
| − | UPDATE_AUDIT_KEY,
| |
| − | START_TS,
| |
| − | END_TS,
| |
| − | (case when ACTIVE_FLAG <> 0 then (select (max(LAST_CFG_EXTRACT_TS) - START_TS) from CTL_EXTRACT_METRICS) else END_TS - START_TS end) as TOTAL_DURATION,
| |
| − | ACTIVE_FLAG,
| |
| − | PURGE_FLAG
| |
| − | from
| |
| − | CALLING_LIST_TO_CAMP_FACT_</source>
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = CALLING_LIST_TO_CAMP_FACT_KEY
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = TENANT_KEY
| |
| − | |colDesc = The surrogate key that is used to join to the TENANT dimension.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = CALLING_LIST_KEY
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = CAMPAIGN_KEY
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = START_DATE_TIME_KEY
| |
| − | |colDesc = Identifies the start of a 15-minute interval in which the call began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = END_DATE_TIME_KEY
| |
| − | |colDesc = Identifies the start of a 15-minute interval in which the call ended. Use this value as a key to join the fact tables to any configured DATE_TIME dimension, in order to group the facts that are related to the same interval and/or convert the START_TS timestamp to an appropriate time zone.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |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.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = UPDATE_AUDIT_KEY
| |
| − | |colDesc = The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = START_TS
| |
| − | |colDesc = The UTC-equivalent value of the date and time when the calling list was added to IDB, which may differ from when the calling list was actually added to contact center configuration.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = END_TS
| |
| − | |colDesc = The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = TOTAL_DURATION
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = ACTIVE_FLAG
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMViewColumn
| |
| − | |colName = PURGE_FLAG
| |
| − | |colDesc =
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentView = TENANT
| |
| − | |foreignKey = TENANT_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentView = CALLING_LIST
| |
| − | |foreignKey = CALLING_LIST_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentView = CAMPAIGN
| |
| − | |foreignKey = CAMPAIGN_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = DATE_TIME
| |
| − | |foreignKey = START_DATE_TIME_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = DATE_TIME
| |
| − | |foreignKey = END_DATE_TIME_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = CTL_AUDIT_LOG
| |
| − | |foreignKey = CREATE_AUDIT_KEY
| |
| − | }}
| |
| − |
| |
| − | {{PDMRef
| |
| − | |parentTable = CTL_AUDIT_LOG
| |
| − | |foreignKey = UPDATE_AUDIT_KEY
| |
| − | }}
| |
| − |
| |
| − | </onlyinclude>
| |
| − |
| |
| − | [[Category:V:GIM:8.5DRAFT]]
| |
