Tracking Position Name and Business Unit Changes Over Time
This query compares the current and previous names and business units of selected positions as of a given effective date. It identifies the most recent updates to each position, showing when changes occurred and what the previous values were. This helps track organizational structure changes and supports audits or reporting on historical position movements.