Jump to: navigation, search
m (1 revision imported: Some parameters changed for consistent camelCase usage)
m (1 revision imported: Some parameters changed for consistent camelCase usage)
Line 1: Line 1:
 
= View SKILL =
 
= View SKILL =
  
 +
 +
 +
{{PDMView
 +
|viewName = SKILL
 +
|shortDesc =
 +
|viewDesc =
 +
|introduced =
 +
|SQL =  <source lang="xml">select
 +
ID              AS SKILL_KEY,
 +
TENANTID        AS TENANT_KEY,
 +
NAME            AS SKILL_NAME,
 +
CREATE_AUDIT_KEY AS CREATE_AUDIT_KEY,
 +
UPDATE_AUDIT_KEY AS UPDATE_AUDIT_KEY,
 +
ID              AS SKILL_CFG_DBID,
 +
CREATED_TS      AS START_TS,
 +
DELETED_TS      AS END_TS
 +
FROM GIDB_GC_SKILL
 +
UNION ALL
 +
SELECT
 +
-1              AS SKILL_KEY,
 +
-1              AS TENANT_KEY,
 +
'UNKNOWN'        AS SKILL_NAME,
 +
-1              AS CREATE_AUDIT_KEY,
 +
-1              AS UPDATE_AUDIT_KEY,
 +
-1              AS SKILL_CFG_DBID,
 +
-1              AS START_TS,
 +
-1              AS END_TS
 +
FROM dual
 +
UNION ALL
 +
SELECT
 +
-2              AS SKILL_KEY,
 +
-1              AS TENANT_KEY,
 +
'NO_VALUE'      AS SKILL_NAME,
 +
-1              AS CREATE_AUDIT_KEY,
 +
-1              AS UPDATE_AUDIT_KEY,
 +
-1              AS SKILL_CFG_DBID,
 +
-1              AS START_TS,
 +
-1              AS END_TS
 +
FROM dual
 +
 +
</source>
 +
}}
 +
 +
{{PDMViewColumn
 +
|colName = SKILL_KEY
 +
|colDesc =
 +
}}
 +
 +
{{PDMViewColumn
 +
|colName = TENANT_KEY
 +
|colDesc = The surrogate key that is used to join to the TENANT dimension.
 +
}}
 +
 +
{{PDMViewColumn
 +
|colName = SKILL_NAME
 +
|colDesc =
 +
}}
 +
 +
{{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 = SKILL_CFG_DBID
 +
|colDesc =
 +
}}
 +
 +
{{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.
 +
}}
 +
 +
{{PDMRef
 +
|parenttable = SKILL
 +
|foreignKey = SKILL_KEY
 +
}}
 +
 +
{{PDMRef
 +
|parentview = TENANT
 +
|foreignKey = TENANT_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]]
 
[[Category:V:GIM:8.5DRAFT]]

Revision as of 09:05, April 23, 2016

View SKILL

Description

Allows facts to be described by the attributes of a skill. Each row describes one skill. A new row is issued for each configured skill, identified by its ID in the contact center configuration. Changing a skill name causes an update to an existing row. Deleting a skill and re-creating it under the same name causes a new row to be issued.

Column List

Column Description
SKILL_KEY The primary key of this view and the surrogate key that is used to join the SKILL dimension to the fact tables.
TENANT_KEY The surrogate key that is used to join the TENANT dimension to the fact tables.
SKILL_NAME The skill name.
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.
SKILL_CFG_DBID The skill object identifier in the contact center configuration.
START_TS The UTC-equivalent value of the date and time when the skill was added to IDB, which may differ from when the skill was actually added to contact center configuration.
END_TS The UTC-equivalent value of the date and time when the skill 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
SKILL CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
SKILL TENANT_KEY TENANT TENANT_KEY
SKILL UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
Comments or questions about this documentation? Contact us for support!