Cargo query
Showing below up to 100 results in range #101 to #200.
View (previous 100 | next 100) (20 | 50 | 100 | 250 | 500)
| Page | colName | colDesc |
|---|---|---|
| Draft:PEC-REP/Library/PDMLibraryGIM/View-GROUP TO CAMPAIGN FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | END_TS | The UTC-equivalent value of the date and time when the place object was removed from contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | PLACE_CFG_DBID | The place object identifier in the contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | PLACE_KEY | The primary key of this view and the surrogate key that is used to join the PLACE dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | PLACE_NAME | The place name. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | START_TS | The UTC-equivalent value of the date and time when the place object was added to IDB, which may differ from when the place was actually added to contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | TENANT_KEY | The surrogate key that is used to join to the TENANT dimension. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | ACTIVE_FLAG | Indicates whether the place is currently a member of the place group: 0 = No, 1 = Yes. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | END_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the place was removed from the place 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | 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 place was removed from the place 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | GROUP_KEY | The surrogate key that is used to join the GROUP_ dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | PLACE_GROUP_FACT_KEY | The primary key of this view. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | PLACE_KEY | The surrogate key that is used to join the PLACE dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | PURGE_FLAG | This field is reserved. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | START_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the place was added to the place 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | START_TS | The UTC-equivalent value of the date and time when the place was added to the place group in the contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | 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 place was a member of the place group. For an active row, this value represents the duration, in seconds, that the place has been a member of the place group, from start time to the time that the ETL last executed. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-PLACE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | ACTIVE_FLAG | Indicates whether the resource is currently a member of the resource group: 0 = No, 1 = Yes. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | GROUP_KEY | The surrogate key that is used to join the GROUP_ dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | PURGE_FLAG | This field is reserved. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | RESOURCE_GROUP_FACT_KEY | The primary key of this view. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | RESOURCE_KEY | The surrogate key that is used to join the RESOURCE_ dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE GROUP FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | ACTIVE_FLAG | Indicates whether the resource currently has the skill at the specified level: 0 = No, 1 = Yes. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | END_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the skill at the specified level was removed from the resource 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 related to the same interval and/or convert the END_TS timestamp to an appropriate time zone. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | 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 skill, at the specified level, was removed from the resource in 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | PURGE_FLAG | This field is reserved. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | RESOURCE_KEY | The surrogate key that is used to join the RESOURCE_ dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | RESOURCE_SKILL_FACT_KEY | The primary key of this view. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | SKILL_KEY | The surrogate key that is used to join the SKILL dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | SKILL_LEVEL | The skill level or proficiency. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | START_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the skill at the specified level was added to the resource 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | START_TS | The UTC-equivalent value of the date and time when the skill, at the specified level, was added to the resource in the contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | TOTAL_DURATION | The meaning depends on the value of ACTIVE_FLAG. For an inactive row, this field represents the total duration, in seconds, that the resource had the skill at the specified level. For an active row, this field represents the duration, in seconds, that the resource has had the skill at the specified level, from start time to the time that the ETL last executed. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-RESOURCE SKILL FACT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | END_TS | The UTC-equivalent value of the date and time when the skill was removed from contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | SKILL_CFG_DBID | The skill object identifier in the contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | SKILL_KEY | The primary key of this view and the surrogate key that is used to join the SKILL dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | SKILL_NAME | The skill name. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-SKILL | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | 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. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | END_TS | The UTC-equivalent value of the date and time when the tenant was removed from contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | START_TS | The UTC-equivalent value of the date and time when the tenant was added to IDB, which may differ from when the tenant was actually added to contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | TENANT_CFG_DBID | The tenant object identifier in the contact center configuration. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | TENANT_KEY | The primary key of this view and the surrogate key that is used to join the TENANT dimension to the fact tables. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | TENANT_NAME | The tenant name. |
| Draft:PEC-REP/Library/PDMLibraryGIM/View-TENANT | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST_CFG_DBID | The calling list object identifier in the contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | CALLING_LIST_NAME | The name of the calling list. |
| PEC-REP/Library/PDMLibraryGIM/View-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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | DESCRIPTION | The description of the calling list. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | END_TS | The UTC-equivalent value of the date and time when the calling list was removed from contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | ACTIVE_FLAG | Indicates whether the association between the calling list and the campaign is still active: 0 = No, 1 = Yes. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CALLING_LIST_KEY | The surrogate key that is used to join the CALLING_LIST dimension to the fact tables. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CALLING_LIST_TO_CAMP_FACT_KEY | The primary key of this view. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | CAMPAIGN_KEY | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | END_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the calling list was removed from the campaign. 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | 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 calling list was removed from the campaign 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | PURGE_FLAG | This field is reserved. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | START_DATE_TIME_KEY | Identifies the start of a 15-minute interval in which the calling list was added to the campaign. 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | START_TS | The UTC-equivalent value of the date and time when the calling list was added to the campaign in the contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | 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 calling list was associated with the campaign. For an active row, this value represents the duration, in seconds, that the calling list was associated with the campaign, from start time to the time that the ETL last executed. |
| PEC-REP/Library/PDMLibraryGIM/View-CALLING LIST TO CAMP FACT | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN_CFG_DBID | The campaign object identifier in contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN_KEY | The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | CAMPAIGN_NAME | The name of the campaign object in Configuration Server. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | DESCRIPTION | The description of the campaign. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | END_TS | The UTC-equivalent value of the date and time when the campaign object was removed from contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | START_TS | The UTC-equivalent value of the date and time when the campaign was added to IDB, which may differ from when the campaign was actually added to contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | TENANT_KEY | The surrogate key that is used to join the TENANT dimension to the fact tables. |
| PEC-REP/Library/PDMLibraryGIM/View-CAMPAIGN | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-GROUP | 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. |
| PEC-REP/Library/PDMLibraryGIM/View-GROUP | END_TS | The UTC-equivalent value of the date and time when the group was removed from contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_CFG_DBID | The group object identifier in the contact center configuration. |
| PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_CFG_TYPE_ID | The contact center configuration integer type that is associated with the DN or agent group object. |
| PEC-REP/Library/PDMLibraryGIM/View-GROUP | GROUP_KEY | The primary key of this view that is used to join the GROUP_ dimension to the fact tables. |