11-19-2021 12:00 AM
General business need:
To support the College in its need to immediately react based on COVID test submissions and results, which were provided by students, faculty and staff. Actions required included email generation and notification & data collection for reports and archival.
Use cases:
Use case 1: Positivity Report
Integration to notify the clinical advisor and contact tracers when a new CoVerified user has entered a positive symptom report. It will ultimately aid in the intake of potential COVID-19 patients into our robust Testing and Contact Tracing programs, further improving the health and safety of the Barnard community.
Barnard College’s Pandemic Response Team (PRT) needs to retrieve Covid-19 data of persons who resulted with positive tests from the CoVerified on an hourly basis. This data is accessed, processed, and stored in an Excel spreadsheet for analysis and reporting by the PRT. If users with positive results are found, their data is emailed to the specified PRT members, and to the individuals identified. (“Push”-like notifications being sent to the clinical advisor and contact tracers each time a CoVerified user enters a positive symptom report.)
Use case 2: Testing Non-Compliance
Integration to notify the clinical advisor, contact tracers, and students when relevant data related to non-compliance is retrieved from the CoVerified web service as described in business requirements below:
Use case 3: New York City Covid-19 Data by ZIP
Enable the retrieval of data, processing, and report generation. These reports are utilized by the BC’s Pandemic Response Team in ongoing efforts to help the wider Barnard community to successfully deal with the Convid-19 pandemic.
Barnard College’s Pandemic Response Team (PRT) needs to retrieve publicly available Covid-19 data from the NYC Department of Health github repository on a daily basis. This data is accessed, processed, and stored in an Excel spreadsheet for analysis and reporting by the PRT.
Use case 4: New York State Regional Covid-19 Data
Barnard College’s Pandemic Response Team (PRT) needs to retrieve publicly available Covid-19 data from the NY State Department of Health dataset on a daily basis. This data is accessed, processed, and stored in an Excel spreadsheet for analysis by the PRT.
Challenges:
Strategic goals:
Execution:
Barnard Development: Two SnapLogic developers, Marrah Arenas and Agron Bauta SnapLogic professional services: Kory Knickerbocker
Manual work to generate hourly data collection was completely eliminated, able to implement modifications to data requirements quickly, notifications distributed to contract tracers and the College’s Pandemic Response Team which allowed for immediate action in order to minimize exposure of COVID across on-campus constituents
Allowed the Pandemic Response Team more time* to primarily deal with issues in their area of expertise, to address Covid-19 exposure and protection across campus constituents and ensure the health of Barnard community.
Barnard’s Covid-19 data can be accessed, processed, and stored for future analysis and reporting by the PRT.
Integration workflow can send email alerts to the specified PRT members, such as clinical advisors and contact tracers and to the individuals affected
The development of these integrations was a learning process. Plan to develop patterns so future development can take advantage of common logic.