WorkOutputsMonthlyReport

Generated schema file.

Columns

Name	Type	References
TargetMonth [KEY]	String
UserId [KEY]	Integer
Month	String
PrescribedWorkingHours	String
HoursInPrescribedWorkingHours	String
HoursInStatutoryWorkingHours	String
ExcessOfStatutoryWorkingHours	String
ExcessOfStatutoryWorkingHoursInHolidays	String
WorkingHoursInStatutoryHolidays	String
LateNightOvertimeWorkingHours	String
TotalWorkingHours	String
ActualWorkingHours	String
TotalLateHours	String
TotalLeaveEarlyHours	String
LackPrescribedWorkTime	String
OverWorkTime	String
OverWorkTime36	String
PrescribedWorkingDays	String
WorkingDays	String
WorkingDaysInNonStatutoryHolidays	String
WorkingDaysInStatutoryHolidays	String
AbsenceDays	String
TardyDays	String
LearveEarlyDays	String
PublicHolidays	String
PaidHolidays	String
RemainPaidHolidays	String
CreatedAt	Datetime
UpdatedAt	Datetime
DaytimePrescribedWorkTime	String
MidnightPrescribedWorkTime	String
DaytimeStatutoryWorkOvertime	String
MidnightStatutoryWorkOvertime	String
DaytimeOutStatutoryWorkTime	String
MidnightOutStatutoryWorkTime	String
DaytimeOutStatutoryHolidayWorkTime	String
MidnightOutStatutoryHolidayWorkTime	String
DaytimeStatutoryHolidayWorkTime	String
MidnightStatutoryHolidayWorkTime	String
PaidHolidayWithTimePaid	Double