Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSUserGroup Contains different usergroup information of the Soarian Clinicals application
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. The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdintNULL RecordId of HSUser table. 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.
Descriptionvarchar(1)NULL User-defined information provided by the modules in the application. 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 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.
GroupNamevarchar(255)NULL Name of the usergroup.
GroupDescriptionvarchar(255)NULL Description for the user group
OwnGroupbitNULL Indicates if this is internal usergroup. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True
LockedOuttinyintNULL Reasons why the usergroup and its associated members are not able to log on to the application. Allowable Values: 0, 1, 2, or NULL. Key of allowable values: 0 - LOUT_NoLockout, 1 - LOUT_BadLogon, 2 - LOUT_Admin.
LastChangeddatetimeNULL The most recent date and time when the usergroup details were modified.
AccessRestrictedbitNULL When set to True, indicates that the user or the usergroup has access to restricted instances of an object. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, NULL - False, 1 - True
PasswordValidLengthintNULL Minimum length of the password assigned to the user or the usergroup to access instances of an object. Note: If the usergroup does have a validation length, it has precedence against the user's validation length.
AccessVIPbitNULL When set to True, indicates that the usergroup has access to very important(VIP) patients. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, NULL - False, 1 - True
UsergroupTypetinyintNULL Usergroup type is used to configure usergroups with similar user assignments. Allowable Values: 0, 1, 2, 3, 4, or NULL Key of allowable values: 0 - UGT_Interactive, 1 - UGT_SuperInteractive, 2 - UGT_System, 3 - UGT_SuperSystem, 4 - UGT_Others.
BeginTimesmalldatetimeNULL Date and time when the usergroup became valid.
EndTimesmalldatetimeNULL Date and time when the usergroup is no longer valid.
ParentGroup_oidintNULL Object ID of the parent user group, where the user group is a child of another user group.
UUIDvarchar(32)NULL GUID(Globally Unique Identifer) of ActiveDirectory mapped to userGroup in the Soarian Clinicals Database.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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