Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HVisitAccessDef Records visit accesses that belong to specific usergroups and Patients
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Unique Identifier that is used for referencing records in this table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL The Record ID. Not valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(255)NULL User defined information provided by the modules in the application
IsDeletedtinyintNOT NULL When set to 1, indicates that the object was deleted. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True.
IsVersionedbitNOT NULL When set to True, indicates that the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True.
CreatedUserIdintNULL Object ID of the user who created the object
CreationTimesmalldatetimeNULL Date and Time when the object was created.
AccessiblebitNULL When set to True, indicates that a user can always access the patient visit. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False 1 - True.
TimeRestrictionTypetinyintNULL Type of time restriction. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - AbsoluteTime 1 - VisitDuration.
BeginTimesmalldatetimeNULL Date and time when the access definition becomes valid.
EndTimesmalldatetimeNULL Date and time when the access definition is no longer valid.
LastChangeddatetimeNULL Most recent date and time when the access definition was modified.
Visit_oidintNOT NULL Object ID for the HPatientVisit.
UserGroup_oidintNOT NULL Object ID for the user HSUserGroup.

Return to Table-Index

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