UserPayCategory


Description

User pay category classification defining payment categories for staff compensation and payroll processing. This table manages different pay categories that determine compensation rates, benefits, and payroll processing rules for healthcare staff, supporting flexible payroll management and compensation structures across different roles and employment types.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkUserPayCategory int identity 4 √ null
AccessUser.fkUserPayCategory FK__AccessUser__UserPayCat R

Primary key - Unique identifier for each user pay category
UserPayCategoryName nvarchar 510 √ null

Pay category name - Name of the pay category (Full-time, Part-time, Contract, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_UserPayCategory Primary key Asc pkUserPayCategory

Relationships

Close relationships within degrees of separation