Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientVisit_Ver Contains patient's changed visit information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNULL ObjectId. The same as related Object ID in HPatientVisit table
InstanceHFCIDsmallintNULL Instance HFC(Healthcare Foundation Class) ID the same as in HPatientVisit table
TypeTinyintNULL Relationship type of change.
Allowable Values: 3 - Simple Property, 20 - One to One Relationship, 21 - One to Many Forward Relationship, 22 - One to Many Reverse Relationship
DataTypeTinyintNULL Data type of column that was changed.
Allowable Values: 2- varchar, 8 - datetime, 100 - int, 101 - double, 102 - Smallint, Tinyint, 103 - Float, 104 - Bit
PropertyNamevarchar(100)NULL Column name in HPatientVisit table that has the changed value.
InvalidationTimedatetimeNULL Date and Time when value was changed.
UserIDintNULL User Id that changed the visit information.
CharValuevarchar(3000)NULL Previous Value for character fields
RelObjectIDintNULL Relation ObjectID.
a) One-To-One Relations values : NULL - If relation is Removed, Not NULL - If relation is Established
b) One-To-Many Relations(both in Forward and Reverse) : Child ObjectID will be in.
TextValuentextNULL Previous Value for text fields
RelHFCIDsmallintNULL Relation HFC(Healthcare Foundation Class) ID(Child HFCID in case of OnetoOne & OnetoMany).
OIDValueintNULL Previous Value for oid fields
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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