Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | INT | NOT NULL | Object ID and primary key of the table, HSensitivity. |
InstanceHFCID | SMALLINT | NOT NULL | HFC(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. |
RecordId | INT | NULL | Record ID. |
Description | VARCHAR(1) | NULL | User-defined description for the row. |
IsDeleted | TINYINT | NOT NULL | Indicates whether the result is deleted. Allowable Values: 0 - No, 1 - Yes. |
IsVersioned | BIT | NOT NULL | Indicates whether the result is modified. Allowable Values: 0 - No, 1 - Yes. |
CreatedUserId | INT | NULL | Object ID of the user who created the result. This field is linked to the HSUser table to get details about the user. |
CreationTime | SMALLDATETIME | NULL | Date and time when the Result is created. |
ObservationID | VARCHAR(30)NULL | | ObservationID of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.01.00. |
ObservationName | VARCHAR(199)NULL | | ObservationName of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.03.02.00. |
Interpretation | VARCHAR(10)NULL | | Interpretation of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.08.00.00. |
ResultValue | VARCHAR(255) | NULL | Value of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00. |
ResultStatus | CHAR(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) |
ResultStatusCode | TINYINT | NULL | 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_oid | BIGINT | NOT NULL | ObjectId of the Parent Organism associated with the Microbiology Result. This is Foreign Key to HinvestigationResult table ObjectID. |
SpecimenDescription | VARCHAR(64) | NULL | SpecimenDescription of the Microbiology Result Sensitivity. |
IsolateNumber | TINYINT | NULL | IsolateNumber of the Microbiology Result Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.20.00.00. |
SensSetId | SMALLINT | NULL | 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. |
SensValueType | VARCHAR(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) |
SensObsCodingSys | VARCHAR(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. |
SensObsAltId | VARCHAR(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. |
SensObsAltText | VARCHAR(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. |
SensObsNameOfAltCodingSys | VARCHAR(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. |
SensObsOrginalText | VARCHAR(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. |
SensObsSubId | VARCHAR(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. |
SensObsValueId | VARCHAR(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. |
SensObsValueText | VARCHAR(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. |
SensObsValueCodingSys | VARCHAR(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. |
SensObsValueAltId | VARCHAR(20) | NULL | Alternate Identifier of the Sensitivity result. This field is obtained from the inbound HL7 Results interface in the OBX.05.04.00. |
SensObsValueAltText | VARCHAR(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. |
SensObsValueNameOfAltCodingSys | VARCHAR(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. |
SensObsValueCodingSysVerID | VARCHAR(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. |
SensObsValueAltCodingSysVerID | VARCHAR(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. |
SensObsValueOriginalText | VARCHAR(199) | NULL | Original Text of the Sensitvity Value. This field is obtained from the inbound HL7 Results interface in the OBX.05.09.00. |
SensUnitsId | VARCHAR(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. |
SensUnitsText | VARCHAR(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. |
SensUnitsCodingSys | VARCHAR(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. |
SensUnitsAltId | VARCHAR(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. |
SensUnitsAltText | VARCHAR(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. |
SensUnitsNameOfAltCodingSys | VARCHAR(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. |
SensUnitsOrginalText | VARCHAR(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. |
SensReferencesRange | VARCHAR(60) | NULL | Reference range associated to the sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.07.00.00. |
SensObsDTimeMins | SMALLDATETIME | NULL | Observation DateTime Sent for the Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.14.00.00. |
SensObsAnalysisDTimeMins | SMALLDATETIME | NULL | Analysis DateTime associated to the Sensitivity. This field is obtained from the inbound HL7 Results interface in the OBX.19.01.00. |
SensPerformingOrgDetailOid | INT | NULL | Foreign Key. It contains the ObjectId of table HPerformingOrgDetail. |
SensComment | VARCHAR(1500) | NULL | Ancillary comments associated to the sensitivity. They are Sent as NTE segments after the sensitivty OBX segments. |
SensReqComment | VARCHAR(1500) | NULL | Requisition Comments associated to the sensitivity. They are sent as NTE Segments after the OBR segment. |
ResultObsRequestCommonInfoOid | BIGINT | NULL | Foreign Key. It contains the ObjectId of table HResultObsRequestCommonInfo. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|