The monthly sheet entity contains informations about the amounts of hours planned based on the weekly work profile and those actually worked within a month, including the negative or positive balance of the employee.

Database level

The entity's attributes are shown below. Mandatory fields are marked with a red star:

form *StringFormRepresents the entity form. Will always be "mos".
mos_country *String
The country name as ISO code (e.g. DE, US)
mos_country_state *String
The state within a country as ISO codation composed from country and state ( e.g. "DE-BW", "DE-BY")
mos_dates_list *


An array including all dates of the month (e.g. {2020-01-01; 2020-01-02}).
mos_days_list *Array/Number
An array including all days of the month (e.g. {1; 2; 3; 4}).
mos_days_names_list *Array/text
An array including all days of the week within the month (e.g. {Mo; Di; Mi; Do; Fr; Sa; So}).
mos_emp_unid *String
The uniques ID of the employment document. 
mos_end *Date
End date of the monthly sheet.
mos_start *Date
Beginning date of the monthly sheet.
mon_month *String
The month number within the calendar year. (e.g. "0" for January; "1" for February)
mos_org_name *String
Represents the organisation name of the parent document.

QEE classes level

The class representing the monthly sheet is QEEMos

Inherits from: QEEObject

REST level

The endpoints dealing with Monthly Sheet are: