Background
Database Reporting Tool (DRT) is a system of files and processes used to schedule SQLs for production-use. These SQLs can be used to create extracts and reports internally or for external parties (like clinics or individuals).
List of Reports
DRT Name |
Schedule |
Frequency |
Jira |
Database |
| Migrate BCCDC Surveillance extract | 7AM | BiMonthly: 10th and 25th | EMR-8033 | Reporting |
| Manually Run Old BCCDC Surveillance Extract | 7AM | BiMonthly: 10th and 25th | EMR-10613 | Reporting |
| EMR Appointment Tracking Tool | 6:45AM | Daily | EMR-5756 | Reporting |
| Daily CPS Form data update | 6:45AM | Daily | EMR-8033 | Reporting |
| VCH CD Surveillance Extract | 6:45AM | Daily | EMR-4306 | Reporting |
| System Summary for Offboarding or Inactivation of Users | Every :00 hour | Hourly | EMR-5954 | Reporting |
| PC Criteria Screen Form | 6AM | Monthly: 1st | EMR-6087 | Reporting |
| PQI Form Usage Reports | 6AM | Monthly: 1st | EMR-7352 | Reporting |
| BCCDC CPS POS Report | 6:55AM | Monthly: 10th | N/A | Reporting |
| BCCDC Express Testing Appointment No Shows | 6AM | Monthly: 15th | N/A | Reporting |
| BCCDC Positive Rate of Infections | 6AM | Monthly: 15th | N/A | Reporting |
| BOOST Query | 1:01AM | Daily | N/A | Reporting |
| Null Transaction Report | 2AM | Daily | EMR-9532 | Support |
| Documents | 2AM | Daily | EMR-5244 | Support |
| FormsUsage | 2AM | Daily | EMR-5244 | Support |
| Results | 2AM | Daily | EMR-5244 | Support |
| Tasks | 2AM | Daily | EMR-5244 | Support |
| Logins | 2:15AM | Monthly: 1st | EMR-7753 | Support |
| Manual Matches | 1:20 AM | Weekly: Tuesday | EMR-5957 | Support |