sagerx

sagerx copied to clipboard

# Problem Statement We need a wholesale review of our current Airflow DAGs and dbt setup for each data source from beginning to end. # Criteria for Success Every checkbox...

jrlegrand

Full Dailymed DAG runs into error

1

# Problem Statement When trying to run DailyMed Full DAG (50,000 SPLs), I run into the error shown below. This is from the build in branch jrlegrand/dailymed # Criteria for...

jrlegrand

PIP additional requirements throws Docker error

1

# Problem Statement Right now, we have CMS Part D DAG in a "hidden_dags" folder because it was causing an error for me and at least one other person when...

jrlegrand

FDA NDC package equivalence (discrete packaging information)

3

# Proposal Parse the fda_ndc package field into a package equivalency table # Rationale adds digestible package information for people to use tied to NDCs

Bridg109

# Problem Statement We arbitrarily chose the first day of the month for the RxNorm DAG schedule, but it looks like it can be updated on days 1-6 or so...

jrlegrand

# Proposal Something like this: ``` select distinct cls.class_type , trim(cls.class_name) as class_name , cpi.ingredient_rxcui , cpi.ingredient_name , cpi.ingredient_tty from staging.stg_fda_ndc__class cls left join staging.stg_fda_ndc__ndc ndc on cls.productid = ndc.productid...

jrlegrand

# Problem Statement RXN_AI was previously named RXN_BOSS_AI and attached to SCDC prior to September 2021 release. RXN_AM was previously named RXN_BOSS_AM and attached to SCDC prior to September 2021...

jrlegrand