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

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