Database Search tutorials
Search the Bp Premier database
Bp Premier offers a tool for searching the database for patient records based on demographic and clinical filters you define. Searches can be used to run a mail merge, for example, or export a list of patients.
This article lists the supplied database queries that are available to use with Bp Premier, with instructions on how to use them.
Export query results to a spreadsheet application to extract patient phone number and email lists.
Useful Database Queries to Run
Provides an overview of Bp Premier's most useful supplied database queries.
Search the database for a specific Patient ID number.
How to search for patients who received a vaccination during a set period or have not received a vaccination by a specific age or for a length of time.
Search for patients with diabetes
How to search for patients with 'diabetes' in their current or past history, and how to search for patients by past medication.
Database Search: Mark patients as inactive or deceased
Mark patients as deceased or inactivate, if a patient has not attended your practice in some time. Run a database search for duplicate or inactive patients and mark the patients in bulk as inactive.
Use the BP Browser utility to browse the database
The BPS 'viewer' account allows read-only access to the Bp Premier database. Administrators and third-party applications can use this account to view and access a subset of database data. You can also export table data to XML or text file.
AU 