Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID and primary key of the table, HPerformingOrgDetail. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Record ID. |
Description | nvarchar(1) | NULL | The user-defined description for the row. |
IsDeleted | tinyint | NOT NULL | Indicates whether the performing organization is deleted. Allowable Values: 0 - No, 1 - Yes. |
IsVersioned | bit | NOT NULL | Indicates whether the performing organization is modified. Allowable Values: 0 - No, 1 - Yes. |
CreatedUserId | int | NULL | Object ID of the user who created the performing organization. This field is linked to the HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | Date and time when the performing organization is created. |
Abbreviation | nvarchar(10) | NULL | Abbreviation of the performing organization for the result. |
Name | nvarchar(64) | NULL | Name of the performing organization for the result. |
StreetAddress | nvarchar(120) | NULL | Street address of the performing organization's address. |
City | nvarchar(64) | NULL | City name of the performing organization's address. |
Area | nvarchar(50) | NULL | Area code of the performing organization's telephone number. |
ZipCode | nvarchar(10) | NULL | Zip code of the performing organization's address. |
Country | nvarchar(64) | NULL | Country name associated to the Performing organization. |
OtherDesignation | varchar(120) | NULL | This field is obtained from the inbound HL7 Results interface in the OBX.24.02.00. |
AddressType | varchar(3) | NULL | This field is obtained from the inbound HL7 Results interface in the OBX.24.07.00. |
CountyOrParishCode | varchar(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. |
PerfOrgNameAsgnAuthNameSpcId | varchar(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. |
PerfOrgNameAsgnAuthUnivId | varchar(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. |
PerfOrgNameAsgnAuthUnivIdType | varchar(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. |
PerfOrgNameIdTypeCode | varchar(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. |
MedDirectorTitle | nvarchar(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. |
MedDirectorFirstName | nvarchar(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. |
MedDirectorMiddleName | nvarchar(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. |
MedDirectorLastName | nvarchar(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. |
MedDirectorIdNumber | varchar(15) | NULL | Medical director's ID number. This field is obtained from the inbound HL7 Results interface in the OBX.25.01.00. |
MedDirectorAsgnAuthNameSpcId | varchar(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. |
MedDirectorAsgnAuthUnivId | varchar(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. |
MedDirectorAsgnAuthUnivIdType | varchar(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. |
MedDirectorNameTypeCode | varchar(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. |
MedDirectorIdTypeCode | varchar(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. |