Expand All Collapse All

IWPAudit Table

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

SQL 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
AuditId uniqueidentifier False Unknown

4.0.106.453 4.0 Release Audit Id Attribute Interaction Web Portal
EventType smallint False Unknown

4.0.106.453 4.0 Release Event Type Attribute Interaction Web Portal
ObjectType smallint False Unknown

4.0.106.453 4.0 Release Object Type Attribute Interaction Web Portal
ObjectId uniqueidentifier True Unknown

4.0.106.453 4.0 Release Object Id Attribute Interaction Web Portal
ObjectName nvarchar (48) True Unknown

4.0.106.453 4.0 Release Object Name Attribute Interaction Web Portal
AuditTimeUTC datetime False Unknown

4.0.106.453 4.0 Release Audit Time UTC Attribute Interaction Web Portal
AuditTimeOffset smallint False Unknown

4.0.106.453 4.0 Release Audit Time Offset Attribute Interaction Web Portal
OrganizationId uniqueidentifier True Unknown

4.0.106.453 4.0 Release Organization Id Attribute Interaction Web Portal
OrganizationName nvarchar (48) True Unknown

4.0.106.453 4.0 Release Organization Name Attribute Interaction Web Portal
SiteId smallint False Unknown

4.0.106.453 4.0 Release Site Id Attribute Interaction Web Portal
IndivId char (22) False Unknown

4.0.106.453 4.0 Release Indiv Id Attribute Interaction Web Portal
ICUserId nvarchar (50) False Unknown

4.0.106.453 4.0 Release IC User Id Attribute Interaction Web Portal
ResultCode smallint True Unknown

4.0.106.453 4.0 Release Result Code Attribute Interaction Web Portal
ResultText nvarchar (256) True Unknown

4.0.106.453 4.0 Release Result Text Attribute Interaction Web Portal
Notes nvarchar (256) True Unknown

4.0.106.453 4.0 Release Notes Attribute Interaction Web Portal

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IWPAudit Clustered AuditId (Ascending)