#596: targeted cancer therapy study - Query 1, 2, 3
--------------------------+----------------------------
Reporter: dconnolly | Owner: schandaka
Type: task | Status: assigned
Priority: major | Milestone: gpc-phase2-h4
Component: data-sharing | Resolution:
Keywords: all-sites | Blocked By:
Blocking: |
--------------------------+----------------------------
Comment (by nsmith):
Hello, Todd:
The purpose of that filter in the query is to identify patients who only
have one primary tumor. That was me just being thorough. If you are
unable to utilize that filter on NAACCR 560, don't worry about it. Please
remove it and run the queries again. Since a high percentage of patients
in our registries have only had one tumor, removing this filter is not a
deal breaker. I just need to make a note of which sites had this
limitation and were unable to use NAACCR 560 in their queries. I know
KUMC also had a similar issue around this filter as well and had to remove
it.
Todd, please remove that filter and re-run queries 2 & 3. Please contact
me directly via phone or email if you any further issues or questions.
Thanks!
Nick
Nicholas C. Smith, MS
Senior Database Architect
Institute for Clinical & Translational Science (http://www.icts.uiowa.edu)
Email: nicholas-c-sm...@uiowa.edu
Phone: 319-467-8173
Replying to [comment:25 tmcneeley]:
> We are unable to complete Query 2 and 3 at MU because it does a join on
NAACCR|560%. We do not have any people coded with 560 so the inner join
returns 0 results.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/596#comment:34>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
