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	DPIA029	Referentietabel	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	DPIC053	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	DPID023	Reden Blokkeren Verlof	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	DPIF002	Organisatorische eenheid	organisation-unit
33	BO4_OrganizationalUnitType	DPIB018	Org Eenheid type	organizational-unit-type
34	BO4_PayrollAmount	DPIC330	Inpastabel	payroll-amount
35	BO4_PayrollCodes	DPIC004	Uitvoercodes	payroll-codes
36	BO4_PersonAddress	DPIB005	Land	person-address
37	BO4_PersonNationality	DPIB006	Nationaliteit	person-nationality
38	BO4_Position	DPIF003	Formatieplaats	position
39	BO4_PositionAllocation	DPIF006	Formatieplaatstoewijzing	position-allocation
40	BO4_PositionDetail	DPIF013	Formatieplaats omvang	position-detail
41	BO4_PositionType	DPIF056	Formatieplaatssoort	position-type
42	BO4_ReasonForLeavingPensionFund	DPIC360	Reden uittreding pensioenfonds	reason-for-leaving-pension-fund
43	BO4_ReasonOutOfService	DPIC354	Reden einde dv	reason-out-of-service
44	BO4_RoleAssignment	DPIB025	Roltoewijzing OE	role-assignment
45	BO4_RoleDescription	DPIB009	Rol Org. eenheid Dto	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	DPIC359	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	DPIC300	Dienstverband	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	DPIC200	Opdrachtgever	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	DPID014	DV Verlofrechten jaar	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	organization-unit
76	TBL_PayrollCode	DPIC004	Uitvoercodes	payroll-code
77	TBL_PayrollInstitution	DPIC202	Instelling deel 1	payroll-institution
78	TBL_PayrollMutations	DPIC503	Salarismutatie	payroll-mutations
79	TBL_PayrollResults_Staging			payroll-results
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	DPIA098	Mutatieverantwoording	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		Dienstverband historie	contract-changing-attributes
91	BO4_WageTaxReduction	DPIC365	Loonheffingskorting	wage-tax-reduction

BO4_AssignmentType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
TypeAssignment	inzsrt_oms
TypeAssignment_BK	inzsrt_kd

BO4_ContractType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractType	srt_contract_oms
ContractType_BK	srt_contract_kd

BO4_CustomFields

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ElementCode	rubriek_kd
Entity_BK	object_id
Value	waarde

BO4_Element

Matching API fields

DATA API field name	Reporting field name
-	Rubrieken

BO4_ElementValue

Matching API fields

DATA API field name	Reporting field name
-	Rubriekswaarde

BO4_EmployeeGroup

Matching API fields

DATA API field name	Reporting field name
-	Doelgroep

BO4_EmploymentRelationship

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
EmploymentRelationship	aard_arbeid_oms
EmploymentRelationship_BK	aard_arbeid_kd

BO4_FunctionGroup

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
FunctionGroup	fnctgrp_oms
FunctionGroup_BK	fnctgrp_kd

BO4_FunctionPaymentType

Matching API fields

DATA API field name	Reporting field name
-	Functieverloning

BO4_FunctionProfession

Matching API fields

DATA API field name	Reporting field name
-	Beroep

BO4_FunctionStandard

Matching API fields

DATA API field name	Reporting field name
-	Standaard functie

BO4_FunctionStatus

Matching API fields

DATA API field name	Reporting field name
-	Status functie

BO4_FunctionType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
FunctionType_BK	funtyp_kd
FunctionType	oms

BO4_History

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ElementCode	rubriek_kd
EndDate	einde_dt
Logon_ID	logon_id
StartDate	ingangs_dt
Value	waarde
ValueDesc	oms
DPIA037_sl	DPIA037_sl
object_id	-

BO4_Indication1

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode1	fp_code1_oms
IndicationCode1_BK	fp_code1_ind

BO4_Indication10

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode10	fp_code10_oms
IndicationCode10_BK	fp_code10_ind

BO4_Indication2

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode2	fp_code2_oms
IndicationCode2_BK	fp_code2_ind

BO4_Indication3

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode3	fp_code3_oms
IndicationCode3_BK	fp_code3_ind

BO4_Indication4

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode4	fp_code4_oms
IndicationCode4_BK	fp_code4_ind

BO4_Indication5

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode5	fp_code5_oms
IndicationCode5_BK	fp_code5_ind

BO4_Indication6

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode6	fp_code6_oms
IndicationCode6_BK	fp_code6_ind

BO4_Indication7

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode7	fp_code7_oms
IndicationCode7_BK	fp_code7_ind

BO4_Indication8

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode8	fp_code8_oms
IndicationCode8_BK	fp_code8_ind

BO4_Indication9

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
IndicationCode9	fp_code9_oms
IndicationCode9_BK	fp_code9_ind

BO4_LeaveBlockadeReason

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ReasonBlockade	vrlf_blok_oms
ReasonBlockade_BK	vrlf_blok_kd

BO4_LeavePolicyDescription

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Leave_policy_code	vrlfreg_kd
Leave_policy_description	vrlfreg_oms
Leave_policy_hours	vrlf_uren

BO4_LeaveReason

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
LeaveReason	vrlrdn_oms
LeaveReason_BK	vrlfrdn_kd

BO4_LeaveRightMutationReason

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Indication_Standard	standaard_ind
LeaveRightMutationReason	vrlfr_mut_oms
LeaveRightMutationReason_BK	vrlfr_mut_kd

BO4_LeaveType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Indication_BankHoliday	fst_ind
Indication_CompanyLeave	bv_ind
Indication_LegalLeave	wet_verlof_ind
Indication_TimeForTime	tvt_ind
LeaveType_BK	vrlfsrt_kd
LeaveType_Desc	vrlfsrt_oms

BO4_LeaveTypePolicy

Matching API fields

DATA API field name	Reporting field name
Code_Leave_Type	vrlfsrt_kd
ID	-
Timestamp	-
Leave_Type_Rights	vrlfr_srt
Leave_policy_code	vrlfreg_kd
Presentation_Unit	pres_eenh
Start_Month	start_mnd

BO4_OrganisationModel

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Current	actueel
EndDate	eind_dt
Ind_Standard	standaard
OrganisationModel	oms
OrganisationModel_BK	om_kd
StartDate	ingang_dt

BO4_OrganisationUnit

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CostCenter_BK	kstpl_kd
CostUnit_BK	kstdrg_kd
Ind_Blocked	oe_blok
OrgModelUnit	oe_vol_nm
OrgModelUnit_BK	DPIF002_sl
OrganisationModel_BK	om_kd
Parent	oe_hoger_n
ShortName	oe_kort_nm
Type	orgeenh_kd

BO4_OrganizationalUnitType

Matching API fields

DATA API field name	Reporting field name
-	Org Eenheid type

BO4_PayrollAmount

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
PayrollAmountNumber	inpas_nr
PayrollAmountSalary	inpas_sal
SalaryScheme_BK	reg_sal_kd

BO4_PayrollCodes

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
PayrollCode	uitv_sttkst
PayrollCodeCustomDesc	uitv_afwtkst
PayrollCode_BK	uitv_kd

BO4_PersonAddress

Matching API fields

DATA API field name	Reporting field name
-	Land

BO4_PersonNationality

Matching API fields

DATA API field name	Reporting field name
-	Nationaliteit

BO4_Position

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CostCenter_BK	kstpl_kd
CostType_BK	kstsrt_kd
CostUnit_BK	kstdrg_kd
EndDate	eind_dt
EndReason_BK	redeind_kd
Function_BK	func_kd
Ind_Formalised	ind_formatie
IndicationCode10_BK	fp_code10_ind
IndicationCode1_BK	fp_code1_ind
IndicationCode2_BK	fp_code2_ind
IndicationCode3_BK	fp_code3_ind
IndicationCode4_BK	fp_code4_ind
IndicationCode5_BK	fp_code5_ind
IndicationCode6_BK	fp_code6_ind
IndicationCode7_BK	fp_code7_ind
IndicationCode8_BK	fp_code8_ind
IndicationCode9_BK	fp_code9_ind
OrgModelUnit_BK	DPIF002_sl
OrganisationModel_BK	om_kd
PositionInfo_BK	toel
PositionReference	referentie
PositionType_BK	fplsrt_kd
Position_BK	DPIF003_sl
StartDate	ingang_dt

BO4_PositionAllocation

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Contract_BK	-
Contractnumber	-
EndDate	eind_dt
EndReason_BK	eind_toew_kd
FTE	aan_fte
Hours	aan_uren
Info	toel
Person_BK	pers_nr
Position_BK	DPIF003_sl
Reason_BK	red_toew_kd
StartDate	ingang_dt
Status	stattoe_kd

BO4_PositionDetail

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
BlockSize_FTE	aan_fte_blok_vac
BlockSize_Hours	aan_uren_blok_vac
EndDate	eind_dt
Position_BK	DPIF003_sl
RestSize_FTE	aan_fte_rest_vac
RestSize_Hours	aan_uren_rest_vac
Seats	aan_stoel
Size_FTE	aan_fte
Size_Hours	aan_uren
StartDate	ingang_dt

BO4_PositionType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
PositionType	oms
PositionType_BK	fplsrt_kd

BO4_ReasonForLeavingPensionFund

Matching API fields

DATA API field name	Reporting field name
-	Reden uittreding pensioenfonds

BO4_ReasonOutOfService

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ReasonOutOfService	redv_oms
ReasonOutOfService_BK	redv_kd

BO4_RoleAssignment

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
AssignmentDescription	toewijzing_oms
EndDate	eind_dt
OU_BK	DPIB015_sl
Person_BK	pers_nr
RoleDescription_BK	rol_oe_kd
StartDate	ingang_dt

BO4_RoleDescription

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
RoleDescription	rol_oe_oms
RoleDescription_BK	rol_oe_kd

BO4_SalaryScale

Matching API fields

DATA API field name	Reporting field name
Timestamp	-
IndicationYouthScaleActive	jgds_ss_ind
SalaryScale_BK	schaal
SalaryScheme_BK	reg_sal_kd
ScaleDesc	schaal_oms
SortingScale	schaal_sort
TransitionScale	overgangschaal
TransitionSeniority	overgangsanc

BO4_SalaryScheme

Matching API fields

DATA API field name	Reporting field name
Timestamp	-
SalaryScheme	reg_sal_oms
SalaryScheme_BK	reg_sal_kd

BO4_ScaleSeniority

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
PayrollAmountNumber	inpas_nr
SalaryScale_BK	schaal
SalaryScheme_BK	reg_sal_kd
SeniorityDesc	ancien_pres
Seniority_BK	ancien
YouthfullMonths	lft_jgd_mnd
YouthfullYears	lft_jgd_jr

BO4_SicknessCodeAbsence

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Description	zktvrzm_oms
SicknessCodeAbsence_BK	zktvrzm_kd

BO4_SicknessReason

Matching API fields

DATA API field name	Reporting field name
-	Reden ziek

BO4_TypeControlZW

Matching API fields

DATA API field name	Reporting field name
-	Soort controle ZW

BO4_TypeOfInsurance

Matching API fields

DATA API field name	Reporting field name
-	Soort WN verzekering

BO4_TypeOfPaidWorker

Matching API fields

DATA API field name	Reporting field name
-	Soort loner

BO4_TypeOfPayrollTax

Matching API fields

DATA API field name	Reporting field name
-	Soort loonheffingen

BO4_TypeOfPensionFund

Matching API fields

DATA API field name	Reporting field name
-	Soort pensioenfonds

FACT_TBL_Sickness

Matching API fields

DATA API field name	Reporting field name
-	FACT_TBL_Sickness

FACT_TBL_WorkingDays

Matching API fields

DATA API field name	Reporting field name
-	FACT_TBL_WorkingDays

TBL_Assignment

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
Contract_BK	-
CostCenter_BK	kstpl_kd
CostType_BK	kstsrt_kd
CostUnit_BK	kstdrg_kd
EndDate	eind_dt
Function_BK	operfunc_kd
HoursPW	uren_pw
OU_BK	oe_oper_sl
Parttime_percentage	-
Person_BK	pers_nr
StartDate	ingang_dt
TypeAssignment_BK	inzsrt_kd
WorkTimeFactor	-

TBL_BankInfo

Matching API fields

DATA API field name	Reporting field name
-	Bankgiro

TBL_Child

Matching API fields

DATA API field name	Reporting field name
-	Kind

TBL_Contract

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
AdditionalSteps	extra_tr
AdjustmentBaseSalary	correctie_bs
AnnualSalarySpecialRewards	jaarloon_bijz
BaseSalaryHourlyWageNextPeriod	p_basissal_ev
BasicGuaranteeSalaryHourlyWage	p_basisgs
BasicGuaranteedSalaryHourlyWageNextPeriod	p_basisgs_ev
BasicSalaryHourlyWage	p_basissal
BlockReallocationTimeRegistrationIndication	blok_verd_ind
BlockVariableSalaryDistributionIndication	tr_vlv_ind
BlockagePayrollTax	loonhef_blokk
BlockagePeriodically	pdk_blok
CalculatedGuaranteeSalary	ber_gs
CalculatedGuaranteedHourlyWage	ber_gu
CalculationHourlyPaidEmployee_BK	svu_tel_kd
CodeNetWager_BK	netto_loner_kd
CompanyCar_BK	bedrijf_auto_kd
ContractDaysPW	werkdgn
ContractHoursPW	uren_pw
ContractNumber	dv_vlgnr
ContractType_BK	srt_contract_kd
Contract_BK	object_id
DateInService	indnst_dt
DateInServiceCAO	id_cao_dt
DateLastCalculation	ltst_herb_dt
DateOfEntryIntoPensionFund	pensf_indt
DateOfWithdrawalPensionFund	pensf_uitdt
DateOutOfService	uitdnst_dt
DeviatingSVDays	afw_sv_dgn
DisabilityDiscount_BK	ag_korting_kd
DiscountBenefit	korting_uitk
EmployeeGroup_BK	doelgrp_kd
EmploymentRelationship_BK	aard_arbeid_kd
EmploymentType_BK	arelsrt_kd
EntryPeriodBlockingIllnessPayrollProcessor	blk_zk_per
FinancialGroup_BK	opdrgvr_nr
FunctionProfession_BK	beroep
Function_BK	primfunc_kd
GrossHourlyWage	ber_bu
GrossSalary	ber_bs
GuaranteeAllowance	garantie_tlg
GuaranteeSalaryScale_BK	schaal_gs
GuaranteedSalary	salaris_gs
HealthInsurer_BK	zv_kd
IncomeReduction_BK	min_inkomsten_kd
IncomeRelationshipNr	ikv_vlgnr
Ind_Payroll_Distribution	kopp_loonv
IndemnityContinuationPFZW_BK	vrijw_voort_pggm
IndicationStaffLoan	pers_lening_ind
IndicationWageIncludingWAJONG	loon_wajong_ind
InfluenceOfInsuranceObligation_BK	verzek_plicht_kd
LatestPeriodical	pdk_mnd_lt
LifeCourseLeaveDiscount	levenl_vrlf_krt
NominalHourlySalary	uurloon
NominalSalary	salaris
NormHoursPerWeek_BK	norm_urn_kd
NoticePeriodInMonths	opzegterm
OU_BK	oe_hier_sl
PFZWSequenceNr	pggm_vlgnr
PartialServiceTime_BK	deeltijd_kd
ParttimePercentage	deelb_perc
ParttimeSalaryHourlyWage	p_deelt_uurl
PayrollAmountNumber	inpas_nr
PayrollAmountNumberGuarantee	inpas_nr_gs
PayrollInstitution_BK	inst_nr
PayrollTaxReduction_BK	min_loonh
PercentageContinuedPaymentLongTermSickness	doorbet_zk_perc
PercentageGrading	perc_insch
PercentageOfRedundancyPay	perc_wachtg
PercentageSpecialRate	bijz_tarief_perc
PercentageWAOWIACalculation	wao_perc
PeriodPeriodicGuaranteedSalary	pdk_mnd_gs
PeriodPeriodically	pdk_mnd
Person_BK	pers_nr
PolicyALG_BK	reg_alg_kd
PolicyAVBAS_BK	reg_avbas_kd
PolicyBAW_BK	reg_baw_kd
PolicyORD_BK	reg_ord_kd
PolicyOVW_BK	reg_ovw_kd
PolicySLD_BK	reg_sld_kd
PolicyVSD_BK	reg_vsd_kd
PrimaryPayrollInstitution	prim_inst_nr
PrimaryRegistrationNumber	prim_reg_nr
ReEntryWAO	herintr_dt
ReasonEndHealthInsurance	zv_rdn
ReasonForLeavingPFZW_BK	reden_uit_pggm
ReasonForLeavingPensionFund_BK	uit_pf_kd
ReasonOutOfService_BK	redv_kd
RegistrationNumber	reg_nr
SalaryScale_BK	schaal
SalaryScheme_BK	reg_sal_kd
SeniorityGuarantee	ancien_gs
Seniority_BK	ancien
SpecialTaxPolicy_BK	tgrp_bs_kd
StartDateHealthInsurance	zv_ing_dt
StartDateWAO	wao_ing_dt
StartDateWorkPattern	wrkptrn_dt
StepsPeriodicGuaranteedSalary	pdk_sprn_gs
StepsPeriodically	pdk_sprn
SupplementMinimumWage_BK	blok_aml_kd
TypeOfIncomeRatio_BK	soort_inkomen_kd
TypeOfInsurance_BK	wn_vzk_kd
TypeOfPaidWorker_BK	loner_kd
TypeOfPayrollTax_BK	lnh_tab_kd
TypeOfPensionFund_BK	pensf_kd
TypeOfServiceABP_BK	tijd_abp_kd
WAOBenefit	wao_uitk
WIAIVABenefit	wia_iva_uitk
WIAWGABenefit	wia_wga_uitk
WageTaxReduction_BK	lh_krt_kd

TBL_CostCenter

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CostCenter	kstpl_nm
CostCenterStatus	index_ind
CostCenter_BK	kstpl_kd

TBL_CostType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CostType	kstsrt_oms
CostTypeStatus	index_ind
CostType_BK	kstsrt_kd

TBL_CostUnit

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CostUnit	kstdrg_oms
CostUnitStatus	index_ind
CostUnit_BK	kstdrg_kd

TBL_EmploymentType

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Description	arelsrt_oms
EmploymentType_BK	arelsrt_kd
ToPayroll	ind_salverw

TBL_FinancialGroup

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
FinancialGroupName	opdrgvr_oms
FinancialGroup_BK	opdrgvr_nr
Periodicity	verln_per_kd

TBL_Function

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CostType_BK	kstsrt_kd
CostUnit_BK	kstdrg_kd
Function	func_oms
FunctionDescription	func_bschr
FunctionGroup_BK	fnctgrp_kd
FunctionPaymentType_BK	funver_kd
FunctionStandard_BK	stanf_kd
FunctionStatus_BK	statfunc_kd
FunctionType_BK	funtyp_kd
Function_BK	func_kd
InactiveFunction	index_ind

TBL_Journal_Entry_Employee

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Amount	pkb_bedrag
Contra Account	jp_reknr
Contract Number	dv_vlgnr
Cost Center Code	kstpl_kd
Cost Type Code	kstsrt_kd
Cost Unit Code	kstdrg_kd
FTE	aant_fte
financialGroup_BK	opdrgvr_nr
Hours	aant_uren
JournalEntry_BK	DPIL009_sl
Origin Code	herkomst_kd
PayrollInstitution_BK	inst_nr
Person BK	pers_nr
Production Period	prod_periode
Registrationnumber	reg_nr
Year	jaar

TBL_Leave_Blockade

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
Contract_BK	-
EndDate	tm_dt
LeaveBlockadeNumber	DPID024_sl
LeaveBlockade_BK	-
LeaveCode	vrlfsrt_kd
PercentageLeaveBlockade	vrlf_blok_perc
Person_BK	pers_nr
ReasonBlockade_BK	vrlf_blok_kd
StartDate	vanaf_dt

TBL_Leave_Policy

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Begin_date_leave_policy	begin_dt
ContractNumber	dv_vlgnr
Contract_BK	-
End_date_leave_policy	eind_dt
Leave_policy_code	vrlfreg_kd
Person_BK	pers_nr

TBL_LeaveEntitlement

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
AgeBasedRights	vrlfr_lft
ContractNumber	dv_vlgnr
ExtraLeaveRights	vrlfr_eu
FullTimeSalaryExtraRights	vrlfr_sal
LastCalculatedExtraHours	ltst_ber_eu
LastLeaveCalculationDate	vrlfber_dt
LeaveRightMutations	vrlfr_mut
LeaveRightsCode1	vrlfr_ov1
LeaveRightsCode2	vrlfr_ov2
LeaveRightsCurrentYear	vrlfr_hjr
LeaveType_BK	vrlfsrt_kd
LeaveYear	vrlfr_jr
Person_BK	pers_nr
SalaryScaleRights	vrlfr_sch
SalarySeniorityRights	vrlfr_inp
StandardLeaveRights	vrlfr_std
TimeForTimeRights	vrlfr_tvt
TransferredRights	vrlfr_vjr
WorkingYearBasedRights	vrlfr_djr

TBL_LeavePerDay

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
Hours	vrlf_uren
LeaveDate	vrlf_dt
LeavePeriodNumber	vtvk_vlgnr
LeaveType_BK	vrlfsrt_kd
LeaveYear	vrlfr_jr
Person_BK	pers_nr

TBL_LeavePeriod

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
EndDate	vtvk_edt
LeavePeriodNumber	vtvk_vlgnr
LeaveReason_BK	vrlfrdn_kd
LeaveType_BK	vrlfsrt_kd
LeaveYear	vrlfr_jr
Person_BK	pers_nr
StartDate	vtvk_bdt

TBL_LeaveRightMutations

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
Contract_BK	-
LeaveRightMutationDate	vrlfr_mut_dt
LeaveRightMutationHours	vrlfr_mut_uren
LeaveRightMutationReason_BK	vrlfr_mut_kd
LeaveRightMutation_BK	DPID027_sl
LeaveType_BK	vrlfsrt_kd
LeaveYear	vrlfr_jr
Person_BK	pers_nr

TBL_OrganizationalUnit

Matching API fields

DATA API field name	Reporting field name
Auth_Level	oe_autor_n
City_OU	oe_plaats
CostCenter	kstpl_kd
Housenumber	oe_huisnr
Housnr_Addition	oe_hnr_toev
ID	-
OU_BK	DPIB015_sl
OU_Key	-
OU_Level	oe_autor
OU_ShortName	oe_kort_nm
OrganizationalUnit	oe_vol_nm
OrganizationalUnitTypeCode	orgeenh_kd
Parent_OU_BK	oe_hoger_n
Parent_OU_Description	-
PhoneNumber	oe_telefoon
Status_OU	oe_blok
Street_OU	oe_straat
Timestamp	-
Zipcode_OU	oe_postcode

TBL_PayrollCode

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Description	-
EndDate	-
financialGroup_BK	-
PayrollCode_BK	-
PayrollInstitution_BK	-
StartDate	-

TBL_PayrollInstitution

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CLA_BK	cao_kd
financialGroup_BK	opdrgvr_nr
PayrollInstitutionName	i_naam
PayrollInstitution_BK	inst_nr
StandardHoursPW	uur_wk_i

TBL_PayrollMutations

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CalculationPeriod	verreken_per
ContractNumber	dv_vlgnr
Contract_BK	-
DeliveryNumber	aanlev_nr
DeliveryPeriod	periode
ElementCode	rubriek_kd
financialGroup_BK	opdrgvr_nr
IndCorrection	sal_wijz_ind
IndDataType	ind_gegsrt
IndExtReference	ind_ext_ref
LogonID	logon_id
MutationDate	mut_dt
MutationStartDate	inggsmut_dt
MutationTime	mut_tijd
ObjectID	object_id
Origination	actie
PayrollInstitution_BK	inst_nr
Person_BK	pers_nr
ProductionType	prod_srt
Recalculation	twk_mut
RecalculationStartPeriod	twk_per_va
RecordID	DPIC503_sl
RegistrationNumber	reg_nr
SalaryPeriod	prod_per
StamVariable	stam_var
UserID	gebr_id
Value	w_nieuw

TBL_PayrollResults_Staging

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
CalculationPeriodNumber	-
CalculationYear	-
CostAllocation_BK	-
FinancialGroup_BK	-
IKVNumber	-
PayrollCode_BK	-
PayrollInstitution_BK	-
PayrollResult	-
RegistrationNumber	-
RunSequenceNumber	-

TBL_PayrollRuns

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
FinancialGroup_BK	-
PaymentPeriod	-
PaymentYear	-
PayrollRunStatus	-
RunSequenceNumber	-
afroepnr	-
runDescription	-

TBL_Person

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
BirthPlace	geb_plts
CommencementDateResidentialAddress	w_ing_dt
CommunicationLanguage	-
DateOfBirth	geb_dt
DateOfDeath	overl_dt
DisplayName	-
EffectiveDatePostalAddress	p_ing_dt
FirstNamePartner	p_voornmn
Gender	geslacht
GenderPartner	p_geslacht
Initials	e_vrlt
InitialsPartner	p_vrlt
KnownAs	e_roepnaam
LastNameAtBirth	e_naam
NamePartner	p_naam
Nationality_BK	nat_kd
PersonBSN	sofi_nr
PersonFirstName	e_voornmn
PersonLastName	naam_samen
Person_BK	pers_nr
PersonalEmail	email_prive
PersonalPhone1	mobiel_tel_nr
PostalAddressAddition	p_hnr_toev
PostalAddressCity	p_plaats
PostalAddressCountryCode	p_land_kd
PostalAddressHouseNumber	p_huisnr
PostalAddressLocation	p_locatie
PostalAddressPhonenumber	p_tel_nr
PostalAddressRegion	p_regio
PostalAddressStreet	p_straat
PostalAddressZIPCode	p_postcode
PrefixLastNameToUse	vrvg_samen
PrefixLastnameAtBirth	e_vrvg
PrefixPartner	p_vrvg
PrimaryEmail	email_werk
PrimaryPhone	werk_tel_nr
ResidentialAddressAddition	w_hnr_toev
ResidentialAddressCity	w_plaats
ResidentialAddressCountryCode	w_land_kd
ResidentialAddressHouseNumber	w_huisnr
ResidentialAddressLocation	w_locatie
ResidentialAddressPhonenumber	w_tel_nr
ResidentialAddressRegion	w_regio
ResidentialAddressStreet	w_straat
ResidentialAddressZIPCode	w_postcode
StartDate_MaritalStatus	burgst_miv
TitlePrefix	e_titul
TitleSuffix	e_titul_na
UseOfLastName	gbrk_naam
WorkEmail1	-
WorkLocation	locatie
WorkPhone1	-

TBL_SalaryDistribution

Matching API fields

DATA API field name	Reporting field name
-	Loonverdeling

TBL_SicknessCase

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
Contract_BK	-
DateBegin	ao_dag_dt
DateEnd	herst_dt
EndDateWagePayment	lnbet_eind_dt
Expected_recovery	verw_h_dt
Ind_Preg-cy	zwvrlf_ind
Ind_Safetynet	vangnet_ind
NewSicknessCase	doorl_ind
Person_BK	pers_nr
ReasonUWVBenefit_BK	uwv_uitk_rdn_kd
Recovery_notification_date	beterm_dt
Safetynet_BK	vangnet_kd
SicknessCase_BK	object_id
SicknessCodeAbsence_BK	zktvrzm_kd
SicknessDossier_DateBegin	eerste_ao_dag_dt
SicknessDossier_DateEnd	-
SicknessReason_BK	rdn_zk
Sickness_notifcation_date	zkmeld_dt
Sickness_notifcation_time	zkmeld_tijd
Time_of_disability	ao_tijdst
TypeControlZW_BK	cntrzw_srt
WVP_Date	wvp_ao_dt
WorkedHoursFirstRecoveryDay	ao_gewuren
DPID110_sl	DPID110_sl

TBL_SicknessCaseDetail

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
ContractNumber	dv_vlgnr
Contract_BK	-
DateBegin	ztvk_vanaf
DateEnd	ztvk_tot
Last_mutation_date	mut_dt
PercentageSick	perc_ziek
Person_BK	pers_nr
SicknessCaseDetail_BK	object_id
DPID110_sl	DPID110_sl
DPID111_sl	DPID111_sl

TBL_SystemMutations

Matching API fields

DATA API field name	Reporting field name
ID	-
Timestamp	-
Action	actie
Contract_BK	-
DataType	gegsrt_id
Description	prompt
ElementCode	rubriek_kd
ElementType	rubsrt_kd
FunctionIdentification	func_id
IndRestrospective	twk_mut
IndStamVar	stam_var
LogDate	log_dt
LogNr	log_volgnr
LogTime	log_tijd
Logon_ID	logon_id
Person_BK	-
ProductionType	prod_srt
RetroPeriod	twk_per
RetroPeriodStart	twk_per_va
SalaryPeriod	prod_per
StartDate	ingangs_dt
SystemMutation_BK	object_id
TransactionNr	trans_nr
User_ID	gebr_id
ValueNew	w_nieuw
ValueNewDescription	oms_nieuw
ValueOld	w_oud
ValueOldDescription	oms_oud

TBL_WorkDisability

Matching API fields

DATA API field name	Reporting field name
-	Arbeidsgehandicapt

TBL_WorkPattern

Matching API fields

DATA API field name	Reporting field name
-	DV Werkpatroon

TBL_WorkSchedule

Matching API fields

DATA API field name	Reporting field name
-	DV Werk rooster

TBL_WorkTherapy

Matching API fields

DATA API field name	Reporting field name
-	Werken op AT basis

TBL_ContractChangingAttributes

Matching API fields

DATA API field name	Reporting field name
-	Dienstverband historie

BO4_WageTaxReduction

Matching API fields

DATA API field name	Reporting field name
-	Loonheffingskorting