PayrollType


Description

Payroll type classification defining types of payroll compensation and payment categories for healthcare staff. This lookup table manages payroll type definitions including descriptions, default amounts, lock settings, overtime flags, and application scope, supporting flexible payroll processing, compensation categorization, and systematic payroll management for healthcare organizations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayTypeID int identity 4 √ null
PayrollEmployeeRecord.fkPayTypeID FK__PayrollEm__fkPay__3DBFA933 C
PayrollException.fkPayTypeID FK__payrollex__fkPay__7EF86FB3 R

Primary key - Unique identifier for each payroll type
PayTypeDesc varchar 255 √ null

Pay type description - Detailed description of the payroll type (e.g., ‘Regular Hours’, ‘Overtime’, ‘Holiday Pay’, ‘Mileage’)
DefaultAmount money 21,4 √ null

Default amount - Default monetary amount or rate for this payroll type
Lock int 4 √ null

Lock flag - Numeric indicator whether this payroll type is locked from modifications (1=Locked, 0=Unlocked)
Overtime int 4 √ null

Overtime flag - Numeric indicator whether this payroll type qualifies as overtime (1=Overtime, 0=Regular)
Applyto char 3 √ null

Apply to scope - Three-character code indicating what this payroll type applies to (e.g., ‘ALL’, ‘EMP’, ‘CON’)

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollType__2EDC8CFF Primary key Asc PayTypeID

Relationships

Close relationships within degrees of separation