You only need to update the QT_BREAKDOWN_PATH table if you loaded your own metadata during the Data Installation process.
|
In the i2b2 users will select the type of results they would like returned when running a query (e.g. Patient set, Encounter set, Number of Patients, etc.). Some of the result types are a breakdown of pre-defined concepts such as gender, vital status, race, and age. The metadata keys for these analysis breakdowns are defined in the QT_BREAKDOWN_PATH table that was created during the CRC data installation.
METADATA KEY
The metadata key is comprised of two parts:
Part 1: the first part of the key is the TABLE_CD which is equivalent to the C_TABLE_CD column in the TABLE_ACCESS table. |
Part 2: the second part of the key is the FULLNAME which is equivalent to the C_FULLNAME column in your metadata table. |
The format of the metadata key is: \\TABLE_CD\FULLNAME\
EXAMPLE DATA FROM I2B2 DEMO
The following is an example of the i2b2 demo data that was loaded into the QT_BREAKDOWN, TABLE_ACCESS, and I2B2 tables during the data installation process.
<head> <style type="text/css"> table,th,td { border-style:solid; border-color:#D8D8D8; border-width:1px; border-collapse:collapse; text-align:left; } th,td { padding:10px; } th { background-color:#F0F0F0; } </style> </head> <body> <p> <b>Table: <i>QT_BREAKDOWN_PATH</i></b> </p><br> <table> <tr> <th> NAME </th> <th> VALUE </th> </tr> <tr> <td> PATIENT_AGE_COUNT_XML </td> <td> \\<font color="#0000FF">i2b2_DEMO</font><font color= "#006A35">\i2b2\Demographics\Age\</font> </td> </tr> <tr> <td> PATIENT_GENDER_COUNT_XML </td> <td> \\<font color="#0000FF">i2b2_DEMO</font><font color= "#006A35">\i2b2\Demographics\Gender\</font> </td> </tr> <tr> <td> PATIENT_RACE_COUNT_XML </td> <td> \\<font color="#0000FF">i2b2_DEMO</font><font color= "#006A35">\i2b2\Demographics\Race\</font> </td> </tr> <tr> <td> PATIENT_VITALSTATUS_COUNT_XML </td> <td> \\<font color="#0000FF">i2b2_DEMO</font><font color= "#006A35">\i2b2\Demographics\Vital Status\</font> </td> </tr> </table><br> <br> <p> <b>Table: <i>TABLE_ACCESS</i></b> </p> <p> <i>(Only those columns and rows that are relevant to this example are shown)</i> </p> <br> <table> <tr> <th> C_TABLE_CD </th> <th> C_TABLE_NAME </th> <th> C_FULLNAME </th> <th> C_NAME </th> </tr> <tr> <td> <font color="#0000FF">i2b2_DEMO</font> </td> <td> I2B2 </td> <td> \i2b2\Demographics\ </td> <td> Demographics </td> </tr> </table><br> <br> <p> <b>Table: <i>I2B2</i></b> </p> <p> <i>(Only those columns and rows that are relevant to this example are shown)</i> </p><br> <table> <tr> <th> C_FULLNAME </th> <th> C_NAME </th> </tr> <tr> <td> <font color="#006A35">\i2b2\Demographics\Age\</font> </td> <td> Age </td> </tr> <tr> <td> <font color="#006A35">\i2b2\Demographics\Gender\</font> </td> <td> Gender </td> </tr> <tr> <td> <font color="#006A35">\i2b2\Demographics\Race\</font> </td> <td> Race </td> </tr> <tr> <td> <font color= "#006A35">\i2b2\Demographics\VitalStatus\</font> </td> <td> Vital Status </td> </tr> </table> </body> |