Project
>
Touchworks
>
User databases
>
IntegratedScan
>
Tables
> dbo.Audit_Event_Type
Touchworks 25.2
[dbo].[Audit_Event_Type]
MS_Description
Event types that we can use in our AuditEvent table (ie ChartGroupAdd)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
smallint
2
NOT NULL
1 - 1
Key to the Audit_Event_Type table
Name
varchar(50)
50
NOT NULL
Name of the Event Type (ChartGroupAdd, AccessGroupDelete etc..)
Category
varchar(30)
30
NOT NULL
Category. Used to assist in Left Joins to various tables as ObjectID in Audit_Event is multipurpose.