RE: [gpc-informatics] #510: Bariatric Query Wave 1 – Study Specific Data Characterization (SSDC)

Hi, Brian: I spoke with Prakash today. He had resolved the issue and resubmitted the SSDC query results. He has updated the ticket (#510). We also discussed this on today's dev call. I believe Dan was going to go ahead and close the ticket. Nick Nicholas C. Smith, MS Senior Database Archi

RE: Reminder: PCORnet Data Characterization for your campus is due TOMORROW

Hi, Russ: I zipped the results and uploaded them via the DataMart Client. How can I verify that I have done this correctly? [cid:image001.jpg@01D257BB.51462CA0] Nicholas C. Smith, MS Senior Database Architect Institute for Clinical & Translational Science (http://www.icts.uiowa.edu

RE: seine-databuilder update RE: cdr2edc Questions

Hi, Chris: I found the presentation here… https://docs.google.com/presentation/d/1FtTUcQbqAwVTecC3vttLqO-B5ZsyQuwHrQotlv8LAaI/edit#slide=id.p [cid:image001.jpg@01D27C64.6FB7B550] Nicholas C. Smith, MS Senior Database Architect Institute for Clinical & Translational Science (http://www.icts.ui

RE: CRG rapid cycle grants

Hello, Russ: At UIOWA we have recently loaded our most recent NAACCR data into our data warehouse. This data is for all cases submitted to the state of Iowa through December 2016. Our goal is to have this data loaded i2b2 around the same time as the CDM refresh. Like MCW, we loaded informati

Cancer CRG DROC Request presentation for GPC Dev call 06/13/2017

Good afternoon, everyone: For tomorrow's dev call I have put together a presentation regarding ticket #596 (DROC Request from Cancer CRG: Preliminary feasibility query for study of use of targeted cancer therapy). Here is the original DROC request, https://informatics.gpcnetwork.org/trac/Proje

RE: [External] RE: Cancer CRG DROC Request presentation for GPC Dev call 06/13/2017

below...that KUMC dates could be shifted by up to a year. Thanks for taking a quick look! I appreciate it. Nick From: Dan Connolly [mailto:dconno...@kumc.edu] Sent: Monday, June 12, 2017 1:29 PM To: Smith, Nicholas C; gpc-dev@listserv.kumc.edu Cc: Chrischilles, Elizabeth A Subject: [External] RE

Re: targeted cancer therapy study - how to fulfill feasibility data request?

DROC request on the KUMC redcap site. Thanks! Nick Smith UIOWA Sent from my Sprint Samsung Galaxy S8+. Original message From: "McDowell, Bradley D" Date: 6/23/17 10:16 AM (GMT-06:00) To: "Smith, Nicholas C" Subject: targeted cancer therapy study - how to

DROC Breast Cancer CRG Request (#596)

Hello, Everyone: I believe a couple of sites had stated on the dev call today that they were able to upload their Query3 results into Redcap. But as of about 30 minutes ago I had not seen any results uploaded to the Query3 project. I was able to upload UIOWA's results into the "Cancer CRG DROC

RE: [External] RE: DROC Breast Cancer CRG Request (#596)

om: Campbell, James R [mailto:campb...@unmc.edu] Sent: Wednesday, July 12, 2017 6:43 AM To: Smith, Nicholas C; gpc-dev@listserv.kumc.edu Subject: [External] RE: DROC Breast Cancer CRG Request (#596) Nicholas So I reformatted our data to include SSF15 and tried to reload the spreadsheet but I no longer hav

RE: [External] Re: [gpc-informatics] #596: targeted cancer therapy study - Query 1, 2, 3

.@kumc.edu; schand...@kumc.edu; McDowell, Bradley D; rwait...@kumc.edu; campb...@unmc.edu; jmcc...@unmc.edu; btay...@mcw.edu; mcneele...@health.missouri.edu; verhagen.lau...@mcrf.mfldclin.edu; tmcma...@kumc.edu; danh...@regenstrief.org; Smith, Nicholas C Cc: Chrischilles, Elizabeth A; phillip.re

RE: [External] GPC NEXT-D Table 1 request

Hello, Mei: I have downloaded the .sql file and run it. Are we just supposed to upload a .csv file on to GPC RedCap of the query results? The columns in the query results of the .sql file do not match the TableFormat.pdf on RedCap. Specifically the pdf has only one column per date (-MM-D

Re: [External] RE: U of Nebraska's r006 approved

UIOWA submitted on Monday. Nick Sent from my Sprint Samsung Galaxy S8+. Original message From: Russ Waitman Date: 10/18/17 07:39 (GMT-06:00) To: GPC-DEV@LISTSERV.KUMC.EDU, gpc...@listserv.kumc.edu Subject: [External] RE: U of Nebraska's r006 approved Hi Mark, Betsy, Umbe

NEXT-D Dropbox Access

Hello, everyone. This came up during the Next-D discussion this morning... For anyone that needs access to the NEXT-D Dropbox, contact Charon Gladfelter at Northwestern (charon.gladfel...@northwestern.edu). [cid:image002.jpg@01D3A4A6.5A701E60] Nicho

DROC #40: Predictive Models for Acute Kidney Injury using PCoRnet CDM

Hello, Mei: Gi-Yung Ryu on our team has experience with R and has some time to try this out here at UIOWA. We are a SQLServer site. Did you have anything available yet to send to the sites to attempt to run? Nick [cid:image001.jpg@01D3FCE4.B5E1E620] Nicholas C. Smith, MS Senior Database Arc

RE: [External] Re: MS-SQL hashing function?, re: Death index file

Hello, Jay: Did you ever get a function to work for MSSQL that can take in the parameters of 'SHA1', SSN+DOB/LNAME/etc, and a hash key and kick out a hashed value? I'm trying this now by taking SSNs in our data warehouse that I know exist in the SSDMF, concatenating that SSN with DOB, attemptin

MS SQLServer CLF Function for SSDMF

Hello, Everyone: Gi-Yung Ryu on our team developed a CLR function to run in MS SQLServer to create the SSDMF hash values. Attached are 2 files. 1. SSDMF_CLR_C#.txt - This is the C# code build dll file and create assembly SSDMF 2. SSDMF_CLR_SQL.txt - This is the SQL script to create the E