PIH/zl-etl issues and pull requests

#145 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#144 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#143 - Uhm 7213

Pull Request - State: closed - Opened by dmdesimone over 1 year ago

#142 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#141 - UHM-7196 Adding ncd_enrollment_location

Pull Request - State: closed - Opened by jmbabazi over 1 year ago

#140 - Uhm 7215

Pull Request - State: closed - Opened by dmdesimone over 1 year ago

#139 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#138 - uhm-7195 choose inh info from latest visit

Pull Request - State: closed - Opened by dmdesimone over 1 year ago

#137 - UHM-7182: Add actual time to timestamps in lab module exports

Pull Request - State: closed - Opened by mogoodrich over 1 year ago

#136 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#135 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#134 - Adding inh columns

Pull Request - State: closed - Opened by jmbabazi over 1 year ago

#133 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#132 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#131 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#130 - uhm-7172 add monthly_arv_status

Pull Request - State: closed - Opened by dmdesimone over 1 year ago

#129 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#128 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#127 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#126 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#125 - add oncology_table

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#124 - uhm-7171 add denial as reason not on arv

Pull Request - State: closed - Opened by dmdesimone over 1 year ago

#123 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#122 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#121 - proposed changes for mch_diagnosis table

Pull Request - State: closed - Opened by jmbabazi over 1 year ago

#120 - all procedures table

Pull Request - State: closed - Opened by jmbabazi over 1 year ago

#119 - UHM-6713 - All encounters table utilizing incremental loading

Pull Request - State: closed - Opened by mseaton over 1 year ago

#118 - UHM-7066 - Include initial enrollment date on hiv_patient_summary_sta…

Pull Request - State: closed - Opened by mseaton over 1 year ago

#117 - Uhm 7049

Pull Request - State: closed - Opened by dmdesimone over 1 year ago

#116 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#115 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#114 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#113 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#112 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#111 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#110 - commit changes to data quality tables

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#109 - update date quality tables

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#108 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#107 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#106 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#105 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#104 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#103 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#102 - commit

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#101 - update hiv_status

Pull Request - State: closed - Opened by aibrahem550 over 1 year ago

#100 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#99 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#98 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#97 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#96 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#95 - Update_eid_visits_v4

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#94 - fix eid_visits v3

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#93 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#92 - eid_visits update index script

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#91 - remove datakind_encounter

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#90 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#89 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#88 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#87 - Data_quality_details_v1

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#86 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#85 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#84 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#83 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#82 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#81 - commit

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#80 - data_quality_log_summary

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#79 - uhm-7048 add tb prophylaxis

Pull Request - State: closed - Opened by dmdesimone almost 2 years ago

#78 - update index script - v1

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago

#77 - UHM 7023 MCH diagnoses

Pull Request - State: closed - Opened by jmbabazi almost 2 years ago

#76 - remove index from scripts and add to update index

Pull Request - State: closed - Opened by aibrahem550 almost 2 years ago - 1 comment

#75 - Adding bulk import parameter

Pull Request - State: closed - Opened by jmbabazi almost 2 years ago

#74 - Uhm 7031

Pull Request - State: closed - Opened by jmbabazi almost 2 years ago

#73 - add latest_arv_dispensed

Pull Request - State: closed - Opened by dmdesimone almost 2 years ago

#72 - Uhm 6904

Pull Request - State: closed - Opened by dmdesimone almost 2 years ago

#71 - commit

Pull Request - State: open - Opened by aibrahem550 about 2 years ago

#70 - Uhm 6713 add all encounters table

Pull Request - State: open - Opened by dmdesimone about 2 years ago

#69 - eid followup visit etl

Pull Request - State: closed - Opened by jmbabazi about 2 years ago

#68 - Create all_encounters_staging.sql

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#67 - Delete all_encounters.sql

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#66 - Uhm 6713 zl dwh encounters table

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#65 - Remove all visits

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#64 - make views temp tables

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#63 - Uhm 6793 clean up permanent tables created by et ls

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#62 - fix next/last visit_dates uhm-6781

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#61 - Uhm 6765

Pull Request - State: closed - Opened by mseaton about 2 years ago

#60 - adding suspected STI Treatment

Pull Request - State: closed - Opened by jmbabazi about 2 years ago

#59 - Temp user logins fix

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#58 - Uhm 6756 indexes

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#57 - Uhm 6756 fix

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#56 - Uhm 6756 all visits

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#55 - data warning for hiv intake, followup dispensing and exposed infant f…

Pull Request - State: closed - Opened by jmbabazi about 2 years ago

#54 - Uhm 6760 location of delivery

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#53 - UHM-6732 - Add derived tables at end of refresh-zl-warehouse.yml

Pull Request - State: closed - Opened by mseaton about 2 years ago

#52 - commit changes

Pull Request - State: closed - Opened by aibrahem550 about 2 years ago

#51 - Add "Partner's HIV Status" uhm-6746

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#50 - Uhm 6745 add nickname

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#49 - UHM-6752 - Enable adding user login data to ETLs conditionally if the…

Pull Request - State: closed - Opened by mseaton about 2 years ago

#48 - Uhm 6713 all encounters table

Pull Request - State: closed - Opened by dmdesimone about 2 years ago

#47 - UHM-6662 - Reconfigure HIV pipeline so HIV "analysis" jobs only depen…

Pull Request - State: closed - Opened by mseaton about 2 years ago

#46 - UHM-6688 - ETL/Export of historical login information

Pull Request - State: closed - Opened by mseaton about 2 years ago

GitHub / PIH/zl-etl issues and pull requests