All,
For the KU response, I modified "number of patients seen" based on Maryan's
comments. I queried the CDM "encounter" table and used the definition of
"active" patient we used Characterize enrollment for PCORI Milestone
1.1<https://informatics.gpcnetwork.org/trac/Project/ticket/97>.
> 2 visits in the 3 years where the visits are separated by greater than 30
> days.
Then, I picked distinct patients we saw in the past year who were also
considered "active". This dropped the number of patients "seen" in the past
year by about 20% from when I just counted every encounter in the past year.
For reference:
with snapshot_date as (
/* From CDM ETL config Jenkins job - when we ETL'd data from Epic*/
select to_date('2015-05-12', 'YYYY-MM-DD') dt from dual
),
pats_delta as (
-- If only one visit, visit_delta_days will be 0
select enc.patid, max(enc.admit_date) - min(enc.admit_date) visit_delta_days
from snapshot_date, pcornet_cdm.cdm_encounter enc
where enc.admit_date > add_months(snapshot_date.dt, -36)
group by enc.patid
),
enrolled as (
select *
from pats_delta
where visit_delta_days > 30
)
select count(distinct enc.patid)
from snapshot_date, enrolled enrld
join pcornet_cdm.cdm_encounter enc on enc.patid = enrld.patid
where enc.admit_date between add_months(snapshot_date.dt, -12) and
snapshot_date.dt
;
From: [email protected]
[mailto:[email protected]] On Behalf Of Brittany Zschoche
Sent: Wednesday, July 08, 2015 2:40 PM
To: '[email protected]'
Cc: 'Laura Fitzmaurice ([email protected])'; '[email protected]';
'[email protected]'; 'Parker, Jerry C.'; '[email protected]'; Steve
Fennel; 'Umberto Tachinardi'
Subject: RE: Action Needed - PCORI Phase 2 Survey
All:
Thank you for your timely responses to the survey. Today I received
clarification from Maryan Zirkle; please see below.
Hi Russ/Brittany,
Please see my responses to your questions below:
Question: Do you have specific criteria to define "seen"? Does this include
anything that generates clinical data?
Answer: This should include active patients at each site. Please provide a
definition of what you consider an active patient (i.e. 2 clinical-data
generating encounters within X years) when giving your response.
Question: Could you please provide examples of these populations?
Answer:
https://help.pcori.org/hc/en-us/articles/202629114-What-priority-populations-does-PCORI-want-to-address-with-its-research-
Please see this link on the PCORI website for information on PCORI's
populations of interest.
Question: Could you please provide context and definition of high quality data?
Answer: Data that has been queried for traditional data quality (DQ) checks
within the site (health system, academic center, community hospital, etc.)
Given this definition, we hope you also consult with the Coordinating Center to
get their understanding of this measure.
Best,
Maryan
We will follow up individually with questions, if needed.
Thanks,
Brittany
From: Brittany Zschoche
Sent: Monday, July 06, 2015 10:36 AM
To: [email protected]<mailto:[email protected]>
Cc: Laura Fitzmaurice ([email protected]<mailto:[email protected]>);
[email protected]<mailto:[email protected]>; Umberto Tachinardi;
'[email protected]'; 'Parker, Jerry C.'; '[email protected]'
Subject: Action Needed - PCORI Phase 2 Survey
Hi, everyone.
Late last week, PCORI sent an information request to Dr. Waitman. The
additional information will assist PCORI in evaluating GPC's Phase 2
application. This evaluation will occur at the Executive Committee meeting
later this month, therefore we do not have any flexibility with our due date,
and it relates directly to Phase 2 funding.
We request that answers are submitted by COB Friday, July 10th, and absolutely
no later than Sunday, July 12th. To expedite the gathering of information, we
have created a REDCap
survey<https://redcap.gpcnetwork.org/surveys/?s=WF7TLPAXW7>.
Please make note of the following:
- Re: geographical overlap - answer with patient duplication in mind
- Re: number of patients transformed into CDM - answer using the same
process used for previous interim reports
- Query and linkage support is budgeted into the Phase 2 GPC budget at
a central level
- I emailed PCORI this morning to seek further clarification on the
following:
o Re: Patients seen at this site.
* Do you have specific criteria to define "seen"?
* Does this include anything that generates clinical data?
o Re: Population of high interest.
* Could you please provide examples of these populations?
o Re: High quality of data.
* Could you please provide context and definition?
o I will forward responses as soon as I have them
Please let me know if you have any questions.
Brittany Zschoche, MBA
Project Manager, Enterprise Analytics & Medical Informatics
University of Kansas Medical Center
[email protected]<mailto:[email protected]>
913-588-4874
Request Help Here<https://redcap.kumc.edu/surveys/?s=qYxMmb>
www.kumc.edu/ea-mi<http://www.kumc.edu/ea-mi>
www.gpcnetwork.org
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
