update tgi_lims_status metrics to work with new bridge table