Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | bigint | NOT NULL | Object ID and primary key of the table, HInvestigationResultSuppInfo_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 | 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. |
FindingName | varchar(64) | NULL | Name of the Finding. This field is obtained from the inbound HL7 Results interface in the OBx.03.01.00. |
StatusEnteredDateTime | datetime | NULL | Date/time when the result was entered in ancillary system. This field is obtained from the inbound HL7 Results interface in the OBR.22.00.00. |
SignedByName | varchar(90) | NULL | Name of the staff who has signed the result. |
ProviderUnitAbbreviation | varchar(10) | NULL | Provider unit abbreviation. This field is obtained from the inbound HL7 Results interface in the OBX.15.01.00. |
RequestorUnitAbbreviation | varchar(10) | NULL | Requester unit abbreviation. This field is obtained from the inbound HL7 Results interface in the OBX.21.03.00. |
RecipientUnitAbbreviation | varchar(10) | NULL | Recipient unit abbreviation. |
ResultSourceUnitAbbreviation | varchar(10) | NULL | Result source unit abbreviation. |
CriticalReferenceRange | varchar(80) | NULL | Critical range for that result. |
ReasonForRevision | varchar(200) | NULL | Reason for revising the result. |
Priority | varchar(32) | NULL | Priority for that result. Allowable Values: Routine, Timing Critical, Now Routine, As soon as possible, Pre operative, Call back, Stat. |
PriorityCode | smallint | NULL | Priority code for that result. Allowable Values: 0 - Routine, 1 - Timing Critical, 2 - Now Routine, 3 - As soon as possible, 4 - Pre operative, 5 - Call back, 6 - Stat. |
EnteredByName | varchar(12) | NULL | Name who has entered that result. This field is obtained from the inbound HL7 Results interface in the MSH.03.01.00. |
IsResultSentOut | tinyint | NOT NULL | Indicates whether the result is sent outbound. |
FormID | int | NULL | This field indicates the FormID of Adaptable Forms. |
RequestedByName | varchar(90) | NULL | Name who has requested that test. This field is obtained from the inbound HL7 Results interface in the OBR.16.01.00. |
InstDtTime | smalldatetime | NULL | Instance DateTime for that adaptable form. |
EDVersion | varchar(50) | NULL | Encapsulated Data Version eg. XSLT ver 1.0. This field is obtained from the inbound HL7 Results interface in the OBR.05.01.00. |
ReadingDr | varchar(90) | NULL | Reading Physician Information from the Inbound Result and Adaptable Form. |
DocID | int | NULL | This field indicates the Object ID for the document. |
PerformedBy | varchar(90) | NULL | Name of staff who Performed the test. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.01. |
OriginID | varchar(12) | NULL | Origin from where the result has come i.e. Rules Engine, Workflow Engine, Digital Dictation etc. |
SignedDateTime | smalldatetime | NULL | Date/Time when the Result has been signed. |
ResultIdentifierDetailOid | int | NULL | Relation to Non HFC HResultIdentifierDetail Table. |
ResultObsRequestCommonInfoOid | bigint | NULL | Foreign Key Relation, ObjectId of the NON HFC Table HResultObsRequestCommonInfo. |
ObxSetId | smallint | NULL | Sequence Number of The repeating OBX segments. This field is obtained from the inbound HL7 Results interface in the OBX.01.00.00. |
UnivServId | varchar(20) | NULL | Universal ServiceID. This field is obtained from the inbound HL7 Results interface in the OBR.04.01.00. |
SpecimenSourceSite | varchar(199) | NULL | Specimen Source Site read from the SPM.8 in the R01 Message. This field is obtained from the inbound HL7 Results interface in the SPM.08.00.00. |
TimingQtyStartDTimeMins | smalldatetime | NULL | Timing Quantity Start Date time. This field is obtained from the inbound HL7 Results interface in the OBX.07.01.00. |
TimingQtyEndDTimeMins | smalldatetime | NULL | Timing Quantity End Date time. This field is obtained from the inbound HL7 Results interface in the TQ1.08.00.01. |
ObsSubId | varchar(20) | NULL | Observation Sub Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.04.00.00. |
AnalysisDTimeMins | smalldatetime | NULL | Analysis Date Time. This field is obtained from the inbound HL7 Results interface in the OBX.19.00.00. |
ObsValId | varchar(20) | NULL | Observation Value Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00. |
ObsValText | varchar(199) | NULL | Observation Value Text. This field is obtained from the inbound HL7 Results interface in the OBX.05.02.00. |
ObsValCodingSys | varchar(20) | NULL | Observation Value Coding System. 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. |
ObsValAltId | varchar(20) | NULL | Observation Value Alternate Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.05.04.00. |
ObsValAltText | varchar(199) | NULL | Observation Value Alternate Text. This field is obtained from the inbound HL7 Results interface in the OBX.05.05.00. |
ObsValNameOfAltCodingSys | varchar(20) | NULL | Observation Value Name Of Alternate Coding System. 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. |
ObsValCodingSysVerId | varchar(10) | NULL | Observation Value Coding System VersionId. This field is obtained from the inbound HL7 Results interface in the OBX.05.07.00. |
ObsValAltCodingSysVerID | varchar(10) | NULL | Observation Value Alternate Coding System VersionID. This field is obtained from the inbound HL7 Results interface in the OBX.05.08.00. |
ObsValOriginalText | varchar(199) | NULL | Original Text given for the Observation Value. This field is obtained from the inbound HL7 Results interface in the OBX.05.09.00. |
ResUnitId | varchar(20) | NULL | Result Unit Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00. |
ResUnitText | varchar(199) | NULL | Text of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.02.00. |
ResUnitCodingSys | varchar(12) | NULL | Name of the Coding System of the Result Unit. For example, UCUM. This field is obtained from the inbound HL7 Results interface in the OBX.06.03.00. |
ResUnitAltId | varchar(20) | NULL | Alternate Identifier of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.04.00. |
ResUnitAltText | varchar(199) | NULL | Alternate Text of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.05.00. |
ResUnitNameOfAltCodingSys | varchar(12) | NULL | Name of Alternate Coding System of the Result Unit. For example, L(local), LN(LOINC), SCT(SNOMED CT). This field is obtained from the inbound HL7 Results interface in the OBX.06.06.00. |
ResUnitOriginalText | varchar(199) | NULL | Original Text of the Result Unit. This field is obtained from the inbound HL7 Results interface in the OBX.06.09.00. |
ObsIdOriginalText | varchar(199) | NULL | Original Text of the Observation Identifier. This field is obtained from the inbound HL7 Results interface in the OBX.03.09.00. |
MessageVersion | varchar(8) | NULL | HL7 Version of the Message that was used for Sending the current Result. This field is obtained from the inbound HL7 Results interface in the MSH.12.00.00. |
LastCngDtime | datetime | NULL | Current Universal Time Coordinate or Greenwich Mean Time. |
|
|