Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPerformingOrgDetail This table stores information related to the performing organization of a result. It also includes information about the performing organization's medical director.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID and primary key of the table, HPerformingOrgDetail.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdintNULL Record ID.
Descriptionnvarchar(1)NULL The user-defined description for the row.
IsDeletedtinyintNOT NULL Indicates whether the performing organization is deleted. Allowable Values: 0 - No, 1 - Yes.
IsVersionedbitNOT NULL Indicates whether the performing organization is modified. Allowable Values: 0 - No, 1 - Yes.
CreatedUserIdintNULL Object ID of the user who created the performing organization. This field is linked to the HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the performing organization is created.
Abbreviationnvarchar(10)NULL Abbreviation of the performing organization for the result.
Namenvarchar(64)NULL Name of the performing organization for the result.
StreetAddressnvarchar(120)NULL Street address of the performing organization's address.
Citynvarchar(64)NULL City name of the performing organization's address.
Areanvarchar(50)NULL Area code of the performing organization's telephone number.
ZipCodenvarchar(10)NULL Zip code of the performing organization's address.
Countrynvarchar(64)NULL Country name associated to the Performing organization.
OtherDesignationvarchar(120)NULL This field is obtained from the inbound HL7 Results interface in the OBX.24.02.00.
AddressTypevarchar(3)NULL This field is obtained from the inbound HL7 Results interface in the OBX.24.07.00.
CountyOrParishCodevarchar(20)NULL County/parish code of the performing organization. This field is obtained from the inbound HL7 Results interface in the OBX.24.09.00.
PerfOrgNameAsgnAuthNameSpcIdvarchar(20)NULL Performing organization name assigning authority namespace identifier. This field is obtained from the inbound HL7 Results interface in the OBX.23.06.01.
PerfOrgNameAsgnAuthUnivIdvarchar(199)NULL Universal identifier of the performing organization name's assigning authority. This field is obtained from the inbound HL7 Results interface in the OBX.23.06.02.
PerfOrgNameAsgnAuthUnivIdTypevarchar(6)NULL Universal identifier type of the performing organization name's assigning authority. This field is obtained from the inbound HL7 Results interface in the OBX.23.06.03.
PerfOrgNameIdTypeCodevarchar(5)NULL ID type code of the Performing Organization Name. This field is obtained from the inbound HL7 Results interface in the OBX.23.07.00.
MedDirectorTitlenvarchar(64)NULL Title of the performing organization's medical director. This field is obtained from the inbound HL7 Results interface in the OBX.25.06.00.
MedDirectorFirstNamenvarchar(30)NULL First name of the performing organization's medical director. This field is obtained from the inbound HL7 Results interface in the OBX.25.03.00.
MedDirectorMiddleNamenvarchar(30)NULL Middle name of the performing organization's medical director. This field is obtained from the inbound HL7 Results interface in the OBX.25.04.00.
MedDirectorLastNamenvarchar(60)NULL Last name of the performing organization's medical director. This field is obtained from the inbound HL7 Results interface in the OBX.25.05.00.
MedDirectorIdNumbervarchar(15)NULL Medical director's ID number. This field is obtained from the inbound HL7 Results interface in the OBX.25.01.00.
MedDirectorAsgnAuthNameSpcIdvarchar(20)NULL Medical director's assigning authority namespace identifier. This field is obtained from the inbound HL7 Results interface in the OBX.25.09.01.
MedDirectorAsgnAuthUnivIdvarchar(199)NULL Universal identifier of the medical director's assigning authority. This field is obtained from the inbound HL7 Results interface in the OBX.25.09.02.
MedDirectorAsgnAuthUnivIdTypevarchar(6)NULL Universal identifier type of the medical director's assigning authority. This field is obtained from the inbound HL7 Results interface in the OBX.25.09.03.
MedDirectorNameTypeCodevarchar(5)NULL Name type code of the medical director. This field is obtained from the inbound HL7 Results interface in the OBX.25.10.00.
MedDirectorIdTypeCodevarchar(5)NULL Type of code used for the medical director's ID. This field is obtained from the inbound HL7 Results interface in the OBX.25.13.00.

Return to Table-Index

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