Re: [gpc-informatics] #109: represent PCORI CDM terminology as i2b2 metadata

2015-01-29 Thread GPC Informatics
#109: represent PCORI CDM terminology as i2b2 metadata ---+-- Reporter: rwaitman | Owner: ngraham Type: enhancement| Status: assigned Priority: major | Milestone: drn-basic-query Component:

RE: HackathonTwo follow-up action items

2015-01-29 Thread Lenon Patrick
Regarding the #44 Portable Heron notes, one situation I’ve dealt with is references to a table which I do not have. From naaccr_concepts_load.sql, for instance: (select * from BlueHeronData.source_master@deid where source_cd like 'tumor_registry@%') I don’t have a “source_master” table,

RE: code sharing an HERON ETL documentation (was: HackathonTwo follow-up action items)

2015-01-29 Thread Lenon Patrick
I don’t see a source_master table here, so I’ll have to check that with Keith when he gets back. I was able to finesse it for the short term, anyway. I did succeed in finding and replicating the “normal_concept” view also referenced in naaccr_concepts_load. Thanks for the feedback. I’ll try

Medication Modifiers

2015-01-29 Thread Bos, Angela
Phillip, can you be more specific on how you populated the RX|CURRENT medication modifier? Sample code would be great. Looking at the Hackathon2 notes NateA: What does current Meds mean? Phillip: anything that was included on the encounter. Thanks! Angela Bos | UTHSCSA