Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultSpecimenInfo This table stores Specimen information related to a Result.
Column Name Column Datatype Column Null Option Column Comment
ResultSpecimenInfoOidBIGINTNOT NULL Object ID and primary key of the table, HResultSpecimenInfo.
ResultObsRequestCommonInfoOidBIGINTNOT NULL Foreign key, which is the ObjectID of the table, HResultObsRequestCommonInfo.
SpecimenSequenceSMALLINTNOT NULL Sequence Number for Repeating SPM Segments in the R01 Message.
SpmIdVARCHAR(80)NULL Specimen Identifier. This field is obtained from the inbound HL7 Results interface in the SPM.02.02.01.
SpmTypeIdVARCHAR(20)NULL Specimen Type Identifier. For example, BLD. This field is obtained from the inbound HL7 Results interface in the SPM.04.01.00.
SpmTypeTextVARCHAR(199)NULL Specimen Type Text. For example, BLOOD. This field is obtained from the inbound HL7 Results interface in the SPM.04.02.00.
SpmTypeCdSysVARCHAR(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.
SpmTypeAltIdVARCHAR(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.
SpmTypeAltTextVARCHAR(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.
SpmTypeNameOfAltCdSysVARCHAR(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.
SpmTypeOrginalTextVARCHAR(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.
SpmSourceSiteIdVARCHAR(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.
SpmSourceSiteTextVARCHAR(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.
SpmSourceSiteCdSysVARCHAR(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.
SpmSourceSiteAltIdVARCHAR(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.
SpmSourceSiteAltTextVARCHAR(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.
SpmSourceSiteNameOfAltCdSysVARCHAR(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.
SpmSourceSiteCdSysVerIdVARCHAR(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.
SpmSourceSiteAltCdSysVerIdVARCHAR(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.
SpmSourceSiteOrginalTextVARCHAR(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.
SpmCollectionStartDTimeMinsSMALLDATETIMENULL Specimen Collection Start DateTime. This field is obtained from the inbound HL7 Results interface in the SPM.17.01.01.
SpmCollectionEndDTimeMinsSMALLDATETIMENULL Specimen Collection End DateTime. This field is obtained from the inbound HL7 Results interface in the SPM.17.02.01.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates