Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ResultSpecimenOBXInfoOid | BIGINT | NOT NULL | Object ID and primary key of the table, HResultSpecimenOBXInfo. |
ResultSpecimenInfoOid | BIGINT | NOT NULL | Foreign Key, which is the ObjectID of the table, HResultSpecimenInfo. |
SpmObxSetId | SMALLINT | NOT NULL | Sequence Number for the Repeating OBX Segments within an SPM Segment in the R01 Message. |
SpmObxValueType | VARCHAR(4) | NULL | Data type of the ResultValue. This field is obtained from the inbound HL7 Results interface in the OBX.02.00.00. |
SpmObxObsId | VARCHAR(20) | NULL | Identifier of the Observation sent after the SPM segment. For example, '1534'. This field is obtained from the inbound HL7 Results interface in the OBX.03.01.00. |
SpmObxObsText | VARCHAR(199) | NULL | Text of the Observation sent after the SPM segment. For example, 'Age at Time of Collection'. This field is obtained from the inbound HL7 Results interface in the OBX.03.02.00. |
SpmObxObsCodingSys | VARCHAR(12) | NULL | Name of the Coding System for the Observation sent after the SPM segment. For example, 'L' for a Local Coding system. This field is obtained from the inbound HL7 Results interface in the OBX.03.03.00. |
SpmObxObsAltId | VARCHAR(20) | NULL | Alternate Identifier of the Observation sent after the SPM segment. For example, 564-9. This field is obtained from the inbound HL7 Results interface in the OBX.03.04.00. |
SpmObxObsAltText | VARCHAR(199) | NULL | Alternate Text of the Observation after the SPM segment. For example, 'Age at Time'. This field is obtained from the inbound HL7 Results interface in the OBX.03.05.00. |
SpmObxObsNameOfAltCdSys | VARCHAR(12) | NULL | Alternate Coding System of the Observation sent after the SPM segment. For example, 'LN' for LOINC. This field is obtained from the inbound HL7 Results interface in the OBX.03.06.00. |
SpmObxObsOrginalText | VARCHAR(199) | NULL | Original Text of the Observation sent after the SPM segment. For example, Age at Time of collection'. This field is obtained from the inbound HL7 Results interface in the OBX.03.09.00. |
SpmObxObsSubId | VARCHAR(20) | NULL | Sub Identifier of the Observation sent after the SPM segment. This field is obtained from the inbound HL7 Results interface in the OBX.04.00.00. |
SpmObxObsValId | VARCHAR(20) | NULL | Result Value of the Observation sent after the SPM segment if the SPM OBX Value Type(OBX.02) is not equal to CWE or CE. For example, '25'. This field is obtained from the inbound HL7 Results interface in the OBX.05.01.00. |
SpmObxObsValText | VARCHAR(199) | NULL | Result Value of the Observation sent after the SPM segment if SPM OBX Value Type(OBX.02) equals CWE, CE or SN. For example, '25'. This field is obtained from the inbound HL7 Results interface in the OBX.05.02.00. |
SpmObxObsValCdSys | VARCHAR(20) | NULL | Coding System of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CE or CWE. For example 'L' for Local. If the SPM OBX Value Type is valued with 'SN', this could contain '-', or '+' or '/' or '.' or ':'. This field is obtained from the inbound HL7 Results interface in the OBX.05.03.00. |
SpmObxObsValAltId | VARCHAR(20) | NULL | Alternate Identifier of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CWE, CE or SN. For example, 25. This field is obtained from the inbound HL7 Results interface in the OBX.05.04.00. |
SpmObxObsValAltText | VARCHAR(199) | NULL | Alternate Text of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CE or CWE. This field is obtained from the inbound HL7 Results interface in the OBX.05.05.00. |
SpmObxObsValNameOfAltCdSys | VARCHAR(20) | NULL | Name of Alternate Coding System of the Observation Value sent after the SPM segment when the SPM OBX Value Type(OBX.02) equals CWE or CE. For example, LN for LOINC. This field is obtained from the inbound HL7 Results interface in the OBX.05.06.00. |
SpmObxObsValCdSysVerID | VARCHAR(10) | NULL | Version Identifier of the Coding System associated to the Obseervation(OBX) of the Specimen(SPM). This field is obtained from the inbound HL7 Results interface in the OBX.05.07.00. |
SpmObxObsValAltCdSysVerID | VARCHAR(10) | NULL | Version Identifier of the Alternate Coding System associated to the Observation(OBX) of the Specimen(SPM). This field is obtained from the inbound HL7 Results interface in the OBX.05.08.00. |
SpmObxObsValOriginalText | VARCHAR(199) | NULL | Original Text of the Observation Value sent after the SPM segment. For example, 25 years old. This field is obtained from the inbound HL7 Results interface in the OBX.05.09.00. |
SpmObxUnitsId | VARCHAR(20) | NULL | Unit of measure for the observation of the specimen(SPM segment). For example, UG/ML. This field is obtained from the inbound HL7 Results interface in the OBX.06.01.00. |
SpmObxUnitsText | VARCHAR(199) | NULL | Textual description of the unit of measure for the observation of the specimen. This field is obtained from the inbound HL7 Results interface in the OBX.06.02.00. |
SpmObxUnitsCodingSys | VARCHAR(12) | NULL | Coding System of the Unit of measure for the observation of the specimen. For Example, UCUM. This field is obtained from the inbound HL7 Results interface in the OBX.06.03.00. |
SpmObxUnitsAltId | VARCHAR(20) | NULL | Alternate Identifier of the Unit of measure for the observation of the specimen. For example, UG/ML. This field is obtained from the inbound HL7 Results interface in the OBX.06.04.00. |
SpmObxUnitsAltText | VARCHAR(199) | NULL | Alternate Textual description of the Unit of measure sent for the observation of the specimen(OBX after SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.06.05.00. |
SpmObxUnitsNameOfAltCdSys | VARCHAR(12) | NULL | Alternate Coding System of the Unit of measure for the observation of the specimen(OBX after SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.06.06.00. |
SpmObxUnitsOrginalText | VARCHAR(199) | NULL | Original Text of the Unit of measure for the observation of the specimen(OBX after SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.06.09.00. |
SpmObxReferencesRange | VARCHAR(60) | NULL | ReferencesRange of the Observation of the specimen(OBX sent after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.07.00.00. |
SpmObxAbnormalFlags | VARCHAR(4) | NULL | Abnormal Flags for the Observation of the specimen(OBX sent after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.08.00.00. |
SpmObxObsResultStatus | CHAR(1) | NULL | Result Status of the Observation of the specimen(OBX sent after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.11.00.00. |
SpmObxObsDTimeMins | SMALLDATETIME | NULL | Observation DateTime of the specimen(OBX after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.14.00.00. |
SpmObxObsAnalysisDTimeMins | SMALLDATETIME | NULL | Analysis DateTime sent for the observation of the specimen(OBX after the SPM segment). This field is obtained from the inbound HL7 Results interface in the OBX.19.01.00. |
SpmObxPerformingOrgDetailOid | INT | NULL | Foreign Key. It is the ObjectId of table HPerformingOrgDetail. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time. |