Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientToUnitAssociation Contains patient to unit association.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPatientToUnitAssociation Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used
Descriptionvarchar(10)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HPatientToUnitAssociation row
CreationTimesmalldatetimeNULL Date and time when the object is created.
IsActiveAssociationbitNULL Active Association indicator. Allowable Values: 0 - False, 1 - True or Null
IsActivebitNULL Active row indicator. Allowable Values: 0 - False, 1 - True or Null
AssociationType_oidintNULL Not Used
HealthCareUnit_oidintNOT NULL HCU(Health Care Unit) ObjectID . Must exist in hhealthcareunit table.
AssociatedPatient_oidintNOT NULL Patient oid associated with the HCU unit.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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