UserGroup


Description

User group definitions managing security groups and organizational units for user access control and data filtering. This table defines groups that users can be assigned to, supporting hierarchical security models, data access control, and organizational structure management within the healthcare system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
GroupID int identity 4 √ null
CategoryGroupAssigned.GroupID FK__CategoryG__Group__70F39DC8 C
GroupAddons.fkGroupID FK_GroupAddons_UserGroup R
GroupInAction.fkGroupID FK_GroupInAction_UserGroup C
GroupInConfigOption.GroupID FK__GroupInCo__Group__145DA0ED C
UserInGroups.GroupID FK_UserInGroups_UserGroup C
UserScreen.GroupID FK_UserSubTab_UserGroup R

Primary key - Unique identifier for each user group
GroupName varchar 50 √ null

Group name - Name of the user group
GroupDesc varchar 500 √ null

Group description - Detailed description of the group’s purpose and scope
AgencyID int 4 √ null

Agency reference - Links to the agency that owns this group
programID int 4 √ null

Program reference - Links to iCS2.dbo.ProgramType for centralized program type definitions associated with this group
FilterBy varchar 10 √ null

Filter criteria - Criteria used for filtering data access for this group

Indexes

Constraint Name Type Sort Column(s)
PK_Group Primary key Asc GroupID

Relationships

Close relationships within degrees of separation