Task

A company is integrating a new workforce planning platform with its existing HR system. Write a SQL query to ensure data accuracy by identifying discrepancies in employee records between the two systems.

Requirements

1. Join the employees table from the HR system with the workforce_planning table using employee_id.
2. Identify employees that exist in the HR system but are missing from the workforce planning platform.
3. Include a flag to indicate if the employee is active in the HR system.
4. Return only those employees with discrepancies in their records.

Schema

employees (employee_id, name, active, department)

workforce_planning (employee_id, name, position)

Expected Output