Tables [dbo].[NoteForm_NAW_Instance_Header]
The Parent (Header) of the Child (Detail) which contains the saved V11 note
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_NoteForm_NAW_Instance_Header: HeaderIDHeaderID[dbo].[uniqueid]9NOT NULLKey to the Noteform_NAW_Instance_Header table
Foreign Keys FK_NoteForm_NAW_Instance_Header_NoteForm_Input_Template: [dbo].[NoteForm_Input_Template].InputTemplateIDInputTemplateID[dbo].[uniqueid]9NOT NULLPoints to the input template used to author the note: NoteForm_Input_Template.TemplateID
Indexes IX_NoteForm_NAW_Instance_Header_CurrentIDCurrentID[dbo].[uniqueid]9NOT NULLPoints to the current "child" row (the latest revision of the note body) found in NoteForm_NAW_Instance.InstanceID
Cluster Key IX_NoteForm_NAW_Instance_Header: PatientIDForeign Keys FK_NoteForm_NAW_Instance_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPoints to the patient for whom this note is being authored  (denormalized for performance - could've been derived from the Encounter). Link to Person.ID
Indexes TWstat_NoteForm_NAW_Instance_Header_CreateDTTMCreateDTTMdatetime8NOT NULLWhen the row was inserted
Indexes NIX_NoteForm_NAW_Instance_Header_EncounterIDForeign Keys FK_NoteForm_NAW_Instance_Header_Encounter: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULL((0))Encounter.Points to the Encounter.ID that this note is associated with
SpecialtyDE[dbo].[dict_id]5NOT NULL((0))Specialty. Points to Specialty_DE.ID (added in 11.4.1 HF12)