Introduction

The RECOVER project

Background

Run the STAR COVID-19 mini-CDM Refresh process per the instructions below (link to come later)
Login to appropriate Unix server (i.e. PuTTY, SSH) that has the Datavant software installed:
1. DEV: plt-nosql01.dhe.duke.edu
2. PRD: plp-nosql01.dhe.duke.edu
Change directory to /dwhome/airflow_ci/master/dags/CDRN_ETL/Datavant/
Run the following command:
1. hash_token_load_master.sh RECOVER
Use a web browser to get to the appropriate Airflow server
1. DEV: http://plt-nosql01.dhe.duke.edu:8091/admin/
2. PRD: http://plp-nosql01.dhe.duke.edu:8083/admin/
Run the DAG STAR_Recover
Follow the steps to transfer the file via AWS per the instructions below
1. STAR RECOVER AWS S3 Info (link to come later)

Export data from HSC_PCOR.CVDNEW_PRIVATE_ADDRESS_HISTORY to CSV file.
Transfer CSV file to plt-nosql03.dhe.duke.edu, directory /dwhome/apps/CDRN/RECOVER.
Login to plt-nosql03.dhe.duke.edu
Change directory to /dwhome/apps/CDRN/RECOVER.
Run degauss.sh

	Subject Area	SQL Scripts (Links to Git Repository Location)
1	Condition	recover_condition.sql
2	Death	recover_death.sql
3	Death Cause	recover_death_cause.sql
4	Demographic	recover_demographic.sql
5	Diagnosis	recover_diagnosis.sql
6	Dispensing	recover_dispensing.sql
7	Encounter	recover_encounter.sql
8	Enrollment	recover_enrollment.sql
9	Geocoding	recover_geocoding.sql
10	Hash Token	recover_hash_token.sql
11	Immunization	recover_immunization.sql
12	Lab Results	recover_lab_result_cm.sql
13	LDS Address History	recover_lds_address_history.sql
14	Medication Administration	recover_med_admin.sql
15	Observation, Clinical	recover_obs_clin.sql
16	Observation, General	recover_obs_gen.sql
17	Prescribing	recover_prescribing.sql
18	PRO	recover_pro_cm.sql
19	Procedure	recover_procedures.sql
20	Provider	recover_provider.sql
21	Referral	recover_referral.sql
22	Vital	recover_vital.sql