7.5Billed ContactsBreakdown of patients with procedures billed to insurance companies with amounts.Jeff BuchbindercenterProvider:module:providermoduleFreeMEDpatient AS pt, icd9 AS icd, cpt AS cpt, procrec AS proc, coverage AS cov, insco AS i, authorizations AS auth
proc.procphysician=$provider AND proc.procpatient=pt.id AND proc.procdiag1=icd.id AND proc.proccpt=cpt.id AND proc.proccurcovid=cov.id AND cov.covinsco=i.id AND (proc.procauth = 0 OR proc.procauth=auth.id)
proc.id'Date Billed'001111260left3060left1260left860left860left660left860left3060left3060left48026811columns00011111