Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMergeItems Contains merged items information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Unique ObjectId generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFCID generated by Architecture
RecordIdintNULL Not Used
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 row
CreationTimesmalldatetimeNULL Date and Time when row was created.
MergeItemOIDintNULL ObjectID of the item that was merged. It can be patient visit. patient identifiers, NOK details, etc
RelationNamevarchar(255)NULL Name of the related DB table for merged item. For Example: PatientIdentifiers, PatientVisit, PatientRelatedParty
MergeItemHFCIDvarchar(255)NULL HFCID Name of the related DB table for merged item. For Example: hfc.PatientIdentifiers, hfc.PatientVisit, hfc.NextofKinDetails
OldOIDintNULL Not Used
MergeInformation_oidintNOT NULL ObjectID linked to the entry in HMergeInformation table.

Return to Table-Index

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