Tables [dbo].[NoteForm_NAW_Audit]
v11 Note Audit log
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Key CIX_NoteForm_NAW_Audit_HdrID_ModDTTM_InstID_ModID_FormID: NoteFormNAWHeaderID\ModificationDTTM\NoteFormNAWInstanceID\ModifiedByID\FormIDIndexes NIX_NoteForm_NAW_Audit_NoteFormNAWHeaderIDForeign Keys FK_NoteForm_NAW_Audit_NoteForm_NAW_Instance_Header: [dbo].[NoteForm_NAW_Instance_Header].NoteFormNAWHeaderIDNoteFormNAWHeaderID[dbo].[uniqueid]9NOT NULLNote form header. Link to Noteform_NAW_Instance_Header.HeaderID
Cluster Key CIX_NoteForm_NAW_Audit_HdrID_ModDTTM_InstID_ModID_FormID: NoteFormNAWHeaderID\ModificationDTTM\NoteFormNAWInstanceID\ModifiedByID\FormIDForeign Keys FK_NoteForm_NAW_Audit_NoteForm_NAW_Instance: [dbo].[NoteForm_NAW_Instance].NoteFormNAWInstanceIDNoteFormNAWInstanceID[dbo].[uniqueid]9NOT NULLNoteform version. Link to Noteform_NAW_Instance.InstanceID
Cluster Key CIX_NoteForm_NAW_Audit_HdrID_ModDTTM_InstID_ModID_FormID: NoteFormNAWHeaderID\ModificationDTTM\NoteFormNAWInstanceID\ModifiedByID\FormIDForeign Keys FK_NoteForm_NAW_Audit_IDX_User: [dbo].[IDX_User].ModifiedByIDModifiedByID[dbo].[uniqueid]9NOT NULLLink to IDX_User.ID (who performed the audit action)
ModificationActionvarchar(25)25NOT NULLThe user action on the note (e.g. Entered, Finalized, Signed, Updated, Deleted, Invalidated, etc.)
ModificationCommentvarchar(max)maxNULL allowedAudit detail represented in XML format
Cluster Key CIX_NoteForm_NAW_Audit_HdrID_ModDTTM_InstID_ModID_FormID: NoteFormNAWHeaderID\ModificationDTTM\NoteFormNAWInstanceID\ModifiedByID\FormIDModificationDTTMdatetime8NOT NULLWhen the audit row was in inserted
Cluster Key CIX_NoteForm_NAW_Audit_HdrID_ModDTTM_InstID_ModID_FormID: NoteFormNAWHeaderID\ModificationDTTM\NoteFormNAWInstanceID\ModifiedByID\FormIDIndexes IX_NoteForm_NAW_Audit_FormIDFormIDvarchar(255)255NOT NULLIf applicable, points to the form in NoteForm_Library.UFormID
ModificationCommentCompressedvarbinary(max)maxNULL allowedThe compressed ModificationComment (to reduce storage consumption)