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.
• 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.

BO4_AssignmentType

• Core table: DPIC356
• Entity name: AssignmentType

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

BO4_ContractType

• Core table: DPIC055
• Entity name: ContractType

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

BO4_CustomFields

• Core table: DPIA032
• Entity name: CustomFields

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

BO4_Element

• Core table: DPIA028
• Entity name: Element

Column	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	—	—

BO4_ElementValue

• Core table: DPIA029
• Entity name: ElementValue

Column	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	—	—

BO4_EmployeeGroup

• Core table: DPIC350
• Entity name: EmployeeGroup

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

BO4_EmploymentRelationship

• Core table: DPIC053
• Entity name: EmploymentRelationship

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
EmploymentRelationship	varchar(25)		aard_arbeid_oms	—	—
EmploymentRelationship_BK	varchar(2)	PK, BK	aard_arbeid_kd	P02268	Code aard arbeidsverhouding
ID	int		—	—	—
Timestamp	datetime2(2)		—	—	—

BO4_FunctionCategory

• Core table: DPIC349
• Entity name: FunctionCategory

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

BO4_FunctionGroup

• Core table: DPIC369
• Entity name: FunctionGroup

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

BO4_FunctionPaymentType

• Core table: DPIF060
• Entity name: FunctionPaymentType

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

BO4_FunctionProfession

• Core table: DPID132
• Entity name: FunctionProfession

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

BO4_FunctionStandard

• Core table: DPIF008
• Entity name: FunctionStandard

Column	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	—	—
FunctionStandard	varchar(50)		oms	P02028	Standaardfunctie
FunctionStandard_BK	varchar(7)	PK, BK	stanf_kd	P02308	Code standaardfunctie
ID	int		—	—	—
Timestamp	datetime2(2)		—	—	—

BO4_FunctionStatus

• Core table: DPIC374
• Entity name: FunctionStatus

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

BO4_FunctionType

• Core table: DPIA046
• Entity name: FunctionType

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

BO4_History

• Core table: DPIA037
• Entity name: History

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
dpia037_sl	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

BO4_Indication1

• Core table: DPIF021
• Entity name: Indication1

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

BO4_Indication10

• Core table: DPIF030
• Entity name: Indication10

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

BO4_Indication2

• Core table: DPIF022
• Entity name: Indication2

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

BO4_Indication3

• Core table: DPIF023
• Entity name: Indication3

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

BO4_Indication4

• Core table: DPIF024
• Entity name: Indication4

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

BO4_Indication5

• Core table: DPIF025
• Entity name: Indication5

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

BO4_Indication6

• Core table: DPIF026
• Entity name: Indication6

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

BO4_Indication7

• Core table: DPIF027
• Entity name: Indication7

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

BO4_Indication8

• Core table: DPIF028
• Entity name: Indication8

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

BO4_Indication9

• Core table: DPIF029
• Entity name: Indication9

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

BO4_LeaveBlockadeReason

• Core table: DPID023
• Entity name: LeaveBlockadeReason

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

BO4_LeaveEntitlement

• Core table: DPID014
• Entity name: LeaveEntitlement

Column	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
LeaveType_BK	varchar(3)	PK, BK	vrlfsrt_kd	P01430	Code verlofsoort werknemer
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01440	Verlofjaar verlofrechten
Person_BK	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

BO4_LeavePerDay

• Core table: DPID016
• Entity name: LeavePerDay

Column	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
LeaveType_BK	varchar(3)	PK, BK	vrlfsrt_kd	P01437	code verlofsoort
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01440	Verlofjaar verlofrechten
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

BO4_LeavePeriod

• Core table: DPID015
• Entity name: LeavePeriod

Column	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
LeaveReason_BK	varchar(3)	BK	vrlfrdn_kd	P01463	Code verlofreden
LeaveType_BK	varchar(3)	PK, BK	vrlfsrt_kd	P01465	Code verlofsoort
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01466	Verlofjaar verlofrechten
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
StartDate	datetime		vtvk_bdt	P01461	Begindatum verloftijdvak
Timestamp	datetime2(2)		—	—	—

BO4_LeavePolicyDescription

• Core table: DPID004
• Entity name: LeavePolicyDescription

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
Leave_policy_code	varchar(3)	PK	vrlfreg_kd	P01400	Code verlofregeling werknemer (Vervallen)
Leave_policy_description	varchar		vrlfreg_oms	—	—
Leave_policy_hours	numeric		vrlf_uren	P01471	Uren verlof
Timestamp	datetime2(2)		—	—	—

BO4_LeaveReason

• Core table: DPID002
• Entity name: LeaveReason

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
LeaveReason	varchar(25)		vrlrdn_oms	—	—
LeaveReason_BK	varchar(3)	PK, BK	vrlfrdn_kd	P01463	Code verlofreden
Timestamp	datetime2(2)		—	—	—

BO4_LeaveRightMutationReason

• Core table: DPID026
• Entity name: LeaveRightMutationReason

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
Indication_Standard	varchar(1)		standaard_ind	—	—
LeaveRightMutationReason	varchar(25)		vrlfr_mut_oms	—	—
LeaveRightMutationReason_BK	varchar(4)	PK, BK	vrlfr_mut_kd	P56001	Code reden verlofrechtmutatie
Timestamp	datetime2(2)		—	—	—

BO4_LeaveType

• Core table: DPID001
• Entity name: LeaveType

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
Indication_BankHoliday	varchar(1)		fst_ind	—	—
Indication_CompanyLeave	varchar(1)		bv_ind	—	—
Indication_LegalLeave	varchar(1)		wet_verlof_ind	—	—
Indication_TimeForTime	varchar(1)		tvt_ind	—	—
LeaveType_BK	varchar(4)	PK, BK	vrlfsrt_kd	P01437	code verlofsoort
LeaveType_Desc	varchar(25)		vrlfsrt_oms	—	—
Timestamp	datetime2(2)		—	—	—

BO4_LeaveTypePolicy

• Core table: DPID010
• Entity name: LeaveTypePolicy

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Code_Leave_Type	varchar(3)	PK	vrlfsrt_kd	P01437	code verlofsoort
ID	int		—	—	—
Leave_policy_code	varchar(3)	PK	vrlfreg_kd	P01400	Code verlofregeling werknemer (Vervallen)
Leave_Type_Rights	numeric		vrlfr_srt	—	—
Presentation_Unit	varchar		pres_eenh	—	—
Start_Month	numeric		start_mnd	—	—
Timestamp	datetime2(2)		—	—	—

BO4_OrganisationModel

• Core table: DPIF001
• Entity name: OrganisationModel

Column	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		—	—	—
Ind_Standard	varchar(1)		standaard	—	—
OrganisationModel	varchar(25)		oms	P02028	Standaardfunctie
OrganisationModel_BK	varchar(5)	PK, BK	om_kd	—	—
StartDate	datetime2(2)		ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

BO4_OrganisationUnit

• Core table: DPIF002
• Entity name: OrganisationUnit

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CostCenter_BK	varchar(7)	BK	kstpl_kd	P01128	Kostenplaats inzet
CostUnit_BK	varchar(7)	BK	kstdrg_kd	P01129	Kostendrager inzet
ID	int		—	—	—
Ind_Blocked	varchar(1)		oe_blok	—	—
OrganisationModel_BK	varchar(5)	BK	om_kd	—	—
OrgModelUnit	varchar(50)		oe_vol_nm	P02032	Omschrijving Org.eenheid loopbaanstap
OrgModelUnit_BK	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	—	—

BO4_OrganizationalUnitType

• Core table: DPIB018
• Entity name: OrganizationalUnitType

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

BO4_PKBColumnNumber

• Core table: DPIL013
• Entity name: PKBColumnNumber

Column	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	—	—
PayrollCode_BK	numeric(6,0)	BK	uitv_kd	—	—
Timestamp	datetime2(2)		—	—	—

BO4_PKBResults

• Core table: DPIL014
• Entity name: PKBResults

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ContractNumber	numeric(4,0)		dv_vlgnr	P01101	Volgnr dienstverband
CostCenter_BK	varchar(7)	BK	kstpl_kd	—	—
CostType_BK	varchar(7)	BK	kstsrt_kd	—	—
CostUnit_BK	varchar(7)	BK	kstdrg_kd	—	—
dpil014_sl	numeric(10,0)	PK	dpil014_sl	—	—
FinancialGroup_BK	numeric(6,0)	BK	opdrgvr_nr	P01103, S00900	Opdrachtgever / Opdrachtgever nummer
ID	int		—	—	—
LineNumber	numeric(4,0)		regel_nr	—	—
OriginCode	varchar(3)		herkomst_kd	—	—
PayrollInstitution_BK	numeric(5,0)	BK	inst_nr	P01104, S02900	Instelling / Instelling nummer
Person_BK	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	—	—

BO4_PayrollAmount

• Core table: DPIC330
• Entity name: PayrollAmount

Column	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
SalaryScheme_BK	varchar(3)	PK, BK	reg_sal_kd	S05551	Code salarisregeling
Timestamp	datetime2(2)		—	—	—

BO4_PayrollCodes

• Core table: DPIC004
• Entity name: PayrollCodes

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

BO4_PersonAddress

• Core table: DPIB005
• Entity name: PersonAddress

Column	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)		—	—	—

BO4_PersonNationality

• Core table: DPIB006
• Entity name: PersonNationality

Column	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)		—	—	—

BO4_Position

• Core table: DPIF003
• Entity name: Position

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CostCenter_BK	varchar(7)	BK	kstpl_kd	P01128	Kostenplaats inzet
CostType_BK	varchar(7)	BK	kstsrt_kd	P01127	Kostensoort inzet
CostUnit_BK	varchar(7)	BK	kstdrg_kd	P01129	Kostendrager inzet
EndDate	datetime2(2)		eind_dt	P01029	Einddatum adres
EndReason_BK	varchar(3)	BK	redeind_kd	—	—
Function_BK	varchar(10)	BK	func_kd	P02301	Code functie
ID	int		—	—	—
Ind_Formalised	varchar(1)		ind_formatie	P02310	Indicator formatiefunctie
IndicationCode1_BK	varchar(5)	BK	fp_code1_ind	P01911	Formatieplaats code ind. 1
IndicationCode2_BK	varchar(5)	BK	fp_code2_ind	P01912	Formatieplaats code ind. 2
IndicationCode3_BK	varchar(5)	BK	fp_code3_ind	P01913	Formatieplaats code ind. 3
IndicationCode4_BK	varchar(5)	BK	fp_code4_ind	P01914	Formatieplaats code ind. 4
IndicationCode5_BK	varchar(5)	BK	fp_code5_ind	P01915	Formatieplaats code ind. 5
IndicationCode6_BK	varchar(5)	BK	fp_code6_ind	P01916	Formatieplaats code ind. 6
IndicationCode7_BK	varchar(5)	BK	fp_code7_ind	P01917	Formatieplaats code ind. 7
IndicationCode8_BK	varchar(5)	BK	fp_code8_ind	P01918	Formatieplaats code ind. 8
IndicationCode9_BK	varchar(5)	BK	fp_code9_ind	P01919	Formatieplaats code ind. 9
IndicationCode10_BK	varchar(5)	BK	fp_code10_ind	P01920	Formatieplaats code ind. 10
OrganisationModel_BK	varchar(5)	BK	om_kd	—	—
OrgModelUnit_BK	numeric(10,0)	BK	dpif002_sl	—	—
Position_BK	numeric(10,0)	PK, BK	dpif003_sl	P01903	Formatieplaatstoewijzing
PositionInfo_BK	varchar(512)	BK	toel	—	—
PositionReference	varchar(10)		referentie	—	—
PositionType_BK	varchar(3)	BK	fplsrt_kd	—	—
StartDate	datetime2(2)		ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

BO4_PositionAllocation

• Core table: DPIF006
• Entity name: PositionAllocation

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	varchar(30)	BK	—	—	—
Contractnumber	numeric(7,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDate	datetime		eind_dt	P01909	Einddatum formatieplaats
EndReason_BK	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	—	—
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Position_BK	numeric(10,0)	PK, BK	dpif003_sl	P01903	Formatieplaatstoewijzing
Reason_BK	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)		—	—	—

BO4_PositionDetail

• Core table: DPIF013
• Entity name: PositionDetail

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
BlockSize_FTE	numeric(11,4)		aan_fte_blok_vac	—	—
BlockSize_Hours	numeric(11,4)		aan_uren_blok_vac	—	—
EndDate	datetime		eind_dt	P01029	Einddatum adres
ID	int		—	—	—
Position_BK	numeric(10,0)	PK, BK	dpif003_sl	P01903	Formatieplaatstoewijzing
RestSize_FTE	numeric(11,4)		aan_fte_rest_vac	—	—
RestSize_Hours	numeric(11,4)		aan_uren_rest_vac	—	—
Seats	numeric(6,0)		aan_stoel	—	—
Size_FTE	numeric(11,4)		aan_fte	P01905	Aantal full time equivalenten
Size_Hours	numeric(11,4)		aan_uren	—	—
StartDate	datetime	PK	ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

BO4_PositionType

• Core table: DPIF056
• Entity name: PositionType

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
PositionType	varchar(25)		oms	P02028	Standaardfunctie
PositionType_BK	varchar(3)	PK, BK	fplsrt_kd	—	—
Timestamp	datetime2(2)		—	—	—

BO4_ReasonForLeavingPensionFund

• Core table: DPIC360
• Entity name: ReasonForLeavingPensionFund

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

BO4_ReasonOutOfService

• Core table: DPIC354
• Entity name: ReasonOutOfService

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

BO4_RoleAssignment

• Core table: DPIB025
• Entity name: RoleAssignment

Column	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
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
RoleDescription_BK	varchar(5)	PK, BK	rol_oe_kd	P01062	Rol
StartDate	datetime	PK	ingang_dt	P01063	Ingangsdatum roltoewijzing
Timestamp	datetime2(2)		—	—	—

BO4_RoleDescription

• Core table: DPIB009
• Entity name: RoleDescription

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
RoleDescription	varchar(25)		rol_oe_oms	—	Roltoewijzing
RoleDescription_BK	varchar(5)	BK	rol_oe_kd	P01062	Rol
Timestamp	datetime2(2)		—	—	—

BO4_SalaryScale

• Core table: DPIC333
• Entity name: SalaryScale

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
IndicationYouthScaleActive	varchar(1)		jgds_ss_ind	S50210	Ind jeugdschaal actief salarisschaal
SalaryScale_BK	varchar(4)	PK, BK	schaal	S05571	Schaal
SalaryScheme_BK	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

BO4_SalaryScheme

• Core table: DPIC043
• Entity name: SalaryScheme

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

BO4_ScaleSeniority

• Core table: DPIC334
• Entity name: ScaleSeniority

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
ID	int		—	—	—
PayrollAmountNumber	int		inpas_nr	S05576	Inpassingsnummer
SalaryScale_BK	varchar(4)	PK, BK	schaal	P01151	Schaal salaris
SalaryScheme_BK	varchar(3)	PK, BK	reg_sal_kd	S05551	Code salarisregeling
Seniority_BK	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

BO4_SicknessCodeAbsence

• Core table: DPID130
• Entity name: SicknessCodeAbsence

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

BO4_SicknessReason

• Core table: DPID133
• Entity name: SicknessReason

Column	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)		—	—	—

BO4_TypeControlZW

• Core table: DPID134
• Entity name: TypeControlZW

Column	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

BO4_TypeOfInsurance

• Core table: DPIC363
• Entity name: TypeOfInsurance

Column	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

BO4_TypeOfPaidWorker

• Core table: DPIC359
• Entity name: TypeOfPaidWorker

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

BO4_TypeOfPayrollTax

• Core table: DPIC361
• Entity name: TypeOfPayrollTax

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

BO4_TypeOfPensionFund

• Core table: DPIC362
• Entity name: TypeOfPensionFund

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

BO4_WageTaxReduction

• Core table: DPIC365
• Entity name: WageTaxReduction

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

TBL_Assignment

• Core table: DPIC310
• Entity name: Assignment

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
CostCenter_BK	varchar(7)	BK	kstpl_kd	P01128	Kostenplaats inzet
CostType_BK	varchar(7)	BK	kstsrt_kd	P01127	Kostensoort inzet
CostUnit_BK	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
Parttime_percentage	numeric(6,4)		—	—	—
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
StartDate	date	PK	ingang_dt	P01125	Ingang inzet
Timestamp	datetime2(2)		—	—	—
TypeAssignment_BK	varchar(3)	BK	inzsrt_kd	P01123	Soort inzet
WorkTimeFactor	decimal(6,4)		—	—	—

TBL_BankInfo

• Core table: DPIC302
• Entity name: BankInfo

Column	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
Contract_BK	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
Person_BK	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

TBL_Child

• Core table: DPIB013
• Entity name: Child

Column	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)		—	—	—

TBL_Contract

• Core table: DPIC300
• Entity name: Contract

Column	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
CalculationHourlyPaidEmployee_BK	varchar(1)	BK	svu_tel_kd	P02108	code SV-dagen + uren uurloners tellen
CodeNetWager_BK	numeric(2,0)	BK	netto_loner_kd	—	—
CompanyCar_BK	numeric(2,0)	BK	bedrijf_auto_kd	—	—
Contract_BK	varchar(30)	BK	object_id	—	—
ContractDaysPW	varchar(7)		werkdgn	P00448	Werkdagen
ContractHoursPW	numeric(5,2)		uren_pw	P01109	Uren per week
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
ContractType_BK	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
DisabilityDiscount_BK	numeric(3,0)	BK	ag_korting_kd	P00930	Vervallen (Vervallen)
DiscountBenefit	numeric(10,2)		korting_uitk	—	—
EmployeeGroup_BK	varchar(3)	BK	doelgrp_kd	P01110	Code doelgroep
EmploymentRelationship_BK	char(2)	BK	aard_arbeid_kd	P02268	Code aard arbeidsverhouding
EmploymentType_BK	varchar(3)	BK	arelsrt_kd	P01102	Soort arbeidsrelatie
EntryPeriodBlockingIllnessPayrollProcessor	varchar(6)		blk_zk_per	P01683	Ingangs periode blokkade ziekte salarisverw.
FinancialGroup_BK	numeric(6,0)	BK	opdrgvr_nr	P01103	Opdrachtgever
Function_BK	varchar(10)	BK	primfunc_kd	P01107	Primaire functie
FunctionProfession_BK	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
GuaranteeSalaryScale_BK	varchar(4)	BK	schaal_gs	P01157	Garantieschaalnummer
HealthInsurer_BK	varchar(3)	BK	zv_kd	P01891	Code zorgverzekeraar
ID	int		—	—	—
IncomeReduction_BK	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
IndemnityContinuationPFZW_BK	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
InfluenceOfInsuranceObligation_BK	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
NormHoursPerWeek_BK	numeric(2,0)	BK	norm_urn_kd	P02486	Cd norm-uren fulltime per week
NoticePeriodInMonths	varchar(1)		opzegterm	P01108	Opzegtermijn in maanden
OU_BK	numeric(10,0)	BK	oe_hier_sl	P01106	Hierarchische org. eenheid
PartialServiceTime_BK	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
PayrollInstitution_BK	numeric(5,0)	BK	inst_nr	P01104	Instelling
PayrollTaxReduction_BK	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
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
PFZWSequenceNr	numeric(4,0)		pggm_vlgnr	P00358	Volgnummer pensioenfonds PFZW
PolicyALG_BK	varchar(3)	BK	reg_alg_kd	P02107	code regeling alg
PolicyAVBAS_BK	varchar(3)	BK	reg_avbas_kd	P02102	code regeling Avbas
PolicyBAW_BK	varchar(3)	BK	reg_baw_kd	P02103	Code regeling BAW
PolicyORD_BK	varchar(3)	BK	reg_ord_kd	P02100	code regeling ord
PolicyOVW_BK	varchar(3)	BK	reg_ovw_kd	P02101	code regeling ovw
PolicySLD_BK	varchar(3)	BK	reg_sld_kd	P02104	code regeling sld
PolicyVSD_BK	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
ReasonForLeavingPensionFund_BK	varchar(3)	BK	uit_pf_kd	P01183	Reden uittreden ABP (Vervallen)
ReasonForLeavingPFZW_BK	numeric(2,0)	BK	reden_uit_pggm	—	—
ReasonOutOfService_BK	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
SalaryScale_BK	varchar(4)	BK	schaal	P01151	Schaal salaris
SalaryScheme_BK	varchar(3)	BK	reg_sal_kd	P00314	Code salarisregeling
Seniority_BK	numeric(3,0)	BK	ancien	P00326	Ancienniteit salaris
SeniorityGuarantee	numeric(3,0)		ancien_gs	P01158	Ancienniteit garantieschaal
SpecialTaxPolicy_BK	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
SupplementMinimumWage_BK	varchar(1)	BK	blok_aml_kd	P00339	Aanvulling minimumloon
Timestamp	datetime2(2)		—	—	—
TypeOfIncomeRatio_BK	numeric(3,0)	BK	soort_inkomen_kd	P00893	Code soort inkomstenverhouding
TypeOfInsurance_BK	varchar(3)	BK	wn_vzk_kd	P01182	Soort wn-verzekering
TypeOfPaidWorker_BK	varchar(3)	BK	loner_kd	P00332	Code soort loner
TypeOfPayrollTax_BK	varchar(3)	BK	lnh_tab_kd	P00333	Soort loonheffingstabel
TypeOfPensionFund_BK	varchar(3)	BK	pensf_kd	P00315	Soort pensioenfonds
TypeOfServiceABP_BK	varchar(3)	BK	tijd_abp_kd	P00859	Code soort diensttijd ABP
WageTaxReduction_BK	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)

TBL_Contract_ChangingAttributes

• Core table: —
• Entity name: Contract_ChangingAttributes

Column	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	—	—	—
Contract_BK	varchar(30)	BK	—	—	—
ContractDaysPW	varchar(7)		—	—	—
ContractHoursPW	decimal(10,2)		—	—	—
ContractHoursPWChanged	int		—	—	—
ContractHoursPWChangedDate	date		—	—	—
ContractNumber	int		—	—	—
ContractStartdt_bk	bigint	PK	—	—	—
ContractType	varchar(10)		—	—	—
ContractType_description	varchar(100)		—	—	—
ContractTypeChanged	int		—	—	—
ContractTypeChangedDate	date		—	—	—
CostCenter	varchar(100)		—	—	—
CostCenter_BK	varchar(10)	BK	—	—	—
CostCenterDescription	varchar(1000)		—	—	—
CostType	varchar(100)		—	—	—
CostType_BK	varchar(10)	BK	—	—	—
CostTypeDescription	varchar(1000)		—	—	—
CostUnit	varchar(100)		—	—	—
CostUnit_BK	varchar(10)	BK	—	—	—
CostUnitChanged	int		—	—	—
CostUnitChangedDate	date		—	—	—
CostUnitDescription	varchar(1000)		—	—	—
Current	bit		—	—	—
Date_Anniversary	date		—	—	—
Date_ID_FirstDateInService	int		—	—	—
Date_ID_LastDateOutOfService	int		—	—	—
Date_In_Service	date		—	—	—
Date_In_Service_CAO	date		—	—	—
Date_of_Entry_Into_The_Pension_Fund	date		—	—	—
Date_of_Withdrawal_Pension_Fund	date		—	—	—
Date_Out_Of_Service	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)		—	—	—
EmploymentType_BK	varchar(3)	BK	—	—	—
EmploymentTypeChanged	int		—	—	—
EmploymentTypeChangedDate	date		—	—	—
EndDate	date		—	—	—
EndDate_slicer	date		—	—	—
EndDateTherapy	date		—	—	—
Entry_period_blocking_illness_payroll_processor	varchar(6)		—	—	—
FinancialGroup_BK	varchar(30)	BK	—	—	—
FinancialGroupChanged	int		—	—	—
FinancialGroupChangedDate	date		—	—	—
FinancialGroupPayrollBK	varchar(3000)		—	—	—
First_Date_in_service	date		—	—	—
Function_BK	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		—	—	—
OU_BK	varchar(30)	BK	—	—	—
OUTherapy	varchar(50)		—	—	—
OUTherapyName	varchar(50)		—	—	—
OwnOrAdaptedActivities	varchar(2)		—	—	—
Partial_Service_Time_Code	varchar(3)		—	—	—
Parttime_percentage	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		—	—	—
PayrollInstitution_BK	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		—	—	—
Person_BK	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	—	—	—
Reason_Out_Of_Service	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)		—	—	—
SalaryScale_BK	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		—	—	—

TBL_CostCenter

• Core table: DPIB004
• Entity name: CostCenter

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

TBL_CostType

• Core table: DPIC353
• Entity name: CostType

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

TBL_CostUnit

• Core table: DPIC352
• Entity name: CostUnit

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

TBL_EmployerCode

• Core table: —
• Entity name: EmployerCode

Column	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		—	—	—
FinancialGroup_BK	varchar(30)	BK	—	—	—
ID	int		—	—	—
PayrollInstitution_BK	varchar(30)	BK	—	—	—
RunId	int		—	—	—
StartPeriod	int		—	—	—
Subnumber	int		—	—	—
Timestamp	datetime2(2)		—	—	—
ValueDate	date		—	—	—
ValueDecimal	decimal(20,4)		—	—	—
ValueInt	int		—	—	—
ValueString	varchar(250)		—	—	—

TBL_EmploymentType

• Core table: DPIC355
• Entity name: EmploymentType

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

TBL_FinancialGroup

• Core table: DPIC200
• Entity name: FinancialGroup

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
FinancialGroup_BK	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)		—	—	—

TBL_Function

• Core table: DPIC351
• Entity name: Function

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CostType_BK	varchar(7)	BK	kstsrt_kd	P02303	Code kostensoort
CostUnit_BK	varchar(7)	BK	kstdrg_kd	P02304	Code kostendrager
Function	varchar(50)		func_oms	P02302	Omschrijving functie
Function_BK	varchar(10)	PK, BK	func_kd	P02301	Code functie
FunctionCategory_BK	varchar(3)	BK	funcat_kd	—	—
FunctionDescription	varchar(max)		func_bschr	—	—
FunctionGroup_BK	varchar(3)	BK	fnctgrp_kd	P02305	Code functiegroep
FunctionPaymentType_BK	varchar(3)	BK	funver_kd	P02306	Code soort verloning
FunctionStandard_BK	varchar(7)	BK	stanf_kd	P02308	Code standaardfunctie
FunctionStatus_BK	varchar(3)	BK	statfunc_kd	P02311	Code status functie
FunctionType_BK	varchar(3)	BK	funtyp_kd	P02309	Code functietype
ID	int		—	—	—
InactiveFunction	varchar(1)		index_ind	—	—
Timestamp	datetime2(2)		—	—	—

TBL_Journal_Entry_Employee

• Core table: DPIL009
• Entity name: Journal_Entry_Employee

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Amount	numeric(13,2)		pkb_bedrag	—	—
Contra Account	varchar(7)		jp_reknr	S34009	Tegenrekeningnr jp-regel
Contract Number	int		dv_vlgnr	P01101	Volgnr dienstverband
Cost Center Code	varchar(7)		kstpl_kd	P01128	Kostenplaats inzet
Cost Type Code	varchar(7)		kstsrt_kd	P01127	Kostensoort inzet
Cost Unit Code	varchar(7)		kstdrg_kd	P01129	Kostendrager inzet
FinancialGroup_BK	int	BK	opdrgvr_nr	S00900	Opdrachtgever nummer
FTE	numeric(11,4)		aant_fte	—	—
Hours	numeric(11,2)		aant_uren	—	—
ID	int		—	—	—
JournalEntry_BK	int	PK, BK	dpil009_sl	—	—
Origin Code	varchar(3)		herkomst_kd	—	—
PayrollInstitution_BK	int	BK	inst_nr	S02900	Instelling nummer
Person BK	int		pers_nr	P01001	Persoonsnummer
Production Period	int		prod_periode	—	—
Registrationnumber	int		reg_nr	P01105	Registratienr
Timestamp	datetime2(2)		—	—	—
Year	int		jaar	—	—

TBL_LeaveRightMutations

• Core table: DPID027
• Entity name: LeaveRightMutations

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	varchar	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
ID	int		—	—	—
LeaveRightMutation_BK	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
LeaveRightMutationReason_BK	varchar(4)	BK	vrlfr_mut_kd	P56001	Code reden verlofrechtmutatie
LeaveType_BK	varchar(3)	PK, BK	vrlfsrt_kd	P01437	code verlofsoort
LeaveYear	numeric(5,0)	PK	vrlfr_jr	P01440	Verlofjaar verlofrechten
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

TBL_Leave_Blockade

• Core table: DPID024
• Entity name: Leave_Blockade

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	varchar	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
EndDate	datetime		tm_dt	P56004	Einddatum blokkade verlofrecht
ID	int		—	—	—
LeaveBlockade_BK	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
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
ReasonBlockade_BK	varchar	BK	vrlf_blok_kd	P56005	Code reden blokkade verlofrecht
StartDate	datetime		vanaf_dt	P56003	Begindatum blokkade verlofrecht
Timestamp	datetime2(2)		—	—	—

TBL_Leave_Policy

• Core table: DPID025
• Entity name: Leave_Policy

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Begin_date_leave_policy	datetime	PK	begin_dt	P01491	Begindatum verlofregeling
Contract_BK	varchar	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
End_date_leave_policy	datetime		eind_dt	P01492	Einddatum verlofregeling
ID	int		—	—	—
Leave_policy_code	varchar		vrlfreg_kd	P01490	Code verlofregeling
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
Timestamp	datetime2(2)		—	—	—

TBL_OrganizationalUnit

• Core table: DPIB015
• Entity name: OrganizationalUnit

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Auth_Level	varchar(30)		oe_autor_n	—	—
City_OU	varchar(50)		oe_plaats	—	—
CostCenter	varchar(50)		kstpl_kd	—	—
Housenumber	int		oe_huisnr	—	—
Housnr_Addition	varchar(5)		oe_hnr_toev	—	—
ID	int		—	—	—
OrganizationalUnit	varchar(50)		oe_vol_nm	P02032	Omschrijving Org.eenheid loopbaanstap
OrganizationalUnitTypeCode	varchar(3)		orgeenh_kd	—	—
OU_BK	numeric(10,0)	PK, BK	dpib015_sl	P01061, P01676	Operationele org.eenheid / Technische sleutel  organisatorische eenheid
OU_Key	int		—	—	—
OU_Level	int		oe_autor	—	—
OU_ShortName	varchar(10)		oe_kort_nm	P02033	Organisatorische eenheid
Parent_OU_BK	varchar(30)	BK	oe_hoger_n	—	—
Parent_OU_Description	varchar(50)		—	—	—
PhoneNumber	varchar(15)		oe_telefoon	—	—
Status_OU	varchar(10)		oe_blok	—	—
Street_OU	varchar(50)		oe_straat	—	—
Timestamp	datetime2(2)		—	—	—
Zipcode_OU	varchar(30)		oe_postcode	—	—

TBL_PayrollCode

• Core table: —
• Entity name: PayrollCode

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Description	varchar(250)		—	—	—
EndDate	date		—	—	—
FinancialGroup_BK	varchar(30)	PK, BK	—	—	—
ID	int		—	—	—
PayrollCode_BK	varchar(30)	PK, BK	—	—	—
PayrollInstitution_BK	varchar(30)	PK, BK	—	—	—
StartDate	date	PK	—	—	—
Timestamp	datetime2(2)		—	—	—

TBL_PayrollInstitution

• Core table: DPIC202
• Entity name: PayrollInstitution

Column	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		—	—	—
PayrollInstitution_BK	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)		—	—	—

TBL_PayrollMutations

• Core table: DPIC503
• Entity name: PayrollMutations

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
CalculationPeriod	varchar(6)		—	—	—
Contract_BK	varchar(30)	BK	—	—	—
ContractNumber	int		—	—	—
DeliveryNumber	int		—	—	—
DeliveryPeriod	varchar(6)		—	—	—
ElementCode	varchar(6)		—	—	—
FinancialGroup_BK	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)		—	—	—
PayrollInstitution_BK	int	BK	—	—	—
Person_BK	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)		—	—	—

TBL_PayrollRuns

• Core table: —
• Entity name: PayrollRuns

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

TBL_Person

• Core table: DPIB010
• Entity name: Person

Column	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
Nationality_BK	varchar(4)	BK	nat_kd	P01004	Nationaliteit
Person_BK	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
PersonFirstName	varchar(70)		e_voornmn	P01002	Voornamen
PersonLastName	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
StartDate_MaritalStatus	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

TBL_PersonalEducationStep

• Core table: DPIE306
• Entity name: PersonalEducationStep

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Action_Employee	varchar(3)		aktie_pers	P02052	Actie persoon opleidingsstap
Action_employer	varchar(3)		aktie_org	P02051	Actie organisatie opleidingsstap
Cost_of_Educationstep	numeric(8,2)		kosten	P02054	Kosten opleidingsstap
Education_BK	varchar(10)	PK, BK	opleiding	P02044	Opleiding
Educationstep_Note	varchar(max)		opl_toel	—	—
Educationstep_type	varchar(10)		opl_type	—	—
Employee_contribution_Educationstep	numeric(8,2)		wknm_bijdr	P02056	Werknemersbijdrage opleidingsstap
Employer_contribution_Educationstep	numeric(8,2)		wkgv_bijdr	P02055	Werkgeversbijdrage opleidingsstap
End_date_Educationstep	datetime		eind_dt	P02045	Einddatum opleidingsstap
Enrollment_status_code	varchar(10)		insch_stat	P02048	Status inschrijving opleiding
ID	int		—	—	—
Institute_code	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
Progress_code	varchar(3)		voortgang	P02053	Voortgang opleidingsstap
Scheduled_date_Educationstep	datetime		plan_dt	P02046	Geplande datum opleidingsstap
Start_date_Educationstep	datetime		begin_dt	P02043	Begindatum opleidingsstap
Status_code_Educationstep	varchar(3)		opl_stat	P02047	Status opleiding
Status_diploma_code	varchar(3)		dipl_stat	P02049	Status diploma
Timestamp	datetime2(2)		—	—	—

TBL_SalaryDistribution

• Core table: DPIC320
• Entity name: SalaryDistribution

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	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
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
SalaryDistributionNumber	numeric(4,0)	PK	lv_rglnr	P01131	Regelnr loonverdeling
Timestamp	datetime2(2)		—	—	—

TBL_SicknessCase

• Core table: DPID110
• Entity name: SicknessCase

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	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_sl	varchar(50)	PK	dpid110_sl	P01615	Technische sleutel ziektegeval
EndDateWagePayment	date		lnbet_eind_dt	—	—
Expected_recovery	date		verw_h_dt	P01605	Datum verwacht herstel
ID	int		—	—	—
Ind_Pregnancy	varchar(2)		zwvrlf_ind	P01613	Indicatie zwangerschapsverlof
Ind_Safetynet	bit		vangnet_ind	P01646	Vangnetgeval indicatie
NewSicknessCase	int		doorl_ind	P01608	ind nieuw/doorl. ziektegeval UWV
Person_BK	int	PK, BK	pers_nr	P01001	Persoonsnummer
ReasonUWVBenefit_BK	varchar	BK	uwv_uitk_rdn_kd	P01618	Code vangnet Ziektewet
Recovery_notification_date	date		beterm_dt	P01607	Datum betermelding
Safetynet_BK	varchar(4)	BK	vangnet_kd	P01645	Soort vangnetgeval
Sickness_notifcation_date	datetime2		zkmeld_dt	P01603	Datum ziekmelding
Sickness_notifcation_time	datetime		zkmeld_tijd	P01604	Tijdstip ziekmelding
SicknessCase_BK	varchar(30)	BK	object_id	—	—
SicknessCodeAbsence_BK	varchar(30)	BK	zktvrzm_kd	P01609	Code ziekteverzuim
SicknessDossier_DateBegin	datetime		eerste_ao_dag_dt	P01616	Datum eerste ao-dag van reeks van ziektegevallen
SicknessDossier_DateEnd	datetime		—	—	—
SicknessReason_BK	varchar(30)	BK	rdn_zk	P01610	Reden ziek
Time_of_disability	datetime		ao_tijdst	P01601	Tijdstip arbeidsongeschikt
Timestamp	datetime2(2)		—	—	—
TypeControlZW_BK	varchar	BK	cntrzw_srt	P01611	Soort controle ZW
WorkedHoursFirstRecoveryDay	decimal(5,2)		ao_gewuren	P01602	Gewerkte uren eerste ao-dag
WVP_Date	date		wvp_ao_dt	P01617	WVP eerste AO-dag

TBL_SicknessCaseDetail

• Core table: DPID111
• Entity name: SicknessCaseDetail

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	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
dpid110_sl	varchar(50)	PK	dpid110_sl	P01615	Technische sleutel ziektegeval
dpid111_sl	varchar(50)	PK	dpid111_sl	P01644	Technische sleutel ziektetijdvak
ID	int		—	—	—
Last_mutation_date	date		mut_dt	—	—
PercentageSick	numeric(6,4)		perc_ziek	P01642	Percentage ziek
Person_BK	numeric(7,0)	PK, BK	pers_nr	P01001	Persoonsnummer
SicknessCaseDetail_BK	varchar(50)	BK	object_id	P01644	Technische sleutel ziektetijdvak
Timestamp	datetime2(2)		—	—	—

TBL_SystemMutations

• Core table: DPIA098
• Entity name: SystemMutations

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Action	varchar(1)		—	—	—
Contract_BK	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	—	—	—
Logon_ID	numeric(10,0)	PK	—	—	—
LogTime	datetime		—	—	—
Person_BK	varchar(30)	BK	—	—	—
ProductionType	varchar(3)		—	—	—
RetroPeriod	varchar(6)		—	—	—
RetroPeriodStart	varchar(6)		—	—	—
SalaryPeriod	varchar(50)		—	—	—
StartDate	datetime		—	—	—
SystemMutation_BK	varchar(50)	BK	—	—	—
Timestamp	datetime2(2)		—	—	—
TransactionNr	numeric(10,0)		—	—	—
User_ID	varchar(16)		—	—	—
ValueNew	varchar(50)		—	—	—
ValueNewDescription	varchar(50)		—	—	—
ValueOld	varchar(50)		—	—	—
ValueOldDescription	varchar(50)		—	—	—

TBL_WorkDisability

• Core table: DPID148
• Entity name: WorkDisability

Column	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

TBL_WorkPattern

• Core table: DPID012
• Entity name: WorkPattern

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	varchar(30)	BK	—	—	—
ContractNumber	numeric(4,0)	PK	dv_vlgnr	P01101	Volgnr dienstverband
ID	int		—	—	—
Person_BK	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

TBL_WorkSchedule

• Core table: DPID013
• Entity name: WorkSchedule

Column	Datatype	Key	HR Core Field	Rubriek Code	Name in HR Core
Contract_BK	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

TBL_WorkTherapy

• Core table: DPID112
• Entity name: WorkTherapy

Column	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
Person_BK	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