Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.NoteForm_NAW_Audit
Touchworks 25.2
[dbo].[NoteForm_NAW_Audit]
MS_Description
v11 Note Audit log
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
NoteFormNAWHeaderID
[dbo].[uniqueid]
9
NOT NULL
Note form header. Link to Noteform_NAW_Instance_Header.HeaderID
NoteFormNAWInstanceID
[dbo].[uniqueid]
9
NOT NULL
Noteform version. Link to Noteform_NAW_Instance.InstanceID
ModifiedByID
[dbo].[uniqueid]
9
NOT NULL
Link to IDX_User.ID (who performed the audit action)
ModificationAction
varchar(25)
25
NOT NULL
The user action on the note (e.g. Entered, Finalized, Signed, Updated, Deleted, Invalidated, etc.)
ModificationComment
varchar(max)
max
NULL allowed
Audit detail represented in XML format
ModificationDTTM
datetime
8
NOT NULL
When the audit row was in inserted
FormID
varchar(255)
255
NOT NULL
If applicable, points to the form in NoteForm_Library.UFormID
ModificationCommentCompressed
varbinary(max)
max
NULL allowed
The compressed ModificationComment (to reduce storage consumption)