Software 101 – Database Part 1

Merge Jobs

When merging jobs, the following steps will move the job assessments from the moving position to the target position.  This will not update the set job target to the combination of the two jobs.  The user would need to adjust that accordingly.

For Behavioral Assessments linked to the moving job, they will not move to the new job.

1. In Salesforce, locate and copy the PI ID from the company’s Account page.

2. Open up SQLQuery

3. Run query:

select *
from position p
inner join Company c on p.Companyid = c.CompanyId
where c.apicompanyID= ‘PI ID’ and p.isarchived = 0

4. The results will provide positionID’s — copy these numbers

5. Insert the PositionID’s in the stored procedure below and execute.  **The second PositionID will be the job that the other job is merged into.

  • exec [Support].[Merge_Positions] ‘PositionID 1’, ‘PositionID 2’

Test your knowledge

Answer the questions below by clicking the ‘Start Quiz’ button. The tasks should be completed in the database to answer each question. After completing the quiz click the ‘Mark Complete & Next Lesson’ button.

Copy link