Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSUser Contains different user's information who are accessing Soarian Clinicals application
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectID of this record.This field is always a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL The 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. Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient.
Descriptionvarchar(1)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables.
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.
LoginIDvarchar(100)NULL LoginId of the user
UserNamevarchar(12)NULL User abbreviation used in displays and printed output.
UserDescriptionvarchar(255)NULL Description for the user
UserCommentvarchar(255)NULL Remarks as entered by the user.
UserTypetinyintNULL The type of user. Allowable Values: 0, 1, 2, 3, 4, 5, 6, 7, or NULL. Key of allowable values: 0 - UT_Staff, 1 - UT_Patient, 2 - UT_Person, 3 - UT_ExternalSystem, 4 - UT_System, 5 - UT_Others, 6 - UT_SuperSystem, 7 - UT_SuperUser.
LastChangeddatetimeNULL Most recent date and time when the user's emergency access privileges were modified.
EmergencyAccessbitNULL When set to True, indicates that the user has emergency access privilege. When a user has emergency access, he can access a secured object to which he would not normally have access. This special security privilege can be established for a specified period of time without reconfiguring the user's security profile. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True
UserContactbitNULL When set to True, indicates that the user has user contact privilege. When a user has user contact, he can access a patient to whom he would not normally have access. This special security privilege can be established for a specified period without reconfiguring the user's security profile. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True
LastLogonTimesmalldatetimeNULL Date and time when the user logged on to the application prior to the current logon.
NormLoginIDvarchar(100)NULL Normalized form of the login ID of the user. This contains no special characters.
BeginTimesmalldatetimeNULL Date and time when the user became a valid user of the application.
EndTimesmalldatetimeNULL Last date and time when the user was a valid user of the application.
PreferenceGroup_oidintNULL The preference group of the user, such as doctors. Note: This is a data dictionary item.
Person_oidintNULL Object Identifier of the HPerson.
Password_oidintNULL Object Identifier of the HSPassword.
SignLevelintNULL Level of signature assigned to the user. Allowable Values: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9.
UUIDvarchar(32)NULL GUID(Globally Unique Identifier) of ActiveDirectory mapped user
UGsMappedtinyintNULL Indicates if the user is migrated to the ActiveDirectory for CDS2. Allowable values - null, 0, 1. Key of allowable values: 0 - False, 1 - True.
IsUserReadOnlybitNULL Indicates if the user is ReadOnly. Allowable values - null, 0, 1. Key of allowable values: 0 - False, 1 - True.

Return to Table-Index

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