Re: Geocoding data matchup ?

Just realized I didn’t have the state in my match and was getting dups . there is 2 matches for the same address , city and zip but in different states : [cid:image001.png@01D30AD6.53D4F220] can’t believe they would match a northern Milwaukee ZIP code to Illinois From: Tim Meyer Date: Tuesd

Re: Geocoding data matchup ?

George, This is the logic we use (Oracle) and it matches up the records pretty well: LEFT JOIN LZ.GEOCODED_ADDRESS ON NVL(GEOCODED_ADDRESS.ARC_ADDRESS,'null') = NVL(TRIM(UPPER(PATIENT.ADD_LINE_1)),'null') AND NVL(GEOCODED_ADDRESS.ARC_CITY,'null') = NVL(TRIM(UPPER(PATIENT.CITY)),'null') AND

Geocoding data matchup ?

All, Anyone started matching the geocoded data to their patient addresses? It does not seem as easy as matching the address, zip and city across the two tables. G George Kowalski BS Biomedical Engineer Biomedical Informatics (414) 805-7318 (office) gkowal...@mcw.edu _

Re: [gpc-informatics] #579: Data Characterization - Cycle 3 Tracking

#579: Data Characterization - Cycle 3 Tracking --+- Reporter: lv| Owner: manuells Type: task | Status: assigned Priority: major | Milestone: cdm-cycle3 Component: data-stds

RE: UT HSC San Antonio's r007 approved

Great news San Antonio! Russ From: PCORnet DRN OC [mailto:dr...@pcornet.org] Sent: Tuesday, August 01, 2017 12:10 PM To: manuells; Laurel Verhagen; greenlee.robert; Russ Waitman Cc: James Topping; Laura Qualls; Darcy Louzao, Ph.D.; Allison Haufler Subject: UT HSC San Antonio's r007 approved Goo

Re: Gpc-dev Digest, Vol 42, Issue 2

5f1d9f297bbfab75eab...@exmail3.kumc.edu> > Content-Type: text/plain; charset="iso-8859-1" > > I haven't managed to get an agenda together. Is there anything sufficiently > important to discuss today that I shouldn't cancel

RE: Gpc-dev Digest, Vol 42, Issue 2

scrubbed... URL: <http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20170801/eec255b3/attachment-0001.html> -- Message: 2 Date: Tue, 1 Aug 2017 16:09:14 + From: "GPC Informatics" To: verhagen.lau...@mcrf.mfldclin.edu, mprit...@kumc.edu, dconn

Re: [gpc-informatics] #579: Data Characterization - Cycle 3 Tracking

#579: Data Characterization - Cycle 3 Tracking --+- Reporter: lv| Owner: manuells Type: task | Status: assigned Priority: major | Milestone: cdm-cycle3 Component: data-stds

RE: gpc-dev 1 Aug: cancel in 3... 2... 1...

Had a brief chat with Todd, Brian and Jim. Looks like we're in better shape on the CDM refresh this cycle. See my notes o http://informatics.gpcnetwork.org/trac/Project/ticket/579#comment:15 Mizzou went in late last night. UTSW had that small bug of 3.0 instead of 3.1 mentioned in the harve

Re: [gpc-informatics] #579: Data Characterization - Cycle 3 Tracking

#579: Data Characterization - Cycle 3 Tracking --+- Reporter: lv| Owner: mprittie Type: task | Status: assigned Priority: major | Milestone: cdm-cycle3 Component: data-stds

gpc-dev 1 Aug: cancel in 3... 2... 1...

I haven't managed to get an agenda together. Is there anything sufficiently important to discuss today that I shouldn't cancel? -- Dan ___ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev

RE: Indiana Regenstrief's r006 approved

Great news from Indiana! Next time I visit my dad we will have a celebratory pork chop at the New Boston Tavern in honor of properly characterized BMIs. http://santaclausind.org/listings/new-boston-tavern/ Russ Waitman, PhD Director of Medical Informatics Associate Vice Chancellor for Enterpris

RE: University of Iowa's r009 approved

Great news Nick! Russ From: PCORnet DRN OC [mailto:dr...@pcornet.org] Sent: Tuesday, August 01, 2017 7:31 AM To: Smith, Nicholas C; michael-wrigh...@uiowa.edu; Laurel Verhagen; greenlee.robert; Russ Waitman Cc: James Topping; Laura Qualls; Darcy Louzao, Ph.D.; Allison Haufler Subject: Universit