Subject Area | SQL Scripts (Links to Git Repository Location) | Notes | |
---|
Python DAG | STAR_ETL_Master.py | Embedded SQL within Python code. May be able to pull out and place into own SQL file. |
|
| CVD19GetPatKeys.sql |
|
|
| STAR_create_etl_tables.sql |
|
|
| STAR_create_etl_tables_CDM61.sql |
|
|
| STAR_create_indexes.sql |
|
|
| STAR_replace_etl_views.sql |
|
|
| cdrn_addr_info.sql |
|
|
| cdrn_all_enc_clin.sql |
|
|
| cdrn_all_enc_hosp.sql |
|
|
| cdrn_all_enc_oa.sql |
|
|
| cdrn_meds_info.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/cdrn_meds_info.sql?ref_type=heads | compare_rpt.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/compare_rpt.sql?ref_type=heads | condition.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/condition.sql?ref_type=heads | death.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/death.sql?ref_type=heads | death_cause.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/death_cause.sql?ref_type=heads | demo_rpt.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/demo_rpt.sql?ref_type=heads | demographic.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/demographic.sql?ref_type=heads | diagnosis.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/diagnosis.sql?ref_type=heads | dispensing_per_year.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensing_per_year.sql?ref_type=heads | dispensing_per_year_Surescript_Step1.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensing_per_year_Surescript_Step1.sql?ref_type=heads | dispensing_per_year_Surescript_Step2.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensing_per_year_Surescript_Step2.sql?ref_type=heads | dispensing_use_inc_load.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensing_use_inc_load.sql?ref_type=heads | encounter.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/encounter.sql?ref_type=heads | encounter_dedup.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/encounter_dedup.sql?ref_type=heads | enrollment.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/enrollment.sql?ref_type=heads | harvest.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/harvest.sql?ref_type=heads | harvest_CDM61.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/harvest_CDM61.sql?ref_type=heads | hash_token.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hash_token.sql?ref_type=heads | hash_token_CDM61.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hash_token_CDM61.sql?ref_type=heads | hash_token_N3C.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hash_token_N3C.sql?ref_type=heads | hash_token_backfill.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hash_token_backfill.sql?ref_type=heads | immunization.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/immunization.sql?ref_type=heads | lab_result_cm_all_years.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/ |
|
|
| compare_rpt.sql |
|
|
| condition.sql |
|
|
| death.sql |
|
|
| death_cause.sql |
|
|
| demo_rpt.sql |
|
|
| demographic.sql |
|
|
| diagnosis.sql |
|
|
| dispensing_per_year.sql |
|
|
| dispensing_per_year_Surescript_Step1.sql |
|
|
| dispensing_per_year_Surescript_Step2.sql |
|
|
| dispensing_use_inc_load.sql |
|
|
| encounter.sql |
|
|
| encounter_dedup.sql |
|
|
| enrollment.sql |
|
|
| harvest.sql |
|
|
| harvest_CDM61.sql |
|
|
| hash_token.sql |
|
|
| hash_token_CDM61.sql |
|
|
| hash_token_N3C.sql |
|
|
| hash_token_backfill.sql |
|
|
| immunization.sql |
|
|
| lab_result_cm_all_years.sql ?ref_type=heads |
|
|
| lds_address_history.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/lds_address_history.sql?ref_type=heads |
|
|
| med_admin.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/med_admin.sql?ref_type=heads |
|
|
| obs_clin_all.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_all.sql?ref_type=heads |
|
|
| obs_clin_flowsheet.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_flowsheet.sql?ref_type=heads |
|
|
| obs_clin_pft.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_pft.sql?ref_type=heads |
|
|
| obs_clin_smoking.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_smoking.sql?ref_type=heads |
|
|
| obs_clin_vitals.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_vitals.sql?ref_type=heads |
|
|
| obs_clin_vitals_legacy.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_vitals_legacy.sql?ref_type=heads |
|
|
| obs_gen.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_gen.sql?ref_type=heads |
|
|
| obs_gen_adt.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_gen_adt.sql?ref_type=heads |
|
|
| obs_gen_sdoh.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_gen_sdoh.sql?ref_type=heads |
|
|
| obs_gen_vent.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_gen_vent.sql?ref_type=heads |
|
|
| pcornet_trial.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/pcornet_trial.sql?ref_type=heads |
|
|
| prescribing.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/prescribing.sql?ref_type=heads |
|
|
| prescribing_mixture_broken_out.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/prescribing_mixture_broken_out.sql?ref_type=heads |
|
|
| prescribing_update_rx_basis.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/prescribing_update_rx_basis.sql?ref_type=heads |
|
|
| private_address_geocode.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/private_address_geocode.sql?ref_type=heads
|
|
|
| private_address_history.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/private_address_history.sql?ref_type=heads |
|
|
| private_demographic.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/private_demographic.sql?ref_type=heads |
|
|
| private_demographic_dedup.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/private_demographic_dedup.sql?ref_type=heads |
|
|
| pro_cm.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/pro_cm.sql?ref_type=heads |
|
|
| pro_cm_sdoh.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/pro_cm_sdoh.sql?ref_type=heads |
|
|
| procedures.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/procedures.sql?ref_type=heads |
|
|
| procedures_caboodle.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/procedures_caboodle.sql?ref_type=heads |
|
|
| provider.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/provider.sql?ref_type=heads |
|
|
| referral.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/referral.sql?ref_type=heads |
|
|
| refresh_stats_update.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/refresh_stats_update.sql?ref_type=heads |
|
|
| remove_dup_keys.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/remove_dup_keys.sql?ref_type=heads |
|
|
| rename_etl_tables_no_drop.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/rename_etl_tables_no_drop.sql?ref_type=heads |
|
|
| rename_etl_tables_w_drop.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/rename_etl_tables_w_drop.sql?ref_type=heads |
|
|
| vital.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/vital.sql?ref_type=heads |
|
|