You are here:
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.
This table shows the fields in the Employee2, Account, Contact, and User objects.
| Employee2 | Account | Contact | User |
|---|---|---|---|
| EmployeeNumber | Salutation | Salutation | SmallPhotoUrl |
| EmployeeType | LastName | LastName | MediumPhotoUrl |
| StatusStartDate | FirstName | FirstName | FullPhotoUrl |
| StatusEndDate | PersonBirthDate | Birthdate | BannerPhotoUrl |
| EmploymentType | PersonEmail | AboutMe | |
| AlternateEmail | PersonHomePhone | HomePhone | |
| InternalOrganizationUnitId | PersonGender | ||
| EmployeeStatus | PersonReportsToId | ||
| ContactId | |||
| UserId |
This table shows the lookup fields in the HR Service data model.
| 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 |
