tuva-health / tuva

Main repo including core data model, data marts, reference data, terminology, and the clinical concept library
https://thetuvaproject.com/
172 stars 41 forks source link

Refactor code and description columns #508

Closed thutuva closed 2 months ago

thutuva commented 2 months ago

Describe your changes

Please include a summary of any changes. This PR performs two major changes:

  1. Adding description columns next to code column (e.g. adding ndc_description next to ndc_code)
  2. Changing NPI columns to ID to clarify JOIN (e.g. billing_npi > billing_id; JOIN on practitioner_id) and adding facility or practitioner names

How has this been tested?

Please describe the tests you ran to verify your changes. Provide instructions or code to reproduce output.

Reviewer focus

Please summarize the specific items you’d like the reviewer(s) to look into. Confirm all column have been changed from NPI to ID and descriptions are added where needed

Checklist before requesting a review

Package release checklist

(Optional) Gif of how this PR makes you feel

Loom link

https://www.loom.com/share/7b8a5e35d9074c80a3f8ba64752381d0?sid=45acd976-572b-4f3c-ba4b-152397c1de8f