Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin


Note
titleImportant

You only need to update the QT_BREAKDOWN_PATH table if you loaded your own metadata during the Data Installation process.

  • If you loaded the data that is supplied in the metadata and crcdata (demodata) packages then no changes are necessary.
  • If you loaded your own metadata then you need to change the entries in the VALUE column of the QT_BREAKDOWN_PATH table to point to the metadata key (TABLE_CD\FULLNAME) for your analysis breakdowns.

Update the path in the QT_BREAKDOWN_PATH table

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.

  • The standard i2b2 breakdowns are the demographic concepts of gender, vital status, race, and age.
  • The metadata key is a concatenation of two columns in two different ontology tables. This key tells the CRC where the concepts for the breakdowns are located. The CRC uses this information to query the Ontology cell to retrieve the query parameters associated with the concept



METADATA KEY

The metadata key is comprised of two parts:

indent
Level1

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.

indent
Level1

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.


html-text
  <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>