When a new patient is scheduled, it would be very nice if there were an asterisk next to their name so it is easily visible by looking at the appointment book that it is a new patient.
I can help you out. Its real easy to get a list of new patients for any given timeframe in PerioVision. Just use the notepad feature and create this query:
Select Patients where (Rtrim(LTRIM(current_date)) >= '02/01/2020') And (last_appt_date >= '2020-02-01 00:00:00') and exists (select * from audit where audit.master_key = patient_primary_key and audit.today between '2020-02-01 00:00:00' and '2020-02-29 23:59:59.999' and audit.ada_no between '000120' and '009999') and not exists (select * from audit where audit.master_key = patient_primary_key and audit.today between '1990-01-01 00:00:00' and '2020-01-31 23:59:59.999' and audit.ada_no between '000120' and '009999')
You will have to change the dates in the query for each timeframe you wish to look at but other than that it works perfectly and you could save/resave this under different names if need be.
Guest
I can help you out. Its real easy to get a list of new patients for any given timeframe in PerioVision. Just use the notepad feature and create this query:
Select Patients where (Rtrim(LTRIM(current_date)) >= '02/01/2020') And (last_appt_date >= '2020-02-01 00:00:00') and exists (select * from audit where audit.master_key = patient_primary_key and audit.today between '2020-02-01 00:00:00' and '2020-02-29 23:59:59.999' and audit.ada_no between '000120' and '009999') and not exists (select * from audit where audit.master_key = patient_primary_key and audit.today between '1990-01-01 00:00:00' and '2020-01-31 23:59:59.999' and audit.ada_no between '000120' and '009999')
You will have to change the dates in the query for each timeframe you wish to look at but other than that it works perfectly and you could save/resave this under different names if need be.
if you want help let me know.
eric@hillandalesmiles.com, office email
301-439-7878 office phn
ericmichaellutz@hotmail.com, personal email