Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HHealthcareUnitType Contains information about differet HCU (Health Care Unit) types.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HHealthcareUnitType Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used.
Descriptionvarchar(255)NULL Set Up as HCU(Health Care Unit) type Name.
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HHealthcareUnitType row.
CreationTimesmalldatetimeNULL Date and Time when row has been created.
Namevarchar(50)NOT NULL Name of the Unit Type
SchedulableServicePointbitNULL Currently not used
IsCilincallyResponsibleSubUnitbitNULL Is SubUnit Clinically responsible. Allowable Values: 0 - False, 1 - True
IsClinicallyResponsibleUnitbitNULL Is Unit Clinically responsible. Allowable Values: 0 - False, 1 - True
CanHavePatientLocationbitNULL Can Unit be a patient location. Allowable Values: 0 - False, 1 - True
ActivebitNOT NULL Indicates if HCU Type is active. Allowable Values: 0 - Not Active, 1 - Active
HasManyLocationsbitNULL Unit allow multiple locations indicator. Allowable Values: 0 - False, 1 - True
CanHaveManyPatientsAtaTimebitNULL Unit support multiple patients indicator. Allowable Values: 0 - False, 1 - True
IconimageNULL Icon displayed in HCU structure. Allowable Values: 0 - False, 1 - True, Null - Not valued.
CanbeHospitalServicebitNULL Unit defined as Hospital Service indicator. Allowable Values: 0 - False, 1 - True
ExtendedHCUTypeintNOT NULL Extended Unit Type Indicator. Allowable Values: 0 - False, 1 - True
IsInsurancePayerbitNULL Insurance Payer indicator to identify insurance payer. Allowable Values: 0 - False, 1 - True
IsInsurancePlanbitNULL Insurance Plan indicator to identify insurance plan. Allowable Values: 0 - False, 1 - True
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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