IWPAudit Table
-
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 |
| 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 |
| 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 |
raw (16) |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| EventType |
smallint |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| ObjectType |
smallint |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| ObjectId |
raw (16) |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| ObjectName |
nvarchar2 (48) |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| AuditTimeUTC |
date |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| AuditTimeOffset |
smallint |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| OrganizationId |
raw (16) |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| OrganizationName |
nvarchar2 (48) |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| SiteId |
smallint |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| IndivId |
char (22) |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| ICUserId |
nvarchar2 (50) |
False |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| ResultCode |
smallint |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| ResultText |
nvarchar2 (256) |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
| Notes |
nvarchar2 (256) |
True |
Unknown |
|
4.0.106.453 |
4.0 Release |
|
|
|
Constraints
| Primary Key Name |
Type |
Column Name (sort order) |
| PK_IWPAudit |
Clustered |
AuditId (Ascending)
|
| Primary Key Name |
Column Name (sort order) |
| PK_IWPAudit |
AuditId (Ascending)
|