Yes, the motivation for this and for the payer information is to obtain
proxy variables for socioeconomic status. The original FWHS asked
nothing about SES, and that's important, probably to researchers in most
specialties.
Larry and Anne will probably have better ideas on which census variables
are best indicators of socioeconomic status. All I can think of are
median family income, % below poverty line, median education level
attained, and median number of persons living in household.
Alex F. Bokov, Ph.D. Clinical Informatics Research Division UT Health
Science Center at San Antonio
On 10/24/2016 04:22 PM, Dan Connolly wrote:
MU is more or less done linking median income etc. (notes on their Apr
demo are in #140
<https://informatics.gpcnetwork.org/trac/Project/ticket/140#comment:47>),
but somebody would have to choose exactly which of the hundreds of
income variables from ACS to use, and likewise education, family size,
etc. And we would need a data extraction tool or process; databuilder
assumes the data comes from observation_fact, but that's not the case
in the architecture MU developed.
I'm struggling thru it at KUMC for Next-D. I was supposed to work with
Mei on it this month, but her maternity leave came early, so now the
schedule is somewhat up in the air.
I don't see progress from any other sites. How about UTHSCSA? How
close are you?
Also, is there some particular motivation for this request that you
can share with us?
--
Dan
------------------------------------------------------------------------
*From:* [email protected]
[[email protected]] on behalf of Alex Bokov
[[email protected]]
*Sent:* Monday, October 24, 2016 3:46 PM
*To:* [email protected]
*Cc:* 'Hanrahan Larry P'; Ann Davis
*Subject:* Re: gpc-dev 25 Oct agenda and meeting notes
If it's not too late, I would like to add these questions that came
from the Obesity paper-writing group (v2.0):
1. To do a verbal poll of each site during the call to see if who has
payer data in their i2b2
(Medicare/Medicaid/BCBS/Self-Pay/Commercial/Government/Contract/Other),
and how feasible it would be for each site which does not, to get
it into their i2b2.
2. To find out how close we are to linking median income, education
attained, family size, and poverty rate from the census data to
patients based on their geocodes.
3. How long each site thinks it would take them to pull these data
elements corresponding to the patients for which they originally
submitted databuilder files.
Can that fit on tomorrow's agenda? Thanks.
-- Alex
Alex F. Bokov, Ph.D. Clinical Informatics Research Division UT Health
Science Center at San Antonio
On 10/24/2016 10:54 AM, Dan Connolly wrote:
What else for tomorrow?
* gpc-dev 25 Oct shared notes
<https://docs.google.com/document/d/1l1VOvUAYUwa4J4-f2yzCyUpiZ1UonOP-7G2-1sh38QQ/edit>;
scribe: CMH
current snapshot:
------------------------------------------------------------------------
1.
Convene, take roll, review records and plan next meeting
1.
Meeting ID and access code: 817-393-381
<https://global.gotomeeting.com/meeting/join/817393381>; call
+1 (571) 317-3131
2.
roll: all 12DevTeams
<https://informatics.gpcnetwork.org/trac/Project/wiki/DevTeams>represented?
KUMC, CMH, UIOWA, WISC, MCW, MCRF, UMN, UNMC, UTHSCSA, UTSW,
MU, IU
Reminder - put institution after your name in GoToMeeting
preferences
1.
today's scribe: CMH
3.
comments on the agenda? On last week’s notes? No. (#12
<https://informatics.gpcnetwork.org/trac/Project/ticket/12>)
Recent tickets opened/closed
<https://informatics.gpcnetwork.org/trac/Project/timeline>-
FYI (i.e. not intended for discussion)
1.
No FYIs this week
4.
Next Meeting: 1 Nov; scribe: UTSW? (did they win a
get-out-of-scribing prize?)
Note LRU schedule
<https://informatics.gpcnetwork.org/trac/Project/ticket/12#comment:92>,
which nominates UTSW …
2.
Milestone:next-d
<https://informatics.gpcnetwork.org/trac/Project/milestone/next-d>FYI:
Next project meeting is Nov 4; a project timeline is in preparation
3.
Milestone:bariatric-study-data
<https://informatics.gpcnetwork.org/trac/Project/milestone/bariatric-study-data>,
Milestone:antibiotic-study-data
<https://informatics.gpcnetwork.org/trac/Project/milestone/antibiotic-study-data>
1.
#524
<https://informatics.gpcnetwork.org/trac/Project/ticket/524>Analytic
Aim 1 individual-level query
<https://informatics.gpcnetwork.org/trac/Project/ticket/524>Due
date was 12 Oct; extended somewhat (see note from Jim M. in #524)
relevant sites: UTSW, WISC (done), UIOWA, KUMC (done),
Marshfield (done)
1.
UTSWReceived the query on 10/6. Due 10/20. Planning to
run this week.Have run query; almost done submitting.
2.
UIOWA - Nick to follow up with Prakash for status
4.
Milestone:cohort-char-bc-db
<https://informatics.gpcnetwork.org/trac/Project/milestone/cohort-char-bc-db>-
due 31 Oct
#297
<https://informatics.gpcnetwork.org/trac/Project/ticket/297>:
Site status, issues
1.
UMN: done. gold star.
2.
KUMC: done with tumor, med data;
owe update on diagnoses, procedures due to#493
<https://informatics.gpcnetwork.org/trac/Project/ticket/493>
1.
Reminder from #448:
REDCap survey: diagnoses and procedures for consented
Breast Cancer Study patients
<https://redcap.gpcnetwork.org/surveys/?s=EEF8DKCA4T>
3.
UNMC: addressing#466
<https://informatics.gpcnetwork.org/trac/Project/ticket/466>,#480
<https://informatics.gpcnetwork.org/trac/Project/ticket/480>,#358
<https://informatics.gpcnetwork.org/trac/Project/ticket/358>(or#534
<https://informatics.gpcnetwork.org/trac/Project/ticket/534>)
1.
Jay out the week of 24-28 Oct
4.
WISC: addressing#537
<https://informatics.gpcnetwork.org/trac/Project/ticket/537>;
blocked by #536
Thanks, Keith, for contributing mssql-2008 support for
minibuilder
<https://bitbucket.org/gpcnetwork/heron_extract/commits/80853a8097b7443a71f210e0b8f33bd74215a892>.
Note some minibuilder docs
<https://informatics.gpcnetwork.org/trac/Project/wiki/BuilderSaga#minibuilder>,
revised builder schema to correct case of column names
<http://listserv.kumc.edu/pipermail/gpc-dev/2016q4/003278.html>.
5.
UTSW: 25 Oct
6.
MCRF: 25 Oct see#471
<https://informatics.gpcnetwork.org/trac/Project/ticket/471>
7.
MCW: Wed 26 Oct
8.
UIOWA: earlier Thu 13 Oct ETA has passed
5.
Milestone:cdm-refresh6
<https://informatics.gpcnetwork.org/trac/Project/milestone/cdm-refresh6>
1.
#155
<https://informatics.gpcnetwork.org/trac/Project/ticket/155>correlating
observations with encounters
<https://informatics.gpcnetwork.org/trac/Project/ticket/155>“At
KUMC, we're testing a fix (9f41d31)
<https://github.com/kumc-bmi/heron/pull/21>for a problem
correlating flowsheet observations with encounters.”
2.
#499
<https://informatics.gpcnetwork.org/trac/Project/ticket/499>integrate
i2p-transform with HERON ETL meds (dispensing)
<https://informatics.gpcnetwork.org/trac/Project/ticket/499>surescripts_3914
branch
<https://github.com/kumc-bmi/heron/tree/surescripts_3914>4d768b7
is HERON ETL work-in-progress to get the data from clarity to
i2b2. Due 3 Nov.
3.
#492
<https://informatics.gpcnetwork.org/trac/Project/ticket/492>How
to Build SAS CDM v3 Medication Tables
<https://informatics.gpcnetwork.org/trac/Project/ticket/492>
1.
Recall UNMC's June 2015 work on Epic ETL for
dispensingticket:199#comment:16
<https://informatics.gpcnetwork.org/trac/Project/ticket/199#comment:16>
2.
Any code to share from UTSW?
3.
Any progress at MCRF?
4.
#359
<https://informatics.gpcnetwork.org/trac/Project/ticket/359>Data
Profile over time: How fresh is it? how far back does the
data go?
<https://informatics.gpcnetwork.org/trac/Project/ticket/359>“Maren
to contact gpc sites and compile a wiki page.”
6.
#459
<https://informatics.gpcnetwork.org/trac/Project/ticket/459>How
to add GPC sites to SNOW SHRINE network?
<https://informatics.gpcnetwork.org/trac/Project/ticket/459>Keith
will get an ETA for the SNOW hub upgrade out to the GPC_DEV group.
------------------------------------------------------------------------
--
Dan
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
