Thanks Shawn, however one clarification please. I see from your examples that the formalism can be used to identify a subset of patients or providers for a folder view access, and I assume that I can select a Patient_dimension attribute an rename it as a variable in the first example below (leaf attribute). But can you also recompute a result such as in the second example below where I compute age from Patient_dimension.Birth_date?
Jim <concept> <level>3</level> <name>Birth date</name> <visualattributes>LA</visualattributes> <facttablecolumn>patient_num</facttablecolumn> <tablename>patient_dimension</tablename> <columnname>Birth_date</columnname> <columndatatype>Date</columndatatype> <operator>=</operator> <dimcode>\PCORI\Demographics\Birthdate\</dimcode> <tooltip>PCORI\Demographics\Birthdate</tooltip> </concept> <concept> <level>3</level> <name>Age</name> <visualattributes>LA</visualattributes> <facttablecolumn>patient_num</facttablecolumn> <tablename>patient_dimension</tablename> <columnname>Birth_date</columnname> <columndatatype>Integer</columndatatype> <operator>=</operator> <dimcode>(sysdate-Birth_date)*365.24</dimcode> <tooltip>PCORI\Demographics\Age</tooltip> <\concept> ________________________________ From: Murphy, Shawn N. [[email protected]] Sent: Saturday, July 26, 2014 8:14 PM To: Campbell, James R; i2b2 Academic Forum ([email protected]); Hickman, Hubert B; Karthik Tumu; Munns, Michael B Subject: RE: RE: Hi Jim, It is here: https://community.i2b2.org/wiki/display/DevForum/Query+Building+from+Ontology Thanks, Shawn. From: Campbell, James R [mailto:[email protected]] Sent: Friday, July 25, 2014 7:48 AM To: Murphy, Shawn N.; i2b2 Academic Forum ([email protected]); Hickman, Hubert B; Karthik Tumu; Munns, Michael B Subject: RE: Shawn Is the deployment of this documented in any i2b2 reference? Jim ________________________________ From: Murphy, Shawn N. [[email protected]] Sent: Thursday, July 24, 2014 9:06 PM To: Campbell, James R; i2b2 Academic Forum ([email protected]<mailto:[email protected]>) Subject: RE: Hi Jim, It computed off of the birth_date column in the patient dimension. For example, here is the XML associated with the 10-17 y/o folder (from the demo demographics ontology): <concept> <level>3</level> <key>\\i2b2_DEMO\i2b2\Demographics\Age\10-17<file:///\\i2b2_DEMO\i2b2\Demographics\Age\10-17> years old\</key> <name> 10-17 years old</name> <synonym_cd>N</synonym_cd> <visualattributes>FA </visualattributes> <totalnum xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:nil="true" /> <facttablecolumn>patient_num</facttablecolumn> <tablename>patient_dimension</tablename> <columnname>birth_date</columnname> <columndatatype>N</columndatatype> <operator>BETWEEN</operator> <dimcode>sysdate - (365.25*18) AND sysdate - (365.25*10) </dimcode> <tooltip>Demographics \ Age \ 10-17 years old</tooltip> </concept> Thanks, Shawn. From: Campbell, James R [mailto:[email protected]] Sent: Thursday, July 24, 2014 7:57 PM To: i2b2 Academic Forum ([email protected]<mailto:[email protected]>) Subject: At the Boston meeting I saw a formulaic rendition of patient age from birthdate data in the Patient Dimension. I may have been confused about context but I assume it was either an Observation fact load utility or, better yet, a computable datatype definition for patient age. Can anyone clarify my uncertainty and direct me to resources? Jim Campbell 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. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
