Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HClinicalInformation OBSOLETE TABLE - Prior to the IMA (Inter-Module Adaptability) feature , This table used to store data from other modules during order entry. This table was kept for backward compatibility support for older form elements. The older form elements are no more available on Order Detail Forms, and with IMA Feature other module elements are getting saved in HClinicalInformationEx table.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1513. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation.
IsVersionedbitNOT NULL Whether the table data is Versioned or not.
Allowable Values:
0 - No version data captured.
1 - Version changes available in _Ver table.
Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HClinicalInformation_Ver.
Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
UnderAntibioticsbitNULL Whether patient was under Antibiotics
Allowable Values
0 - False
1 - True
DrugNamevarchar(32)NULL Name of the Drug
LastDoseDateTimesmalldatetimeNULL Date/Time when the last dosage was given
Heightvarchar(2000)NULL Height of the patient when the order was entered.
Weightvarchar(2000)NULL Weight of the patient when the order was entered.
PatientConditionvarchar(64)NULL Condition of the patient when the order was entered.
PrevTransDatesmalldatetimeNULL Date of previous Transfusion
PrevTransReactionsvarchar(32)NULL Reactions due to previous Transfusion
PrevTransUnitvarchar(16)NULL Unit of previous Transfusion
PregnancyIndicatorDatesmalldatetimeNULL DateTime when pregnancy indicator was valued
PregnancyNumbertinyintNULL Number of times patient was pregnant
PregnancyIndicatorbitNULL Whether patient is pregnant or not
Allowable Values
0 - False
1 - True
LMPDatesmalldatetimeNULL Date of Last menstrual period(LMP)
AllergyToDyebitNULL Whether patient is allergic to Dye
Allowable Values
0 - False
1 - True
AllergyToLatexbitNULL Whether patient is having latex allergy
Allowable Values
0 - False
1 - True
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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