Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLocation Contains HCU location relative information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HLocation Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Record ID valued to 0.
Descriptionvarchar(255)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 HLocation row
CreationTimesmalldatetimeNULL Date and time when the object is created.
StartDatedatetimeNULL The starting date and time when the location is active. Can be NULL.
EndDatedatetimeNULL The ending date and time when the location is active. Can be NULL.
Name_oidintNULL Valued to Object id in the HdataDictionaryItem table. The DDI name represents Location Name. Item type code for this DDI entry is 'HospitalOrganization.HLocation.Location'. DDI name
LocationAddress_oidintNULL ObjectID in HAddress Table entry that contains address information for the location.
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