California Prison System
See Orion Bridge
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.
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.
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.
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.
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.
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 @startdate=ADDDATE(CURDATE(),INTERVAL -2 MONTH);
FROM orionproc op,procedurelog pl,procedurecode pc,patient p
WHERE op.ProcNum=pl.ProcNum 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.