ref dx_lookup table needs updating

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

ref dx_lookup table needs updating #160

Closed alastairmatheson closed 10 months ago

alastairmatheson commented 1 year ago

As new ICD codes are added, we need to add to the claims.ref_dx_lookup table and set up a process for maintaining it quarterly

kai-fukutaki commented 1 year ago

Step 1: One-time multi-year update to ICD-10-CM codes is done. Previous table ICD_9_10_CM_Complete.xlsx had through 2018, so downloaded ICD-10-CM code descriptions in tabular order and bound all unique rows together. Old version of ICD_9_10_CM_Complete is in archive folder in case issues arise.

elikern-kc commented 10 months ago

This has been completed!