Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PeriodID | int | 4 | null |
|
|
Period primary key - Unique identifier for the payroll period |
||
| DatePayroll | datetime | 16,3 | √ | null |
|
|
Payroll date - Date of the payroll period |
|
| WeekNumber | int | 4 | √ | null |
|
|
Week number - Week number within the payroll period |
|
| Status | varchar | 10 | √ | null |
|
|
Period status - Status of the payroll period (Open, Closed, Processed, etc.) |
|
| PayEmpID | int | 4 | null |
|
|
Employee record primary key - Unique identifier for each employee payroll record |
||
| fkUserid | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the employee |
|
| NumHours | decimal | 6,2 | √ | null |
|
|
Hours worked - Number of hours worked by the employee in this period |
|
| Rate | money | 21,4 | √ | null |
|
|
Pay rate - Hourly or per-service rate for the employee |
|
| fkPayTypeID | int | 4 | √ | null |
|
|
Pay type reference - Links to pay type classification (Regular, Overtime, etc.) |
|
| DateCalculated | datetime | 16,3 | √ | null |
|
|
Calculation date - Date when payroll was calculated for this record |
|
| DaySeq | int | 4 | √ | null |
|
|
Day sequence - Sequential day number within the payroll period |
|
| fkPeriodid | int | 4 | √ | null |
|
|
Period reference - Links back to the payroll period |
|
| Comments | varchar | 1000 | √ | null |
|
|
Record comments - Notes or comments about this payroll record |
|
| RecordStatus | varchar | 10 | √ | null |
|
|
Record status - Status of this individual payroll record |
Relationships
Close relationships within degrees of separation
