UserPayType


Description

User pay type classification defining payment types and compensation methods for staff payroll processing. This table manages different pay types that determine how staff are compensated, including salary, hourly, contract, and other payment structures, supporting diverse compensation models and payroll processing requirements for healthcare organizations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkUserPayTypeID int identity 4 √ null
AccessUser.fkUserPayTypeID FK__AccessUser__UserPayType R

Primary key - Unique identifier for each user pay type
UserPayTypeName nvarchar 510 √ null

Pay type name - Name of the pay type (Salary, Hourly, Contract, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_UserPayType Primary key Asc pkUserPayTypeID

Relationships

Close relationships within degrees of separation