Tables

The following section 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:

• Core table: the internal HR Core table name.
• Entity name: the entity identifier exposed through the integration interface.
• Internal Table: the internal Data table name.
• Key: possible values: PK (primary key) & BK (business key).

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.

assignment

• Entity Name: assignment
• Core Table: DPIC310
• Internal Table: TBL_Assignment

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
CostCenterBK	varchar(7)	BK	kstpl_kd	P01128	Kostenplaats inzet
CostTypeBK	varchar(7)	BK	kstsrt_kd	P01127	Kostensoort inzet
CostUnitBK	varchar(7)	BK	kstdrg_kd	P01129	Kostendrager inzet
EndDate	date		eind_dt	P01126	Einde inzet
Function_BK	varchar(30)	PK, BK	operfunc_kd	P01122	Operationele functie
HoursPW	decimal(10,2)		uren_pw	P01124	Uren inzet per week
Id	int		—	—	—
OU_BK	varchar(30)	PK, BK	oe_oper_sl	P01121	Operationele org. eenheid
PartTimePercentage	numeric(6,4)		—	—	—
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
StartDate	date	PK	ingang_dt	P01125	Ingang inzet
Timestamp	datetime2(2)		—	—	—
TypeAssignmentBK	varchar(3)	BK	inzsrt_kd	P01123	Soort inzet
WorkTimeFactor	decimal(6,4)		—	—	—

assignment-type

• Entity Name: assignment-type
• Core Table: DPIC356
• Internal Table: BO4_AssignmentType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
TypeAssignment	varchar(25)		inzsrt_oms	—	—
TypeAssignmentBK	varchar(3)	PK, BK	inzsrt_kd	P01123	Soort inzet

bank-info

• Entity Name: bank-info
• Core Table: DPIC302
• Internal Table: TBL_BankInfo

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Amount	numeric(9,2)		bg_bd	P01205	Bedrag bankgegevens
Balance	numeric(9,2)		saldo	P01206	Saldo bedrag bankrekening
BankInfoNumber	numeric(3,0)	PK	bg_vlgnr	P01201	Volgnr bankgegevens
BIC	varchar(11)		bic	P01208	BIC Code
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDate	datetime		bg_eind_dt	—	—
IBAN	varchar(34)		iban	P01207	IBAN Code
Id	int		—	—	—
PaymentReason	varchar(100)		reden_bet	P01204	Reden betaling bankgegevens
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
StartDate	datetime		bg_begin_dt	—	—
Timestamp	datetime2(2)		—	—	—
TransactionAscribedTo	varchar(50)		afw_ten	P01203	Afw tenaamstelling bankgegevens

child

• Entity Name: child
• Core Table: DPIB013
• Internal Table: TBL_Child

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
BirthdateChild	datetime		k_geb_dt	P01081	Geboortedatum kind
Child_BK	varchar(30)	PK, BK	dpib013_sl	P01080	Kindnummer
DeathdateChild	datetime		k_overl_dt	P01087	Overlijdensdatum kind
DiffNameChild	varchar(30)		k_afw_naam	P01085	Afw naam-kind
DiffPrefixChild	varchar(10)		k_afw_vrvg	P01084	Afw voorvoegsel-kind
FirstNameChild	varchar(25)		k_voornmn	P01083	Voornaam kind
GenderChild	varchar(1)		k_geslacht	P01086	Geslacht kind
Id	int		—	—	—
InitialsChild	varchar(6)		k_vrlt	P01082	Voorletters-kind
Person_BK	varchar(30)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

contract

• Entity Name: contract
• Core Table: DPIC300
• Internal Table: TBL_Contract

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AdditionalSteps	numeric(3,0)		extra_tr	P00359	Extra treden salaris
AdjustmentBaseSalary	numeric(10,2)		correctie_bs	—	—
AnnualSalarySpecialRewards	numeric(10,2)		jaarloon_bijz	—	—
BaseSalaryHourlyWageNextPeriod	numeric(9,2)		p_basissal_ev	—	—
BasicGuaranteedSalaryHourlyWageNextPeriod	numeric(9,2)		p_basisgs_ev	—	—
BasicGuaranteeSalaryHourlyWage	numeric(9,2)		p_basisgs	—	—
BasicSalaryHourlyWage	numeric(9,2)		p_basissal	—	—
BlockagePayrollTax	numeric(10,2)		loonhef_blokk	—	—
BlockagePeriodically	varchar(1)		pdk_blok	P00355	Ind blokkade periodiek
BlockReallocationTimeRegistrationIndication	varchar(1)		blok_verd_ind	P02110	Blokkeren verdeling tijdregistratie
BlockVariableSalaryDistributionIndication	varchar(1)		tr_vlv_ind	P02109	Blokkeren variabele loonverdeling
CalculatedGuaranteedHourlyWage	numeric(6,2)		ber_gu	P01160	Berekend garantie uurloon
CalculatedGuaranteeSalary	numeric(9,2)		ber_gs	P01159	Berekend garantiesalaris
CalculationHourlyPaidEmployeeBK	varchar(1)	BK	svu_tel_kd	P02108	code SV-dagen + uren uurloners tellen
CodeNetWagerBK	numeric(2,0)	BK	netto_loner_kd	—	—
CompanyCarBK	numeric(2,0)	BK	bedrijf_auto_kd	—	—
ContractBK	varchar(30)	BK	object_id	—	—
ContractDaysPerWeek	varchar(7)		werkdgn	P00448	Werkdagen
ContractHoursPerWeek	numeric(5,2)		uren_pw	P01109	Uren per week
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
ContractTypeBK	numeric(2,0)	BK	srt_contract_kd	P08259	Code contract (on)bepaalde tijd
DateInService	datetime		indnst_dt	P00322	Datum in dienst
DateInServiceCao	datetime		id_cao_dt	P00834	Datum in dienst CAO
DateLastCalculation	datetime		ltst_herb_dt	—	—
DateOfEntryIntoPensionFund	datetime		pensf_indt	P00831	Datum intreding pensioenfonds
DateOfWithdrawalPensionFund	datetime		pensf_uitdt	P00832	Datum uittreding pensioenfonds
DateOutOfService	datetime		uitdnst_dt	P00830	Datum uit dienst
DeviatingSvDays	numeric(6,2)		afw_sv_dgn	P00447	Afw aantal Sv dagen
DisabilityDiscountBK	numeric(3,0)	BK	ag_korting_kd	P00930	Vervallen (Vervallen)
DiscountBenefit	numeric(10,2)		korting_uitk	—	—
EmployeeGroupBK	varchar(3)	BK	doelgrp_kd	P01110	Code doelgroep
EmploymentRelationshipBK	char(2)	BK	aard_arbeid_kd	P02268	Code aard arbeidsverhouding
EmploymentTypeBK	varchar(3)	BK	arelsrt_kd	P01102	Soort arbeidsrelatie
EntryPeriodBlockingIllnessPayrollProcessor	varchar(6)		blk_zk_per	P01683	Ingangs periode blokkade ziekte salarisverw.
FinancialGroupBK	numeric(6,0)	BK	opdrgvr_nr	P01103	Opdrachtgever
FunctionBK	varchar(10)	BK	primfunc_kd	P01107	Primaire functie
FunctionProfessionBK	varchar(10)	BK	beroep	P00311	Functie/Beroep
GrossHourlyWage	numeric(6,2)		ber_bu	P01162	Berekend bruto uurloon
GrossSalary	numeric(9,2)		ber_bs	P01161	Berekend bruto salaris
GuaranteeAllowance	numeric(10,2)		garantie_tlg	—	—
GuaranteedSalary	numeric(9,2)		salaris_gs	P00471	Garantiesalaris
GuaranteeSalaryScaleBK	varchar(4)	BK	schaal_gs	P01157	Garantieschaalnummer
HealthInsurerBK	varchar(3)	BK	zv_kd	P01891	Code zorgverzekeraar
Id	int		—	—	—
IncomeReductionBK	numeric(2,0)	BK	min_inkomsten_kd	P02263	Code incidentele inkomstenvermindering
IncomeRelationshipNr	numeric(5,0)		ikv_vlgnr	P01114	Volgnummer inkomstenverhouding
Ind_Payroll_Distribution	varchar(1)		kopp_loonv	P01112	Ind koppelen loonverdeling
IndemnityContinuationPfzwBK	numeric(2,0)	BK	vrijw_voort_pggm	P02516	Vrijwillige voortzetting PFZW (Vervallen)
IndicationStaffLoan	numeric(2,0)		pers_lening_ind	P02262	Indicatie voordeel uit personeelslening(Vervallen)
IndicationWageIncludingWajong	numeric(2,0)		loon_wajong_ind	P02261	Indicatie loon incl. WAJONG uitkering
InfluenceOfInsuranceObligationBK	numeric(2,0)	BK	verzek_plicht_kd	P08258	Code invloed verzekeringsplicht
LatestPeriodical	varchar(6)		pdk_mnd_lt	P00836	Periode laatste periodiek
LifeCourseLeaveDiscount	numeric(11,2)		levenl_vrlf_krt	P01398	(Vervallen) Levensloopverlofkorting
NominalHourlySalary	numeric(6,2)		uurloon	P01154	Uurloon
NominalSalary	numeric(9,2)		salaris	P01153	Salaris
NormHoursPerWeekBK	numeric(2,0)	BK	norm_urn_kd	P02486	Cd norm-uren fulltime per week
NoticePeriodInMonths	varchar(1)		opzegterm	P01108	Opzegtermijn in maanden
OUBK	numeric(10,0)	BK	oe_hier_sl	P01106	Hierarchische org. eenheid
PartialServiceTimeBK	varchar(3)	BK	deeltijd_kd	P00421	Code deeldiensttijd
ParttimePercentage	numeric(6,2)		deelb_perc	P00404	Percentage deelbetrekking
ParttimeSalaryHourlyWage	numeric(9,2)		p_deelt_uurl	—	—
PayrollAmountNumber	numeric(5,0)		inpas_nr	P01152	Inpassingsnr salaris
PayrollAmountNumberGuarantee	numeric(5,0)		inpas_nr_gs	P00318	Inpassingsnr gar.salaris
PayrollInstitutionBK	numeric(5,0)	BK	inst_nr	P01104	Instelling
PayrollTaxReductionBK	numeric(3,0)	BK	min_loonh	—	—
PercentageContinuedPaymentLongTermSickness	numeric(7,2)		doorbet_zk_perc	—	—
PercentageGrading	numeric(8,4)		perc_insch	P00504	Procentuele inschaling
PercentageOfRedundancyPay	numeric(6,2)		perc_wachtg	P00422	Percentage wachtgeld
PercentageSpecialRate	numeric(7,2)		bijz_tarief_perc	—	—
PercentageWaoWiaCalculation	numeric(6,2)		wao_perc	P00429	Percentage WAO-WIA berekend
PeriodPeriodically	numeric(3,0)		pdk_mnd	P00353	Periode periodiek
PeriodPeriodicGuaranteedSalary	numeric(3,0)		pdk_mnd_gs	P00470	Periode periodiek gar.salaris
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
PfzwSequenceNr	numeric(4,0)		pggm_vlgnr	P00358	Volgnummer pensioenfonds PFZW
PolicyAlgBK	varchar(3)	BK	reg_alg_kd	P02107	code regeling alg
PolicyAvbasBK	varchar(3)	BK	reg_avbas_kd	P02102	code regeling Avbas
PolicyBawBK	varchar(3)	BK	reg_baw_kd	P02103	Code regeling BAW
PolicyOrdBK	varchar(3)	BK	reg_ord_kd	P02100	code regeling ord
PolicyOvwBK	varchar(3)	BK	reg_ovw_kd	P02101	code regeling ovw
PolicySldBK	varchar(3)	BK	reg_sld_kd	P02104	code regeling sld
PolicyVsdBK	varchar(3)	BK	reg_vsd_kd	P02106	code regeling vsd
PrimaryPayrollInstitution	numeric(5,0)		prim_inst_nr	P00988	(Vervallen) Instellingsnummer hoofd DV
PrimaryRegistrationNumber	numeric(7,0)		prim_reg_nr	P00989	(Vervallen) Registratie nummer hoofd DV
ReasonEndHealthInsurance	varchar(1)		zv_rdn	P01895	Reden einde zorgverzekeraar
ReasonForLeavingPensionFundBK	varchar(3)	BK	uit_pf_kd	P01183	Reden uittreden ABP (Vervallen)
ReasonForLeavingPfzwBK	numeric(2,0)	BK	reden_uit_pggm	—	—
ReasonOutOfServiceBK	varchar(3)	BK	redv_kd	P01113	Reden einde dv
ReEntryWao	datetime		herintr_dt	P01682	Ingangsdatum herintreding WAO
RegistrationNumber	numeric(7,0)		reg_nr	P01105	Registratienr
SalaryScaleBK	varchar(4)	BK	schaal	P01151	Schaal salaris
SalarySchemeBK	varchar(3)	BK	reg_sal_kd	P00314	Code salarisregeling
SeniorityBK	numeric(3,0)	BK	ancien	P00326	Ancienniteit salaris
SeniorityGuarantee	numeric(3,0)		ancien_gs	P01158	Ancienniteit garantieschaal
SpecialTaxPolicyBK	varchar(3)	BK	tgrp_bs_kd	P00334	Code speciale fiscale regeling
StartDateHealthInsurance	datetime		zv_ing_dt	P01893	Ingangsdatum zorgverzekeraar
StartDateWao	datetime		wao_ing_dt	P01680	Ingangsdatum WAO
StartDateWorkPattern	datetime		wrkptrn_dt	P01401	Ingangsdatum werkpatroon
StepsPeriodically	varchar(10)		pdk_sprn	P01171	Sprongen periodiek
StepsPeriodicGuaranteedSalary	varchar(10)		pdk_sprn_gs	P01172	Sprongen periodiek gar.salaris
SupplementMinimumWageBK	varchar(1)	BK	blok_aml_kd	P00339	Aanvulling minimumloon
Timestamp	datetime2(2)		—	—	—
TypeOfIncomeRatioBK	numeric(3,0)	BK	soort_inkomen_kd	P00893	Code soort inkomstenverhouding
TypeOfInsuranceBK	varchar(3)	BK	wn_vzk_kd	P01182	Soort wn-verzekering
TypeOfPaidWorkerBK	varchar(3)	BK	loner_kd	P00332	Code soort loner
TypeOfPayrollTaxBK	varchar(3)	BK	lnh_tab_kd	P00333	Soort loonheffingstabel
TypeOfPensionFundBK	varchar(3)	BK	pensf_kd	P00315	Soort pensioenfonds
TypeOfServiceAbpBK	varchar(3)	BK	tijd_abp_kd	P00859	Code soort diensttijd ABP
WageTaxReductionBK	numeric(2,0)	BK	lh_krt_kd	P00354	Loonheffingskorting
WaoBenefit	numeric(9,2)		wao_uitk	P00005	WIA uitk dagbedrag
WiaIvaBenefit	numeric(10,2)		wia_iva_uitk	P01391	WIA IVA uitkering(Vervallen)
WiaWgaBenefit	numeric(10,2)		wia_wga_uitk	P01392	WIA WGA uitkering(Vervallen)

contract-changing-attributes

• Entity Name: contract-changing-attributes
• Core Table: —
• Internal Table: TBL_Contract_ChangingAttributes

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
30_percent_policy	varchar(50)		—	—	—
30_percent_policy_BK	varchar(50)	BK	—	—	—
Active	bit		—	—	—
Additional_Steps	numeric(3,0)		—	—	—
Blockage_Periodically	varchar(1)		—	—	—
Blockage_Supplement_Minimum_Wage_BK	varchar(1)	BK	—	—	—
Calculated_Guarantee_Salary	numeric(9,2)		—	—	—
Calculated_Guaranteed_Hourly_Wage	numeric(6,2)		—	—	—
CodeWIA	int		—	—	—
CodeWW	int		—	—	—
CodeZW	int		—	—	—
Company_Car	varchar(50)		—	—	—
Company_Car_BK	int	BK	—	—	—
ContractBK	varchar(30)	BK	—	—	—
ContractDaysPW	varchar(7)		—	—	—
ContractHoursPw	decimal(10,2)		—	—	—
ContractHoursPWChanged	int		—	—	—
ContractHoursPWChangedDate	date		—	—	—
ContractNumber	int		—	—	—
ContractStartdtBK	bigint	PK	—	—	—
ContractType	varchar(10)		—	—	—
ContractType_description	varchar(100)		—	—	—
ContractTypeChanged	int		—	—	—
ContractTypeChangedDate	date		—	—	—
CostCenter	varchar(100)		—	—	—
CostCenterBK	varchar(10)	BK	—	—	—
CostCenterDescription	varchar(1000)		—	—	—
CostType	varchar(100)		—	—	—
CostTypeBK	varchar(10)	BK	—	—	—
CostTypeDescription	varchar(1000)		—	—	—
CostUnit	varchar(100)		—	—	—
CostUnitBK	varchar(10)	BK	—	—	—
CostUnitChanged	int		—	—	—
CostUnitChangedDate	date		—	—	—
CostUnitDescription	varchar(1000)		—	—	—
Current	bit		—	—	—
Date_Anniversary	date		—	—	—
Date_ID_FirstDateInService	int		—	—	—
Date_ID_LastDateOutOfService	int		—	—	—
DateInService	date		—	—	—
Date_In_Service_CAO	date		—	—	—
Date_of_Entry_Into_The_Pension_Fund	date		—	—	—
Date_of_Withdrawal_Pension_Fund	date		—	—	—
DateOutOfService	date		—	—	—
Date_Out_Of_Service_Current	date		—	—	—
Date_out_of_service_slicer	date		—	—	—
DaysTherapy	tinyint		—	—	—
DescriptionActivities	varchar(50)		—	—	—
Deviating_SV_Days	numeric(6,2)		—	—	—
Disability_discount_BK	int	BK	—	—	—
Disability_discount_desc	varchar(25)		—	—	—
Employee_Group_BK	varchar(3)	BK	—	—	—
Employee_Group_desc	varchar(25)		—	—	—
Employment_percentage	decimal(6,2)		—	—	—
Employment_Relationship_Code	char(2)		—	—	—
Employment_Relationship_Desc	varchar(25)		—	—	—
EmploymentTypeBK	varchar(3)	BK	—	—	—
EmploymentTypeChanged	int		—	—	—
EmploymentTypeChangedDate	date		—	—	—
EndDate	date		—	—	—
EndDate_slicer	date		—	—	—
EndDateTherapy	date		—	—	—
Entry_period_blocking_illness_payroll_processor	varchar(6)		—	—	—
FinancialGroupBK	varchar(30)	BK	—	—	—
FinancialGroupChanged	int		—	—	—
FinancialGroupChangedDate	date		—	—	—
FinancialGroupPayrollBK	varchar(3000)		—	—	—
First_Date_in_service	date		—	—	—
FunctionBK	varchar(30)	BK	—	—	—
Function_Profession	varchar(10)		—	—	—
FunctionChanged	int		—	—	—
FunctionChangedDate	date		—	—	—
GrossHourlyWage	numeric(9,2)		—	—	—
GrossHourlyWageChanged	int		—	—	—
GrossHourlyWageChangedDate	date		—	—	—
GrossSalary	numeric(9,2)		—	—	—
GrossSalaryChanged	int		—	—	—
GrossSalaryChangedDate	date		—	—	—
Guarantee_Salary_Scale_BK	varchar(4)	BK	—	—	—
Guarantee_Salary_Scale_desc	varchar(25)		—	—	—
Guaranteed_salary	numeric(9,2)		—	—	—
Guaranteed_Salary_Scheme_BK	varchar(3)	BK	—	—	—
GuaranteedSalaryScheme_Desc	varchar(25)		—	—	—
GuaranteeSalaryScaleBKChanged	int		—	—	—
GuaranteeSalaryScaleBKChangedDate	date		—	—	—
Health_Insurer_BK	varchar(3)	BK	—	—	—
Health_Insurer_Name	varchar(50)		—	—	—
Health_Insurer_Short_Name	varchar(25)		—	—	—
Health_Insurer_Type	varchar(1)		—	—	—
HoursTherapy	numeric(5,2)		—	—	—
Id	int		—	—	—
Income_reduction_BK	numeric(2,0)	BK	—	—	—
Income_reduction_desc	varchar(25)		—	—	—
IncomeRelationship_Nr	numeric(5,0)		—	—	—
Indemnity_continuation_PFZW	numeric(2,0)		—	—	—
Indemnity_continuation_PFZW_desc	varchar(25)		—	—	—
Indication_Insured_Accoring_to_Sickness_Law	varchar(1)		—	—	—
Indication_Staff_Loan	numeric(2,0)		—	—	—
Indication_Wage_Including_WAJONG_desc	varchar(25)		—	—	—
Indication_youth_scale_active	varchar(1)		—	—	—
Indication_youth_scale_active_Guarantee	varchar(1)		—	—	—
IndicationEmployeeRecovered	varchar(2)		—	—	—
Influence_Of_Insurance_Obligation_BK	int	BK	—	—	—
Influence_Of_Insurance_Obligation_desc	varchar(25)		—	—	—
Integration_number_Guarantee_salary	int		—	—	—
InternalMovement	varchar(50)		—	—	—
Last_Date_out_of_service	date		—	—	—
Last_Date_out_of_service_slicer	date		—	—	—
Latest_Periodical	varchar(6)		—	—	—
Life-course_Leave_Discount	numeric(11,2)		—	—	—
Linked_contract	int		—	—	—
Month_DateInService	int		—	—	—
Month_DateInService_CAO	int		—	—	—
Month_DateOutOfService	int		—	—	—
Month_EndDate	int		—	—	—
Month_FirstDateInService	int		—	—	—
Month_LastDateOutOfService	int		—	—	—
Month_StartDate	int		—	—	—
Next Anniversary	numeric(11,1)		—	—	—
Nominal_Hourly_Salary	numeric(6,2)		—	—	—
Nominal_Salary	numeric(9,2)		—	—	—
NormHoursPerWeek_BK	int	BK	—	—	—
Notice_Period_In_Months	varchar(1)		—	—	—
ORD_Policy_Code	varchar(3)		—	—	—
ORD_Policy_Desc	varchar(25)		—	—	—
OrganizationalUnitChanged	int		—	—	—
OrganizationalUnitChangedDate	date		—	—	—
OUBK	varchar(30)	BK	—	—	—
OUTherapy	varchar(50)		—	—	—
OUTherapyName	varchar(50)		—	—	—
OwnOrAdaptedActivities	varchar(2)		—	—	—
Partial_Service_Time_Code	varchar(3)		—	—	—
ParttimePercentage	numeric(6,4)		—	—	—
PartTimePercentageChanged	int		—	—	—
PartTimePercentageChangedDate	date		—	—	—
Payroll_Amount_Number	int		—	—	—
PayrollAmount_Number (Scale Seniority)	int		—	—	—
PayrollAmount_Number_Guarantee_Scale_Seniority	int		—	—	—
PayrollAmount_Salary (Scale Seniority)	numeric(8,2)		—	—	—
PayrollAmountNumberChanged	int		—	—	—
PayrollAmountNumberChangedDate	date		—	—	—
PayrollAmountNumberGuaranteeChanged	int		—	—	—
PayrollAmountNumberGuaranteeChangedDate	date		—	—	—
PayrollIndicator	bit		—	—	—
PayrollInstitutionBK	varchar(30)	BK	—	—	—
PayrollInstitutionChanged	int		—	—	—
PayrollInstitutionChangedDate	date		—	—	—
PayrollScheme	varchar(3)		—	—	—
PayrollScheme_desc	varchar(25)		—	—	—
Percentage_Grading	numeric(8,4)		—	—	—
Percentage_of_Redundancy_Pay	numeric(6,2)		—	—	—
Percentage_WAO_WIA_Calculation	numeric(7,2)		—	—	—
PercentagePayValue	numeric(6,2)		—	—	—
Period_Periodic_Guaranteed_Salary	numeric(3,0)		—	—	—
Period_Periodically	int		—	—	—
PersonBK	int	BK	—	—	—
PFZW_Sequence_Nr	numeric(4,0)		—	—	—
Policy_BAW	varchar(25)		—	—	—
Policy_BAW_Code	char(3)		—	—	—
PrevStartDate	date		—	—	—
Primary_Payroll_Institution	int		—	—	—
Primary_Registration_Number	numeric(7,0)		—	—	—
Quarter_DateInService	int		—	—	—
Quarter_DateInService_CAO	int		—	—	—
Quarter_DateOutOfService	int		—	—	—
Quarter_EndDate	int		—	—	—
Quarter_FirstDateInService	int		—	—	—
Quarter_LastDateOutOfService	int		—	—	—
Quarter_StartDate	int		—	—	—
Re-entry_WAO	date		—	—	—
RealDateInService	date		—	—	—
RealDateOutOfService	date		—	—	—
Reason_ABP_resignation_BK	varchar(3)	BK	—	—	—
Reason_for_End_of_Health_Insurance	varchar(1)		—	—	—
Reason_for_Leaving_Pension_Fund	varchar(3)		—	—	—
Reason_no_addition_car	varchar(50)		—	—	—
Reason_no_addition_car_BK	int	BK	—	—	—
ReasonOutOfService	varchar(3)		—	—	—
Reason_Out_Of_Service_Current	varchar(3)		—	—	—
Reason_Out_Of_Service_Desc	varchar(25)		—	—	—
Reason_Out_Of_Service_Desc_Current	varchar(25)		—	—	—
Reason-for-Leaving-Pension_Fund_desc	varchar(25)		—	—	—
RegistrationNumber	varchar(30)		—	—	—
Salary_Guarantee_Scale_Seniority	numeric(8,2)		—	—	—
Salary_Payroll_Amount_Guarantee	numeric(8,2)		—	—	—
Salary_Payroll_Amount_Table	numeric(8,2)		—	—	—
SalaryScaleBK	varchar(4)	BK	—	—	—
SalaryScale_Desc	varchar(25)		—	—	—
SalaryScaleBKChanged	int		—	—	—
SalaryScaleBKChangedDate	date		—	—	—
SalarySchemeBKChanged	int		—	—	—
SalarySchemeBKChangedDate	date		—	—	—
Scale_Payroll_Amount	varchar(1)		—	—	—
Security_BK	varchar(65)	BK	—	—	—
Seniority	varchar(2)		—	—	—
Seniority_desc	varchar(5)		—	—	—
Seniority_Guarantee	int		—	—	—
Seniority_Guarantee_desc	varchar(5)		—	—	—
SeniorityBKChanged	int		—	—	—
SeniorityBKChangedDate	date		—	—	—
SeniorityGuaranteeChanged	int		—	—	—
SeniorityGuaranteeChangedDate	date		—	—	—
Sequence_Number_Income_Ratio	numeric(5,0)		—	—	—
Sequence_Number_PFZW	numeric(4,0)		—	—	—
Sorting_Guarantee_Salary_Scale	varchar(4)		—	—	—
Sorting_Scale	varchar(4)		—	—	—
Special_Tax_Policy_Code	varchar(3)		—	—	—
StandardHoursPW	decimal(10,2)		—	—	—
Start_Date_Health_Insurance	date		—	—	—
Start_date_WAO	date		—	—	—
Start_date_Work_Pattern	date		—	—	—
StartDate	date		—	—	—
StartDateTherapy	date		—	—	—
Steps_Periodic_Guaranteed_Salary	varchar(10)		—	—	—
Steps_Periodically	varchar(10)		—	—	—
Supplement_Minimum_Wage	varchar(25)		—	—	—
Timestamp	datetime2(2)		—	—	—
Transition_Scale	varchar(4)		—	—	—
Transition_Scale_Guarantee_Salary	varchar(4)		—	—	—
Transition_Seniority	int		—	—	—
Transition_Seniority_Guarantee_Salary	int		—	—	—
Type_of_Employee_Insurance_BK	varchar(3)	BK	—	—	—
Type_Of_Income_Ratio_BK	int	BK	—	—	—
Type_Of_Income_Ratio_desc	varchar(25)		—	—	—
Type_of_payroll_Tax_BK	varchar(3)	BK	—	—	—
Type_of_payroll_Tax_desc	varchar(25)		—	—	—
Type_of_Pension_Fund_BK	varchar(3)	BK	—	—	—
Type_of_service_ABP_BK	varchar(3)	BK	—	—	—
Type-of_Pension_Fund_desc	varchar(25)		—	—	—
TypeOfPaidWorker	varchar(3)		—	—	—
TypeOfPaidWorker_desc	varchar(100)		—	—	—
TypeOfPaidWorkerChanged	int		—	—	—
TypeOfPaidWorkerChangedDate	date		—	—	—
Wage_Tax_reduction_BK	int	BK	—	—	—
Wage_Tax_reduction_desc	varchar(25)		—	—	—
WAO_benefit	numeric(9,2)		—	—	—
WIA_IVA_benefit	numeric(10,2)		—	—	—
WIA_WGA_benefit	numeric(10,2)		—	—	—
WorkingAmount	decimal(6,2)		—	—	—
WorkingPeriod	varchar(50)		—	—	—
WorkingUnit	varchar(50)		—	—	—
Year_DateInService	int		—	—	—
Year_DateInService_CAO	int		—	—	—
Year_DateOutOfService	int		—	—	—
Year_EndDate	int		—	—	—
Year_FirstDateInService	int		—	—	—
Year_LastDateOutOfService	int		—	—	—
Year_StartDate	int		—	—	—
YearsInService	int		—	—	—
Youthfull_months	int		—	—	—
Youthfull_months_Guarantee_Salary	int		—	—	—
Youthfull_years	int		—	—	—
Youthfull_years_Guarantee_Salary	int		—	—	—

contract-type

• Entity Name: contract-type
• Core Table: DPIC055
• Internal Table: BO4_ContractType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		srt_contract_oms	—	—
ContractTypeBK	int	PK, BK	srt_contract_kd	P08259	Code contract (on)bepaalde tijd
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

cost-center

• Entity Name: cost-center
• Core Table: DPIB004
• Internal Table: TBL_CostCenter

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar		kstpl_nm	—	—
CostCenterBK	varchar(7)	PK, BK	kstpl_kd	P01128	Kostenplaats inzet
CostCenterStatus	varchar(1)		index_ind	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

cost-type

• Entity Name: cost-type
• Core Table: DPIC353
• Internal Table: TBL_CostType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Type	varchar(25)		kstsrt_oms	—	—
CostTypeBK	varchar(7)	PK, BK	kstsrt_kd	P01127	Kostensoort inzet
CostTypeStatus	varchar(1)		index_ind	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

cost-unit

• Entity Name: cost-unit
• Core Table: DPIC352
• Internal Table: TBL_CostUnit

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		kstdrg_oms	—	—
CostUnitBK	varchar(7)	PK, BK	kstdrg_kd	P01129	Kostendrager inzet
CostUnitStatus	varchar(1)		index_ind	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

custom-fields

• Entity Name: custom-fields
• Core Table: DPIA032
• Internal Table: BO4_CustomFields

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ElementCode	varchar(10)	PK	rubriek_kd	—	—
EntityBK	varchar(50)	PK, BK	object_id	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
Value	varchar(200)		waarde	P00001	Gewerkte uren

data-type

• Entity Name: data-type
• Core Table: DPIA012
• Internal Table: BO4_DataType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(30)		gegsrt_oms	—	—
DataTypeBK	varchar(5)	BK	gegsrt_id	—	—
Timestamp	datetime2(2)		—	—	—

diploma-status

• Entity Name: diploma-status
• Core Table: DPIE307
• Internal Table: BO4_DiplomaStatus

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
StatusDiploma	varchar(25)		stat_oms	—	—
StatusDiplomaCode	varchar(3)		dipl_stat	P02049	Status diploma
Timestamp	datetime2(2)		—	—	—

education

• Entity Name: education
• Core Table: DPIE303
• Internal Table: TBL_Education

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
EducationBK	varchar(10)	BK	opleiding	P02044	Opleiding
EducationDesc	varchar(50)		opl_oms	—	—
EducationNote	varchar(max)		opl_toel	—	—
EducationTypeBK	varchar(10)	BK	opl_type	—	—
InstituteBK	varchar(10)	BK	opl_inst	P02050	Opleidingsinstituut
Timestamp	datetime2(2)		—	—	—

education-step-progress

• Entity Name: education-step-progress
• Core Table: DPIE310
• Internal Table: BO4_EducationStepProgress

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Progress	varchar(25)		voortg_oms	—	—
ProgressCode	varchar(3)		voortgang	P02053	Voortgang opleidingsstap
Timestamp	datetime2(2)		—	—	—

education-step-status

• Entity Name: education-step-status
• Core Table: DPIE309
• Internal Table: BO4_EducationStepStatus

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
StatusCodeEducationstep	varchar(3)		opl_stat	P02047	Status opleiding
StatusEducationstep	varchar(25)		stat_oms	—	—
Timestamp	datetime2(2)		—	—	—

education-type

• Entity Name: education-type
• Core Table: DPIE305
• Internal Table: BO4_EducationType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
EducationTypeBK	varchar(10)	BK	opl_type	—	—
EducationTypeDesc	varchar(25)		type_oms	—	—
Timestamp	datetime2(2)		—	—	—

element

• Entity Name: element
• Core Table: DPIA028
• Internal Table: BO4_Element

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Classified	varchar(1)		ingedeeld	—	—
DataType	varchar(2)		gegsrt_id	—	—
Description	varchar(20)		prompt	—	Rubriek
ElementCode	varchar(6)	PK	rubriek_kd	—	—
ElementDescription	varchar(100)		rubr_oms	—	—
FieldName	varchar(16)		veld_nm	—	—
Id	int		—	—	—
Length	int		lengte	—	—
NumberOfDecimals	varchar(1)		aant_dec	—	—
ReferenceTable	varchar(7)		reftab_nm	—	—
RetentionPeriod	varchar(3)		bewaarterm	—	—
Timestamp	datetime2(2)		—	—	—
Type	varchar(1)		type_kd	—	—

element-value

• Entity Name: element-value
• Core Table: DPIA029
• Internal Table: BO4_ElementValue

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ElementCode	varchar(6)	PK	rubriek_kd	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
ValueCode	varchar(50)	PK	waarde	P00001	Gewerkte uren
ValueDesc	varchar(100)		waarde_oms	—	—

employee-group

• Entity Name: employee-group
• Core Table: DPIC350
• Internal Table: BO4_EmployeeGroup

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Employee_Group	varchar(25)		doelgrp_oms	—	—
EmployeeGroup_BK	varchar(3)	PK, BK	doelgrp_kd	P01110	Code doelgroep
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

employer-code

• Entity Name: employer-code
• Core Table: —
• Internal Table: TBL_EmployerCode

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AcwLevel	varchar(10)		—	—	—
Code	int		—	—	—
CodeDescription	varchar(250)		—	—	—
CodeExpirationPeriod	int		—	—	—
CodeGroup	tinyint		—	—	—
CodeType	varchar(1)		—	—	—
CodeValueDescription	varchar(250)		—	—	—
EndPeriod	int		—	—	—
FinancialGroupBK	varchar(30)	BK	—	—	—
Id	int		—	—	—
PayrollInstitutionBK	varchar(30)	BK	—	—	—
RunId	int		—	—	—
StartPeriod	int		—	—	—
Subnumber	int		—	—	—
Timestamp	datetime2(2)		—	—	—
ValueDate	date		—	—	—
ValueDecimal	decimal(20,4)		—	—	—
ValueInt	int		—	—	—
ValueString	varchar(250)		—	—	—

employment-relationship

• Entity Name: employment-relationship
• Core Table: DPIC053
• Internal Table: BO4_EmploymentRelationship

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Relationship	varchar(25)		aard_arbeid_oms	—	—
EmploymentRelationshipBK	varchar(2)	PK, BK	aard_arbeid_kd	P02268	Code aard arbeidsverhouding
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

employment-type

• Entity Name: employment-type
• Core Table: DPIC355
• Internal Table: TBL_EmploymentType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(50)		arelsrt_oms	—	—
EmploymentTypeBK	varchar(30)	PK, BK	arelsrt_kd	P01102	Soort arbeidsrelatie
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
ToPayroll	bit		ind_salverw	—	—

enrollment-status

• Entity Name: enrollment-status
• Core Table: DPIE308
• Internal Table: BO4_EnrollmentStatus

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
EnrollmentStatusName	varchar(25)		stat_oms	—	—
EnrollmentStatusCode	varchar(3)		insch_stat	P02048	Status inschrijving opleiding
Timestamp	datetime2(2)		—	—	—

financial-group

• Entity Name: financial-group
• Core Table: DPIC200
• Internal Table: TBL_FinancialGroup

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
FinancialGroupBK	varchar(30)	PK, BK	opdrgvr_nr	S00900	Opdrachtgever nummer
FinancialGroupName	varchar(50)		opdrgvr_oms	S00901	Opdrachtgever omschrijving
Id	int		—	—	—
Periodicity	varchar(30)		verln_per_kd	S03007	Code verloningsperiodiciteit
Timestamp	datetime2(2)		—	—	—

function

• Entity Name: function
• Core Table: DPIC351
• Internal Table: TBL_Function

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CostTypeBK	varchar(7)	BK	kstsrt_kd	P02303	Code kostensoort
CostUnitBK	varchar(7)	BK	kstdrg_kd	P02304	Code kostendrager
Name	varchar(50)		func_oms	P02302	Omschrijving functie
FunctionBK	varchar(10)	PK, BK	func_kd	P02301	Code functie
FunctionCategory_BK	varchar(3)	BK	funcat_kd	—	—
FunctionDescription	varchar(max)		func_bschr	—	—
FunctionGroupBK	varchar(3)	BK	fnctgrp_kd	P02305	Code functiegroep
FunctionPaymentTypeBK	varchar(3)	BK	funver_kd	P02306	Code soort verloning
FunctionStandardBK	varchar(7)	BK	stanf_kd	P02308	Code standaardfunctie
FunctionStatusBK	varchar(3)	BK	statfunc_kd	P02311	Code status functie
FunctionTypeBK	varchar(3)	BK	funtyp_kd	P02309	Code functietype
Id	int		—	—	—
InactiveFunction	varchar(1)		index_ind	—	—
Timestamp	datetime2(2)		—	—	—

function-area

• Entity Name: function-area
• Core Table: DPIF058
• Internal Table: BO4_FunctionArea

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		oms	P02028	Standaardfunctie
FunctionAreaBK	varchar(3)	BK	fungeb_kd	—	—
Timestamp	datetime2(2)		—	—	—

function-category

• Entity Name: function-category
• Core Table: DPIC349
• Internal Table: BO4_FunctionCategory

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		oms	P02028	Standaardfunctie
FunctionCategoryBK	varchar(3)	PK, BK	funcat_kd	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

function-group

• Entity Name: function-group
• Core Table: DPIC369
• Internal Table: BO4_FunctionGroup

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		fnctgrp_oms	—	—
FunctionGroup_BK	varchar(3)	PK, BK	fnctgrp_kd	P02305	Code functiegroep
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

function-level

• Entity Name: function-level
• Core Table: DPIF059
• Internal Table: BO4_FunctionLevel

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		oms	P02028	Standaardfunctie
FunctionLevelBK	varchar(3)	BK	funniv_kd	—	—
Timestamp	datetime2(2)		—	—	—

function-payment-type

• Entity Name: function-payment-type
• Core Table: DPIF060
• Internal Table: BO4_FunctionPaymentType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
FunctionPayment_Type	varchar(25)		oms	P02028	Standaardfunctie
FunctionPaymentType_BK	varchar(3)	PK, BK	funver_kd	P02306	Code soort verloning
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

function-profession

• Entity Name: function-profession
• Core Table: DPID132
• Internal Table: BO4_FunctionProfession

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Function_Profession	varchar(25)		beroep_oms	—	—
FunctionProfession_BK	varchar(10)	PK, BK	beroep	P00311	Functie/Beroep
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

function-standard

• Entity Name: function-standard
• Core Table: DPIF008
• Internal Table: BO4_FunctionStandard

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
FunctionArea_BK	varchar(3)	BK	fungeb_kd	—	—
FunctionLevel_BK	varchar(3)	BK	funniv_kd	—	—
Function_Standard	varchar(50)		oms	P02028	Standaardfunctie
FunctionStandard_BK	varchar(7)	PK, BK	stanf_kd	P02308	Code standaardfunctie
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

function-status

• Entity Name: function-status
• Core Table: DPIC374
• Internal Table: BO4_FunctionStatus

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Function_Status	varchar(25)		statfunc_oms	—	Status Functie
FunctionStatus_BK	varchar(3)	PK, BK	statfunc_kd	P02311	Code status functie
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

function-type

• Entity Name: function-type
• Core Table: DPIA046
• Internal Table: BO4_FunctionType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		oms	P02028	Standaardfunctie
FunctionTypeBK	varchar(3)	PK, BK	funtyp_kd	P02309	Code functietype
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

history

• Entity Name: history
• Core Table: DPIA037
• Internal Table: BO4_History

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Dpia037	int	PK	dpia037_sl	—	—
ElementCode	varchar		rubriek_kd	—	—
EndDate	datetime		einde_dt	—	—
Id	int		—	—	—
Logon_ID	int	PK	logon_id	—	—
Object_id	varchar		—	—	—
StartDate	datetime		ingangs_dt	—	—
Timestamp	datetime2(2)		—	—	—
Value	varchar		waarde	P00001	Gewerkte uren
ValueDesc	varchar		oms	P02028	Standaardfunctie

indication-1

• Entity Name: indication-1
• Core Table: DPIF021
• Internal Table: BO4_Indication1

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode1	varchar(50)		fp_code1_oms	—	—
IndicationCode1BK	varchar(5)	PK, BK	fp_code1_ind	P01911	Formatieplaats code ind. 1
Timestamp	datetime2(2)		—	—	—

indication-10

• Entity Name: indication-10
• Core Table: DPIF030
• Internal Table: BO4_Indication10

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode10	varchar(50)		fp_code10_oms	—	—
IndicationCode10BK	varchar(5)	PK, BK	fp_code10_ind	P01920	Formatieplaats code ind. 10
Timestamp	datetime2(2)		—	—	—

indication-2

• Entity Name: indication-2
• Core Table: DPIF022
• Internal Table: BO4_Indication2

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode2	varchar(50)		fp_code2_oms	—	—
IndicationCode2BK	varchar(5)	PK, BK	fp_code2_ind	P01912	Formatieplaats code ind. 2
Timestamp	datetime2(2)		—	—	—

indication-3

• Entity Name: indication-3
• Core Table: DPIF023
• Internal Table: BO4_Indication3

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode3	varchar(50)		fp_code3_oms	—	—
IndicationCode3BK	varchar(5)	PK, BK	fp_code3_ind	P01913	Formatieplaats code ind. 3
Timestamp	datetime2(2)		—	—	—

indication-4

• Entity Name: indication-4
• Core Table: DPIF024
• Internal Table: BO4_Indication4

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode4	varchar(50)		fp_code4_oms	—	—
IndicationCode4BK	varchar(5)	PK, BK	fp_code4_ind	P01914	Formatieplaats code ind. 4
Timestamp	datetime2(2)		—	—	—

indication-5

• Entity Name: indication-5
• Core Table: DPIF025
• Internal Table: BO4_Indication5

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode5	varchar(50)		fp_code5_oms	—	—
IndicationCode5BK	varchar(5)	PK, BK	fp_code5_ind	P01915	Formatieplaats code ind. 5
Timestamp	datetime2(2)		—	—	—

indication-6

• Entity Name: indication-6
• Core Table: DPIF026
• Internal Table: BO4_Indication6

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode6	varchar(50)		fp_code6_oms	—	—
IndicationCode6BK	varchar(5)	PK, BK	fp_code6_ind	P01916	Formatieplaats code ind. 6
Timestamp	datetime2(2)		—	—	—

indication-7

• Entity Name: indication-7
• Core Table: DPIF027
• Internal Table: BO4_Indication7

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode7	varchar(50)		fp_code7_oms	—	—
IndicationCode7BK	varchar(5)	PK, BK	fp_code7_ind	P01917	Formatieplaats code ind. 7
Timestamp	datetime2(2)		—	—	—

indication-8

• Entity Name: indication-8
• Core Table: DPIF028
• Internal Table: BO4_Indication8

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode8	varchar(50)		fp_code8_oms	—	—
IndicationCode8BK	varchar(5)	PK, BK	fp_code8_ind	P01918	Formatieplaats code ind. 8
Timestamp	datetime2(2)		—	—	—

indication-9

• Entity Name: indication-9
• Core Table: DPIF029
• Internal Table: BO4_Indication9

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationCode9	varchar(50)		fp_code9_oms	—	—
IndicationCode9BK	varchar(5)	PK, BK	fp_code9_ind	P01919	Formatieplaats code ind. 9
Timestamp	datetime2(2)		—	—	—

indirect-mutations

• Entity Name: indirect-mutations
• Core Table: DPIA101
• Internal Table: TBL_IndirectMutations

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
BlockedDate	date		blokkeer_dt	—	—
CalculationPeriod	varchar(6)		verreken_per	—	—
ChangeVersion	bigint		—	—	—
ContractBK	varchar(50)	BK	—	—	—
CreationId	varchar(16)		creatie_id	—	—
CreationDate	date		creatie_dt	—	—
DataTypeBK	varchar(5)	BK	—	—	—
DeclineDate	date		afkeur_dt	—	—
DeliveryProcessCode	varchar(3)		proces_kd	—	—
Dpia101	int		—	—	—
ElementCode	varchar(6)		rubriek_kd	—	—
IndBlocked	varchar(1)		blokkeer_ind	—	—
IndDeclined	varchar(1)		afkeur_ind	—	—
IndirectMutationBK	varchar(50)	BK	object_id	—	—
IndNew	varchar(1)		nieuw_ind	—	—
IndProcessed	varchar(1)		verwerk_ind	—	—
IndStamVariable	varchar(1)		stam_var	—	—
LogonId	bigint		—	—	—
PersonBK	varchar(50)	BK	combi_go	—	—
ProductionPeriod	varchar(6)		prod_per	—	—
ProductionType	varchar(3)		prod_srt	—	—
StartDate	date		ingangs_dt	—	—
Timestamp	datetime2(2)		—	—	—
Value	varchar(100)		waarde	—	—

institute

• Entity Name: institute
• Core Table: DPIE304
• Internal Table: BO4_Institute

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Name	varchar(25)		inst_oms	—	Opleidingsinstituut
InstituteCode	varchar(10)		opl_inst	P02050	Opleidingsinstituut
Timestamp	datetime2(2)		—	—	—

journal-entry-employee

• Entity Name: journal-entry-employee
• Core Table: DPIL009
• Internal Table: TBL_Journal_Entry_Employee

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Amount	numeric(13,2)		pkb_bedrag	—	—
ContraAccount	varchar(7)		jp_reknr	S34009	Tegenrekeningnr jp-regel
ContractNumber	int		dv_vlgnr	P01101	Volgnr dienstverband
CostCenterCode	varchar(7)		kstpl_kd	P01128	Kostenplaats inzet
CostTypeCode	varchar(7)		kstsrt_kd	P01127	Kostensoort inzet
CostUnitCode	varchar(7)		kstdrg_kd	P01129	Kostendrager inzet
FinancialGroupBK	int	BK	opdrgvr_nr	S00900	Opdrachtgever nummer
FTE	numeric(11,4)		aant_fte	—	—
Hours	numeric(11,2)		aant_uren	—	—
Id	int		—	—	—
JournalEntryBK	int	PK, BK	dpil009_sl	—	—
OriginCode	varchar(3)		herkomst_kd	—	—
PayrollInstitutionBK	int	BK	inst_nr	S02900	Instelling nummer
PersonBK	int		pers_nr	P01001	Persoonsnummer
ProductionPeriod	int		prod_periode	—	—
RegistrationNumber	int		reg_nr	P01105	Registratienr
Timestamp	datetime2(2)		—	—	—
Year	int		jaar	—	—

leave-blockade

• Entity Name: leave-blockade
• Core Table: DPID024
• Internal Table: TBL_Leave_Blockade

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDate	datetime		tm_dt	P56004	Einddatum blokkade verlofrecht
Id	int		—	—	—
LeaveBlockadeBK	varchar	BK	—	P56008	Technische sleutel verlofrecht
LeaveBlockadeNumber	numeric(10,0)	PK	dpid024_sl	P56008	Technische sleutel verlofrecht
LeaveCode	varchar(3)	PK	vrlfsrt_kd	P56007	Code verlofsoort
PercentageLeaveBlockade	numeric		vrlf_blok_perc	P56006	Percentage blokkade verlofrecht
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
ReasonBlockadeBK	varchar	BK	vrlf_blok_kd	P56005	Code reden blokkade verlofrecht
StartDate	datetime		vanaf_dt	P56003	Begindatum blokkade verlofrecht
Timestamp	datetime2(2)		—	—	—

leave-blockade-reason

• Entity Name: leave-blockade-reason
• Core Table: DPID023
• Internal Table: BO4_LeaveBlockadeReason

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
ReasonBlockade	varchar		vrlf_blok_oms	—	—
ReasonBlockadeBK	varchar(4)	PK, BK	vrlf_blok_kd	P56005	Code reden blokkade verlofrecht
Timestamp	datetime2(2)		—	—	—

leave-entitlement

• Entity Name: leave-entitlement
• Core Table: DPID014
• Internal Table: BO4_LeaveEntitlement

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AgeBasedRights	numeric(8,4)		vrlfr_lft	P01445	jr verlofrecht leeftijd uren
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
ExtraLeaveRights	numeric(8,4)		vrlfr_eu	P01451	Jr verlofrecht extra uren
FullTimeSalaryExtraRights	numeric(8,4)		vrlfr_sal	—	—
Id	int		—	—	—
LastCalculatedExtraHours	numeric(8,4)		ltst_ber_eu	P01452	Laatst berekende extra uren
LastLeaveCalculationDate	datetime		vrlfber_dt	P01441	Datum laatste verlofberekening
LeaveRightMutations	numeric(9,4)		vrlfr_mut	P01454	Jr verlofrechtmutaties uren
LeaveRightsCode1	numeric(8,4)		vrlfr_ov1	P01449	jr verlofrecht code 1 uren
LeaveRightsCode2	numeric(8,4)		vrlfr_ov2	P01450	jr verlofrecht code 2 uren
LeaveRightsCurrentYear	numeric(9,4)		vrlfr_hjr	P01443	Verlofrecht totaal dit jaar in uren
LeaveTypeBK	varchar(3)	PK, BK	vrlfsrt_kd	P01430	Code verlofsoort werknemer
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01440	Verlofjaar verlofrechten
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
SalaryScaleRights	numeric(8,4)		vrlfr_sch	P01447	jr verlofrecht sal.schalen uren
SalarySeniorityRights	numeric(8,4)		vrlfr_inp	P01448	jr verlofrecht inpastab. uren
StandardLeaveRights	numeric(8,4)		vrlfr_std	P01444	Jr verlofrecht standaard uren
TimeForTimeRights	numeric(11,4)		vrlfr_tvt	—	—
Timestamp	datetime2(2)		—	—	—
TransferredRights	numeric(11,4)		vrlfr_vjr	P01442	Verlofrecht tegoed vrgjr in uren
WorkingYearBasedRights	numeric(8,4)		vrlfr_djr	P01446	jr verlofrecht dienstjaren uren

leave-per-day

• Entity Name: leave-per-day
• Core Table: DPID016
• Internal Table: BO4_LeavePerDay

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
Hours	numeric(9,4)		vrlf_uren	P01471	Uren verlof
Id	int		—	—	—
LeaveDate	datetime	PK	vrlf_dt	P01470	Datum verlof
LeavePeriodNumber	numeric(4,0)	PK	vtvk_vlgnr	P01460	Volgnummer verloftijdvak
LeaveTypeBK	varchar(3)	PK, BK	vrlfsrt_kd	P01437	code verlofsoort
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01440	Verlofjaar verlofrechten
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

leave-period

• Entity Name: leave-period
• Core Table: DPID015
• Internal Table: BO4_LeavePeriod

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDate	datetime		vtvk_edt	P01462	Einddatum verloftijdvak
Id	int		—	—	—
LeavePeriodNumber	numeric(4,0)	PK	vtvk_vlgnr	P01460	Volgnummer verloftijdvak
LeaveReasonBK	varchar(3)	BK	vrlfrdn_kd	P01463	Code verlofreden
LeaveTypeBK	varchar(3)	PK, BK	vrlfsrt_kd	P01465	Code verlofsoort
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01466	Verlofjaar verlofrechten
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
StartDate	datetime		vtvk_bdt	P01461	Begindatum verloftijdvak
Timestamp	datetime2(2)		—	—	—

leave-policy

• Entity Name: leave-policy
• Core Table: DPID025
• Internal Table: TBL_Leave_Policy

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
BeginDateLeavePolicy	datetime	PK	begin_dt	P01491	Begindatum verlofregeling
ContractBK	varchar	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDateLeavePolicy	datetime		eind_dt	P01492	Einddatum verlofregeling
Id	int		—	—	—
LeavePolicyCode	varchar		vrlfreg_kd	P01490	Code verlofregeling
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

leave-policy-description

• Entity Name: leave-policy-description
• Core Table: DPID004
• Internal Table: BO4_LeavePolicyDescription

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
LeavePolicyCode	varchar(3)	PK	vrlfreg_kd	P01400	Code verlofregeling werknemer (Vervallen)
Description	varchar		vrlfreg_oms	—	—
Hours	numeric		vrlf_uren	P01471	Uren verlof
Timestamp	datetime2(2)		—	—	—

leave-reason

• Entity Name: leave-reason
• Core Table: DPID002
• Internal Table: BO4_LeaveReason

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Reason	varchar(25)		vrlrdn_oms	—	—
LeaveReasonBK	varchar(3)	PK, BK	vrlfrdn_kd	P01463	Code verlofreden
Timestamp	datetime2(2)		—	—	—

leave-right-mutation-reason

• Entity Name: leave-right-mutation-reason
• Core Table: DPID026
• Internal Table: BO4_LeaveRightMutationReason

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationStandard	varchar(1)		standaard_ind	—	—
Reason	varchar(25)		vrlfr_mut_oms	—	—
LeaveRightMutationReasonBK	varchar(4)	PK, BK	vrlfr_mut_kd	P56001	Code reden verlofrechtmutatie
Timestamp	datetime2(2)		—	—	—

leave-right-mutations

• Entity Name: leave-right-mutations
• Core Table: DPID027
• Internal Table: TBL_LeaveRightMutations

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
Id	int		—	—	—
LeaveRightMutationBK	bigint	PK, BK	dpid027_sl	P56011	Technische sleutel verlofrecht mutaties
LeaveRightMutationDate	date		vrlfr_mut_dt	P56000	Datum verlofrechtmutatie
LeaveRightMutationHours	decimal(9,4)		vrlfr_mut_uren	P56002	Verlofrechtmutatie in uren
LeaveRightMutationReasonBK	varchar(4)	BK	vrlfr_mut_kd	P56001	Code reden verlofrechtmutatie
LeaveTypeBK	varchar(3)	PK, BK	vrlfsrt_kd	P01437	code verlofsoort
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01440	Verlofjaar verlofrechten
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

leave-type

• Entity Name: leave-type
• Core Table: DPID001
• Internal Table: BO4_LeaveType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationBankHoliday	varchar(1)		fst_ind	—	—
IndicationCompanyLeave	varchar(1)		bv_ind	—	—
IndicationLegalLeave	varchar(1)		wet_verlof_ind	—	—
IndicationTimeForTime	varchar(1)		tvt_ind	—	—
LeaveTypeBK	varchar(4)	PK, BK	vrlfsrt_kd	P01437	code verlofsoort
LeaveTypeDesc	varchar(25)		vrlfsrt_oms	—	—
Timestamp	datetime2(2)		—	—	—

leave-type-policy

• Entity Name: leave-type-policy
• Core Table: DPID010
• Internal Table: BO4_LeaveTypePolicy

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CodeLeaveType	varchar(3)	PK	vrlfsrt_kd	P01437	code verlofsoort
Id	int		—	—	—
LeavePolicyCode	varchar(3)	PK	vrlfreg_kd	P01400	Code verlofregeling werknemer (Vervallen)
LeaveTypeRights	numeric		vrlfr_srt	—	—
PresentationUnit	varchar		pres_eenh	—	—
StartMonth	numeric		start_mnd	—	—
Timestamp	datetime2(2)		—	—	—

organisation-model

• Entity Name: organisation-model
• Core Table: DPIF001
• Internal Table: BO4_OrganisationModel

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Current	varchar(1)		actueel	—	—
EndDate	datetime2(2)		eind_dt	P01029	Einddatum adres
Id	int		—	—	—
IndStandard	varchar(1)		standaard	—	—
Model	varchar(25)		oms	P02028	Standaardfunctie
OrganisationModelBK	varchar(5)	PK, BK	om_kd	—	—
StartDate	datetime2(2)		ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

organisation-unit

• Entity Name: organisation-unit
• Core Table: DPIF002
• Internal Table: BO4_OrganisationUnit

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CostCenterBK	varchar(7)	BK	kstpl_kd	P01128	Kostenplaats inzet
CostUnitBK	varchar(7)	BK	kstdrg_kd	P01129	Kostendrager inzet
Id	int		—	—	—
IndBlocked	varchar(1)		oe_blok	—	—
OrganisationModelBK	varchar(5)	BK	om_kd	—	—
OrgModelUnit	varchar(50)		oe_vol_nm	P02032	Omschrijving Org.eenheid loopbaanstap
OrgModelUnitBK	numeric(10,0)	PK, BK	dpif002_sl	—	—
Parent	numeric(10,0)		oe_hoger_n	—	—
ShortName	varchar(10)		oe_kort_nm	P02033	Organisatorische eenheid
Timestamp	datetime2(2)		—	—	—
Type	varchar(3)		orgeenh_kd	—	—

organization-unit

• Entity Name: organization-unit
• Core Table: DPIB015
• Internal Table: TBL_OrganizationalUnit

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AuthLevel	varchar(30)		oe_autor_n	—	—
City	varchar(50)		oe_plaats	—	—
CostCenter	varchar(50)		kstpl_kd	—	—
HouseNumber	int		oe_huisnr	—	—
HouseNumberAddition	varchar(5)		oe_hnr_toev	—	—
Id	int		—	—	—
Name	varchar(50)		oe_vol_nm	P02032	Omschrijving Org.eenheid loopbaanstap
TypeCode	varchar(3)		orgeenh_kd	—	—
OU_BK	numeric(10,0)	PK, BK	dpib015_sl	P01061, P01676	Operationele org.eenheid / Technische sleutel  organisatorische eenheid
Key	int		—	—	—
Level	int		oe_autor	—	—
ShortName	varchar(10)		oe_kort_nm	P02033	Organisatorische eenheid
ParentId	varchar(30)	BK	oe_hoger_n	—	—
ParentDescription	varchar(50)		—	—	—
PhoneNumber	varchar(15)		oe_telefoon	—	—
Status	varchar(10)		oe_blok	—	—
Street	varchar(50)		oe_straat	—	—
Timestamp	datetime2(2)		—	—	—
ZipCode	varchar(30)		oe_postcode	—	—

organizational-unit-type

• Entity Name: organizational-unit-type
• Core Table: DPIB018
• Internal Table: BO4_OrganizationalUnitType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
OrganizationalUnit_Type	varchar(30)		oms	P02028	Standaardfunctie
OrganizationalUnitTypeCode	varchar(3)	PK	orgeenh_kd	—	—
Timestamp	datetime2(2)		—	—	—

payroll-amount

• Entity Name: payroll-amount
• Core Table: DPIC330
• Internal Table: BO4_PayrollAmount

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
PayrollAmountNumber	int	PK	inpas_nr	S05577	Inpassingsnr
PayrollAmountSalary	numeric(8,2)		inpas_sal	S05578	Inpas salaris
SalarySchemeBK	varchar(3)	PK, BK	reg_sal_kd	S05551	Code salarisregeling
Timestamp	datetime2(2)		—	—	—

payroll-code

• Entity Name: payroll-code
• Core Table: —
• Internal Table: TBL_PayrollCode

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(250)		—	—	—
EndDate	date		—	—	—
FinancialGroup_BK	varchar(30)	PK, BK	—	—	—
Id	int		—	—	—
PayrollCodeBK	varchar(30)	PK, BK	—	—	—
PayrollInstitutionBK	varchar(30)	PK, BK	—	—	—
StartDate	date	PK	—	—	—
Timestamp	datetime2(2)		—	—	—

payroll-codes

• Entity Name: payroll-codes
• Core Table: DPIC004
• Internal Table: BO4_PayrollCodes

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Name	varchar(17)		uitv_sttkst	S05992	Standaard tekst uitvoercode
PayrollCodeBK	int	PK, BK	uitv_kd	—	—
PayrollCodeCustomDesc	varchar(17)		uitv_afwtkst	S05999	Afwijkende tekst uitvoercode
Timestamp	datetime2(2)		—	—	—

payroll-institution

• Entity Name: payroll-institution
• Core Table: DPIC202
• Internal Table: TBL_PayrollInstitution

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CLA_BK	int	BK	cao_kd	S03002	Code CAO
FinancialGroup_BK	varchar(30)	PK, BK	opdrgvr_nr	S00900	Opdrachtgever nummer
Id	int		—	—	—
PayrollInstitutionBK	varchar(30)	PK, BK	inst_nr	S02900	Instelling nummer
PayrollInstitutionName	varchar(50)		i_naam	S02001	Instelling naam
StandardHoursPW	numeric(5,2)		uur_wk_i	S00993	Uren per week inst
Timestamp	datetime2(2)		—	—	—

payroll-mutations

• Entity Name: payroll-mutations
• Core Table: DPIC503
• Internal Table: TBL_PayrollMutations

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CalculationPeriod	varchar(6)		—	—	—
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	int		—	—	—
DeliveryNumber	int		—	—	—
DeliveryPeriod	varchar(6)		—	—	—
ElementCode	varchar(6)		—	—	—
FinancialGroupBK	int	BK	—	—	—
Id	int		—	—	—
IndCorrection	varchar(1)		—	—	—
IndDataType	varchar(3)		—	—	—
IndExtReference	varchar(1)		—	—	—
LogonID	int	PK	—	—	—
MutationDate	datetime		—	—	—
MutationStartDate	datetime		—	—	—
MutationTime	datetime		—	—	—
ObjectID	varchar(50)		—	—	—
Origination	varchar(1)		—	—	—
PayrollInstitutionBK	int	BK	—	—	—
PersonBK	int	BK	—	—	—
ProductionType	varchar(3)		—	—	—
Recalculation	varchar(1)		—	—	—
RecalculationStartPeriod	varchar(6)		—	—	—
RecordID	int	PK	—	—	—
RegistrationNumber	int		—	—	—
SalaryPeriod	varchar(6)		—	—	—
StamVariable	varchar(1)		—	—	—
Timestamp	datetime2(2)		—	—	—
UserID	varchar(16)		—	—	—
Value	varchar(50)		—	—	—

payroll-results

• Entity Name: payroll-results
• Core Table: —
• Internal Table: TBL_PayrollResults_Staging

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CalculationPeriodNumber	short		—	—	—
CalculationYear	short		—	—	—
CostAllocationBK	string	BK	—	—	—
FinancialGroupBK	string	BK	—	—	—
Id	int	PK	—	—	—
IKVNumber	int		—	—	—
PayrollCodeBK	string	BK	—	—	—
PayrollInstitutionBK	string	BK	—	—	—
PayrollResult	decimal		—	—	—
PayrollRun	long		—	—	—
RegistrationNumber	string		—	—	—
Timestamp	DateTime		—	—	—

payroll-runs

• Entity Name: payroll-runs
• Core Table: —
• Internal Table: TBL_PayrollRuns

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AfroepNr	varchar(150)		—	—	—
EmployeeCodeStatus	varchar(50)		—	—	—
EmployerCodeStatus	varchar(50)		—	—	—
FinancialGroupBK	varchar(30)	BK	—	—	—
Id	int		—	—	—
PaymentPeriod	smallint		—	—	—
PaymentYear	smallint		—	—	—
PayrollRun	bigint	PK	—	—	—
PayrollRunStatus	varchar(50)		—	—	—
runDescription	varchar(150)		—	—	—
Timestamp	datetime2(2)		—	—	—
UpdatedDate	datetime2(2)		—	—	—

person

• Entity Name: person
• Core Table: DPIB010
• Internal Table: TBL_Person

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
BirthPlace	varchar(50)		geb_plts	P01032	Geboorteplaats
CommencementDateResidentialAddress	datetime		w_ing_dt	P01012	Woonadres - ingangsdatum
CommunicationLanguage	varchar(50)		—	—	—
DateOfBirth	date		geb_dt	P00321	Geboortedatum
DateOfDeath	date		overl_dt	P01005	Overlijdensdatum
DisplayName	varchar(100)		—	—	—
EffectiveDatePostalAddress	datetime		p_ing_dt	P01011	Postadres - ingangsdatum
FirstNamePartner	varchar(25)		p_voornmn	P01006	Partner-voornaam
Gender	varchar(1)		geslacht	P00330	Geslacht
GenderPartner	varchar(1)		p_geslacht	P01033	Geslacht partner
Id	int		—	—	—
Initials	varchar(6)		e_vrlt	P00303	Voorletters
InitialsPartner	varchar(6)		p_vrlt	P00392	Partner-voorletters
KnownAs	varchar(50)		e_roepnaam	P01003	Roepnaam
LastNameAtBirth	varchar(50)		e_naam	P00301	Geboortenaam
NamePartner	varchar(50)		p_naam	P00390	Partner-naam
NationalityBK	varchar(4)	BK	nat_kd	P01004	Nationaliteit
PersonBK	varchar(30)	PK, BK	pers_nr	P01001	Persoonsnummer
PersonalEmail	varchar(100)		email_prive	P01034	E-mail adres prive
PersonalPhone1	varchar(20)		mobiel_tel_nr	P01036	Telefoonnr mobiel
PersonBSN	bigint		sofi_nr	P00320	BSN/Sofi-nummer
FirstName	varchar(70)		e_voornmn	P01002	Voornamen
LastName	varchar(70)		naam_samen	P01008	Samengestelde naam
PostalAddressAddition	varchar(50)		p_hnr_toev	P00368	Postadres - huisnummertoevoeging
PostalAddressCity	varchar(50)		p_plaats	P00308	Postadres - plaatsnaam
PostalAddressCountryCode	varchar(50)		p_land_kd	P00847	Postadres - landcode
PostalAddressHouseNumber	int		p_huisnr	P00367	Postadres - huisnummer
PostalAddressLocation	varchar(50)		p_locatie	—	—
PostalAddressPhonenumber	varchar(15)		p_tel_nr	P01026	Postadres - telefoonnummer
PostalAddressRegion	varchar(50)		p_regio	—	—
PostalAddressStreet	varchar(50)		p_straat	P00365	Postadres - straatnaam
PostalAddressZIPCode	varchar(50)		p_postcode	P00313	Postadres - postcode
PrefixLastnameAtBirth	varchar(10)		e_vrvg	P00302	Geboortenaam-voorvoegsels
PrefixLastNameToUse	varchar(10)		vrvg_samen	P01009	Samengestelde naam-voorvoegsels
PrefixPartner	varchar(10)		p_vrvg	P00391	Partner-voorvoegsels
PrimaryEmail	varchar(100)		email_werk	P01035	E-mail adres werk
PrimaryPhone	varchar(20)		werk_tel_nr	P01037	Telefoonnr werk
ResidentialAddressAddition	varchar(50)		w_hnr_toev	P01018	Woonadres - Huisnummertoevoeging
ResidentialAddressCity	varchar(50)		w_plaats	P01022	Woonadres - Plaatsnaam
ResidentialAddressCountryCode	varchar(50)		w_land_kd	P01024	Woonadres - Landcode
ResidentialAddressHouseNumber	int		w_huisnr	P01016	Woonadres - Huisnummer
ResidentialAddressLocation	varchar(50)		w_locatie	—	—
ResidentialAddressPhonenumber	varchar(15)		w_tel_nr	P01027	Woonadres - telefoonnummer
ResidentialAddressRegion	varchar(50)		w_regio	—	—
ResidentialAddressStreet	varchar(50)		w_straat	P01014	Woonadres - straatnaam
ResidentialAddressZIPCode	varchar(50)		w_postcode	P01020	Woonadres - Postcode
StartDateMaritalStatus	date		burgst_miv	P00849	Burgerlijke staat-ingangsdatum
Timestamp	datetime2(2)		—	—	—
TitlePrefix	varchar(15)		e_titul	P00305	Titulatuur voor de naam
TitleSuffix	varchar(15)		e_titul_na	P03937	Titulatuur achter de naam
UseOfLastName	varchar(1)		gbrk_naam	P00304	Gebruik achternaam
WorkEmail1	varchar(100)		—	P01035	E-mail adres werk
WorkLocation	varchar(50)		locatie	P01050	Locatie
WorkPhone1	varchar(20)		—	P01027, P01037	Woonadres - telefoonnummer / Telefoonnr werk

person-address

• Entity Name: person-address
• Core Table: DPIB005
• Internal Table: BO4_PersonAddress

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Address_BK	varchar(4)	PK, BK	land_kd	P01025	Landcode - add.adres
Country_Desc	varchar(25)		land_nm	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—

person-nationality

• Entity Name: person-nationality
• Core Table: DPIB006
• Internal Table: BO4_PersonNationality

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Nationality_BK	varchar(4)	PK, BK	nat_kd	P01004	Nationaliteit
PrimaryNationaliy	varchar(25)		nat_oms	—	—
Timestamp	datetime2(2)		—	—	—

personal-education-step

• Entity Name: personal-education-step
• Core Table: DPIE306
• Internal Table: TBL_PersonalEducationStep

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ActionEmployee	varchar(3)		aktie_pers	P02052	Actie persoon opleidingsstap
ActionEmployer	varchar(3)		aktie_org	P02051	Actie organisatie opleidingsstap
Cost	numeric(8,2)		kosten	P02054	Kosten opleidingsstap
EducationBK	varchar(10)	PK, BK	opleiding	P02044	Opleiding
Note	varchar(max)		opl_toel	—	—
Type	varchar(10)		opl_type	—	—
EmployeeContribution	numeric(8,2)		wknm_bijdr	P02056	Werknemersbijdrage opleidingsstap
EmployerContribution	numeric(8,2)		wkgv_bijdr	P02055	Werkgeversbijdrage opleidingsstap
EndDate	datetime		eind_dt	P02045	Einddatum opleidingsstap
EnrollmentStatusCode	varchar(10)		insch_stat	P02048	Status inschrijving opleiding
Id	int		—	—	—
InstituteCode	varchar(10)		opl_inst	P02050	Opleidingsinstituut
PersonBK	numeric(7,0)	PK	pers_nr	P01001	Persoonsnummer
PersonEducationBK	varchar(50)		—	—	—
PersonEducationNumber	varchar(50)	PK	vlgnr	P02042	Volgnummer opleiding
ProgressCode	varchar(3)		voortgang	P02053	Voortgang opleidingsstap
ScheduledDate	datetime		plan_dt	P02046	Geplande datum opleidingsstap
StartDate	datetime		begin_dt	P02043	Begindatum opleidingsstap
StatusCode	varchar(3)		opl_stat	P02047	Status opleiding
StatusDiplomaCode	varchar(3)		dipl_stat	P02049	Status diploma
Timestamp	datetime2(2)		—	—	—

p-k-b-column-number

• Entity Name: p-k-b-column-number
• Core Table: DPIL013
• Internal Table: BO4_PKBColumnNumber

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ColumnNumber	numeric(4,0)	PK	kolom_nr	—	—
Id	int		—	—	—
IndSalaryResult	varchar(1)		ind_sal_res	—	—
LineNumber	numeric(4,0)	PK	regel_nr	—	—
PayrollCodeBK	numeric(6,0)	BK	uitv_kd	—	—
Timestamp	datetime2(2)		—	—	—

p-k-b-results

• Entity Name: p-k-b-results
• Core Table: DPIL014
• Internal Table: BO4_PKBResults

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractNumber	numeric(4,0)		dv_vlgnr	P01101	Volgnr dienstverband
CostCenterBK	varchar(7)	BK	kstpl_kd	—	—
CostTypeBK	varchar(7)	BK	kstsrt_kd	—	—
CostUnitBK	varchar(7)	BK	kstdrg_kd	—	—
Dpil014Sl	numeric(10,0)	PK	dpil014_sl	—	—
FinancialGroupBK	numeric(6,0)	BK	opdrgvr_nr	P01103, S00900	Opdrachtgever / Opdrachtgever nummer
Id	int		—	—	—
LineNumber	numeric(4,0)		regel_nr	—	—
OriginCode	varchar(3)		herkomst_kd	—	—
PayrollInstitutionBK	numeric(5,0)	BK	inst_nr	P01104, S02900	Instelling / Instelling nummer
PersonBK	numeric(7,0)	BK	pers_nr	P01001	Persoonsnummer
PKBValue1	numeric(14,2)		pkb_waarde_1	—	—
PKBValue2	numeric(14,2)		pkb_waarde_2	—	—
PKBValue3	numeric(14,2)		pkb_waarde_3	—	—
PKBValue4	numeric(14,2)		pkb_waarde_4	—	—
PKBValue5	numeric(14,2)		pkb_waarde_5	—	—
PKBValue6	numeric(14,2)		pkb_waarde_6	—	—
PKBValue7	numeric(14,2)		pkb_waarde_7	—	—
PKBValue8	numeric(14,2)		pkb_waarde_8	—	—
PKBValue9	numeric(14,2)		pkb_waarde_9	—	—
PKBValue10	numeric(14,2)		pkb_waarde_10	—	—
PKBValue11	numeric(14,2)		pkb_waarde_11	—	—
PKBValue12	numeric(14,2)		pkb_waarde_12	—	—
PKBValue13	numeric(14,2)		pkb_waarde_13	—	—
PKBValue14	numeric(14,2)		pkb_waarde_14	—	—
PKBValue15	numeric(14,2)		pkb_waarde_15	—	—
PKBValue16	numeric(14,2)		pkb_waarde_16	—	—
PKBValue17	numeric(14,2)		pkb_waarde_17	—	—
PKBValue18	numeric(14,2)		pkb_waarde_18	—	—
PKBValue19	numeric(14,2)		pkb_waarde_19	—	—
PKBValue20	numeric(14,2)		pkb_waarde_20	—	—
PKBValue21	numeric(14,2)		pkb_waarde_21	—	—
PKBValue22	numeric(14,2)		pkb_waarde_22	—	—
PKBValue23	numeric(14,2)		pkb_waarde_23	—	—
PKBValue24	numeric(14,2)		pkb_waarde_24	—	—
PKBValue25	numeric(14,2)		pkb_waarde_25	—	—
PKBValue26	numeric(14,2)		pkb_waarde_26	—	—
PKBValue27	numeric(14,2)		pkb_waarde_27	—	—
PKBValue28	numeric(14,2)		pkb_waarde_28	—	—
PKBValue29	numeric(14,2)		pkb_waarde_29	—	—
PKBValue30	numeric(14,2)		pkb_waarde_30	—	—
PKBValue31	numeric(14,2)		pkb_waarde_31	—	—
PKBValue32	numeric(14,2)		pkb_waarde_32	—	—
PKBValue33	numeric(14,2)		pkb_waarde_33	—	—
PKBValue34	numeric(14,2)		pkb_waarde_34	—	—
PKBValue35	numeric(14,2)		pkb_waarde_35	—	—
PKBValue36	numeric(14,2)		pkb_waarde_36	—	—
PKBValue37	numeric(14,2)		pkb_waarde_37	—	—
PKBValue38	numeric(14,2)		pkb_waarde_38	—	—
PKBValue39	numeric(14,2)		pkb_waarde_39	—	—
PKBValue40	numeric(14,2)		pkb_waarde_40	—	—
PKBValue41	numeric(14,2)		pkb_waarde_41	—	—
PKBValue42	numeric(14,2)		pkb_waarde_42	—	—
PKBValue43	numeric(14,2)		pkb_waarde_43	—	—
PKBValue44	numeric(14,2)		pkb_waarde_44	—	—
PKBValue45	numeric(14,2)		pkb_waarde_45	—	—
PKBValue46	numeric(14,2)		pkb_waarde_46	—	—
PKBValue47	numeric(14,2)		pkb_waarde_47	—	—
PKBValue48	numeric(14,2)		pkb_waarde_48	—	—
PKBValue49	numeric(14,2)		pkb_waarde_49	—	—
PKBValue50	numeric(14,2)		pkb_waarde_50	—	—
PKBValue51	numeric(14,2)		pkb_waarde_51	—	—
PKBValue52	numeric(14,2)		pkb_waarde_52	—	—
PKBValue53	numeric(14,2)		pkb_waarde_53	—	—
PKBValue54	numeric(14,2)		pkb_waarde_54	—	—
PKBValue55	numeric(14,2)		pkb_waarde_55	—	—
PKBValue56	numeric(14,2)		pkb_waarde_56	—	—
PKBValue57	numeric(14,2)		pkb_waarde_57	—	—
PKBValue58	numeric(14,2)		pkb_waarde_58	—	—
PKBValue59	numeric(14,2)		pkb_waarde_59	—	—
PKBValue60	numeric(14,2)		pkb_waarde_60	—	—
PKBValue61	numeric(14,2)		pkb_waarde_61	—	—
PKBValue62	numeric(14,2)		pkb_waarde_62	—	—
PKBValue63	numeric(14,2)		pkb_waarde_63	—	—
PKBValue64	numeric(14,2)		pkb_waarde_64	—	—
PKBValue65	numeric(14,2)		pkb_waarde_65	—	—
PKBValue66	numeric(14,2)		pkb_waarde_66	—	—
PKBValue67	numeric(14,2)		pkb_waarde_67	—	—
PKBValue68	numeric(14,2)		pkb_waarde_68	—	—
PKBValue69	numeric(14,2)		pkb_waarde_69	—	—
PKBValue70	numeric(14,2)		pkb_waarde_70	—	—
PKBValue71	numeric(14,2)		pkb_waarde_71	—	—
PKBValue72	numeric(14,2)		pkb_waarde_72	—	—
PKBValue73	numeric(14,2)		pkb_waarde_73	—	—
PKBValue74	numeric(14,2)		pkb_waarde_74	—	—
PKBValue75	numeric(14,2)		pkb_waarde_75	—	—
PKBValue76	numeric(14,2)		pkb_waarde_76	—	—
PKBValue77	numeric(14,2)		pkb_waarde_77	—	—
PKBValue78	numeric(14,2)		pkb_waarde_78	—	—
PKBValue79	numeric(14,2)		pkb_waarde_79	—	—
PKBValue80	numeric(14,2)		pkb_waarde_80	—	—
PKBValue81	numeric(14,2)		pkb_waarde_81	—	—
PKBValue82	numeric(14,2)		pkb_waarde_82	—	—
PKBValue83	numeric(14,2)		pkb_waarde_83	—	—
PKBValue84	numeric(14,2)		pkb_waarde_84	—	—
PKBValue85	numeric(14,2)		pkb_waarde_85	—	—
PKBValue86	numeric(14,2)		pkb_waarde_86	—	—
PKBValue87	numeric(14,2)		pkb_waarde_87	—	—
PKBValue88	numeric(14,2)		pkb_waarde_88	—	—
PKBValue89	numeric(14,2)		pkb_waarde_89	—	—
PKBValue90	numeric(14,2)		pkb_waarde_90	—	—
PKBValue91	numeric(14,2)		pkb_waarde_91	—	—
PKBValue92	numeric(14,2)		pkb_waarde_92	—	—
PKBValue93	numeric(14,2)		pkb_waarde_93	—	—
PKBValue94	numeric(14,2)		pkb_waarde_94	—	—
PKBValue95	numeric(14,2)		pkb_waarde_95	—	—
PKBValue96	numeric(14,2)		pkb_waarde_96	—	—
PKBValue97	numeric(14,2)		pkb_waarde_97	—	—
PKBValue98	numeric(14,2)		pkb_waarde_98	—	—
PKBValue99	numeric(14,2)		pkb_waarde_99	—	—
PKBValue100	numeric(14,2)		pkb_waarde_100	—	—
ProductionPeriod	numeric(3,0)		prod_periode	—	—
RegistrationNumber	numeric(7,0)		reg_nr	P01105	Registratienr
SalaryPeriod	numeric(3,0)		sal_periode	—	—
Timestamp	datetime2(2)		—	—	—
Year	numeric(5,0)		jaar	—	—

position

• Entity Name: position
• Core Table: DPIF003
• Internal Table: BO4_Position

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CostCenterBK	varchar(7)	BK	kstpl_kd	P01128	Kostenplaats inzet
CostTypeBK	varchar(7)	BK	kstsrt_kd	P01127	Kostensoort inzet
CostUnitBK	varchar(7)	BK	kstdrg_kd	P01129	Kostendrager inzet
EndDate	datetime2(2)		eind_dt	P01029	Einddatum adres
EndReasonBK	varchar(3)	BK	redeind_kd	—	—
FunctionBK	varchar(10)	BK	func_kd	P02301	Code functie
Id	int		—	—	—
IndFormalised	varchar(1)		ind_formatie	P02310	Indicator formatiefunctie
IndicationCode1BK	varchar(5)	BK	fp_code1_ind	P01911	Formatieplaats code ind. 1
IndicationCode2BK	varchar(5)	BK	fp_code2_ind	P01912	Formatieplaats code ind. 2
IndicationCode3BK	varchar(5)	BK	fp_code3_ind	P01913	Formatieplaats code ind. 3
IndicationCode4BK	varchar(5)	BK	fp_code4_ind	P01914	Formatieplaats code ind. 4
IndicationCode5BK	varchar(5)	BK	fp_code5_ind	P01915	Formatieplaats code ind. 5
IndicationCode6BK	varchar(5)	BK	fp_code6_ind	P01916	Formatieplaats code ind. 6
IndicationCode7BK	varchar(5)	BK	fp_code7_ind	P01917	Formatieplaats code ind. 7
IndicationCode8BK	varchar(5)	BK	fp_code8_ind	P01918	Formatieplaats code ind. 8
IndicationCode9BK	varchar(5)	BK	fp_code9_ind	P01919	Formatieplaats code ind. 9
IndicationCode10BK	varchar(5)	BK	fp_code10_ind	P01920	Formatieplaats code ind. 10
OrganisationModelBK	varchar(5)	BK	om_kd	—	—
OrgModelUnitBK	numeric(10,0)	BK	dpif002_sl	—	—
PositionBK	numeric(10,0)	PK, BK	dpif003_sl	P01903	Formatieplaatstoewijzing
PositionInfoBK	varchar(512)	BK	toel	—	—
PositionReference	varchar(10)		referentie	—	—
PositionTypeBK	varchar(3)	BK	fplsrt_kd	—	—
StartDate	datetime2(2)		ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

position-allocation

• Entity Name: position-allocation
• Core Table: DPIF006
• Internal Table: BO4_PositionAllocation

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(7,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDate	datetime		eind_dt	P01909	Einddatum formatieplaats
EndReasonBK	varchar(3)	BK	eind_toew_kd	P01910	Reden einde toewijzing
FTE	numeric(6,4)		aan_fte	P01905	Aantal full time equivalenten
Hours	numeric(7,4)		aan_uren	—	—
Id	int		—	—	—
Info	varchar(max)		toel	—	—
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
PositionBK	numeric(10,0)	PK, BK	dpif003_sl	P01903	Formatieplaatstoewijzing
ReasonBK	varchar(3)	BK	red_toew_kd	P01906	Reden toewijzing
StartDate	datetime	PK	ingang_dt	P01908	Ingangsdatum formatieplaats
Status	varchar(3)		stattoe_kd	P01907	Status toewijzing
Timestamp	datetime2(2)		—	—	—

position-detail

• Entity Name: position-detail
• Core Table: DPIF013
• Internal Table: BO4_PositionDetail

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
BlockSizeFTE	numeric(11,4)		aan_fte_blok_vac	—	—
BlockSizeHours	numeric(11,4)		aan_uren_blok_vac	—	—
EndDate	datetime		eind_dt	P01029	Einddatum adres
Id	int		—	—	—
PositionBK	numeric(10,0)	PK, BK	dpif003_sl	P01903	Formatieplaatstoewijzing
RestSizeFTE	numeric(11,4)		aan_fte_rest_vac	—	—
RestSizeHours	numeric(11,4)		aan_uren_rest_vac	—	—
Seats	numeric(6,0)		aan_stoel	—	—
SizeFTE	numeric(11,4)		aan_fte	P01905	Aantal full time equivalenten
SizeHours	numeric(11,4)		aan_uren	—	—
StartDate	datetime	PK	ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

position-type

• Entity Name: position-type
• Core Table: DPIF056
• Internal Table: BO4_PositionType

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Type	varchar(25)		oms	P02028	Standaardfunctie
PositionTypeBK	varchar(3)	PK, BK	fplsrt_kd	—	—
Timestamp	datetime2(2)		—	—	—

reason-for-leaving-pension-fund

• Entity Name: reason-for-leaving-pension-fund
• Core Table: DPIC360
• Internal Table: BO4_ReasonForLeavingPensionFund

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
ReasonForLeaving_PensionFund	varchar(25)		uit_pf_oms	—	—
ReasonForLeavingPensionFund_BK	varchar(3)	PK, BK	uit_pf_kd	P01183	Reden uittreden ABP (Vervallen)
Timestamp	datetime2(2)		—	—	—

reason-out-of-service

• Entity Name: reason-out-of-service
• Core Table: DPIC354
• Internal Table: BO4_ReasonOutOfService

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Reason	varchar(100)		redv_oms	—	—
ReasonOutOfServiceBK	varchar(50)	PK, BK	redv_kd	P01113	Reden einde dv
Timestamp	datetime2(2)		—	—	—

role-assignment

• Entity Name: role-assignment
• Core Table: DPIB025
• Internal Table: BO4_RoleAssignment

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AssignmentDescription	varchar(50)		toewijzing_oms	P01065	Omschrijving roltoewijzing
EndDate	datetime		eind_dt	P01064	Einddatum roltoewijzing
Id	int		—	—	—
OU_BK	numeric(10,0)	PK, BK	dpib015_sl	P01061	Operationele org.eenheid
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
RoleDescriptionBK	varchar(5)	PK, BK	rol_oe_kd	P01062	Rol
StartDate	datetime	PK	ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

role-description

• Entity Name: role-description
• Core Table: DPIB009
• Internal Table: BO4_RoleDescription

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Description	varchar(25)		rol_oe_oms	—	Roltoewijzing
RoleDescriptionBK	varchar(5)	BK	rol_oe_kd	P01062	Rol
Timestamp	datetime2(2)		—	—	—

safety-net-case

• Entity Name: safety-net-case
• Core Table: DPID146
• Internal Table: BO4_SafetyNetCase

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(50)		vangnet_oms	—	—
SafetynetBK	varchar(30)	BK	vangnet_kd	P01645	Soort vangnetgeval
Timestamp	datetime2(2)		—	—	—

salary-distribution

• Entity Name: salary-distribution
• Core Table: DPIC320
• Internal Table: TBL_SalaryDistribution

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
CostCenter_BK	varchar(7)	BK	kstpl_kd	P01134	Kostenplaats loonverdeling
CostType_BK	varchar(7)	BK	kstsrt_kd	P01133	Kostensoort loonverdeling
CostUnit_BK	varchar(7)	BK	kstdrg_kd	P01135	Kostendrager loonverdeling
Id	int		—	—	—
PercentageSalaryDistribution	numeric(6,2)		lv_perc	P01132	Percentage loonverdeling
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
SalaryDistributionNumber	numeric(4,0)	PK	lv_rglnr	P01131	Regelnr loonverdeling
Timestamp	datetime2(2)		—	—	—

salary-scale

• Entity Name: salary-scale
• Core Table: DPIC333
• Internal Table: BO4_SalaryScale

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationYouthScaleActive	varchar(1)		jgds_ss_ind	S50210	Ind jeugdschaal actief salarisschaal
SalaryScaleBK	varchar(4)	PK, BK	schaal	S05571	Schaal
SalarySchemeBK	varchar(3)	PK, BK	reg_sal_kd	S05551	Code salarisregeling
ScaleDesc	varchar(25)		schaal_oms	S05572	Oms salarisschaal
SortingScale	varchar(4)		schaal_sort	—	—
Timestamp	datetime2(2)		—	—	—
TransitionScale	varchar(4)		overgangschaal	S05569	Overgangsschaal
TransitionSeniority	int		overgangsanc	S05570	Overgangsancienniteit

salary-scheme

• Entity Name: salary-scheme
• Core Table: DPIC043
• Internal Table: BO4_SalaryScheme

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
SchemeSalary	varchar(25)		reg_sal_oms	S05552	Oms salarisregeling
SalarySchemeBK	varchar(3)	PK, BK	reg_sal_kd	S05551	Code salarisregeling
Timestamp	datetime2(2)		—	—	—

scale-seniority

• Entity Name: scale-seniority
• Core Table: DPIC334
• Internal Table: BO4_ScaleSeniority

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
PayrollAmountNumber	int		inpas_nr	S05576	Inpassingsnummer
SalaryScaleBK	varchar(4)	PK, BK	schaal	P01151	Schaal salaris
SalarySchemeBK	varchar(3)	PK, BK	reg_sal_kd	S05551	Code salarisregeling
SeniorityBK	int	PK, BK	ancien	S05575	Ancienniteit
SeniorityDesc	varchar(5)		ancien_pres	—	—
Timestamp	datetime2(2)		—	—	—
YouthfullMonths	int		lft_jgd_mnd	S50221	Leeftijd maanden jeugdschaal
YouthfullYears	int		lft_jgd_jr	S50220	Leeftijd jaren jeugdschaal

sickness

• Entity Name: sickness
• Core Table: —
• Internal Table: FACT_TBL_Sickness

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Age	int		—	—	—
ContractStartdt_bk	long	PK, BK	—	—	—
Date_ID	int	PK	—	—	—
EndDatePeriod	DateTime		—	—	—
EndOfSicknessCase	int		—	—	—
FTE	decimal		—	—	—
Id	int		—	—	—
PercentageSick	decimal		—	—	—
SicknessCase_BK	string	PK, BK	—	—	—
SicknessCaseDetail_BK	string	PK, BK	—	—	—
SicknessCaseDurationMax365	int		—	—	—
SicknessDays	decimal		—	—	—
SicknessDaysWeighted	decimal		—	—	—
SicknessDaysWeightedFirstYear	decimal		—	—	—
SicknessDaysWeightedSecondYear	decimal		—	—	—
SicknessDaysWeightedThirdYear	decimal		—	—	—
SicknessDuration	int		—	—	—
SicknessDurationCategory	string		—	—	—
SicknessDurationYearCategory	string		—	—	—
StartDatePeriod	DateTime	PK	—	—	—
StartOfNewSicknessCase	int		—	—	—
Timestamp	DateTime		—	—	—

sickness-case

• Entity Name: sickness-case
• Core Table: DPID110
• Internal Table: TBL_SicknessCase

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
DateBegin	date		ao_dag_dt	P01600	Datum eerste ao-dag
DateEnd	date		herst_dt	P01606	Datum herstel
Dpid110	varchar(50)	PK	dpid110_sl	P01615	Technische sleutel ziektegeval
EndDateWagePayment	date		lnbet_eind_dt	—	—
ExpectedRecovery	date		verw_h_dt	P01605	Datum verwacht herstel
Id	int		—	—	—
PregnancyIndicator	varchar(2)		zwvrlf_ind	P01613	Indicatie zwangerschapsverlof
SafetynetIndicator	bit		vangnet_ind	P01646	Vangnetgeval indicatie
NewSicknessCase	int		doorl_ind	P01608	ind nieuw/doorl. ziektegeval UWV
PersonBK	int	PK, BK	pers_nr	P01001	Persoonsnummer
ReasonUWVBenefitBK	varchar	BK	uwv_uitk_rdn_kd	P01618	Code vangnet Ziektewet
RecoveryNotificationDate	date		beterm_dt	P01607	Datum betermelding
SafetynetBK	varchar(4)	BK	vangnet_kd	P01645	Soort vangnetgeval
NotificationDate	datetime2		zkmeld_dt	P01603	Datum ziekmelding
NotificationTime	datetime		zkmeld_tijd	P01604	Tijdstip ziekmelding
SicknessCaseBK	varchar(30)	BK	object_id	—	—
CodeAbsenceBK	varchar(30)	BK	zktvrzm_kd	P01609	Code ziekteverzuim
DossierDateBegin	datetime		eerste_ao_dag_dt	P01616	Datum eerste ao-dag van reeks van ziektegevallen
DossierDateEnd	datetime		—	—	—
ReasonBK	varchar(30)	BK	rdn_zk	P01610	Reden ziek
TimeOfDisability	datetime		ao_tijdst	P01601	Tijdstip arbeidsongeschikt
Timestamp	datetime2(2)		—	—	—
TypeControlZWBK	varchar	BK	cntrzw_srt	P01611	Soort controle ZW
WorkedHoursFirstRecoveryDay	decimal(5,2)		ao_gewuren	P01602	Gewerkte uren eerste ao-dag
WVPDate	date		wvp_ao_dt	P01617	WVP eerste AO-dag

sickness-case-detail

• Entity Name: sickness-case-detail
• Core Table: DPID111
• Internal Table: TBL_SicknessCaseDetail

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
DateBegin	date		ztvk_vanaf	P01640	Ziektetijdvak vanaf
DateEnd	date		ztvk_tot	P01641	ziektetijdvak tot
Dpid110Sl	varchar(50)	PK	dpid110_sl	P01615	Technische sleutel ziektegeval
Dpid111Sl	varchar(50)	PK	dpid111_sl	P01644	Technische sleutel ziektetijdvak
Id	int		—	—	—
LastMutationDate	date		mut_dt	—	—
PercentageSick	numeric(6,4)		perc_ziek	P01642	Percentage ziek
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
SicknessCaseDetailBK	varchar(50)	BK	object_id	P01644	Technische sleutel ziektetijdvak
Timestamp	datetime2(2)		—	—	—

sickness-code-absence

• Entity Name: sickness-code-absence
• Core Table: DPID130
• Internal Table: BO4_SicknessCodeAbsence

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(30)		zktvrzm_oms	—	—
Id	int		—	—	—
SicknessCodeAbsenceBK	varchar(30)	PK, BK	zktvrzm_kd	P01609	Code ziekteverzuim
Timestamp	datetime2(2)		—	—	—

sickness-reason

• Entity Name: sickness-reason
• Core Table: DPID133
• Internal Table: BO4_SicknessReason

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(30)		rdn_zk_oms	—	—
Id	int		—	—	—
SicknessReason_BK	varchar(30)	PK, BK	rdn_zk	P01610	Reden ziek
Timestamp	datetime2(2)		—	—	—

system-mutations

• Entity Name: system-mutations
• Core Table: DPIA098
• Internal Table: TBL_SystemMutations

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Action	varchar(1)		—	—	—
ContractBK	varchar(30)	BK	—	—	—
DataType	varchar(2)		—	—	—
Description	varchar(20)		—	—	—
ElementCode	varchar(6)		—	—	—
ElementType	varchar(3)		—	—	—
FunctionIdentification	numeric(7,0)		—	—	—
Id	int		—	—	—
IndRestrospective	varchar(1)		—	—	—
IndStamVar	varchar(1)		—	—	—
LogDate	datetime		—	—	—
LogNr	numeric(10,0)	PK	—	—	—
LogonID	numeric(10,0)	PK	—	—	—
LogTime	datetime		—	—	—
PersonBK	varchar(30)	BK	—	—	—
ProductionType	varchar(3)		—	—	—
RetroPeriod	varchar(6)		—	—	—
RetroPeriodStart	varchar(6)		—	—	—
SalaryPeriod	varchar(50)		—	—	—
StartDate	datetime		—	—	—
SystemMutationBK	varchar(50)	BK	—	—	—
Timestamp	datetime2(2)		—	—	—
TransactionNr	numeric(10,0)		—	—	—
UserID	varchar(16)		—	—	—
ValueNew	varchar(50)		—	—	—
ValueNewDescription	varchar(50)		—	—	—
ValueOld	varchar(50)		—	—	—
ValueOldDescription	varchar(50)		—	—	—

time-registration

• Entity Name: time-registration
• Core Table: DPIN150
• Internal Table: TBL_TimeRegistration

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ActivityCode	varchar(3)		act_kd	—	—
ActivityStatus	varchar(1)		act_status	—	—
CalculationPeriod	varchar(6)		ber_periode	—	—
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)		dv_vlgnr	P01101	Volgnr dienstverband
CostUnitCode	varchar(7)		kstdrg_kd	—	—
DateActivity	datetime		tr_dt	—	—
DurationActivity	decimal(4,2)		—	—	—
EndtimeActivity	datetime		tr_eind_td	—	—
IndicationDifferentShift	varchar(1)		afw_dnst_ind	—	—
IndicationOrigination	varchar(1)		herkomst_ind	—	—
LogonId	int		logon_id	—	—
OUActivity	bigint		oe_activiteit	—	—
OURegistration	bigint		oe_registratie	—	—
OUShift	bigint		oe_dienst	—	—
PartOfDay	int		dagdeel	—	—
PercentageCode	int		perc_kd	—	—
Period	int		periode	—	—
Personnumber	numeric(7,0)		pers_nr	P01001	Persoonsnummer
SequenceNumber	int		tr_volgnr	—	—
ShiftCode	varchar(4)		dnst_kd	—	—
StarttimeActivity	datetime		tr_begin_td	—	—
TimeRegistrationBK	int		dpin150_sl	—	—
Timestamp	datetime2(2)		—	—	—
Year	int		jaar	—	—

type-control-z-w

• Entity Name: type-control-z-w
• Core Table: DPID134
• Internal Table: BO4_TypeControlZW

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(30)		cntrzw_oms	—	—
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
TypeControlZW_BK	varchar(30)	PK, BK	cntrzw_srt	P01611	Soort controle ZW

type-of-income-ratio

• Entity Name: type-of-income-ratio
• Core Table: DPIC052
• Internal Table: BO4_TypeOfIncomeRatio

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Timestamp	datetime2(2)		—	—	—
TypeOf_IncomeRatio	varchar(25)		srt_inkomen_oms	—	—
TypeOfIncomeRatio_BK	int	PK, BK	soort_inkomen_kd	P00893	Code soort inkomstenverhouding

type-of-insurance

• Entity Name: type-of-insurance
• Core Table: DPIC363
• Internal Table: BO4_TypeOfInsurance

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
IndicationInsuredAccoringtoSicknessLaw	varchar(1)		zw_ind	—	—
Timestamp	datetime2(2)		—	—	—
TypeOfInsurance_BK	varchar(3)	PK, BK	wn_vzk_kd	P01182	Soort wn-verzekering

type-of-paid-worker

• Entity Name: type-of-paid-worker
• Core Table: DPIC359
• Internal Table: BO4_TypeOfPaidWorker

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
ScalePayrollAmount	varchar(1)		sch_inpas	—	—
Timestamp	datetime2(2)		—	—	—
TypeOf_PaidWorker	varchar(25)		loner_oms	—	—
TypeOfPaidWorker_BK	varchar(3)	PK, BK	loner_kd	P00332	Code soort loner

type-of-payroll-tax

• Entity Name: type-of-payroll-tax
• Core Table: DPIC361
• Internal Table: BO4_TypeOfPayrollTax

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
TypeOf_PayrollTax	varchar(25)		lnh_tab_oms	—	—
TypeOfPayrollTax_BK	varchar(3)	PK, BK	lnh_tab_kd	P00333	Soort loonheffingstabel

type-of-pension-fund

• Entity Name: type-of-pension-fund
• Core Table: DPIC362
• Internal Table: BO4_TypeOfPensionFund

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
TypeOf_PensionFund	varchar(25)		pensf_oms	—	—
TypeOfPensionFund_BK	varchar(3)	PK, BK	pensf_kd	P00315	Soort pensioenfonds

user-information

• Entity Name: user-information
• Core Table: DPIA009
• Internal Table: TBL_UserInformation

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
AccessToAll	varchar(1)		toeg_allen	—	—
AccessToUnlocked	varchar(1)		toeg_slotl	—	—
DefaultPrinter	varchar(16)		defprinter	—	—
IndInitialPassword	varchar(1)		init_pwd_ind	—	—
MaxBatchPriority	varchar(1)		gebr_prior	—	—
NetworkId	varchar(50)		netwerk_id	—	—
PasswordMutationDate	date		wwmut_dt	—	—
Person_BK	int	BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—
UsedStartMenu	numeric(7,0)		gebr_start	—	—
UserId	varchar(16)		gebr_id	—	—
UserGroupId	varchar(2)		gbrgrp_id	—	—
Username	varchar(30)		gebr_naam	—	—
ValidityDuration	int		geldig_duur	—	—

wage-tax-reduction

• Entity Name: wage-tax-reduction
• Core Table: DPIC365
• Internal Table: BO4_WageTaxReduction

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Id	int		—	—	—
Timestamp	datetime2(2)		—	—	—
WageTax_Reduction	varchar(25)		lh_krt_oms	—	—
WageTaxReduction_BK	int	PK, BK	lh_krt_kd	P00354	Loonheffingskorting

work-disability

• Entity Name: work-disability
• Core Table: DPID148
• Internal Table: TBL_WorkDisability

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
EndDate_WorkDisability	datetime		eind_dt	P04404	Einddatum arbeidsgehandicapt
Id	int		—	—	—
Person_BK	int	PK, BK	pers_nr	P01001	Persoonsnummer
ReasonEndOfDisability_BK	varchar(3)	BK	uitstr_kd	P04403	Code reden uitstroom arbeidsgehandicapt
ReasonStartOfDisability_BK	varchar(3)	BK	instr_kd	P04402	Code reden instroom arbeidsgehandicapt
StartDate_WorkDisability	datetime		ingang_dt	P04401	Ingangsdatum arbeidsgehandicapt
Timestamp	datetime2(2)		—	—	—
WorkDisability_BK	varchar(18)	BK	—	—	—
WorkDisability_Number	int	PK	dpid148_sl	P04426	Technische sleutel arbeidsgehandicapt

work-pattern

• Entity Name: work-pattern
• Core Table: DPID012
• Internal Table: TBL_WorkPattern

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
Id	int		—	—	—
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—
WorkPattern_BK	int	PK, BK	dpid012_sl	P01412	Technische sleutel DV Werkpatroon
WorkPatternHours	numeric(5,2)		ptrn_uren	P01411	Uren werkpatroon DV
WorkPatternNumber	numeric(3,0)		ptrn_vlgnr	P01410	Volgnummerr werkpatroon

work-schedule

• Entity Name: work-schedule
• Core Table: DPID013
• Internal Table: TBL_WorkSchedule

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractBK	varchar(30)	BK	—	—	—
Contract_number	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
Id	int		—	—	—
Personnumber	numeric(7,0)	PK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—
WorkScheduleDate	datetime2(2)	PK	rstr_dt	P01420	Datum werkrooster
WorkScheduleHours	numeric(5,2)		rstr_uren	P01421	Uren werkrooster

work-therapy

• Entity Name: work-therapy
• Core Table: DPID112
• Internal Table: TBL_WorkTherapy

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
DescriptionActivities	varchar(25)		at_werk_oms	P01677	Omschrijving wekz. AT basis
EndDateTherapy	datetime		ther_tot	P01671	Therapie tijdvak tot
Id	int		—	—	—
Notes	varchar(max)		at_notit	—	—
OU_BK	numeric(10,0)	BK	dpib015_sl	P01676	Technische sleutel  organisatorische eenheid
OwnOrAdaptedActivities	varchar(3)		ander_wrk_kd	P01675	Code eigen/aangepast werk
PersonBK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
ProductivityTherapy	numeric(6,2)		ther_prod	P01673	Percentage produktiviteit therapie
SicknessCase_BK	varchar(30)	BK	dpid110_sl	P01615	Technische sleutel ziektegeval
SicknessNumber	numeric(10,0)	PK	dpid110_sl	P01615	Technische sleutel ziektegeval
StartDateTherapy	datetime		ther_vanaf	P01670	Therapie tijdvak vanaf
TherapyHoursPerWeek	numeric(5,2)		ther_upw	P01672	Uren per week therapie
Timestamp	datetime2(2)		—	—	—
WorkTherapy_BK	varchar(50)	BK	object_id	—	—
WorkTherapyNumber	numeric(10,0)	PK	dpid112_sl	P01674	Technische sleutel Therapie tijdvak

working-days

• Entity Name: working-days
• Core Table: —
• Internal Table: FACT_TBL_WorkingDays

Field	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Age	int	PK	—	—	—
Contract_BK	string	BK	—	—	—
ContractStartdt_bk	long	PK, BK	—	—	—
Date_ID	int	PK	—	—	—
FTE	decimal	PK	—	—	—
Id	int		—	—	—
Person_BK	string	BK	—	—	—
SickInMonth	int	PK	—	—	—
Timestamp	DateTime		—	—	—
Working_Days	int	PK	—	—	—
WorkingDaysWeighted	decimal		—	—	—