From Swab to Dashboard — The Journey of COVID-19 Testing Data and Reports
LEXINGTON, Ky. (March 2, 2021) — Determined to start Spring 2021 safely, the university announced students would need to complete entry testing for COVID-19 as well as required ongoing testing for students throughout the spring semester. But what goes on behind the scenes to ensure testing operations run smoothly? The answer involves more than you may think.
Let’s start with accurately defining the student populations that are required to complete COVID-19 testing. This data is defined by the Institutional Research, Analytics, & Decision Support (IRADS) team and handed over to Health Corps to begin communications on when and how to get tested. Once students, faculty and staff begin to get their COVID-19 tests, there are three major data sources feeding in test results — WildHealth, University Health Services and the Self-Report Tool. Test results from these three data sources are uploaded into a SQL Server database and fed into a Tableau report which allows IRADS to check for data that is missing information, doesn’t match up correctly, or is a duplicate result. After the test results data is validated, it is given to the Health Cloud operations team who prepares and loads the data into the Salesforce Health Cloud environment which triggers COVID cases for the Health Corps contact tracing team to start their outreach.
If a student gets back a negative test result, an automated email is triggered via Marketing Cloud. This email sends the student their negative test result immediately to their UK email once the data is loaded into Health Cloud. If a student tests positive for COVID-19 at UK, it starts a multifaceted chain of actions that involve several departments at UK. Wellness connectors are contacted to help provide resources to those in quarantine including everything from basic needs (e.g., meals, medication, groceries) to essential technology (e.g., MiFis and devices). Representatives from Facilities, Transportation, Housing, Dining and more also join in on the effort to support those in quarantine.
As this chain of events occur, the COVID-19 data still has one final stop. The number of tests administered and new positive cases are fed into the public-facing University of Kentucky COVID-19 Data Dashboard, which informs the university community about the overall health of the campus population.
Since the beginning of UK’s COVID-19 response, there have been many improvements made to the data ingestion process. One example is the Self-Report Tool, which allows UK students, faculty and staff to not only report their COVID-19 test results in the event they got tested somewhere other than UK, but also whether they received the flu vaccination, or COVID-19 vaccination. Thanks to the work from Information Technology Services’ Enterprise Applications team, this tool was enhanced to automatically feed the information to the testing results database, ensuring all cases would be reported and contacted.
It is through the dedicated work of university employees that COVID-19 testing, reporting and subsequent response continues to operate every day. Our community owes much gratitude to those who work to develop and implement strategies to keep us all safe.
As the state’s flagship, land-grant institution, the University of Kentucky exists to advance the Commonwealth. We do that by preparing the next generation of leaders — placing students at the heart of everything we do — and transforming the lives of Kentuckians through education, research and creative work, service and health care. We pride ourselves on being a catalyst for breakthroughs and a force for healing, a place where ingenuity unfolds. It's all made possible by our people — visionaries, disruptors and pioneers — who make up 200 academic programs, a $476.5 million research and development enterprise and a world-class medical center, all on one campus.
In 2022, UK was ranked by Forbes as one of the “Best Employers for New Grads” and named a “Diversity Champion” by INSIGHT into Diversity, a testament to our commitment to advance Kentucky and create a community of belonging for everyone. While our mission looks different in many ways than it did in 1865, the vision of service to our Commonwealth and the world remains the same. We are the University for Kentucky.