Re: geocoding and HMRFS data RE: gpc-dev 25 Oct agenda and meeting notes

2016-10-24 Thread Alex Bokov
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

RE: which sites have payer data?

2016-10-24 Thread Dan Connolly
I see Justin gave us some ETL details on clinic visits back in Aug 2014. https://informatics.gpcnetwork.org/trac/Project/ticket/139#comment:5 and as to motivation... I just re-discovered from the ticket description that a message from Dan Hale in July 2014 was the genesis of these tickets

RE: which sites have payer data?

2016-10-24 Thread Verhagen, Laurel A
Marshfield hasn’t had a use case to load insurance coverage into i2b2. Are there definitions to align insurance carriers with the categories listed by Alex? Dan alludes to this being part of visit details. That’s a cleaner approach than trying to establish eligibility windows, which is what we

RE: trouble parsing household income from geo data

2016-10-24 Thread Dan Connolly
Aha... I found this comment in my "fun with maps" work: # Puerto Rico has a "." for Median Age: Male (UEK002). # UMN folks say this signifies 'supressed' # though they're surprised it's there too. -- Dan From: Dan Connolly

geocoding and HMRFS data RE: gpc-dev 25 Oct agenda and meeting notes

2016-10-24 Thread Dan Connolly
MU is more or less done linking median income etc. (notes on their Apr demo are in #140), but somebody would have to choose exactly which of the hundreds of income variables from ACS to use, and likewise education, family

Re: gpc-dev 25 Oct agenda and meeting notes

2016-10-24 Thread Alex Bokov
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

trouble parsing household income from geo data

2016-10-24 Thread Dan Connolly
I'm trying to look at Median household income in 'acs_20135a/zcta_860/ge.00_file.dat.gz'. Variable B19013 has... data_type n start_column 16038 width

Jay -- UNMC -- BC Survey -- crosswalk question (naaccr_prep related), multiple "mrn" to the same StudyID

2016-10-24 Thread Pedersen, Jay G
Hi, This question is directed to Dan Connolly, but the result may be of interest to the GPC in general. I had a question about what we discussed last Friday. Recall that we used a different field in our NAACCR data to identify a patient. I think it was postion 50:57, and the value was NOT

gpc-dev 25 Oct agenda and meeting notes

2016-10-24 Thread Dan Connolly
What else for tomorrow? * gpc-dev 25 Oct shared notes; scribe: CMH current snapshot: 1. Convene, take roll, review records and plan next meeting * ​Meeting

Re: [gpc-informatics] #492: How to Build SAS CDM v3 Medication Tables

2016-10-24 Thread GPC Informatics
#492: How to Build SAS CDM v3 Medication Tables --+ Reporter: dconnolly | Owner: lv Type: design-issue | Status: assigned Priority: major | Milestone: cdm-refresh6 Component: data-stds | Resolution:

Re: [gpc-informatics] #155: correlating observations with encounters

2016-10-24 Thread GPC Informatics
#155: correlating observations with encounters --+--- Reporter: lv| Owner: dconnolly Type: design-issue | Status: assigned Priority: major | Milestone: cdm-refresh6