DailyWorkings
Generated schema file.
Columns
Name | Type | References | |
Date [KEY] | Date | ||
EmployeeKey [KEY] | String | ||
CurrentDateEmployeeDivisionCode | String | ||
CurrentDateEmployeeDivisionName | String | ||
CurrentDateEmployeeGender | String | ||
CurrentDateEmployeeTypeCode | String | ||
CurrentDateEmployeeTypeName | String | ||
CurrentDateEmployeeCode | String | ||
CurrentDateEmployeeLastName | String | ||
CurrentDateEmployeeFirstName | String | ||
CurrentDateEmployeeLastNamePhonetics | String | ||
CurrentDateEmployeeFirstNamePhonetics | String | ||
WorkPlaceDivisionCode | String | ||
WorkPlaceDivisionName | String | ||
IsClosing | Boolean | ||
IsHelp | Boolean | ||
IsError | Boolean | ||
WorkdayTypeName | String | ||
Assigned | Integer | ||
Unassigned | Integer | ||
Overtime | Integer | ||
LateNight | Integer | ||
LateNightUnassigned | Integer | ||
LateNightOvertime | Integer | ||
BreakTime | Integer | ||
Late | Integer | ||
EarlyLeave | Integer | ||
TotalWork | Integer | ||
HolidaysObtainedFulltimeHolidayCode | Integer | ||
HolidaysObtainedFulltimeHolidayName | String | ||
HolidaysObtainedHalfdayHolidays | String | ||
HolidaysObtainedHourHolidays | String | ||
AutoBreakOff | Integer | ||
DiscretionaryVacation | Integer | ||
CustomDailyWorkings | String |