PayrollException


Description

Payroll exception management handling special payroll cases, rate overrides, and exception processing for healthcare staff compensation. This table manages payroll exceptions including custom rates, special pay types, effective date ranges, and exception status tracking, supporting flexible payroll processing, rate adjustments, and special compensation scenarios for healthcare organizations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayExcepID int identity 4 √ null

Primary key - Unique identifier for each payroll exception
fkExcepTypeID varchar 10 √ null
PayrollExceptionRuleType.ExcepType FK__PayrollEx__fkExc__793F965D C

Exception type reference - Links to exception type classification for categorizing the payroll exception
ExceptionValue varchar 50 √ null

Exception value - Specific value or parameter for the payroll exception
ExceptionName varchar 255 √ null

Exception name - Descriptive name for the payroll exception
fkUserID int 4 √ null
AccessUser.UserID FK__PayrollEx__fkUse__7A33BA96 C

Employee reference - Links to AccessUser table for the healthcare provider or staff member
fkRateID int 4 √ null
Rate.RateID FK__PayrollEx__fkRat__7B27DECF C

Rate reference - Links to rate table for the base rate being modified by this exception
ExcepRate money 21,4 √ null

Exception rate - Special rate amount for this payroll exception
Dateeffective smalldatetime 16 √ null

Effective date - Date when this payroll exception becomes effective
DateEnd smalldatetime 16 √ null

End date - Date when this payroll exception expires or is no longer effective
ExcepStatus varchar 15 √ null

Exception status - Current status of the payroll exception (e.g., ‘Active’, ‘Inactive’, ‘Pending’, ‘Expired’)
Comments varchar 1000 √ null

Exception comments - Additional notes or comments about the payroll exception
fkPayTypeID int 4 √ null
PayrollType.PayTypeID FK__payrollex__fkPay__7EF86FB3 R

Pay type reference - Links to pay type classification for this exception

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollException__784B7224 Primary key Asc PayExcepID

Relationships

Close relationships within degrees of separation