Jump to: navigation, search

View CALLING_LIST

Description

Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list. This view is based on the GIDB_GC_CALLING_LIST table.

Column List

Column Description
CALLING_LIST_KEY The primary key of this view and the surrogate key that is used to join the CALLING_LIST dimension to the fact tables.
TENANT_KEY The surrogate key that is used to join the TENANT dimension to the fact tables.
CALLING_LIST_NAME The name of the calling list.
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 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.
DESCRIPTION The description of the calling list.
CALLING_LIST_CFG_DBID The calling list object identifier in the contact center configuration.
START_TS 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.
END_TS The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.

SQL Query

SELECT
  ID               AS CALLING_LIST_KEY,
  TENANTID         AS TENANT_KEY,
  NAME             AS CALLING_LIST_NAME,
  CREATE_AUDIT_KEY AS CREATE_AUDIT_KEY,
  UPDATE_AUDIT_KEY AS UPDATE_AUDIT_KEY,
  DESCRIPTION      AS DESCRIPTION,
  ID               AS CALLING_LIST_CFG_DBID,
  CREATED_TS       AS START_TS,
  DELETED_TS       AS END_TS
  FROM GIDB_GC_CALLING_LIST
  UNION ALL
  SELECT
  -1               AS CALLING_LIST_KEY,
  -1               AS TENANT_KEY,
  'UNKNOWN'        AS CALLING_LIST_NAME,
  -1               AS CREATE_AUDIT_KEY,
  -1               AS UPDATE_AUDIT_KEY,
  'UNKNOWN'        AS DESCRIPTION,
  -1               AS CALLING_LIST_CFG_DBID,
  -1               AS START_TS,
  -1               AS END_TS
  FROM dual
  UNION ALL
  SELECT
  -2               AS CALLING_LIST_KEY,
  -1               AS TENANT_KEY,
  'NO_VALUE'       AS CALLING_LIST_NAME,
  -1               AS CREATE_AUDIT_KEY,
  -1               AS UPDATE_AUDIT_KEY,
  'NO_VALUE'       AS DESCRIPTION,
  -1               AS CALLING_LIST_CFG_DBID,
  -1               AS START_TS,
  -1               AS END_TS
  FROM dual

Feedback

Comment on this article:

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