Expand All Collapse All
Survey Configuration Log

SurveyConfigLog Table

Survey Configuration Log

The SurveyConfigLog table consists of changes made to surveys. It holds at most two years of data.

  • Table Type - Historical
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ConfigChangeObjectType int False No

The part of the survey that was changed, e.g. question, prompt, rule (See the following Explanation of ConfigChangeObjectType.)

 4.0.106.453 4.0 Release Config Change Object Type Fact CSSurvey
ConfigChangeType int False No

The type of change made to a survey, e.g. Add, Update, Delete. (See the following Explanation of ConfigChangeType.)

 4.0.106.453 4.0 Release Config Change Type Fact CSSurvey
ConfigTimeStampUTC datetime False No

UTC timestamp for the event

 4.0.106.453 4.0 Release Config Time Stamp UTC Attribute CSSurvey
Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ConfigChangeObjectType integer False No

The part of the survey that was changed, e.g. question, prompt, rule (See the following Explanation of ConfigChangeObjectType.)

 4.0.106.453 4.0 Release
ConfigChangeType integer False No

The type of change made to a survey, e.g. Add, Update, Delete. (See the following Explanation of ConfigChangeType.)

 4.0.106.453 4.0 Release
ConfigTimeStampUTC timestamp False No

UTC timestamp for the event

 4.0.106.453 4.0 Release

Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyConfigLog Clustered ConfigTimeStampUTC (Ascending)
ConfigChangeType (Ascending)
ConfigChangeObjectType (Ascending)

Primary Key Name Column Name (sort order)
PK_SurveyConfigLog ConfigTimeStampUTC (Ascending)
ConfigChangeType (Ascending)
ConfigChangeObjectType (Ascending)