Hello every one
I will share with you our raw data tables and we trying to do our best with first ETL mission.
CDM Table(s) => Source table(s)
- PERSON & DEATH => Demographics Table
- VISIT_OCCURRENCE => ER,OP and IP Tables
- MEASURMENT => Lab Table
- CONDITION_OCCURRENCE => Diagnosis Table
- DRUG_EXPOSURE => Medication Table
- PROCEDURE_OCCURRENCE => Surgery Table
- OBSERVATION => Lab ,Diagnosis ,Medication and Surgery
- OBSERVATION_PERIOD => MIN(start_date) as observation_period_start_date, MAX(end_date) as observation_period_end_date from VISIT_OCCURRENCE table.
This is what we have done so far.
any comments or recommendations or guidance will be appreciated.
thanks at all.