I keep running into an issue with the Update Occupant Features GP tool (Pro 3.6.4) that is becoming problematic to our workflow. We use the Home Office function in Space Planner, where the Occupant assignment record gets set to "Area ID = 0". When running the Update Occupants Features tool, if an existing Home Office occupant is later assigned a Unit, their Home Office assignment record is not removed from the table, and a second record is created for their new Unit assignment. Is this expected behavior? I would think most would want the tool to essentially "move" the user based on the new assignment (i.e. delete the record with the Home Office assignment and create a new record with the Unit they've been assigned.)
In this case I had both "Insert new occupants" and "Delete occupants not included in the Input Occupant Table" options unchecked, as I only want it to update assignments for existing Occupants. I also had a "Where" query for Home Office Identifier set—not that I was moving anyone to a "Home Office" but because the tool documentation says that if there's no query there then those with a Home Office assignment won't be updated.
For now I've written a script that finds Occupants who have multiple assignments, where at least one has "Area ID = 0", and then removes that record with the Home Assignment if was not the most recently created of the group. It would be great if the Update Occupants Tool could handle this, however.
