NOTE
Description: Textual comment with attribution associated with an order or event

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKNOTETYPEID 2 LKNOTETYPE
QUESTIONNAIREID 4 QUESTIONNAIRE
ENCOUNTERID 5 ENCOUNTER
DERIVEDFROMID 11 NOTE
DIAGNOSTICREPORTID 12 DIAGNOSTICREPORT
DOCUMENTREFERENCEID 13 DOCUMENTREFERENCE
LKENTEREDINERRORREASONID 14 LKENTEREDINERRORREASON
LKQUESTIONNAIREDERIVEDFROMTYPEID 21 LKQUESTIONNAIREDERIVEDFROMTYPE
SURGERYCASERECORDID 22 SURGERYCASERECORD

Column Information
Name Type
1 NOTEID INT
Description: The unique Id for the Note table
Name Type
2 LKNOTETYPEID INT
Description: LkNoteTypeId is a foreign key to the LkNoteType table
Name Type
3 STATUS NVARCHAR
Description: Calculated status value
Name Type
4 QUESTIONNAIREID INT
Description: QuestionnaireId is a foreign key to the Questionnaire table
Name Type
5 ENCOUNTERID INT
Description: EncounterId is a foreign key to the Encounter table
Name Type
6 EXAMDATETIME DATETIME2
Description: Note Exam Date Time
Name Type
7 EXAMTIMEZONEOFFSET INT
Description: Note Exam Time zone offset
Name Type
8 SIGNDATETIME DATETIME2
Description: Date and time that the Note has been signed
Name Type
9 SIGNTIMEZONEOFFSET INT
Description: Sign time zone offset
Name Type
10 SIGNATURE NVARCHAR
Description: Signature of the note
Name Type
11 DERIVEDFROMID INT
Description: DerivedFromId is a foreign key to the Note table
Name Type
12 DIAGNOSTICREPORTID INT
Description: DiagnosticReportId is a foreign key to the DiagnosticReport table
Name Type
13 DOCUMENTREFERENCEID INT
Description: DocumentReferenceId is a foreign key to the DocumentReference table
Name Type
14 LKENTEREDINERRORREASONID INT
Description: LkEnteredInErrorReasonId is a foreign key to the LkEnteredInErrorReason table
Name Type
15 NOTEENTEREDERRORCOMMENTS NVARCHAR
Description: Comments made about the reason why the note as been entered in error
Name Type
17 NOTEENTEREDERROR DATETIME2
Description: Date and time when the Note has been set as Entered in Error
Name Type
18 ENTEREDERRORTIMEZONEOFFSET INT
Description: Entered in Error time zone offset
Name Type
19 NOTEENTEREDERRORSIGNATURE NVARCHAR
Description: Signature of the Entered in Error
Name Type
20 TEXT NVARCHAR
Description: Text is related to the LkNoteTypeId it stores the text of Annotations or Comments Is used when the note is not a structured note
Name Type
21 LKQUESTIONNAIREDERIVEDFROMTYPEID INT
Description: LkQuestionnaireDerivedFromTypeId is a foreign key to the LkQuestionnaireDerivedFromType table
Name Type
22 SURGERYCASERECORDID INT
Description: SurgeryCaseRecordId is a foreign key to the SurgeryCaseRecord table
Name Type
23 INTERNALUSEFORMERGEFK INT
Description: Used to store a temporary Id to prevent the use of a sql merge
Name Type
24 INTERNALUSEFORMERGENOTEID INT
Description: Used to store a temporary Id to prevent the use of a sql merge
Name Type
25 GROUPSESSIONID INT
Description: GroupSessionId is a foreign key to the GroupSession table
Name Type
27 HISTORICAL BIT
Description: Indicates if a note is Historical data. When a note is set to Historical action like enter in error amend add addendum carry forward etc. cannot be performed.
Name Type
29 CREATED DATETIME2
Description: Record created time
Name Type
30 CREATEDTIMEZONEOFFSET INT
Description: Time zone Offset for Created time
Name Type
32 LASTMODIFIED DATETIME2
Description: Record Last Modified time
Name Type
33 LASTMODIFIEDTIMEZONEOFFSET INT
Description: Time zone Offset for Modified time
Name Type
34 UITEMPID INT
Description: Stores a temporary Id used by the UI to assign newly assigned PK Ids.