Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLetterInstance This table stores the information for all clinical letters created by the user.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Primary key.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL ID of record
Descriptionvarchar(1)NULL Description of the clinical letter.
IsDeletedtinyintNOT NULL If the letter was deleted it is valued to 1. Valued to 0 if not deleted. Allowable values : 0 or 1.
IsVersionedbitNOT NULL If the template was modified then the value of this field is 1. Otherwise it is 0. Default value is 0.
CreatedUserIdintNULL ID of the user who created the clinical letter.
CreationTimesmalldatetimeNULL Date and time when the clinical letter was created.
InstanceIDvarchar(25)NULL Same as the ObjectID field.
MainStatustinyintNULL Current status of the document. Allowable values:
1 - Draft status
2 - In progress
3 - Signed
4 - Completed
5 - Erroneous
6 - Cosigned
SubStatustinyintNULL 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.
DocTypeintNULL ID of the letter type for the clinical letter.
CoSignatureRequiredbitNULL Valued to 1 if the clinical letter requires cosignature. Allowable values : 0 or 1.
CreationDateTimesmalldatetimeNULL Date and time when the clinical letter was created.
SignedDateTimesmalldatetimeNULL Date and time when the clinical letter was signed.
CoSignedDateTimesmalldatetimeNULL Date and time when the clinical letter was cosigned.
lastSavedDateTimesmalldatetimeNULL Date and time when the clinical letter was last saved.
VersionintNULL Version of the document.
XMLDocumenttextNULL Content of the document in XML format.
LetterTitlevarchar(100)NULL Title of the clinical letter.
Template_oidintNULL Foreign key to HLetterTemplate table.
Patient_oidintNOT NULL Foreign key to HPatient table.
CreatedBy_oidintNOT NULL Staff member that created the clinical letter(Foreign key to HStaff table)
SignedBy_oidintNULL Staff member that signed the clinical letter(Foreign key to HStaff table)
CoSignedBy_oidintNULL Staff member that cosigned the clinical letter(Foreign key to HStaff table)
Typist_oidintNULL Staff member that is assigned as the typist for the clinical letter(Foreign key to HStaff table).
lastSavedBy_oidintNOT NULL Staff member that last saved the clinical letter(Foreign key to HStaff table).
PatientVisit_oidintNOT NULL Foreign key to HPatientVisit table.
Stylesheet_oidintNOT NULL Foreign key to HLetterStylesheet table.
Author_oidINTNULL Foreign key to HStaff table.(It refers to a particular staff member who is the author of the clinical letter)
PreviousValuesvarchar(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.
UniqueIdvarchar(150)NULL Generated unique ID with the object ID appended at the end.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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