Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HInvestigationResultSuppInfo_Active This table stores information related to a Result. The data comes from the HL7 OBX and OBR segments on an Inbound R01 Result. HInvestigationResultSuppInfo_Active is an Extended table for HinvestigationResult_Active table.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDbigintNOT NULL Object ID and primary key of the table, HInvestigationResultSuppInfo_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 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.
FindingNamevarchar(64)NULL Name of the Finding. This field is obtained from the inbound HL7 Results interface in the OBx.03.01.00.
StatusEnteredDateTimedatetimeNULL Date/time when the result was entered in ancillary system. This field is obtained from the inbound HL7 Results interface in the OBR.22.00.00.
SignedByNamevarchar(90)NULL Name of the staff who has signed the result.
ProviderUnitAbbreviationvarchar(10)NULL Provider unit abbreviation. This field is obtained from the inbound HL7 Results interface in the OBX.15.01.00.
RequestorUnitAbbreviationvarchar(10)NULL Requester unit abbreviation. This field is obtained from the inbound HL7 Results interface in the OBX.21.03.00.
RecipientUnitAbbreviationvarchar(10)NULL Recipient unit abbreviation.
ResultSourceUnitAbbreviationvarchar(10)NULL Result source unit abbreviation.
CriticalReferenceRangevarchar(80)NULL Critical range for that result.
ReasonForRevisionvarchar(200)NULL Reason for revising the result.
Priorityvarchar(32)NULL Priority for that result. Allowable Values: Routine, Timing Critical, Now Routine, As soon as possible, Pre operative, Call back, Stat.
PriorityCodesmallintNULL Priority code for that result. Allowable Values: 0 - Routine, 1 - Timing Critical, 2 - Now Routine, 3 - As soon as possible, 4 - Pre operative, 5 - Call back, 6 - Stat.
EnteredByNamevarchar(12)NULL Name who has entered that result. This field is obtained from the inbound HL7 Results interface in the MSH.03.01.00.
IsResultSentOuttinyintNOT NULLIndicates whether the result is sent outbound.
FormIDintNULL This field indicates the FormID of Adaptable Forms.
RequestedByNamevarchar(90)NULL Name who has requested that test. This field is obtained from the inbound HL7 Results interface in the OBR.16.01.00.
InstDtTimesmalldatetimeNULL Instance DateTime for that adaptable form.
EDVersionvarchar(50)NULL Encapsulated Data Version eg. XSLT ver 1.0. This field is obtained from the inbound HL7 Results interface in the OBR.05.01.00.
ReadingDrvarchar(90)NULL Reading Physician Information from the Inbound Result and Adaptable Form.
DocIDintNULL This field indicates the Object ID for the document.
PerformedByvarchar(90)NULL Name of staff who Performed the test. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.01.
OriginIDvarchar(12)NULL Origin from where the result has come i.e. Rules Engine, Workflow Engine, Digital Dictation etc.
SignedDateTimesmalldatetimeNULL Date/Time when the Result has been signed.
ResultIdentifierDetailOidintNULL Relation to Non HFC HResultIdentifierDetail Table.
ResultObsRequestCommonInfoOidbigintNULL Foreign Key Relation, ObjectId of the NON HFC Table HResultObsRequestCommonInfo.
ObxSetIdsmallintNULL Sequence Number of The repeating OBX segments. This field is obtained from the inbound HL7 Results interface in the OBX.01.00.00.
UnivServIdvarchar(20)NULL Universal ServiceID. This field is obtained from the inbound HL7 Results interface in the OBR.04.01.00.
SpecimenSourceSitevarchar(199)NULL Specimen Source Site read from the SPM.8 in the R01 Message. This field is obtained from the inbound HL7 Results interface in the SPM.08.00.00.
TimingQtyStartDTimeMinssmalldatetimeNULL Timing Quantity Start Date time. This field is obtained from the inbound HL7 Results interface in the OBX.07.01.00.
TimingQtyEndDTimeMinssmalldatetimeNULL Timing Quantity End Date time. This field is obtained from the inbound HL7 Results interface in the TQ1.08.00.01.
ObsSubIdvarchar(20)NULL Observation Sub Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.04.00.00.
AnalysisDTimeMinssmalldatetimeNULL Analysis Date Time. This field is obtained from the inbound HL7 Results interface in the OBX.19.00.00.
ObsValIdvarchar(20)NULL Observation Value Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00.
ObsValTextvarchar(199)NULL Observation Value Text. This field is obtained from the inbound HL7 Results interface in the OBX.05.02.00.
ObsValCodingSysvarchar(20)NULL Observation Value Coding System. For example, L(local), LN(LOINC), SCT(SNOMED CT). This field is obtained from the inbound HL7 Results interface in the OBX.05.03.00.
ObsValAltIdvarchar(20)NULL Observation Value Alternate Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.05.04.00.
ObsValAltTextvarchar(199)NULL Observation Value Alternate Text. This field is obtained from the inbound HL7 Results interface in the OBX.05.05.00.
ObsValNameOfAltCodingSysvarchar(20)NULL Observation Value Name Of Alternate Coding System. For example, L(local), LN(LOINC), SCT(SNOMED CT). This field is obtained from the inbound HL7 Results interface in the OBX.05.06.00.
ObsValCodingSysVerIdvarchar(10)NULL Observation Value Coding System VersionId. This field is obtained from the inbound HL7 Results interface in the OBX.05.07.00.
ObsValAltCodingSysVerIDvarchar(10)NULL Observation Value Alternate Coding System VersionID. This field is obtained from the inbound HL7 Results interface in the OBX.05.08.00.
ObsValOriginalTextvarchar(199)NULL Original Text given for the Observation Value. This field is obtained from the inbound HL7 Results interface in the OBX.05.09.00.
ResUnitIdvarchar(20)NULL Result Unit Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00.
ResUnitTextvarchar(199)NULL Text of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.02.00.
ResUnitCodingSysvarchar(12)NULL Name of the Coding System of the Result Unit. For example, UCUM. This field is obtained from the inbound HL7 Results interface in the OBX.06.03.00.
ResUnitAltIdvarchar(20)NULL Alternate Identifier of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.04.00.
ResUnitAltTextvarchar(199)NULL Alternate Text of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.05.00.
ResUnitNameOfAltCodingSysvarchar(12)NULL Name of Alternate Coding System of the Result Unit. For example, L(local), LN(LOINC), SCT(SNOMED CT). This field is obtained from the inbound HL7 Results interface in the OBX.06.06.00.
ResUnitOriginalTextvarchar(199)NULL Original Text of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.09.00.
ObsIdOriginalTextvarchar(199)NULL Original Text of the Observation Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.03.09.00.
MessageVersionvarchar(8)NULL HL7 Version of the Message that was used for Sending the current Result. This field is obtained from the inbound HL7 Results interface in the MSH.12.00.00.
LastCngDtimedatetimeNULL Current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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