Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HResultCopiesToInfo This table stores information related to the CC and BCC recipients of an Inbound Lab Result.
Column Name Column Datatype Column Null Option Column Comment
ResultCopiesToInfoOidBIGINTNOT NULL Object ID and primary key of the table, HResultCopiesToInfo.
ResultObsRequestCommonInfoOidBIGINTNOT NULL Foreign Key. It contains the ObjectId of HResultObsRequestCommonInfo.
ResCCorBCCSequenceSMALLINTNOT NULL Sequence Number for repeating CC or BCC Fields in the R01 Message.
ResCCorBCCIdNumberVARCHAR(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.
ResCCorBCCFamilyNameVARCHAR(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.
ResCCorBCCFirstNameVARCHAR(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.
ResCCorBCCFurtherNameOrInitialVARCHAR(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.
ResCCorBCCSuffixVARCHAR(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.
ResCCorBCCPrefixVARCHAR(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.
ResCCorBCCAsgnAuthNameSpcIdVARCHAR(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.
ResCCorBCCAsgnAuthUnivIdVARCHAR(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.
ResCCorBCCAsgnAuthUnivIdTypeVARCHAR(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.
ResCCorBCCNameTypeCodeVARCHAR(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.
ResCCorBCCIdTypeCodeVARCHAR(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.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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