Update affiliate tracking tables when lead status changes

Your affiliate lead updates can miss partner mapping and break reporting. Keep tracking tables current so billing and program managers reconcile referrals before the monthly close.