MonthlyWorkings
Generated schema file.
Columns
| Name | Type | References | |
| TargetDate | String | ||
| Year [KEY] | Integer | ||
| Month [KEY] | Integer | ||
| EmployeeKey [KEY] | String | ||
| CurrentEmployeeDivisionCode | String | ||
| CurrentEmployeeDivisionName | String | ||
| CurrentEmployeeGender | String | ||
| CurrentEmployeeTypeCode | String | ||
| CurrentEmployeeTypeName | String | ||
| CurrentEmployeeCode | String | ||
| CurrentEmployeeLastName | String | ||
| CurrentEmployeeFirstName | String | ||
| CurrentEmployeeLastNamePhonetics | String | ||
| CurrentEmployeeFirstNamePhonetics | String | ||
| StartDate | Date | ||
| EndDate | Date | ||
| WorkingCount | Decimal | ||
| WeekdayWorkingCount | Decimal | ||
| LateCount | Decimal | ||
| EarlyLeaveCount | Decimal | ||
| WorkingDayCount | Decimal | ||
| WeekdayWorkingdayCount | Decimal | ||
| AbsentdayCount | Decimal | ||
| HolidaysObtained | String | ||
| Assigned | Integer | ||
| Unassigned | Integer | ||
| Overtime | Integer | ||
| Night | Integer | ||
| NightOvertime | Integer | ||
| BreakSum | Integer | ||
| Late | Integer | ||
| EarlyLeave | Integer | ||
| HolidayWorkNormal | Integer | ||
| HolidayWorkNight | Integer | ||
| HolidayWorkOvertime | Integer | ||
| HolidayWorkNightOvertime | Integer | ||
| HolidayWorkExtra | Integer | ||
| PremiumWorkOvertime1 | Integer | ||
| PremiumWorkNightOvertime1 | Integer | ||
| PremiumWorkOvertime2 | Integer | ||
| PremiumWorkNightOvertime2 | Integer | ||
| LegalHolidayWorkNormal | Integer | ||
| LegalHolidayWorkNight | Integer | ||
| LegalHolidayWorkOvertime | Integer | ||
| LegalHolidayWorkNightOvertime | Integer | ||
| LegalHolidayWorkExtra | Integer | ||
| LegalHolidayWorkCount | Decimal | ||
| LegalHolidayWorkDayCount | Decimal | ||
| GeneralHolidayWorkNormal | Integer | ||
| GeneralHolidayWorkNight | Integer | ||
| GeneralHolidayWorkOvertime | Integer | ||
| GeneralHolidayWorkNightOvertime | Integer | ||
| GeneralHolidayWorkExtra | Integer | ||
| GeneralHolidayWorkCount | Decimal | ||
| GeneralHolidayWorkDayCount | Decimal | ||
| Bind | Integer | ||
| Regarding | Integer | ||
| IsClosing | Boolean | ||
| CustomMonthlyWorkings | String | ||
| IntervalShortageCount | Decimal |