Register Checks
Prior to sending your register to Karo it is a good idea to check for any patients who might be rejected for funding because of incomplete recording of patient details.
The following are three (3) ways in Medtech32 that you can use to find this information along with reasons a patient might be rejected for funding.
1) Create a set of queries using the QueryBuilder (see here for some sample screenshots)
2) Download the MedTech query .qbu file below and save in a location that medtech can access
Reminder: for some of these queries you will need to change the date to the relevant quarter/month
Issues with the patient name:
- First Name is blank (download Mt32 query .qbu file)
- Surname is blank (download Mt32 query .qbu file)
- Surname is "Mouse" (download Mt32 query .qbu file)
Issues with the patient DOB:
- DOB is blank (download Mt32 query .qbu file)
- DOB is after the date of enrolment (note: it is not possible to do in a MedTech query, you will need to use the SQL below to find this information)
- DOB is in the future (download Mt32 query .qbu file)
Issues with the enrolment:
- Patient is not enrolled (R not E) (download Mt32 query .qbu file)
- Patient is enrolled as B (newborn) for a 2nd quarter or when the baby is too old (download Mt32 query .qbu file)
- Enrolment date is blank (download Mt32 query .qbu file)
- Enrolment date is in the future (download Mt32 query .qbu file)
- Enrolment date and date last visit are over 3 years old (download Mt32 query .qbu files Query1 Query2)
3) Download the SQL file below and run this in medtech - see here for instructions to run an SQL in medtech
- MedTech sql file - one for each of the groups above
If you do not use Medtech32 as your Patient Management System you will need to contact your vendor for similar queries/examples.