Has anyone else attempted the SCILHS i2b2 to CDM code on Oracle? I'm focusing on the demographics table to start with have run into a few things I wanted to share.
#1) SCILHS relies on the patient_dimension for the demographics, not the observation_fact. Just something to be aware of, not really a problem as long as you have the patient_dimension built out. #2) The demographics ontology has some rows that use the IN for the operator and some rows that use like. But the code only works for the race/sex where it is using "IN" as the operator. I added a where race.c_operator='IN' , sex.c_operator='IN' , hisp.c_operator='IN' where necessary to avoid the oracle error. #3) For Hispanic, the code is only looking at the race_cd. This only give you 'Yes' or 'No-Information' as values. I think it would make more sense to move the ethnicity information to an ethnicity_cd column. Anyone else working with the i2b2 to CDM on Oracle code? Just wondering if there are any other changes you've had to make to get it working. Thanks, Phillip ________________________________ UT Southwestern Medical Center The future of medicine, today.
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
