Dataverse tables
Applies to these Dynamics 365 apps:
Human Resources
Microsoft Dynamics 365 Human Resources uses Dataverse to enable extensibility and integration scenarios.
Note
Human Resources entities correspond to Dataverse tables. For more information about Dataverse (formerly Common Data Service) and terminology updates, see What is Microsoft Dataverse?
The following Dataverse tables are available based on Human Resources entities.
Benefit tables
| Name | Table |
|---|---|
| Benefit Calculation Frequency | cdm_benefitcalculationfrequency |
| Benefit Calculation Frequency Pay Period | cdm_benefitcalculationfrequencypayperiod |
| Benefit Calculation Rate | cdm_benefitcalculationrate |
| Benefit Calculation Rate Detail | cdm_benefitcalculationratedetail |
| Benefit Option | cdm_benefitoption |
| Benefit Plan | cdm_benefitplan (Not enabled for custom field support) |
| Benefit Type | cdm_benefittype |
Business process tasks tables
| Name | Table |
|---|---|
| Business Process Calendar | cdm_businessprocesscalendar |
| Business Process Group Assignment | cdm_businessprocessgroupassignment |
| Business Process Library Task Group | cdm_businessprocesslibrarytaskgroup |
| Business Process Stage | cdm_businessprocessstage |
| Checklist Template Header | cdm_businessprocesstemplateheader |
| Checklist Template Task | cdm_businessprocesstemplatetask |
Compensation tables
| Name | Table |
|---|---|
| Compensation Fixed Plan | cdm_compensationfixedplan |
| Compensation Grid | cdm_compensationgrid |
| Compensation Level | cdm_compensationlevel |
| Compensation Pay Frequency | cdm_compensationpayfrequency |
| Compensation Reference Point Setup | cdm_compensationreferencepointsetup |
| Compensation Reference Point Setup Line | cdm_compensationreferencepointsetupline |
| Compensation Region | cdm_compensationregion |
| Compensation Structure | cdm_compensationstructure |
| Compensation Variable Plan | cdm_compensationvariableplan |
| Compensation Variable Plan Level | cdm_compensationvariableplanlevel |
| Compensation Variable Plan Type | cdm_compensationvariableplantype |
| Fixed Compensation Event | cdm_fixedcompensationevent |
| Vesting Rule | cdm_vestingrule |
| Worker Fixed Compensation | cdm_workerfixedcompensation |
Organization tables
| Name | Table |
|---|---|
| Department | cdm_department |
| Employment | cdm_employment |
| Company | cdm_company |
| Job | cdm_job |
| Job Function | cdm_jobfunction |
| Job Position | cdm_jobposition |
| Position Type | cdm_positiontype |
| Position Worker Assignment | cdm_positionworkerassignmentmap |
| Job Position Dimension | cdm_jobpositiondimension |
| Job Type | cdm_jobtype |
| Language | cdm_language |
| Title | cdm_title |
Note
Financial dimensions for Position Type, Position Worker Assignment, and Employment provide one-direction integration to Dataverse. Financial dimensions updates currently can't synchronize from Dataverse to Human Resources.
Leave and absence tables
| Name | Table |
|---|---|
| Leave Bank Transaction | cdm_leavebanktransaction |
| Leave Enrollment | cdm_leaveenrollment |
| Leave Plan | cdm_leaveplan |
| Leave Request | cdm_leaverequest |
| Leave Request Detail | cdm_leaverequestdetail |
| Leave Type | cdm_leavetype |
| Leave Type Reason Code | cdm_leavetypereasoncode |
Payroll tables
| Name | Table |
|---|---|
| Pay Cycle | cdm_paycycle |
| Pay Period | cdm_payperiod |
| Payroll Earning Code | cdm_payrollearningcode |
| Bank Account Disbursement | cdm_bankaccountdisbursement |
| Tax Region | cdm_taxregion |
Worker tables
| Name | Table |
|---|---|
| Worker | cdm_worker |
| Worker Address | cdm_workeraddress |
| Worker Personal Detail | cdm_workerpersonaldetail |
| Worker Person Identification Number | cdm_workerpersonidentificationnumber |
| Worker Person Identification Type | cdm_workerpersonidentificationtype |
| Work Calendar | cdm_workcalendar |
| Work Calendar Day | cdm_workcalendarday |
| Work Calendar Holiday | cdm_workcalendarholiday |
| Work Calendar Holiday Line | cdm_workcalendarholidayline |
| Work Calendar Time Interval | cdm_workcalendartimeinterval (Not enabled for custom field support) |
| Worker Bank Account | cdm_workerbankaccount |
Worker setup tables
| Name | Table |
|---|---|
| Veteran Status | cdm_veteranstatus |
| Ethnic Origin | cdm_ethnicorigin |
| Reason Code | cdm_reasoncode |
| Person Identification Issuing Agency | cdm_personidentificationissuingagency |
Competency tables
| Name | Table |
|---|---|
| Skill Type | cdm_skilltype |
Table relationship models
Worker
Job and Job Position
Benefits
Compensation
Leave
Work Calendar
See also
Choose a data integration technology
Configure Dataverse integration
Configure Dataverse virtual tables
Human Resources virtual tables FAQ
What is Microsoft Dataverse?
Terminology updates