I would take Rachel Hess off the email list as she likely gets too much spam
Every inpatient admission has up to 10 official diagnoses tied to it. So, the starting point it getting those diagnoses loaded as a beginning point tied to the parent patient concept populated by the beneficiary summary Russ On Jun 26, 2015, at 10:26 AM, GPC Informatics <[email protected]<mailto:[email protected]>> wrote: #287: Search ResDAC synthetic claims data for ICD9 diagnoses in development i2b2 instance -------------------------+--------------------------- Reporter: rwaitman | Owner: rgleue Type: enhancement | Status: assigned Priority: major | Milestone: cohort-char1 Component: etl-dev | Resolution: Keywords: | Blocked By: Blocking: | -------------------------+--------------------------- Comment (by rgleue): I've been exploring different tables. Here's one Russ wanted me to do in the email. Not exactly sure what the ICD9_DGNS_CD_1 up to 10 really are though... {{{ SELECT ADMTNG_ICD9_DGNS_CD as Concept_CD, ICD9_DGNS_CD_1 as Concept_CD_1, ICD9_DGNS_CD_2 as Concept_CD_2, ICD9_DGNS_CD_3 as Concept_CD_3, ICD9_DGNS_CD_4 as Concept_CD_4, ICD9_DGNS_CD_5 as Concept_CD_5, ICD9_DGNS_CD_6 as Concept_CD_6, ICD9_DGNS_CD_7 as Concept_CD_7, ICD9_DGNS_CD_8 as Concept_CD_8, ICD9_DGNS_CD_9 as Concept_CD_9, ICD9_DGNS_CD_10 as Concept_CD_10 FROM inpatient }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/287#comment:4> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics Russ Waitman, PhD Director of Medical Informatics Assistant Vice Chancellor for Enterprise Analytics Associate Professor, Department of Internal Medicine University of Kansas Medical Center, Kansas City, Kansas 913-945-7087 (office) [email protected]<mailto:[email protected]> http://www.kumc.edu/ea-mi/ http://informatics.kumc.edu<http://informatics.kumc.edu/> http://informatics.gpcnetwork.org – a PCORNet collaborative
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
