Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | This column is not used. |
Description | varchar(1) | NULL | This column is not used. |
IsVersioned | bit | NOT NULL | When set to True(1), indicates that the object was modified. Once this field is set to True, you cannot reset it to False. |
CreatedUserId | int | NULL | The ID of the user who created the clinical note. This field is linked to HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | The date and time when the clinical note was created. |
PatientID | int | NOT NULL | The ID of the patient. |
UserRole | varchar(30) | NULL | The role of the staff type of the user who entered the clinical note for the patient. |
CollectedDT | smalldatetime | NOT NULL | The date and time when the clinical note was collected. |
ClinNoteID | int | NOT NULL | The unique ID assigned to the clinical note. |
EnteredDT | smalldatetime | NOT NULL | The date and time when the clinical note was entered in the application. |
EndDT | datetime | NULL | The last date and time when the clinical note is available to users for selection and processing. |
LinkObjectID | BigInt | NULL | The unique ID of the HFC object to which the user attaches the clinical note. For example, if we attach a clinical note to an assessment, the assessment ID is stored. |
LinkObjectHFCID | int | NULL | The HFC ID of the object to which the user attaches the clinical note. |
NoteStatus | int | NOT NULL | The status of the clinical note. Allowable Values: 0, 1, 2, 3. Key of allowable values: 0 - Erroneous, 1 - Draft 2, - InProgress 3 - Complete. |
NoteStatusText | varchar(30) | NOT NULL | Description of the status of the clinical note. Refer to NoteStatus for values. |
NoteText | varchar(3500) | NULL | Contents of the clinical note. |
RevisedReason | varchar(30) | NULL | The reason the clinical note was modified. |
RevisedUserAbbrName | varchar(30) | NULL | The abbreviation for the name of the user who modified the clinical note. |
RevisedUserRole | varchar(30) | NULL | The staff type of the user who modified the clinical note. |
UserName | varchar(92) | NOT NULL | The name of the user who entered the clinical note |
UserID | int | NOT NULL | The ID of the user who entered the clinical note. |
VisitID | int | NULL | The ID of the patient visit during which the clinical note was entered. |
UserTitle | varchar(30) | NULL | The title(such as Mr or Ms) for the user who entered the clinical note. |
HistoryInd | tinyint | NULL | When set to 0, indicates that a new clinical note was entered. When set to 1, indicates that the clinical note was modified. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - New Clinical Note Entered, 1 - Clinical Note Modified. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|