Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKNOTETYPEID	2	LKNOTETYPE
QUESTIONNAIREID	3	QUESTIONNAIRE
ENCOUNTERID	4	ENCOUNTER
DERIVEDFROMID	10	NOTE
DIAGNOSTICREPORTID	11	DIAGNOSTICREPORT
DOCUMENTREFERENCEID	12	DOCUMENTREFERENCE
LKENTEREDINERRORREASONID	13	LKENTEREDINERRORREASON
LKQUESTIONNAIREDERIVEDFROMTYPEID	20	LKQUESTIONNAIREDERIVEDFROMTYPE
SURGERYCASERECORDID	28	SURGERYCASERECORD

	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	QUESTIONNAIREID	INT
	Description: QuestionnaireId is a foreign key to the Questionnaire table

	Name	Type
4	ENCOUNTERID	INT
	Description: EncounterId is a foreign key to the Encounter table

	Name	Type
5	EXAMDATETIME	DATETIME2
	Description: Note Exam Date Time

	Name	Type
6	EXAMTIMEZONEOFFSET	INT
	Description: Note Exam Time zone offset

	Name	Type
7	SIGNDATETIME	DATETIME2
	Description: Date and time that the Note has been signed

	Name	Type
8	SIGNTIMEZONEOFFSET	INT
	Description: Sign time zone offset

	Name	Type
9	SIGNATURE	NVARCHAR
	Description: Signature of the note

	Name	Type
10	DERIVEDFROMID	INT
	Description: DerivedFromId is a foreign key to the Note table

	Name	Type
11	DIAGNOSTICREPORTID	INT
	Description: DiagnosticReportId is a foreign key to the DiagnosticReport table

	Name	Type
12	DOCUMENTREFERENCEID	INT
	Description: DocumentReferenceId is a foreign key to the DocumentReference table

	Name	Type
13	LKENTEREDINERRORREASONID	INT
	Description: LkEnteredInErrorReasonId is a foreign key to the LkEnteredInErrorReason table

	Name	Type
14	NOTEENTEREDERRORCOMMENTS	NVARCHAR
	Description: Comments made about the reason why the note as been entered in error

	Name	Type
16	NOTEENTEREDERROR	DATETIME2
	Description: Date and time when the Note has been set as Entered in Error

	Name	Type
17	ENTEREDERRORTIMEZONEOFFSET	INT
	Description: Entered in Error time zone offset

	Name	Type
18	NOTEENTEREDERRORSIGNATURE	NVARCHAR
	Description: Signature of the Entered in Error

	Name	Type
19	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
20	LKQUESTIONNAIREDERIVEDFROMTYPEID	INT
	Description: LkQuestionnaireDerivedFromTypeId is a foreign key to the LkQuestionnaireDerivedFromType table

	Name	Type
23	CREATED	DATETIME2
	Description: Record created time

	Name	Type
24	CREATEDTIMEZONEOFFSET	INT
	Description: Time zone Offset for Created time

	Name	Type
26	LASTMODIFIED	DATETIME2
	Description: Record Last Modified time

	Name	Type
27	LASTMODIFIEDTIMEZONEOFFSET	INT
	Description: Time zone Offset for Modified time

	Name	Type
28	SURGERYCASERECORDID	INT
	Description: SurgeryCaseRecordId is a foreign key to the SurgeryCaseRecord table