Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLetterTemplate This table stores the information for all available clinical letter templates.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Primary key of the table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL ID of the record.
Descriptionvarchar(255)NULL Description given to the template.
IsVersionedbitNOT 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.
CreatedUserIdintNULL ID of the user who created the template.
CreationTimesmalldatetimeNULL Date and time when the template was created.
TemplateIDvarchar(25)NULL Unique ID given to the template.
TemplateNamevarchar(25)NULL Name of the template.
DocTypeintNULL ID of the letter type.
SchemaIDvarchar(25)NULL ID of the schema.
Versionvarchar(25)NULL Version of the letter template.
CoSignatureRequiredbitNULL If the template requires cosignature then the value of this field is 1. Otherwise it is 0.
Stylesheet_oidintNOT NULL Foreign key to HLetterStylesheet.
TransformationTypevarchar(10)NOT NULL Type of the transformation having the default value as 'NORESTRICT'

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates