UserStatus


Description

User status definitions defining status values for user accounts and employment status within the healthcare system. This table manages status classifications such as Active, Inactive, Terminated, On Leave, supporting user lifecycle management, access control, and human resources tracking for healthcare staff administration.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
StatusID char 2 √ null

Status identifier - Unique code for each user status type
StatusDesc varchar 30 √ null

Status description - Description of the user status (Active, Inactive, etc.)

Relationships

Close relationships within degrees of separation