Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMergeInformation Contains patient merge 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.
UserIDvarchar(255)NULL Not Used
MergeDateTimedatetimeNULL Not Used
MergeSequenceNointNULL Next sequential number generated by Architecture.
Reasonvarchar(255)NULL Not Used
OldPatientOIDintNULL Source patient Objectid
Patient_oidintNOT NULL Target patient Objectid
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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