WorkRecordSummaries
Generated schema file.
Columns
| Name | Type | References | |
| EmployeeId [KEY] | Integer |
Employees.Id | |
| Year | Integer | ||
| Month | Integer | ||
| StartDate | Datetime | ||
| EndDate | Datetime | ||
| WorkDays | Integer | ||
| TotalWorkMins | Integer | ||
| TotalNormalWorkMins | Integer | ||
| TotalExcessStatutoryWorkMins | Integer | ||
| TotalOvertimeExceptNormalWorkMins | Integer | ||
| TotalOvertimeWithinNormalWorkMins | Integer | ||
| TotalHolidayWorkMins | Integer | ||
| TotalLatenightWorkMins | Integer | ||
| TotalLatenessAndEarlyLeavingMins | Integer | ||
| NumAbsences | Integer | ||
| NumPaidHolidays | Integer | ||
| NumPaidHolidaysAndHoursDays | Integer | ||
| NumPaidHolidaysAndHoursHours | Integer | ||
| NumPaidHolidaysLeft | Integer | ||
| NumPaidHolidaysAndHoursLeftDays | Integer | ||
| NumPaidHolidaysAndHoursLeftHours | Integer | ||
| NumSubstituteHolidaysUsed | Integer | ||
| NumCompensatoryHolidaysUsed | Integer | ||
| NumSpecialHolidaysUsed | Integer | ||
| NumSpecialHolidaysAndHoursUsedDays | Integer | ||
| NumSpecialHolidaysAndHoursUsedHours | Integer | ||
| MultiHourlyWages | String | ||
| WorkRecords | String |