![open dental user query examples open dental user query examples](https://www.opendental.com/manual/images/queryVariables.gif)
*Query code written/modified:, :MatG */
![open dental user query examples open dental user query examples](https://www.opendental.com/manual/images/refsPaths.gif)
This is another way of getting a Christmas card list without filtering out patients who have not been in for a while. *37 A list of all guarantors of patients with an active status. PatStatus = 0Ī list of all guarantors of patients with an active status - This is another way of getting a Christmas card list without filtering out patients who have not been in for a while. *36 A list of patients seen between two dates (based on procedures completed in date range). *16*/ SELECT SUM(procedurelog.ProcFee),patient.GradeSchoolĪND procedurelog.ProcDate >= ' 2005 - 10 - 01 'ĪND procedurelog.ProcDate = ' 2005 - 10 - 01 'Ī list of patients seen between two dates (based on procedures completed in date range). For versions greater than 7.3, replace GradeSchool with SiteNum to get the query to work. INNER JOIN refattach ON referral.ReferralNum=refattach.ReferralNumĪND refattach.RefType = 1 /*Is From referrals*/ĪND refattach.RefDate BETWEEN AND BY referral.ReferralNumįor public health clinics, the production by gradeschool. *Change dates between the ' ' in format 'YYYY -mm -dd '*/
OPEN DENTAL USER QUERY EXAMPLES UPDATE
Please update your version accordingly.*/ *15 A list of all referrals you have received for a user specific date range.įor Versions 17.1 and greater. Shows how many patients referred by each source in the date range. WHERE pl.ProcStatus = 2 - Completed proceduresĪND pl.ProcDate BETWEEN AND - Date limitationĪ list of all referrals you have received for a user specific date range - For Versions 17.1 and greater. *Query code written/modified: :SalinaK*/įORMAT(AVG(pl.ProcFee * (pl.UnitQty + pl.BaseUnits)),2) AS '$AvgFee_ ',įORMAT(SUM(pl.ProcFee * (pl.UnitQty + pl.BaseUnits)),2) AS '$TotFee_ ' *14 Daily Procedures: Grouped by Procedure Code. *11 OBSOLETE, if you need a query like this one, you must request it from us or compose it */ SELECT definition.ItemName,SUM(claimproc.FeeBilled) AS ProductionĪND claimproc.ProcDate >= ' 2005 - 04 - 01 'ĪND claimproc.ProcDate = ' 2005 - 09 - 01 'ĭaily Procedures: Grouped by Procedure Code. So, it will never include private pay, and if you billed with UCR fees showing, it will use those fees, which are higher. OBSOLETE Production by fee schedule for date range - OBSOLETE This is a useful report, but please note that the amounts are taken from claims you 've sent. ,BalTotal,InsEst,BalTotal -InsEst AS $pat,ĭATE_FORMAT( MAX( paysplit. *6 */ SELECT CONCAT(LName, ', ',FName, ' ',MiddleI) Status = '4 ')Īging report which includes date of last payment - The last payment date is only for payments entered on the guarantor of the family. InsPayAmt) as $AmtįROM claimpayment,claimproc,insplan,patient,carrier ChartNumberĭaily Insurance payments organized by chart number - In the example, for 7 / 29 / 2005ĬONCAT( patient.
![open dental user query examples open dental user query examples](https://toolspond.com/wp-content/uploads/2021/06/Open-Dental-vs-Dentrix-The-best-guide-to-software-for-the-dental-management.jpg)
DateEntry =CURDATE() /* Replace =CURDATE() with ='' including apostrophes */ WHERE SUBSTRING(Birthdate, 6, 5) >= '10-06 'ĪND payment. *3 */ SELECT LName,FName,Address,Address2,City,State,Zip,Birthdate ProcStatus = 1 - Treatment Plannedīirthday postcards for a one week range - In the example, from 10 / 06 to 10 / 13 ,IF( - Display middle initial if we have one *- Do not modify under this line - */ĬONCAT( - Build a name string like OD's default *2 All treatment planned procedures, ordered by patient */ Results will only include queries that match ALL selected categories.Īll claims that are currently open that were sent on a given day - change DateSent value as neededĪll treatment planned procedures, ordered by patient - See also #50 & #56
![open dental user query examples open dental user query examples](https://i.ytimg.com/vi/jGysjaGCNDQ/maxresdefault.jpg)
If you need help finding a query, modifying a query, or would like a custom query, fill out and submit a Query Request Form Look at the query comments for variable descriptions. If needed, change any required variables before running. If you find a query you like, copy /paste the query into Open Dental to run it. We recommend looking at higher numbered queries first, because older queries may not work in new versions. Queries are sorted chronologically, with queries written for older versions listed first and queries written for newer versions listed last. There may be additional changes needed to return the results you want. These query examples were written for other practices, usually for a specific purpose. Home Welcome to the Open Dental Query Examples Page