Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMoveLog Contains detailed move visit 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(1)NULL Not Used
IsVersionedsmallintNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
UserNamevarchar(12)NULL User name of the user who started the visit move.
CreationTimesmalldatetimeNULL Date and Time when row was created.
CreatedUserIdintNULL UserId of the user who created the row
MoveDatedatetimeNULL Date and time of the move operation.
SourcePatientIDintNULL ObjectId of the source patient. Must be in HPatient Table.
TargetPatientIDintNULL ObjectId of the target patient. Must be in HPatient Table.
VisitOIDintNULL Objectid of the visit that was moved. Must be in HPatientVisit table.
StatusValuesmallintNULL Move status. Allowable Values: 0 - Completed 1 - In Progress
Commentsvarchar(500)NULL Not Used.

Return to Table-Index

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