#439: Demographics breakdown for population for PCORI Reporting
--------------------------+------------------------------
Reporter: mish | Owner: gkowalski
Type: problem | Status: assigned
Priority: major | Milestone: data-quality-q3
Component: data-sharing | Resolution:
Keywords: | Blocked By:
Blocking: 327 |
--------------------------+------------------------------
Changes (by dconnolly):
* component: data-stds => data-sharing
Old description:
> See attached spreadsheet from PCORI. They are requesting we fill out some
> basic demographic for our entire populations as well as by cohort.
>
> Split ticket; see #441 for cohort population reporting.
>
> ----
>
> Brittany,
>
> First Page (overall demographics):
> The grouping on the ages is different from (a) what we’ve gathered in the
> past, and (b) our default groupings within the GPC standard ontology (See
> Babel). However, it’s a relatively simple change to make. Debbie is in
> the quality code anyway making her final touches, I was about to create
> the new REDCap definitions for the new fields, so we can adopt this
> change relatively quickly. (Debbie tells me it’ll take a day to add this.
> It’ll add maybe 15minute of my type to create these new categories within
> our REDCap database.) Debbie has already started work on adding this code
> into the quality query
>
> I’ll create a ticket for it in a moment and add it to the list of things
> to accomplish.
>
> -TM
New description:
In preparation for presentation at a Dec 16 PCORI meeting, Marianne Z. has
requested we fill out attachment:Table1_Basic_11202015v5_GPC.xlsx . It
has two sheets:
- **Population Characterization**
- which seems to correlate somewhat with our quarterly QA queries
- **Cohort Characterization**
- which see #441
--
Comment:
As discussed 8 Dec (#12):
- **This request is an effort to get minimal information ASAP** per MZ
Dec 2. So when in doubt, make your best guess. Bonus points for explaining
any differences between what you did and what MZ asked for.
- Regardless of how you come up with your answers for your population as
a whole, put them in the
[https://redcap.gpcnetwork.org/redcap_v6.2.2/DataEntry/grid.php?pid=19 GPC
Quarterly QA Check Repository] redcap project.
- ''note: in contrast, we're using email to DC/BZ for the cohort stuff
#441''
- One approach is to use the [https://bitbucket.org/DanC/gpc-qa-
quarterly/ gpc-qa-quarterly] SQL code; rev b8a6546 includes recent work in
this area.
- This approach isn't constrained to the dates and such that MZ asked
for, but we hope it's still useful.
- Another approach is to use an i2b2 query such as "Demo breakdown for
MZ 14 Dec [12-8-2015]" on babel, which attempts to match more closely the
time-spans she requested.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/439#comment:5>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
