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:
| Name | Type | Label | Description |
|---|
| form * | String | Form | Represents 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 * | Array/Date |
| 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:
xrMos (GET, POST, PUT, DELETE)
xrMoss (GET, PUT, DELETE)