I suppose this question is to Jennifer Cai at UTSW; she doesn't seem to be copied. Mei, would you please add her to this thread?
Or perhaps you can answer, Phillip? -- Dan ________________________________ From: Al'ona Furmanchuk [furmanc...@icnanotox.org] Sent: Thursday, May 18, 2017 11:30 AM To: <gpc-dev@listserv.kumc.edu> Cc: Nathan Graham; Laurel Verhagen; Dan Connolly; Sravani Chandaka; McNeeley, Todd Alexander; Mei Liu; Campbell, James R; Satyender Goel; Bernard Black; Charon Gladfelter Subject: Re: [gpc-informatics] #444: Pregnancy Status for NEXT-D Did I get it right that you guys have EPISODE table in your system that keeping track of different conditions including pregnancy (SUM_BLK_TYPE_ID = 2). The data into this table is collected as result of processing notes and other text type records. You do not use CPT, ICD and other codes in your algorithm defining pregnancy episodes. Right? Do you upload this information to CONDITION table in your PCORNET CDM? If yes, we could add extra line to the code to pick this information when checking for pregnancy exclusion condition. On Thu, May 18, 2017 at 11:14 AM, GPC Informatics <d...@madmode.com<mailto:d...@madmode.com>> wrote: #444: Pregnancy Status for NEXT-D --------------------------+--------------------------- Reporter: afurmanchuck | Owner: afurmanchuck Type: design-issue | Status: assigned Priority: major | Milestone: next-d Component: data-stds | Resolution: Keywords: | Blocked By: Blocking: 546 | --------------------------+--------------------------- Comment (by meiliu): Following is UTSW's approach to retrieve pregnancy data provided by Jennifer Cai on 5/18: ---- Following are two tables to retrieve pregnancy data: EPISODE EPISODE_LINK Here is one script we used to retrieve the data SELECT P.*, PAT_LINK_ID, EDD_INITIAL_DT, OB_WRK_EDD_DT, L.PAT_ENC_CSN_ID, E.COMMENTS,E.STICKY_NOTE_TEXT,E.PROVIDERS_COMMENT FROM EPISODE E LEFT JOIN EPISODE_LINK L ON L.EPISODE_ID = E.EPISODE_ID AND L.LINE = 1 , LAUREN_SINGER_PAT_LIST P -- this is our local temporary patient cohort table WHERE E.STATUS_C = 1 AND P.PAT_ID = E.PAT_LINK_ID AND E.SUM_BLK_TYPE_ID = 2 AND ((OB_WRK_EDD_DT > SYSDATE OR OB_WRK_EDD_DT IS NULL) AND ( EDD_INITIAL_DT > SYSDATE OR EDD_INITIAL_DT IS NULL)) -- order by concept_id --Note: Based on the data in table EPISODE where status = 1 (active) and SUM_BLK_TYPE_ID = 2 (pregnancy) and EDD > sysdate -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/444#comment:19> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics -- Al’ona Furmanchuk, Ph.D. Research Associate Center for Health Information Partnerships, Northwestern University, Feinberg School of Medicine 633 N. Saint Clair Street, 20th floor, Chicago, IL 60611 Web: http://furmanchuk.com/ E-mail: alona.furmanc...@northwestern.edu<mailto:furmanc...@icnanotox.org> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev