PayrollEmployeePeriod


Description

Payroll employee period management defining payroll periods and processing cycles for healthcare staff compensation. This table manages payroll period definitions including payroll dates, week numbers, and processing status, supporting systematic payroll processing, period-based compensation cycles, and payroll administration for healthcare organizations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PeriodID int identity 4 √ null
PayrollEmployeeRecord.fkPeriodID FK__PayrollEm__fkPer__3BD760C1 C

Primary key - Unique identifier for each payroll period
DatePayroll datetime 16,3 √ null

Payroll date - Date when payroll is processed for this period
WeekNumber int 4 √ null

Week number - Week number within the payroll period for multi-week cycles
Status varchar 10 √ null

Period status - Current status of the payroll period (e.g., ‘Open’, ‘Closed’, ‘Processing’, ‘Complete’)

Indexes

Constraint Name Type Sort Column(s)
PK__PayrollEmployeeP__38FAF416 Primary key Asc PeriodID

Relationships

Close relationships within degrees of separation