Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSecurityObject Contains all the Security objects of the Soarian Clinicals application and its types(for example, the data recorded while registering or discharging a patient.)
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. Note: The value specified in the ObjectID field and in this field enables unique identification of an object across the application.
RecordIdintNULL The Record ID. Not valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(1)NULL User defined information provided by the modules in the application. Not valued in this table.
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 The object ID of the user who created the object. This field is linked to HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the object was created.
MappingStringvarchar(255)NULL String that maps the security object to the HFC object, stored procedures.
MappingStringDesvarchar(255)NULL Description of the string that maps the security object to the HFC object, stored procedures.
SOTypetinyintNULL Type of security object. Allowable Values: 0, 1 and 2. Key of allowable values: 0 - HFCObject, 1 - Stored Procedure and 2 - Event.
SOGrouptinyintNULL Group to which the security object belongs. Allowable Values: 0, 1, 2 and 3. Key of allowable values: 0 - Other, 1 - Patient related , 2 - Patient + visit related, 3 - Unit Bound
LastChangeddatetimeNULL Most recent date and time when the security object was modified.
BeginTimesmalldatetimeNULL Date and time when the security object became valid.
EndTimesmalldatetimeNULL Last date and time when the security object was valid.

Return to Table-Index

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