Tricky~21min

The Change Order Paid Without Approval

10 change orders were paid out while still pending or rejected — the payment run isn't actually checking approval status before releasing funds. 20 more change orders were paid under an approval_status of approved_verbal — a legitimate regional practice where a site manager approves by phone, not a violation.

Tables you'll query

change_orderspayments

What you'll learn

JOINs
Investigate this case →