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
[Video] Setting up PPS Hosted on an iPad or iPhone
Viewed 1077 times since Fri, Feb 14, 2014
Set Up Letterhead
Viewed 866 times since Tue, Jan 11, 2011
Statement Layout Designer
Viewed 716 times since Wed, Jan 26, 2011
Letter Layout Designer
Viewed 950 times since Wed, Jan 26, 2011
Custom Forms Maintenance
Viewed 909 times since Mon, Apr 4, 2011
SMS Message Setup
Viewed 876 times since Fri, Jan 7, 2011
Viewed 1210 times since Tue, Jan 18, 2011
Setup Activity Templates
Viewed 1066 times since Thu, Feb 24, 2011
Using PPS Self Check-In
Viewed 627 times since Fri, May 6, 2016
Setup Medical History
Viewed 686 times since Fri, Feb 11, 2011