Hi again,
So the solution I settled on was to look at a different table which had
the current benefit plan listed (only one
per patient). The table I used was a Data warehouse table that we use
in house.
So the total for Part B added up to 99.9%. I only had four groups:
Commercial, Medicaid, Medicare, NULL.
--- Debbie
On 1/7/2015 1:07 PM, Nadkarni, Prakash wrote:
Maybe Debbie’s solution is OK – I don’t see any language in the
template to the effect that the numbers must add up to 100 percent,
and multiple insurance is a fact of life in the real world. A footnote
to the effect that the numbers are > 100 because of multiple insurance
per patient may resolve the issue.
*From:*Nathan Graham [mailto:[email protected]]
*Sent:* Wednesday, January 07, 2015 12:02 PM
*To:* 'Debbie Yoshihara'; [email protected]; Nadkarni,
Prakash; '[email protected]' ([email protected]);
'[email protected]'
([email protected]); Alex Bokov ([email protected]);
Fothergill, Rita, R <[email protected]> ([email protected]);
'Jason Lebsack ([email protected])' ([email protected]);
Mish Thomas F ([email protected]); [email protected];
Justin Dale ([email protected])
*Cc:* Steve Fennel
*Subject:* RE: Due Monday, January 12th: Population characterization
(parts A and B) for PCORNet LOI
Debbie,
That’s a good question – I somewhat arbitrarily picked one of the
groups per patient (Oracle min() function on the ID number associated
with the group). Maybe that’s not a good approach - I’m open to other
ideas.
--
Nathan
*From:*Debbie Yoshihara [mailto:[email protected]]
*Sent:* Wednesday, January 07, 2015 10:56 AM
*To:* Nathan Graham; [email protected]
<mailto:[email protected]>; '[email protected]'
([email protected] <mailto:[email protected]>);
'[email protected]' ([email protected] <mailto:[email protected]>);
'[email protected]' ([email protected]
<mailto:[email protected]>); Alex Bokov
([email protected] <mailto:[email protected]>); Fothergill, Rita, R
<[email protected] <mailto:[email protected]>>
([email protected] <mailto:[email protected]>); 'Jason Lebsack
([email protected] <mailto:[email protected]>)'
([email protected] <mailto:[email protected]>); Mish
Thomas F ([email protected] <mailto:[email protected]>);
[email protected]
<mailto:[email protected]>; Justin Dale ([email protected]
<mailto:[email protected]>)
*Cc:* Steve Fennel
*Subject:* Re: Due Monday, January 12th: Population characterization
(parts A and B) for PCORNet LOI
Hi,
When I do my query for Part B: Insurance Coverage Overview, there are
patients (25%) which are in multiple
groups: for example, Commercial and Medicare FFS. How are other
groups marking this? I will get > 100%
if I mark these individuals in both groups. The effective date is the
same, so I have no choice but to use both.
--- Debbie
On 1/7/2015 8:58 AM, Nathan Graham wrote:
All,
As we discussed in the GPC-dev call yesterday
<http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20150107/1a231dff/attachment-0001.pdf>,
we’re working on PCORnet Phase 2
<http://www.pcori.org/announcement/national-patient-centered-clinical-research-network-clinical-data-research-networks>
letter of intent (LOI). Much like the quarterly updates we’ve
provided to PCORI, the LOI document template
<http://www.pcori.org/sites/default/files/PCORI-PFA-CDRN-LOI-Template.doc>
has a couple of sections with tables devoted to population
characteristics:
·Part A: Population Overview
·Part B: Insurance Coverage Overview
Brittany sent out an e-mail to the site PIs on Friday (January 02,
2015) asking that each site fill in these sections (among others)
by Tuesday, January 6^th . However, as per GPC-dev meeting notes
for January 6, 2015
<http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20150107/1a231dff/attachment-0001.pdf>,
*Dr. Waitman has extended the requested deadline to Monday January
12^th * (for the tables in sections A and B at least).
*Please let us know right away who from each site will be the
primary contact for providing numbers for the tables in parts A
and B*. For the PCORI quarterly updates, I believe I got
population numbers from the following people:
·University of Iowa: *Prakash Nadkarni*
·Medical College of Wisconsin: *Brad Taylor*
·Marshfield Clinic: *Laurel Verhagen*
·San Antonio: *Alex Bokov*
·Children's Mercy Hospital: *Rita Fothergill*
·University of Nebraska: *Jason Lebsack*
·University of Wisconsin – Madison: *Tom Mish*
·University of Texas Southwestern: *Phillip Reeder*
·University of Minnesota: *Justin Dale*
There’s been some discussion regarding what “Number of active
patients with data in the EMR” means. After talking with Dr.
Waitman yesterday I plan to use the same method we used to
characterize enrollment for PCORI milestone 1.1
<https://informatics.gpcnetwork.org/trac/Project/ticket/97>:
//
/“The GPC will use a refined definition of enrollment based upon
the criteria we used in our proposal...2 visits in the 3 years
where the visits are separated by greater than 30 days”/
I also plan to use that number for “active patients” as the
denominator for part B.
Thanks for your help!
Regards,
Nathan
_______________________________________________
Gpc-dev mailing list
[email protected] <mailto:[email protected]>
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
--
Debbie Yoshihara Informatics Specialist
SMPH-IT, Biomedical Informatics Services
School of Medicine and Public Health, UW-Madison
[email protected] <mailto:[email protected]>
Tel:(608)263-5643 <Tel:%28608%29263-5643>
------------------------------------------------------------------------
Notice: This UI Health Care e-mail (including attachments) is covered
by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is
confidential and may be legally privileged. If you are not the
intended recipient, you are hereby notified that any retention,
dissemination, distribution, or copying of this communication is
strictly prohibited. Please reply to the sender that you have
received the message in error, then delete it. Thank you.
------------------------------------------------------------------------
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
