Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultCodedInfo This table stores a result's relevant clinical information, Result Handling information and the condition of the specimen. This information is sent on an inbound R01 Result transaction with a CWE (Coded With Exceptions) data type. The CWE data type contains multiple data elements.
Column Name Column Datatype Column Null Option Column Comment
ResultCodedInfoOidBIGINTNOT NULL ObjectID and primary key of the table, HResultCodedInfo.
ResultObsRequestCommonInfoOidBIGINTNOT NULL Foreign Key, which is the ObjectId of the table, HResultObsRequestCommonInfo.
CodedInfoR01MessageFieldNameVARCHAR(10)NOT NULL A field name which specifies whether the data is for Relevant clinical information, Result Handling information of the condition of the specimen. This field is obtained from the inbound HL7 Results interface in the 'OBR.13'(Relevant Clinical Information),'OBR.49'(Result Handling information) and SPM.24(Condition of the specimen).
CodedInfoSequenceSMALLINTNOT NULL Sequence Number for Repeating CWE(Coded With Exceptions) Fields within a FieldName in the R01 Message.
CodedInfoGroupIdSMALLINTNOT NULL Group ID for repeating CWE Fields within a FieldName at Different SPM Locations in the R01 Message.
CodedInfoIdVARCHAR(20)NULL Identifier read from CWE.1 for the field indicated by CodedInfoR01MessageFieldName.
CodedInfoTextVARCHAR(199)NULL Text read from CWE.2 for the field indicated by CodedInfoR01MessageFieldName.
CodedInfoCodingSysVARCHAR(20)NULL Name of the CodingSystem read from CWE.3 for the field indicated by CodedInfoR01MessageFieldName. For example, L for Local, LN for LOINC.
CodedInfoAltIdVARCHAR(20)NULL Alternate Identifier read from CWE.4 for the field indicated by CodedInfoR01MessageFieldName.
CodedInfoAltTextVARCHAR(199)NULL Alternate Text read from the CWE.5 for the field indicated by CodedInfoR01MessageFieldName.
CodedInfoNameOfAltCodingSysVARCHAR(20)NULL Name of the Alternate Coding System read from CWE.6 for the field indicated by CodedInfoR01MessageFieldName. For example, L for Local, LN for LOINC.
CodedInfoCodingSysVerIdVARCHAR(10)NULL Coding System Version Identifier read from CWE.7 for the field indicated by CodedInfoR01MessageFieldName.
CodedInfoAltCodingSysVerIdVARCHAR(10)NULL Alternate Coding System Version Identifier read from CWE.8 for the field indicated by CodedInfoR01MessageFieldName.
CodedInfoOriginalTextVARCHAR(199)NULL Original Text read from CWE.9 for the field indicated by CodedInfoR01MessageFieldName.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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