A comment on fasting versus random glucose test. In Northwestern EDW, 99.999% of glucose tests are recorded as random, whether or not the patient supposedly fasted overnight before the test.
Bernie ************************************************************* Bernard S. Black Chabraja Professor, Northwestern University Pritzker Law School and Kellogg School of Management 375 East Chicago Ave., Chicago IL 60611 bbl...@northwestern.edu<mailto:bbl...@northwestern.edu> tel: law: 312-503-2784<tel:312-503-2784>; Kellogg 847-491-5049<tel:847-491-5049>; cell: 847-807-9599<tel:847-807-9599> papers on SSRN at: http://ssrn.com/author=16042 ************************************************************ From: Dan Connelly Sent: Friday, April 07, 2017 11:42 AM To: Al'ona Furmanchuk <furmanc...@icnanotox.org>; <gpc-dev@listserv.kumc.edu> <gpc-dev@listserv.kumc.edu> Cc: gkowal...@mcw.edu; Mei Liu <mei...@kumc.edu>; Taylor, Bradley <btay...@mcw.edu>; Bernard Black <bbl...@kellogg.northwestern.edu>; Kho, Abel <a...@nm.org>; Osinski, Kristen <kosin...@mcw.edu> Subject: RE: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c I assume nearly everything is subject to change (hence careful use of version control). But meanwhile, I can make progress based on what I've got, so that's what I 'm doing. -- Dan ________________________________ From: Al'ona Furmanchuk [furmanc...@icnanotox.org] Sent: Friday, April 07, 2017 11:37 AM To: <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>> Cc: gkowal...@mcw.edu<mailto:gkowal...@mcw.edu>; Dan Connolly; Mei Liu; Taylor, Bradley; Bernard Black; Kho, Abel; Osinski, Kristen Subject: Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c Please, disregard Apr. 4th document on labs for now. It turned to have errors due to wrong application of sorting command. Earlier next week we will provide corrected version. Apologies. On Fri, Apr 7, 2017 at 11:14 AM, GPC Informatics <d...@madmode.com<mailto:d...@madmode.com>> wrote: #551: next-D labs for cohort selection: fasting glucose, HbA1c --------------------------+------------------------ Reporter: afurmanchuck | Owner: gkowalski Type: design-issue | Status: assigned Priority: major | Milestone: next-d Component: data-stds | Resolution: Keywords: | Blocked By: Blocking: 545 | --------------------------+------------------------ Comment (by dconnolly): George, I'm not surprised you get no results for fasting; I don't think I get any either. But babel shows 6777-7 is much used at MCW; that's in the list of codes for random glucose, yes? Do you not get any results there either? Meanwhile, note the work on `lab_review.csv`.... I haven't integrated it into the query yet; i.e. replaced the hard-coded list of LOINC codes with a join on a table built from `lab_review.csv`. Meanwhile, Dr. Kho is refining the lab spreadsheet. 5792-7 seems to be the most recorded glucose lab at MCW (based on c_totalnum from Babel). That row in Dr. Kho's Apr 4 spreadsheet says "No". I'm not sure why; he plans to include rationale in his next revision. 5792-7 is also not in the SQL code. For 6777-7, which is also much recorded, I see "allowable for now" and it is in the SQL code. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/551#comment:17<https://urldefense.proofpoint.com/v2/url?u=http-3A__informatics.gpcnetwork.org_trac_Project_ticket_551-23comment-3A17&d=DwMF-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=EU6EJqbkLbTzD2PQ0lCK4E1MmxWravJtnw_k_JJzEa0&s=KJVE23NNSERL3Kfq9ZP-41iQ6ULcrqgRCs-q2X5mqmo&e=>> gpc-informatics <http://informatics.gpcnetwork.org/<https://urldefense.proofpoint.com/v2/url?u=http-3A__informatics.gpcnetwork.org_&d=DwMF-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=EU6EJqbkLbTzD2PQ0lCK4E1MmxWravJtnw_k_JJzEa0&s=L8HAYooR0HDpgjiiPtyQFiOKbD_VusmtWj_jN-kqGpA&e=>> Greater Plains Network - Informatics -- Al'ona Furmanchuk, Ph.D. Research Associate Center for Health Information Partnerships, Northwestern University, Feinberg School of Medicine 633 N. Saint Clair Street, 20th floor, Chicago, IL 60611 Web: http://furmanchuk.com/<https://urldefense.proofpoint.com/v2/url?u=http-3A__furmanchuk.com_&d=DwMF-g&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=EU6EJqbkLbTzD2PQ0lCK4E1MmxWravJtnw_k_JJzEa0&s=l0XTGijmBM80NkzgEsDKW5ajk37H5QgRXKgXdQo44XU&e=> E-mail: alona.furmanc...@northwestern.edu<mailto:furmanc...@icnanotox.org> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev