(Created target blank page For Version: PSAAS:Julie) |
(Automated save: adding PEC_Migrated template.) |
||
Line 1: | Line 1: | ||
− | < | + | = View CAMPAIGN = |
+ | |||
+ | {{Template:PEC_Migrated}} | ||
+ | |||
+ | |||
+ | |||
+ | <onlyinclude> | ||
+ | |||
+ | |||
+ | {{PDMView | ||
+ | |viewName = CAMPAIGN | ||
+ | |shortDesc = Allows facts to be described based on attributes of an outbound campaign. | ||
+ | |viewDesc = Allows facts to be described based on attributes of an outbound campaign. Each row describes one campaign. | ||
+ | |subjectAreas=Calling_List_To_Campaign | ||
+ | |introduced = | ||
+ | |SQL = <source lang="xml" enclose="div">select | ||
+ | ID AS CAMPAIGN_KEY, | ||
+ | TENANTID AS TENANT_KEY, | ||
+ | NAME AS CAMPAIGN_NAME, | ||
+ | CREATE_AUDIT_KEY AS CREATE_AUDIT_KEY, | ||
+ | UPDATE_AUDIT_KEY AS UPDATE_AUDIT_KEY, | ||
+ | DESCRIPTION AS DESCRIPTION, | ||
+ | ID AS CAMPAIGN_CFG_DBID, | ||
+ | CREATED_TS AS START_TS, | ||
+ | DELETED_TS AS END_TS | ||
+ | FROM GIDB_GC_CAMPAIGN | ||
+ | UNION ALL | ||
+ | SELECT | ||
+ | -1 AS CAMPAIGN_KEY, | ||
+ | -1 AS TENANT_KEY, | ||
+ | 'UNKNOWN' AS CAMPAIGN_NAME, | ||
+ | -1 AS CREATE_AUDIT_KEY, | ||
+ | -1 AS UPDATE_AUDIT_KEY, | ||
+ | 'UNKNOWN' AS DESCRIPTION, | ||
+ | 1 AS CAMPAIGN_CFG_DBID, | ||
+ | 1 AS START_TS, | ||
+ | 1 AS END_TS | ||
+ | FROM dual | ||
+ | UNION ALL | ||
+ | SELECT | ||
+ | -2 AS CAMPAIGN_KEY, | ||
+ | -1 AS TENANT_KEY, | ||
+ | 'NO_VALUE' AS CAMPAIGN_NAME, | ||
+ | -1 AS CREATE_AUDIT_KEY, | ||
+ | -1 AS UPDATE_AUDIT_KEY, | ||
+ | 'NO_VALUE' AS DESCRIPTION, | ||
+ | 1 AS CAMPAIGN_CFG_DBID, | ||
+ | 1 AS START_TS, | ||
+ | 1 AS END_TS | ||
+ | FROM dual | ||
+ | |||
+ | </source> | ||
+ | }} | ||
+ | |||
+ | {{PDMViewColumn | ||
+ | |colName = CAMPAIGN_KEY | ||
+ | |colDesc = The surrogate key that is used to join the CAMPAIGN dimension to the fact tables. | ||
+ | }} | ||
+ | |||
+ | {{PDMViewColumn | ||
+ | |colName = TENANT_KEY | ||
+ | |colDesc = The surrogate key that is used to join the TENANT dimension to the fact tables. | ||
+ | }} | ||
+ | |||
+ | {{PDMViewColumn | ||
+ | |colName = CAMPAIGN_NAME | ||
+ | |colDesc = The name of the campaign object in Configuration Server. | ||
+ | }} | ||
+ | |||
+ | {{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 = DESCRIPTION | ||
+ | |colDesc = The description of the campaign. | ||
+ | }} | ||
+ | |||
+ | {{PDMViewColumn | ||
+ | |colName = CAMPAIGN_CFG_DBID | ||
+ | |colDesc = The campaign object identifier in contact center configuration. | ||
+ | }} | ||
+ | |||
+ | {{PDMViewColumn | ||
+ | |colName = START_TS | ||
+ | |colDesc = 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. | ||
+ | }} | ||
+ | |||
+ | {{PDMViewColumn | ||
+ | |colName = END_TS | ||
+ | |colDesc = The UTC-equivalent value of the date and time when the campaign object was removed from contact center configuration. | ||
+ | }} | ||
+ | |||
+ | {{PDMRef | ||
+ | |parentView = CAMPAIGN | ||
+ | |foreignKey = CAMPAIGN_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:PSAAS:Julie]] |
Latest revision as of 01:21, June 22, 2020
View CAMPAIGN
Important
This content may not be the latest Genesys Engage cloud content. To find the latest content, go to Reporting in Genesys Engage cloud.
No results
This page was last edited on June 22, 2020, at 01:21.
Comments or questions about this documentation? Contact us for support!