Bacha, Sarah
(2024)
New York City Neonatal Herpes Database Migration:
The Data Modernization Process and Implications of 2006-2019 Neonatal Herpes Data into Maven.
Master Essay, University of Pittsburgh.
Abstract
With an approximated 60% fatality rate among untreated cases, neonatal herpes is a public health crisis that requires effective time-sensitive surveillance. However, it is not nationally notifiable. A limited number of states require its surveillance, each with different procedures for reporting. This results in limited information regarding the neonatal herpes incidence and a lack of historical information from which comparative trends can be determined and interventions can be designed.
New York City began recording reported neonatal herpes cases in an Access database in 2006. Since then, surveillance has been transferred to their centralized surveillance database, Maven, creating a need for neonatal herpes information from 2006 to 2019 to be migrated into Maven. Access records were first assigned Person IDs. A crosswalk document was created to match Access variables to Maven variables, and variable transfers were categorized into six types. Variables were imported into SAS, cleaned, and transformed to Maven variables. After multiple iterations were coded through SAS for variables in repeatable forms, appropriate parent questions were opened, and Maven labels were added, the created datasets were exported as comma separated text (.csv) files and imported into Maven.
The migration procedure resulted in 178 Access variables being migrated into 140 Maven variables. Migration challenges included correcting variables with substandard data entry errors, migrating variables with multiple iterations, and migrating variables that required manual reformatting. These errors were most found in laboratory information variables. The largest limiting factor in data quality was how information was collected outside of the health department. The roadblocks listed above can be mediated by ensuring public health reports are: (1) standardized among different laboratories/hospitals; (2) compatible with local public health reporting; (3) directly electronically reportable to the local health department.
Stricter reporting laws are needed to establish a consistent definition of neonatal herpes. Establishing a nationally notifiable status could inform its incidence rate over time and help establish interventions to decrease the rate of neonatal herpes. Modernized databases paired with stricter reporting laws can impart immense public health impact by improving surveillance efforts and decreasing the staggering morbidity and mortality rates of this important public health issue.
Share
| Citation/Export: |
|
| Social Networking: |
|
Details
| Item Type: |
Other Thesis, Dissertation, or Long Paper
(Master Essay)
|
| Status: |
Unpublished |
| Creators/Authors: |
|
| Contributors: |
| Contribution | Contributors Name | Email | Pitt Username | ORCID  |
|---|
| Committee Chair | Haggerty, Catherine | haggertyc@edc.pitt.edu | haggertyc | UNSPECIFIED | | Committee Member | Hershey, Tina Batra | tbh16@pitt.edu | tbh16 | UNSPECIFIED | | Committee Member | Klinger, Ellen J | eklinger@health.nvc.gov | UNSPECIFIED | UNSPECIFIED |
|
| Date: |
17 May 2024 |
| Date Type: |
Completion |
| Submission Date: |
25 April 2024 |
| Access Restriction: |
No restriction; Release the ETD for access worldwide immediately. |
| Number of Pages: |
41 |
| Institution: |
University of Pittsburgh |
| Schools and Programs: |
School of Public Health > Epidemiology |
| Degree: |
MPH - Master of Public Health |
| Thesis Type: |
Master Essay |
| Refereed: |
Yes |
| Uncontrolled Keywords: |
neonatal herpes; database migration; surveillance; infectious disease reporting; sexually transmitted infection; Maven; SAS |
| Date Deposited: |
17 May 2024 19:18 |
| Last Modified: |
17 May 2024 19:18 |
| URI: |
http://d-scholarship.pitt.edu/id/eprint/46307 |
Metrics
Monthly Views for the past 3 years
Plum Analytics
Actions (login required)
 |
View Item |
![[img]](https://d-scholarship.pitt.edu/style/images/fileicons/application_pdf.png)
![[feed]](/images/feed-icon-32x32.png){kind=icon}