invantive documentation
Invantive Support ForumsLog In / Sign Up

EmploymentsComprehensiveByEmployerId__embeddedBasesForCalculation: Loket.nl REST itgen_loketnl_employmentscomprehensivebyemployerid__embeddedbasesforcalculation_plural

read only REST

  • Catalog: LoketNlRest
  • Schema: Employment
  • Label: itgen_loketnl_employmentscomprehensivebyemployerid__embeddedbasesforcalculation_plural

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.

Can only retrieve data.

API Source

  • Endpoint: /providers/employers/{employerId}/employees/employments/comprehensive
  • Operation: get /providers/employers/{employerId}/employees/employments/comprehensive

Parameters

Name Data Type Required Default Documentation
employerId `` The unique identifier of the employer
referenceDate `` Set a reference date for choosing the date dependent data.
removeEmptyLines `` When true and combined with a X-ReportInput header, the output only contains employments for which selected underlying data, such as wage, is available.

Table Columns

The columns of the table EmploymentsComprehensiveByEmployerId__embeddedBasesForCalculation are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ageBasedMaximum_key int32 itgen_loketnl_agebasedmaximum_key The number for the ageBasedMaximum
ageBasedMaximum_value varchar2(50) itgen_loketnl_agebasedmaximum_value The description of the ageBasedMaximum
ageBasedMinimum_key int32 itgen_loketnl_agebasedminimum_key The number for the ageBasedMinimum
ageBasedMinimum_value varchar2(50) itgen_loketnl_agebasedminimum_value The description of the ageBasedMinimum
base_key int32 itgen_loketnl_base_key The number for the base
base_value varchar2(50) itgen_loketnl_base_value The description of the base
calculateWorkingHours char Calculate Working Hours 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 Cancellation Notice Date The date on which the notice was given by either the employee or the employer. NL: DatumOpzegging
cancellationPeriodEmployee int32 Cancellation Notice for Employee 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 Cancellation Notice for Employer 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 itgen_loketnl_cancellationperiodtimeunit_key
cancellationPeriodTimeUnit_value varchar2 itgen_loketnl_cancellationperiodtimeunit_value
citizenServiceNumber_citizenServiceNumber varchar2(9) itgen_loketnl_citizenservicenumber_citizenservicenumber The social security number of the employee used in communication with the Dutch tax authorities. The number has to be a valid Dutch citizen service number (BSN).
commissionUntilDate datetime itgen_loketnl_commissionuntildate The date on which the employment will end. NL: AanstellingTot
commissionUntilDate1 datetime itgen_loketnl_commissionuntildate1 Until date for commision #1. NL: AanstellingTot1
commissionUntilDate2 datetime itgen_loketnl_commissionuntildate2 Until date for commision #2. NL: AanstellingTot2
commissionUntilDate3 datetime itgen_loketnl_commissionuntildate3 Until date for commision #3. NL: AanstellingTot3
commissionUntilDate4 datetime itgen_loketnl_commissionuntildate4 Until date for commision #4. NL: AanstellingTot4
commissionUntilDate5 datetime itgen_loketnl_commissionuntildate5 Until date for commision #5. NL: AanstellingTot5
commissionUntilDate6 datetime itgen_loketnl_commissionuntildate6 Until date for commision #6. NL: AanstellingTot6
deviatingAwfContribution_endPeriod_periodEndDate datetime itgen_loketnl_deviatingawfcontribution_endperiod_periodenddate The last day of the payroll period.
deviatingAwfContribution_endPeriod_periodNumber int32 itgen_loketnl_deviatingawfcontribution_endperiod_periodnumber The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable.
deviatingAwfContribution_endPeriod_periodStartDate datetime itgen_loketnl_deviatingawfcontribution_endperiod_periodstartdate The first day of the payroll period.
deviatingAwfContribution_endPeriod_year int32 itgen_loketnl_deviatingawfcontribution_endperiod_year The year of the last payroll period for which the record is applicable.
deviatingAwfContribution_id guid itgen_loketnl_deviatingawfcontribution_id The unique identifier of an object (GUID/UUID)
deviatingAwfContribution_startPeriod_periodEndDate datetime itgen_loketnl_deviatingawfcontribution_startperiod_periodenddate The last day of the payroll period.
deviatingAwfContribution_startPeriod_periodNumber int32 itgen_loketnl_deviatingawfcontribution_startperiod_periodnumber The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the record is applicable.
deviatingAwfContribution_startPeriod_periodStartDate datetime itgen_loketnl_deviatingawfcontribution_startperiod_periodstartdate The first day of the payroll period.
deviatingAwfContribution_startPeriod_year int32 itgen_loketnl_deviatingawfcontribution_startperiod_year The year of the first payroll period for which the record is applicable.
deviatingAwfContribution_typeOfDeviatingAwfContribution_key int32 itgen_loketnl_deviatingawfcontribution_typeofdeviatingawfcontribution_key The type of deviating Deviating AWF contribution to be applied for this employment.
deviatingAwfContribution_typeOfDeviatingAwfContribution_value varchar2(50) itgen_loketnl_deviatingawfcontribution_typeofdeviatingawfcontribution_value Description of the nationality
deviatingCLAExternalParty int32 itgen_loketnl_deviatingclaexternalparty CLA (CAO) code in case of a deviating CLA for external parties . NL: CaoKlantgroepAfwijkend
deviatingCLATaxReturn int32 itgen_loketnl_deviatingclataxreturn CLA (CAO) code in case of a deviating CLA for tax returns. NL: CAOUWV
deviations_financialReservationPercentage double itgen_loketnl_deviations_financialreservationpercentage deviation from the financial reservation percentage
deviations_percentage double itgen_loketnl_deviations_percentage Deviation from the percentage
deviations_reservationPercentage double itgen_loketnl_deviations_reservationpercentage deviation from the reservation percentage
emailLeaveRequest varchar2(255) Email Address for Leave Requests Recipient e-mail adress for notification in case of leave requests. NL: EmailVerlofaanvraag
employee_address_city varchar2(24) itgen_loketnl_employee_address_city City of the address
employee_address_country_isoCode varchar2(2) itgen_loketnl_employee_address_country_isocode The ISO 3166-1 alpha-2 value for the country
employee_address_country_key int32 itgen_loketnl_employee_address_country_key The key for the country. Possible values can be aquired via the metadata endpoint
employee_address_country_value varchar2(50) itgen_loketnl_employee_address_country_value The name of the country
employee_address_furtherIndication_key int32 itgen_loketnl_employee_address_furtherindication_key The key of the further indication ('nadere aanduiding'). Possible values can be aquired via the metadata endpoint
employee_address_furtherIndication_value varchar2 itgen_loketnl_employee_address_furtherindication_value The description of the further indication ('nadere aanduiding'), the possible values are "WW" and "AB"
employee_address_houseNumber int32 itgen_loketnl_employee_address_housenumber House number of the address
employee_address_houseNumberAddition varchar2(4) itgen_loketnl_employee_address_housenumberaddition 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 varchar2(35) itgen_loketnl_employee_address_location The location like to further specify the address
employee_address_postalCode varchar2(9) itgen_loketnl_employee_address_postalcode The postal code of the address, only nullable if country is not The Netherlands (NL).
employee_address_street varchar2(24) itgen_loketnl_employee_address_street Streetname of the address
employee_contactInformation_businessEmailAddress varchar2(255) itgen_loketnl_employee_contactinformation_businessemailaddress The business e-mail address of the employee.
employee_contactInformation_businessMobilePhoneNumber varchar2(15) itgen_loketnl_employee_contactinformation_businessmobilephonenumber The business mobile phone number of the employee.
employee_contactInformation_businessPhoneNumber varchar2(15) itgen_loketnl_employee_contactinformation_businessphonenumber The business phone number of the employee.
employee_contactInformation_emailAddress varchar2(255) itgen_loketnl_employee_contactinformation_emailaddress The e-mail address of the employee.
employee_contactInformation_faxNumber varchar2(15) itgen_loketnl_employee_contactinformation_faxnumber The fax number to contact this individual
employee_contactInformation_mobilePhoneNumber varchar2(15) itgen_loketnl_employee_contactinformation_mobilephonenumber The mobile phone number of the employee.
employee_contactInformation_phoneNumber varchar2(15) itgen_loketnl_employee_contactinformation_phonenumber The phone number of the employee.
employee_deviatingPostalAddress_city varchar2(24) itgen_loketnl_employee_deviatingpostaladdress_city City of the address
employee_deviatingPostalAddress_country_isoCode varchar2(2) itgen_loketnl_employee_deviatingpostaladdress_country_isocode The ISO 3166-1 alpha-2 value for the country
employee_deviatingPostalAddress_country_key int32 itgen_loketnl_employee_deviatingpostaladdress_country_key The key for the country. Possible values can be aquired by the metadata endpoint
employee_deviatingPostalAddress_country_value varchar2(50) itgen_loketnl_employee_deviatingpostaladdress_country_value The name of the country
employee_deviatingPostalAddress_furtherIndication_key int32 itgen_loketnl_employee_deviatingpostaladdress_furtherindication_key The key of the further indication. Possible values can be aquired by the metadata endpoint
employee_deviatingPostalAddress_furtherIndication_value varchar2 itgen_loketnl_employee_deviatingpostaladdress_furtherindication_value The description of the further indication, the possible values are "WW" and "AB"
employee_deviatingPostalAddress_houseNumber int32 itgen_loketnl_employee_deviatingpostaladdress_housenumber House number of the address
employee_deviatingPostalAddress_houseNumberAddition varchar2(4) itgen_loketnl_employee_deviatingpostaladdress_housenumberaddition 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 varchar2(35) itgen_loketnl_employee_deviatingpostaladdress_location The location like to further specify the address
employee_deviatingPostalAddress_postalCode varchar2(9) itgen_loketnl_employee_deviatingpostaladdress_postalcode The postal code of the address, only nullable if country is not The Netherlands (NL).
employee_deviatingPostalAddress_street varchar2(24) itgen_loketnl_employee_deviatingpostaladdress_street Streetname of the address
employee_employeeNumber int32 itgen_loketnl_employee_employeenumber The employee number to uniquely identify an employee within an employer
employee_exclusionFromAbsenceStatus char itgen_loketnl_employee_exclusionfromabsencestatus Indicates whether the employee is excluded for any information of absence
employee_id guid Employee ID The unique identifier of an object (GUID/UUID)
employee_identityDocument_documentIdentification varchar2 itgen_loketnl_employee_identitydocument_documentidentification
employee_identityDocument_typeOfDocument_key int32 itgen_loketnl_employee_identitydocument_typeofdocument_key The key for the type of document. Possible values can be aquired via the metadata endpoint
employee_identityDocument_typeOfDocument_value varchar2(50) itgen_loketnl_employee_identitydocument_typeofdocument_value Description of the type of document
employee_personalDetails_aowDate datetime itgen_loketnl_employee_personaldetails_aowdate 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 itgen_loketnl_employee_personaldetails_civilstatus_key
employee_personalDetails_civilStatus_value varchar2(50) itgen_loketnl_employee_personaldetails_civilstatus_value
employee_personalDetails_dateOfBirth datetime itgen_loketnl_employee_personaldetails_dateofbirth The date of birth
employee_personalDetails_dateOfDeath datetime itgen_loketnl_employee_personaldetails_dateofdeath The date of death
employee_personalDetails_firstName varchar2(28) itgen_loketnl_employee_personaldetails_firstname The first name, given name, forename or Christian name as part of a persons personal name.
employee_personalDetails_formattedName varchar2(82) itgen_loketnl_employee_personaldetails_formattedname Formatted name of the employee based on the value of howToFormatLastName
employee_personalDetails_gender_key int32 itgen_loketnl_employee_personaldetails_gender_key
employee_personalDetails_gender_value varchar2(50) itgen_loketnl_employee_personaldetails_gender_value
employee_personalDetails_howToFormatLastName_key int32 itgen_loketnl_employee_personaldetails_howtoformatlastname_key
employee_personalDetails_howToFormatLastName_value varchar2(50) itgen_loketnl_employee_personaldetails_howtoformatlastname_value
employee_personalDetails_initials varchar2(6) itgen_loketnl_employee_personaldetails_initials The initials
employee_personalDetails_lastName varchar2(25) itgen_loketnl_employee_personaldetails_lastname The last name, family name or surname as part of a persons personal name.
employee_personalDetails_lastNamePartner varchar2(25) itgen_loketnl_employee_personaldetails_lastnamepartner The last name of the employee's partner.
employee_personalDetails_nationality_key int32 itgen_loketnl_employee_personaldetails_nationality_key The key for the nationality. Possible values can be aquired via the metadata endpoint
employee_personalDetails_nationality_value varchar2(50) itgen_loketnl_employee_personaldetails_nationality_value Description of the nationality
employee_personalDetails_photo varchar2 itgen_loketnl_employee_personaldetails_photo 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 varchar2(24) itgen_loketnl_employee_personaldetails_placeofbirth The place of birth
employee_personalDetails_prefix varchar2(10) itgen_loketnl_employee_personaldetails_prefix The prefix to the last name
employee_personalDetails_prefixPartner varchar2(10) itgen_loketnl_employee_personaldetails_prefixpartner The prefix to the last name of the employee's partner.
employee_personalDetails_title_key int32 itgen_loketnl_employee_personaldetails_title_key
employee_personalDetails_title_value varchar2(50) itgen_loketnl_employee_personaldetails_title_value
employee_revokeEmployeeSelfServiceAccessOn datetime itgen_loketnl_employee_revokeemployeeselfserviceaccesson The date on which the Employee will be automatically blocked.
employee_statusEmployeeSelfService_key int32 itgen_loketnl_employee_statusemployeeselfservice_key
employee_statusEmployeeSelfService_value varchar2(50) itgen_loketnl_employee_statusemployeeselfservice_value
employee_travel_travelDistanceToWork int32 itgen_loketnl_employee_travel_traveldistancetowork The one way distance in meters the employee has to travel to work.
employee_travel_travelDistanceToWorkInKm double itgen_loketnl_employee_travel_traveldistancetoworkinkm The one way distance in kilometers the employee has to travel to work.
employeeProfileId_key int32 Employee Profile ID Key
employeeProfileId_value varchar2 Employee Profile ID Value
employmentCategoryType_key int32 itgen_loketnl_employmentcategorytype_key
employmentCategoryType_value varchar2 itgen_loketnl_employmentcategorytype_value
employmentContractType_key int32 itgen_loketnl_employmentcontracttype_key
employmentContractType_value varchar2 itgen_loketnl_employmentcontracttype_value
employmentDurationType_key int32 Employment Duration Type Key
employmentDurationType_value varchar2 Employment Duration Type Value
endDate datetime End Date The date on which the employment ends. NL: DatumUitDienst
endDate_1 datetime itgen_loketnl_enddate_1 The end date of the entity. The date is up to and including.
endOfEmploymentDueToIllness char itgen_loketnl_endofemploymentduetoillness Indicates whether the reason for the termination of an employment is due to long-term illness. NL: ZiekUitDienst
endOfEmploymentReason_key int32 itgen_loketnl_endofemploymentreason_key The key for the reason for the end of the employment.
endOfEmploymentReason_value varchar2 itgen_loketnl_endofemploymentreason_value The description of the reason for the end of the employment.
endOfEmploymentReasonTaxAuthorities_key int32 itgen_loketnl_endofemploymentreasontaxauthorities_key The key for the reason for the end of the employment.
endOfEmploymentReasonTaxAuthorities_value varchar2 itgen_loketnl_endofemploymentreasontaxauthorities_value The description of the reason for the end of the employment.
essMutationSet_key int32 itgen_loketnl_essmutationset_key
essMutationSet_value varchar2 itgen_loketnl_essmutationset_value
exemptionInsuranceObligation_key int32 itgen_loketnl_exemptioninsuranceobligation_key
exemptionInsuranceObligation_value varchar2 itgen_loketnl_exemptioninsuranceobligation_value
exemptionPremiumWaiverMarginalLabour char itgen_loketnl_exemptionpremiumwaivermarginallabour Indicates whether an exemption (i.e. waiver) on the premium marginal labour (vrijstelling marginale arbeid) applies for this employment. NL: PremieVrijstellingMarginaleArbeid
exemptionWorkRelatedExpenseScheme char itgen_loketnl_exemptionworkrelatedexpensescheme Indicates whether an exemption (i.e. non-participation) on the work-related expense scheme (werkkostenregeling) applies for this employment. NL: WerkkostenRegelingUitsluiting
firstDayNotification char First Day Notification 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
fiscalProperties_annualSalary double itgen_loketnl_fiscalproperties_annualsalary The fiscal annual salary. NL: Fiscaal jaarloon
fiscalProperties_applyDayTables char itgen_loketnl_fiscalproperties_applydaytables Indicates whether the value of the day table is used for the calculation of payroll tax. NL: DagtabelToepassen
fiscalProperties_applyDeviatingPayrollTaxPercentageOn_key int32 itgen_loketnl_fiscalproperties_applydeviatingpayrolltaxpercentageon_key
fiscalProperties_applyDeviatingPayrollTaxPercentageOn_value varchar2(50) itgen_loketnl_fiscalproperties_applydeviatingpayrolltaxpercentageon_value
fiscalProperties_applyPayrollTaxDeduction char itgen_loketnl_fiscalproperties_applypayrolltaxdeduction Indicates whether payroll tax deduction is appliclable (loonheffingskorting). NL: ArbeidskortingToepassen
fiscalProperties_applySalarysplit_key int32 itgen_loketnl_fiscalproperties_applysalarysplit_key
fiscalProperties_applySalarysplit_value varchar2(50) itgen_loketnl_fiscalproperties_applysalarysplit_value Description of the type of document
fiscalProperties_applySingleElderlyTaxDeduction char itgen_loketnl_fiscalproperties_applysingleelderlytaxdeduction Indicates whether wage include Wajong benefits (affects payrolling). NL: LoonInclusiefWajong
fiscalProperties_applyStudentDeduction char itgen_loketnl_fiscalproperties_applystudentdeduction Apply the "Scholierenregeling". NL; ArbeidskortingToepassen
fiscalProperties_contributionReductionEducation_key int32 itgen_loketnl_fiscalproperties_contributionreductioneducation_key
fiscalProperties_contributionReductionEducation_value varchar2(50) itgen_loketnl_fiscalproperties_contributionreductioneducation_value Description of the type of education
fiscalProperties_deviatingCalculationRulePayrollTax_key int32 itgen_loketnl_fiscalproperties_deviatingcalculationrulepayrolltax_key
fiscalProperties_deviatingCalculationRulePayrollTax_value varchar2(50) itgen_loketnl_fiscalproperties_deviatingcalculationrulepayrolltax_value
fiscalProperties_deviatingPayrollTaxPercentage double itgen_loketnl_fiscalproperties_deviatingpayrolltaxpercentage Indicates the deviating payroll tax percentage which is to be applied. NL: AfwijkendLoonbelastingPercentage
fiscalProperties_deviatingPayrollTaxTableColour_key int32 itgen_loketnl_fiscalproperties_deviatingpayrolltaxtablecolour_key
fiscalProperties_deviatingPayrollTaxTableColour_value varchar2(50) itgen_loketnl_fiscalproperties_deviatingpayrolltaxtablecolour_value
fiscalProperties_deviatingPercentageThirtyPercentFacility double itgen_loketnl_fiscalproperties_deviatingpercentagethirtypercentfacility Indicates a deviating percentage which should be applied for the 30% facility (30%-regeling)
fiscalProperties_deviatingSmallJobsArrangement char itgen_loketnl_fiscalproperties_deviatingsmalljobsarrangement Kleine banenregeling
fiscalProperties_deviatingTaxTableCode_key int32 itgen_loketnl_fiscalproperties_deviatingtaxtablecode_key
fiscalProperties_deviatingTaxTableCode_value varchar2(80) itgen_loketnl_fiscalproperties_deviatingtaxtablecode_value
fiscalProperties_doesWageIncludeAow char itgen_loketnl_fiscalproperties_doeswageincludeaow Indicates whether wage include AOW pension (affects payrolling). NL: LoonInclusiefAowUitkering
fiscalProperties_doesWageIncludeWajong char itgen_loketnl_fiscalproperties_doeswageincludewajong Indicates whether wage include Wajong benefits (affects payrolling). NL: LoonInclusiefWajong
fiscalProperties_endDate datetime itgen_loketnl_fiscalproperties_enddate The end date of the entity. The date is up to and including.
fiscalProperties_hasEmployeeLoan char itgen_loketnl_fiscalproperties_hasemployeeloan Whether an employee loan (Personeelslening) is applicable may be indicated here. The Personeelslening indirectly affects the income tax calculations.
fiscalProperties_id guid itgen_loketnl_fiscalproperties_id The unique identifier of an object (GUID/UUID)
fiscalProperties_percentageForeignIncome double itgen_loketnl_fiscalproperties_percentageforeignincome Indicates what percentage of the income of this employment is taxable outside the Netherlands. NL: PercentageBuitenlandsInkomen
fiscalProperties_residentOf_key int32 itgen_loketnl_fiscalproperties_residentof_key
fiscalProperties_residentOf_value varchar2(80) itgen_loketnl_fiscalproperties_residentof_value Description of the type of document
fiscalProperties_specialIndication_four int32 itgen_loketnl_fiscalproperties_specialindication_four Speciale aanduiding 4
fiscalProperties_specialIndication_one int32 itgen_loketnl_fiscalproperties_specialindication_one Speciale aanduiding 1
fiscalProperties_specialIndication_three int32 itgen_loketnl_fiscalproperties_specialindication_three Speciale aanduiding 3
fiscalProperties_specialIndication_two int32 itgen_loketnl_fiscalproperties_specialindication_two Speciale aanduiding 2
fiscalProperties_startDate datetime itgen_loketnl_fiscalproperties_startdate The start date of the entity. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource.
fiscalProperties_thirtyPercentFacility_key int32 itgen_loketnl_fiscalproperties_thirtypercentfacility_key
fiscalProperties_thirtyPercentFacility_value varchar2(50) itgen_loketnl_fiscalproperties_thirtypercentfacility_value
fiscalProperties_usesTransportByWithholdingAgent char itgen_loketnl_fiscalproperties_usestransportbywithholdingagent The so-called 'vervoer vanwege inhoudingsplichtige' is a tax rule that may apply. By example when the employer organizes the transport for the employee.
hasOnCallAppearanceObligation char itgen_loketnl_hasoncallappearanceobligation 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
healthcareInsuranceActConfiguration_additionalContributionEmployer double itgen_loketnl_healthcareinsuranceactconfiguration_additionalcontributionemployer If applicable, please enter any additional contribution (extra bijdrage werkgever) for the employer in relation to the Healthcare Insurance Act (Zorgverzekeringswet).
healthcareInsuranceActConfiguration_additionalPremium double itgen_loketnl_healthcareinsuranceactconfiguration_additionalpremium Additional premium (aanvullende premie) on top of the nomial premium may be registered here, if applicable.
healthcareInsuranceActConfiguration_endDate datetime itgen_loketnl_healthcareinsuranceactconfiguration_enddate The end date of the entity. The date is up to and including.
healthcareInsuranceActConfiguration_healthcareInsuranceActType_key int32 itgen_loketnl_healthcareinsuranceactconfiguration_healthcareinsuranceacttype_key
healthcareInsuranceActConfiguration_healthcareInsuranceActType_value varchar2(50) itgen_loketnl_healthcareinsuranceactconfiguration_healthcareinsuranceacttype_value
healthcareInsuranceActConfiguration_id guid itgen_loketnl_healthcareinsuranceactconfiguration_id The unique identifier of an object (GUID/UUID)
healthcareInsuranceActConfiguration_nominalPremium double itgen_loketnl_healthcareinsuranceactconfiguration_nominalpremium A nominal premium (nominale premie) for the Healthcare Insurance Act may be registered here, if applicable.
healthcareInsuranceActConfiguration_startDate datetime itgen_loketnl_healthcareinsuranceactconfiguration_startdate The start date of the entity. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource.
historicalStartDate datetime Historical Start Date 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 ID The unique identifier of an object (GUID/UUID)
id_1 guid itgen_loketnl_id_1 The unique identifier of an object (GUID/UUID)
incomeRelationshipNumber int32 itgen_loketnl_incomerelationshipnumber 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 char itgen_loketnl_isanonymousemployee An employee that wants to remain anonymous related to social security instances. NL: IsAnoniemeWerknemer
isDirectorAndMajorShareholder char itgen_loketnl_isdirectorandmajorshareholder 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 char itgen_loketnl_isfamilyofowner 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 char itgen_loketnl_isgemoedsbezwaardemployeeinsurance Gemoedsbezwaard Werknemerverzekering. NL: IsGemoedsbezwaardWerknemerverzekering
isGemoedsbezwaardNationalInsurance char itgen_loketnl_isgemoedsbezwaardnationalinsurance Gemoedsbezwaard Volksverzekering. NL: IsGemoedsbezwaardVolksverzekering
isOnCallEmployment char itgen_loketnl_isoncallemployment 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 char itgen_loketnl_ispreviousowner 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
journalAllocation_allocationBasedOnActualHours_costCenter_code varchar2 itgen_loketnl_journalallocation_allocationbasedonactualhours_costcenter_code
journalAllocation_allocationBasedOnActualHours_costCenter_description varchar2 itgen_loketnl_journalallocation_allocationbasedonactualhours_costcenter_description
journalAllocation_allocationBasedOnActualHours_costCenter_key int32 itgen_loketnl_journalallocation_allocationbasedonactualhours_costcenter_key
journalAllocation_allocationBasedOnActualHours_costUnit_code varchar2 itgen_loketnl_journalallocation_allocationbasedonactualhours_costunit_code
journalAllocation_allocationBasedOnActualHours_costUnit_description varchar2 itgen_loketnl_journalallocation_allocationbasedonactualhours_costunit_description
journalAllocation_allocationBasedOnActualHours_costUnit_key int32 itgen_loketnl_journalallocation_allocationbasedonactualhours_costunit_key
journalAllocation_endPeriod_periodEndDate datetime itgen_loketnl_journalallocation_endperiod_periodenddate The last day of the payroll period.
journalAllocation_endPeriod_periodNumber int32 itgen_loketnl_journalallocation_endperiod_periodnumber The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable.
journalAllocation_endPeriod_periodStartDate datetime itgen_loketnl_journalallocation_endperiod_periodstartdate The first day of the payroll period.
journalAllocation_endPeriod_year int32 itgen_loketnl_journalallocation_endperiod_year The year of the last payroll period for which the journal allocation is applicable.
journalAllocation_id guid itgen_loketnl_journalallocation_id The unique identifier of an object (GUID/UUID)
journalAllocation_journalProfileConfiguration_endPeriod_periodEndDate datetime itgen_loketnl_journalallocation_journalprofileconfiguration_endperiod_periodenddate The last day of the payroll period.
journalAllocation_journalProfileConfiguration_endPeriod_periodNumber int32 itgen_loketnl_journalallocation_journalprofileconfiguration_endperiod_periodnumber The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable.
journalAllocation_journalProfileConfiguration_endPeriod_periodStartDate datetime itgen_loketnl_journalallocation_journalprofileconfiguration_endperiod_periodstartdate The first day of the payroll period.
journalAllocation_journalProfileConfiguration_endPeriod_year int32 itgen_loketnl_journalallocation_journalprofileconfiguration_endperiod_year The year of the first payroll period for which the journal allocation is applicable.
journalAllocation_journalProfileConfiguration_id guid itgen_loketnl_journalallocation_journalprofileconfiguration_id The unique identifier of an object (GUID/UUID)
journalAllocation_journalProfileConfiguration_journalProfile_key int32 itgen_loketnl_journalallocation_journalprofileconfiguration_journalprofile_key
journalAllocation_journalProfileConfiguration_journalProfile_value varchar2 itgen_loketnl_journalallocation_journalprofileconfiguration_journalprofile_value
journalAllocation_journalProfileConfiguration_startPeriod_periodEndDate datetime itgen_loketnl_journalallocation_journalprofileconfiguration_startperiod_periodenddate The last day of the payroll period.
journalAllocation_journalProfileConfiguration_startPeriod_periodNumber int32 itgen_loketnl_journalallocation_journalprofileconfiguration_startperiod_periodnumber The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable.
journalAllocation_journalProfileConfiguration_startPeriod_periodStartDate datetime itgen_loketnl_journalallocation_journalprofileconfiguration_startperiod_periodstartdate The first day of the payroll period.
journalAllocation_journalProfileConfiguration_startPeriod_year int32 itgen_loketnl_journalallocation_journalprofileconfiguration_startperiod_year The year of the first payroll period for which the journal allocation is applicable.
journalAllocation_startPeriod_periodEndDate datetime itgen_loketnl_journalallocation_startperiod_periodenddate The last day of the payroll period.
journalAllocation_startPeriod_periodNumber int32 itgen_loketnl_journalallocation_startperiod_periodnumber The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable.
journalAllocation_startPeriod_periodStartDate datetime itgen_loketnl_journalallocation_startperiod_periodstartdate The first day of the payroll period.
journalAllocation_startPeriod_year int32 itgen_loketnl_journalallocation_startperiod_year The year of the first payroll period for which the journal allocation is applicable.
linkedEmployment guid itgen_loketnl_linkedemployment The unique identifier of an object (GUID/UUID)
namePayslip varchar2(34) Name on Payslip Name that is visible on payslips for the employment. NL: NaamLoonstrook
nonPayrollAdministration_description varchar2(50) itgen_loketnl_nonpayrolladministration_description Description of the administration
nonPayrollAdministration_id guid itgen_loketnl_nonpayrolladministration_id The unique identifier of an object (GUID/UUID)
nonPayrollAdministration_name varchar2(70) itgen_loketnl_nonpayrolladministration_name Name of the non payroll administration
organizationalEntity_department_code int32 itgen_loketnl_organizationalentity_department_code
organizationalEntity_department_description varchar2 itgen_loketnl_organizationalentity_department_description
organizationalEntity_department_key guid itgen_loketnl_organizationalentity_department_key The unique identifier of an object (GUID/UUID)
organizationalEntity_deviatingFunctionDescription varchar2(50) itgen_loketnl_organizationalentity_deviatingfunctiondescription The deviating function description of the employment. This description deviates from the value of the function field.
organizationalEntity_deviatingFunctionGroup varchar2(5) itgen_loketnl_organizationalentity_deviatingfunctiongroup The deviating function group description of the employment. Only applies when a deviating function description is defined.
organizationalEntity_distributionUnit_code int32 itgen_loketnl_organizationalentity_distributionunit_code
organizationalEntity_distributionUnit_description varchar2 itgen_loketnl_organizationalentity_distributionunit_description
organizationalEntity_distributionUnit_key guid itgen_loketnl_organizationalentity_distributionunit_key The unique identifier of an object (GUID/UUID)
organizationalEntity_endDate datetime itgen_loketnl_organizationalentity_enddate The end date of the entity. The date is up to and including.
organizationalEntity_function_description varchar2(50) itgen_loketnl_organizationalentity_function_description
organizationalEntity_function_group varchar2(5) itgen_loketnl_organizationalentity_function_group
organizationalEntity_function_key guid itgen_loketnl_organizationalentity_function_key The unique identifier of an object (GUID/UUID)
organizationalEntity_id guid itgen_loketnl_organizationalentity_id The unique identifier of an object (GUID/UUID)
organizationalEntity_internalTelephoneExtensionNumber varchar2(15) itgen_loketnl_organizationalentity_internaltelephoneextensionnumber The phone number of the standard working location (standplaats) for the employment.
organizationalEntity_placeOfEmployment varchar2(24) itgen_loketnl_organizationalentity_placeofemployment The standard working location (standplaats) for the employment.
organizationalEntity_standardFunction_category int32 itgen_loketnl_organizationalentity_standardfunction_category
organizationalEntity_standardFunction_code varchar2(6) itgen_loketnl_organizationalentity_standardfunction_code
organizationalEntity_standardFunction_key int32 itgen_loketnl_organizationalentity_standardfunction_key
organizationalEntity_standardFunction_value varchar2 itgen_loketnl_organizationalentity_standardfunction_value
organizationalEntity_startDate datetime itgen_loketnl_organizationalentity_startdate The start date of the entity. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource.
otherPayrollVariables_endDate datetime itgen_loketnl_otherpayrollvariables_enddate The end date of the entity. The date is up to and including.
otherPayrollVariables_id guid itgen_loketnl_otherpayrollvariables_id The unique identifier of an object (GUID/UUID)
otherPayrollVariables_insuranceProperties_applicableForNoRiskPolicy char itgen_loketnl_otherpayrollvariables_insuranceproperties_applicablefornoriskpolicy Indicates if the employment is applicable for the "Looncompensatie bij ziekte (no-riskpolis)" as defined by the UWV. Please check with the UWV to determine when to set the value to true.
otherPayrollVariables_payrollProperties_applyMinimumWageVocationalLearningPathway char itgen_loketnl_otherpayrollvariables_payrollproperties_applyminimumwagevocationallearningpathway Minimum wage vocational learning pathway (Minimumloon BBL)
otherPayrollVariables_payrollProperties_applyYearlyHoursNorm char itgen_loketnl_otherpayrollvariables_payrollproperties_applyyearlyhoursnorm applyYearlyHoursNorm (jaarurennorm) indicates if the contract is based on a set numbers of hours per year and a set wage is payed every payroll period.
otherPayrollVariables_payrollProperties_collectiveLaborAgreementCodeHiringEmployer_endDate datetime itgen_loketnl_otherpayrollvariables_payrollproperties_collectivelaboragreementcodehiringemployer_enddate The end date of the CAO
otherPayrollVariables_payrollProperties_collectiveLaborAgreementCodeHiringEmployer_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_collectivelaboragreementcodehiringemployer_key
otherPayrollVariables_payrollProperties_collectiveLaborAgreementCodeHiringEmployer_startDate datetime itgen_loketnl_otherpayrollvariables_payrollproperties_collectivelaboragreementcodehiringemployer_startdate The start date of the CAO
otherPayrollVariables_payrollProperties_collectiveLaborAgreementCodeHiringEmployer_value varchar2(90) itgen_loketnl_otherpayrollvariables_payrollproperties_collectivelaboragreementcodehiringemployer_value
otherPayrollVariables_payrollProperties_deviatingPremiumGroup_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_deviatingpremiumgroup_key
otherPayrollVariables_payrollProperties_deviatingPremiumGroup_value varchar2(50) itgen_loketnl_otherpayrollvariables_payrollproperties_deviatingpremiumgroup_value
otherPayrollVariables_payrollProperties_incidentalIncomeDeduction_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_incidentalincomededuction_key
otherPayrollVariables_payrollProperties_incidentalIncomeDeduction_value varchar2(50) itgen_loketnl_otherpayrollvariables_payrollproperties_incidentalincomededuction_value
otherPayrollVariables_payrollProperties_occupationalDisabilityDeductionAfter2009 double itgen_loketnl_otherpayrollvariables_payrollproperties_occupationaldisabilitydeductionafter2009 (OccupationalDisability) Deduction after 2009 (Arbeidsgeh.krt na 2009 (tm 2009 WAO)) Tot en met 2009 moest de premiekorting arbeidsgehandicapte werknemers gesplitst worden in een gedeelte voor de premie WAO/WIA en een gedeelte voor de premie WW-awf of UFO premie. Vanaf 2010 hoeft u het totaalbedrag niet meer te splitsen. Loket.nl zal de bedragen die opgegeven zijn bij Arbeidsgeh.krt na 2009 (tm 2009 WAO) en Arbeidsgeh. krt (tm 2009 AWF/UFO) bij elkaar optellen. U kunt vanaf 2010 dus volstaan met het vullen van Arbeidsgeh.krt na 2009 (tm 2009 WAO). Vanaf 2013 mag dit veld geen waarde meer bevatten, premiekorting arbeidsgehandicapte werknemer wordt automatisch bepaald op basis van opgegeven indicatie bij veld premiekorting
otherPayrollVariables_payrollProperties_occupationalDisabilityDeductionTo2009 double itgen_loketnl_otherpayrollvariables_payrollproperties_occupationaldisabilitydeductionto2009 (OccupationalDisability) Deduction to 2009 (including 2009) (Arbeidsgeh.krt (tm 2009 AWF/UFO)) Tot en met 2009 moest de premiekorting arbeidsgehandicapte werknemers gesplitst worden in een gedeelte voor de premie WAO/WIA en een gedeelte voor de premie WW-awf of UFO premie. Vanaf 2010 hoeft u het totaalbedrag niet meer te splitsen. Loket.nl zal de bedragen die opgegeven zijn bij Arbeidsgeh.krt na 2009 (tm 2009 WAO) en Arbeidsgeh. krt (tm 2009 AWF/UFO) bij elkaar optellen. U kunt vanaf 2010 dus volstaan met het vullen van Arbeidsgeh.krt na 2009 (tm 2009 WAO). Vanaf 2013 mag dit veld geen waarde meer bevatten, premiekorting arbeidsgehandicapte werknemer wordt automatisch bepaald op basis van opgegeven indicatie bij veld premiekorting
otherPayrollVariables_payrollProperties_occupationalDisabilityPremiumDiscount_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_occupationaldisabilitypremiumdiscount_key
otherPayrollVariables_payrollProperties_occupationalDisabilityPremiumDiscount_value varchar2(80) itgen_loketnl_otherpayrollvariables_payrollproperties_occupationaldisabilitypremiumdiscount_value
otherPayrollVariables_payrollProperties_phaseClassification_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_phaseclassification_key
otherPayrollVariables_payrollProperties_phaseClassification_value varchar2(60) itgen_loketnl_otherpayrollvariables_payrollproperties_phaseclassification_value
otherPayrollVariables_payrollProperties_terminateIncomenumberFlexibleEmployment_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_terminateincomenumberflexibleemployment_key
otherPayrollVariables_payrollProperties_terminateIncomenumberFlexibleEmployment_value varchar2(50) itgen_loketnl_otherpayrollvariables_payrollproperties_terminateincomenumberflexibleemployment_value
otherPayrollVariables_payrollProperties_wageCostBenefit_key int32 itgen_loketnl_otherpayrollvariables_payrollproperties_wagecostbenefit_key
otherPayrollVariables_payrollProperties_wageCostBenefit_value varchar2(50) itgen_loketnl_otherpayrollvariables_payrollproperties_wagecostbenefit_value
otherPayrollVariables_payrollProperties_wajongWithWageDispensation char itgen_loketnl_otherpayrollvariables_payrollproperties_wajongwithwagedispensation wajongWithDispensation (Wajong met loondispensatie (was Doelgroep banenafspraak)) indicates that the employer has the express premission to lower the wage of this employment (even below minimum wage). This indicator will disable the validation on minimum wage for this employment.
otherPayrollVariables_pensionProperties_annualCalculationBaseAbp double itgen_loketnl_otherpayrollvariables_pensionproperties_annualcalculationbaseabp annualCalculationBase (jaargrondslag voor ABP) for ABP
otherPayrollVariables_pensionProperties_applyDispensationRiskFund char itgen_loketnl_otherpayrollvariables_pensionproperties_applydispensationriskfund applyDispensationRiskFund (Disp. risicofonds)
otherPayrollVariables_pensionProperties_compulsoryEducationDays int32 itgen_loketnl_otherpayrollvariables_pensionproperties_compulsoryeducationdays compulsoryEducationDays (Aantal dagen leerplicht)
otherPayrollVariables_pensionProperties_deviatingDisabilityInsuranceActPercentageForCordares_key int32 itgen_loketnl_otherpayrollvariables_pensionproperties_deviatingdisabilityinsuranceactpercentageforcordares_key
otherPayrollVariables_pensionProperties_deviatingDisabilityInsuranceActPercentageForCordares_value varchar2(50) itgen_loketnl_otherpayrollvariables_pensionproperties_deviatingdisabilityinsuranceactpercentageforcordares_value
otherPayrollVariables_pensionProperties_leaveAbp_leaveType_key int32 itgen_loketnl_otherpayrollvariables_pensionproperties_leaveabp_leavetype_key
otherPayrollVariables_pensionProperties_leaveAbp_leaveType_value varchar2(50) itgen_loketnl_otherpayrollvariables_pensionproperties_leaveabp_leavetype_value
otherPayrollVariables_pensionProperties_leaveAbp_valueOfParticipationDuringLeave int32 itgen_loketnl_otherpayrollvariables_pensionproperties_leaveabp_valueofparticipationduringleave valueOfParticipation (waardeDeelnemerschap) (pensioen opbouw voor ambtenaren ABP)
otherPayrollVariables_pensionProperties_occupationalPensionFund int32 itgen_loketnl_otherpayrollvariables_pensionproperties_occupationalpensionfund Occupational Pension Fund (BPF-code)
otherPayrollVariables_pensionProperties_specificationOfIncomeRelationshipApg_code varchar2(4) itgen_loketnl_otherpayrollvariables_pensionproperties_specificationofincomerelationshipapg_code
otherPayrollVariables_pensionProperties_specificationOfIncomeRelationshipApg_key int32 itgen_loketnl_otherpayrollvariables_pensionproperties_specificationofincomerelationshipapg_key
otherPayrollVariables_pensionProperties_specificationOfIncomeRelationshipApg_value varchar2(75) itgen_loketnl_otherpayrollvariables_pensionproperties_specificationofincomerelationshipapg_value
otherPayrollVariables_productivityPercentage double itgen_loketnl_otherpayrollvariables_productivitypercentage productivityPercentage (Productiviteitspercentage) can be used to indicate the productivity percentage of an employment.
otherPayrollVariables_startDate datetime itgen_loketnl_otherpayrollvariables_startdate The date on which this record starts. A (broken chain)[./#section/Data/Date-chains] is maintained with this record.
participation55plusRegulationUWV char itgen_loketnl_participation55plusregulationuwv Indicates whether the 55 plus regulation (55 plus regeling) is applicable for the employment. NL: Deelname55Plus
payrollAdministration_clientNumber int32 itgen_loketnl_payrolladministration_clientnumber 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 varchar2(50) itgen_loketnl_payrolladministration_description Description of the administration
payrollAdministration_id guid Payroll Administration ID The unique identifier of an object (GUID/UUID)
payrollAdministration_name varchar2(70) Payroll Administration Name Name of the payroll administration
payrollId int32 Payroll ID 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
pensionBenefits_endDate datetime itgen_loketnl_pensionbenefits_enddate The end date of the entity. The date is up to and including.
pensionBenefits_id guid itgen_loketnl_pensionbenefits_id The unique identifier of an object (GUID/UUID)
pensionBenefits_payout double itgen_loketnl_pensionbenefits_payout The ammount of (gross) pension received
pensionBenefits_startDate datetime itgen_loketnl_pensionbenefits_startdate The date on which this pension benefit starts A (broken chain)[./#section/Data/Date-chains] is maintained within this resource.
periodPayGradeAdjustment int32 itgen_loketnl_periodpaygradeadjustment 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 Profession Code 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 itgen_loketnl_sendtoexternalparty_key
sendToExternalParty_value varchar2 itgen_loketnl_sendtoexternalparty_value
signalPayGradeAdjustment char itgen_loketnl_signalpaygradeadjustment Indicates whether signaling regarding salary scale adjustments are enabled for the employment. NL: SalarisschaalSignaleren
socialSecurityConfiguration_endDate datetime itgen_loketnl_socialsecurityconfiguration_enddate The end date of the entity. The date is up to and including.
socialSecurityConfiguration_id guid itgen_loketnl_socialsecurityconfiguration_id The unique identifier of an object (GUID/UUID)
socialSecurityConfiguration_isInsuredForOccupationalDisabilityInsuranceAct char itgen_loketnl_socialsecurityconfiguration_isinsuredforoccupationaldisabilityinsuranceact Will contributions for the Occupational Disability Insurance Act (WAO) be payed for this employment
socialSecurityConfiguration_isInsuredForSicknessBenefitsAct char itgen_loketnl_socialsecurityconfiguration_isinsuredforsicknessbenefitsact Will contributions for the Sickness Benefits Act (ZW) be payed for this employment
socialSecurityConfiguration_isInsuredForUnemploymentInsuranceAct char itgen_loketnl_socialsecurityconfiguration_isinsuredforunemploymentinsuranceact Will contributions for the Unemployment Insurance Act (WW) be payed for this employment
socialSecurityConfiguration_startDate datetime itgen_loketnl_socialsecurityconfiguration_startdate The start date of the entity. Valide values are either the startDate of the employment or the firstday of a payrolling year. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource.
specialIncomeRatio_key int32 Special Income Ratio Key
specialIncomeRatio_value varchar2 Special Income Ratio Value
startCancellationNoticePeriod datetime itgen_loketnl_startcancellationnoticeperiod 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 Start Date The date on which this employment starts. NL: DatumInDienst
startDate_1 datetime itgen_loketnl_startdate_1 The date on which this base starts. A (linked chain)[./#section/Data/Date-chains] per base is maintained within this resource. So multiple bases can be active at the same time but one specific base can never be active multiple times at the same time.
startDateContractOfIndefiniteDuration datetime itgen_loketnl_startdatecontractofindefiniteduration 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.
statusEmployeeSelfService_hasTwoFactorAuthentication char itgen_loketnl_statusemployeeselfservice_hastwofactorauthentication Does the employee have two factor authentication enabled
statusEmployeeSelfService_status varchar2(50) itgen_loketnl_statusemployeeselfservice_status Description of the status
temporaryTaxExemption_key int32 itgen_loketnl_temporarytaxexemption_key
temporaryTaxExemption_value varchar2 itgen_loketnl_temporarytaxexemption_value
typeOfEmployee_key int32 Type of Employee Key
typeOfEmployee_value varchar2 Type of Employee Value
typeOfParticipation_key int32 itgen_loketnl_typeofparticipation_key
typeOfParticipation_value varchar2 itgen_loketnl_typeofparticipation_value
vacationCoupons_key int32 itgen_loketnl_vacationcoupons_key
vacationCoupons_value varchar2 itgen_loketnl_vacationcoupons_value
valueOfParticipation_key int32 Value of Participation Key
valueOfParticipation_value varchar2 Value of Participation Value
wachtgeldOldRegulation char itgen_loketnl_wachtgeldoldregulation Indicates whether the (old) wachtgeld regulation is applicable for the employment. NL: WachtgeldOudeRegeling
wage_applyPayGrade char itgen_loketnl_wage_applypaygrade 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 itgen_loketnl_wage_employercosts The cost for the employer for this employee.
wage_employerCostsType_key int32 itgen_loketnl_wage_employercoststype_key
wage_employerCostsType_value varchar2(50) itgen_loketnl_wage_employercoststype_value
wage_endDate datetime itgen_loketnl_wage_enddate The end date for the information in the record.
wage_grossWage double itgen_loketnl_wage_grosswage The gross wage for the employee
wage_grossWageType_key int32 itgen_loketnl_wage_grosswagetype_key
wage_grossWageType_value varchar2(50) itgen_loketnl_wage_grosswagetype_value
wage_id guid itgen_loketnl_wage_id The unique identifier of an object (GUID/UUID)
wage_isGrossWageFullTime char itgen_loketnl_wage_isgrosswagefulltime 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 itgen_loketnl_wage_netwage Net wage for the employment
wage_netWageType_key int32 itgen_loketnl_wage_netwagetype_key
wage_netWageType_value varchar2(50) itgen_loketnl_wage_netwagetype_value
wage_payGrade_key int32 itgen_loketnl_wage_paygrade_key
wage_payGrade_value varchar2(50) itgen_loketnl_wage_paygrade_value
wage_payrollPeriodType_key int32 itgen_loketnl_wage_payrollperiodtype_key
wage_payrollPeriodType_value varchar2(50) itgen_loketnl_wage_payrollperiodtype_value
wage_payScale_key int32 itgen_loketnl_wage_payscale_key
wage_payScale_value varchar2(50) itgen_loketnl_wage_payscale_value
wage_startDate datetime itgen_loketnl_wage_startdate The start date for the information in the record. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. Note It is possible to have no wage record.
workinghours_aggregatedHoursPerWeek double itgen_loketnl_workinghours_aggregatedhoursperweek 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 itgen_loketnl_workinghours_averagehoursperweek 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 itgen_loketnl_workinghours_averageparttimefactor 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 char itgen_loketnl_workinghours_calculateusingworkpattern_daysdailyrate 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 char itgen_loketnl_workinghours_calculateusingworkpattern_deviatingdaysandhours 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 char itgen_loketnl_workinghours_calculateusingworkpattern_hoursbrokenperiod 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 char itgen_loketnl_workinghours_calculateusingworkpattern_hoursregularperiod Indicates whether the hours for the payrolling should be calculated based on the workpattern for regular periods.
workinghours_calculateUsingWorkPattern_leaveHours char itgen_loketnl_workinghours_calculateusingworkpattern_leavehours Indicates whether then leave balances (verlof) are to be calculated based on the workpattern. If set to false and the user is not linked to a leave policy with applyLeaveSchedule set to true the following fields are used for the calculation deviatingHoursPerWeek if null shift.fullTimeHoursPerWeek is used
workinghours_contractCode_code int32 itgen_loketnl_workinghours_contractcode_code
workinghours_contractCode_description varchar2 itgen_loketnl_workinghours_contractcode_description
workinghours_contractCode_key guid itgen_loketnl_workinghours_contractcode_key The unique identifier of an object (GUID/UUID)
workinghours_deviatingHoursPerWeek double itgen_loketnl_workinghours_deviatinghoursperweek 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 itgen_loketnl_workinghours_deviatingsvdaysperperiod Sv (social insurance) days are normally calculated by hours per shift, this optional field is used to register a deviating value.
workinghours_endDate datetime itgen_loketnl_workinghours_enddate The end date of the entity. The date is up to and including.
workinghours_flexibleHoursContract_key int32 itgen_loketnl_workinghours_flexiblehourscontract_key
workinghours_flexibleHoursContract_value varchar2(50) itgen_loketnl_workinghours_flexiblehourscontract_value
workinghours_id guid itgen_loketnl_workinghours_id The unique identifier of an object (GUID/UUID)
workinghours_regularWorkPattern char itgen_loketnl_workinghours_regularworkpattern When the employee works the same amount of hours per day every week, then the workpattern is regular.
workinghours_shift_bonusPercentage decimal itgen_loketnl_workinghours_shift_bonuspercentage The bonus percentage used in wage calculations for the hours made in this shift.
workinghours_shift_fullTimeHoursPerWeek decimal itgen_loketnl_workinghours_shift_fulltimehoursperweek The full time hours for an employment that is linked to this shift.
workinghours_shift_shiftNumber int32 itgen_loketnl_workinghours_shift_shiftnumber The number for the shift.
workinghours_shiftRateSickLeave_bonusPercentage decimal itgen_loketnl_workinghours_shiftratesickleave_bonuspercentage The bonus percentage used in wage calculations for the hours made in this shift.
workinghours_shiftRateSickLeave_fullTimeHoursPerWeek decimal itgen_loketnl_workinghours_shiftratesickleave_fulltimehoursperweek The full time hours for an employment that is linked to this shift.
workinghours_shiftRateSickLeave_shiftNumber int32 itgen_loketnl_workinghours_shiftratesickleave_shiftnumber The key number to identify the shift to be used for calculation of daily rate in case of sick leave (ziekte).
workinghours_startDate datetime itgen_loketnl_workinghours_startdate Start date of the record. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource.
workinghours_workPattern_evenWeeks_friday double itgen_loketnl_workinghours_workpattern_evenweeks_friday
workinghours_workPattern_evenWeeks_monday double itgen_loketnl_workinghours_workpattern_evenweeks_monday
workinghours_workPattern_evenWeeks_saturday double itgen_loketnl_workinghours_workpattern_evenweeks_saturday
workinghours_workPattern_evenWeeks_sunday double itgen_loketnl_workinghours_workpattern_evenweeks_sunday
workinghours_workPattern_evenWeeks_thursday double itgen_loketnl_workinghours_workpattern_evenweeks_thursday
workinghours_workPattern_evenWeeks_tuesday double itgen_loketnl_workinghours_workpattern_evenweeks_tuesday
workinghours_workPattern_evenWeeks_wednesday double itgen_loketnl_workinghours_workpattern_evenweeks_wednesday
workinghours_workPattern_oddWeeks_friday double itgen_loketnl_workinghours_workpattern_oddweeks_friday
workinghours_workPattern_oddWeeks_monday double itgen_loketnl_workinghours_workpattern_oddweeks_monday
workinghours_workPattern_oddWeeks_saturday double itgen_loketnl_workinghours_workpattern_oddweeks_saturday
workinghours_workPattern_oddWeeks_sunday double itgen_loketnl_workinghours_workpattern_oddweeks_sunday
workinghours_workPattern_oddWeeks_thursday double itgen_loketnl_workinghours_workpattern_oddweeks_thursday
workinghours_workPattern_oddWeeks_tuesday double itgen_loketnl_workinghours_workpattern_oddweeks_tuesday
workinghours_workPattern_oddWeeks_wednesday double itgen_loketnl_workinghours_workpattern_oddweeks_wednesday
writtenEmploymentContract char itgen_loketnl_writtenemploymentcontract Did the employment and employer make a written contract? NL: Schriftelijke overeenkomst

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: