Jump to: navigation, search
m (1 revision imported: Cleaned up for It. 6)
Line 1: Line 1:
 
= View GROUP_ =
 
= View GROUP_ =
−
 
+
 
−
  <onlyinclude>
+
<onlyinclude>
−
 
+
 
−
 
+
 
−
  {{PDMView
+
{{PDMView
−
  |viewName = GROUP_
+
|viewName = GROUP_
−
  |shortDesc =  Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
+
|shortDesc =  Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
−
  |viewDesc =  Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. Routing points, queues, and agents can belong to resource groups. Places can belong to place groups. Each row describes one place group or resource group. A new row is issued for each configured place group and resource group, which is identified by its ID in the contact center configuration. Changing a group name causes an update to an existing row. Deleting a group and re-creating it under the same name causes a new row to be issued.
+
|viewDesc =  Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. Routing points, queues, and agents can belong to resource groups. Places can belong to place groups. Each row describes one place group or resource group. A new row is issued for each configured place group and resource group, which is identified by its ID in the contact center configuration. Changing a group name causes an update to an existing row. Deleting a group and re-creating it under the same name causes a new row to be issued.
−
 
+
 
−
  <!-- <font color=red>'''Writer's note to self:''' This is the page created on April 25 from the word-processed XML file (i.e., space-from-underscore removed from page title element). Confirm it is the page that gets linked to from the l-h navigation pane and from the Ponydocs TOC, and that there's no ghost GROUP_ page.</font>-->
+
<!-- <font color=red>'''Writer's note to self:''' This is the page created on April 25 from the word-processed XML file (i.e., space-from-underscore removed from page title element). Confirm it is the page that gets linked to from the l-h navigation pane and from the Ponydocs TOC, and that there's no ghost GROUP_ page.</font>-->
−
  |introduced =   
+
|introduced =   
−
  |SQL =  <source lang="xml" enclose="div">SELECT
+
|SQL =  <source lang="xml" enclose="div">SELECT
−
  ID      AS GROUP_KEY,
+
ID      AS GROUP_KEY,
−
  TENANTID AS TENANT_KEY,
+
TENANTID AS TENANT_KEY,
−
  NAME    AS GROUP_NAME,
+
NAME    AS GROUP_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,
−
  CASE TYPE
+
CASE TYPE
−
  WHEN 0 THEN 'Unknown'
+
WHEN 0 THEN 'Unknown'
−
  WHEN 1 THEN 'Agent'
+
WHEN 1 THEN 'Agent'
−
  WHEN 2 THEN 'Place'
+
WHEN 2 THEN 'Place'
−
  WHEN 3 THEN
+
WHEN 3 THEN
−
  CASE DNGROUPTYPE
+
CASE DNGROUPTYPE
−
  WHEN 0 THEN 'Unknown'
+
WHEN 0 THEN 'Unknown'
−
  WHEN 1 THEN 'Single Port'
+
WHEN 1 THEN 'Single Port'
−
  WHEN 2 THEN 'Queue'
+
WHEN 2 THEN 'Queue'
−
  WHEN 3 THEN 'RoutingPoint'
+
WHEN 3 THEN 'RoutingPoint'
−
  WHEN 4 THEN 'Network Port'
+
WHEN 4 THEN 'Network Port'
−
  WHEN 5 THEN 'Service Number'
+
WHEN 5 THEN 'Service Number'
−
  ELSE 'Unknown'
+
ELSE 'Unknown'
−
  END
+
END
−
  ELSE 'Unknown'
+
ELSE 'Unknown'
−
  END AS GROUP_TYPE,
+
END AS GROUP_TYPE,
−
  CASE TYPE
+
CASE TYPE
−
  WHEN 0 THEN 'UNKNOWN'
+
WHEN 0 THEN 'UNKNOWN'
−
  WHEN 1 THEN 'AGENT'
+
WHEN 1 THEN 'AGENT'
−
  WHEN 2 THEN 'PLACE'
+
WHEN 2 THEN 'PLACE'
−
  WHEN 3 THEN
+
WHEN 3 THEN
−
  CASE DNGROUPTYPE
+
CASE DNGROUPTYPE
−
  WHEN 0 THEN 'UNKNOWN'
+
WHEN 0 THEN 'UNKNOWN'
−
  WHEN 1 THEN 'SINGLEPORT'
+
WHEN 1 THEN 'SINGLEPORT'
−
  WHEN 2 THEN 'QUEUE'
+
WHEN 2 THEN 'QUEUE'
−
  WHEN 3 THEN 'ROUTINGPOINT'
+
WHEN 3 THEN 'ROUTINGPOINT'
−
  WHEN 4 THEN 'NETWORKPORT'
+
WHEN 4 THEN 'NETWORKPORT'
−
  WHEN 5 THEN 'SERVICENUMBER'
+
WHEN 5 THEN 'SERVICENUMBER'
−
  ELSE 'UNKNOWN'
+
ELSE 'UNKNOWN'
−
  END
+
END
−
  ELSE 'UNKNOWN'
+
ELSE 'UNKNOWN'
−
  END AS GROUP_TYPE_CODE,
+
END AS GROUP_TYPE_CODE,
−
  ID      AS GROUP_CFG_DBID,
+
ID      AS GROUP_CFG_DBID,
−
  TYPE    AS GROUP_CFG_TYPE_ID,
+
TYPE    AS GROUP_CFG_TYPE_ID,
−
  CREATED_TS  AS START_TS,
+
CREATED_TS  AS START_TS,
−
  DELETED_TS  AS END_TS
+
DELETED_TS  AS END_TS
−
  FROM GIDB_GC_GROUP
+
FROM GIDB_GC_GROUP
−
  UNION ALL
+
UNION ALL
−
  SELECT
+
SELECT
−
  -1          AS GROUP_KEY,
+
-1          AS GROUP_KEY,
−
  -1          AS TENANT_KEY,
+
-1          AS TENANT_KEY,
−
  'UNKNOWN'    AS GROUP_NAME,
+
'UNKNOWN'    AS GROUP_NAME,
−
  -1          AS CREATE_AUDIT_KEY,
+
-1          AS CREATE_AUDIT_KEY,
−
  -1          AS UPDATE_AUDIT_KEY,
+
-1          AS UPDATE_AUDIT_KEY,
−
  'UNKNOWN'  AS GROUP_TYPE,
+
'UNKNOWN'  AS GROUP_TYPE,
−
  'UNKNOWN'  AS GROUP_TYPE_CODE,
+
'UNKNOWN'  AS GROUP_TYPE_CODE,
−
  -1          AS GROUP_CFG_DBID,
+
-1          AS GROUP_CFG_DBID,
−
  -1          AS GROUP_CFG_TYPE_ID,
+
-1          AS GROUP_CFG_TYPE_ID,
−
  -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 GROUP_KEY,
+
-2          AS GROUP_KEY,
−
  -1          AS TENANT_KEY,
+
-1          AS TENANT_KEY,
−
  'No Group'  AS GROUP_NAME,
+
'No Group'  AS GROUP_NAME,
−
  -1          AS CREATE_AUDIT_KEY,
+
-1          AS CREATE_AUDIT_KEY,
−
  -1          AS UPDATE_AUDIT_KEY,
+
-1          AS UPDATE_AUDIT_KEY,
−
  'NO_VALUE'  AS GROUP_TYPE,
+
'NO_VALUE'  AS GROUP_TYPE,
−
  'NO_VALUE'  AS GROUP_TYPE_CODE,
+
'NO_VALUE'  AS GROUP_TYPE_CODE,
−
  -1          AS GROUP_CFG_DBID,
+
-1          AS GROUP_CFG_DBID,
−
  -1          AS GROUP_CFG_TYPE_ID,
+
-1          AS GROUP_CFG_TYPE_ID,
−
  -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 = GROUP_KEY
+
|colName = GROUP_KEY
−
  |colDesc =  The primary key of this view that is used to join the GROUP_ dimension to the fact tables.
+
|colDesc =  The primary key of this view that is used to join the GROUP_ dimension to the fact tables.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = TENANT_KEY
+
|colName = TENANT_KEY
−
  |colDesc = The surrogate key that is used to join the TENANT dimension to the fact tables.
+
|colDesc = The surrogate key that is used to join the TENANT dimension to the fact tables.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = GROUP_NAME
+
|colName = GROUP_NAME
−
  |colDesc =  The group name.
+
|colDesc =  The group name.
−
  }}
+
}}
−
 
+
 
−
  {{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 &mdash; 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 &mdash; 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 = GROUP_TYPE
+
|colName = GROUP_TYPE
−
  |colDesc =  The group type. This field is set to one of the following values:
+
|colDesc =  The group type. This field is set to one of the following values:
−
  * Unknown
+
* Unknown
−
  * Agent
+
* Agent
−
  * Place
+
* Place
−
  * Queue
+
* Queue
−
  * RoutingPoint
+
* RoutingPoint
−
  * Network Port
+
* Network Port
−
  * Service Number
+
* Service Number
−
  * Single Port
+
* Single Port
−
 
+
 
−
  This value can change with localization.
+
This value can change with localization.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = GROUP_TYPE_CODE
+
|colName = GROUP_TYPE_CODE
−
  |colDesc =  The group type code. This field is set to one of the following values:
+
|colDesc =  The group type code. This field is set to one of the following values:
−
 
+
 
−
  * UNKNOWN
+
* UNKNOWN
−
  * AGENT
+
* AGENT
−
  * PLACE
+
* PLACE
−
  * QUEUE
+
* QUEUE
−
  * ROUTINGPOINT
+
* ROUTINGPOINT
−
  * NETWORKPORT
+
* NETWORKPORT
−
  * SERVICENUMBER
+
* SERVICENUMBER
−
  * SINGLEPORT
+
* SINGLEPORT
−
 
+
 
−
  This value does not change with localization.
+
This value does not change with localization.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = GROUP_CFG_DBID
+
|colName = GROUP_CFG_DBID
−
  |colDesc =  The group object identifier in the contact center configuration.
+
|colDesc =  The group object identifier in the contact center configuration.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = GROUP_CFG_TYPE_ID
+
|colName = GROUP_CFG_TYPE_ID
−
  |colDesc =  The contact center configuration integer type that is associated with the DN or agent group object.
+
|colDesc =  The contact center configuration integer type that is associated with the DN or agent group object.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = START_TS
+
|colName = START_TS
−
  |colDesc = The UTC-equivalent value of the date and time when the group was added to IDB, which may differ from when the group was actually added to contact center configuration.
+
|colDesc = The UTC-equivalent value of the date and time when the group was added to IDB, which may differ from when the group was actually added to contact center configuration.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = END_TS
+
|colName = END_TS
−
  |colDesc = The UTC-equivalent value of the date and time when the group was removed from contact center configuration.
+
|colDesc = The UTC-equivalent value of the date and time when the group was removed from contact center configuration.
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentView = GROUP_
+
|parentView = GROUP_
−
  |foreignKey = GROUP_KEY
+
|foreignKey = GROUP_KEY
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentView = TENANT
+
|parentView = TENANT
−
  |foreignKey = TENANT_KEY
+
|foreignKey = TENANT_KEY
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentTable = CTL_AUDIT_LOG
+
|parentTable = CTL_AUDIT_LOG
−
  |foreignKey = CREATE_AUDIT_KEY
+
|foreignKey = CREATE_AUDIT_KEY
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentTable = CTL_AUDIT_LOG
+
|parentTable = CTL_AUDIT_LOG
−
  |foreignKey = UPDATE_AUDIT_KEY
+
|foreignKey = UPDATE_AUDIT_KEY
−
  }}
+
}}
−
 
+
 
−
 
+
 
−
  </onlyinclude>
+
</onlyinclude>
−
 
+
 
−
  [[Category:V:GIM:8.5DRAFT]]
+
[[Category:V:GIM:8.5DRAFT]]

Revision as of 17:41, August 18, 2016

View GROUP_

Description

Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups. Routing points, queues, and agents can belong to resource groups. Places can belong to place groups. Each row describes one place group or resource group. A new row is issued for each configured place group and resource group, which is identified by its ID in the contact center configuration. Changing a group name causes an update to an existing row. Deleting a group and re-creating it under the same name causes a new row to be issued.

Column List

Column Description
GROUP_KEY The primary key of this view that is used to join the GROUP_ dimension to the fact tables.
TENANT_KEY The surrogate key that is used to join the TENANT dimension to the fact tables.
GROUP_NAME The group 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.
GROUP_TYPE The group type. This field is set to one of the following values:
  • Unknown
  • Agent
  • Place
  • Queue
  • RoutingPoint
  • Network Port
  • Service Number
  • Single Port
This value can change with localization.
GROUP_TYPE_CODE The group type code. This field is set to one of the following values:
  • UNKNOWN
  • AGENT
  • PLACE
  • QUEUE
  • ROUTINGPOINT
  • NETWORKPORT
  • SERVICENUMBER
  • SINGLEPORT
This value does not change with localization.
GROUP_CFG_DBID The group object identifier in the contact center configuration.
GROUP_CFG_TYPE_ID The contact center configuration integer type that is associated with the DN or agent group object.
START_TS The UTC-equivalent value of the date and time when the group was added to IDB, which may differ from when the group was actually added to contact center configuration.
END_TS The UTC-equivalent value of the date and time when the group 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
GROUP_ CREATE_AUDIT_KEY CTL_AUDIT_LOG TENANT_KEY
GROUP_ TENANT_KEY TENANT TENANT_KEY
GROUP_ UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
Comments or questions about this documentation? Contact us for support!