Expand All Collapse All

IR_Audit 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 No

4.0.106.453 4.0 Release
Id uniqueidentifier False No

4.0.106.453 4.0 Release
AuditDate datetime False No

4.0.106.453 4.0 Release
AuditDateOffset int False No

4.0.106.453 4.0 Release
AuditOperation smallint False No

4.0.106.453 4.0 Release
IndivId char (22) True Yes

4.0.106.453 4.0 Release
ICUID nvarchar (255) True Yes

4.0.106.453 4.0 Release
AuditedName nvarchar (255) True Yes

4.0.106.453 4.0 Release
Comments nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release

SQL Constraints

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

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_Audit_IndivId IndivId Individual IndivID Yes

Index Name Type Column Name (sort order)
IX_IR_Audit_AuditOperation Non-clustered AuditOperation (Ascending)
IX_IR_Audit_Id Non-clustered Id (Ascending)
IX_IR_Audit_IndivId Non-clustered IndivId (Ascending)