Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ResultCodedInfoOid | BIGINT | NOT NULL | ObjectID and primary key of the table, HResultCodedInfo. |
ResultObsRequestCommonInfoOid | BIGINT | NOT NULL | Foreign Key, which is the ObjectId of the table, HResultObsRequestCommonInfo. |
CodedInfoR01MessageFieldName | VARCHAR(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). |
CodedInfoSequence | SMALLINT | NOT NULL | Sequence Number for Repeating CWE(Coded With Exceptions) Fields within a FieldName in the R01 Message. |
CodedInfoGroupId | SMALLINT | NOT NULL | Group ID for repeating CWE Fields within a FieldName at Different SPM Locations in the R01 Message. |
CodedInfoId | VARCHAR(20) | NULL | Identifier read from CWE.1 for the field indicated by CodedInfoR01MessageFieldName. |
CodedInfoText | VARCHAR(199) | NULL | Text read from CWE.2 for the field indicated by CodedInfoR01MessageFieldName. |
CodedInfoCodingSys | VARCHAR(20) | NULL | Name of the CodingSystem read from CWE.3 for the field indicated by CodedInfoR01MessageFieldName. For example, L for Local, LN for LOINC. |
CodedInfoAltId | VARCHAR(20) | NULL | Alternate Identifier read from CWE.4 for the field indicated by CodedInfoR01MessageFieldName. |
CodedInfoAltText | VARCHAR(199) | NULL | Alternate Text read from the CWE.5 for the field indicated by CodedInfoR01MessageFieldName. |
CodedInfoNameOfAltCodingSys | VARCHAR(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. |
CodedInfoCodingSysVerId | VARCHAR(10) | NULL | Coding System Version Identifier read from CWE.7 for the field indicated by CodedInfoR01MessageFieldName. |
CodedInfoAltCodingSysVerId | VARCHAR(10) | NULL | Alternate Coding System Version Identifier read from CWE.8 for the field indicated by CodedInfoR01MessageFieldName. |
CodedInfoOriginalText | VARCHAR(199) | NULL | Original Text read from CWE.9 for the field indicated by CodedInfoR01MessageFieldName. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time. |