Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Primary key of the table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | ID of the record. |
Description | varchar(255) | NULL | Description given to the template. |
IsVersioned | bit | NOT NULL | If the template is modified then the value of this field is 1. Otherwise it is 0. Allowable values - 0 or 1. Default value is 0. |
CreatedUserId | int | NULL | ID of the user who created the template. |
CreationTime | smalldatetime | NULL | Date and time when the template was created. |
TemplateID | varchar(25) | NULL | Unique ID given to the template. |
TemplateName | varchar(25) | NULL | Name of the template. |
DocType | int | NULL | ID of the letter type. |
SchemaID | varchar(25) | NULL | ID of the schema. |
Version | varchar(25) | NULL | Version of the letter template. |
CoSignatureRequired | bit | NULL | If the template requires cosignature then the value of this field is 1. Otherwise it is 0. |
Stylesheet_oid | int | NOT NULL | Foreign key to HLetterStylesheet. |
TransformationType | varchar(10) | NOT NULL | Type of the transformation having the default value as 'NORESTRICT' |
|
|