Capturing multiple job records for a user
Summarize
Summary of Capturing multiple job records for a user
ServiceNow’s new Jobs (snhrcorejob) table enables organizations to store and manage multiple job records per user, capturing detailed job history within the HR system. This capability allows HR cases to be linked to specific job records, providing clarity and precision when managing employee lifecycle events such as payroll discrepancies, onboarding, or transfers.
Show less
Key Features
- Multiple job records per user: The Jobs table tracks all job positions held by an employee, including start and end dates for each role.
- Primary job reference: The HR Profile (snhrcoreprofile) table references the Jobs table to identify the user’s primary job, which is displayed in employment information related lists.
- Job-specific HR cases: The HR Case (snhrcorecase) table includes a reference field (subjectpersonjob) linking cases to specific job records, enabling accurate case association.
- Lifecycle event support: Cases such as onboarding or transfers can be tied to the relevant job record, ensuring that activities and workflows trigger based on the correct job context.
Key Outcomes
- Enhanced accuracy in HR case management by associating cases with specific jobs, especially useful when employees hold or have held multiple roles.
- Improved tracking of job history and employment status within the HR system, reflecting rehires and role changes clearly.
- Better support for lifecycle events, ensuring downstream processes are aligned with the employee’s current or relevant job information.
Capture multiple job records for a user with the new Jobs (sn_hr_core_job) table. When creating HR cases, you can specify which job the case pertains to. For example, say that you have a payroll discrepancy case and the employee has two associated job records. When the case is created, you can specify which job the case is for.
Jobs table overview
Beginning in the New York release, you can use the new Jobs (sn_hr_core_job) table to store multiple job records per user and capture the job history of users within your organization.
Jobs table and HR Profile table
The HR Profile table has a reference to the Jobs table for the user's primary job.
| Field | Description |
|---|---|
primary_job
|
Reference field to the Jobs (sn_hr_core_job) table. |
For example, the following HR profile record is for Eva Seahorn. Eva was first hired as a UX designer in May 2017. In August 2018, Eva left the company. In June 2019, Eva was rehired as a marketing director. Eva has two associated job records, with the marketing director position as Eva's primary job.
- In the Employment Information related list, information about the primary job is displayed.
- In the Jobs related list, all of the associated job records are displayed.
Jobs table and HR Case table
The HR Case table has a reference to the Jobs table for the subject person's job.
| Field | Description |
|---|---|
| subject_person_job | Reference field to the Jobs (sn_hr_core_job) table. |
In the case of Eva Seahorn, for example, Eva was rehired as a marketing director in June 2019. Eva has two associated job records. When an onboarding case is created for Eva, the subject_person_job field enables you to specify which job the onboarding case pertains to. The onboarding case would be for the marketing director job Eva was rehired for.
Supporting multiple jobs in a lifecycle event
Use the Jobs table to create lifecycle event cases where you can specify which job the case pertains to. For example, say that you have an intern that is being transferred to a full-time position. The intern has two associated job records. When an onboarding case for the full-time position is created, the case is associated with the full-time job record, ensuring that downstream activity sets and activities are triggered based on information from that relevant job record. For more information, see Support multiple jobs in a lifecycle event.