Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HMoveLog_Ver Contains moved visit changed detail information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNULL ObjectId. The same as related Object ID in HMoveLog table.
InstanceHFCIDsmallintNULL Instance HFCID the same as in HMoveLog table.
TypeTinyintNULL Relationship type of change. For this table it will always be as 3 - Simple Property change.
DataTypeTinyintNULL Data type of column that was changed. For this table it will always be as 2- varchar.
PropertyNamevarchar(100)NULL Column name that has the changed value.
InvalidationTimedatetimeNULL Date and Time when value was changed.
UserIDintNULL User Id that updated "Comments" field after move visit is complete.
CharValuevarchar(3000)NULL Previous Value for changed "Comments" field.
RelObjectIDintNULL Not used.
TextValuentextNULL Not used.
RelHFCIDsmallintNULL Not used.
OIDValueintNULL Not used.

Return to Table-Index

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