invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeEducations: Loket.nl REST Employee Educations

read only

  • Catalog: LoketNlRest
  • Schema: Views
  • Label: Employee Educations

Can only retrieve data.

Table Columns

The columns of the table EmployeeEducations 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
edn_educationLevel_key int32 itgen_loketnl_educationlevel_key
edn_educationLevel_value varchar2(80) itgen_loketnl_educationlevel_value
edn_employeeCosts double itgen_loketnl_employeecosts The costs of the education for the employee
edn_employerCosts double Employer Costs The costs of the education for the employer
edn_endDate datetime End Date The end date of the entity. The date is up to and including.
edn_endOfValidityDate datetime itgen_loketnl_endofvaliditydate The end date of the diploma validity . The date is up to and including.
edn_furtherIndication_code varchar2 itgen_loketnl_furtherindication_code
edn_furtherIndication_description varchar2 itgen_loketnl_furtherindication_description
edn_furtherIndication_key guid itgen_loketnl_furtherindication_key The unique identifier of an object (GUID/UUID)
edn_hasDiploma_key int32 itgen_loketnl_hasdiploma_key
edn_hasDiploma_value varchar2(80) itgen_loketnl_hasdiploma_value
edn_id guid ID The unique identifier of an object (GUID/UUID)
edn_institute_city varchar2(24) itgen_loketnl_institute_city City of the institute
edn_institute_Name varchar2(70) itgen_loketnl_institute_name Name of the institute
edn_name varchar2(50) Name Name of the education
edn_particularities varchar2(4000) Particularities Extra information about the education
edn_startDate datetime Start Date The date on which this education starts.
edn_typeOfEducation_code varchar2 itgen_loketnl_typeofeducation_code
edn_typeOfEducation_description varchar2 itgen_loketnl_typeofeducation_description
edn_typeOfEducation_key guid itgen_loketnl_typeofeducation_key The unique identifier of an object (GUID/UUID)
edn_yearOfDiploma int32 itgen_loketnl_yearofdiploma Year in which the diploma was aquired
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: