Tables [dbo].[NoteForm_Amendment_Activation]
Tracks the beginning of a v11 Note amendment cycle
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_NoteForm_Amendment_Activation: NoteformNAWInstanceHeaderNoteformNAWInstanceHeader[dbo].[uniqueid]9NOT NULLNoteform Header. Link to NoteForm_NAW_Instance_Header.HeaderID.
ActivationReasonDocumentID[dbo].[uniqueid]9NOT NULLPoints to Document.DocumentID (the Document row of first finalization, prior to any amendment)
Indexes NIX_NoteForm_Amendment_Activation_PatientIDForeign Keys FK_NoteForm_Amendment_Activation_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
ActivationDTTMdatetime8NOT NULLWhen the row was inserted.