Thanks Sravani! ________________________________ From: Sravani Chandaka <[email protected]> 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 [[email protected]] on behalf of Debbie Yoshihara [[email protected]] 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 [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
