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 [email protected]<mailto:[email protected]> 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 <[email protected]>; <[email protected]> <[email protected]> Cc: [email protected]; Mei Liu <[email protected]>; Taylor, Bradley <[email protected]>; Bernard Black <[email protected]>; Kho, Abel <[email protected]>; Osinski, Kristen <[email protected]> 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 [[email protected]] Sent: Friday, April 07, 2017 11:37 AM To: <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]>; 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 <[email protected]<mailto:[email protected]>> 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: [email protected]<mailto:[email protected]> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
