Order feed
“Order IDs are unique.”
Marcus Lee, at the kickoff call
SELECT count(*), count(DISTINCT order_id) FROM erp.orders
3,840 of 120,000 orders repeat an ID
Unique on order ID plus order date. Passes.
“Those are from the 2023 migration. Order ID plus order date is unique.”
Marcus Lee replied and confirmed by email
Coding agent read the rule over MCP and wrote the dedupe step