UserInDiscipline


Description

User discipline assignments linking healthcare providers to their professional disciplines and program types. This table establishes which disciplines users are qualified to provide within specific program contexts, supporting discipline-based service delivery, provider qualification tracking, and program-specific staff assignments.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userDiscID int identity 4 √ null

Primary key - Unique identifier for each user-discipline assignment
userid int 4 √ null
AccessUser.UserID FK_UserInDiscipline_AccessUser C

User reference - Links to the healthcare provider (AccessUser.UserID)
pkDiscDisTypeID int 4 √ null
DiscInDisTypeInProgType.pkDiscDisTypeID FK_UserInDiscipline_DiscInDisTypeInProgType C

Discipline type reference - Links to the discipline-program type combination (DiscInDisTypeInProgType.pkDiscDisTypeID)
DisStatus varchar 10 √ null

Discipline status - Current status of the discipline assignment (Active, Inactive, etc.)
disOrder int 4 √ null

Display order - Order for displaying multiple disciplines for the same user

Indexes

Constraint Name Type Sort Column(s)
PK_UserInDiscipline Primary key Asc userDiscID
IX_UserId_pkDiscDisTypeID Performance Asc/Asc userid + pkDiscDisTypeID
IX_UserInDiscipline Performance Asc userid

Relationships

Close relationships within degrees of separation