The right column. The wrong result.
The agent used the correct column. Finance's number was still $1.4M lower. The exclusion rules that explain the gap exist nowhere in the schema.
Finance had moved to mrr_contracted after mrr_monthly diverged for annual accounts. The agent used it. Correct column. The agent returned $4.2M. Finance expected $2.8M. The gap was $1.4M.
Finance applies three exclusion rules every time it runs this report. None of them are in the schema.
Trial extensions excluded: accounts where trial_extension_end is later than the period end date are removed. The flag exists in the table. The rule for when to apply it never made it into documentation. That removes $480K.
Internal accounts excluded: is_internal = true must be filtered out. The field is there. The mrr_contracted documentation says nothing about it. That removes $320K. Churn-scheduled accounts excluded: accounts with a churn_scheduled_date within 30 days of period end are pulled for board reporting. The field exists; the rule lives in a runbook. That removes $600K.
The agent used the right column. The exclusion logic that defines Finance's number lives in a runbook.
