Tables

The following table provides an overview of all entities exposed by the Data API. Each entry represents a table in our system that can be consumed by integrators:

  • HR Core table: the internal HR Core table name.
  • ODS table: the corresponding source table in the Operational Data Store (ODS).
  • NL name: the original Dutch description used in the source system.
  • Entity name: the entity identifier exposed through the integration interface.


This reference is intended to help integrators understand the relationship between the source data model and the entities available for consumption, and to facilitate data mapping between HR Core and external systems.


# ODS table HR Core table NL name Entity name
1 BO4_AssignmentType dpic356 Soort Inzet assignment-type
2 BO4_ContractType dpic055 Soort contract contract-type
3 BO4_CustomFields     custom-fields
4 BO4_Element DPIA028 Rubrieken element
5 BO4_ElementValue DPIA029 Rubriekswaarde element-value
6 BO4_EmployeeGroup DPIC350 Doelgroep employee-group
7 BO4_EmploymentRelationship dpic355 Soort arbeidsrelatie employment-relationship
8 BO4_FunctionGroup dpic369 Functiegroep function-group
9 BO4_FunctionPaymentType DPIF060 Functieverloning function-payment-type
10 BO4_FunctionProfession DPID132 Beroep function-profession
11 BO4_FunctionStandard DPIF008 Standaard functie function-standard
12 BO4_FunctionStatus DPIC374 Status functie function-status
13 BO4_FunctionType dpia046 Functie type function-type
14 BO4_History dpia037 Historie history
15 BO4_Indication1 dpif021 Formatieplaats indicatie1 indication1
16 BO4_Indication10 dpif030 Formatieplaats indicatie10 indication10
17 BO4_Indication2 dpif022 Formatieplaats indicatie2 indication2
18 BO4_Indication3 dpif023 Formatieplaats indicatie3 indication3
19 BO4_Indication4 dpif024 Formatieplaats indicatie4 indication4
20 BO4_Indication5 dpif025 Formatieplaats indicatie5 indication5
21 BO4_Indication6 dpif026 Formatieplaats indicatie6 indication6
22 BO4_Indication7 dpif027 Formatieplaats indicatie7 indication7
23 BO4_Indication8 dpif028 Formatieplaats indicatie8 indication8
24 BO4_Indication9 dpif029 Formatieplaats indicatie9 indication9
25 BO4_LeaveBlockadeReason dpid024 DV verlofblokkade leave-blockade-reason
26 BO4_LeavePolicyDescription dpid004 Verlofregeling leave-policy-description
27 BO4_LeaveReason dpid002 Verlofreden leave-reason
28 BO4_LeaveRightMutationReason dpid026 Reden verlofrecht mutatie leave-right-mutation-reason
29 BO4_LeaveType dpid001 Verlofsoort leave-type
30 BO4_LeaveTypePolicy dpid010 Verlofsoort regeling leave-type-policy
31 BO4_OrganisationModel dpif001 Organisatiemodel organisation-model
32 BO4_OrganisationUnit dpib015 Organisatorische eenheid organisation-unit
33 BO4_OrganizationalUnitType DPIB018 Org Eenheid type organizational-unit-type
34 BO4_PayrollAmount dpic330 Inpastabel payroll-amount
35 BO4_PayrollCodes     payroll-codes
36 BO4_PersonAddress DPIB005 Land person-address
37 BO4_PersonNationality DPIB006 Nationaliteit person-nationality
38 BO4_Position dpic351 Functie position
39 BO4_PositionAllocation     position-allocation
40 BO4_PositionDetail DPIE204 Toelichting functie position-detail
41 BO4_PositionType dpia046 Functie typen1 position-type
42 BO4_ReasonForLeavingPensionFund DPIC360 Reden uittreding pensioenfonds reason-for-leaving-pension-fund
43 BO4_ReasonOutOfService     reason-out-of-service
44 BO4_RoleAssignment dpib025 Roltoewijzing OE role-assignment
45 BO4_RoleDescription     role-description
46 BO4_SalaryScale dpic333 Salaris schaal salary-scale
47 BO4_SalaryScheme dpic043 Salarisregeling salary-scheme
48 BO4_ScaleSeniority dpic334 Schaal ancienniteit scale-seniority
49 BO4_SicknessCodeAbsence dpid130 Code ziekte verzuim sickness-code-absence
50 BO4_SicknessReason DPID133 Reden ziek sickness-reason
51 BO4_TypeControlZW DPID134 Soort controle ZW type-control-z-w
52 BO4_TypeOfInsurance DPIC363 Soort WN verzekering type-of-insurance
53 BO4_TypeOfPaidWorker TBC Soort loner type-of-paid-worker
54 BO4_TypeOfPayrollTax DPIC361 Soort loonheffingen type-of-payroll-tax
55 BO4_TypeOfPensionFund DPIC362 Soort pensioenfonds type-of-pension-fund
56 FACT_TBL_Sickness   Feitentabel Verzuim sickness
57 FACT_TBL_WorkingDays   Feitentabel Werkdagen working-days
58 TBL_Assignment dpic310 Inzet assignment
59 TBL_BankInfo DPIC302 Bankgiro bank-info
60 TBL_Child DPIB013 Kind child
61 TBL_Contract     contract
62 TBL_CostCenter dpib004 Kostenplaats cost-center
63 TBL_CostType dpic353 Kostensoort cost-type
64 TBL_CostUnit dpic352 Kostendrager cost-unit
65 TBL_EmploymentType dpic355 Soort arbeidsrelatie employment-type
66 TBL_FinancialGroup     financial-group
67 TBL_Function dpic351 Functie function
68 TBL_Journal_Entry_Employee dpil009 Journaalposten werknemer journal-entry-employee
69 TBL_Leave_Blockade dpid024 DV verlofblokkade leave-blockade
70 TBL_Leave_Policy dpid004 Verlofregeling leave-policy
71 TBL_LeaveEntitlement     leave-entitlement
72 TBL_LeavePerDay dpid016 DV Verlof per dag leave-per-day
73 TBL_LeavePeriod dpid015 DV Verlof tijdvak leave-period
74 TBL_LeaveRightMutations dpid027 verlofrechtmutatie leave-right-mutations
75 TBL_OrganizationalUnit dpib015 Organisatorische eenheid organizational-unit
76 TBL_PayrollCode     payroll-code
77 TBL_PayrollInstitution dpic202 Instelling deel 1 payroll-institution
78 TBL_PayrollMutations dpic503 Salarismutatie payroll-mutations
79 TBL_PayrollResults_Staging     payroll-results-staging
80 TBL_PayrollRuns     payroll-runs
81 TBL_Person dpib010 Persoon person
82 TBL_SalaryDistribution DPIC320 Loonverdeling salary-distribution
83 TBL_SicknessCase dpid110 Ziektegeval sickness-case
84 TBL_SicknessCaseDetail dpid111 Ziektetijdvak sickness-case-detail
85 TBL_SystemMutations     system-mutations
86 TBL_WorkDisability DPID148 Arbeidsgehandicapt work-disability
87 TBL_WorkPattern DPID012 DV Werkpatroon work-pattern
88 TBL_WorkSchedule DPID013 DV Werk rooster work-schedule
89 TBL_WorkTherapy DPID112 Werken op AT basis work-therapy
90 TBL_ContractChangingAttributes dpia037 Historie contract-changing-attributes
91 BO4_WageTaxReduction DPIC365 Loonheffingskorting wage-tax-reduction