Common Data Service entities

Note

Effective November 2020:

  • Common Data Service has been renamed to Microsoft Dataverse. For more information, see Power Automate Blog.
  • Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. For more information, see Terminology updates.

This topic will be updated soon to reflect the latest terminology.

Microsoft Dynamics 365 Human Resources uses Common Data Service to enable extensibility and integration scenarios.

For more information about Common Data Service, see What is Common Data Service.

The following Human Resources entities are available in Common Data Service.

Benefit entities

Name Entity
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 entities

Name Entity
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 entities

Name Entity
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 entities

Name Entity
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 Common Data Service. Financial dimensions updates currently can't synchronize from Common Data Service to Human Resources.

Leave and absence entities

Name Entity
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 entities

Name Entity
Pay Cycle cdm_paycycle
Pay Period cdm_payperiod
Payroll Earning Code cdm_payrollearningcode
Bank Account Disbursement cdm_bankaccountdisbursement
Tax Region cdm_taxregion

Worker entities

Name Entity
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 entities

Name Entity
Veteran Status cdm_veteranstatus
Ethnic Origin cdm_ethnicorigin
Reason Code cdm_reasoncode
Person Identification Issuing Agency cdm_personidentificationissuingagency

Competency entities

Name Entity
Skill Type cdm_skilltype

Entity relationship models

Worker

Worker

Job and Job Position

Job and Job Position

Benefits

Benefits

Compensation

Compensation

Leave

Leave

Work Calendar

Work Calendar

See also

Choose a data integration technology
Configure Common Data Service integration