RAW_RX_MED_NAME? RE: data collection for next-D: i2b2, babel, OMOP, PCORnet CDM, ACS, geocoding

2016-12-01 Thread Dan Connolly
In the "People with at least one ordered medications specific to Diabetes Mellitus" query, I see: where ( UPPER(a.RAW_RX_MED_NAME) like UPPER('%Acetohexamide%') or UPPER(a.RAW_RX_MED_NAME) like UPPER('%D[i,y]melor%') or ... I don't think we populate RAW_RX_MED_NAME. We being KUMC. Not sure abou

Re: RAW_RX_MED_NAME? RE: data collection for next-D: i2b2, babel, OMOP, PCORnet CDM, ACS, geocoding

2016-12-01 Thread Al'ona Furmanchuk
If you do not populate raw values in pcornet, use any other field with name you have in your database. Only condition must be met when using it make sure med is prescribed med, not home or any other med such as current meds and so on. using any type of meds will cause significant change in cohor

denominator is everybody with two visits? RE: data collection for next-D: i2b2, babel, OMOP, PCORnet CDM, ACS, geocoding

2016-12-01 Thread Dan Connolly
We talked about 10s of thousands; now I read: 1. Denominator or study population Minimum two encounters (inpatient, outpatient, and emergency ΜΆ see Part A1 in Appendix A) in EDW at any time on different days. AND age between 18 and 89 years old at time of encounter. Age is defined as a diff