Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatAccessDef_Ver Indicates which property has been changed by whom from the changes made in HPatAccessDef Table
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNULL The ID of the object that was modified.
InstanceHFCIDsmallintNULL The HFC ID of the object that was modified.
TypeTinyintNULL The type of property that was modified. For example - 3, 105
DataTypeTinyintNULL The 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 The name of the property that was modified.
InvalidationTimedatetimeNULL The date and time when the object was modified.
UserIDintNULL The logon ID of the user who modified the object.
CharValuevarchar(3000)NULL The values of the object prior to modification.For example, if the residential address was modified, this field stores the address prior to modification.
RelObjectIDintNULL The ID of a new relationship, if set.
TextValuentextNULL The value as entered by the user. If the value in the Type field is set to 105, this field is used.
RelHFCIDsmallintNULL The HFC ID of the new relation. This field is populated if the ID of the new relation is set in the RelObjectID field.
OIDValueintNULL The ID assigned to the values as stored in the CharValue field. For example, if the residential address was changed, this field stores the object ID of HAddress, which contains details of the residential address. This field is populated if Type does not equal 3. This field is used to index the values.

Return to Table-Index

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