Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSensitivity This table stores information related to Micro Sensitivity Results.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDINTNOT NULLObject ID and primary key of the table, HSensitivity.
InstanceHFCIDSMALLINTNOT NULLHFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdINTNULL Record ID.
DescriptionVARCHAR(1)NULL User-defined description for the row.
IsDeletedTINYINTNOT NULLIndicates whether the result is deleted. Allowable Values: 0 - No, 1 - Yes.
IsVersionedBITNOT NULLIndicates 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.
ObservationIDVARCHAR(30)NULL ObservationID of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.01.00.
ObservationNameVARCHAR(199)NULL ObservationName of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.02.00.
InterpretationVARCHAR(10)NULL Interpretation of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.08.00.00.
ResultValueVARCHAR(255)NULL Value of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00.
ResultStatusCHAR(1)NULL Status of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.11.00.00. Allowable values: U(FinalResult), P(PreliminaryResult), S(PartialResult), F(FinalResult), C(CorrectedResult), D(DeletesOBXRecord) , I(SpecimenInLabResultsPending), N(NotAsked), R(ResultsEnteredNotVerified), O(OrderDetailsOnly), X(ResultsCanNotBeObtained), W(PostOriginalAsWrong)
ResultStatusCodeTINYINTNULL StatusCode of the Microbiology Result Sensitivity Associated with 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.
Result_oidBIGINTNOT NULLObjectId of the Parent Organism associated with the Microbiology Result. This is Foreign Key to HinvestigationResult table ObjectID.
SpecimenDescriptionVARCHAR(64)NULL SpecimenDescription of the Microbiology Result Sensitivity.
IsolateNumberTINYINTNULL IsolateNumber of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.20.00.00.
SensSetIdSMALLINTNULL Sequence Number For Repeating OBX Segments within Child OBXs sent for a Sensitivity in the R01 Message. This field is obtained from the inbound HL7 Results interface in the OBX.01.00.00.
SensValueTypeVARCHAR(4)NULL HL7 value type of the ResultValue that Follows in the OBX.5. This field is obtained from the inbound HL7 Results interface in the OBX.02.00.00 of Sensitivity. For example, AN(Ambiguous Numeric), CE(Coded), CWE(Coded with Exceptions), DT(Date/Time), FT(Formatted text), NM(Numeric), SN(Structured Numeric), ST(String text), TM(Time), TS(Time stamp), TX(Text data)
SensObsCodingSysVARCHAR(12)NULL Name of the Coding System for the Observation Sent with Child OBX's sent for the Sensitivity. For example, L(Local), LN(LOINC), SCT(SNOMED CT). This field is obtained from the inbound HL7 Results interface in the OBX.03.03.00.
SensObsAltIdVARCHAR(20)NULL Alternate Identifier of the Observation Sent with Child OBXs sent for Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.04.00.
SensObsAltTextVARCHAR(199)NULL Alternate Text of the Observation on Child OBXs sent for Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.05.00.
SensObsNameOfAltCodingSysVARCHAR(12)NULL Name of the Alternate Coding System of the Observation Sent with the Child OBXs sent for the Sensitivity. For example, L(Local), LN(LOINC), SCT(SNOMED CT). This field is obtained from the inbound HL7 Results interface in the OBX.03.06.00.
SensObsOrginalTextVARCHAR(199)NULL Original Text of the Observation Sent with Child OBXs sent for Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.09.00.
SensObsSubIdVARCHAR(20)NULL Sequence number from the HL7 OBX segment for the sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.04.00.00.
SensObsValueIdVARCHAR(20)NULL Observation Identifier for the sensitvity. This field is obtained from the inbound HL7 Results interface in the OBX.03.01.00 when the OBX.02.00.00 is valued with CWE, CE or SN.
SensObsValueTextVARCHAR(199)NULL Result value of the sensitivity. Sensitivities are obtained from the Child OBXs. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00 or OBX.05.02.00 depending on the value sent in the OBX.02.
SensObsValueCodingSysVARCHAR(20)NULL Coding System of the Sensitivity Result Value. 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.
SensObsValueAltIdVARCHAR(20)NULL Alternate Identifier of the Sensitivity result. This field is obtained from the inbound HL7 Results interface in the OBX.05.04.00.
SensObsValueAltTextVARCHAR(199)NULL Alternate Text associated with the Sensitivity result. This field is obtained from the inbound HL7 Results interface in the OBX.05.05.00.
SensObsValueNameOfAltCodingSysVARCHAR(20)NULL Alternate Coding System of the Observation Value Sent with Child OBXs sent for Sensitivity. 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.
SensObsValueCodingSysVerIDVARCHAR(10)NULL Coding System Version Identifier of the Observation Value Sent with Child OBXs sent for Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.05.07.00.
SensObsValueAltCodingSysVerIDVARCHAR(10)NULL Alternate Coding System Version Identifier of the Observation Value Sent with Child OBXs sent for Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.05.08.00.
SensObsValueOriginalTextVARCHAR(199)NULL Original Text of the Sensitvity Value. This field is obtained from the inbound HL7 Results interface in the OBX.05.09.00.
SensUnitsIdVARCHAR(20)NULL Unit of measure associated to the Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00.
SensUnitsTextVARCHAR(199)NULL Description of the unit of measure for the Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.06.02.00.
SensUnitsCodingSysVARCHAR(12)NULL Coding System of the unit of measure sent for the Sensitivity. For example, UCUM. This field is obtained from the inbound HL7 Results interface in the OBX.06.03.00.
SensUnitsAltIdVARCHAR(20)NULL Sensitvity's Alternate Identifier for the unit of measure. This field is obtained from the inbound HL7 Results interface in the OBX.06.04.00.
SensUnitsAltTextVARCHAR(199)NULL Alternate Text associated with the alternate identifier for the sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.06.05.00.
SensUnitsNameOfAltCodingSysVARCHAR(12)NULL Name of the Alternate Coding System for the sensitivity's Alternate Identifier. For example, UCUM. This field is obtained from the inbound HL7 Results interface in the OBX.06.06.00.
SensUnitsOrginalTextVARCHAR(199)NULL Original Text of the Unit of measure sent for the sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.06.09.00.
SensReferencesRangeVARCHAR(60)NULL Reference range associated to the sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.07.00.00.
SensObsDTimeMinsSMALLDATETIMENULL Observation DateTime Sent for the Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.14.00.00.
SensObsAnalysisDTimeMinsSMALLDATETIMENULL Analysis DateTime associated to the Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.19.01.00.
SensPerformingOrgDetailOidINTNULL Foreign Key. It contains the ObjectId of table HPerformingOrgDetail.
SensCommentVARCHAR(1500)NULL Ancillary comments associated to the sensitivity. They are Sent as NTE segments after the sensitivty OBX segments.
SensReqCommentVARCHAR(1500)NULL Requisition Comments associated to the sensitivity. They are sent as NTE Segments after the OBR segment.
ResultObsRequestCommonInfoOidBIGINTNULL Foreign Key. It contains the ObjectId of table HResultObsRequestCommonInfo.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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