Sidebar
Today’s Topics: Death Table Research: Tom Galia (me) • Researched issues on the OHDSI CDM Builders forum and internal ETL documents. • Updated Google Docs spreadsheet with findings. • Potential to allow multiple death records per person to capture multiple causes of death is being considered.
Provider Table: Multiple Specialties, Clinical Titles, & Missing Specialties Melanie Philofsky • Requirement to capture providers with multiple specialties. (Only one record is allowed per provider.) • Not all specialties are represented (particularly pediatric and alternative medicine) • Requirement to know the title of provider (RN, MD, PA, etc.)
Person and Place of Service Tables: Data contains variable indicating questionable validity Ron Stewart Ron’s work with the CPRD: Clinical Practice Research Datalink (I had to look this up!) has numerous instances where data that is of questionable quality needs to be preserved rather than excluded. Christian Reich agreed that this is an issue that is getting a lot of attention. Some ideas for accommodating this were discussed. These issues were added to our Themis group for now.
Examples:
• Dates fall outside of observation period. Current practice throw records out. • Numerous observations of patient and family history fall outside of observation period.
Google Docs Spreadsheet https://docs.google.com/spreadsheets/d/1QqpmCMbN6Zcg4YxWhLVXyAP5ARD-hbiq7bv3heYKxZ0/edit#gid=0
