UserPayGroup


Description

User pay group management defining rate groups and compensation structures for staff payroll processing. This table manages pay groups that determine rate structures, compensation levels, and payroll processing rules for different categories of healthcare staff, supporting flexible rate management and payroll administration across various roles and programs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayGroupID int identity 4 √ null
Rate.PayGroup FK__Rate__PayGroup__624BE676 R

Primary key - Unique identifier for each pay group
RateGroupName nvarchar 1073741823 √ null

Rate group name - Name of the rate group for compensation classification
RateGroupDesc varchar 255 √ null

Rate group description - Detailed description of the rate group and its compensation structure
UserId int 4 √ null

User reference - Links to the user who created or manages this pay group

Indexes

Constraint Name Type Sort Column(s)
PK__UserPayGroup__4EA8A765 Primary key Asc PayGroupID

Relationships

Close relationships within degrees of separation