Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ResultCopiesToInfoOid | BIGINT | NOT NULL | Object ID and primary key of the table, HResultCopiesToInfo. |
ResultObsRequestCommonInfoOid | BIGINT | NOT NULL | Foreign Key. It contains the ObjectId of HResultObsRequestCommonInfo. |
ResCCorBCCSequence | SMALLINT | NOT NULL | Sequence Number for repeating CC or BCC Fields in the R01 Message. |
ResCCorBCCIdNumber | VARCHAR(15) | NULL | Identifier Number of the person who was CC'd or BCC'd on the result. This field is obtained from the inbound HL7 Results interface in the OBR.28.01.00 in the R01 Message. |
ResCCorBCCFamilyName | VARCHAR(50) | NULL | FamilyName/LastName of the person who was CC'd or BCC'd on the result. This field is obtained from the inbound HL7 Results interface in the OBR.28.02.01 in the R01 Message. |
ResCCorBCCFirstName | VARCHAR(30) | NULL | FirstName of the person who was CC'd or BCC'd on the result. This field is obtained from the inbound HL7 Results interface in the OBR.28.03.00 in the R01 Message. |
ResCCorBCCFurtherNameOrInitial | VARCHAR(30) | NULL | FurtherNames or middle initial of the person who was CC'd or BCC'd on the result. This field is obtained from the inbound HL7 Results interface in the OBR.28.04.00 in the R01 Message. |
ResCCorBCCSuffix | VARCHAR(20) | NULL | Name Suffix of the person who was CC'd or BCC'd on the result. This field is obtained from the inbound HL7 Results interface in the OBR.28.05.00 in the R01 Message. |
ResCCorBCCPrefix | VARCHAR(20) | NULL | Name prefix of the person who was CC'd or BCC'd on the result. This field is obtained from the inbound HL7 Results interface in the OBR.28.06.00 in the R01 Message. |
ResCCorBCCAsgnAuthNameSpcId | VARCHAR(20) | NULL | Assigning Authority NameSpace Identifier that was used to identify the system, application, organization, etc. that assigned the Identifier Number. This field is obtained from the inbound HL7 Results interface in the OBR.28.09.01 in the R01 Message. |
ResCCorBCCAsgnAuthUnivId | VARCHAR(199) | NULL | Assigning Authority Universal Identifier that was used to identify the system, application, organization, etc. that assigned the ID Number. This field is obtained from the inbound HL7 Results interface in the OBR.28.09.02 in the R01 Message. |
ResCCorBCCAsgnAuthUnivIdType | VARCHAR(6) | NULL | Assigning Authority Universal Identifier Type(for example, ISO) used to identify the system, application, organization, etc. that assigned the ID Number. This field is obtained from the inbound HL7 Results interface in the OBR.28.09.03 in the R01 Message. |
ResCCorBCCNameTypeCode | VARCHAR(5) | NULL | Name Type Code. This field is obtained from the inbound HL7 Results interface in the OBR.28.10.00 in the R01 Message. |
ResCCorBCCIdTypeCode | VARCHAR(5) | NULL | Type of Identifier used for the identifier number. This field is obtained from the inbound HL7 Results interface in the OBR.28.13.00 in the R01 Message. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time. |