View RESOURCE_GROUP_FACT
Description
Each row describes the membership of one resource (routing point, queue, or agent) in one resource group. The grain of the fact is an accumulating snapshot that represents the duration of the configured membership, which is identified by its ID in the configuration database.
Column List
Column | Description |
---|---|
RESOURCE_GROUP_FACT_KEY | The primary key of this view. |
START_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the resource was added to the resource group in the contact center configuration. 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. |
END_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the resource was removed from the resource group in the contact center configuration. 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 END_TS timestamp to an appropriate time zone. |
TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
RESOURCE_KEY | The surrogate key that is used to join the RESOURCE_ dimension to the fact tables. |
GROUP_KEY | The surrogate key that is used to join the GROUP_ dimension to the fact tables. |
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. |
START_TS | The UTC-equivalent value of the date and time when the resource was added to the resource group in the contact center configuration. |
END_TS | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, the UTC-equivalent value of the date and time when the resource was removed from the resource group in the contact center configuration. For an active row, this value represents a UTC-equivalent value of the date and time far in the future, so that applications do not have to test for null. |
TOTAL_DURATION | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this value represents the total duration, in seconds, that the resource was a member of the resource group. For an active row, this value represents the duration, in seconds, that the resource has been a member of the resource group, from start time to the time that the ETL last executed. |
ACTIVE_FLAG | Indicates whether the resource is currently a member of the resource group: 0 = No, 1 = Yes. |
PURGE_FLAG | This field is reserved. |
This page was last edited on June 22, 2022, at 23:58.
Comments or questions about this documentation? Contact us for support!