invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeAbsenceProgresses: Loket.nl REST Employee Absence Progresses

read only

  • Catalog: LoketNlRest
  • Schema: Views
  • Label: Employee Absence Progresses

Can only retrieve data.

Table Columns

The columns of the table EmployeeAbsenceProgresses 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
abe_accidentType_key int32 Accident Type Key The key of the accident type. Possible values can be aquired via the metadata endpoint.
abe_accidentType_value varchar2(50) Accident Type Value Description of the accident type.
abe_actionToBeTakenByOccupationalHealthAndSafetyService_key int32 itgen_loketnl_actiontobetakenbyoccupationalhealthandsafetyservice_key The key of the desired action to be taken by the occupational health and safety service. Possible values can be aquired via the metadata endpoint.
abe_actionToBeTakenByOccupationalHealthAndSafetyService_value varchar2(50) itgen_loketnl_actiontobetakenbyoccupationalhealthandsafetyservice_value Description of the desired action to be taken by the occupational health and safety service.
abe_caseManager_function varchar2(50) itgen_loketnl_casemanager_function Function of the case manager.
abe_caseManager_name varchar2(25) itgen_loketnl_casemanager_name Name of the case manager for reintegration.
abe_caseManager_organization varchar2(70) itgen_loketnl_casemanager_organization Function of the case manager.
abe_caseManager_phoneNumber varchar2(15) itgen_loketnl_casemanager_phonenumber The phone number of the employee.
abe_causeOfAbsence_key int32 Cause of Absence Key The key of the cause of the absence. Possible values can be acquired via the metadata endpoint
abe_causeOfAbsence_value varchar2(50) Cause of Absence Value Description of the cause of the absence.
abe_comments varchar2(4000) Comments Free text field to register any relevant information.
abe_contactInformation_city varchar2(24) Contact Information City City of the address
abe_contactInformation_country_isoCode varchar2(2) Contact Information Country ISO-Code The ISO 3166-1 alpha-2 value for the country
abe_contactInformation_country_key int32 Contact Information Country Key The key for the country. Possible values can be aquired via the metadata endpoint
abe_contactInformation_country_value varchar2(50) Contact Information Country Value The name of the country
abe_contactInformation_endDate datetime itgen_loketnl_contactinformation_enddate end date of the contact information
abe_contactInformation_furtherIndication_key int32 itgen_loketnl_contactinformation_furtherindication_key The key of the further indication. Possible values can be aquired via the metadata endpoint
abe_contactInformation_furtherIndication_value varchar2 itgen_loketnl_contactinformation_furtherindication_value The description of the further indication, the possible values are "WW" and "AB"
abe_contactInformation_houseNumber int32 Contact Information House Number House number of the address
abe_contactInformation_houseNumberAddition varchar2(4) Contact Information House Number Addition 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.
abe_contactInformation_locationType_key int32 itgen_loketnl_contactinformation_locationtype_key The key of the location type. Possible values can be aquired via the metadata endpoint
abe_contactInformation_locationType_value varchar2(50) itgen_loketnl_contactinformation_locationtype_value Description of location type
abe_contactInformation_name varchar2(70) Contact Information Name name of the institute for the contact information.
abe_contactInformation_phoneNumber varchar2(15) Contact Information Phone Number The phone number to contact the employee on.
abe_contactInformation_postalCode varchar2(9) Contact Information Postal Code The postal code of the address
abe_contactInformation_startDate datetime itgen_loketnl_contactinformation_startdate start date of the contact information
abe_contactInformation_street varchar2(24) Contact Information Street Streetname of the address
abe_expectedDateOfChildbirth datetime Expected Date of Child Birth Bevallingsdatum
abe_expectedDuration_key int32 Expected Duration Key The key of the expected duration of the absence. Possible values can be acquired via the metadata endpoint.
abe_expectedDuration_value varchar2(50) Expected Duration Value Description of the expected duration of the absence.
abe_expectedEndDateOfMaternityLeave datetime Expected End Date of Maternity Leave verwachte datum einde zwangerschapsverlof
abe_hasMobilityIssue char itgen_loketnl_hasmobilityissue This field indicates whether the Employee has an issue limiting its mobility.
abe_hoursWorkedOnFirstDayOfAbsence int64 Hours Worked on First Day of Absence The number of hours worked on the first day of the absence.
abe_id guid ID The unique identifier of an object (GUID/UUID)
abe_isDisruptedEmploymentRelationship char itgen_loketnl_isdisruptedemploymentrelationship Indicates whether the employement relationship between employee and employer is disrupted.
abe_isHospitalised char itgen_loketnl_ishospitalised Betreft het een ziekenhuisopnamen
abe_isRecoveredWithinTwoWeeks char itgen_loketnl_isrecoveredwithintwoweeks This field indicates whether the Employee is (expected) recoverd within two weeks, relating to a full recovery.
abe_isThirdPartyLiability char Is 3rd Party Liability This field is related to accidentType. When accidentType is specified, this field indicates whether a third party is liable for the accident.
abe_isWorkRelatedIllness char Is Work-related Illness Beroepsziekte
abe_progress_currentIncapacityPercentage int64 itgen_loketnl_progress_currentincapacitypercentage percentage of not being able to work
abe_progress_endOfAbsence_date datetime itgen_loketnl_progress_endofabsence_date The last day of the absence.
abe_progress_endOfAbsence_reason_key int32 itgen_loketnl_progress_endofabsence_reason_key The key of the reason why the absence is ended. Possible values can be aquired via the metadata endpoint.
abe_progress_endOfAbsence_reason_value varchar2(50) itgen_loketnl_progress_endofabsence_reason_value Description of the reason why the absence ended.
abe_progress_startDate datetime Progress Start Date start dat of the incapacityPercentage
abe_reintegration_dateOfFinalizingPlanOfAction datetime itgen_loketnl_reintegration_dateoffinalizingplanofaction The day on which a plan of action (for return to normal work) was finalized.
abe_reintegration_reintegrationGoal_key int32 itgen_loketnl_reintegration_reintegrationgoal_key The key for the reintegration goal. Related to the Wet Verbetering Poortwachter.
abe_reintegration_reintegrationGoal_value varchar2(50) itgen_loketnl_reintegration_reintegrationgoal_value The name of the country
aps_comments varchar2(4000) Comments Free text field to register any relevant information.
aps_endDate datetime End Date The last day that the incapacityPercentage is active.
aps_id guid ID The unique identifier of an object (GUID/UUID)
aps_incapacityPercentage int64 Incapacity Percentage percentage of not being able to work
aps_startDate datetime Start Date start dat of the incapacityPercentage
aps_typeOfWorkResumption_key int32 Type of Work Resumption Key The key of the type of work resumption. Possible values can be acquired via the metadata endpoint.
aps_typeOfWorkResumption_value varchar2(50) Type of Work Resumption Value Description of the type of work resumption.
epe_address_city varchar2(24) City City of the address
epe_address_country_isoCode varchar2(2) Country ISO-code The ISO 3166-1 alpha-2 value for the country
epe_address_country_key int32 Country Key The key for the country. Possible values can be aquired via the metadata endpoint
epe_address_country_value varchar2(50) Country Value The name of the country
epe_address_furtherIndication_key int32 Address Further Indication Key The key of the further indication ('nadere aanduiding'). Possible values can be aquired via the metadata endpoint
epe_address_furtherIndication_value varchar2 Address Further Indication Value The description of the further indication ('nadere aanduiding'), the possible values are "WW" and "AB"
epe_address_houseNumber int32 House Number House number of the address
epe_address_houseNumberAddition varchar2(4) House Number Addition 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.
epe_address_location varchar2(35) Location The location like to further specify the address
epe_address_postalCode varchar2(9) Postal Code The postal code of the address, only nullable if country is not The Netherlands (NL).
epe_address_street varchar2(24) Street Streetname of the address
epe_contactInformation_businessEmailAddress varchar2(255) itgen_loketnl_contactinformation_businessemailaddress The business e-mail address of the employee.
epe_contactInformation_businessMobilePhoneNumber varchar2(15) itgen_loketnl_contactinformation_businessmobilephonenumber The business mobile phone number of the employee.
epe_contactInformation_businessPhoneNumber varchar2(15) itgen_loketnl_contactinformation_businessphonenumber The business phone number of the employee.
epe_contactInformation_emailAddress varchar2(255) Contact Information Email Address The e-mail address of the employee.
epe_contactInformation_faxNumber varchar2(15) Contact Information Fax Number The fax number to contact this individual
epe_contactInformation_mobilePhoneNumber varchar2(15) itgen_loketnl_contactinformation_mobilephonenumber The mobile phone number of the employee.
epe_contactInformation_phoneNumber varchar2(15) Contact Information Phone Number The phone number of the employee.
epe_deviatingPostalAddress_city varchar2(24) Deviating Postal Address City City of the address
epe_deviatingPostalAddress_country_isoCode varchar2(2) Deviating Postal Address Country ISO-code The ISO 3166-1 alpha-2 value for the country
epe_deviatingPostalAddress_country_key int32 Deviating Postal Address Country Key The key for the country. Possible values can be aquired by the metadata endpoint
epe_deviatingPostalAddress_country_value varchar2(50) Deviating Postal Address Country Value The name of the country
epe_deviatingPostalAddress_furtherIndication_key int32 Deviating Postal Address Further Indication Key The key of the further indication. Possible values can be aquired by the metadata endpoint
epe_deviatingPostalAddress_furtherIndication_value varchar2 Deviating Postal Address Further Indication Value The description of the further indication, the possible values are "WW" and "AB"
epe_deviatingPostalAddress_houseNumber int32 Deviating Postal Address House Number House number of the address
epe_deviatingPostalAddress_houseNumberAddition varchar2(4) Deviating Postal Address House Number Addition 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.
epe_deviatingPostalAddress_location varchar2(35) Deviating Postal Address Location The location like to further specify the address
epe_deviatingPostalAddress_postalCode varchar2(9) Deviating Postal Address Postal Code The postal code of the address, only nullable if country is not The Netherlands (NL).
epe_deviatingPostalAddress_street varchar2(24) Deviating Postal Address Street Streetname of the address
epe_employeeNumber int32 Employee Number The employee number to uniquely identify an employee within an employer
epe_exclusionFromAbsenceStatus char itgen_loketnl_exclusionfromabsencestatus Indicates whether the employee is excluded for any information of absence
epe_id guid ID The unique identifier of an object (GUID/UUID)
epe_identityDocument_documentIdentification varchar2 itgen_loketnl_identitydocument_documentidentification
epe_identityDocument_typeOfDocument_key int32 itgen_loketnl_identitydocument_typeofdocument_key The key for the type of document. Possible values can be aquired via the metadata endpoint
epe_identityDocument_typeOfDocument_value varchar2(50) itgen_loketnl_identitydocument_typeofdocument_value Description of the type of document
epe_personalDetails_aowDate datetime itgen_loketnl_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.
epe_personalDetails_civilStatus_key int32 itgen_loketnl_personaldetails_civilstatus_key
epe_personalDetails_civilStatus_value varchar2(50) itgen_loketnl_personaldetails_civilstatus_value
epe_personalDetails_dateOfBirth datetime Date of Birth The date of birth
epe_personalDetails_dateOfDeath datetime itgen_loketnl_personaldetails_dateofdeath The date of death
epe_personalDetails_firstName varchar2(28) First Name The first name, given name, forename or Christian name as part of a persons personal name.
epe_personalDetails_formattedName varchar2(82) itgen_loketnl_personaldetails_formattedname Formatted name of the employee based on the value of howToFormatLastName
epe_personalDetails_gender_key int32 itgen_loketnl_personaldetails_gender_key
epe_personalDetails_gender_value varchar2(50) itgen_loketnl_personaldetails_gender_value
epe_personalDetails_howToFormatLastName_key int32 itgen_loketnl_personaldetails_howtoformatlastname_key
epe_personalDetails_howToFormatLastName_value varchar2(50) itgen_loketnl_personaldetails_howtoformatlastname_value
epe_personalDetails_initials varchar2(6) Initials The initials
epe_personalDetails_lastName varchar2(25) Last Name The last name, family name or surname as part of a persons personal name.
epe_personalDetails_lastNamePartner varchar2(25) Last Name Partner The last name of the employee's partner.
epe_personalDetails_nationality_key int32 Nationality Key The key for the nationality. Possible values can be aquired via the metadata endpoint
epe_personalDetails_nationality_value varchar2(50) Nationality Value Description of the nationality
epe_personalDetails_photo varchar2 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.
epe_personalDetails_placeOfBirth varchar2(24) itgen_loketnl_personaldetails_placeofbirth The place of birth
epe_personalDetails_prefix varchar2(10) Prefix The prefix to the last name
epe_personalDetails_prefixPartner varchar2(10) Prefix Partner The prefix to the last name of the employee's partner.
epe_personalDetails_title_key int32 Title Key
epe_personalDetails_title_value varchar2(50) Title Value
epe_revokeEmployeeSelfServiceAccessOn datetime itgen_loketnl_revokeemployeeselfserviceaccesson The date on which the Employee will be automatically blocked.
epe_statusEmployeeSelfService_key int32 itgen_loketnl_statusemployeeselfservice_key
epe_statusEmployeeSelfService_value varchar2(50) itgen_loketnl_statusemployeeselfservice_value
epe_travel_travelDistanceToWork int32 itgen_loketnl_travel_traveldistancetowork The one way distance in meters the employee has to travel to work.
epe_travel_travelDistanceToWorkInKm double itgen_loketnl_travel_traveldistancetoworkinkm The one way distance in kilometers the employee has to travel to work.
epr_address_city varchar2(24) City City of the address
epr_address_country_isoCode varchar2(2) Country ISO-code The ISO 3166-1 alpha-2 value for the country
epr_address_country_key int32 Country Key The key for the country. Possible values can be aquired via the metadata endpoint
epr_address_country_value varchar2(50) Country Value The name of the country
epr_address_furtherIndication_key int32 Address Further Indication Key The key of the further indication. Possible values can be aquired via the metadata endpoint
epr_address_furtherIndication_value varchar2 Address Further Indication Value The description of the further indication, the possible values are "WW" and "AB"
epr_address_houseNumber int32 House Number House number of the address
epr_address_houseNumberAddition varchar2(4) House Number Addition 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.
epr_address_location varchar2(35) Location The location like to further specify the address
epr_address_postalCode varchar2(9) Postal Code The postal code of the address
epr_address_province_key int32 Address Province Key The key for the province. Possible values can be aquired via the metadata endpoint
epr_address_province_value varchar2(50) Address Province Value The name of the province. Only the Dutch provices are supported and not translated
epr_address_street varchar2(24) Street Streetname of the address
epr_branch_key int32 Branch Key The key of the branch. Possible values can be aquired via the metadata endpoint
epr_branch_value varchar2(50) Branch Value Description of the branch. Branch is only available in Dutch
epr_chamberOfCommerceNumber varchar2(35) Chamber of Commerce Number Chamber of commerce number. In Dutch "Kamer van koophandel" number
epr_companyName varchar2(70) Company Name Name of the company
epr_contact_function varchar2(50) Contact Function The job title/function of the contact of the employer
epr_contact_name varchar2(50) Contact Name Name of the contact of the employer
epr_contact_phoneNumber varchar2(15) Phone Number The general phone number of the employer
epr_contactInformation_emailAddress varchar2(255) Contact Information Email Address The email address of the employer
epr_contactInformation_faxNumber varchar2(15) Contact Information Fax Number The fax number of the employer
epr_contactInformation_phoneNumber varchar2(15) Contact Information Phone Number The telephone number of the employer
epr_contactInformation_website varchar2(255) Contact Information Website The website of the employer
epr_deviatingPostalAddress_city varchar2(24) Deviating Postal Address City City of the address
epr_deviatingPostalAddress_country_isoCode varchar2(2) Deviating Postal Address Country ISO-code The ISO 3166-1 alpha-2 value for the country
epr_deviatingPostalAddress_country_key int32 Deviating Postal Address Country Key The key for the country. Possible values can be aquired by the metadata endpoint
epr_deviatingPostalAddress_country_value varchar2(50) Deviating Postal Address Country Value The name of the country
epr_deviatingPostalAddress_furtherIndication_key int32 Deviating Postal Address Further Indication Key The key of the further indication. Possible values can be aquired by the metadata endpoint
epr_deviatingPostalAddress_furtherIndication_value varchar2 Deviating Postal Address Further Indication Value The description of the further indication, the possible values are "WW" and "AB"
epr_deviatingPostalAddress_houseNumber int32 Deviating Postal Address House Number House number of the address
epr_deviatingPostalAddress_houseNumberAddition varchar2(4) Deviating Postal Address House Number Addition 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.
epr_deviatingPostalAddress_location varchar2(35) Deviating Postal Address Location The location like to further specify the address
epr_deviatingPostalAddress_poBox int32 Deviating Postal Address Post Office Box Post office box
epr_deviatingPostalAddress_postalCode varchar2(9) Deviating Postal Address Postal Code The postal code of the address, only nullable if country is not The Netherlands (NL).
epr_deviatingPostalAddress_street varchar2(24) Deviating Postal Address Street Streetname of the address
epr_employerLogo varchar2 Employer Logo The location of the logo of the employer. 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.
epr_employerNumber int32 Employer Number The employer number is used in various overviews and exports to identify a specific employer in Loket (please note: this is not the identifier used in the REST API).
epr_id guid ID The unique identifier of an object (GUID/UUID)
epr_legalForm_key int32 Legal Form Key The key of the legal form. Possible values can be aquired via the metadata endpoint
epr_legalForm_value varchar2(50) Legal Form Value Description of the legal form. Possible values are the legel forms supported by Dutch law
epr_providerLogo varchar2 Provider Logo This logo is displayed in the interface of loket.nl. if null no deviating logo is present and the normal provider logo should be used (aquire the URL to the logo via ../v2/providers)
epr_providerSettings_administrationNumber varchar2(15) itgen_loketnl_providersettings_administrationnumber A free field that is most commonly used to store the Debtors Number the provider uses for the employer. This field is used as a key field in some of the existing SOAP webservices.
epr_providerSettings_groupCode int32 itgen_loketnl_providersettings_groupcode The groupcode is used for grouping employers. It is used for filtering output and processes (only include employers in group 40 in this report).
epr_providerSettings_parentEmployerForConsolidatedOverviews int32 itgen_loketnl_providersettings_parentemployerforconsolidatedoverviews This field is used to link employers in order to generate reports containing the information of all the linked employers. By applying this method, infinite amount of employers can be linked.
epr_providerSettings_sendEmailWhenSalarySlipIsAvailable char itgen_loketnl_providersettings_sendemailwhensalaryslipisavailable Indicates whether an e-mail should be sent to an employee if a salary slip becomes available in the employee portal (loket.nl's "werknemer.loket")
epr_sbi_key int32 SBI Key The key of the SBI code. Possible values can be aquired via the metadata endpoint
epr_sbi_sbiCode varchar2(32) SBI Code Possible values are the values from the Dutch SBI 2008
epr_sbi_value varchar2(255) SBI Value Description of the SBI code

Release Notes

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