  |
axiUm Report Package
So far, these are the reports that are part of the Metrics Report Hub at the University of Colorado School of Dental Medicine. We have initial permission to "share everything", but the actual availablily will be pending a more formal review.
"Table" reports are similiar to many Crystal Reports, and can have Grouping, Sub Totals, and Grand Totals (and counts, min, max, etc). Additionally, any report usually has a Table shown at the bottom as a "details" drilldown to see the data behind any chart, even if "Table" isn't listed as the Report Type.
| Report Name | Report/Chart Type | Description | Possible CODA Measure? |
|---|---|---|---|
| Baseline | Number | This report shows a simple count, of all patients who meet the search criteria. It is used to confirm accuracy across other reports in the same report hub. | |
| Procedure Counts (Slice in Time) | Table | This report shows how many patients had each procedure (excluding step codes), and how many times those procedures were completed | |
| Procedure Counts (Current Info) | table | This report shows how many patients had each procedure (excluding step codes), and how many times those procedures were completed | |
| Procedure Counts (Trends) | Table | This report shows instance and patient counts for each procedure each calendar year, for the past 4 years, allowing you to spot trends. | |
| Screened to Complete (Screening in Date Range) | multi-series chart | Shows how many patients were screened, how many of those were , how many of those had other treatment, how many of those were marked as case complete. | |
| Screened to Complete (Screening and Trx in Date Range) | multi-series chart | Shows how many patients were screened, how many of those had comp evals, how many of those had other treatment, how many of those were marked as case complete. | |
| Survey of Dental Education | Table | This one shows a variety of values, to assist with filling out the annual CODA Survey of Dental Education. Unfortunately, I think this one would need the most work to customize for each school, as ours isn't even perfect yet as we are still working to be more consistent with how we enter the data across clinics. However, I do think it could help a lot of schools do better than they are now with this. | Related |
| Screened Patients | Single Series Chart | Shows how many of the patients who were seen in the date range (had any treatment) had previously been screened. | Yes |
| Demographics - Language | Single Series Chart | Shows the top 4 primary languages for your patients (others can drilled down to by clicking the "Other" category). This is a potential CODA Standards of Care Measure, if you state that you record the patient demographics (the idea being that your "Unspecified" is low, or 0). It can also be helpful in determining the need for translators or translated forms. | Yes |
| Demographics - Races | Single Series Chart | Shows the top 6 races for your patients (others can drilled down to by clicking the "Other" category). This is a potential CODA Standards of Care Measure, if you state that you record the patient demographics (the idea being that your "Unspecified" is low, or 0). Since multiple races can be selected, the "pie" slices represent all possible combinations to keep the overall total from having duplicates, however you can find out how many patients identify as any potential race total by reviewing the tool-tip for any single-race entries. | |
| Demographics - Ethnicity | Single Series Chart | Shows the selected Ethnicity values for your patients. | Yes |
| Demographics - Age | Single Series Chart | Shows the selected Age buckets values for your patients. It currently just shows "Adult" and "Adolescent" but it is on my list to expand that into a few more categories. Other variations would be easy as well, such as saying "0-10", "11-20" etc. | |
| Demographics - Gender | Single Series Chart | Shows the selected Gender values for your patients. | |
| Demographics - State | Single Series Chart | Shows the States and Counties your patients come from. It starts with a US Heat map, and as you click on any state it drills down to show every county in that state. | |
| Signed General Consents | Single Series Chart | Shows the number of patients in the patient set who had a General Consent signed before being treated. This is a potential CODA Standards of Care Measure. | Yes |
| Medical History Form | Single Series Chart | Shows the number of patients in the patient set who had a Medical History Form updated/signed/neeing approval under/over 12 months before the patient's last treatment within the date range. | Yes |
| Signed HIPAA Consents | Single Series Chart | Shows the number of patients in the patient set who had or did not have a Signed HIPAA Consent form signed before recieving treatment within the date range. | Yes |
| Treatment Plans | Single Series Chart | Shows the number of patients who had a treatment plan signed within a year before their most recent treatment in the date range, or had a treatment plan older than a year, or never had a treatment plan signed. | Yes |
| Emergency Metrics | Two Single Series Charts | Shows the number of patients who were seen in an Emergency Clinic, or had Urgent Care Appointments. Can be modified to how you identify Emergency Visits. | Yes |
| Comp Exams | Single Series Chart | Shows the number of patients who had a comprehensive exam within one year before the most recent treatment in the date range. Also states if the patient did not have anything other than a Screening in the period, or if they had or never had a Comp Exam at all. | Yes |
| Perio Exam | Single Series Chart | Shows the number of patients who had a perio exam within one year before the most recent treatment in the date range. Also states if the patient did not have anything other than a Screening in the period, or if they had or never had a Comp Exam at all. | Yes |
| Comp or Perio Exam | Single Series Chart | Shows the number of patients who had a comprehensive or perio exam within one year before the most recent treatment in the date range. Also states if the patient did not have anything other than a Screening in the period, or if they had or never had a Comp Exam at all. | Yes |
| Medical Condition Metrics | Table | Shows how many Active/Active Under 65/Active 65 and older/Active or Inactive patients have each Clinical Alert, Patient Alert, Allergy, Medical Problem, specified EPR Forms, specified EPR Answers out of those treated within the patient set and date range. | Yes |
| Patient Pay Type | Single Series Chart | Shows the primary payment method by the patients seen in the date range, such as speicfic Grants, Medicaid, Insurance or Self-Pay. | |
| Patient Visits | Single Series Chart | Shows count of patient visits for each Provider Category (class) selected, with a drill-down to a line graph showing the specific dates over the time period. | |
| Overnight Logs | Table | Shows a summary of how long the overnight took (or if it completed), allowing you to drill-down to see how long each individual process took. | |
| eRx Log | Table | Shows a summary of eRx errors, grouped by provider and eRx Error Code (bad_provider_id, bad_parameter). Can help to identify when users are trying to login to eRx before their eRx user account is set up. Can be filtered by one month or the current day. | |
| System/Usage Dashboard | Table | Shows Stats, Alerts and Error conditions dealing with applications, users, stations and misconfigurations. Shows number of active Stations, and number of users who have logged into axiUm and the different web modules in the last 1 day/7 days/Ever. | |
| Custom Script Logs | Table | Shows a summary of how long various Custom Scripts took (or if it completed), allowing you to drill-down to see how long each individual process took. Only works for custom scripts which write logs to the ax_log table. | |
| View/Function Performance Report | Table | Analyzes oracle performance logs to indicate which scripts are taking up the most CPU time so that they can be optimized. (Takes a while to load) | |
| Crystal Reports | Table | The Cystal Reports used in axiUm, and the tables and fields they reference. Can be useful to identify which reports need updating after an axiUm upgrade. (Requires a seperate tool to be installed to scan the .rpt files, such as Report Runner Documenter) |
Treatment to Treatment Measures - These measures are a bit different than those above, in that they are all comparing two treatments often on the same tooth site, the count of patients or treatments based on the first set of procedures and a single series chart showing those who had or had not a treatment in the second series of procedures. They are all dynamically created through a configuration window, and show a Dentation Count Chart drill-down if they are site-specific in addition to the details level drill-down that shows patient charts and provider codes. Using the configuration windows, it is easy to set up your own Treatment to Treatment measures without creating any additional SQL objects or SQL Queries. These also make great CODA Standard of Care Measures!
| Report Name/Description |
|---|
| Crown to Endo |
| Endo to Extraction |
| Denture Remake |
| Screening Exams before Comprehensive Exams |
| Phase 1 of Care completed |
| Denture Remake (Complete) |
| Denture Remake (Partial) |
| SRP then Perio Reevaluation |
| Perio Reevaluation then Perio Maintenance |
| Initiation of Preventive Care |
| DQA - Periodontal Evaluation in Adults with Periodontitis |
| DQA - Ongoing Care in Adults with Periodontitis |
| Start of OD to Complete of OD |
| Start of Denture to Completion of Denture |
| Start of Denture to Completion of Denture (w/o Pre-prosthetic Oral Surgery) |
| Start of Denture to Completion of Denture (with Pre-prosthetic Oral Surgery) |
| Comprehensive Exams to Any Other Treatment |
| Comprehensive Exams to Perio |
| Crown to Extraction |
| Crown Remake |
| SRP then Crown |
| Extraction to I&D |
| Screening to Post-Op Eval |