Capturing multiple job records for a user

  • Release version: Zurich
  • Updated July 31, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Capturing multiple job records for a user

    ServiceNow's Zurich release introduces theJobs (snhrcorejob)table, enabling organizations to store multiple job records for a single user and track their job history within the HR system. This feature allows HR cases to specify the exact job record relevant to the case, supporting more precise case management, especially when users have held multiple roles over time.

    Show full answer Show less

    Jobs Table and HR Profile Integration

    The HR Profile (snhrcoreprofile) table references the Jobs table through a primaryjob field, indicating the user's main active job. While the HR Profile displays employment information related to the primary job, the Jobs table maintains all job records associated with the user, including historical roles.

    For example, if an employee left the company and was later rehired in a different role, both job records are stored and linked. The employment start date reflects the user's overall tenure, while the job start date corresponds to the beginning of the current primary job.

    Jobs Table and HR Case Integration

    HR cases reference the Jobs table via the subjectpersonjob field, allowing cases to be linked to the specific job relevant to the case. This is particularly useful for scenarios such as payroll discrepancies or onboarding, where the case must be associated with a particular job record rather than just the user.

    Supporting Multiple Jobs in Lifecycle Events

    The Jobs table enables lifecycle event cases to be tied to specific job records. For example, if an intern transitions to a full-time position (with two job records existing), onboarding cases can be linked to the full-time job record. This ensures that downstream activities and workflows trigger based on the correct job data, improving accuracy and efficiency in HR processes.

    Practical Benefits for ServiceNow Customers

    • Accurately track multiple job roles and job histories for employees within the HR system.
    • Specify the relevant job for HR cases, improving case resolution and data precision.
    • Support complex employee lifecycle events with multiple job roles, ensuring correct workflows and activity sets are applied.
    • Leverage the Jobs table to maintain comprehensive employment records that reflect real-world organizational changes.

    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.

    Table 1. HR Profile (sn_hr_core_profile) table
    Field Description
    primary_job
    • Job start date
    • Job end date
    		 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.
    Note:
    The employment start date represents the first day the user was employed with the organization. The job start date represents the first day of the user's current primary job. Because Eva left the organization in August 2018, but was rehired in June 2019. This represents Eva's new employment start date.

    HR profile record with multiple job records.

    Jobs table and HR Case table

    The HR Case table has a reference to the Jobs table for the subject person's job.

    Table 2. HR Case (sn_hr_core_case) table
    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.