Would MOM_ID / DAD_ID maybe be better in PATIENT_DIMENSION as a 1-time fact like BIRTH_DATE/VITAL_STATUS? This shouldn’t overload that table with extra data and would facilitate making queries (not pretty ones) joining together Mom/Child facts from OBSERVATION_FACT.
BTW, I checked our instance and was surprised to find that the MOM_ID field was filled in over 10k times, but the DAD_ID was almost non-existent. - Glenn Medical Informatics Senior Analyst CTSI – Clinical & Translational Science Institute [email protected]<mailto:[email protected]> (414) 805-7239 From: <Campbell>, James R <[email protected]<mailto:[email protected]>> Date: Monday, May 11, 2015 at 7:14 PM To: Phillip Reeder <[email protected]<mailto:[email protected]>> Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: [gpc-informatics] #103: subject of observation (e.g. maternal findings relevant to child) Agreed; that was the point of the LOINC codes for observation_values for "Mother_of", "Father_of" and "Family_member_of" Jim James R. Campbell MD [email protected]<mailto:[email protected]> Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 On May 7, 2015, at 11:13 AM, "Phillip Reeder" <[email protected]<mailto:[email protected]>> wrote: The best way I can think of would be to add a concept that links to a parent or child patient_num. For example, if a child had an observation of: CHILD_OF VALUE=1111 where 1111 is the patient_num of the mother. Or we could do the opposite with the mother¹s observation being: HAS_CHILD VALUE=2222 where 2222 is the patient_num of the child. This would give you the ability, on the back end at least, to find siblings and parents. Alternate plan would be to just add a separate table with the data needed and keep it outside of i2b2, since i2b2 can¹t really handle the parent child relationships. Phillip On 5/7/15, 9:18 AM, "GPC Informatics" <[email protected]<mailto:[email protected]>> wrote: #103: subject of observation (e.g. maternal findings relevant to child) --------------------------+----------------------------------- Reporter: campbell | Owner: preeder Type: design-issue | Status: assigned Priority: major | Milestone: bariatric-study-data Component: data-stds | Resolution: Keywords: | Blocked By: Blocking: | --------------------------+----------------------------------- Changes (by dconnolly): * owner: westr006 => preeder * status: reopened => assigned Comment: Phillip, how would you approach this? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/103#comment:12> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list [email protected]<mailto:[email protected]> http://listserv.kumc.edu/mailman/listinfo/gpc-dev ________________________________ UT Southwestern Medical Center The future of medicine, today. ------------------------------------------------------------------------- This message was secured by ZixCorp(R). The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. _______________________________________________ Gpc-dev mailing list [email protected]<mailto:[email protected]> http://listserv.kumc.edu/mailman/listinfo/gpc-dev _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
