Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ResultObsRequestCommonInfoOid | BIGINT | NOT NULL | Object ID and primary key of the table, HResultObsRequestCommonInfo. |
SendApplNameSpcId | VARCHAR(20) | NULL | An Identifier which indicates the Sending Application. For example, LAB. This field is obtained from the inbound HL7 Results interface in the MSH.03.01.00. |
SendApplUnivId | VARCHAR(199) | NULL | Universal Identifier for the Sending Application which is unique to that sending application. For example, the CLIA Id of the lab. This field is obtained from the inbound HL7 Results interface in the MSH.03.02.00. |
SendApplUnivIdType | VARCHAR(6) | NULL | Type of Universal Identifier used to identify the Sending Application. For example, CLIA. This field is obtained from the inbound HL7 Results interface in the MSH.03.03.00. |
SendFacilityNameSpcId | VARCHAR(20) | NULL | An Identifier which identifies the Sending Facility. This field is obtained from the inbound HL7 Results interface in the MSH.04.01.00. |
SendFacilityUnivId | VARCHAR(199) | NULL | Universal Identifier for the Sending Facility which is unique to that facility. This field is obtained from the inbound HL7 Results interface in the MSH.04.02.00. |
SendFacilityUnivIdType | VARCHAR(6) | NULL | Type of Universal Identifier used to identify the Sending Facility. For example, ISO. This field is obtained from the inbound HL7 Results interface in the MSH.04.03.00. |
ResultMessageProfileInfoOid | INT | NOT NULL | This stores processing information needed for the transaction. |
PlacerGrpNumEntityId | VARCHAR(199) | NULL | Entity Identifier for the Placer Group Number. This field is obtained from the inbound HL7 Results interface in the ORC.04.01.00. |
PlacerGrpNumNameSpcId | VARCHAR(20) | NULL | Name of the Placer Group Number. This field is obtained from the inbound HL7 Results interface in the ORC.04.02.00. |
PlacerGrpNumUnivId | VARCHAR(199) | NULL | Universal Identifier which identifies the Placer Group Number. This field is obtained from the inbound HL7 Results interface in the ORC.04.03.00. |
PlacerGrpNumUnivIdType | VARCHAR(6) | NULL | Type of universal Identifier used to identify the Placer Group Number. For example, ISO. This field is obtained from the inbound HL7 Results interface in the ORC.04.04.00. |
PlacerOrdNumEntityId | VARCHAR(199) | NULL | Soarian generated Order number, order occurrence number or Lab Id(LID). This field is obtained from the inbound HL7 Results interface in the OBR.02.01.00. |
PlacerOrdNumNameSpcId | VARCHAR(20) | NULL | Type of data that is stored in the PlacerNumberOrderID field. Allowable values: Null - indicates occurrence#, OrderID - indicates Order ID, Order_ID - Indicates Order ID, OccOrder_ID - Indicates occurrence #, LID - Indicates Sample collected lab id. This field is obtained from the inbound HL7 Results interface in the OBR.02.02.00. |
PlacerOrdNumUnivId | VARCHAR(199) | NULL | Universal Identifier which uniquely identifies the Placer Order Number. This field is obtained from the inbound HL7 Results interface in the OBR.02.03.00. |
PlacerOrdNumUnivIdType | VARCHAR(6) | NULL | Type of Universal Identifier used to identify the Placer Order Number. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.02.04.00. |
FillerOrdNumEntityId | VARCHAR(199) | NULL | Filler Order Number Entity Identifier. It is typically valued with the Specimen Number from the lab. This field is obtained from the inbound HL7 Results interface in the OBR.03.01.00. |
FillerOrdNumNameSpcId | VARCHAR(20) | NULL | Name associated to the Filler Order Number Identifier. This field is obtained from the inbound HL7 Results interface in the OBR.03.02.00. |
FillerOrdNumUnivId | VARCHAR(199) | NULL | Universal Identifier which uniquely identifies the Filler Order Number. This field is obtained from the inbound HL7 Results interface in the OBR.03.03.00. |
FillerOrdNumUnivIdType | VARCHAR(6) | NULL | Universal Identifier used for the Filler Order Number. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.03.04.00. |
UnivServIdText | VARCHAR(199) | NULL | Textual description of the service which was ordered. For example, Throat Culture. This field is obtained from the inbound HL7 Results interface in the OBR.04.02.00. |
UnivServIdCdSys | VARCHAR(12) | NULL | Name of the Coding System of the Universal Service Identifier. For example, LOINC. This field is obtained from the inbound HL7 Results interface in the OBR.04.03.00. |
UnivServIdAltId | VARCHAR(20) | NULL | Alternate Identifier of the Universal Service Identifier. For example, a SNOMED, LOINC or Local identifier for the result. This field is obtained from the inbound HL7 Results interface in the OBR.04.04.00. |
UnivServIdAltText | VARCHAR(199) | NULL | Textual description of the Alternate Identifier. For example, Throat Culture. This field is obtained from the inbound HL7 Results interface in the OBR.04.05.00. |
UnivServIdNameOfAltCdSys | VARCHAR(12) | NULL | Name of the Alternate Coding System of the Universal Service Identifier. for example, SNOMED, LOINC, etc. This field is obtained from the inbound HL7 Results interface in the OBR.04.06.00. |
UnivServIdOriginalText | VARCHAR(199) | NULL | Original Textual description of the Universal Service Identifier. For example, Throat Culture. This field is obtained from the inbound HL7 Results interface in the OBR.04.09.00. |
ObservationEndDTimeMins | SMALLDATETIME | NULL | End date/time of the Observation. This field is obtained from the inbound HL7 Results interface in the OBR.08.00.00. |
SpecimenActionCode | CHAR(1) | NULL | Specimen Action Code to further define the type of Result. This field is obtained from the inbound HL7 Results interface in the OBR.11.00.00. Possible Values: A - Add ordered tests to the existing specimen, L - Lab to Obtain specimen from patient, G - Generated Order, Reflex Order, O - specimen obtained by service other than Lab. Micro Results are identified with a 'G'. |
OrdProviderIdNum | VARCHAR(15) | NULL | Ordering Provider Identifier Number. This field is obtained from the inbound HL7 Results interface in the OBR.16.01.00. |
OrdProviderLastName | VARCHAR(50) | NULL | Ordering Provider Last Name. This field is obtained from the inbound HL7 Results interface in the OBR.16.02.01. |
OrdProviderFirstName | VARCHAR(30) | NULL | Ordering Provider First Name. This field is obtained from the inbound HL7 Results interface in the OBR.16.03.00. |
OrdProviderInitials | VARCHAR(30) | NULL | Ordering Provider Middle Initial. This field is obtained from the inbound HL7 Results interface in the OBR.16.04.00. |
OrdProviderSuffix | VARCHAR(20) | NULL | Ordering Provider Name Suffix. This field is obtained from the inbound HL7 Results interface in the OBR.16.05.00. |
OrdProviderPrefix | VARCHAR(20) | NULL | Ordering Provider Name Prefix. This field is obtained from the inbound HL7 Results interface in the OBR.16.06.00. |
OrdProviderAsgnAuthNameSpcId | VARCHAR(20) | NULL | Ordering Provider Assigning Authority NameSpace Identifier. This field is obtained from the inbound HL7 Results interface in the OBR.16.09.01. |
OrdProviderAsgnAuthUnivId | VARCHAR(199) | NULL | Ordering Provider Assigning Authority Universal Identifier which uniquely identifies the provider. This field is obtained from the inbound HL7 Results interface in the OBR.16.09.02. |
OrdProviderAsgnAuthUnivIdType | VARCHAR(6) | NULL | Type of Universal Identifier used for the Ordering Provider Assigning Authority. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.16.09.03. |
OrdProviderNameTypeCode | VARCHAR(5) | NULL | Ordering Provider Name Type Code. This field is obtained from the inbound HL7 Results interface in the OBR.16.10.00. |
OrdProviderIdTypeCode | VARCHAR(5) | NULL | Type of identifier used for the Ordering Provider. For example NPI#. This field is obtained from the inbound HL7 Results interface in the OBR.16.13.00. |
ObrStatusCode | CHAR(1) | NULL | Result Status or the Culture status. This field is obtained from the inbound HL7 Results interface in the OBR.25.00.00. Values include: A - Some but not all, results available, C - Correction to results, F - Final Results, I - No results available; specimen received, procedure incomplete, O - Order Received; specimen not yet received, P - Preliminary; A Verified early result is available, R - Results stored; not yet verified, S - No results available; procedure scheduled but not done, X - No Results available ; order cancelled. |
ParentResId | VARCHAR(20) | NULL | Used to link micro sensitivities to the culture result. The field contains an Identifier which was sent in the OBX.03 of the Parent Result so that they can be linked. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.01. |
ParentResText | VARCHAR(199) | NULL | Used to link micro sensitivities to the culture result. The field contains the Text which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.02. |
ParentResCdSys | VARCHAR(12) | NULL | Used to link micro sensitivities to the culture result. The field contains the Name Of Coding System which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.03. |
ParentResAltId | VARCHAR(20) | NULL | Used to link micro sensitivities to the culture result. The field contains the Alternate Identifier which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.04. |
ParentResAltText | VARCHAR(199) | NULL | Used to link micro sensitivities to the culture result. The field contains the Alternate Text which was sent in the OBX.03 of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.05. |
ParentResNameOfAltCdSys | VARCHAR(12) | NULL | Used to link micro sensitivities to the culture result. The field contains the Name Of Alternate Coding System which was sent in the OBX.03 of the Parent result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.06. |
ParentResOriginalText | VARCHAR(199) | NULL | Used to link micro sensitivities to the culture result. The field contains the Original text of the Parent Result. This field is obtained from the inbound HL7 Results interface in the OBR.26.01.09. |
ParentObsSubId | VARCHAR(20) | NULL | Used to link micro sensitivities to the culture result. The field contains the Parent Observation Sub Identifier which was sent in the OBX.04 of the parent. This field is obtained from the inbound HL7 Results interface in the OBR.26.02.00. |
ParentPlacerAsgnIdEntityId | VARCHAR(199) | NULL | AssigningId Entity Identifier of the Parent Placer. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.01. |
ParentPlacerAsgnIdNameSpcId | VARCHAR(20) | NULL | AssigningId NameSpace Identifier of the Parent Placer. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.02. |
ParentPlacerAsgnIdUnivId | VARCHAR(199) | NULL | AssigningId Universal Identifier of the Parent Placer. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.03. |
ParentPlacerAsgnIdUnivIdType | VARCHAR(6) | NULL | Universal Identifier type used for the AssigningId of the Parent Placer. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.29.01.04. |
ParentFillerAsgnIdEntityId | VARCHAR(199) | NULL | AssigningId Entity Identifier of the Parent Filler. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.01. |
ParentFillerAsgnIdNameSpcId | VARCHAR(20) | NULL | AssigningId NameSpace Identifier of the Parent Filler. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.02. |
ParentFillerAsgnIdUnivId | VARCHAR(199) | NULL | Universal Identifier which uniquely identifies the AssigningId of the Parent Filler. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.03. |
ParentFillerAsgnIdUnivIdType | VARCHAR(6) | NULL | Universal identier type of the AssigningId of the Parent Filler. For example, ISO. This field is obtained from the inbound HL7 Results interface in the OBR.29.02.04. |
PrinResRdrIdNumber | VARCHAR(15) | NULL | Identifier of the Doctor who read the results(Reading Doctor). This field is obtained from the inbound HL7 Results interface in the OBR.32.01.01. |
PrinResRdrSourceTable | VARCHAR(4) | NULL | Reading Doctor Source Table. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.08. |
PrinResRdrAsgnAuthNameSpcId | VARCHAR(20) | NULL | Entitiy specific staff Identifier of the Reading Doctor. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.09. |
PrinResRdrAsgnAuthUnivId | VARCHAR(199) | NULL | Reading Doctor Assigning Authority Universal Identifier. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.10. |
PrinResRdrAsgnAuthUnivIdType | VARCHAR(6) | NULL | Universal identifier Type used to identify the Reading Doctor Assigning Authority. For exmaple, NPI. This field is obtained from the inbound HL7 Results interface in the OBR.32.01.11. |
TechnicianIdNumber | VARCHAR(15) | NULL | Identifier Number of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.01. |
TechnicianSourceTable | VARCHAR(4) | NULL | Source Table of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.08. |
TechnicianAsgnAuthNameSpcId | VARCHAR(20) | NULL | Assigning Authority NameSpace Identifier of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.09. |
TechnicianAsgnAuthUnivId | VARCHAR(199) | NULL | Assigning Authority Universal Identifier of the Technician. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.10. |
TechnicianAsgnAuthUnivIdType | VARCHAR(6) | NULL | Type of Universal Identifier used to identify the Assigning Authority of the Technician. For example, NPI. This field is obtained from the inbound HL7 Results interface in the OBR.34.01.11. |
ParentUnivServId | VARCHAR(20) | NULL | Universal Service Identifier of the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.01.00. |
ParentUnivServIdText | VARCHAR(199) | NULL | Text name for the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.02.00. |
ParentUnivServIdCdSys | VARCHAR(20) | NULL | Name of Coding System of the Universal Service Identifier used in the parent order. For example, LOINC. This field is obtained from the inbound HL7 Results interface in the OBR.50.03.00. |
ParentUnivServIdAltId | VARCHAR(20) | NULL | Alternate Identifier of the Universal Service Identifier used in the Parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.04.00. |
ParentUnivServIdAltText | VARCHAR(199) | NULL | Alternate Text of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.05.00. |
ParentUnivServIdNmOfAltCdSys | VARCHAR(20) | NULL | Name of Alternate Coding System of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.06.00. |
ParentUnivServIdCdSysVerId | VARCHAR(10) | NULL | Coding System Version Identifier of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.07.00. |
ParentUnivServIdAltCdSysVerId | VARCHAR(10) | NULL | Alternate Coding System Version Identifier of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.08.00. |
ParentUnivServIdOriginalText | VARCHAR(199) | NULL | Original Text of the Universal Service Identifier used in the parent order. This field is obtained from the inbound HL7 Results interface in the OBR.50.09.00. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time. |