Points to the input template used to author the note: NoteForm_Input_Template.TemplateID
CurrentID
[dbo].[uniqueid]
9
NOT NULL
Points to the current "child" row (the latest revision of the note body) found in NoteForm_NAW_Instance.InstanceID
PatientID
[dbo].[uniqueid]
9
NOT NULL
Points to the patient for whom this note is being authored (denormalized for performance - could've been derived from the Encounter). Link to Person.ID
CreateDTTM
datetime
8
NOT NULL
When the row was inserted
EncounterID
[dbo].[uniqueid]
9
NOT NULL
((0))
Encounter.Points to the Encounter.ID that this note is associated with
SpecialtyDE
[dbo].[dict_id]
5
NOT NULL
((0))
Specialty. Points to Specialty_DE.ID (added in 11.4.1 HF12)