Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HHealthCareUnit Contains Healthcare Unit information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectID of HHealthCareUnit table generated by Architecture
InstanceHFCIDsmallintNOT NULL InstanceHFCID of HHealthCareUnit table generated by Architecture
RecordIdintNULL NOt used.
Descriptionvarchar(255)NULL Description of the HealthCareUnit that is being created. Can be valued to HCU Name.
IsVersionedbitNOT NULL Indicates if the row in the table is modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserID of the user who created the row in the database
CreationTimesmalldatetimeNULL Date and Time when row was created.
DefaultStore_oidintNULL Not Used.
HealthcareUnitNamevarchar(75)NOT NULL HealthCareUnit Name that is being created.
Abbreviationvarchar(10)NOT NULL Abbreviation of HealthCareUnit Name
ActivebitNOT NULL Active indicator.(1-Active, 0-Non Active)
CapacityintNULL Not Used
ActivationDatedatetimeNULL Date and Time when HealthCareUnit's became active.
InActivationDatedatetimeNULL Date and Time when HealthCareUnit's became inactive.
IsLeafbitNULL Not Used
NetworkTypetinyintNULL Network Type of HealthCareUnit. Allowable Values: 0 - Internal HCU, 1 - External HCU
HealthcareUnitPathvarchar(2000)NOT NULL Path - Folder structure of Health Care Units.
Hospital Organization\Internal HCU\Enterprise Medical Center
Hospital Organization\Internal HCU\Enterprise Medical Center\Entity
Hospital Organization\Internal HCU\Enterprise Medical Center\Entity\UnitA
IsValidMedialocationIndicatorbitNULL Not Used
CanHaveMediabitNULL Indicates whether healthcareunit can have media. Allowable Values: 0 - No, 1 - Yes
OrganizationTypetinyintNULL Organization Type of HealthCareUnit. Allowable Values: 0 - Entity, 1 - Enterprise, 2 - Unit
IsIsolatedbitNULL Indicates whether this healthcareunit is isolated. Allowable Values: 0 - No, 1 - Yes
UnitForQuickRegistrationbitNULL Indicates whether this healthcareunit is a unit for Quick Registration. Allowable Values: 0 - No, 1 - Yes
IsNameModifiedbitNULL HealthCareUnit Name Modified indicator. Allowable Values: 0 - Not Modified 1 - Modified
PreviousNamevarchar(75)NULL Previous name of HealthCareUnit
EntityMappingIDintNULL Entity ID of HealthCareUnit
InterfacedSystemTypevarchar(8)NULL Interfaced System Type of HealthCareunit. Allowable Values: 0 - Internal HCU, 1 - External HCU
InterfaceRouteCodevarchar(8)NULL Not Used.
HCUExternalAbbvarchar(30)NULL HealthCareUnit External Abbreviation. Set Up by client and can match the HCU Abbreviation.
EntityAbbvarchar(10)NULL Abbreviation of the Entity that HCU belong to.
UnitType_oidintNOT NULL Objectid of the HCU Type with relation to the Objectid in HHealthcareUnitType.
SeqNointNULL Sequence No of HealthCareUnit can be set up by the client.
IsClinicallyResponsibleUnitbitNULL Indicates if HCU is Clinically Responsible Unit. Allowable Values: 0 - No, 1 - Yes
CanHavePatientLocationbitNULL Indicates this healthcareunit can have patient location. Allowable Values: 0 - No, 1 - Yes
EntityGroup_oidintNULL Not Used
IsExclusiveHCUTinyIntNULL Indicates this HealthCareUnit is Exclusive HCU. Allowable Values: 0 - No, 1 - Yes, Null - Not valued.
Specialty_OIDINTNULL Speicalty OID of this HealthCareUnit
LastCngDtimedatetimeNULL DEFAULT(getutcdate( Indicates the current Universal Time Coordinate or Greenwich Mean Time
IsFollowUpCareProviderTinyIntNULL Indicate whether HealthCareUnit is a Follow up Health Care Provider. Allowable Values: 0 - No, 1 - Yes
IsAmbulatoryUnitTinyIntNOT NULL Indicates whether a healthcareunit is an ambulatory type or not. Allowable Values: 0 - No, 1 - Yes
ISOguidvarchar(128)NULL Globally unique ID for an entity. This is valued by the client.
NPIvarchar(20)NULL NPI(National Provider Identifier)
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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