The merge collects every crew id each store claims for a person, then validates all of them in one query against this org's crews. The person keeps whichever claim survives; unrecognised ids become null.
Also called: guy vanished off his crew · stale crew assignment · wrong tenant's crew
- 1claimCrew records each store's claim per person index rather than taking the first non-null.
- 2One query selects crews in this org matching any referenced id.
- 3Each person's crewId becomes the first claim that this org actually owns, else null.
A crew member vanished off his own crew's roster while his record sat there intact — it was pointing at a crew belonging to an entirely different company, left behind by an old import, and that stale value was beating the real one. Any crew reference that does not name a crew this company actually owns is dropped rather than trusted. One check, and a whole class of stale membership data becomes harmless instead of invisible.
- Stale cross-tenant crew ids winning over correct local ones.
- People silently missing from their own crew's roster.
See it on your own jobs
Twenty minutes, your numbers, no slide deck. We’ll build one of your real buildings in front of you and send you the estimate link at the end — yours to keep either way.
or keep browsing features →