Looking for a query for insurance codes in a given date range for a particular insurance. In other words, I need to know how many prophys where done between May 07 and Sept. 07 for Delta Dental.
Thanks
Guillermo
Procedure Quote -Date Range- Carrier Querry
Re: Procedure Quote -Date Range- Carrier Querry
Do you want a list of the patients who had those prophies or just a total number? If it's a total number, is it just for prophies or for all codes?
Jorge Bonilla, DMD
Jorge Bonilla, DMD
Jorge Bonilla DMD
Open Dental user since May 2005
Open Dental user since May 2005
Re: Procedure Quote -Date Range- Carrier Querry
This query will give you a list of the patients with a count and the date of each prophy. It includes both adult and child prophies for all Delta plans.
SET @pos=0;
SELECT @pos:=@pos+1 as numberofpatients, carrier.CarrierName,procedurelog.ProcDate,patient.LName,patient.Fname
FROM patient,carrier,insplan,procedurelog,procedurecode
WHERE patient.PatNum=insplan.Subscriber
AND insplan.CarrierNum=carrier.CarrierNum
AND carrier.CarrierName LIKE '%Delta%'
AND patient.PatNum=procedurelog.PatNum
AND procedurelog.ProcDate>='2007-05-01'
AND procedurelog.ProcDate<='2007-09-30'
AND procedurelog.CodeNum=procedurecode.CodeNum
AND procedurecode.ProcCode LIKE '%D11%'
ORDER BY procedurelog.ProcDate
Is this what you need?
Jorge Bonilla, DMD
SET @pos=0;
SELECT @pos:=@pos+1 as numberofpatients, carrier.CarrierName,procedurelog.ProcDate,patient.LName,patient.Fname
FROM patient,carrier,insplan,procedurelog,procedurecode
WHERE patient.PatNum=insplan.Subscriber
AND insplan.CarrierNum=carrier.CarrierNum
AND carrier.CarrierName LIKE '%Delta%'
AND patient.PatNum=procedurelog.PatNum
AND procedurelog.ProcDate>='2007-05-01'
AND procedurelog.ProcDate<='2007-09-30'
AND procedurelog.CodeNum=procedurecode.CodeNum
AND procedurecode.ProcCode LIKE '%D11%'
ORDER BY procedurelog.ProcDate
Is this what you need?
Jorge Bonilla, DMD
Jorge Bonilla DMD
Open Dental user since May 2005
Open Dental user since May 2005
Re: Procedure Quote -Date Range- Carrier Querry
Thanks Jorge; you are the best. Worked like a charm.