Notifications
Clear all
Topic starter
I would like to do a slot utilization report.
I would like to know what tables in the oracle database if anyone knows, that holds what times and days are blocked by a particular template and then with that I can relate it to the appts of patients that actually filled those slots.
I am using Centricity EMR
Thank you in advance
Posted : January 15, 2020 2:35 am
You'll want to use the PERIOD table to identify template rules.
Posted : January 15, 2020 7:46 am
Topic starter
and then what table can I pull how many slots were assigned?
Posted : January 15, 2020 7:56 am
If you want to report on specific appointments then you can use an available view called RPTAPPT. Do you have the data dictionary?
Posted : January 16, 2020 6:05 am
