Search found 503 matches
- Thu Nov 13, 2008 12:11 pm
- Forum: Main Forum
- Topic: Open Dental enforces distinct tooth surfaces
- Replies: 3
- Views: 5554
Re: Open Dental enforces distinct tooth surfaces
My experience has been that no insurance will pay for an OOL filling. They only allow you to bill once for each surface. There might be exceptions but I've never seen any.
- Thu Nov 13, 2008 12:00 pm
- Forum: Main Forum
- Topic: Which fee schedule should I set up?
- Replies: 3
- Views: 4118
Re: Which fee schedule should I set up?
Make a fee schedule for every insurance company you contract with. You can set the type of plan (probably PPO percentage), the fee schedule and the percentages in the insurance plan edit window for the patient.
- Wed Nov 12, 2008 12:52 pm
- Forum: Main Forum
- Topic: Printing the Chart?
- Replies: 2
- Views: 3641
Re: Printing the Chart?
Try Alt and PrntScrn in the big version of the chart. Then paste to the images module and print from there.
- Mon Nov 10, 2008 3:57 pm
- Forum: Main Forum
- Topic: Preauthorization
- Replies: 1
- Views: 2979
Re: Preauthorization
The way we do it is different, and it works for us: 1. Add the preauth from the treatment plan module. 2. Wait for the insurance co to reply 3. Edit any incorrect amount by double clicking the procedure in the Tx plan module and then double clicking the line under "insurance estimates and payments" ...
- Sat Oct 18, 2008 12:45 pm
- Forum: Main Forum
- Topic: No Tx Plan on appointment window(v6.1.1)
- Replies: 5
- Views: 5493
Re: No Tx Plan on appointment window(v6.1.1)
I haven't upgraded to 6.1 yet, so I'm not sure you're talking about the same thing. Do you mean that on 6.1, when you double click on an appointment, the only procedures that show are the ones tied to that appointment? Almost every day, specially with initial patient visits, I edit the appointment t...
- Tue Oct 14, 2008 2:51 pm
- Forum: Advanced Topics
- Topic: bug?: Ext graphic not showing for pri teeth
- Replies: 7
- Views: 7633
Re: bug?: Ext graphic not showing for pri teeth
Works for me too. Using Vista and version 6.0.4
- Fri Oct 10, 2008 1:20 pm
- Forum: Main Forum
- Topic: Patient recall address different from billing address
- Replies: 2
- Views: 3725
Re: Patient recall address different from billing address
You have to make the parent who gets the bills the guarantor (by selecting the patient in the family module and then clicking on Set Guarantor). Then make sure this patient has the address were bills should be sent. Then you select the record for the patient you want to send the recall postcard to. ...
- Fri Sep 26, 2008 6:32 pm
- Forum: Advanced Topics
- Topic: "Blue Book" Ins Ests?
- Replies: 16
- Views: 14587
Re: "Blue Book" Ins Ests?
In my office we've used the allowed fee schedules feature extensively, so we've had something like a Bluebook for a long time. We see a few of those plans where they pay less than the regular carrier fee, so our solution has been to treat those plans as distinct carriers. For example, there is a car...
- Thu Sep 25, 2008 1:39 pm
- Forum: Main Forum
- Topic: Query question
- Replies: 6
- Views: 6978
Re: Query question
I would also suggest you add a line to select only those patients that are not inactive, archived or deceased using the following as one of the conditions:
AND patient.PatStatus = '0'
Jorge Bonilla, DMD
AND patient.PatStatus = '0'
Jorge Bonilla, DMD
- Thu Sep 25, 2008 1:27 pm
- Forum: Main Forum
- Topic: Query question
- Replies: 6
- Views: 6978
Re: Query question
To remove the time you can change it as follows: SET @pos=0; SELECT @pos:=@pos+1 as numberofpatients, patient.LName,patient.FName,patient.Address,patient.Address2,patient.City,patient.State,patient.Zip, Date_Format(MAX(procedurelog.procdate),'%m/%d/%y') as DATE FROM patient,procedurelog WHERE proced...
- Thu Sep 25, 2008 12:43 pm
- Forum: Main Forum
- Topic: Query question
- Replies: 6
- Views: 6978
Re: Query question
Sorry you had problems. I had fixed that query after it was posted. The query you need is as follows: SET @pos=0; SELECT @pos:=@pos+1 as numberofpatients, patient.LName,patient.FName,patient.Address,patient.Address2,patient.City,patient.State,patient.Zip, MAX(procedurelog.procdate) FROM patient,proc...
- Wed Sep 24, 2008 1:34 pm
- Forum: Main Forum
- Topic: Pt. with balance suddenly has zero balance
- Replies: 7
- Views: 7711
Re: Pt. with balance suddenly has zero balance
I doubt that the software has the ability to do something like that on it's own. Have you asked your employees about it? Maybe one of them made the entries thinking that the patient had paid or that the debt had been written off. We are running that same version at our office and haven't noticed any...
- Thu Sep 11, 2008 11:11 am
- Forum: Main Forum
- Topic: 4 piece Rx paper
- Replies: 6
- Views: 9589
Re: 4 piece Rx paper
Is it possible to separate all four pieces and then print each individually as separate pages? Where can we buy this paper?
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Wed Sep 10, 2008 1:26 pm
- Forum: Main Forum
- Topic: ? about the labels
- Replies: 5
- Views: 6807
Re: ? about the labels
You can print labels for your panos and even for patient folders. Now that you can customize them you can use them for practically anything.
- Wed Sep 10, 2008 1:21 pm
- Forum: Main Forum
- Topic: Beta or Stable version
- Replies: 2
- Views: 3917
Re: Beta or Stable version
I use only stable releases at the office, but the version I keep at home is always Beta. The reason for this is that I have more time at home to play with the Beta version. When I find a bug I have time to find out when and how it happens and then I can send an e-mail to Jordan with specific informa...
- Thu Aug 28, 2008 3:36 pm
- Forum: Main Forum
- Topic: Help w/query that includes user-defined field
- Replies: 3
- Views: 4057
Re: Help w/query that includes user-defined field
The patfield table contains all the info you need to add to the patient table for the report you want. The fields that you may need are patfield.FieldName, patfield.FieldValue and you can use patfield.PatNum as a link to the patient table. If you have more than one patient field defined, then you wi...
- Sat Aug 23, 2008 7:00 pm
- Forum: Main Forum
- Topic: referal slips.
- Replies: 6
- Views: 6233
Re: referal slips.
That would be the doctor we are referring the patient to. It's not something really crucial, since we normally write this info on the envelope we put the referral slip in so the patient can call for an appointment. Maybe some of us don't use envelopes, in that case it would be necessary to have that...
- Sat Aug 23, 2008 6:22 am
- Forum: Main Forum
- Topic: Copay Fee Schedules
- Replies: 5
- Views: 5858
Re: Copay Fee Schedules
The software doesn't have this feature yet, but I think it would be a great addition. Right now what we do is that whenever we see $0 in the treatment plan we edit the amount manually.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Sat Aug 23, 2008 6:18 am
- Forum: Main Forum
- Topic: referal slips.
- Replies: 6
- Views: 6233
Re: referal slips.
I was about to ask the same thing. We need to have the doctor's specialty and phone number on the referral slip.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Wed Aug 20, 2008 4:00 pm
- Forum: Main Forum
- Topic: Setting an appointment complete
- Replies: 4
- Views: 4709
Re: Setting an appointment complete
I forgot to add that some offices may not use the appointment book feature of Open Dental. Their only option is to Set Complete from the chart.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Wed Aug 20, 2008 3:57 pm
- Forum: Main Forum
- Topic: Setting an appointment complete
- Replies: 4
- Views: 4709
Re: Setting an appointment complete
This feature is used for instances where you complete treatment in addition to the procedures included in the appointment. For example, a patient has a recall appointment and you Set Complete the appointment, but you then decide to fix a caries on that same appointment instead of having the patient ...
- Tue Aug 19, 2008 1:54 pm
- Forum: Main Forum
- Topic: Favor of theForum.......
- Replies: 11
- Views: 9040
Re: Favor of theForum.......
Go to Windows Control Panel, then Printers. Right click on the printer and check the default printer preferences. This could be the cause.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Tue Aug 12, 2008 2:53 pm
- Forum: Main Forum
- Topic: Charting Questions
- Replies: 8
- Views: 7968
Re: Charting Questions
Open Dental used to have a feature where you could hide graphics by clicking on a checkbox in the procedure edit window. This feature was dropped a couple of years ago when the chart progressively got better and smarter. Still, there are some situations where the chart doesn't reflect the reality an...
- Thu Aug 07, 2008 2:48 pm
- Forum: Advanced Topics
- Topic: Send claim from multiple computers
- Replies: 9
- Views: 10093
Re: Send claim from multiple computers
This will also depend on your clearinghouse. If you use one that has some sort of communications software to upload the claims, you can only send claims from the computer where you have that software installed.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Sun Aug 03, 2008 5:09 am
- Forum: Main Forum
- Topic: Recall postcards
- Replies: 1
- Views: 3761
Re: Recall postcards
We use the ones for laser printers. They come four to a page.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Mon Jul 21, 2008 3:47 pm
- Forum: Advanced Topics
- Topic: Required changes to Rx in Texas
- Replies: 4
- Views: 5079
Re: Required changes to Rx in Texas
Seems like states are folllowing some sort of federal mandate because I received a similar letter stating basically the same things, except for the intended use (that's probably a Texas thing). Down here they also recommend we add our NPI number.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Mon Jul 21, 2008 10:01 am
- Forum: Main Forum
- Topic: New Patients
- Replies: 6
- Views: 6854
Re: New Patients
In our office when a new patient makes an appointment we fill out minimal information (usually name and phone number and in some cases insurance id) and classify them as "Non Patient" until the patient actually shows up. Only then do we fill out all the information and change them to "Patient" statu...
- Fri Jul 18, 2008 1:30 pm
- Forum: Main Forum
- Topic: Electronic Claims
- Replies: 2
- Views: 3574
Re: Electronic Claims
That's a very good price and if it's working well for you I see no reason to change.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Sat May 31, 2008 7:38 am
- Forum: Main Forum
- Topic: Procedure Buttons
- Replies: 8
- Views: 8240
Re: Procedure Buttons
Thanks. I also got some help through pm.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Thu May 29, 2008 1:49 pm
- Forum: Main Forum
- Topic: Procedure Buttons
- Replies: 8
- Views: 8240
Re: Procedure Buttons
If anybody has an icon for full dentures or partial dentures, please let me know.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Thu May 29, 2008 1:09 pm
- Forum: Main Forum
- Topic: Procedure Buttons
- Replies: 8
- Views: 8240
Re: Procedure Buttons
Here's some more: http://i69.photobucket.com/albums/i77/jorgebon/Prefababutment.jpg http://i69.photobucket.com/albums/i77/jorgebon/ImplantCrown.jpg http://i69.photobucket.com/albums/i77/jorgebon/implant.jpg http://i69.photobucket.com/albums/i77/jorgebon/CustomAbutment.jpg http://i69.photobucket.com/...
- Thu May 29, 2008 1:01 pm
- Forum: Main Forum
- Topic: Procedure Buttons
- Replies: 8
- Views: 8240
Re: Procedure Buttons
Yes, you can import more icons. You can either draw them yourself in window's Paint or share from other OD users. I'm not sure how to post them here in this forum but let me try. Jorge Bonilla, DMD http://i69.photobucket.com/albums/i77/jorgebon/Toothnote.jpg http://i69.photobucket.com/albums/i77/jor...
- Tue May 27, 2008 3:11 pm
- Forum: Main Forum
- Topic: Individual patient balance
- Replies: 2
- Views: 3341
Re: Individual patient balance
How about to the right of the family balance, make a box or draw some lines to separate both balances and add the words "individual balance" on top, so there's no possibility of confusing both numbers. The family balance should also be labelled with the word "family" to avoid confusion. Jorge Bonill...
- Tue May 27, 2008 2:33 pm
- Forum: Main Forum
- Topic: Individual patient balance
- Replies: 2
- Views: 3341
Individual patient balance
The new account module format works fine in most aspects, but I would like to suggest that the balance for the individual patient (besides the family total) be displayed somewhere. I can see the estimated patient portion when we make the claim, but still if the patient owes something else besides th...
- Sun May 18, 2008 5:02 pm
- Forum: Main Forum
- Topic: printer problems
- Replies: 12
- Views: 10276
Re: printer problems
When you go to Start/ Printers and faxes (form your desktop's start menu) is the default printer connected to these computers? If not, select one that is or install the one you want that is connected to the network.
- Mon May 12, 2008 4:36 pm
- Forum: Main Forum
- Topic: weighing the big decision
- Replies: 18
- Views: 121720
Re: weighing the big decision
I get a certain feeling of happiness and nostalgia when I read a post from someone who's just starting out. I guess it comes with age. I've been practicing for 23 years in my hometown. I started out with nothing but debt and I went to every bank in town. None of them would help me unless I would go ...
- Sat May 10, 2008 8:14 pm
- Forum: Main Forum
- Topic: Estimated patient portion
- Replies: 1
- Views: 2719
Estimated patient portion
I find that the new line with the estimated patient portion in the account module is only correct if you do not select the "Claims show UCR fee, not billed fee" option in the plan's definition. If you have this option selected, it will calculate the difference between the estimated ins payment and y...
- Fri May 02, 2008 7:29 pm
- Forum: Main Forum
- Topic: question on example query
- Replies: 5
- Views: 5572
Re: question on example query
That's a very good idea, Mifa. DTbar, If you had the database information imported from a previous practice software, then this query might not be the one you want. In any case, you can delete the line that refers to the completed procedures and see what you get. Since I don't know exactly what info...
- Fri May 02, 2008 6:35 pm
- Forum: Main Forum
- Topic: question on example query
- Replies: 5
- Views: 5572
Re: question on example query
Procstatus = '2' means procedures that have been completed. this limits the output of the query to only patients that had previously been seen in the office because only patients who have actually been to the office have completed procedures. I recommend you try a more refined version of this query:...
- Fri Apr 25, 2008 1:49 pm
- Forum: Main Forum
- Topic: getting images out of OD
- Replies: 2
- Views: 3402
Re: getting images out of OD
You can get the images fron the A-Z folder.
- Fri Apr 04, 2008 3:25 pm
- Forum: Main Forum
- Topic: Filing Code - where used?
- Replies: 1
- Views: 2993
Re: Filing Code - where used?
It's used in electronic claims. Although almost all go out with "commercial insurance" there are a few insurance plans that use BCBS (Blue Cross Blue Shield). There's probably other plans that use other filing indicators, but I don't know which ones.
- Tue Apr 01, 2008 5:37 pm
- Forum: Main Forum
- Topic: Multiple codes for the same procedure
- Replies: 3
- Views: 4649
Re: Multiple codes for the same procedure
You can add a new procedure with a new code (in LISTS/PROCEDURE CODES), but just add a letter or number at the end. For example, D1110a. Define it as whatever you want, like "half prophy" and assign a fee to it. When you print the claim form or send it electronically, Open Dental will cut off the la...
- Tue Apr 01, 2008 5:31 pm
- Forum: Main Forum
- Topic: Break Control Button
- Replies: 11
- Views: 9151
Re: Break Control Button
You can "un-break" an appointment easily by double clicking on it and then changing the status back to scheduled.
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Wed Mar 26, 2008 3:33 pm
- Forum: Main Forum
- Topic: Interest From Ins. Co
- Replies: 2
- Views: 3327
Re: Interest From Ins. Co
In our office we just process it normally on the patient's account. We then have a negative balance (like we owe the patient the amount of interest paid). Then we make an adjustment called "Finance Charge" for that same amount to bring the account to $0.
- Mon Mar 24, 2008 6:07 pm
- Forum: Main Forum
- Topic: Rolling back to previous version
- Replies: 3
- Views: 3962
Re: Rolling back to previous version
To go back to a previous version you have to uninstall the new version first. Then reinstall the old version (you need to get it from a backup). When it asks you to select the database, select the one named opendentalbackup date . Where I wrote date should be the date when you updated to the newer v...
- Wed Mar 19, 2008 2:38 pm
- Forum: Advanced Topics
- Topic: Procedure Quote -Date Range- Carrier Querry
- Replies: 3
- Views: 4683
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,ins...
- Wed Mar 19, 2008 1:58 pm
- Forum: Advanced Topics
- Topic: Procedure Quote -Date Range- Carrier Querry
- Replies: 3
- Views: 4683
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
- Fri Mar 14, 2008 3:24 pm
- Forum: Main Forum
- Topic: Private Message link
- Replies: 1
- Views: 3047
Private Message link
Jordan,
I received a PM and the link that is sent in the e-mail alerting me to the PM doesn't work. I went to the forum and opened the message manually.
Jorge Bonilla, DMD
I received a PM and the link that is sent in the e-mail alerting me to the PM doesn't work. I went to the forum and opened the message manually.
Jorge Bonilla, DMD
- Sat Mar 08, 2008 7:20 pm
- Forum: Main Forum
- Topic: I need another query, please !!!!
- Replies: 7
- Views: 8251
And if you want to know what you did to each of the patients that the previous query counted, use this query and it will give you the name of each patient with the procedures done: SET @FromDate= '2007-01-01', @ToDate='2007-12-31'; SELECT patient.PatNum,definition.ItemName,procedurecode.ProcCode, pr...
- Sat Mar 08, 2008 11:58 am
- Forum: Main Forum
- Topic: I need another query, please !!!!
- Replies: 7
- Views: 8251
You could use query #26 or #41 from the examples page. If you need the number of patients, try this: SET @pos=0; SELECT @pos:=@pos+1 as numberofpatients, carrier.CarrierName,patient.* FROM patient,carrier,insplan WHERE patient.PatNum=insplan.Subscriber AND insplan.CarrierNum=carrier.CarrierNum AND c...
- Thu Mar 06, 2008 10:50 am
- Forum: Main Forum
- Topic: I need another query, please !!!!
- Replies: 7
- Views: 8251
I read your post in Dental Town a couple of days ago and my wife and I have been thinking about what we would do if we received the same letter. I think that unless United Concordia has a big chunk of your business, the best thing would be to cancel your contract with them. Anyway, I edited one of t...
- Sun Mar 02, 2008 3:37 pm
- Forum: Main Forum
- Topic: openoffice
- Replies: 3
- Views: 4675
Open Office is very good. The only problem right now is that Open Dental merge letters don't work with OO (I think). You can save documents in MS Office format and you can open MS Office documents in Open Office. If you save in the OO format, then MS Office cannot open it. That's why it's best to al...
- Thu Feb 28, 2008 12:09 pm
- Forum: Main Forum
- Topic: variable for patient age
- Replies: 5
- Views: 5976
- Thu Feb 28, 2008 11:16 am
- Forum: Main Forum
- Topic: variable for patient age
- Replies: 5
- Views: 5976
I like "Teach Yourself SQL in Ten Minutes" by Ben Forta. I got it at Border's. So what you want could be something like a total number of patients within a range. For example, a list and total number of patients under the age of ten. I think the way to keep it simple is to have one query for each ag...
- Tue Feb 26, 2008 2:05 pm
- Forum: Main Forum
- Topic: variable for patient age
- Replies: 5
- Views: 5976
The patient's age is probably the result of a calculation based on the patient's birth date. You can find that in the Patient table. If you tell us what you would like we can probably help you write the query. This is the simplest way to sort by age: select * from patient Order by birthdate Jorge Bo...
- Mon Feb 25, 2008 1:26 pm
- Forum: Main Forum
- Topic: Considering OD for a new office
- Replies: 15
- Views: 16611
Remember when somebody suggested that Jordan design some sort of logo for T-shirts or polo shirts so we could wear them at the dental meetings? Maybe we could still do that for the meeting in San Antonio. If somebody can design it and post it to the website, we could download it and have a local sho...
- Mon Feb 25, 2008 1:20 pm
- Forum: Main Forum
- Topic: export pics
- Replies: 7
- Views: 6905
- Sun Feb 24, 2008 4:07 pm
- Forum: Main Forum
- Topic: export pics
- Replies: 7
- Views: 6905
- Sun Feb 24, 2008 7:03 am
- Forum: Main Forum
- Topic: Considering OD for a new office
- Replies: 15
- Views: 16611
Regarding question #3: In about four months our office will have been running Open Dental for three years. I can tell you that in that time we haven't had any major problems. If we have any questions about how we should do something or if we find something we think is a bug, we just send an e-mail o...
- Sat Feb 23, 2008 5:55 pm
- Forum: Main Forum
- Topic: Database Maintenance
- Replies: 2
- Views: 3694
- Sat Feb 23, 2008 5:50 am
- Forum: Main Forum
- Topic: Database Maintenance
- Replies: 2
- Views: 3694
Database Maintenance
When I run "Database Maintenance" I get "Claim payments with mismatched dates fixed:" and the number of fixed dates. I don't see any difference in dates before and after in the claim or the payment. I'm not really sure what dates are being fixed. Apparently it must be something we do wrong always be...
- Thu Feb 07, 2008 5:52 pm
- Forum: Main Forum
- Topic: Delete alternative treatment plans ?
- Replies: 33
- Views: 27711
Mzrdmd, I can almost always tell the patient what their plan covers and how much they have to pay. We've taken the time to enter fee schedules, copay schedules and allowed fees for practically all the plans we see. So when the patient has all the different options explained I can give them an estima...
- Tue Feb 05, 2008 4:28 pm
- Forum: Main Forum
- Topic: Delete alternative treatment plans ?
- Replies: 33
- Views: 27711
We also try to have the patient decide while in the chair. Nevertheless, there are options like using clinical notes or tooth notes for special cases. It's also good to have it all documented in a narrative. If someone else reads the progress notes, it's better to have a note stating what you explai...
- Tue Jan 29, 2008 1:41 pm
- Forum: Main Forum
- Topic: Ins Benefits
- Replies: 12
- Views: 10996
- Sun Jan 27, 2008 6:37 am
- Forum: Main Forum
- Topic: Server ?
- Replies: 4
- Views: 5969
If you are going to have a maximum of seven computers, you might not even need a real server unless you're going to run some other application that may need it. Open Dental works fine from a regular computer that acts as a central depository of information for the rest of the computers on the networ...
- Sat Jan 26, 2008 5:13 pm
- Forum: Main Forum
- Topic: Alternative Benefit: Changing Composite to Amalgam
- Replies: 4
- Views: 5697
- Sat Jan 26, 2008 11:31 am
- Forum: Main Forum
- Topic: HIPAA and postcards
- Replies: 3
- Views: 8799
- Sun Jan 13, 2008 10:17 am
- Forum: Advanced Topics
- Topic: 'Save Query' option
- Replies: 6
- Views: 7975
I made a small change to your query so you don't have to go in and change the dates all the time. It will now calculate a period of time of 3 months (today minus a 3 month interval) so every day you can get the previous 3 months' referrals. I used a 3 month interval, but you can change that to whate...
- Wed Jan 09, 2008 4:55 pm
- Forum: Main Forum
- Topic: Insurance Estimates
- Replies: 4
- Views: 5064
What we've done in our office is make fee schedules for each insurance company. We obviously obtain fee schedules from all those insurance companies where we have contracts. In those that we don't have contracts, we build an allowed fee schedule from past experience until we have at least the most u...
- Sun Jan 06, 2008 1:00 pm
- Forum: Main Forum
- Topic: Report for patients not seen in 4 or 5 years
- Replies: 14
- Views: 13410
If you transfered all those patients from your other software before adding any current patients, then they can be found through the patient number. They should have numbers one to the total number of imported patients. If that's the case, then you only need to find the first patient you entered (ma...
- Sun Jan 06, 2008 6:25 am
- Forum: Main Forum
- Topic: Report for patients not seen in 4 or 5 years
- Replies: 14
- Views: 13410
OK, I combined what we know about these patients, 1. no procedures in last 4 years 2. datefirstvisit = 0001-01-01 3. classified as patient in family module I came up with this query, but if you have current patients that meet all of these conditions, they will also appear. For example, I tried it on...
- Sun Jan 06, 2008 5:23 am
- Forum: Main Forum
- Topic: Report for patients not seen in 4 or 5 years
- Replies: 14
- Views: 13410
Can you see if there is anything else unique in the group of patients you want ? Do they have anything entered in the chart module (any previous treatment)? Do you know the exact date when these records where created in Open Dental? Are they classified as patients or as non patients in the family mo...
- Sat Jan 05, 2008 9:47 am
- Forum: Main Forum
- Topic: Report for patients not seen in 4 or 5 years
- Replies: 14
- Views: 13410
Try it anyway. I tried it by adding a patient (only the first and last name) to the database. I didn't add any procedures. This query found that patient. I also tried it by trying datefirstvisit is null. That didn't work because apparently the datefirstvisit defaults to 0001-01-01 when you create th...
- Fri Jan 04, 2008 2:41 pm
- Forum: Advanced Topics
- Topic: Updating Info from one Open Dental DB to another...
- Replies: 4
- Views: 5657
If you are not going to make any changes to the database in your office while you are out doing the exams, it would be easy to just use the backup and restore features of Open Dental. On the other hand, if both databases are going to have changes at the same time, there's no way I know of that you c...
- Fri Jan 04, 2008 2:06 pm
- Forum: Main Forum
- Topic: Report for patients not seen in 4 or 5 years
- Replies: 14
- Views: 13410
Sorry, I didn't know they had no procedures. Try this query, it will check for a first visit date and includes only those classified as "patients" (no inactive or dead patients). I am thinking that maybe they have no first visit date since they haven't come in yet from Open Dental's point of view. H...
- Thu Jan 03, 2008 5:20 pm
- Forum: Main Forum
- Topic: Referred from:
- Replies: 5
- Views: 6926
- Thu Jan 03, 2008 2:34 pm
- Forum: Main Forum
- Topic: Report for patients not seen in 4 or 5 years
- Replies: 14
- Views: 13410
This query should do what you want. It will also give a count of how many patients haven't come in. You can change the date in the next to the last line as needed. Copy and paste it to your query window: SET @pos=0; SELECT @pos:=@pos+1 as numberofpatients, patient.LName,patient.FName,patient.Address...
- Thu Jan 03, 2008 1:25 pm
- Forum: Main Forum
- Topic: Ver 5.4 Tooth Chart Graphics
- Replies: 7
- Views: 8869
I find that the chart will look better or worse depending on the background color where the teeth are pictured. I use a slate blue color and it looks great. Maybe a change in the background color can also help those who find the teeth too white. It can be changed in the Setup-Definitions menu. Selec...
- Fri Dec 21, 2007 1:30 pm
- Forum: Main Forum
- Topic: Moving Quadrant in the Claim Form 2006
- Replies: 2
- Views: 4840
The problem with doing that is that then the tooth numbers for other procedures would not print in the form, only the quadrants. As I understand it, quadrants and arches are supposed to print in field 25 (areas of oral cavity) as numbers. I think 10, 20 , 30 and 40 are the quadrants and 01 and 02 ar...
- Sun Dec 16, 2007 5:40 am
- Forum: Main Forum
- Topic: Canadian E-claims
- Replies: 38
- Views: 31209
How about if you guys settle on a compromise. Maybe somebody in Jordan's team can work on a small part of the Canadian claims thing for each version that comes out. It would be good to have a goal for a certain date (or several smaller goals for various dates). This would show progress and the good ...
- Sun Dec 16, 2007 5:13 am
- Forum: Advanced Topics
- Topic: Greetings from Spain
- Replies: 5
- Views: 7757
- Tue Dec 11, 2007 1:22 pm
- Forum: Main Forum
- Topic: New patient report
- Replies: 2
- Views: 4430
- Thu Nov 29, 2007 2:51 pm
- Forum: Main Forum
- Topic: Bar on small box at corner of appt
- Replies: 15
- Views: 16980
- Thu Nov 29, 2007 3:22 am
- Forum: Main Forum
- Topic: Bar on small box at corner of appt
- Replies: 15
- Views: 16980
- Wed Nov 28, 2007 1:57 pm
- Forum: Main Forum
- Topic: Bar on small box at corner of appt
- Replies: 15
- Views: 16980
- Mon Nov 26, 2007 1:57 pm
- Forum: Main Forum
- Topic: Eclaim for crowns
- Replies: 2
- Views: 4751
- Mon Nov 12, 2007 2:19 pm
- Forum: Main Forum
- Topic: optional patient ID & subscriber ID switched??
- Replies: 3
- Views: 6501
I always enter the same number in both the patient ID and the Medicaid ID fields. The patient ID number goes out in electronic claims, and we have a few local plans that use patient ID numbers. They require both the subscriber's ID number and the patient's ID number. On the paper claimforms, you can...
- Sun Nov 04, 2007 1:47 pm
- Forum: Main Forum
- Topic: Fee Schedule Update Service....
- Replies: 4
- Views: 7394
- Thu Nov 01, 2007 7:28 pm
- Forum: Main Forum
- Topic: PPO Percentage
- Replies: 1
- Views: 3797
- Thu Nov 01, 2007 6:09 pm
- Forum: Main Forum
- Topic: PPO Percentage
- Replies: 1
- Views: 3797
PPO Percentage
I was looking at the new PPO Percentage insurance type and noticed that it will make estimates on treatment plans better since it will show our real fees and how much of a discount we give. I'm not really sure when we should use PPO Percentage instead of Category Percentage. Jordan, could you please...
- Mon Oct 29, 2007 5:11 pm
- Forum: Main Forum
- Topic: Ins Substitute Codes
- Replies: 1
- Views: 3950
Ins Substitute Codes
I was looking at the new feature in Beta version 5.3 for substituting insurance codes. I find that it works fine when a plan doesn't cover posterior composites but allows the fee for the corresponding amalgam. I couldn't find a way to inactivate the feature for those plans that do cover posterior co...
- Fri Oct 19, 2007 3:45 pm
- Forum: Main Forum
- Topic: Insurance plan list
- Replies: 7
- Views: 7189
Insurance plan list
After a couple of years of using Open Dental, I find that the insurance plan list is getting very large. I would like to suggest a feature where one could mark a plan as inactive and be able to hide it from the list. This would help for example when you have a group of patients that changes their pl...
- Sat Oct 13, 2007 2:20 pm
- Forum: Main Forum
- Topic: Online RealTime Eligibility & Benefits Checking
- Replies: 4
- Views: 9587
Our experience has been similar, although we use another clearinghouse. The problem is that online eligibility only confirms that the patient is active in a plan, but it doesn't give any information on procedure eligibility. These are the procedures that have time limits like once every 6 months or ...
- Thu Sep 13, 2007 12:43 pm
- Forum: Main Forum
- Topic: Positive Insurance Adjustments / PPOs
- Replies: 18
- Views: 16415
You need to make two fee schedules for this situation. The first one is the fee you expect for every procedure (total ins plan plus patient pays). Then you make another fee schedule and classify it as "allowed fee schedule". In this one you put whatever the plan normally pays for each procedure. Whe...
- Wed Sep 12, 2007 4:37 pm
- Forum: Main Forum
- Topic: Positive Insurance Adjustments / PPOs
- Replies: 18
- Views: 16415
I hope the plans to change the way PPOs are handled doesn't mean you're going to eliminate all the existing ways of using different fee schedules and copay schedules. I'm specially fond of the allowed fee schedules. I still haven't seen a plan we can't give exact or very accurate estimates for using...
- Thu Aug 30, 2007 5:16 pm
- Forum: Main Forum
- Topic: Treatment Plan Procedures and Status of Appointments
- Replies: 6
- Views: 13198
In our office we mark the appointment broken so that it will show in the progress notes, then we delete the appointment and add a note in the appointment module at the same time and date that says "Patient missed appt". It will show with the patient's picture just like an appointment and since the c...
- Fri Aug 17, 2007 5:42 pm
- Forum: Main Forum
- Topic: eclaims vs. date sent bug?
- Replies: 7
- Views: 12239
I actually prefer to send the claims in a batch at the end of the day than sending after each patient. The advantage is that the office manager can have a look at the claims before they're sent and make corrections. Nevertheless, I think in the future when we can get instantaneous responses from all...
- Fri Aug 10, 2007 3:48 pm
- Forum: Main Forum
- Topic: Graphical chart/ video card problems
- Replies: 4
- Views: 7402
- Sun Jul 22, 2007 10:52 am
- Forum: Main Forum
- Topic: How to change path to OpenDentalData
- Replies: 1
- Views: 5287
- Sat Jul 21, 2007 6:11 pm
- Forum: Main Forum
- Topic: Is something missing?
- Replies: 1
- Views: 5155
Is something missing?
What happened to all the posts from the month of July?
Jorge Bonilla, DMD
Jorge Bonilla, DMD
- Wed Jun 27, 2007 7:38 pm
- Forum: Main Forum
- Topic: Version 5.0
- Replies: 5
- Views: 11940
- Wed Jun 27, 2007 7:07 pm
- Forum: Main Forum
- Topic: Version 5.0
- Replies: 5
- Views: 11940
I'm trying it out at home and apparently the appt module is slow on my laptop only. It's slow all the time, from openning the module to viewing anything at all. It's fast enough on my desktop, though. The desktop has a faster processor and a good video card. I'm thinking it could also be slow at the...
- Wed Jun 27, 2007 5:56 pm
- Forum: Main Forum
- Topic: Version 5.0
- Replies: 5
- Views: 11940
Version 5.0
Just downloaded a few hours ago and it looks awesome. The only bad thing I noticed is that the appointment module has slowed down considerably. I hope it's something that can be fixed soon. The computer at our front desk isn't as fast as the others so this could be a big problem for us. Jorge Bonill...