Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ResultSpecimenInfoOid | BIGINT | NOT NULL | Object ID and primary key of the table, HResultSpecimenInfo. |
ResultObsRequestCommonInfoOid | BIGINT | NOT NULL | Foreign key, which is the ObjectID of the table, HResultObsRequestCommonInfo. |
SpecimenSequence | SMALLINT | NOT NULL | Sequence Number for Repeating SPM Segments in the R01 Message. |
SpmId | VARCHAR(80) | NULL | Specimen Identifier. This field is obtained from the inbound HL7 Results interface in the SPM.02.02.01. |
SpmTypeId | VARCHAR(20) | NULL | Specimen Type Identifier. For example, BLD. This field is obtained from the inbound HL7 Results interface in the SPM.04.01.00. |
SpmTypeText | VARCHAR(199) | NULL | Specimen Type Text. For example, BLOOD. This field is obtained from the inbound HL7 Results interface in the SPM.04.02.00. |
SpmTypeCdSys | VARCHAR(12) | NULL | Specimen Type Coding System. For example, "L" for Local, 'LN' for LOINC, 'SCT' for SNOMED CT. This field is obtained from the inbound HL7 Results interface in the SPM.04.03.00. |
SpmTypeAltId | VARCHAR(20) | NULL | Specimen Type Alternate Identifier. For example, 119297000(SNOMED code for blood) This field is obtained from the inbound HL7 Results interface in the SPM.04.04.00. |
SpmTypeAltText | VARCHAR(199) | NULL | Specimen Type Alternate Text. For example, BLD. This field is obtained from the inbound HL7 Results interface in the SPM.04.05.00. |
SpmTypeNameOfAltCdSys | VARCHAR(12) | NULL | Specimen Type Name of Alternate Coding System. For example, 'SCT' for SNOMED CT, 'L' for Local, 'LN' for LOINC. This field is obtained from the inbound HL7 Results interface in the SPM.04.06.00. |
SpmTypeOrginalText | VARCHAR(199) | NULL | Specimen Type Original Text. For example, 'Blood Specimen'. This field is obtained from the inbound HL7 Results interface in the SPM.04.09.00. |
SpmSourceSiteId | VARCHAR(20) | NULL | Specimen Source Site Identifier. For example, 372237002. This field is obtained from the inbound HL7 Results interface in the SPM.08.01.00. |
SpmSourceSiteText | VARCHAR(199) | NULL | Specimen Source Site Text. For example, 'Rectum part(body structre)'. This field is obtained from the inbound HL7 Results interface in the SPM.08.02.00. |
SpmSourceSiteCdSys | VARCHAR(20) | NULL | Specimen Source Site Coding System. For example, 'SCT' for SNOMED CT. This field is obtained from the inbound HL7 Results interface in the SPM.08.03.00. |
SpmSourceSiteAltId | VARCHAR(20) | NULL | Specimen Source Site Alternate Identifier. For example, 'REC'. This field is obtained from the inbound HL7 Results interface in the SPM.08.04.00. |
SpmSourceSiteAltText | VARCHAR(199) | NULL | Specimen Source Site Alternate Text. For example, 'Rectum'. This field is obtained from the inbound HL7 Results interface in the SPM.08.05.00. |
SpmSourceSiteNameOfAltCdSys | VARCHAR(20) | NULL | Specimen Source Site Name of Atlternate Coding System. For example, 'L' for Local code. This field is obtained from the inbound HL7 Results interface in the SPM.08.06.00. |
SpmSourceSiteCdSysVerId | VARCHAR(10) | NULL | Specimen Source Site Coding System Version Identifier. This field is obtained from the inbound HL7 Results interface in the SPM.08.07.00. |
SpmSourceSiteAltCdSysVerId | VARCHAR(10) | NULL | Specimen Source Site Alternate Coding System Version Identifier. This field is obtained from the inbound HL7 Results interface in the SPM.08.08.00. |
SpmSourceSiteOrginalText | VARCHAR(199) | NULL | Specimen Source Site Original Text. For example, 'Rectum'. This field is obtained from the inbound HL7 Results interface in the SPM.08.09.00. |
SpmCollectionStartDTimeMins | SMALLDATETIME | NULL | Specimen Collection Start DateTime. This field is obtained from the inbound HL7 Results interface in the SPM.17.01.01. |
SpmCollectionEndDTimeMins | SMALLDATETIME | NULL | Specimen Collection End DateTime. This field is obtained from the inbound HL7 Results interface in the SPM.17.02.01. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time. |