Look Up Tables

look up tables

Look up Tables are used in PPS to control the entries that are allowed in certain fields. This means that the user can restrict what values are input to just those that they want recorded.

For example, when adding a new appointment, the “Appointment Type” look up table can contain entries such as “Initial Assessment”, “New Patient” or “Hydrotherapy”. This helps when running reports as the user can select to break down the results of their report by the look up table entry thus minimising the number of different entries (especially slight variations of spellings).

Some Look Up tables will store additional default values. For example the 'Appointment Type' table can optionally have a Charge Codes associated with each entry. When the selected entry is used for an appointment, the charge code will be automatically selected for you when the user creates the charge for the appointment.

The PPS System Administrator controsl which PPS users has access to setting up and maintaining 'Look Up Tables' as part of the PPS Access Control system.


Related Articles
General System Options
Viewed 1360 times since Tue, Apr 5, 2011
Using the PPS Online Booking Admin Module
Viewed 2732 times since Wed, Jul 22, 2015
Custom Forms Maintenance
Viewed 959 times since Mon, Apr 4, 2011
Label Layout Designer
Viewed 1095 times since Wed, Jan 26, 2011
Set Up Letterhead
Viewed 922 times since Tue, Jan 11, 2011
Viewed 1275 times since Tue, Jan 18, 2011
Viewed 891 times since Tue, Jan 18, 2011
Setup Medical History
Viewed 746 times since Fri, Feb 11, 2011
Setup Activity Templates
Viewed 1127 times since Thu, Feb 24, 2011
Setup E-mail Settings
Viewed 1290 times since Mon, Jan 17, 2011