Salesforce Docs Portal

HR Service Data Model

At the heart of the HR Service solution is the HR Service data model. The data model comprises several Salesforce objects for storing information about your company's employees.

Required Editions

View supported editions.

The HR Service data model represents employees through a virtual object called Person Account and an extension object called Employee2. The Person Account object is made up of the Account and Contact objects. The Employee2 object maintains a 1:1 master-detail relationship with the Contact object and stores employee-specific fields and relationships. For other fields, the data model either reuses or maps with the Contact and Account objects.

The data model also works with integrations with human capital management (HCM) systems, such as Workday. The integration automates the creation and periodic synchronization of employee records to keep them up to date with the data in the HCM system. See the Employee Service Data Model.

HR Service doc data model diagram

This table lists the HR Service-specific objects and the Salesforce platform objects that HR Service consumes, along with the fields from those objects that HR Service uses.

HR Service objects and consumed Salesforce platform objects
Object Object Type Fields Used by HR Service
Account Salesforce Platform
  • FirstName
  • LastName
  • PersonBirthDate
  • PersonEmail
  • PersonGender
  • PersonHomePhone
  • PersonReportsTo
  • Salutation
Contact Salesforce Platform
  • Birthdate
  • FirstName
  • Email
  • HomePhone
  • LastName
  • Salutation
ComplaintCase HR Service All fields
ComplaintParticipant HR Service All fields
Employee2 HR Service All fields
EmpUserProvisioningProcess HR Service All fields
EmpUserProvisionProcessErr HR Service All fields
ExtlIntrIdMapping HR Service All fields
InternalOrganizationUnit HR Service All fields
PublicComplaint HR Service All fields
User Salesforce Platform
  • AboutMe
  • BannerPhotoUrl
  • FullPhotoUrl
  • MediumBannerPhotoUrl
  • SmallPhotoUrl

This table shows the lookup fields in the HR Service data model.

HR Service lookup fields
Object Lookup Field
Account PersonReportsToId
Contact IndividualId
Contact ReportsToId
Employee2 InternalOrganizationUnitId
Employee2 ContactId
Employee2 UserId
User ContactId
User AccountId
User BannerPhotoUrl
User SmallPhotoUrl
User MediumPhotoUrl
User FullPhotoUrl