Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.NoteForm_Amendment_Activation
Touchworks 25.2
[dbo].[NoteForm_Amendment_Activation]
MS_Description
Tracks the beginning of a v11 Note amendment cycle
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
NoteformNAWInstanceHeader
[dbo].[uniqueid]
9
NOT NULL
Noteform Header. Link to NoteForm_NAW_Instance_Header.HeaderID.
ActivationReasonDocumentID
[dbo].[uniqueid]
9
NOT NULL
Points to Document.DocumentID (the Document row of first finalization, prior to any amendment)
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
ActivationDTTM
datetime
8
NOT NULL
When the row was inserted.