Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key. |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | The ID of the record. |
Description | varchar(1) | NULL | Column is not used. |
IsVersioned | bit | NOT NULL | Valued to 1 if a comment was modified. Allowable values: 0 and 1. |
CreatedUserId | int | NULL | The ID of the user who created the comment in the clinical letter. |
CreationTime | smalldatetime | NULL | The date and time of the creation of the comment in the clinical letter. |
CommentText | varchar(2000) | NULL | The text which was added by the user in the comment. |
CommentSeq | int | NULL | The sequence of the comment for a particular letter. Value starts at 1 and increases for every new comment on the same letter. |
CommentStatus | varchar(1) | NULL | The status of the comment will be 'A' when the comment is saved. |
Letter_oid | int | NOT NULL | The foreign key to HLetterInstance table. |
ReadStatus | smallint | NULL | Set to 0 when a comment is added directly in a clinical letter. This indicates that the comment is active. |
| | | When a comment is added to a letter which was already sent to the worklist then the ReadStatus for all older comments of that letter will be 1 indicating that they are not active. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|