RE: Due Monday, January 12th: Population characterization (parts A and B) for PCORNet LOI

[Nathan Graham]

Phillip,

I've copied gpc-dev as I think our discussion may benefit others - I hope 
that's ok.

Right now, I'm looking at the clarity_epm table - this is what we (KUMC) used 
for the original 
proposal<http://frontiersresearch.org/frontiers/sites/default/files/frontiers/documents/GPC-PCORI-CDRN-Research-Plan-Template-KUMCv44.pdf>
 to estimate insurance coverage in table 1.1.  It looks like we might not have 
very comprehensive data but we didn't go live with Epic billing until recently 
which may explain the sparse coverage - I'm still investigating however.

...
with at_least_one_payor as (
  select pat_id, min(fin.title) title -- LOI asking for patient counts, so I 
thought I'd take only one if a patient has more...
  from clarity.pat_enc_2 enc
  join clarity.clarity_epm epm on epm.payor_id = enc.visit_payor_id
  join CLARITY.zc_fin_class fin on fin.fin_class_c = epm.financial_class
  group by pat_id
  ),
...

As a side note, a quick search of gpc-trac came up with a comment by Justin 
Dale<https://informatics.gpcnetwork.org/trac/Project/ticket/139#comment:5> 
indicating he used that table for some exploration into insurance status.

--
Nathan


From: Phillip Reeder [mailto:phillip.ree...@utsouthwestern.edu]
Sent: Wednesday, January 07, 2015 10:37 AM
To: Nathan Graham
Cc: Susan Morrison
Subject: Re: Due Monday, January 12th: Population characterization (parts A and 
B) for PCORNet LOI

Where are you getting the insurance coverage from?  Are you pulling it out of 
Clarity?  If so, which tables?  Just trying to make sure we are consistent.

Thanks,
Phillip

From: Nathan Graham <ngra...@kumc.edu<mailto:ngra...@kumc.edu>>
Date: Wednesday, January 7, 2015 at 8:58 AM
To: "GPC-DEV@LISTSERV.KUMC.EDU<mailto:GPC-DEV@LISTSERV.KUMC.EDU>" 
<GPC-DEV@LISTSERV.KUMC.EDU<mailto:GPC-DEV@LISTSERV.KUMC.EDU>>, 
"'prakash-nadka...@uiowa.edu<mailto:'prakash-nadka...@uiowa.edu>' 
(prakash-nadka...@uiowa.edu<mailto:prakash-nadka...@uiowa.edu>)" 
<prakash-nadka...@uiowa.edu<mailto:prakash-nadka...@uiowa.edu>>, 
"'btay...@mcw.edu<mailto:'btay...@mcw.edu>' 
(btay...@mcw.edu<mailto:btay...@mcw.edu>)" 
<btay...@mcw.edu<mailto:btay...@mcw.edu>>, 
"'verhagen.lau...@mcrf.mfldclin.edu<mailto:'verhagen.lau...@mcrf.mfldclin.edu>' 
(verhagen.lau...@mcrf.mfldclin.edu<mailto:verhagen.lau...@mcrf.mfldclin.edu>)" 
<verhagen.lau...@mcrf.mfldclin.edu<mailto:verhagen.lau...@mcrf.mfldclin.edu>>, 
"Alex Bokov (bo...@uthscsa.edu<mailto:bo...@uthscsa.edu>)" 
<bo...@uthscsa.edu<mailto:bo...@uthscsa.edu>>, "Fothergill, Rita, R 
<rfotherg...@cmh.edu<mailto:rfotherg...@cmh.edu>> 
(rfotherg...@cmh.edu<mailto:rfotherg...@cmh.edu>)" 
<rfotherg...@cmh.edu<mailto:rfotherg...@cmh.edu>>, "'Jason Lebsack 
(jlebs...@nebraskamed.com<mailto:jlebs...@nebraskamed.com>)' 
(jlebs...@nebraskamed.com<mailto:jlebs...@nebraskamed.com>)" 
<jlebs...@nebraskamed.com<mailto:jlebs...@nebraskamed.com>>, "Mish Thomas F 
(tm...@uwhealth.org<mailto:tm...@uwhealth.org>)" 
<tm...@uwhealth.org<mailto:tm...@uwhealth.org>>, Phillip Reeder 
<phillip.ree...@utsouthwestern.edu<mailto:phillip.ree...@utsouthwestern.edu>>, 
"Justin Dale (jd...@umn.edu<mailto:jd...@umn.edu>)" 
<jd...@umn.edu<mailto:jd...@umn.edu>>
Cc: Brittany Zschoche <bzscho...@kumc.edu<mailto:bzscho...@kumc.edu>>, Russ 
Waitman <rwait...@kumc.edu<mailto:rwait...@kumc.edu>>, Steve Fennel 
<sfen...@kumc.edu<mailto:sfen...@kumc.edu>>
Subject: Due Monday, January 12th: Population characterization (parts A and B) 
for PCORNet LOI

extended the requested deadline to Monday January 12th
________________________________

UT Southwestern


Medical Center



The future of medicine, today.



_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev