PayrollEmployeeHour


Description

Payroll employee hour tracking managing daily hour records for healthcare staff payroll processing. This table tracks individual employee hours worked by day sequence, supporting detailed time tracking, payroll calculations, and labor cost management for healthcare providers across different service delivery periods and payroll cycles.

Columns

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

Primary key - Unique identifier for each employee hour record
fkUserid int 4 √ null
AccessUser.UserID FK__PayrollEm__fkUse__3712ABA4 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 day sequence
DaySeq int 4 √ null

Day sequence - Sequential day number within the payroll period for time tracking

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollEmployeeH__361E876B Primary key Asc PayID

Relationships

Close relationships within degrees of separation