Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultObsRequestCommonInfo This table stores information related to the Order associated to a result. It contains data from the OBR Segment and ORC Segment for an Inbound R01 Message.
Column Name Column Datatype Column Null Option Column Comment
ResultObsRequestCommonInfoOidBIGINTNOT NULL Object ID and primary key of the table, HResultObsRequestCommonInfo.
SendApplNameSpcIdVARCHAR(20)NULL An Identifier which indicates the Sending Application. For example, LAB. This field is obtained from the inbound HL7 Results interface in the MSH.03.01.00.
SendApplUnivIdVARCHAR(199)NULL Universal Identifier for the Sending Application which is unique to that sending application. For example, the CLIA Id of the lab. This field is obtained from the inbound HL7 Results interface in the MSH.03.02.00.
SendApplUnivIdTypeVARCHAR(6)NULL Type of Universal Identifier used to identify the Sending Application. For example, CLIA. This field is obtained from the inbound HL7 Results interface in the MSH.03.03.00.
SendFacilityNameSpcIdVARCHAR(20)NULL An Identifier which identifies the Sending Facility. This field is obtained from the inbound HL7 Results interface in the MSH.04.01.00.
SendFacilityUnivIdVARCHAR(199)NULL Universal Identifier for the Sending Facility which is unique to that facility. This field is obtained from the inbound HL7 Results interface in the MSH.04.02.00.
SendFacilityUnivIdTypeVARCHAR(6)NULL Type of Universal Identifier used to identify the Sending Facility. For example, ISO. This field is obtained from the inbound HL7 Results interface in the MSH.04.03.00.
ResultMessageProfileInfoOidINTNOT NULL This stores processing information needed for the transaction.
PlacerGrpNumEntityIdVARCHAR(199)NULL Entity Identifier for the Placer Group Number. This field is obtained from the inbound HL7 Results interface in the ORC.04.01.00.
PlacerGrpNumNameSpcIdVARCHAR(20)NULL Name of the Placer Group Number. This field is obtained from the inbound HL7 Results interface in the ORC.04.02.00.
PlacerGrpNumUnivIdVARCHAR(199)NULL Universal Identifier which identifies the Placer Group Number. This field is obtained from the inbound HL7 Results interface in the ORC.04.03.00.
PlacerGrpNumUnivIdTypeVARCHAR(6)NULL Type of universal Identifier used to identify the Placer Group Number. For example, ISO. This field is obtained from the inbound HL7 Results interface in the ORC.04.04.00.
PlacerOrdNumEntityIdVARCHAR(199)NULL Soarian generated Order number, order occurrence number or Lab Id(LID). This field is obtained from the inbound HL7 Results interface in the OBR.02.01.00.
PlacerOrdNumNameSpcIdVARCHAR(20)NULL Type of data that is stored in the PlacerNumberOrderID field. Allowable values: Null - indicates occurrence#, OrderID - indicates Order ID, Order_ID - Indicates Order ID, OccOrder_ID - Indicates occurrence #, LID - Indicates Sample collected lab id. This field is obtained from the inbound HL7 Results interface in the OBR.02.02.00.
PlacerOrdNumUnivIdVARCHAR(199)NULL Universal Identifier which uniquely identifies the Placer Order Number. This field is obtained from the inbound HL7 Results interface in the OBR.02.03.00.
PlacerOrdNumUnivIdTypeVARCHAR(6)NULL Type of Universal Identifier used to identify the Placer Order Number. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.02.04.00.
FillerOrdNumEntityIdVARCHAR(199)NULL Filler Order Number Entity Identifier. It is typically valued with the Specimen Number from the lab. This field is obtained from the inbound HL7 Results interface in the OBR.03.01.00.
FillerOrdNumNameSpcIdVARCHAR(20)NULL Name associated to the Filler Order Number Identifier. This field is obtained from the inbound HL7 Results interface in the OBR.03.02.00.
FillerOrdNumUnivIdVARCHAR(199)NULL Universal Identifier which uniquely identifies the Filler Order Number. This field is obtained from the inbound HL7 Results interface in the OBR.03.03.00.
FillerOrdNumUnivIdTypeVARCHAR(6)NULL Universal Identifier used for the Filler Order Number. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.03.04.00.
UnivServIdTextVARCHAR(199)NULL Textual description of the service which was ordered. For example, Throat Culture. This field is obtained from the inbound HL7 Results interface in the OBR.04.02.00.
UnivServIdCdSysVARCHAR(12)NULL Name of the Coding System of the Universal Service Identifier. For example, LOINC. This field is obtained from the inbound HL7 Results interface in the OBR.04.03.00.
UnivServIdAltIdVARCHAR(20)NULL Alternate Identifier of the Universal Service Identifier. For example, a SNOMED, LOINC or Local identifier for the result. This field is obtained from the inbound HL7 Results interface in the OBR.04.04.00.
UnivServIdAltTextVARCHAR(199)NULL Textual description of the Alternate Identifier. For example, Throat Culture. This field is obtained from the inbound HL7 Results interface in the OBR.04.05.00.
UnivServIdNameOfAltCdSysVARCHAR(12)NULL Name of the Alternate Coding System of the Universal Service Identifier. for example, SNOMED, LOINC, etc. This field is obtained from the inbound HL7 Results interface in the OBR.04.06.00.
UnivServIdOriginalTextVARCHAR(199)NULL Original Textual description of the Universal Service Identifier. For example, Throat Culture. This field is obtained from the inbound HL7 Results interface in the OBR.04.09.00.
ObservationEndDTimeMinsSMALLDATETIMENULL End date/time of the Observation. This field is obtained from the inbound HL7 Results interface in the OBR.08.00.00.
SpecimenActionCodeCHAR(1)NULL Specimen Action Code to further define the type of Result. This field is obtained from the inbound HL7 Results interface in the OBR.11.00.00. Possible Values: A - Add ordered tests to the existing specimen, L - Lab to Obtain specimen from patient, G - Generated Order, Reflex Order, O - specimen obtained by service other than Lab. Micro Results are identified with a 'G'.
OrdProviderIdNumVARCHAR(15)NULL Ordering Provider Identifier Number. This field is obtained from the inbound HL7 Results interface in the OBR.16.01.00.
OrdProviderLastNameVARCHAR(50)NULL Ordering Provider Last Name. This field is obtained from the inbound HL7 Results interface in the OBR.16.02.01.
OrdProviderFirstNameVARCHAR(30)NULL Ordering Provider First Name. This field is obtained from the inbound HL7 Results interface in the OBR.16.03.00.
OrdProviderInitialsVARCHAR(30)NULL Ordering Provider Middle Initial. This field is obtained from the inbound HL7 Results interface in the OBR.16.04.00.
OrdProviderSuffixVARCHAR(20)NULL Ordering Provider Name Suffix. This field is obtained from the inbound HL7 Results interface in the OBR.16.05.00.
OrdProviderPrefixVARCHAR(20)NULL Ordering Provider Name Prefix. This field is obtained from the inbound HL7 Results interface in the OBR.16.06.00.
OrdProviderAsgnAuthNameSpcIdVARCHAR(20)NULL Ordering Provider Assigning Authority NameSpace Identifier. This field is obtained from the inbound HL7 Results interface in the OBR.16.09.01.
OrdProviderAsgnAuthUnivIdVARCHAR(199)NULL Ordering Provider Assigning Authority Universal Identifier which uniquely identifies the provider. This field is obtained from the inbound HL7 Results interface in the OBR.16.09.02.
OrdProviderAsgnAuthUnivIdTypeVARCHAR(6)NULL Type of Universal Identifier used for the Ordering Provider Assigning Authority. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.16.09.03.
OrdProviderNameTypeCodeVARCHAR(5)NULL Ordering Provider Name Type Code. This field is obtained from the inbound HL7 Results interface in the OBR.16.10.00.
OrdProviderIdTypeCodeVARCHAR(5)NULL Type of identifier used for the Ordering Provider. For example NPI#. This field is obtained from the inbound HL7 Results interface in the OBR.16.13.00.
ObrStatusCodeCHAR(1)NULL Result Status or the Culture status. This field is obtained from the inbound HL7 Results interface in the OBR.25.00.00. Values include: A - Some but not all, results available, C - Correction to results, F - Final Results, I - No results available; specimen received, procedure incomplete, O - Order Received; specimen not yet received, P - Preliminary; A Verified early result is available, R - Results stored; not yet verified, S - No results available; procedure scheduled but not done, X - No Results available ; order cancelled.
ParentResIdVARCHAR(20)NULL Used to link micro sensitivities to the culture result. The field contains an Identifier which was sent in the OBX.03 of the Parent Result so that they can be linked. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.01.
ParentResTextVARCHAR(199)NULL Used to link micro sensitivities to the culture result. The field contains the Text which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.02.
ParentResCdSysVARCHAR(12)NULL Used to link micro sensitivities to the culture result. The field contains the Name Of Coding System which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.03.
ParentResAltIdVARCHAR(20)NULL Used to link micro sensitivities to the culture result. The field contains the Alternate Identifier which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.04.
ParentResAltTextVARCHAR(199)NULL Used to link micro sensitivities to the culture result. The field contains the Alternate Text which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.05.
ParentResNameOfAltCdSysVARCHAR(12)NULL Used to link micro sensitivities to the culture result. The field contains the Name Of Alternate Coding System which was sent in the OBX.03 of the Parent result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.06.
ParentResOriginalTextVARCHAR(199)NULL Used to link micro sensitivities to the culture result. The field contains the Original text of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.09.
ParentObsSubIdVARCHAR(20)NULL Used to link micro sensitivities to the culture result. The field contains the Parent Observation Sub Identifier which was sent in the OBX.04 of the parent. This field is obtained from the inbound HL7 Results interface in the OBR.26.02.00.
ParentPlacerAsgnIdEntityIdVARCHAR(199)NULL AssigningId Entity Identifier of the Parent Placer. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.01.
ParentPlacerAsgnIdNameSpcIdVARCHAR(20)NULL AssigningId NameSpace Identifier of the Parent Placer. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.02.
ParentPlacerAsgnIdUnivIdVARCHAR(199)NULL AssigningId Universal Identifier of the Parent Placer. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.03.
ParentPlacerAsgnIdUnivIdTypeVARCHAR(6)NULL Universal Identifier type used for the AssigningId of the Parent Placer. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.04.
ParentFillerAsgnIdEntityIdVARCHAR(199)NULL AssigningId Entity Identifier of the Parent Filler. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.01.
ParentFillerAsgnIdNameSpcIdVARCHAR(20)NULL AssigningId NameSpace Identifier of the Parent Filler. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.02.
ParentFillerAsgnIdUnivIdVARCHAR(199)NULL Universal Identifier which uniquely identifies the AssigningId of the Parent Filler. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.03.
ParentFillerAsgnIdUnivIdTypeVARCHAR(6)NULL Universal identier type of the AssigningId of the Parent Filler. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.04.
PrinResRdrIdNumberVARCHAR(15)NULL Identifier of the Doctor who read the results(Reading Doctor). This field is obtained from the inbound HL7 Results interface in the OBR.32.01.01.
PrinResRdrSourceTableVARCHAR(4)NULL Reading Doctor Source Table. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.08.
PrinResRdrAsgnAuthNameSpcIdVARCHAR(20)NULL Entitiy specific staff Identifier of the Reading Doctor. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.09.
PrinResRdrAsgnAuthUnivIdVARCHAR(199)NULL Reading Doctor Assigning Authority Universal Identifier. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.10.
PrinResRdrAsgnAuthUnivIdTypeVARCHAR(6)NULL Universal identifier Type used to identify the Reading Doctor Assigning Authority. For exmaple, NPI. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.11.
TechnicianIdNumberVARCHAR(15)NULL Identifier Number of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.01.
TechnicianSourceTableVARCHAR(4)NULL Source Table of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.08.
TechnicianAsgnAuthNameSpcIdVARCHAR(20)NULL Assigning Authority NameSpace Identifier of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.09.
TechnicianAsgnAuthUnivIdVARCHAR(199)NULL Assigning Authority Universal Identifier of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.10.
TechnicianAsgnAuthUnivIdTypeVARCHAR(6)NULL Type of Universal Identifier used to identify the Assigning Authority of the Technician. For example, NPI. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.11.
ParentUnivServIdVARCHAR(20)NULL Universal Service Identifier of the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.01.00.
ParentUnivServIdTextVARCHAR(199)NULL Text name for the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.02.00.
ParentUnivServIdCdSysVARCHAR(20)NULL Name of Coding System of the Universal Service Identifier used in the parent order. For example, LOINC. This field is obtained from the inbound HL7 Results interface in the OBR.50.03.00.
ParentUnivServIdAltIdVARCHAR(20)NULL Alternate Identifier of the Universal Service Identifier used in the Parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.04.00.
ParentUnivServIdAltTextVARCHAR(199)NULL Alternate Text of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.05.00.
ParentUnivServIdNmOfAltCdSysVARCHAR(20)NULL Name of Alternate Coding System of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.06.00.
ParentUnivServIdCdSysVerIdVARCHAR(10)NULL Coding System Version Identifier of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.07.00.
ParentUnivServIdAltCdSysVerIdVARCHAR(10)NULL Alternate Coding System Version Identifier of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.08.00.
ParentUnivServIdOriginalTextVARCHAR(199)NULL Original Text of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.09.00.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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