Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Primary key. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | ID of record |
Description | varchar(1) | NULL | Description of the clinical letter. |
IsDeleted | tinyint | NOT NULL | If the letter was deleted it is valued to 1. Valued to 0 if not deleted. Allowable values : 0 or 1. |
IsVersioned | bit | NOT NULL | If the template was modified then the value of this field is 1. Otherwise it is 0. Default value is 0. |
CreatedUserId | int | NULL | ID of the user who created the clinical letter. |
CreationTime | smalldatetime | NULL | Date and time when the clinical letter was created. |
InstanceID | varchar(25) | NULL | Same as the ObjectID field. |
MainStatus | tinyint | NULL | Current status of the document. Allowable values: |
| | | 1 - Draft status |
| | | 2 - In progress |
| | | 3 - Signed |
| | | 4 - Completed |
| | | 5 - Erroneous |
| | | 6 - Cosigned |
SubStatus | tinyint | NULL | Sub status of the clinical letter. Example 1: If MainStatus is 2(In progress) then SubStatus will be 2 if the user is a physician. Valued to 3 if the user is a typist. Example 2: If MainStatus is 4(Completed) then SubStatus will be 4 if the letter was completed. If the letter is "completed and printed"(Refer to HLetterVersions Status columns) this is valued to 5. |
DocType | int | NULL | ID of the letter type for the clinical letter. |
CoSignatureRequired | bit | NULL | Valued to 1 if the clinical letter requires cosignature. Allowable values : 0 or 1. |
CreationDateTime | smalldatetime | NULL | Date and time when the clinical letter was created. |
SignedDateTime | smalldatetime | NULL | Date and time when the clinical letter was signed. |
CoSignedDateTime | smalldatetime | NULL | Date and time when the clinical letter was cosigned. |
lastSavedDateTime | smalldatetime | NULL | Date and time when the clinical letter was last saved. |
Version | int | NULL | Version of the document. |
XMLDocument | text | NULL | Content of the document in XML format. |
LetterTitle | varchar(100) | NULL | Title of the clinical letter. |
Template_oid | int | NULL | Foreign key to HLetterTemplate table. |
Patient_oid | int | NOT NULL | Foreign key to HPatient table. |
CreatedBy_oid | int | NOT NULL | Staff member that created the clinical letter(Foreign key to HStaff table) |
SignedBy_oid | int | NULL | Staff member that signed the clinical letter(Foreign key to HStaff table) |
CoSignedBy_oid | int | NULL | Staff member that cosigned the clinical letter(Foreign key to HStaff table) |
Typist_oid | int | NULL | Staff member that is assigned as the typist for the clinical letter(Foreign key to HStaff table). |
lastSavedBy_oid | int | NOT NULL | Staff member that last saved the clinical letter(Foreign key to HStaff table). |
PatientVisit_oid | int | NOT NULL | Foreign key to HPatientVisit table. |
Stylesheet_oid | int | NOT NULL | Foreign key to HLetterStylesheet table. |
Author_oid | INT | NULL | Foreign key to HStaff table.(It refers to a particular staff member who is the author of the clinical letter) |
PreviousValues | varchar(1000) | NULL | When there are any changes in patient demographics(Name, DOB, address etc.) this column is updated. If any of the fields are not valued, this column is empty. |
UniqueId | varchar(150) | NULL | Generated unique ID with the object ID appended at the end. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|