Cargo query
Showing below up to 20 results in range #101 to #120.
View (previous 20 | next 20) (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. |