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.
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.
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
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);
Open Dental Software 1-503-363-5432