Thank you Phillip! To get this to work, I did remap to concept_cd, concept_dimension just like our current I2B2.
--- Debbie Yoshihara From: Phillip Reeder [mailto:[email protected]] Sent: Wednesday, February 22, 2017 10:37 AM To: Wanta Keith M; Debbie Yoshihara; gpc-dev Subject: Re: SCILHS ontology for demographics The nice thing about SHRINE is that it doesn't require the same i2b2 terminology/dimension at each site. So if we're using the SCILHS ontology in SHRINE, I can modify my local terminology to hit my concept dimension or custom "Ethnicity_cd" of the patient dimension, and the counts that are run will return correctly thanks to this shrine mapping file's translation of the query and i2b2's use of the path vs concept_cd. I would agree that i2b2 needs to add an ethnicity_cd column to it's standard patient_dimension table. But that shouldn't stop us from being able to use it with SHIRNE. Phillip From: Gpc-dev <[email protected]<mailto:[email protected]>> on behalf of Wanta Keith M <[email protected]<mailto:[email protected]>> Date: Wednesday, February 22, 2017 at 10:23 AM To: Yoshihara Deborah L <[email protected]<mailto:[email protected]>>, gpc-dev <[email protected]<mailto:[email protected]>> Subject: RE: SCILHS ontology for demographics All, To elaborate on Debbie's question here, let me expand a bit. RACE_CD is a standard column in PATIENT_DIMENSION. Ethnicity does not have a standard column in PATIENT_DIMENSION, but many of us in GPC added to a custom PATIENT_DIMENSION table in order to support a CDM requirement. Ideally, GPC should propose to Partners to add a standard column to the i2b2 PATIENT_DIMENSION table, especially since CDM requires this data? I guess these organizations are not the same, but they all work together, and many of the same people are somewhat involved in the PCORI/CDM project. In the short term and as an alternative, we could propose a new standard SCILHS concept named "SCILHS: ETHNICITY" and use the CONCEPT_DIMENSION instead. Or in GPC, we could have a standard ethnicity concept named "GPC: ETHNICITY". It just makes sense to have a standard concept to represent a standard CDM attribute. --- Keith M. Wanta UW Health From: Gpc-dev [mailto:[email protected]] On Behalf Of Debbie Yoshihara Sent: Wednesday, February 22, 2017 7:41 AM To: gpc-dev Subject: SCILHS ontology for demographics Hi, How are sites handling that both ETHNICITY and RACE are referred to the RACE_CD in table PATIENT_DIMENSION for the SCILHS 2.02 ontology? For example, ETHNICITY:HISPANIC and RACE:01 have C_FACTTABLECOLUMN PATIENT_NUM, C_TABLENAME PATIENT_DIMENSION, C_COLUMNNAME RACE_CD. So you can have an ethnicity or a race but not both. --- Debbie ________________________________ UT Southwestern Medical Center The future of medicine, today.
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
