PH2S Data Team Metrics
Amanda Carroll
Introduction
[Briefly state the purpose of this section and why it matters to stakeholders.]The purpose of…
Performance Management Data
[Insert key metrics and data in a table format below.]
| Data Team Summary Tasks from 2025 | Jan, N = 231 | Feb, N = 291 | Mar, N = 371 | Apr, N = 411 | May, N = 561 | Jun, N = 451 | Jul, N = 491 | Aug, N = 501 | Sep, N = 711 | Oct, N = 441 | Nov, N = 361 | Dec, N = 191 | Overall, N = 5001 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Metric | |||||||||||||
| Â Â Â Â REDCap Builds | 10 (43%) | 4 (14%) | 8 (22%) | 4 (9.8%) | 15 (27%) | 18 (40%) | 20 (41%) | 10 (20%) | 8 (11%) | 7 (16%) | 11 (31%) | 5 (26%) | 120 (24%) |
| Â Â Â Â Grants Supported | 6 (26%) | 4 (14%) | 9 (24%) | 19 (46%) | 16 (29%) | 8 (18%) | 13 (27%) | 11 (22%) | 12 (17%) | 4 (9.1%) | 4 (11%) | 5 (26%) | 111 (22%) |
| Â Â Â Â Publications Supported | 1 (4.3%) | 2 (6.9%) | 1 (2.7%) | 2 (4.9%) | 0 (0%) | 2 (4.4%) | 1 (2.0%) | 0 (0%) | 2 (2.8%) | 1 (2.3%) | 2 (5.6%) | 2 (11%) | 16 (3.2%) |
| Â Â Â Â Analysis | 1 (4.3%) | 3 (10%) | 4 (11%) | 5 (12%) | 2 (3.6%) | 3 (6.7%) | 0 (0%) | 2 (4.0%) | 0 (0%) | 1 (2.3%) | 2 (5.6%) | 2 (11%) | 25 (5.0%) |
| Â Â Â Â Process Improvement | 5 (22%) | 12 (41%) | 11 (30%) | 8 (20%) | 12 (21%) | 9 (20%) | 3 (6.1%) | 7 (14%) | 10 (14%) | 3 (6.8%) | 6 (17%) | 3 (16%) | 89 (18%) |
| Â Â Â Â Trainings | 0 (0%) | 4 (14%) | 4 (11%) | 3 (7.3%) | 11 (20%) | 5 (11%) | 12 (24%) | 20 (40%) | 39 (55%) | 28 (64%) | 11 (31%) | 2 (11%) | 139 (28%) |
| 1 n (%) | |||||||||||||
| Data Team Task Summary from 2024 | Jan, N = 241 | Feb, N = 201 | Mar, N = 301 | Apr, N = 301 | May, N = 331 | Jun, N = 321 | Jul, N = 401 | Aug, N = 351 | Sep, N = 361 | Oct, N = 261 | Nov, N = 231 | Dec, N = 141 | Overall, N = 3431 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Metric | |||||||||||||
| Â Â Â Â REDCap Builds | 10 (42%) | 13 (65%) | 15 (50%) | 5 (17%) | 12 (36%) | 17 (53%) | 19 (48%) | 17 (49%) | 11 (31%) | 10 (38%) | 9 (39%) | 5 (36%) | 143 (42%) |
| Â Â Â Â Grants Supported | 5 (21%) | 0 (0%) | 5 (17%) | 6 (20%) | 7 (21%) | 4 (13%) | 7 (18%) | 6 (17%) | 8 (22%) | 11 (42%) | 5 (22%) | 3 (21%) | 67 (20%) |
| Â Â Â Â Publications Supported | 0 (0%) | 1 (5.0%) | 0 (0%) | 2 (6.7%) | 1 (3.0%) | 2 (6.3%) | 0 (0%) | 0 (0%) | 2 (5.6%) | 0 (0%) | 2 (8.7%) | 0 (0%) | 10 (2.9%) |
| Â Â Â Â Analysis | 3 (13%) | 1 (5.0%) | 2 (6.7%) | 4 (13%) | 6 (18%) | 2 (6.3%) | 1 (2.5%) | 4 (11%) | 6 (17%) | 4 (15%) | 5 (22%) | 6 (43%) | 44 (13%) |
| Â Â Â Â Process Improvement | 2 (8.3%) | 1 (5.0%) | 5 (17%) | 8 (27%) | 1 (3.0%) | 2 (6.3%) | 5 (13%) | 2 (5.7%) | 6 (17%) | 1 (3.8%) | 1 (4.3%) | 0 (0%) | 34 (9.9%) |
| Â Â Â Â Trainings | 4 (17%) | 4 (20%) | 3 (10%) | 5 (17%) | 6 (18%) | 5 (16%) | 8 (20%) | 6 (17%) | 3 (8.3%) | 0 (0%) | 1 (4.3%) | 0 (0%) | 45 (13%) |
| 1 n (%) | |||||||||||||
Data Interpretation
[Explain what the numbers mean in plain language. Highlight trends, successes, and areas for improvement. Include data visualizations if available.]As seen above from the tables, the Data Team completed ~500 tasks total in 2025, which was a 45.7% increase from 2024. Chelsea was hired at the end of April in 2024, and this really shows the productivity increase and ceiling of two employees, rather than one.
As you can see from the first table below, from August - November the majority of tasks completed were trainings as the Data Team was preparing for the Clinical Database training in October, as well as the go-live in November. This really monopolized the time of the Data Team, and they are hoping the allocation of quality assurance (QA) tasks and data integration from the Pilot will mostly be given to the future student and S1 in 2026.
Each of the charts below show each specific task area from above broken down individually. Some key things to note:
- May - July was huge for REDCap builds because of the clinical database, as this was when most of the building and editing was completed. Another big note of this was in November, from go-live, and edits from that.
- April was huge for grants support because of the first attempted submission of ALL FOCUS data that month, which included re-doing the REDCap, cleaning all data, analyzing it, and uploading into their system.
-
The biggest note for publications was that the Data Team was included on
three publications in 2025. Here are the citations for that:
- Langkiet, J., Hutzel-Dunham, E., Brown, J. L., Lyons, M. S., Freiermuth, C., Sprague, J. E., Lambert, J., Braun, R. S., Littlefield, A. K., Frey, J. A., Bachmann, D., Bischof, J. J., Pantalon, M. V., Ancona, R. M., Carroll, A., Petrovitch, D., Himes, K. P., & Punches, B. E. (2026). Mental Health Symptom Screening Among Adult Emergency Department Patients: A Cross-Sectional Study. JACEP Open, 7(2), 100312. https://doi.org/10.1016/j.acepjo.2025.100312
- Bischof, J. J., Reichert, E. M., Maitland, J., Queen, J. M., Cobranchi, C., Conroy, M. J., … & Lyons, M. S. (2025). Evaluation of an influenza vaccine administration program in the emergency department. The American Journal of Emergency Medicine.
- Sherman, J. P., Albright, N., Emerson, B., Cobranchi, C., Brown, J. L., Morgan, E., Gillespie, G. L., Spatholt, D., Richards, R., & Punches, B. E. (2026). No Place to Rest: Housing Instability and Pain Experiences in the Emergency Department. Journal of Emergency Nursing. https://doi.org/10.1016/j.jen.2025.12.003
- For Process Improvement, the Data Team’s biggest months were February (GPRA), March (FOCUS), April (FOCUS), May (FOCUS), June (data SOP’s), and Sept (Clinical DB Training).
-
For training, the biggest month is September with the highest bar
‘Created for REDCap Build’, which was the Data Team preparing for the
Clinical Database Training. The second highest month was October, with
‘Provided for REDCap Build’ as the highest bar, because that is when all
Clinical Database Trainings were conducted.
Key Updates & Strategic Initiatives
[Summarize major events, changes, or initiatives that impacted performance during the year.]
2025 was a big year for the Data Team with the go-live of the clinical database. With hundreds of hours of building and creating the training materials, this is hard to track accurately with a count, but was tracked to the best of their abilities. The data team also provided6 full days of training across HPAs and students, as well as full days of shadowing in the ED for all HPAs and students. Similar to 2024, overall the Data Team completed the most tasks in REDCap, whether completing REDCap builds or edits to existing projects. This is challenging to track, and does not count the consecutive days spent working on these tasks, but rather completed projects. To note, the data team takes off 2 weeks every December, and Amanda was off a decent amount Sept - Nov for family emergencies.
Looking Ahead
[Briefly outline priorities for the upcoming year.]
Recently the Data Team has been working through a lot of outlines, data proposals, and REDCap builds for new grants awarded, which will be the majority of work for the beginning of 2026. FOCUS rebuilding and data dissemination will also be a focus of 2026. The data team will also be hiring a student and a S1 in 2026, which will offset some of the burden of the ongoing task list, as well as increase trainings and mentoring hours in 2026.