Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultSpecimenOBXInfo This table stores information related to the results of the specimen. It is sent on Repeating OBX segments after the SPM segment.
Column Name Column Datatype Column Null Option Column Comment
ResultSpecimenOBXInfoOidBIGINTNOT NULL Object ID and primary key of the table, HResultSpecimenOBXInfo.
ResultSpecimenInfoOidBIGINTNOT NULL Foreign Key, which is the ObjectID of the table, HResultSpecimenInfo.
SpmObxSetIdSMALLINTNOT NULL Sequence Number for the Repeating OBX Segments within an SPM Segment in the R01 Message.
SpmObxValueTypeVARCHAR(4)NULL Data type of the ResultValue. This field is obtained from the inbound HL7 Results interface in the OBX.02.00.00.
SpmObxObsIdVARCHAR(20)NULL Identifier of the Observation sent after the SPM segment. For example, '1534'. This field is obtained from the inbound HL7 Results interface in the OBX.03.01.00.
SpmObxObsTextVARCHAR(199)NULL Text of the Observation sent after the SPM segment. For example, 'Age at Time of Collection'. This field is obtained from the inbound HL7 Results interface in the OBX.03.02.00.
SpmObxObsCodingSysVARCHAR(12)NULL Name of the Coding System for the Observation sent after the SPM segment. For example, 'L' for a Local Coding system. This field is obtained from the inbound HL7 Results interface in the OBX.03.03.00.
SpmObxObsAltIdVARCHAR(20)NULL Alternate Identifier of the Observation sent after the SPM segment. For example, 564-9. This field is obtained from the inbound HL7 Results interface in the OBX.03.04.00.
SpmObxObsAltTextVARCHAR(199)NULL Alternate Text of the Observation after the SPM segment. For example, 'Age at Time'. This field is obtained from the inbound HL7 Results interface in the OBX.03.05.00.
SpmObxObsNameOfAltCdSysVARCHAR(12)NULL Alternate Coding System of the Observation sent after the SPM segment. For example, 'LN' for LOINC. This field is obtained from the inbound HL7 Results interface in the OBX.03.06.00.
SpmObxObsOrginalTextVARCHAR(199)NULL Original Text of the Observation sent after the SPM segment. For example, Age at Time of collection'. This field is obtained from the inbound HL7 Results interface in the OBX.03.09.00.
SpmObxObsSubIdVARCHAR(20)NULL Sub Identifier of the Observation sent after the SPM segment. This field is obtained from the inbound HL7 Results interface in the OBX.04.00.00.
SpmObxObsValIdVARCHAR(20)NULL Result Value of the Observation sent after the SPM segment if the SPM OBX Value Type(OBX.02) is not equal to CWE or CE. For example, '25'. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00.
SpmObxObsValTextVARCHAR(199)NULL Result Value of the Observation sent after the SPM segment if SPM OBX Value Type(OBX.02) equals CWE, CE or SN. For example, '25'. This field is obtained from the inbound HL7 Results interface in the OBX.05.02.00.
SpmObxObsValCdSysVARCHAR(20)NULL Coding System of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CE or CWE. For example 'L' for Local. If the SPM OBX Value Type is valued with 'SN', this could contain '-', or '+' or '/' or '.' or ':'. This field is obtained from the inbound HL7 Results interface in the OBX.05.03.00.
SpmObxObsValAltIdVARCHAR(20)NULL Alternate Identifier of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CWE, CE or SN. For example, 25. This field is obtained from the inbound HL7 Results interface in the OBX.05.04.00.
SpmObxObsValAltTextVARCHAR(199)NULL Alternate Text of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CE or CWE. This field is obtained from the inbound HL7 Results interface in the OBX.05.05.00.
SpmObxObsValNameOfAltCdSysVARCHAR(20)NULL Name of Alternate Coding System of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CWE or CE. For example, LN for LOINC. This field is obtained from the inbound HL7 Results interface in the OBX.05.06.00.
SpmObxObsValCdSysVerIDVARCHAR(10)NULL Version Identifier of the Coding System associated to the Obseervation(OBX) of the Specimen(SPM). This field is obtained from the inbound HL7 Results interface in the OBX.05.07.00.
SpmObxObsValAltCdSysVerIDVARCHAR(10)NULL Version Identifier of the Alternate Coding System associated to the Observation(OBX) of the Specimen(SPM). This field is obtained from the inbound HL7 Results interface in the OBX.05.08.00.
SpmObxObsValOriginalTextVARCHAR(199)NULL Original Text of the Observation Value sent after the SPM segment. For example, 25 years old. This field is obtained from the inbound HL7 Results interface in the OBX.05.09.00.
SpmObxUnitsIdVARCHAR(20)NULL Unit of measure for the observation of the specimen(SPM segment). For example, UG/ML. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00.
SpmObxUnitsTextVARCHAR(199)NULL Textual description of the unit of measure for the observation of the specimen. This field is obtained from the inbound HL7 Results interface in the OBX.06.02.00.
SpmObxUnitsCodingSysVARCHAR(12)NULL Coding System of the Unit of measure for the observation of the specimen. For Example, UCUM. This field is obtained from the inbound HL7 Results interface in the OBX.06.03.00.
SpmObxUnitsAltIdVARCHAR(20)NULL Alternate Identifier of the Unit of measure for the observation of the specimen. For example, UG/ML. This field is obtained from the inbound HL7 Results interface in the OBX.06.04.00.
SpmObxUnitsAltTextVARCHAR(199)NULL Alternate Textual description of the Unit of measure sent for the observation of the specimen(OBX after SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.06.05.00.
SpmObxUnitsNameOfAltCdSysVARCHAR(12)NULL Alternate Coding System of the Unit of measure for the observation of the specimen(OBX after SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.06.06.00.
SpmObxUnitsOrginalTextVARCHAR(199)NULL Original Text of the Unit of measure for the observation of the specimen(OBX after SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.06.09.00.
SpmObxReferencesRangeVARCHAR(60)NULL ReferencesRange of the Observation of the specimen(OBX sent after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.07.00.00.
SpmObxAbnormalFlagsVARCHAR(4)NULL Abnormal Flags for the Observation of the specimen(OBX sent after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.08.00.00.
SpmObxObsResultStatusCHAR(1)NULL Result Status of the Observation of the specimen(OBX sent after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.11.00.00.
SpmObxObsDTimeMinsSMALLDATETIMENULL Observation DateTime of the specimen(OBX after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.14.00.00.
SpmObxObsAnalysisDTimeMinsSMALLDATETIMENULL Analysis DateTime sent for the observation of the specimen(OBX after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.19.01.00.
SpmObxPerformingOrgDetailOidINTNULL Foreign Key. It is the ObjectId of table HPerformingOrgDetail.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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