Thanks Sravani - I'll keep all of them then.
--- Debbie
________________________________
From: Sravani Chandaka <schand...@kumc.edu>
Sent: Friday, January 6, 2017 10:17:41 AM
To: Debbie Yoshihara; 'gpc-dev'
Subject: RE: Finders.sql English explanation please
Hi Debbie,
Usually HIC numbers follow a specific syntax 9-digit SSN followed by an alpha
suffix ("A" beneficiary (retired worker or disabled worker), "B" spouse (spouse
is over 65), "C" children (child or grandchild of a retiree), "D" divorced
spouse, widow, widower, "E" widowed mother). However, I found duplicate numbers
for patients as well and in most of the cases one of those HIC number did not
follow the typical HIC number syntax. I brought this GDIT's attention. They
told me to retain both the numbers in the finder file. Let me know if you have
any further questions regarding this.
Thanks
Sravani
From: Debbie Yoshihara [mailto:dlyos...@wisc.edu]
Sent: Friday, January 06, 2017 7:53 AM
To: Sravani Chandaka <schand...@kumc.edu>; 'gpc-dev' <gpc-dev@listserv.kumc.edu>
Subject: Re: Finders.sql English explanation please
I found out though that some patients have multiple HIC numbers.
Did anyone else have that happen?
If so, what did you do?
--- Debbie
________________________________
From: Sravani Chandaka <schand...@kumc.edu<mailto:schand...@kumc.edu>>
Sent: Thursday, January 5, 2017 3:32:13 PM
To: Debbie Yoshihara; 'gpc-dev'
Subject: RE: Finders.sql English explanation please
Hi Debbie,
The description you gave below is correct. We need HIC numbers for the
ACCT_FIN_CLASS_C 2 or 3. Patients must have at least one observation fact with
weight, with cancer case, with diagnosis. You are right on the columns in the
data set as well. The data set that you send to GDIT includes
SSN,GENDER,DOB,HIC and PATIENT_NUM(hashed).
Thanks
Sravani
________________________________
From: Gpc-dev [gpc-dev-boun...@listserv.kumc.edu] on behalf of Debbie Yoshihara
[dlyos...@wisc.edu]
Sent: Thursday, January 05, 2017 7:04 AM
To: gpc-dev
Subject: Finders.sql English explanation please
Hi,
Since I cannot access both Clarity and I2B2 on the same machine,
I'll have to do this query in two parts.
Could someone give me an English description of what this sql is doing?
What I'm looking for is something like:
Inclusion:
The set of patients must have at least one observation fact with weight, with
cancer case, with diagnosis. (I2B2)
The set of patients must have ACCT_FIN_CLASS_C 2 or 3 (Clarity)
Data set:
Patient number
Social security number
Gender: M, F, 0
Date of birth MM/DD/YYYY
HIC member number
Is this it, or did I miss something?
Thanks,
Debbie Yoshihara
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
