Payroll employee

Applies to these Dynamics 365 apps:
Human Resources

This topic provides details and an example query for the Payroll employee entity in Dynamics 365 Human Resources.

Properties

Property
Physical name
Type
Use Description
Personnel number
mshr_personnelnumber
String
Read-only
Required
The employee's unique personnel number.
Primary field
mshr_primaryfield
String
Required
System generated
Last name
mshr_lastname
String
Read only
Required
Employee last name.
Legal entity ID
mshr_legalentityID
String
Read-only
Required
Specifies the legal entity (company).
Valid from
mshr_namevalidfrom
Date Time Offset
Read-only
Required
Date the employee information is valid from.
Gender
mshr_gender
Int32
Read-only
Required
The employee's gender.
Payroll employee entity ID
mshr_payrollemployeeentityid
GUID
Required
System generated
A system-generated GUID value to uniquely identify the employee.
Employment start date
mshr_employmentstartdate
Date time offset
Read-only
Required
The start date of the employee's employment.
Identification type ID
mshr_identificationtypeid
String
Read-only
Required
The identification type defined for the employee.
Employment end date
mshr_employmentenddate
Date time offset
Read-only
Required
The end of the employee's employment.
Data area ID
mshr_dataareaid_id
GUID
Required
System generated
System-generated GUID value identifying the legal entity (company).
Valid to
mshr_namevalidto
Date Time Offset
Read-only
Required
Date the employee information is valid to.
Birth date
mshr_birthdate
Date Time Offset
Read-only
Required
The employee's birth date
Identification number to
mshr_identificationnumber
String
Read-only
Required
The identification number defined for the employee.
First name
mshr_firstname
String
Read-only
Required
Employee first name.
Middle name
mshr_middlename
String
Read-only
Required
Employee middle name.

Example query for Payroll employee

Request

GET [Organizaton URI]/api/data/v9.1/mshr_payrollemployeeentities?$filter=mshr_personnelnumber eq @personnelnumber and mshr_identificationtypeid eq @idtype and mshr_namevalidfrom le @asofdate and mshr_namevalidto ge @asofdate&@personnelnumber='000041'&@idtype='SSN'&@asofdate=2021-04-01

Response

{
	     "mshr_legalentityid": "USMF",
            "mshr_personnelnumber": "000041",
            "mshr_employmentstartdate": "2011-04-05T07:00:00Z",
            "mshr_employmentenddate": "2154-12-31T23:59:59Z",
            "mshr_firstname": "Cassie",
            "mshr_middlename": "Lassie",
            "mshr_lastname": "Hicks",
            "mshr_namevalidfrom": "2021-03-12T20:34:25Z",
            "mshr_namevalidto": "2154-12-31T23:59:59Z",
            "mshr_birthdate": "1987-09-12T00:00:00Z",
            "mshr_gender": 200000002,
            "mshr_identificationtypeid": "SSN",
            "mshr_identificationnumber": "888-99-9342",
            "mshr_dataareaid": "USMF",
            "mshr_primaryfield": "000041 | USMF | 4/5/2011 07:00:00 am",
            "_mshr_fk_worker_id_value": "000000ad-0000-0000-d5ff-004105000000",
            "_mshr_fk_employment_id_value": "00000d0d-0000-0000-0600-014105000000",
            "_mshr_fk_fixedcompplan_id_value": "0000029f-0000-0000-d5ff-004105000000",
            "mshr_payrollemployeeentityid": "00000d3c-0000-0000-d5ff-004105000000",
            "_mshr_dataareaid_id_value": null
}