Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HInvestigationResult_Active This table stores information related to the OBX (Result) and OBR (Order) information of an Inbound R01 Result. It will also contain data for results manually entered on Soarian.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDbigintNOT NULL Object ID and primary key of the table, HInvestigationResult_Active.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique identification of an object across the application.
RecordIdintNULL Indicates the record ID.
Descriptionvarchar(1)NULL User-defined description for the row.
IsDeletedtinyintNOT NULL Indicates whether the result is deleted. Allowable Values: 0 - No, 1 - Yes.
IsVersionedbitNOT NULL Indicates whether the result is modified. Allowable Values: 0 - No, 1 - Yes.
CreatedUserIdintNULL Object ID of the user who created the result. This field is linked to the HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the Result is created.
FindingAbbreviationvarchar(16)NOT NULL Abbreviation set for the name of the finding. This field is obtained from the inbound HL7 Results interface in the OBR.04.01.00.
ResultStatuschar(1)NOT NULL Status of the Result. This field is obtained from the inbound HL7 Results interface in the OBX.11.00.00. Allowable value: U - FinalResult, P - PreliminaryResult, S - PartialResult, F - FinalResult, C - CorrectedResult, D - DeletesOBXRecord, I - SpecimenInLabResultsPending, N - NotAsked,R - ResultsEnteredNotVerified, O - OrderDetailsOnly, X - ResultsCanNotBeObtained, W - PostOriginalAsWrong.
ResultStatusCodetinyintNOT NULL Code for the Result Status. Allowable value: 0 - Preliminary Result, 1 - Partial Result, 2 - Final Result, 3 - Corrected Result, 4 - Deleted OBX Record, 5 - Specimen In Lab Result Pending, 6 - Not Asked, 7 - Results Entered Not Verified, 8 - Order details only, 9 - Results Can Not Be Obtained, 10 - Post Original As Wrong, 11 - Future Use, 12 - Result worksheet not signed yet, 13 - Erroneous.
ReferenceRangevarchar(80)NULL Reference range for the Result. This field is obtained from the inbound HL7 Results interface in the OBX.07.00.00.
UnitOfReferenceRangevarchar(16)NULL Unit of Measure. For example,(g/g)/s. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00.
DeviatingIndicatorCodetinyintNULL Code that indicates the Severity of the Result. Allowable value: L - 0, N - 1, H - 2, A - 4, LL - 5, HH - 6, AA - 7.
ResultDateTimedatetimeNOT NULL Date Time that the Result was saved in the Soarian System.
ObservationDateTimesmalldatetimeNULL Clinically relevant Date Time of the result. For Lab results, this is typically the Sample collection date/time. This field is obtained from the inbound HL7 Results interfac OBR.07.00.00 or OBX.14. The OBX.14 takes precedence.
IsExternalResulttinyintNOT NULL Indicates whether the Result is an interface Or Manually Entered Result. Allowable Values: 0 - Manual, 1 - Interface.
ServiceProviderOrderIDvarchar(80)NULL Unique Service Provider Order ID of a Result. This field is obtained from the inbound HL7 Results interface in the OBR.02.01.00.
AbnormalFlagvarchar(5)NULL Severity of the Result based on HL7 standard values. This field is obtained from the inbound HL7 Results interface in the OBX.08.00.00. Allowable value: L - Below low normal, LL - Below lower panic limits, H - Above high normal, HH - Above upper panic limits, A - Abnormal, AA - Very abnormal, N - Normal.
Commentsvarchar(80)NULL Comments for the OBX Segment.
SignedtinyintNOT NULL Indicates whether the Result is signed or not. Allowable Values: 0 - NO, 1 - Yes.
ResultValuevarchar(80)NULL Result Value. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00.
ResultDataTypevarchar(4)NULL HL7 Data Type of a Result. This field is obtained from the inbound HL7 Results interface in the OBX.02.00.00.
ResultDataTypeCodetinyintNULL Data type code of a ResultDataType. Allowable Values: NM - 0, ST - 1, CE - 2, TX - 3, Form - 6, ED - 7, RP - 8, AN - 10.
RequisitionCommentsvarchar(80)NULL Comments provided for the Order(OBR) Segment. This field is obtained from the inbound HL7 Results interface in the NTE.03.00.00.
SpecimenNamevarchar(64)NULL Source of the Specimen i.e., sample collected(Eg : blood , urine). This field is obtained from the inbound HL7 Results interface in the OBR.15.01.02.
ClinicalTypechar(2)NULL Clinical type of the Result. Allowable Values: Mi - Micro Results.
IsAmmendedtinyintNOT NULL Indicates whether the object is revised. Allowable Values: 0 - NO, 1 - Yes.
MRUAbbreviationvarchar(10)NULL Abbreviation for the name of the MRU.
IsRestrictedtinyintNOT NULL Indicates whether the Result is defined as being a sensitive/restricted result. Allowable Values: 0 - NO, 1 - Yes.
ResultIdbigintNULL Result OID. When the Result is Revised, the Result OID is Valued with the ObjectID of the previous Result.
IsRangeValueVersionedtinyintNOT NULL Reference range of a result has been updated. Allowable Values: 0 - NO, 1 - Yes.
InvalidationDateTimesmalldatetimeNOT NULL Date time in which the Result is/will become invalidated.
HasCommenttinyintNOT NULL Indicates whether the Result has comments. Allowable Values: 0 - NO, 1 - Yes.
Service_oidintNULL Object ID for the HService table.
Patient_oidintNULL ObjectOID of the HPatient.
RequestedBy_oidintNULL Ordering doctor.
PatientVisit_oidintNULL PatientVisit OID.
PerformedBy_oidintNULL User who has performed the Result.
HTMLResult_oidintNULL Object_id of HTML Result Type from HHTML table
SignedBy_oidintNULL Staff ObjectID who signed the Result.
Occurrence_oidbigintNULL Occurrence ObjectID of an Order to which this result is associated. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype.
RequestorUnit_oidintNULL Requester Unit_Oid.
VisitTypetinyintNULL Type of the Visit. Allowable Values: 0 - Active, 1 - closed.
ResultSuppInfo_oidbigintNULL ObjectID of the HinvestigationResultSuppInfo_Active table. This field is always a primary key for the HinvestigationResultSuppInfo_Active table.
HasMultipleRefRangesbitNULL Indicates whether the Result has MultipleRefRanges. Allowable Values: 0 - NO, 1 - Yes.
UOMCodevarchar(16)NULL Code for the UnitOfMeasure.
HasOnlyImagetinyintNOT NULL Type of a Image Result. Allowable Values: 0 - text Result, 1 - image only Result, 2 - Image with text Result.
ServiceTypeCodesmallintNULL Code for ServiceType.
ServiceSubTypeCodesmallintNULL Code for ServiceSubType.
HasFormtinyintNULL Indicates whether the Result is entered using AT(Adaptability Tool) Forms.
EDTypeCodevarchar(8)NULL Indicates whether the Result is PDF or RTF. Allowable Values: PDF - PDF Results, RTF - RTF Results.
PerformingOrgDetail_oidIntNull Object ID and Primary key of the table HPerformingOrgDetail.
LastCngDtimedatetimeNULL Current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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