ncats / CTSA-Metrics

17 stars 16 forks source link

ACT MSSQL 2022 #44

Closed DarrenWHenderson closed 2 years ago

DarrenWHenderson commented 2 years ago

Added top concept_cd checks from tsv files.

This commit is the first pass for ACT for 2022 on MSSQL. It adds a programmatic way to grab the tsv files for the top concept codes uploaded by @mim18 if a site would prefer to make use of that, but that is optional. The script does however rely on those tables being loaded by some method into a single table with a vocabulary column added. I opted to go the oledb automation route so that if needed, we could update the top code tsv in the repo, and sites could refresh their code tables for this piece of the metrics easily.