Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMergeLog Contains detailed 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.
UserNamevarchar(255)NULL User name of the user who started the merge.
MergeDatedatetimeNULL Date and time of the merge.
SourcePatientIDvarchar(20)NULL ObjectId of the source patient(data moved from this patient). Must be in HPatient Table.
TargetPatientIDvarchar(20)NULL ObjectId of the target patient(data moved to this patient). Must be in HPatient Table.
StatusValuetinyintNULL Merge status. Allowable Values: 0 - Completed 1 - In Progress
Commentsvarchar(255)NULL Comment put by the process at the end of the merge.

Return to Table-Index

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