Home User Manual Discussion Forum Search

California Prison Systems Setup Instructions 


Set up a new Oracle schema or database using the two files we have posted on the Oracle page.  This will result in a brand new database with a small amount of information in it.  No information from the databases previously used for testing will be carried forward into this new database.

Using the ordinary Open Dental client program running on the server, connect directly to the database from the Choose Database window for initial testing.

In the Data Paths window, select the option half-way down to store images directly in the database without using A to Z folders.

Turn on Orion bridge in Program Links. Then restart Open Dental.

Follow the instructions on the Middle Tier page to also set up the middle tier on the server that the other workstations will be connecting to.

Setting up Options

In order to perform the next step, a patient must be currently selected as described in Select Patient.  If there are no patients in the database, a patient will need to be added as described in Family Add.

Go to the Chart module, Show Tab.  Set up two chart views, one for Treatment Plan, and one for Progress Notes:

Create the Exam Sheets for "Oral Cancer Screening” and “PSR”.  The sheets that were already set up over the last few months can be exported from the old database and then imported into the new database to save time.

Printing out Planned Appointment
In Sheets, set up a Patient Letter. Rename it Planned Appt Info. Change the layout to suit your needs. In the main static text box, add the field [plannedAppointmentInfo]. Save the sheet.  To later print the info for the Planned Appointment for one patient, open that patient and click the Letter button the main toobar.  Pick the Planned Appt Info from the list.

Multivisit Appointments
Let's say there are 4 procedures in a multivisit sequence:
Appt 1: Denture Impressions- Set DPC to 2. (this also sets a schedule by date)
Appt 2: Bite - DPC none
Appt 3: Try-in - DPC none
Appt 4: Deliver - DPC none
The Deliver procedure would be the D code, while the other three would be dummy codes. For example, C5105 for denture impressions. At the first appointment, the first procedure is changed from TP to C, and the stop clock date is set for that procedure to match the date of service.  Once the stop clock date is set for the first procedure, there is no time limit to complete the remaining procedures.

The query below can be used to determine when a case was started, the number of days between appointments, and the total number of days to complete case. It first finds any completed multivisit procedures with a stopclock date in the given range.  It then shows all completed mulitvisit procedures with a date greater than or equal to the stop clock date.

SET @enddate=CURDATE();
SELECT pl.PatNum,pc.ProcCode,pl.ProcDate,op.DateStopClock
FROM orionproc op,procedurelog pl,procedurecode pc,patient p
WHERE op.ProcNum=pl.ProcNum AND
pl.CodeNum=pc.CodeNum AND
p.PatNum=pl.PatNum AND
op.Status2=2 AND
pc.IsMultiVisit='1' AND
((op.DateStopClock>=@startdate AND op.DateStopClock<=@enddate) OR
ORDER BY p.LName,p.FName,pl.ProcDate

Instructions for using the query above can be found on the Query Favorites page.


Open Dental Software 1-503-363-5432