Jump to: navigation, search
(Resaving to refresh the Cargo table)
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
= View CALLING_LIST =
 
= View CALLING_LIST =
−
 
+
 
 
<onlyinclude>
 
<onlyinclude>
−
 
+
 
−
 
 
 
{{PDMView
 
{{PDMView
 
|viewName = CALLING_LIST
 
|viewName = CALLING_LIST
 
|shortDesc =  Allows facts to be described based on attributes of an outbound campaign calling list.
 
|shortDesc =  Allows facts to be described based on attributes of an outbound campaign calling list.
 
|viewDesc =  Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list.
 
|viewDesc =  Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list.
−
|introduced =   {{Editgrn_open}}9.9.001{{Editgrn_close}}
+
|introduced =
 
|SQL =  <source lang="xml" enclose="div">SELECT
 
|SQL =  <source lang="xml" enclose="div">SELECT
−
ID              AS CALLING_LIST_KEY,
+
  ID              AS CALLING_LIST_KEY,
−
TENANTID        AS TENANT_KEY,
+
  TENANTID        AS TENANT_KEY,
−
NAME            AS CALLING_LIST_NAME,
+
  NAME            AS CALLING_LIST_NAME,
−
CREATE_AUDIT_KEY AS CREATE_AUDIT_KEY,
+
  CREATE_AUDIT_KEY AS CREATE_AUDIT_KEY,
−
UPDATE_AUDIT_KEY AS UPDATE_AUDIT_KEY,
+
  UPDATE_AUDIT_KEY AS UPDATE_AUDIT_KEY,
−
DESCRIPTION      AS DESCRIPTION,
+
  DESCRIPTION      AS DESCRIPTION,
−
ID              AS CALLING_LIST_CFG_DBID,
+
  ID              AS CALLING_LIST_CFG_DBID,
−
CREATED_TS      AS START_TS,
+
  CREATED_TS      AS START_TS,
−
DELETED_TS      AS END_TS
+
  DELETED_TS      AS END_TS
−
FROM GIDB_GC_CALLING_LIST
+
  FROM GIDB_GC_CALLING_LIST
−
UNION ALL
+
  UNION ALL
−
SELECT
+
  SELECT
−
-1              AS CALLING_LIST_KEY,
+
  -1              AS CALLING_LIST_KEY,
−
-1              AS TENANT_KEY,
+
  -1              AS TENANT_KEY,
−
'UNKNOWN'        AS CALLING_LIST_NAME,
+
  'UNKNOWN'        AS CALLING_LIST_NAME,
−
-1              AS CREATE_AUDIT_KEY,
+
  -1              AS CREATE_AUDIT_KEY,
−
-1              AS UPDATE_AUDIT_KEY,
+
  -1              AS UPDATE_AUDIT_KEY,
−
'UNKNOWN'        AS DESCRIPTION,
+
  'UNKNOWN'        AS DESCRIPTION,
−
-1              AS CALLING_LIST_CFG_DBID,
+
  -1              AS CALLING_LIST_CFG_DBID,
−
-1              AS START_TS,
+
  -1              AS START_TS,
−
-1              AS END_TS
+
  -1              AS END_TS
−
FROM dual
+
  FROM dual
−
UNION ALL
+
  UNION ALL
−
SELECT
+
  SELECT
−
-2              AS CALLING_LIST_KEY,
+
  -2              AS CALLING_LIST_KEY,
−
-1              AS TENANT_KEY,
+
  -1              AS TENANT_KEY,
−
'NO_VALUE'      AS CALLING_LIST_NAME,
+
  'NO_VALUE'      AS CALLING_LIST_NAME,
−
-1              AS CREATE_AUDIT_KEY,
+
  -1              AS CREATE_AUDIT_KEY,
−
-1              AS UPDATE_AUDIT_KEY,
+
  -1              AS UPDATE_AUDIT_KEY,
−
'NO_VALUE'      AS DESCRIPTION,
+
  'NO_VALUE'      AS DESCRIPTION,
−
-1              AS CALLING_LIST_CFG_DBID,
+
  -1              AS CALLING_LIST_CFG_DBID,
−
-1              AS START_TS,
+
  -1              AS START_TS,
−
-1              AS END_TS
+
  -1              AS END_TS
−
FROM dual
+
  FROM dual
−
 
+
 
−
</source>
+
  </source>
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = CALLING_LIST_KEY
 
|colName = CALLING_LIST_KEY
−
|colDesc =   The primary key of this view and the surrogate key that is used to join the CALLING_LIST dimension to the fact tables.  
+
|colDesc = The primary key of this view and the surrogate key that is used to join the CALLING_LIST dimension to the fact tables.
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = TENANT_KEY
 
|colName = TENANT_KEY
−
|colDesc = The surrogate key that is used to join to the TENANT dimension.
+
|colDesc = The surrogate key that is used to join the TENANT dimension to the fact tables.
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = CALLING_LIST_NAME
 
|colName = CALLING_LIST_NAME
−
|colDesc =   The name of the calling list.  
+
|colDesc = The name of the calling list.
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = CREATE_AUDIT_KEY
 
|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.
+
|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 &mdash; that is, applications that need to identify newly added data.
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = UPDATE_AUDIT_KEY
 
|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.
+
|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 &mdash; that is, applications that need to identify recently modified data.
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = DESCRIPTION
 
|colName = DESCRIPTION
−
|colDesc =   The description of the calling list.  
+
|colDesc = The description of the calling list.
 
}}
 
}}
  
 
{{PDMViewColumn
 
{{PDMViewColumn
 
|colName = CALLING_LIST_CFG_DBID
 
|colName = CALLING_LIST_CFG_DBID
−
|colDesc =   The calling list object identifier in the contact center configuration.  
+
|colDesc = The calling list object identifier in the contact center configuration.
 
}}
 
}}
  
Line 91: Line 90:
 
|colName = END_TS
 
|colName = END_TS
 
|colDesc = The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.
 
|colDesc = The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration.
−
}}
 
−
 
−
{{PDMRef
 
−
|parentView = CALLING_LIST
 
−
|foreignKey = CALLING_LIST_KEY
 
 
}}
 
}}
  
 
{{PDMRef
 
{{PDMRef
 
|parentView = TENANT
 
|parentView = TENANT
 +
|parentColumn = TENANT_KEY
 
|foreignKey = TENANT_KEY
 
|foreignKey = TENANT_KEY
 
}}
 
}}
Line 105: Line 100:
 
{{PDMRef
 
{{PDMRef
 
|parentTable = CTL_AUDIT_LOG
 
|parentTable = CTL_AUDIT_LOG
 +
|parentColumn = AUDIT_KEY
 
|foreignKey = CREATE_AUDIT_KEY
 
|foreignKey = CREATE_AUDIT_KEY
 
}}
 
}}
Line 110: Line 106:
 
{{PDMRef
 
{{PDMRef
 
|parentTable = CTL_AUDIT_LOG
 
|parentTable = CTL_AUDIT_LOG
 +
|parentColumn = AUDIT_KEY
 
|foreignKey = UPDATE_AUDIT_KEY
 
|foreignKey = UPDATE_AUDIT_KEY
−
}}
+
}}
−
 
 
−
 
 
−
 
 
−
</onlyinclude>
 
  
−
[[Category:V:GIM:8.5DRAFT]]
+
 
 +
  </onlyinclude>
 +
 
 +
  [[Category:V:GIM:8.5DRAFT]]

Latest revision as of 22:39, June 16, 2020

View CALLING_LIST

Description

Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list.

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.


References

The summary List of References will include the following entries for this table or view:


Child Table/View Child Table/View Column Parent Table/View Parent Table/View Column
CALLING_LIST CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CALLING_LIST CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CALLING_LIST TENANT_KEY TENANT TENANT_KEY
CALLING_LIST TENANT_KEY TENANT TENANT_KEY
CALLING_LIST UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CALLING_LIST UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY



Description

Allows facts to be described based on attributes of an outbound campaign calling list. Each row describes one calling list.

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.


References

The summary List of References will include the following entries for this table or view:


Child Table/View Child Table/View Column Parent Table/View Parent Table/View Column
CALLING_LIST CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CALLING_LIST CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CALLING_LIST TENANT_KEY TENANT TENANT_KEY
CALLING_LIST TENANT_KEY TENANT TENANT_KEY
CALLING_LIST UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CALLING_LIST UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
This page was last edited on June 16, 2020, at 22:39.
Comments or questions about this documentation? Contact us for support!