Lab Matters Summer 2018 - Page 79

APHL 2018 Annual Meeting Poster Abstracts Incorporation of Non-Influenza Respiratory Virus Detections from the Public Health Laboratory Interoperability Project into the National Respiratory and Enteric Virus Surveillance System (complete abstract in Infectious Disease, p. 64) Playing with Building Blocks: The Newborn Screening Health IT Implementation Guide and Toolkit (complete abstract in Newborn Screening, p. 81) Designing Reusable and Scalable Options for Public Health Data Exchange J. Park 1 , R. Byres 1 , N. Raketich 1 , M. Kourbage 1 , L. Carlton 2 , Davis Sanderson 2 ; 1 J Michael Consulting, LLC, 2 Association of Public Health Laboratories, Silver Spring, MD Presenter: Jon Lipsky, J Michael Consulting LLC, Atlanta, GA, Phone 770.309.3124, Email jlipsky@jmichael-consulting.com Informatics Self-Assessment Tool Presenter: Rachel Shepherd, Association of Public Health Laboratories, Silver Spring, MD, Phone: 240.485.2796, Email: rachel.shepherd@aphl.org One of These Things Is Not Like the Other… Or Is It? Why Informatics Should Lean Heavily on Lessons Learned in Disparate Industries to Create Novel Solutions A. Vangeloff and G. Peterson, Yahara Software, Madison, WI Background: Often when trying to solve a problem, we find ourselves looking in familiar places for the answer. But when it comes to data and Informatics surface similarities aren’t enough. Familiar methods such as HL7 and other health informatics go-tos have drawbacks that confine data entry to certain formats and prevent access to important non-standardized data sets stored in different formats. This technological set of road blocks can keep data in silos and prevent complete and accurate reporting as well as hinder case management efforts. Methods: A novel software framework built in C# with a WPS and React front end was modified from its original purpose to track trucking data to collect and store surveillance data from around the globe. This flexible software allowed for ingestion and normalization of various data types, creating a case management system that allow disparate data to be presented in normalized formats. In addition, because it was built for the trucking industry originally, the system was designed to adapt to large amounts of data that came from different locations, at different times, in different formats. Results: The software solution was adapted from its original purpose in trucking to intake surveillance and healthcare data from disparate sources (CSV, REDCap, XML, PDF, .JPEG, .PNG and others), extract the data for input into SQL tables, combine the data into a case management system and display data in a unified report format. The collected reports were then used to determine the cause of death in infant mortality cases globally. Conclusions: This project demonstrates how seem ₯Ή±δ‘₯™™•Ι•ΉΠ)ΑΙ½‰±•΅ΟŠQΑΙ•Ω•ΉΡ₯Ήœ‘₯±‘‘½½΅½ΙΡ…±₯Ρ䁅ΉΡΙ…­₯ΉœΡΙՍ­Μ…Ι½ΝΜ)Ρ‘”UOŠQέ•Ι”Ν½±Ω•ΥΝ₯ΉœΡ‘”Ν…΅”Ρ•‘Ή₯…°Α‘₯±½Ν½Α‘丁]”½™™•Θ)…‘Ω₯”½Έ‘½ά…ΑΑΙ½…‘₯ΉœΡ•‘Ή₯…°ΑΥι鱕́™Ι½΄„‘₯™™•Ι•ΉΠ…Ή±”)…Έ±•…ΡΌΝՍ•ΝΝ™Υ°Ν½™Ρέ…Ι”ΑΙ½©•Ρ́…́ݕ±°…́‘₯͍ΥΝ́ё”)•αΑ•ΙΡ₯Ν”°Ρ₯΅”…Ή‰Υ‘•ΠΉ••‘•ΡΌ₯΅Α±•΅•ΉΠ΅•Ρ‘½‘́ΝՍ …Μ)Ρ‘•Ν”Έ)\ΈΉ‘Ι•έΜ€Δ€°HΈM‘•Α‘•Ι€Θ€°ΈA•Ρ•ΙΝ½Έ€Μ€μ€ΔY₯ɝ₯Ή₯„₯Ω₯Ν₯½Έ½˜) ½ΉΝ½±₯‘…Ρ•1…‰½Ι…Ρ½ΙδM•ΙΩ₯•Μ°I₯‘΅½Ή°Y°€ΘΝΝ½₯…Ρ₯½Έ½˜)AΥ‰±₯Œ!•…±Ρ 1…‰½Ι…Ρ½Ι₯•Μ°M₯±Ω•ΘMΑΙ₯Ήœ°5°€Μe…‘…Ι„M½™Ρέ…Ι”°)5…‘₯Ν½Έ°]$AΙ•Ν•ΉΡ•Θ聉‰•δY…Ή•±½™˜°5L°e…‘…Ι„M½™Ρέ…Ι”°5…‘₯Ν½Έ°]$°)΅…₯°θ…Ω…Ή•±½™™ε…‘…Ι…Ν½™Ρέ…Ι”Ή½΄)%Έ€ΘΐΔά°Ή•…Ι±δ€Μΐ±…‰½Ι…Ρ½Ι₯•ΜΥΝ•Ρ‘”%Ή™½Ι΅…Ρ₯ΜM•±˜΄)ΝΝ•ΝΝ΅•ΉΠQ½½°ΡΌ•Ω…±Υ…Ρ”Ρ‘•₯ȁ…Α…‰₯±₯Ρ₯•Μ…Ή΅½Ή₯ѽȁё•₯Θ)Ι½έΡ …ΉΉ••‘́½Ω•ΘΡ₯΅”Έ δΥΝ₯ΉœΡ‘”‘…Ρ„±•…Ή•™Ι½΄)Α…ΙΡ₯₯Α…ΉΡΜ°A!0‘…́•ΝΡ…‰±₯Ν‘•„Ή…Ρ₯½Ή…°…Ι•…Ρ”…Ή)‰…Ν•±₯Ή”™½Θ½Ω•ΘΉ₯Ή•Ρ••ΈΝΑ•₯™₯Œ…ΉΙ₯Ρ₯…°½Α•Ι…Ρ₯½Ή…°…Ι•…Μ)έ₯Ρ‘₯ΈΡ‘”±…‰½Ι…Ρ½Ι丁•Ν₯Ή•ΡΌ‰”„½±±…‰½Ι…Ρ₯Ω”•α•Ι₯Ν”)™½Θ±…‰½Ι…Ρ½ΙδΑ•ΙΝ½ΉΉ•°°M•±˜΅ΝΝ•ΝΝ΅•ΉΠQ½½°ΥΝ•Ί…₯Έ‰Ι½…)₯ΉΝ₯‘Ё…Ή…Ι”ΑΙ½Ω₯‘•„΅½Ι”½΅ΑΙ•‘•ΉΝ₯Ω”Ω₯•ά½˜Ρ‘•₯Θ)½έΈ±…‰½Ι…Ρ½ΙηŠé™ΥΉΡ₯½Ή…±₯Ρ䁅Ή‘½άΡ‘•δ½΅Α…Ι”ΡΌ½Ρ‘•ΙΜΈ)Q‘”…ΝΝ•ΝΝ΅•ΉΠ…±ΝΌΝ•Ίٕ…́„‰±Υ•ΑΙ₯ΉΠ°Ν‘½έ…Ν₯Ήœ…Ι•…́½˜)•α•±±•Ή”ΡΌΝΡΙ₯Ω”™½ΘΈ%ΈΡ‘₯́Α½ΝΡ•Θ°έ”έ₯±°Ν‘…Ι”Ν½΅”½˜Ρ‘”%ΉΝΡ₯ΡΥΡ₯½Ή…°I•Ν•…ɍ )AΥ‰±₯!•…±Ρ‘1…‰Μ)A!0)A!0Ή½Ιœ)Q‘”AΥ‰±₯Œ!•…±Ρ 1…‰½Ι…Ρ½ΙδMεΝΡ•΅Μ…Ρ…‰…Ν”€‘A!1M€θ)5½Ω₯ΉœQ½έ…ɑ́„9…Ρ₯½Ήέ₯‘”AΥ‰±₯Œ!•…±Ρ 1…‰½Ι…Ρ½ΙδQ•ΝΠ)…ΉΕΥ₯Α΅•ΉΠ₯Ι•Ρ½Ιδ)(ΈI½Ν…±•θ°ΈMԁ…ΉΈ]Ι₯‘Π°ΝΝ½₯…Ρ₯½Έ½˜AΥ‰±₯Œ!•…±Ρ )1…‰½Ι…Ρ½Ι₯•Μ°M₯±Ω•ΘMΑΙ₯Ήœ°5)=‰©•Ρ₯Ω”θAΙ½Ω₯‘”ΑΥ‰±₯Œ‘•…±Ρ ±…‰½Ι…Ρ½Ι䀑A!0€ΝΡ…­•‘½±‘•ΙΜ)έ₯Ρ …ΈΥΑ‘…Ρ”½ΈΡ‘”ΑΙ½Ι•Ν́½˜Ρ‘”AΥ‰±₯Œ!•…±Ρ 1…‰½Ι…Ρ½Ιδ)MΥ΅΅•Θ€ΘΐΔΰ15QQIL(άά)Q‘”99ML5½‘•ΙΉ₯ι…Ρ₯½Έ%Ή₯Ρ₯…Ρ₯Ω”€‘95$€Q•‘Ή₯…°ΝΝ₯ΝΡ…Ή”(‘Q€Q•…΄‘•Ω•±½Α•„½Ή™₯ΥΙ…‰±”I‘…ΑΝ½‘δΙ½ΥΡ”Ρ•΅Α±…Ρ”ΡΌ)™…₯±₯Ρ…Ρ”AΥ‰±₯Œ!•…±Ρ •Ή₯•ΟŠd€‘A!Μ€₯΅Α±•΅•ΉΡ…Ρ₯½Έ½˜!0܁…Ν”)Ή½Ρ₯™₯…Ρ₯½Έ΅•ΝΝ…•ΜΡΌΡ‘”  Έ5…ΑΑ₯Ήœ©ΥΙ₯Ν‘₯Ρ₯½Έ΅ΝΑ•₯™₯Œ‘…Ρ„)½‘•Μ…Ή™½Ι΅…Ρ́ѼΉ…Ρ₯½Ή…°ΝΡ…Ή‘…ɑ́₯́„‘…±±•Ή”½΅΅½ΈΡΌ)…Ήδ‘…Ρ„•α‘…Ή”₯΅Α±•΅•ΉΡ…Ρ₯½ΈΈ%ΉΡ•Ι…Ρ₯½Έ•Ή₯Ή•Μ°ΝՍ …Μ)I‘…ΑΝ½‘䁅Ή5₯ΙΡ °ΑΙ½Ω₯‘”„Ρ•‘Ή₯…°Ν½±ΥΡ₯½ΈΡΌΡ‘₯́‘…±±•Ή”°)‰ΥЁɕΕΥ₯Ι”Ρ₯΅”…Ή•αΑ•ΙΡ₯Ν”ΡΌ½Ή™₯ΥΙ”ΈQ‘”I‘…ΑΝ½‘δΡ•΅Α±…Ρ”°)έ‘₯ ΝΥΑΑ½ΙΡ́•Ή•Ι₯ŒΨΘΈΐ‰…Ν•5•ΝΝ…”5…ΑΑ₯ΉœΥ₯‘•Μ(‘55Μ€…ΉΡ‘”Ι‰½Ω₯Ι…°Ψĸ́55°•Ή…‰±•Μ…•Ή₯•ΜΡΌ₯΅Α±•΅•ΉΠ)ΝΡ…Ή‘…ɐ΅…ΑΑ₯Ήœ‰δ•ΉΡ•Ι₯Ήœ©ΥΙ₯Ν‘₯Ρ₯½Έ΅ΝΑ•₯™₯Œ₯Ή™½Ι΅…Ρ₯½Έ)₯ΉΡΌ„½Ή™₯ΥΙ…Ρ₯½ΈΡ…‰±”Ι…Ρ‘•ΘΡ‘…ΈέΙ₯Ρ₯Ήœ½‘”ΡΌ΅…ΐ•Ω•Ιδ)‘…Ρ„•±•΅•ΉΠΈQ‘₯́…ΑΑΙ½… Ι•‘Ս•ΜΡ‘”Ή••™½ΘΥΝΡ½΄½‘”)…Ή‘•Ω•±½Α΅•ΉΠΙ•Ν½Υɍ•ΜΈA!́…ΈΥΝ”Ρ‘”Ρ…‰±”΅‘Ι₯Ω•Έ½‘”°)₯ΉΝΡΙՍΡ₯½ΉΜ…Ή•α₯ΝΡ₯ΉœΝΡΙՍΡΥΙ”ΡΌ‘•Ω•±½ΐΙ½Υѕ́ё…Ёέ₯±°ΝΥΑΑ½ΙΠ)™ΥΡΥΙ”!0܁΅•ΝΝ…”‘•Ω•±½Α΅•ΉΠΈA!́…Έ•αΡ•ΉΡ‘”™ΥΉΡ₯½Ή…±₯Ρδ)½˜Ρ‘”Ι½Υѕ́₯Ή‘•Α•Ή‘•ΉΡ±δ‰δΥΑ‘…Ρ₯ΉœΡ‘”ΥΝΡ½΄½‘”Ν•Ρ₯½Έ½˜)Ρ‘”I‘…ΑΝ½‘δΡ•΅Α±…Ρ”ΈQ‘”Ρ…‰±”΅‘Ι₯Ω•ΈΙ½ΥΡ”ΑΙ•Ν•ΉΡ́„Ν…±…‰±”)…Ή½Ή™₯ΥΙ…‰±”½ΑΡ₯½Έ™½Θ₯΅Α±•΅•ΉΡ₯Ήœ!0܁…Ν”Ή½Ρ₯™₯…Ρ₯½Έ)΅•ΝΝ…•Μέ₯Ρ ±₯΅₯Ρ•ΥΝΡ½΅₯ι…Ρ₯½ΈΈQ‘₯́…ΑΑΙ½… …Έ‰”…‘…ΑΡ•)™½Θ½Ρ‘•ΘΑΥ‰±₯Œ‘•…±Ρ ‘…Ρ„•α‘…Ή”Ή••‘ΜΈ)Ή…Ρ₯½Ή…°ΡΙ•Ή‘́‘₯͍½Ω•Ι•™Ι½΄Ρ‘”±…ΝЁ…ΝΝ•ΝΝ΅•ΉΠ…Ή₯ΝΝΥ”„)…±°™½ΘΑ…ΙΡ₯₯Α…Ρ₯½Έ₯Έ€ΘΐΔΰΈ