Schakel JavaScript in om deze site te bekijken.

Loket.nl REST Forums

Navigatie: Schema: Views > Views

EmployerEmploymentPayrollPeriods

Catalogus: LoketNlRest

Schema: Views

Dit is een alleen-lezen view. De Loket.nl REST API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Loket.nl REST ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Loket.nl REST-API.

View Kolommen

De kolommen van de view EmployerEmploymentPayrollPeriods worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.

Naam

Datatype

Label

Verplicht

Documentatie

epr_address_city

string(24)

Plaats

City of the address

epr_address_country_isoCode

string(2)

Land ISO-code

The ISO 3166-1 alpha-2 value for the country

epr_address_country_key

int32

Landsleutel

The key for the country. Possible values can be aquired via the metadata endpoint

epr_address_country_value

string(50)

Landwaarde

The name of the country

epr_address_furtherIndication_key

int32

Adres Verdere Indicatiesleutel

The key of the further indication. Possible values can be aquired via the metadata endpoint

epr_address_furtherIndication_value

string

Adres Verdere Indicatiewaarde

The description of the further indication, the possible values are "WW" and "AB"

epr_address_houseNumber

int32

Huisnummer

House number of the address

epr_address_houseNumberAddition

string(4)

Huisnummertoevoeging

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

string(35)

Locatie

The location like to further specify the address

epr_address_postalCode

string(9)

Postcode

The postal code of the address

epr_address_province_key

int32

Adres Provinciesleutel

The key for the province. Possible values can be aquired via the metadata endpoint

epr_address_province_value

string(50)

Adres Provinciewaarde

The name of the province. Only the Dutch provices are supported and not translated

epr_address_street

string(24)

Straat

Streetname of the address

epr_branch_key

int32

Filiaal Sleutel

The key of the branch. Possible values can be aquired via the metadata endpoint

epr_branch_value

string(50)

Filiaalwaarde

Description of the branch. Branch is only available in Dutch

epr_chamberOfCommerceNumber

string(35)

KvK-nummer

Chamber of commerce number. In Dutch "Kamer van koophandel" number

epr_companyName

string(70)

Naam bedrijf

Naam van het bedrijf

epr_contact_function

string(50)

Contactpersoon Functie

The job title/function of the contact of the employer

epr_contact_name

string(50)

Contactpersoon Naam

Name of the contact of the employer

epr_contact_phoneNumber

string(15)

Telefoonnummer

The general phone number of the employer

epr_contactInformation_emailAddress

string(255)

Contactgegevens E-mailadres

The email address of the employer

epr_contactInformation_faxNumber

string(15)

Contactinformatie Faxnummer

The fax number of the employer

epr_contactInformation_phoneNumber

string(15)

Contactgegevens Telefoonnummer

The telephone number of the employer

epr_contactInformation_website

string(255)

Contactinformatie Website

The website of the employer

epr_deviatingPostalAddress_city

string(24)

Afwijkend Postadres Stad

City of the address

epr_deviatingPostalAddress_country_isoCode

string(2)

Afwijkend Postadres Land ISO-code

The ISO 3166-1 alpha-2 value for the country

epr_deviatingPostalAddress_country_key

int32

Afwijkend Postadreslandsleutel

The key for the country. Possible values can be aquired by the metadata endpoint

epr_deviatingPostalAddress_country_value

string(50)

Afwijkende Postadres Landwaarde

The name of the country

epr_deviatingPostalAddress_furtherIndication_key

int32

Afwijkend Postadres Verdere Indicatiesleutel

The key of the further indication. Possible values can be aquired by the metadata endpoint

epr_deviatingPostalAddress_furtherIndication_value

string

Afwijkende Postadres Verdere Indicatiewaarde

The description of the further indication, the possible values are "WW" and "AB"

epr_deviatingPostalAddress_houseNumber

int32

Afwijkend Postadres Huisnummer

House number of the address

epr_deviatingPostalAddress_houseNumberAddition

string(4)

Afwijkend Postadres Huisnummertoevoeging

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

string(35)

Afwijkend Postadres Locatie

The location like to further specify the address

epr_deviatingPostalAddress_poBox

int32

Afwijkend Postadres Postbus

Post office box

epr_deviatingPostalAddress_postalCode

string(9)

Afwijkend Postadres Postcode

The postal code of the address, only nullable if country is not The Netherlands (NL).

epr_deviatingPostalAddress_street

string(24)

Afwijkende Postadresstraat

Streetname of the address

epr_employerLogo

string

Logo Werkgever

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

Werkgevernummer

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

Rechtsvorm Sleutel

The key of the legal form. Possible values can be aquired via the metadata endpoint

epr_legalForm_value

string(50)

Rechtsvormwaarde

Description of the legal form. Possible values are the legel forms supported by Dutch law

epr_providerLogo

string

Providerlogo

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

string(15)

 

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

 

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

 

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

boolean

 

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-sleutel

The key of the SBI code. Possible values can be aquired via the metadata endpoint

epr_sbi_sbiCode

string(32)

SBI Code

Possible values are the values from the Dutch SBI 2008

epr_sbi_value

string(255)

SBI-waarde

Description of the SBI code

ept_calculateWorkingHours

boolean

Werkuren Berekenen

Automatically calculate working hours for the employment if the option automatically calculate hours is selected for a given period. NL: Completeren/Berekenen uren

ept_cancellationNoticeDate

datetime

Annuleringsdatum

The date on which the notice was given by either the employee or the employer. NL: DatumOpzegging

ept_cancellationPeriodEmployee

int32

Annuleringsverklaring voor Werknemer

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

ept_cancellationPeriodEmployer

int32

Annuleringsverklaring voor Werkgever

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

ept_cancellationPeriodTimeUnit_key

int32

 

 

ept_cancellationPeriodTimeUnit_value

string

 

 

ept_commissionUntilDate

datetime

 

The date on which the employment will end. NL: AanstellingTot

ept_commissionUntilDate1

datetime

 

Until date for commision #1. NL: AanstellingTot1

ept_commissionUntilDate2

datetime

 

Until date for commision #2. NL: AanstellingTot2

ept_commissionUntilDate3

datetime

 

Until date for commision #3. NL: AanstellingTot3

ept_commissionUntilDate4

datetime

 

Until date for commision #4. NL: AanstellingTot4

ept_commissionUntilDate5

datetime

 

Until date for commision #5. NL: AanstellingTot5

ept_commissionUntilDate6

datetime

 

Until date for commision #6. NL: AanstellingTot6

ept_deviatingCLAExternalParty

int32

 

CLA (CAO) code in case of a deviating CLA for external parties . NL: CaoKlantgroepAfwijkend

ept_deviatingCLATaxReturn

int32

 

CLA (CAO) code in case of a deviating CLA for tax returns. NL: CAOUWV

ept_emailLeaveRequest

string(255)

E-mailadres voor Verlofaanvragen

Recipient e-mail adress for notification in case of leave requests. NL: EmailVerlofaanvraag

ept_employee_dateOfBirth

datetime

Medewerker Geboortedatum

The date of birth

ept_employee_employeeNumber

int32

 

The employee number to uniquely identify a employee within a employer.

ept_employee_firstName

string(28)

Medewerker Voornaam

The first name of the employee

ept_employee_formattedName

string(82)

Medewerker Geformatteerde Naam

Formatted name of the employee based on the value of `howToFormatLastName`

ept_employee_id

guid

Werknemer ID

The unique identifier of an object (GUID/UUID)

ept_employee_initials

string(6)

Medewerker Initialen

The initials of the employee

ept_employee_lastName

string(25)

Medewerker Achternaam

The last name of the employee

ept_employee_lastNamePartner

string(25)

 

The last name of the partner of the employee

ept_employee_photo

string

Medewerkersfoto

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.

ept_employee_prefix

string(10)

Medewerker Voorvoegsel

The prefix of the employee

ept_employee_prefixPartner

string(10)

Medewerker Voorvoegsel Partner

The prefix of the partner of the employee

ept_employeeProfileId_key

int32

Werknemersprofiel ID Sleutel

 

ept_employeeProfileId_value

string

Werknemersprofiel ID Waarde

 

ept_employmentCategoryType_key

int32

 

 

ept_employmentCategoryType_value

string

 

 

ept_employmentContractType_key

int32

 

 

ept_employmentContractType_value

string

 

 

ept_employmentDurationType_key

int32

Dienstverbandduursoortsleutel

 

ept_employmentDurationType_value

string

Dienstverbandduursoortwaarde

 

ept_endDate

datetime

Einddatum

The date on which the employment ends. NL: DatumUitDienst

ept_endOfEmploymentDueToIllness

boolean

 

Indicates whether the reason for the termination of an employment is due to long-term illness. NL: ZiekUitDienst

ept_endOfEmploymentReason_key

int32

 

The key for the reason for the end of the employment.

ept_endOfEmploymentReason_value

string

 

The description of the reason for the end of the employment.

ept_endOfEmploymentReasonTaxAuthorities_key

int32

 

The key for the reason for the end of the employment.

ept_endOfEmploymentReasonTaxAuthorities_value

string

 

The description of the reason for the end of the employment.

ept_essMutationSet_key

int32

 

 

ept_essMutationSet_value

string

 

 

ept_exemptionInsuranceObligation_key

int32

 

 

ept_exemptionInsuranceObligation_value

string

 

 

ept_exemptionPremiumWaiverMarginalLabour

boolean

 

Indicates whether an exemption (i.e. waiver) on the premium marginal labour (vrijstelling marginale arbeid) applies for this employment. NL: PremieVrijstellingMarginaleArbeid

ept_exemptionWorkRelatedExpenseScheme

boolean

 

Indicates whether an exemption (i.e. non-participation) on the work-related expense scheme (werkkostenregeling) applies for this employment. NL: WerkkostenRegelingUitsluiting

ept_firstDayNotification

boolean

Eerste Dag Melding

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

ept_hasOnCallAppearanceObligation

boolean

 

In the case of an on-call employment this field indicates whether the employment has an appearance obligation. This field can be `null` in cases where it is unknown whether the employment has an appearance obligation. NL: SoortOproepkrachtOfInvalkracht

ept_historicalStartDate

datetime

Historische Startdatum

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

ept_id

guid

ID

The unique identifier of an object (GUID/UUID)

ept_incomeRelationshipNumber

int32

 

The income relationship number that is required in the tax return. Together with the citizen service number (burgerservicenummer, BSN) and wage tax number, the income relationship number uniquely identifies an employment. NL: NummerInkomstenVerhouding

ept_isAnonymousEmployee

boolean

 

An employee that wants to remain anonymous related to social security instances. NL: IsAnoniemeWerknemer

ept_isDirectorAndMajorShareholder

boolean

 

Indicates whether the employment can be classified as a director and major shareholder (Dutch: directeur-grootaandeelhouder or DGA). This field can be `null` in cases where it is unknown whether the employment can be classified as a director and major shareholder. NL: IsDirecteurGrootAandeelhouder

ept_isFamilyOfOwner

boolean

 

Indicates whether the employment can be classified as a previous owner. This field can be `null` in cases where it is unknown whether the employment can be classified as a director and major shareholder. NL: IsFamilieVanEigenaar

ept_isGemoedsbezwaardEmployeeInsurance

boolean

 

Gemoedsbezwaard Werknemerverzekering. NL: IsGemoedsbezwaardWerknemerverzekering

ept_isGemoedsbezwaardNationalInsurance

boolean

 

Gemoedsbezwaard Volksverzekering. NL: IsGemoedsbezwaardVolksverzekering

ept_isOnCallEmployment

boolean

 

Indicates whether the employment is an on-call employment. This field can be `null` in cases where it is unknown whether the employment is an on-call employment. NL: IsOproepkrachtOfInvalkracht

ept_isPreviousOwner

boolean

 

Indicates whether the employment can be classified as a previous owner. This field can be `null` in cases where it is unknown whether the employment can be classified as a director and major shareholder. NL: IsVorigeEigenaar

ept_linkedEmployment

guid

 

The unique identifier of an object (GUID/UUID)

ept_namePayslip

string(34)

Naam op Loonstrook

Name that is visible on payslips for the employment. NL: NaamLoonstrook

ept_nonPayrollAdministration_description

string(50)

 

Description of the administration

ept_nonPayrollAdministration_id

guid

 

The unique identifier of an object (GUID/UUID)

ept_nonPayrollAdministration_name

string(70)

 

Name of the non payroll administration

ept_participation55plusRegulationUWV

boolean

 

Indicates whether the 55 plus regulation (55 plus regeling) is applicable for the employment. NL: Deelname55Plus

ept_payrollAdministration_clientNumber

int32

 

The client number is a unique number for administrations that are used for payrolling. This field has no value if the administration is not used for payrolling.

ept_payrollAdministration_description

string(50)

 

Description of the administration

ept_payrollAdministration_id

guid

Salarisadministratie ID

The unique identifier of an object (GUID/UUID)

ept_payrollAdministration_name

string(70)

Naam Salarisadministratie

Name of the payroll administration

ept_payrollId

int32

Salarisstrook 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

ept_periodPayGradeAdjustment

int32

 

The values is used for two processes. First off, a message can be configured to notify the user(s) of a upcoming wage raise/negotiation based on the value of this field. Second, the value, in combination with `signalSalaryScaleAdjustment`, is used to signal a wage raises based on the `payScale` and ‘payGrade’. NL: PeriodeSalarisPeriodiek

ept_professionCode

int32

Beroepscode

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

ept_sendToExternalParty_key

int32

 

 

ept_sendToExternalParty_value

string

 

 

ept_signalPayGradeAdjustment

boolean

 

Indicates whether signaling regarding salary scale adjustments are enabled for the employment. NL: SalarisschaalSignaleren

ept_specialIncomeRatio_key

int32

Sleutel voor Speciale Inkomensverhouding

 

ept_specialIncomeRatio_value

string

Speciale Inkomensverhouding

 

ept_startCancellationNoticePeriod

datetime

 

The date on which the term of notice period starts. If the agrement states that a notice periode always starts on the first day of the month and the notice was given on the 15th the start notice periode will be the first day of the next month. NL: AanvangOpzegtermijn

ept_startDate

datetime

Startdatum

The date on which this employment starts. NL: DatumInDienst

ept_startDateContractOfIndefiniteDuration

datetime

 

When did the value of `employmentDurationType` change for definite to indefinite. NL: Startdatum onbepaalde tijd This value should be te samen as the `startDate` if the contract was indefinite from the start.

ept_temporaryTaxExemption_key

int32

 

 

ept_temporaryTaxExemption_value

string

 

 

ept_typeOfEmployee_key

int32

Medewerkersoortsleutel

 

ept_typeOfEmployee_value

string

Type Werknemerswaarde

 

ept_typeOfParticipation_key

int32

 

 

ept_typeOfParticipation_value

string

 

 

ept_vacationCoupons_key

int32

 

 

ept_vacationCoupons_value

string

 

 

ept_valueOfParticipation_key

int32

Waarde van Participatiesleutel

 

ept_valueOfParticipation_value

string

Waarde Participatiewaarde

 

ept_wachtgeldOldRegulation

boolean

 

Indicates whether the (old) wachtgeld regulation is applicable for the employment. NL: WachtgeldOudeRegeling

ept_writtenEmploymentContract

boolean

 

Did the employment and employer make a written contract? NL: Schriftelijke overeenkomst

ppa_costCenter_code

string

Kostenplaatscode

 

ppa_costCenter_description

string

Kostenplaats Omschrijving

 

ppa_costCenter_key

int32

Kostenplaatssleutel

 

ppa_costUnit_code

string

Kostendragercode

 

ppa_costUnit_description

string

Kostendrager Omschrijving

 

ppa_costUnit_key

int32

Kostensleutelcode

 

ppa_distributionUnit_code

int32

Code voor Distributie-eenheid

 

ppa_distributionUnit_description

string

Distributieeenheid Omschrijving

 

ppa_distributionUnit_key

guid

Distributie-eenheid Sleutel

The unique identifier of an object (GUID/UUID)

ppa_id

guid

ID

The unique identifier of an object (GUID/UUID)

ppa_payrollPeriod_periodEndDate

datetime

Einddatum Loonperiode

The last day of the period to which the payroll period data applies

ppa_payrollPeriod_periodNumber

int32

Nummer Verloningsperiode

The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the payroll period in which the payroll data is to be processed.

ppa_payrollPeriod_periodStartDate

datetime

Startdatum Verloningsperiode

The first day of the period to which the payroll period data applies

ppa_payrollPeriod_year

int32

Loonverwerking Jaarperiode

The year of the payroll period in which the payroll data is to be processed

ppa_payslipText

string(25)

Tekst op Loonstrook

A custom text to be displayed on the payslip.

ppa_payslipType_key

int32

Loonstrooksoortsleutel

 

ppa_payslipType_value

string

Loonstrooksoortwaarde

 

ppa_shift_bonusPercentage

decimal

Dienst Bonuspercentage

The bonus percentage used in wage calculations for the hours made in this shift.

ppa_shift_fullTimeHoursPerWeek

decimal

Weekuren Full-time Dienstverband

The full time hours for an employment that is linked to this shift.

ppa_shift_shiftNumber

int32

Dienstnummer

The number for the shift. Loket.nl supports a maximum of 5 shifts per payroll administration.

 

10-06-2024 18:51 Versie 24.1.3-BETA+4689

X

Belangrijke Informatie over Veiligheid en Gebruik

Beoogd gebruik en beperkingen: Deze software, ontwikkeld door Invantive, is ontworpen om een verscheidenheid aan zakelijke en informatietechnologische gegevensverwerkingsfuncties te ondersteunen, zoals boekhouding, financiële rapportage en verkooprapportage. Het is belangrijk om op te merken dat deze software niet is ontworpen, getest of goedgekeurd voor gebruik in omgevingen waar een storing of defect kan leiden tot levensbedreigende situaties, ernstige fysieke schade of milieuschade. Dit omvat, maar is niet beperkt tot:

  • Nucleaire faciliteiten: de software mag niet worden gebruikt voor operaties of functies die verband houden met de controle, het onderhoud of de werking van nucleaire faciliteiten.
  • Defensie en militaire toepassingen: deze software is niet geschikt voor gebruik in defensiegerelateerde toepassingen, inclusief maar niet beperkt tot wapenbeheer, militaire strategieplanning of andere aspecten van nationale defensie.
  • Luchtvaart: de software is niet bedoeld voor gebruik in de bediening, navigatie of communicatiesystemen van vliegtuigen of luchtverkeersleidingomgevingen.
  • Gezondheidszorg en medicijnproductie: deze software mag niet worden gebruikt voor de werking van medische apparaten, de analyse van patiëntgegevens voor kritieke gezondheidsbeslissingen, farmaceutische productie of medisch onderzoek waarbij een storing of defect de gezondheid van de patiënt kan beïnvloeden.
  • Verwerking van chemische en/of gevaarlijke stoffen: deze software is niet bedoeld voor het beheer, de controle of de operationele aspecten van chemische fabrieken of faciliteiten voor de verwerking van chemische en/of gevaarlijke stoffen. Elke storing in de software die in deze omgevingen wordt gebruikt kan leiden tot gevaarlijke chemische lozingen, explosies of milieurampen.
  • Transport- en verkeerscontrolesystemen: de software mag niet worden gebruikt voor de besturing, bediening of het beheer van transportsystemen, waaronder de besturing van spoorwegsignalen, metrosystemen of verkeerslichten. Storingen in dergelijke kritieke systemen kunnen tot ernstige ongelukken leiden en de openbare veiligheid in gevaar brengen.
  • Energienetwerk- en nutsbesturingssystemen: deze software is niet ontworpen voor de besturing of bediening van energienetwerksystemen, waaronder elektrische onderstations, besturingssystemen voor hernieuwbare energie of besturingssystemen van waternutsbedrijven. Het falen van software op deze gebieden kan leiden tot aanzienlijke stroomonderbrekingen, onderbrekingen in de watervoorziening of andere storingen in openbare voorzieningen, waardoor gemeenschappen in gevaar kunnen komen en grote schade kan worden aangericht.
  • Andere omgevingen met een hoog risico: alle andere kritieke infrastructuren en omgevingen waar een storing in de software kan leiden tot aanzienlijke schade aan personen of het milieu.

Gebruikersverantwoordelijkheid: gebruikers moeten ervoor zorgen dat ze het beoogde gebruik van de software begrijpen en de software niet gebruiken in een omgeving die buiten het beoogde doel valt. Het is de verantwoordelijkheid van de gebruiker om de geschiktheid van de software voor de beoogde toepassing te beoordelen, vooral in scenario's die een risico kunnen vormen voor leven, gezondheid en/of milieu.

Afwijzing van aansprakelijkheid: Invantive wijst elke verantwoordelijkheid af voor schade, letsel of wettelijke gevolgen die voortvloeien uit het gebruik of misbruik van deze software in verboden en/of onbedoelde toepassingen.

  
Disclaimer