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 https://gitlab.dhe.duke. |
|
|
| 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/STARhash_create_indexestoken.sql?ref_type=heads |
|
|
| STARhash_replacetoken_etl_viewsCDM61.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/STARhash_replacetoken_etl_viewsCDM61.sql?ref_type=heads |
|
|
| cdrnhash_addrtoken_infoN3C.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/cdrnhash_addrtoken_infoN3C.sql?ref_type=heads |
|
|
| cdrnhash_all_enctoken_clinbackfill.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/cdrnhash_alltoken_enc_clinbackfill.sql?ref_type=headscdrn_all_enc_hosp |
|
|
| immunization.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/cdrn_all_enc_hospimmunization.sql?ref_type=headscdrn |
|
|
| lab_result_cm_all_enc_oayears.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/cdrnlab_result_cm_all_enc_oayears.sql?ref_type=heads |
|
|
| cdrnlds_medsaddress_infohistory.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/cdrnlds_medsaddress_infohistory.sql?ref_type=heads |
|
|
| comparemed_rptadmin.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/comparemed_rptadmin.sql?ref_type=heads |
|
|
| conditionobs_clin_all.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/conditionobs_clin_all.sql?ref_type=heads |
|
|
| deathobs_clin_flowsheet.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/deathobs_clin_flowsheet.sql?ref_type=headsdeath |
|
|
| obs_clin_causepft.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/deathobs_clin_causepft.sql?ref_type=heads |
|
|
| demoobs_clin_rptsmoking.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/demoobs_clin_rptsmoking.sql?ref_type=heads |
|
|
| demographicobs_clin_vitals.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/demographicobs_clin_vitals.sql?ref_type=heads | diagnosis
|
|
| obs_clin_vitals_legacy.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/ | diagnosisobs_clin_vitals_legacy.sql?ref_type=heads |
|
|
| dispensingobs_per_yeargen.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensingobs_per_yeargen.sql?ref_type=headsdispensing |
|
|
| obs_per_year_Surescript_Step1gen_adt.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensingobs_per_year_Surescript_Step1gen_adt.sql?ref_type=headsdispensing |
|
|
| obs_per_year_Surescript_Step2gen_sdoh.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensingobs_per_year_Surescript_Step2gen_sdoh.sql?ref_type=heads |
|
|
| dispensing_useobs_incgen_loadvent.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/dispensingobs_usegen_inc_loadvent.sql?ref_type=heads |
|
|
| encounterpcornet_trial.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/encounterpcornet_trial.sql?ref_type=headsencounter_dedup |
|
|
| prescribing.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/encounter_dedupprescribing.sql?ref_type=headsenrollment |
|
|
| prescribing_mixture_broken_out.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/enrollmentprescribing_mixture_broken_out.sql?ref_type=heads |
|
|
| harvestprescribing_update_rx_basis.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/harvestprescribing_update_rx_basis.sql?ref_type=heads |
|
|
| harvestprivate_address_CDM61geocode.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/harvestprivate_address_CDM61geocode.sql?ref_type=heads
|
|
|
| hashprivate_address_tokenhistory.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hashprivate_address_tokenhistory.sql?ref_type=headshash |
|
|
| private_token_CDM61demographic.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hashprivate_token_CDM61demographic.sql?ref_type=headshash |
|
|
| private_tokendemographic_N3Cdedup.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hashprivate_tokendemographic_N3Cdedup.sql?ref_type=headshash |
|
|
| pro_token_backfillcm.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/hashpro_token_backfillcm.sql?ref_type=heads |
|
|
| immunizationpro_cm_sdoh.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/immunizationpro_cm_sdoh.sql?ref_type=headslab_result |
|
|
| _cm_all_yearsprocedures.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/lab_result_cm_all_yearsprocedures.sql?ref_type=heads |
|
|
| ldsprocedures_address_historycaboodle.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/ldsprocedures_address_historycaboodle.sql?ref_type=heads |
|
|
| med_adminprovider.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/med_adminprovider.sql?ref_type=heads |
|
|
| obs_clin_allreferral.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_allreferral.sql?ref_type=headsobs |
|
|
| refresh_clinstats_flowsheetupdate.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obsrefresh_clinstats_flowsheetupdate.sql?ref_type=headsobs |
|
|
| remove_clindup_pftkeys.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obsremove_clindup_pftkeys.sql?ref_type=headsobs_clin_smoking |
|
|
| rename_etl_tables_no_drop.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_smokingrename_etl_tables_no_drop.sql?ref_type=headsobs_clin |
|
|
| _vitalsrename_etl_tables_w_drop.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_vitalsrename_etl_tables_w_drop.sql?ref_type=heads |
|
|
| obs_clin_vitals_legacyvital.sql https://gitlab.dhe.duke.edu/edw-foundations/cdrn/airflowetl/-/blob/master/projSql/CDRN_ETL/STAR/MainETL/obs_clin_vitals_legacyvital.sql?ref_type=heads |
|
|