PayrollEmployeeRecord


Description

Payroll employee record management storing individual employee payroll records with detailed compensation information for healthcare staff. This table manages employee-specific payroll data including hours worked, pay rates, pay types, calculation dates, and processing status, supporting comprehensive payroll processing, employee compensation tracking, and detailed payroll reporting for healthcare organizations.

Columns

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

Primary key - Unique identifier for each employee payroll record
fkPeriodID int 4 √ null
PayrollEmployeePeriod.PeriodID FK__PayrollEm__fkPer__3BD760C1 C

Period reference - Links to PayrollEmployeePeriod table for the payroll period
fkUserid int 4 √ null
AccessUser.UserID FK__PayrollEm__fkUse__3CCB84FA C

Employee reference - Links to AccessUser table for the healthcare provider or staff member
NumHours decimal 6,2 √ null

Hours worked - Number of hours worked by the employee for this payroll record
DaySeq int 4 √ null

Day sequence - Sequential day number within the payroll period
Rate money 21,4 √ null

Pay rate - Hourly or per-service rate for the employee
fkPayTypeID int 4 √ null
PayrollType.PayTypeID FK__PayrollEm__fkPay__3DBFA933 C

Pay type reference - Links to pay type classification (Regular, Overtime, Holiday, etc.)
DateCalculated datetime 16,3 √ null

Calculation date - Date when this payroll record was calculated
Status varchar 10 √ null

Record status - Current status of this payroll record (e.g., ‘Draft’, ‘Calculated’, ‘Approved’, ‘Paid’)
Comments varchar 1000 √ null

Record comments - Additional notes or comments about this payroll record

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollEmployeeR__3AE33C88 Primary key Asc PayEmpID
IX_DateCalculated Performance Asc DateCalculated
IX_Period Performance Asc fkPeriodID

Relationships

Close relationships within degrees of separation