Refreshed data 12/1/2020 billing_data bd organization org ON bd.org_id_ma = org.id billing_report_todo brtd ON brtd.org_id = org.id buildings bldg ON bd.building_id_ma = bldg.id department dpt ON dpt.id = bd.dept_id_ma machines mac ON bd.model_id = mac.id machine_types mt ON ma.model_type = mt.id tblContacts tbc ON tbc.org_id_contact = bd.org_id_ma AND tbc.decision_maker = 'Yes' (2171 didn't go in. Said dupe, but wasn't) No need to refresh these 2 tables lkp_school_year looksy ON looksy.yr_id = brtd.school_year lkp_billing_cycle lookbill ON lookbill.billing_cycle_id = bd.billing_cycle