Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Unique Identifier that is used for referencing records in this table. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | 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. |
Description | varchar(1) | NULL | User-defined information provided by the modules in the application. The length of this field varies with tables |
IsDeleted | tinyint | NOT 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. |
IsVersioned | bit | NOT 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. |
CreatedUserId | int | NULL | The object ID of the user who created the object. This field is linked to HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
GroupName | varchar(255) | NULL | Name of the usergroup. |
GroupDescription | varchar(255) | NULL | Description for the user group |
OwnGroup | bit | NULL | Indicates if this is internal usergroup. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True |
LockedOut | tinyint | NULL | 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. |
LastChanged | datetime | NULL | The most recent date and time when the usergroup details were modified. |
AccessRestricted | bit | NULL | 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 |
PasswordValidLength | int | NULL | 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. |
AccessVIP | bit | NULL | 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 |
UsergroupType | tinyint | NULL | 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. |
BeginTime | smalldatetime | NULL | Date and time when the usergroup became valid. |
EndTime | smalldatetime | NULL | Date and time when the usergroup is no longer valid. |
ParentGroup_oid | int | NULL | Object ID of the parent user group, where the user group is a child of another user group. |
UUID | varchar(32) | NULL | GUID(Globally Unique Identifer) of ActiveDirectory mapped to userGroup in the Soarian Clinicals Database. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|