Jump to: navigation, search
m (1 revision imported: Iteration 7 schema updates)
m (1 revision imported: Iteration 7 schema updates)
Line 4: Line 4:
 
    
 
    
 
    
 
    
−
  {{PDMView
+
{{PDMView
−
  |viewName = CAMPAIGN
+
|viewName = CAMPAIGN
−
  |shortDesc =  Allows facts to be described based on attributes of an outbound 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.
+
|viewDesc =  Allows facts to be described based on attributes of an outbound campaign. Each row describes one campaign.
 
|subjectAreas=Calling_List_To_Campaign
 
|subjectAreas=Calling_List_To_Campaign
−
  |introduced =   
+
|introduced =   
−
  |SQL =  <source lang="xml" enclose="div">select
+
|SQL =  <source lang="xml" enclose="div">select
 
   ID              AS CAMPAIGN_KEY,
 
   ID              AS CAMPAIGN_KEY,
 
   TENANTID        AS TENANT_KEY,
 
   TENANTID        AS TENANT_KEY,
Line 47: Line 47:
 
    
 
    
 
   </source>
 
   </source>
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = CAMPAIGN_KEY
+
|colName = CAMPAIGN_KEY
−
  |colDesc = The surrogate key that is used to join the CAMPAIGN dimension to the fact tables.
+
|colDesc = The surrogate key that is used to join the CAMPAIGN 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 = CAMPAIGN_NAME
+
|colName = CAMPAIGN_NAME
−
  |colDesc = The name of the campaign object in Configuration Server.
+
|colDesc = The name of the campaign object in Configuration Server.
−
  }}
+
}}
−
 
+
 
−
  {{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 = DESCRIPTION
+
|colName = DESCRIPTION
−
  |colDesc = The description of the campaign.
+
|colDesc = The description of the campaign.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = CAMPAIGN_CFG_DBID
+
|colName = CAMPAIGN_CFG_DBID
−
  |colDesc = The campaign object identifier in contact center configuration.
+
|colDesc = The campaign object identifier in contact center configuration.
−
  }}
+
}}
−
 
+
 
−
  {{PDMViewColumn
+
{{PDMViewColumn
−
  |colName = START_TS
+
|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.
+
|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
+
{{PDMViewColumn
−
  |colName = END_TS
+
|colName = END_TS
−
  |colDesc = The UTC-equivalent value of the date and time when the campaign object was removed from contact center configuration.
+
|colDesc = The UTC-equivalent value of the date and time when the campaign object was removed from contact center configuration.
−
  }}
+
}}
−
 
+
 
−
  {{PDMRef
+
{{PDMRef
−
  |parentView = CAMPAIGN
+
|parentView = TENANT
−
  |foreignKey = CAMPAIGN_KEY
+
|parentColumn = TENANT_KEY
−
  }}
+
|foreignKey = TENANT_KEY
−
 
+
}}
−
  {{PDMRef
+
 
−
  |parentView = TENANT
+
{{PDMRef
−
  |foreignKey = TENANT_KEY
+
|parentTable = CTL_AUDIT_LOG
−
  }}
+
|parentColumn = AUDIT_KEY
−
 
+
|foreignKey = CREATE_AUDIT_KEY
−
  {{PDMRef
+
}}
−
  |parentTable = CTL_AUDIT_LOG
+
 
−
  |foreignKey = CREATE_AUDIT_KEY
+
{{PDMRef
−
  }}
+
|parentTable = CTL_AUDIT_LOG
−
 
+
|parentColumn = AUDIT_KEY
−
  {{PDMRef
+
|foreignKey = UPDATE_AUDIT_KEY
−
  |parentTable = CTL_AUDIT_LOG
+
}}
−
  |foreignKey = UPDATE_AUDIT_KEY
 
−
  }}
 
 
    
 
    
 
    
 
    

Revision as of 10:15, August 31, 2017

View CAMPAIGN

Description

Allows facts to be described based on attributes of an outbound campaign. Each row describes one campaign.

Column List

Column Description
CAMPAIGN_KEY The surrogate key that is used to join the CAMPAIGN dimension to the fact tables.
TENANT_KEY The surrogate key that is used to join the TENANT dimension to the fact tables.
CAMPAIGN_NAME The name of the campaign object in Configuration Server.
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.
DESCRIPTION The description of the campaign.
CAMPAIGN_CFG_DBID The campaign object identifier in contact center configuration.
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.
END_TS The UTC-equivalent value of the date and time when the campaign object 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
CAMPAIGN CREATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
CAMPAIGN TENANT_KEY TENANT TENANT_KEY
CAMPAIGN UPDATE_AUDIT_KEY CTL_AUDIT_LOG AUDIT_KEY
Comments or questions about this documentation? Contact us for support!