Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HVisitAccessDef_Ver Indicates which property has been changed by whom from the changes made in HVisitAccessDef Table
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNULL Unique Identifier that is used for referencing records in this table.
InstanceHFCIDsmallintNULL HFC(Healthcare Foundation Class) ID of the object.
TypeTinyintNULL Type of property that is modified. For example - 3, 105.
DataTypeTinyintNULL Data type of the property that was modified. Allowable Values : 2 - Char / Unique Identifier, 8 - Date time, 100 - int , 101 - Float, 102 - Smallint, 103 - Float, 104 - Bit, 105 - Text, 106 - Tinyint.
PropertyNamevarchar(100)NULL Name of the property that was modified.
InvalidationTimedatetimeNULL Date and time when the object was modified.
UserIDintNULL Logon ID of the user who modified the object.
CharValuevarchar(3000)NULL Values of the object prior to modification.For example, if the residential address is modified, this field will store the address prior to modification.
RelObjectIDintNULL ID of a new relationship, if set.
TextValuentextNULL Value as entered by the user. If the value in the Type field is set to 105, this field is used.
RelHFCIDsmallintNULL HFC ID of the new relation. This field is populated if the ID of the new relation is set in the RelObjectID field.
OIDValueintNULL ID assigned to the values as stored in the CharValue field. For example, if the residential address was changed, this field will store the object ID of HAddress, which contains details of the residential address. This field is populated if Type is not equal to 3. This field is used to index the values.

Return to Table-Index

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