Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | bigint | NOT NULL | Object ID and primary key of the table, HInvestigationResult_Active. |
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 identification of an object across the application. |
RecordId | int | NULL | Indicates the 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. |
FindingAbbreviation | varchar(16) | NOT NULL | Abbreviation set for the name of the finding. This field is obtained from the inbound HL7 Results interface in the OBR.04.01.00. |
ResultStatus | char(1) | NOT NULL | Status of the Result. This field is obtained from the inbound HL7 Results interface in the OBX.11.00.00. Allowable value: 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 | NOT NULL | Code for 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. |
ReferenceRange | varchar(80) | NULL | Reference range for the Result. This field is obtained from the inbound HL7 Results interface in the OBX.07.00.00. |
UnitOfReferenceRange | varchar(16) | NULL | Unit of Measure. For example,(g/g)/s. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00. |
DeviatingIndicatorCode | tinyint | NULL | Code that indicates the Severity of the Result. Allowable value: L - 0, N - 1, H - 2, A - 4, LL - 5, HH - 6, AA - 7. |
ResultDateTime | datetime | NOT NULL | Date Time that the Result was saved in the Soarian System. |
ObservationDateTime | smalldatetime | NULL | Clinically relevant Date Time of the result. For Lab results, this is typically the Sample collection date/time. This field is obtained from the inbound HL7 Results interfac OBR.07.00.00 or OBX.14. The OBX.14 takes precedence. |
IsExternalResult | tinyint | NOT NULL | Indicates whether the Result is an interface Or Manually Entered Result. Allowable Values: 0 - Manual, 1 - Interface. |
ServiceProviderOrderID | varchar(80) | NULL | Unique Service Provider Order ID of a Result. This field is obtained from the inbound HL7 Results interface in the OBR.02.01.00. |
AbnormalFlag | varchar(5) | NULL | Severity of the Result based on HL7 standard values. This field is obtained from the inbound HL7 Results interface in the OBX.08.00.00. Allowable value: L - Below low normal, LL - Below lower panic limits, H - Above high normal, HH - Above upper panic limits, A - Abnormal, AA - Very abnormal, N - Normal. |
Comments | varchar(80) | NULL | Comments for the OBX Segment. |
Signed | tinyint | NOT NULL | Indicates whether the Result is signed or not. Allowable Values: 0 - NO, 1 - Yes. |
ResultValue | varchar(80) | NULL | Result Value. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00. |
ResultDataType | varchar(4) | NULL | HL7 Data Type of a Result. This field is obtained from the inbound HL7 Results interface in the OBX.02.00.00. |
ResultDataTypeCode | tinyint | NULL | Data type code of a ResultDataType. Allowable Values: NM - 0, ST - 1, CE - 2, TX - 3, Form - 6, ED - 7, RP - 8, AN - 10. |
RequisitionComments | varchar(80) | NULL | Comments provided for the Order(OBR) Segment. This field is obtained from the inbound HL7 Results interface in the NTE.03.00.00. |
SpecimenName | varchar(64) | NULL | Source of the Specimen i.e., sample collected(Eg : blood , urine). This field is obtained from the inbound HL7 Results interface in the OBR.15.01.02. |
ClinicalType | char(2) | NULL | Clinical type of the Result. Allowable Values: Mi - Micro Results. |
IsAmmended | tinyint | NOT NULL | Indicates whether the object is revised. Allowable Values: 0 - NO, 1 - Yes. |
MRUAbbreviation | varchar(10) | NULL | Abbreviation for the name of the MRU. |
IsRestricted | tinyint | NOT NULL | Indicates whether the Result is defined as being a sensitive/restricted result. Allowable Values: 0 - NO, 1 - Yes. |
ResultId | bigint | NULL | Result OID. When the Result is Revised, the Result OID is Valued with the ObjectID of the previous Result. |
IsRangeValueVersioned | tinyint | NOT NULL | Reference range of a result has been updated. Allowable Values: 0 - NO, 1 - Yes. |
InvalidationDateTime | smalldatetime | NOT NULL | Date time in which the Result is/will become invalidated. |
HasComment | tinyint | NOT NULL | Indicates whether the Result has comments. Allowable Values: 0 - NO, 1 - Yes. |
Service_oid | int | NULL | Object ID for the HService table. |
Patient_oid | int | NULL | ObjectOID of the HPatient. |
RequestedBy_oid | int | NULL | Ordering doctor. |
PatientVisit_oid | int | NULL | PatientVisit OID. |
PerformedBy_oid | int | NULL | User who has performed the Result. |
HTMLResult_oid | int | NULL | Object_id of HTML Result Type from HHTML table |
SignedBy_oid | int | NULL | Staff ObjectID who signed the Result. |
Occurrence_oid | bigint | NULL | Occurrence ObjectID of an Order to which this result is associated. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
RequestorUnit_oid | int | NULL | Requester Unit_Oid. |
VisitType | tinyint | NULL | Type of the Visit. Allowable Values: 0 - Active, 1 - closed. |
ResultSuppInfo_oid | bigint | NULL | ObjectID of the HinvestigationResultSuppInfo_Active table. This field is always a primary key for the HinvestigationResultSuppInfo_Active table. |
HasMultipleRefRanges | bit | NULL | Indicates whether the Result has MultipleRefRanges. Allowable Values: 0 - NO, 1 - Yes. |
UOMCode | varchar(16) | NULL | Code for the UnitOfMeasure. |
HasOnlyImage | tinyint | NOT NULL | Type of a Image Result. Allowable Values: 0 - text Result, 1 - image only Result, 2 - Image with text Result. |
ServiceTypeCode | smallint | NULL | Code for ServiceType. |
ServiceSubTypeCode | smallint | NULL | Code for ServiceSubType. |
HasForm | tinyint | NULL | Indicates whether the Result is entered using AT(Adaptability Tool) Forms. |
EDTypeCode | varchar(8) | NULL | Indicates whether the Result is PDF or RTF. Allowable Values: PDF - PDF Results, RTF - RTF Results. |
PerformingOrgDetail_oid | Int | Null | Object ID and Primary key of the table HPerformingOrgDetail. |
LastCngDtime | datetime | NULL | Current Universal Time Coordinate or Greenwich Mean Time. |
|