search

PHSKC-APDE / claims_data

Process and analyze WA State Medicaid, Medicare, and All-Payer Claims Database eligibility and claims data
21 stars 4 forks source link

change attribution of race/ethnicity in mcaid_mcare_elig_demo #52

Open dcolombara opened 4 years ago

dcolombara commented 4 years ago

Lines 58-64 need to be changed. Currently replace race/eth data with MCARE data only if MCAID is missing. It should be if missing OR "Unknown" (while MCARE data is NOT missing and NOT "Unknown")

alastairmatheson commented 4 years ago

I just finished adding race_unk and race_eth_unk flags into the mcaid_elig_demo table today. You could use those or look in race_me and race_eth_me for "Unknown", whichever is easier (the flags come from looking at race_me and race_eth_me anyway)

dcolombara commented 4 years ago

Implement specific plan for implementing changes to Mcare & Mcare-Mcaid race attribution based on conversation 12/10/2019

From: Dawadi, Shuva sdawadi@kingcounty.gov Sent: Tuesday, December 10, 2019 3:58 PM

Race/ethnicity conversation: All analysis of Medicare race data – use the RTI race categories; RTI algorithm data is better than nothing; Hierarchical data: Medicaid (for linked duals), Medicare RTI (white or black) and then rest unknown; Other race data sources? License data, Death data, housing data (need to talk DSA), LTSS for King county (ADS), CHARS (but that’s further out), Medicare advantage with commercial

dcolombara commented 4 years ago

Discussed with Susan on 2/20/2020 and decided to post-pone changes until after ETL team can discuss the way forward based on Susan's research and emails received from PHA.