Description: Textual comment with attribution associated with an order or event
Column Name |
Ordinal Position |
|
|
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.
|