How to best use the HR Job [sn_hr_core_job] and HR Position [sn_hr_core_position] Tables

[Community Alums]

New York introduced the HR Job [sn_hr_core_job] table, and the documentation describes how this table's intent is to "store multiple job records per user and capture the job history of users within your organization". 

Where does this leave the role of the HR Position [sn_hr_core_position] table? There is little documentation to describe its purpose, and it only has a few fields that seem to be present in the Job table. It is used in Org chart views, though.

Also, the relationships between these tables and the HR Profile table seem to be somewhat repetitive and circular.

How should we use these tables moving forward? We're going to need to add some logic to keep these in sync...

[Kiel Sanders · Accepted solution]

The Jobs table is intended to track an employee's job history for use within the HR product. One use case for this would be to evaluate past job against new job for determining required activities during employee transfers. Another example would be for supporting employees that have split jobs/multiple job roles and filing cases against the correct job.

In terms of configuration, each Job record is associated to a Position. Position remains on the HR Profile still for customers not using the Job table. To avoid confusion and conflict between the two areas when using Jobs, there's a "Primary" checkbox field on Jobs records that will automatically sync and update that job record data to the relevant HR Profile fields.

You can learn more on the Capturing multiple job records for a user page in product documentation.

[Mrman]

@Kiel Sanders Could you please let me know if there is any script to sync the 'Primary job' field on HR profile once the 'primary' checkbox is selected on saved on JOb record .

[Kiel Sanders]

Yes, there is a Business Rule called "Synchronize primary job to HR Profile" to do exactly this.

[Nat Iyer]

Thanks Kiel. There is a string field "Position Code" in HR Profile table that has no linkage to the Position table. What is the purpose of this field?

Further, Position typically has two components - a code/number and a title. However, the Position table has only one column (string). Is it okay to add Position code/number as an extension?

Appreciate your thoughts.

Nat Iyer