RE: GPC-Dev Agenda 4-21
Sorry for the late request, but could we add the following topic for the obesity survey: What version of Redcap are you running? How soon could your site potentially achieve 6.1.x? We would like to use Redcap “access code” functionality introduced in 6.1.0. Used in conjunction with participant lists, it allows a user to enter a general survey URL, then requires them to enter a non-case-sensitive 9-character access code to go to their unique survey link. -Angela | UTHSCSA From: gpc-dev-boun...@listserv.kumc.edu [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Dan Connolly Sent: Monday, April 20, 2015 3:30 PM To: Apathy,Nate; gpc-dev@listserv.kumc.edu Subject: RE: GPC-Dev Agenda 4-21 Thanks for getting the ball rolling, Nate. I went over our business and made some adjustments. Note in particular that I dropped items where I couldn't find an update shared with the group. Reminder: if anyone wants something on the agenda, please send mail or update a ticket before 10am Monday. You can, of course, ask to have something added when we review the agenda at the beginning of the call, but things work better if materials are available in advance. 1.Convene, take roll, review records and plan next meeting. a.Meeting ID and access code: 817-393-381https://global.gotomeeting.com/meeting/join/817393381; call +1 (571) 317-3131 b.roll: all 10 DevTeamshttps://informatics.gpcnetwork.org/trac/Project/wiki/DevTeams represented? i.KUMC, CMH, UIOWA, WISC, MCW, MCRF, UMN, UNMC, UTHSCSA, UTSW, (MU), (IU) ii.Reminder - put institution after your name on the GoToMeeting (preferences) c.meeting notes (#12https://informatics.gpcnetwork.org/trac/Project/ticket/12): previous notes OK? today's scribe: Nate A (Cerner/CMH) comments on the agenda? chair dropped items where no update was available as of ~T-24hrs .recent tickets opened/closed FYI: 1.#165:https://informatics.gpcnetwork.org/trac/Project/ticket/165 PopMedNet @ UTSW - closed 2.#270http://informatics.gpcnetwork.org/trac/Project/ticket/270 - Port Q1 QA query to Oracle opened 3.note also recent ticket comments reporthttps://informatics.gpcnetwork.org/trac/Project/report/13 d.Next Meeting April 28th: scribe? 2.#78 Shared GPC RxNORM/NDFRT medications ontologyhttps://informatics.gpcnetwork.org/trac/Project/ticket/78 re-opened; also #236https://informatics.gpcnetwork.org/trac/Project/ticket/236 . Nate sent list of non-SCDF codeshttp://listserv.kumc.edu/pipermail/gpc-dev/2015q2/001525.html to group 3.#158 Usable LOINC Labs - March 27 commenthttps://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:28 proposes that Jan 19 detailshttps://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:20 suffice . KUMC’s experience is positive so far, though we haven’t released a.is what’s on babel consistent with Jan 19 details? 4. milestone:data-quality3https://informatics.gpcnetwork.org/trac/Project/milestone/data-quality3 . #270 (Port Q1 QA query to Oracle) closedhttps://informatics.gpcnetwork.org/trac/Project/ticket/270#comment:2 5.milestone:bc-survey-cohort-def (depgraphhttps://informatics.gpcnetwork.org/trac/Project/depgraph/ticket/227): . #271https://informatics.gpcnetwork.org/trac/Project/ticket/271 IRB-wait a.#264https://informatics.gpcnetwork.org/trac/Project/ticket/264 confirm governance and workflow: ~7 sites responded 6.Milestone: obesity-survey-defhttps://informatics.gpcnetwork.org/trac/Project/milestone/obesity-survey-def . #252 test results from wischttps://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:5 7. milestone:cohort-char1https://informatics.gpcnetwork.org/trac/Project/milestone/cohort-char1 . #258https://informatics.gpcnetwork.org/trac/Project/ticket/258 volunteer to take a whack at breast cancer treatment from NAACCR? 8.#242https://informatics.gpcnetwork.org/trac/Project/ticket/242 - Nate A. asks Apr 16 “where can we find the necessary attachments and code to attempt this? ...” 1. milestone:data-domains3 currently has no due date; is that OK? are there any customers waiting? -- Dan From: gpc-dev-boun...@listserv.kumc.edumailto:gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Apathy,Nate [nate.apa...@cerner.com] Sent: Monday, April 20, 2015 9:50 AM To: gpc-dev@listserv.kumc.edumailto:gpc-dev@listserv.kumc.edu Subject: GPC-Dev Agenda 4-21 Hi all - I’ve started the agenda/notes dochttps://docs.google.com/document/d/1W0zFvJwC0S20vzumCI-roRNoo2ux-M6uJNx2o7E4TrY/edit?usp=sharing for tomorrow’s dev call and everyone should have access to edit. Much of the agenda below is follow-up from last week. Let me know if there are specific items to include on this agenda
RE: [gpc-informatics] #78: shared GPC RxNORM/NDFRT medications ontology
I agree except in the case of Generic packs and Branded pack formulations which are reported in the NLM documentation to be the sole exceptions to SCDF and SBDF 'prescribable drug' status. These four RXNORM code types should be the 'clinical prescription/order' codes for our inpatient orders and outpatient prescriptions. Jim From: GPC Informatics [d...@madmode.com] Sent: Monday, April 20, 2015 4:56 PM To: Campbell, James R; ngra...@kumc.edu; dconno...@kumc.edu; mh...@kumc.edu; b...@uthscsa.edu Cc: nate.apa...@cerner.com; aaron.me...@cerner.com Subject: Re: [gpc-informatics] #78: shared GPC RxNORM/NDFRT medications ontology #78: shared GPC RxNORM/NDFRT medications ontology -+ Reporter: campbell | Owner: ngraham Type: enhancement | Status: closed Priority: major| Milestone: data-domains2 Component: data-stds| Resolution: fixed Keywords: onc-stds | Blocked By: Blocking: 181 | -+ Changes (by ngraham): * cc: nateapathy, Aaron.Meyer@… (added) * status: reopened = closed * resolution: = fixed Comment: I chatted with Aaron on the phone and I think we're on the same page with respect to the SCDF/SBDF being the lowest (most granular) level of the current GPC medications ontology. Aaron noted that he's not concerned with the current design and he doesn't have any questions at this time. He said that ~30% of their order volume (CMH I suppose? I didn't think to clarify on the phone) is currently mapped to the GPC ontology. For the remaining ~70%, they have the RxCUIs (via NDC) but the code to map these CUI's to the parent SCDF/SBDF via the !RxNorm relationship table(s) hasn't been completed yet. I suggested that ([https://informatics.kumc.edu/work/browser/heron_load/epic_med_mapping.sql epic_med_mapping.sql]) might be a useful reference. It's likely not directly reusable of course - for one thing, at KU most of our medications map to !RxNorm via GCN rather than NDC (in fact, the KU code doesn't even bother with [http://www.nlm.nih.gov/research/umls/rxnorm/NDC_Normalization_Code.rtf NDC normalization]). I've created #272 to keep track of the question from comment:14 regarding obsolete terms. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/78#comment:16 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #238: Q1 2015 QA Query
#238: Q1 2015 QA Query --+ Reporter: mish | Owner: mish Type: enhancement | Status: assigned Priority: major | Milestone: data-quality3 Component: data-quality | Resolution: Keywords: data-quality | Blocked By: Blocking: 232, 262 | --+ Comment (by mish): I think that Nathan Graham as some feedback he'd like to give yet. We'll ask tomorrow and then close the ticket if he's good. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:21 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #252: collect test results of Weight and Height cohort selection queries from all sites
#252: collect test results of Weight and Height cohort selection queries from all sites --+- Reporter: bokov | Owner: bokov Type: task | Status: assigned Priority: major | Milestone: obesity-survey-def Component: data-sharing | Resolution: Keywords:| Blocked By: 210, 250, 251 Blocking: 254 | --+- Changes (by dconnolly): * owner: gkowalski = bokov Comment: Alex, we have test info from WISC now; do you have responses from any other sites? If so, which? -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:6 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
RE: GPC-Dev Agenda 4-21
Thanks for getting the ball rolling, Nate. I went over our business and made some adjustments. Note in particular that I dropped items where I couldn't find an update shared with the group. Reminder: if anyone wants something on the agenda, please send mail or update a ticket before 10am Monday. You can, of course, ask to have something added when we review the agenda at the beginning of the call, but things work better if materials are available in advance. 1. Convene, take roll, review records and plan next meeting. * Meeting ID and access code: 817-393-381https://global.gotomeeting.com/meeting/join/817393381; call +1 (571) 317-3131 * roll: all 10 DevTeamshttps://informatics.gpcnetwork.org/trac/Project/wiki/DevTeams represented? * KUMC, CMH, UIOWA, WISC, MCW, MCRF, UMN, UNMC, UTHSCSA, UTSW, (MU), (IU) * Reminder - put institution after your name on the GoToMeeting (preferences) * meeting notes (#12https://informatics.gpcnetwork.org/trac/Project/ticket/12): previous notes OK? today's scribe: Nate A (Cerner/CMH) comments on the agenda? chair dropped items where no update was available as of ~T-24hrs * recent tickets opened/closed FYI: * #165:https://informatics.gpcnetwork.org/trac/Project/ticket/165 PopMedNet @ UTSW - closed * #270http://informatics.gpcnetwork.org/trac/Project/ticket/270 - Port Q1 QA query to Oracle opened * note also recent ticket comments reporthttps://informatics.gpcnetwork.org/trac/Project/report/13 * Next Meeting April 28th: scribe? 2. #78 Shared GPC RxNORM/NDFRT medications ontologyhttps://informatics.gpcnetwork.org/trac/Project/ticket/78 re-opened; also #236https://informatics.gpcnetwork.org/trac/Project/ticket/236 * Nate sent list of non-SCDF codeshttp://listserv.kumc.edu/pipermail/gpc-dev/2015q2/001525.html to group 3. #158 Usable LOINC Labs - March 27 commenthttps://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:28 proposes that Jan 19 detailshttps://informatics.gpcnetwork.org/trac/Project/ticket/158#comment:20 suffice * KUMC’s experience is positive so far, though we haven’t released * is what’s on babel consistent with Jan 19 details? 4. milestone:data-quality3https://informatics.gpcnetwork.org/trac/Project/milestone/data-quality3 * #270 (Port Q1 QA query to Oracle) closedhttps://informatics.gpcnetwork.org/trac/Project/ticket/270#comment:2 5. milestone:bc-survey-cohort-def (depgraphhttps://informatics.gpcnetwork.org/trac/Project/depgraph/ticket/227): * #271https://informatics.gpcnetwork.org/trac/Project/ticket/271 IRB-wait * #264https://informatics.gpcnetwork.org/trac/Project/ticket/264 confirm governance and workflow: ~7 sites responded 6. Milestone: obesity-survey-defhttps://informatics.gpcnetwork.org/trac/Project/milestone/obesity-survey-def * #252 test results from wischttps://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:5 7. milestone:cohort-char1https://informatics.gpcnetwork.org/trac/Project/milestone/cohort-char1 * #258https://informatics.gpcnetwork.org/trac/Project/ticket/258 volunteer to take a whack at breast cancer treatment from NAACCR? 8. #242https://informatics.gpcnetwork.org/trac/Project/ticket/242 - Nate A. asks Apr 16 “where can we find the necessary attachments and code to attempt this? ...” 9. milestone:data-domains3 currently has no due date; is that OK? are there any customers waiting? -- Dan From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Apathy,Nate [nate.apa...@cerner.com] Sent: Monday, April 20, 2015 9:50 AM To: gpc-dev@listserv.kumc.edu Subject: GPC-Dev Agenda 4-21 Hi all - I’ve started the agenda/notes dochttps://docs.google.com/document/d/1W0zFvJwC0S20vzumCI-roRNoo2ux-M6uJNx2o7E4TrY/edit?usp=sharing for tomorrow’s dev call and everyone should have access to edit. Much of the agenda below is follow-up from last week. Let me know if there are specific items to include on this agenda that are not represented. (I promise the gdoc formatting is better than what’s below ☺) 1. Convene, take roll, review records and plan next meeting. 1. Meeting ID and access code: 817-393-381https://global.gotomeeting.com/meeting/join/817393381; call +1 (571) 317-3131 2. meeting notes (#12https://informatics.gpcnetwork.org/trac/Project/ticket/12): previous notes OK? today's scribe: Nate A (Cerner/CMH) Next Meeting April 28th: 3. roll: all 10 DevTeamshttps://informatics.gpcnetwork.org/trac/Project/wiki/DevTeams represented? comments on the agenda? 1. KUMC, CMH, UIOWA, WISC, MCW, MCRF, UMN, UNMC, UTHSCSA, UTSW, (MU), (IU) 2. Reminder - put institution after your name on the GoToMeeting (preferences) 1. recent tickets
Re: [gpc-informatics] #238: Q1 2015 QA Query
#238: Q1 2015 QA Query --+- Reporter: mish | Owner: jvanschyndle@… Type: enhancement | Status: assigned Priority: major | Milestone: data-quality3 Component: data-quality | Resolution: Keywords: data-quality | Blocked By: Blocking: 232, 262 | --+- Comment (by dconnolly): Tom, preparing for tomorrow's call, I don't see any updates from any of the sites. So the soonest I can see this getting done is two weeks - a week for sites to do their thing and a week for the review and write-up. I updated milestone:data-quality3 to agenda-time (10am) on May 4. Feel free to do this sort of milestone update yourself, keeping in mind one caveat: it's important to make a comment on a relevant ticket as well as editing the milestone for two reasons: 1. to notify relevant people (trac doesn't send notifications when milestones are edited) 2. to leave an audit trail (trac doesn't keep old versions of milestone info) -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:18 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #238: Q1 2015 QA Query
#238: Q1 2015 QA Query --+ Reporter: mish | Owner: mish Type: enhancement | Status: assigned Priority: major | Milestone: data-quality3 Component: data-quality | Resolution: Keywords: data-quality | Blocked By: Blocking: 232, 262 | --+ Changes (by dconnolly): * owner: jvanschyndle@… = mish Comment: Tom, are you guys still working on developing the query? Is there feedback on the SQL code that you're currently addressing? If there's no outstanding feedback that you know of, please close this ticket. p.s. full email addresses work fine in the cc field, but for the owner field, I much prefer to stick to trac account names. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:20 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #238: Q1 2015 QA Query
#238: Q1 2015 QA Query --+- Reporter: mish | Owner: jvanschyndle@… Type: enhancement | Status: assigned Priority: major | Milestone: data-quality3 Component: data-quality | Resolution: Keywords: data-quality | Blocked By: Blocking: 232, 262 | --+- Comment (by lv): Results for MCRF were sent to Tom on Wednesday, April 15. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:19 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #270: Port Q1 QA query to Oracle
#270: Port Q1 QA query to Oracle --+ Reporter: dconnolly | Owner: mikemunns Type: enhancement | Status: closed Priority: major | Milestone: data-quality3 Component: data-sharing | Resolution: fixed Keywords:| Blocked By: Blocking: 232, 262 | --+ Changes (by dconnolly): * status: new = closed * resolution: = fixed Comment: Ah. Mike attached it on Apr 16: attachment:UNMC_March_2015_Quality_Query_4_1_2015v6.sql:ticket:262 -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/270#comment:2 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #270: Port Q1 QA query to Oracle
#270: Port Q1 QA query to Oracle --+ Reporter: dconnolly | Owner: mikemunns Type: enhancement | Status: new Priority: major | Milestone: data-quality3 Component: data-sharing | Resolution: Keywords:| Blocked By: Blocking: 232, 262 | --+ Comment (by dconnolly): While Mike has the ball, Nathan reports progress in ticket:238#comment:17. I can't quite tell if KUMC's results (#262) are still blocked by this, so I'm leaving the blocking relationship in place. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/270#comment:1 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
Re: [gpc-informatics] #210: Query by BMI percentile among children.
#210: Query by BMI percentile among children. -+- Reporter: bokov| Owner: huhickman Type: enhancement | Status: assigned Priority: major| Milestone: obesity- Component: data-stds| survey-def Keywords: BMI pediatric-cohort obesity-cohort | Resolution: Blocking: 252 | Blocked By: -+- Changes (by dconnolly): * owner: gkowalski = huhickman Comment: In the Apr 14 meeting (cf #12), Hubert and Alex took the ball. Alex last moved it in comment:6, so the ball is yours, Hubert. -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/210#comment:29 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
[gpc-informatics] #270: Port Q1 QA query to Oracle
#270: Port Q1 QA query to Oracle ---+--- Reporter: dconnolly | Owner: mikemunns Type: enhancement | Status: new Priority: major | Milestone: data-quality3 Component: data-sharing | Keywords: Blocked By:| Blocking: 232, 262 ---+--- per gpc-dev call 14 Apr (see #12 for notes) -- Ticket URL: http://informatics.gpcnetwork.org/trac/Project/ticket/270 gpc-informatics http://informatics.gpcnetwork.org/ Greater Plains Network - Informatics ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev