# EmploymentsComprehensiveByEmployerId List of employments with additional entities __Activity name :__ GetEmploymentsComprehensiveByEmployerId Get a list of employments for an employer. With this version we introduced the "Comprehensive" resource which contains additional entities. This endpoint only returns the employments that meet the filter settings set at the user level. Note that filter settings are set for a user <-> employer <-> client combination. Select loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/comprehensive Insert loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/comprehensive Update loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/comprehensive Delete loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/comprehensive Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/employees/employments/comprehensive - Catalog: `LoketNlRest` - Schema: `Employment` - Field Selection Method: NotRequired - Base Path: `_embedded[*]` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. | ## Columns of Table Function The columns of the table function `EmploymentsComprehensiveByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `calculateWorkingHours` | `boolean` | | ☐ | Automatically calculate working hours for the employment if the option automatically calculate hours is selected for a given period. NL: Completeren/Berekenen uren | | `cancellationNoticeDate` | `datetime` | | ☐ | The date on which the notice was given by either the employee or the employer. NL: DatumOpzegging | | `cancellationPeriodEmployee` | `int32` | | ☐ | The notice period an employee is required to give the employer when resigning. The unit of time that applies to this field is described in the noticePeriodTimeUnit property. NL: OpzegtermijnWerknemer | | `cancellationPeriodEmployer` | `int32` | | ☐ | The notice period an employer is required to give the employee when terminating the contract. The unit of time that applies to this field is described in the noticePeriodTimeUnit property. NL: OpzegtermijnWerkgever | | `cancellationPeriodTimeUnit_key` | `int32` | | ☐ | | | `cancellationPeriodTimeUnit_value` | `string` | | ☐ | | | `commissionUntilDate` | `datetime` | | ☐ | The date on which the employment will end. NL: AanstellingTot | | `commissionUntilDate1` | `datetime` | | ☐ | Until date for commision #1. NL: AanstellingTot1 | | `commissionUntilDate2` | `datetime` | | ☐ | Until date for commision #2. NL: AanstellingTot2 | | `commissionUntilDate3` | `datetime` | | ☐ | Until date for commision #3. NL: AanstellingTot3 | | `commissionUntilDate4` | `datetime` | | ☐ | Until date for commision #4. NL: AanstellingTot4 | | `commissionUntilDate5` | `datetime` | | ☐ | Until date for commision #5. NL: AanstellingTot5 | | `commissionUntilDate6` | `datetime` | | ☐ | Until date for commision #6. NL: AanstellingTot6 | | `deviatingCLAExternalParty` | `int32` | | ☐ | CLA (CAO) code in case of a deviating CLA for external parties . NL: CaoKlantgroepAfwijkend | | `deviatingCLATaxReturn` | `int32` | | ☐ | CLA (CAO) code in case of a deviating CLA for tax returns. NL: CAOUWV | | `emailLeaveRequest` | `string(255)` | | ☐ | Recipient e-mail adress for notification in case of leave requests. NL: EmailVerlofaanvraag | | `employee_address_city` | `string(24)` | | ☐ | City of the address | | `employee_address_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `employee_address_country_key` | `int32` | | ☐ | The key for the country. Posible values can be aquired via the metadata endpoint | | `employee_address_country_value` | `string(50)` | | ☐ | The name of the country | | `employee_address_furtherIndication_key` | `int32` | | ☐ | The key of the further indication ('nadere aanduiding'). Posible values can be aquired via the metadata endpoint | | `employee_address_furtherIndication_value` | `string` | | ☐ | The description of the further indication ('nadere aanduiding'), the posible values are "WW" and "AB" | | `employee_address_houseNumber` | `int32` | | ☐ | House number of the address | | `employee_address_houseNumberAddition` | `string(4)` | | ☐ | An addition to further specify the house/door/postbox. For example used to specifty a room of floor number in addition to the house number. | | `employee_address_location` | `string(35)` | | ☐ | The location like to further specify the address | | `employee_address_postalCode` | `string(9)` | | ☐ | The postal code of the address, only nullable if country is not The Netherlands (NL). | | `employee_address_street` | `string(24)` | | ☐ | Streetname of the address | | `employee_contactInformation_businessEmailAddress` | `string(255)` | | ☐ | The business e-mail address of the employee. | | `employee_contactInformation_businessMobilePhoneNumber` | `string(15)` | | ☐ | The business mobile phone number of the employee. | | `employee_contactInformation_businessPhoneNumber` | `string(15)` | | ☐ | The business phone number of the employee. | | `employee_contactInformation_emailAddress` | `string(255)` | | ☐ | The e-mail address of the employee. | | `employee_contactInformation_faxNumber` | `string(15)` | | ☐ | The fax number to contact this individual | | `employee_contactInformation_mobilePhoneNumber` | `string(15)` | | ☐ | The mobile phone number of the employee. | | `employee_contactInformation_phoneNumber` | `string(15)` | | ☐ | The phone number of the employee. | | `employee_deviatingPostalAddress_city` | `string(24)` | | ☐ | City of the address | | `employee_deviatingPostalAddress_country_isoCode` | `string(2)` | | ☐ | The ISO 3166-1 alpha-2 value for the country | | `employee_deviatingPostalAddress_country_key` | `int32` | | ☐ | The key for the country. Possible values can be aquired by the metadata endpoint | | `employee_deviatingPostalAddress_country_value` | `string(50)` | | ☐ | The name of the country | | `employee_deviatingPostalAddress_furtherIndication_key` | `int32` | | ☐ | The key of the further indication. Possible values can be aquired by the metadata endpoint | | `employee_deviatingPostalAddress_furtherIndication_value` | `string` | | ☐ | The description of the further indication, the posible values are "WW" and "AB" | | `employee_deviatingPostalAddress_houseNumber` | `int32` | | ☐ | House number of the address | | `employee_deviatingPostalAddress_houseNumberAddition` | `string(4)` | | ☐ | An addition to further specify the house/door/postbox. For example used to specifty a room of floor number in addition to the house number. | | `employee_deviatingPostalAddress_location` | `string(35)` | | ☐ | The location like to further specify the address | | `employee_deviatingPostalAddress_postalCode` | `string(9)` | | ☐ | The postal code of the address, only nullable if country is not The Netherlands (NL). | | `employee_deviatingPostalAddress_street` | `string(24)` | | ☐ | Streetname of the address | | `employee_employeeNumber` | `int32` | | ☐ | The employee number to uniquely identify an employee within an employer | | `employee_exclusionFromAbsenceStatus` | `boolean` | | ☐ | Indicates whether the employee is excluded for any information of absence | | `employee_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employee_identityDocument_documentIdentification` | `string` | | ☐ | | | `employee_identityDocument_typeOfDocument_key` | `int32` | | ☐ | The key for the type of document. Posible values can be aquired via the metadata endpoint | | `employee_identityDocument_typeOfDocument_value` | `string(50)` | | ☐ | Description of the type of document | | `employee_personalDetails_aowDate` | `datetime` | | ☐ | The date when, according to Dutch law, the person has the right to a state pension. The value is generated by the system based on the date of birth. | | `employee_personalDetails_civilStatus_key` | `int32` | | ☐ | | | `employee_personalDetails_civilStatus_value` | `string(50)` | | ☐ | | | `employee_personalDetails_dateOfBirth` | `datetime` | | ☐ | The date of birth | | `employee_personalDetails_dateOfDeath` | `datetime` | | ☐ | The date of death | | `employee_personalDetails_firstName` | `string(28)` | | ☐ | The first name, given name, forename or Christian name as part of a persons personal name. | | `employee_personalDetails_formattedName` | `string(82)` | | ☐ | Formatted name of the employee based on the value of `howToFormatLastName` | | `employee_personalDetails_gender_key` | `int32` | | ☐ | | | `employee_personalDetails_gender_value` | `string(50)` | | ☐ | | | `employee_personalDetails_howToFormatLastName_key` | `int32` | | ☐ | | | `employee_personalDetails_howToFormatLastName_value` | `string(50)` | | ☐ | | | `employee_personalDetails_initials` | `string(6)` | | ☐ | The initials | | `employee_personalDetails_lastName` | `string(25)` | | ☐ | The last name, family name or surname as part of a persons personal name. | | `employee_personalDetails_lastNamePartner` | `string(25)` | | ☐ | The last name of the employee's partner. | | `employee_personalDetails_nationality_key` | `int32` | | ☐ | The key for the nationality. Posible values can be aquired via the metadata endpoint | | `employee_personalDetails_nationality_value` | `string(50)` | | ☐ | Description of the nationality | | `employee_personalDetails_photo` | `string` | | ☐ | A photo of the employee to use as a avatar/profile picture. The last part of the returned endpoint is the version of the logo this allows users to cache the image. Changing the value of the version will not influence the output. | | `employee_personalDetails_placeOfBirth` | `string(24)` | | ☐ | The place of birth | | `employee_personalDetails_prefix` | `string(10)` | | ☐ | The prefix to the last name | | `employee_personalDetails_prefixPartner` | `string(10)` | | ☐ | The prefix to the last name of the employee's partner. | | `employee_personalDetails_title_key` | `int32` | | ☐ | | | `employee_personalDetails_title_value` | `string(50)` | | ☐ | | | `employee_revokeEmployeeSelfServiceAccessOn` | `datetime` | | ☐ | The date on which the Employee will be automatically blocked. | | `employee_statusEmployeeSelfService_key` | `int32` | | ☐ | | | `employee_statusEmployeeSelfService_value` | `string(50)` | | ☐ | | | `employee_travel_travelDistanceToWork` | `int32` | | ☐ | The one way distance in metres the employee has to travel to work. | | `employeeProfileId_key` | `int32` | | ☐ | | | `employeeProfileId_value` | `string` | | ☐ | | | `employmentContractType_key` | `int32` | | ☐ | | | `employmentContractType_value` | `string` | | ☐ | | | `employmentDurationType_key` | `int32` | | ☐ | | | `employmentDurationType_value` | `string` | | ☐ | | | `endDate` | `datetime` | | ☐ | The date on which the employment ends. NL: DatumUitDienst | | `endOfEmploymentDueToIllness` | `boolean` | | ☐ | Indicates whether the reason for the termination of an employment is due to long-term illness. NL: ZiekUitDienst | | `endOfEmploymentReason_key` | `int32` | | ☐ | The key for the reason for the end of the employment. | | `endOfEmploymentReason_value` | `string` | | ☐ | The description of the reason for the end of the employment. | | `endOfEmploymentReasonTaxAuthorities_key` | `int32` | | ☐ | The key for the reason for the end of the employment. | | `endOfEmploymentReasonTaxAuthorities_value` | `string` | | ☐ | The description of the reason for the end of the employment. | | `essMutationSet_key` | `int32` | | ☐ | | | `essMutationSet_value` | `string` | | ☐ | | | `exemptionInsuranceObligation_key` | `int32` | | ☐ | | | `exemptionInsuranceObligation_value` | `string` | | ☐ | | | `exemptionPremiumWaiverMarginalLabour` | `boolean` | | ☐ | Indicates whether an exemption (i.e. waiver) on the premium marginal labour (vrijstelling marginale arbeid) applies for this employment. NL: PremieVrijstellingMarginaleArbeid | | `exemptionWorkRelatedExpenseScheme` | `boolean` | | ☐ | Indicates whether an exemption (i.e. non-participation) on the work-related expense scheme (werkkostenregeling) applies for this employment. NL: WerkkostenRegelingUitsluiting | | `firstDayNotification` | `boolean` | | ☐ | Indicates whether a first-day notification (EersteDagsMelding) was created for the employment. Attention: this indication cannot be altered after an employment has been created. NL: EersteDagsMelding | | `hasOnCallAppearanceObligation` | `boolean` | | ☐ | In the case of an on-call employment this field indicates whether the employment has an appearance obligation. This field can be `null` in cases where it is unknown whether the employment has an appearance obligation. NL: SoortOproepkrachtOfInvalkracht | | `historicalStartDate` | `datetime` | | ☐ | The historical date on which the employee was first employed. This field is used when an employee has multiple employments in time. In most cases this field should be used as the date on which the employee started working for the company. NL: HistorischeDatumInDienst | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `incomeRelationshipNumber` | `int32` | | ☐ | The income relationship number that is required in the tax return. Together with the citizen service number (burgerservicenummer, BSN) and wage tax number, the income relationship number uniquely identifies an employment. NL: NummerInkomstenVerhouding | | `isAnonymousEmployee` | `boolean` | | ☐ | An employee that wants to remain anonymous related to social security instances. NL: IsAnoniemeWerknemer | | `isDirectorAndMajorShareholder` | `boolean` | | ☐ | Indicates whether the employment can be classified as a director and major shareholder (Dutch: directeur-grootaandeelhouder or DGA). This field can be `null` in cases where it is unknown whether the employment can be classified as a director and major shareholder. NL: IsDirecteurGrootAandeelhouder | | `isFamilyOfOwner` | `boolean` | | ☐ | Indicates whether the employment can be classified as a previous owner. This field can be `null` in cases where it is unknown whether the employment can be classified as a director and major shareholder. NL: IsFamilieVanEigenaar | | `isGemoedsbezwaardEmployeeInsurance` | `boolean` | | ☐ | Conscientious Objector Employee Insurance. NL: IsGemoedsbezwaardWerknemerverzekering | | `isGemoedsbezwaardNationalInsurance` | `boolean` | | ☐ | Conscientious Objector National Insurance. NL: IsGemoedsbezwaardVolksverzekering | | `isOnCallEmployment` | `boolean` | | ☐ | Indicates whether the employment is an on-call employment. This field can be `null` in cases where it is unknown whether the employment is an on-call employment. NL: IsOproepkrachtOfInvalkracht | | `isPreviousOwner` | `boolean` | | ☐ | Indicates whether the employment can be classified as a previous owner. This field can be `null` in cases where it is unknown whether the employment can be classified as a director and major shareholder. NL: IsVorigeEigenaar | | `namePayslip` | `string(34)` | | ☐ | Name that is visible on payslips for the employment. NL: NaamLoonstrook | | `nonPayrollAdministration_description` | `string(50)` | | ☐ | Description of the administration | | `nonPayrollAdministration_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `nonPayrollAdministration_name` | `string(70)` | | ☐ | Name of the non payroll administration | | `organizationalEntity_department_code` | `int32` | | ☐ | | | `organizationalEntity_department_description` | `string` | | ☐ | | | `organizationalEntity_department_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `organizationalEntity_deviatingFunctionDescription` | `string(50)` | | ☐ | The deviating function description of the employment. This description deviates from the value of the `function` field. | | `organizationalEntity_deviatingFunctionGroup` | `string(5)` | | ☐ | The deviating function group description of the employment. Only applies when a deviating function description is defined. | | `organizationalEntity_distributionUnit_code` | `int32` | | ☐ | | | `organizationalEntity_distributionUnit_description` | `string` | | ☐ | | | `organizationalEntity_distributionUnit_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `organizationalEntity_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `organizationalEntity_function_description` | `string(50)` | | ☐ | | | `organizationalEntity_function_group` | `string(5)` | | ☐ | | | `organizationalEntity_function_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `organizationalEntity_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `organizationalEntity_internalTelephoneExtensionNumber` | `string(15)` | | ☐ | The phone number of the standard working location (standplaats) for the employment. | | `organizationalEntity_placeOfEmployment` | `string(24)` | | ☐ | The standard working location (standplaats) for the employment. | | `organizationalEntity_standardFunction_category` | `int32` | | ☐ | | | `organizationalEntity_standardFunction_code` | `string(6)` | | ☐ | | | `organizationalEntity_standardFunction_key` | `int32` | | ☐ | | | `organizationalEntity_standardFunction_value` | `string` | | ☐ | | | `organizationalEntity_startDate` | `datetime` | | ☐ | The start date of the entity. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. | | `participation55plusRegulationUWV` | `boolean` | | ☐ | Indicates whether the 55 plus regulation (55 plus regeling) is applicable for the employment. NL: Deelname55Plus | | `payrollAdministration_clientNumber` | `int32` | | ☐ | The client number is a unique number for administrations that are used for payrolling. This field has no value if the administration is not used for payrolling. | | `payrollAdministration_description` | `string(50)` | | ☐ | Description of the administration | | `payrollAdministration_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollAdministration_name` | `string(70)` | | ☐ | Name of the payroll administration | | `payrollId` | `int32` | | ☐ | The payrolling number for this employment of the employee. Used by the payroll engine. This number is automatically generated and cannot be changed by the user. NL: PersoneelsnummerVerloning | | `periodPayGradeAdjustment` | `int32` | | ☐ | The values is used for two processes. First off, a message can be configured to notify the user(s) of a upcoming wage raise/negotiation based on the value of this field. Second, the value, in combination with `signalSalaryScaleAdjustment`, is used to signal a wage raises based on the `payScale` and ‘payGrade’. NL: PeriodeSalarisPeriodiek | | `professionCode` | `int32` | | ☐ | A code field for a profession. This field only applies in case of a specific CLA (Bouw / Infra). Please leave empty if not applicable. NL: BeroepUWV | | `sendToExternalParty_key` | `int32` | | ☐ | | | `sendToExternalParty_value` | `string` | | ☐ | | | `signalPayGradeAdjustment` | `boolean` | | ☐ | Indicates whether signaling regarding salary scale adjustments are enabled for the employment. NL: SalarisschaalSignaleren | | `specialIncomeRatio_key` | `int32` | | ☐ | | | `specialIncomeRatio_value` | `string` | | ☐ | | | `startCancellationNoticePeriod` | `datetime` | | ☐ | The date on which the term of notice period starts. If the agrement states that a notice periode always starts on the first day of the month and the notice was given on the 15th the start notice periode will be the first day of the next month. NL: AanvangOpzegtermijn | | `startDate` | `datetime` | | ☐ | The date on which this employment starts. NL: DatumInDienst | | `startDateContractOfIndefiniteDuration` | `datetime` | | ☐ | When did the value of `employmentDurationType` change for definite to indefinite. NL: Startdatum onbepaalde tijd This value should be te samen as the `startDate` if the contract was indefinite from the start. | | `temporaryTaxExemption_key` | `int32` | | ☐ | | | `temporaryTaxExemption_value` | `string` | | ☐ | | | `typeOfEmployee_key` | `int32` | | ☐ | | | `typeOfEmployee_value` | `string` | | ☐ | | | `typeOfParticipation_key` | `int32` | | ☐ | | | `typeOfParticipation_value` | `string` | | ☐ | | | `vacationCoupons_key` | `int32` | | ☐ | | | `vacationCoupons_value` | `string` | | ☐ | | | `valueOfParticipation_key` | `int32` | | ☐ | | | `valueOfParticipation_value` | `string` | | ☐ | | | `wachtgeldOldRegulation` | `boolean` | | ☐ | Indicates whether the (old) wachtgeld regulation is applicable for the employment. NL: WachtgeldOudeRegeling | | `wage_applyPayGrade` | `boolean` | | ☐ | Apply pay grade indicates that after submitting the record the server will replace the value of `grossWage` with the value represented by the selected `payGrade`. A pay grade contains time based values, the value that is active on the `start date` of the record will be selected. | | `wage_employerCosts` | `double` | | ☐ | The cost for the employer for this employee. | | `wage_employerCostsType_key` | `int32` | | ☐ | | | `wage_employerCostsType_value` | `string(50)` | | ☐ | | | `wage_endDate` | `datetime` | | ☐ | The end date for the information in the record. | | `wage_grossWage` | `double` | | ☐ | The gross wage for the employee | | `wage_grossWageType_key` | `int32` | | ☐ | | | `wage_grossWageType_value` | `string(50)` | | ☐ | | | `wage_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `wage_isGrossWageFullTime` | `boolean` | | ☐ | Indicates whether the given grossWage is either a full-time wage or a part-time wage. Full-time wage is the default value (isGrossWageFulltime = true) and Loket.nl recommends to use this option. A full-time wage takes into account the part-time percentage of an employment. While a part-time wage does not. E.g. A full-time wage of 2400 euro’s is registered. The employments works 20 out of 40 hours (40 fours is a full-time shift) thus having a 20/40 = 50% part-time percentage. The part-time hours (deviatingHoursPerWeek) are accessible through the endpoint for working hours of an employement. In the wage calculation Loket.nl will divide the grossWage component by 50% resulting in a grossWage of 1200 euro’s. In the case of a part-time wage the part-time percentage will be ignored. | | `wage_netWage` | `double` | | ☐ | Net wage for the employment | | `wage_netWageType_key` | `int32` | | ☐ | | | `wage_netWageType_value` | `string(50)` | | ☐ | | | `wage_payGrade_key` | `int32` | | ☐ | | | `wage_payGrade_value` | `string(50)` | | ☐ | | | `wage_payrollPeriodType_key` | `int32` | | ☐ | | | `wage_payrollPeriodType_value` | `string(50)` | | ☐ | | | `wage_payScale_key` | `int32` | | ☐ | | | `wage_payScale_value` | `string(50)` | | ☐ | | | `wage_startDate` | `datetime` | | ☐ | The start date for the information in the record. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. __Note__ It is posible to have no wage record. | | `workinghours_aggregatedHoursPerWeek` | `double` | | ☐ | This read-only field provides the user with a single point of knowledge as to what number of hours per week employment is actually registered in regards to the payrolling process. This number may be respectively based on the workpattern, deviating hours per week or shift hours. If the employment is an 'on call employment' (oproepkracht/invalkracht) the number is either NULL or represents the min-hours if that is applicable. This field is especially useful for third-parties that want to know the number of hours per week (without having to apply specific Loket logic). I.e. this field is not visible in Loket GUI. | | `workinghours_averageHoursPerWeek` | `double` | | ☐ | This field can be used to register the average hours per week an employment with varying hours works. For example, 0 hour contracts and min max contracts. The value of this field does NOT directly affect the payrolling proces. | | `workinghours_averageParttimeFactor` | `double` | | ☐ | This field is used to register the deviating value of the parttimefactor, purely for administrative purposes. The parttimefactor is normally calculated by workinghours dividing by shifthours multplied by 100. Please note that this field is not used in the actual payroll proces! For the payroll process the number of hours is used. | | `workinghours_calculateUsingWorkPattern_daysDailyRate` | `boolean` | | ☐ | Indicates whether the number of days of dailyrate should be calculated based on the workpattern. The number of days are normally calculated by the working hours. | | `workinghours_calculateUsingWorkPattern_deviatingDaysAndHours` | `boolean` | | ☐ | Indication whether the deviating hours per week and deviating SV-days per period are to be automatically calculated based on the workpattern. Please note (!) that any values in the deviatingHoursPerWeek and deviatingSvDaysPerPeriod fields (of this workingHours record) will be overwritten based on this calculation if true (and endDate=NULL)! | | `workinghours_calculateUsingWorkPattern_hoursBrokenPeriod` | `boolean` | | ☐ | Indicates whether the hours for the payrolling should be calculated based on the workpattern in broken periods. These are periods of in or out of service. | | `workinghours_calculateUsingWorkPattern_hoursRegularPeriod` | `boolean` | | ☐ | Indicates whether the hours for the payrolling should be calculated based on the workpattern for regular periods. | | `workinghours_calculateUsingWorkPattern_leaveHours` | `boolean` | | ☐ | Indicates whether then leave balances (verlof) are to be calculated based on the workpattern. | | `workinghours_contractCode_code` | `int32` | | ☐ | | | `workinghours_contractCode_description` | `string` | | ☐ | | | `workinghours_contractCode_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `workinghours_deviatingHoursPerWeek` | `double` | | ☐ | If this field is empty the fulltime hours are based as defined by the shift, this optional field is used to register an overwriting value. The value can be less or more then the fulltime hours a week. | | `workinghours_deviatingSvDaysPerPeriod` | `int32` | | ☐ | Sv (social insurance) days are normally calculated by hours per shift, this optional field is used to register a deviating value. | | `workinghours_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `workinghours_flexibleHoursContract_key` | `int32` | | ☐ | | | `workinghours_flexibleHoursContract_value` | `string(50)` | | ☐ | | | `workinghours_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `workinghours_regularWorkPattern` | `boolean` | | ☐ | When the employee works the same amount of hours per day every week, then the workpattern is regular. | | `workinghours_shift_bonusPercentage` | `decimal` | | ☐ | The bonus percentage used in wage calculations for the hours made in this shift. | | `workinghours_shift_fullTimeHoursPerWeek` | `decimal` | | ☐ | The full time hours for an employment that is linked to this shift. | | `workinghours_shift_shiftNumber` | `int32` | | ☐ | The number for the shift. | | `workinghours_shiftRateSickLeave_bonusPercentage` | `decimal` | | ☐ | The bonus percentage used in wage calculations for the hours made in this shift. | | `workinghours_shiftRateSickLeave_fullTimeHoursPerWeek` | `decimal` | | ☐ | The full time hours for an employment that is linked to this shift. | | `workinghours_shiftRateSickLeave_shiftNumber` | `int32` | | ☐ | The key number to identify the shift to be used for calculation of daily rate in case of sick leave (ziekte). | | `workinghours_startDate` | `datetime` | | ☐ | Start date of the record. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. | | `workinghours_workPattern_evenWeeks_friday` | `double` | | ☐ | | | `workinghours_workPattern_evenWeeks_monday` | `double` | | ☐ | | | `workinghours_workPattern_evenWeeks_saturday` | `double` | | ☐ | | | `workinghours_workPattern_evenWeeks_sunday` | `double` | | ☐ | | | `workinghours_workPattern_evenWeeks_thursday` | `double` | | ☐ | | | `workinghours_workPattern_evenWeeks_tuesday` | `double` | | ☐ | | | `workinghours_workPattern_evenWeeks_wednesday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_friday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_monday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_saturday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_sunday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_thursday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_tuesday` | `double` | | ☐ | | | `workinghours_workPattern_oddWeeks_wednesday` | `double` | | ☐ | | | `writtenEmploymentContract` | `boolean` | | ☐ | Did the employment and employer make a written contract? NL: Schriftelijke overeenkomst |