Stage 5 Derive SQLs

Jump to bottom

wolfderby edited this page Nov 18, 2022 · 2 revisions

Derives etc

Steps

Create Legacy Database Structures (no drop; create; no truncate) -truncates commented out
derive_unique_all_case.sql -makes LAERS data like FAERS data and removes duplicates created in process
map_all_drugname_to_rxnorm
standardize_combined_drug_mapping
derive_standard_case_outcome_category
derive_standard_case_indication.sql
derive_standard_case_outcome.sql
derive_standard_drug_outcome_count.sql
derive_standard_drug_outcome_contingency_table.sql -create index if not exists
derive_standard_drug_outcome_statistics.sql
map_meddra_to_snomed.sql
derive_standard_drug_outcome_drilldown.sql -create table if not exists -create index if not exists

Helpful Resources:

a paper to help understand the derive_unique_all_case.sql