<!DOCTYPE html>
<html lang="en">
<head>
<title>i2b2 1.7.00 Release Notes</title>
<meta charset="UTF-8">
<meta name="description" content="The release notes for version 1.7.00 of the i2b2 Software" />
<meta name="keywords" content="i2b2, release, 1.7" />
<link rel="stylesheet" type="text/css" media="all" href="/stylesheets/i2b2-wiki.css" />
</head>
<body>
<h1 id="rel1700">i2b2 Release 1.7</h1>
<p class="releaseDate"><b>Release Date:</b> December 20, 2013</p>
<h2>Installation Notes</h2>
<ul>
<li>
This release note applies to you if you are <b>upgrading to 1.7</b> from an earlier version of i2b2.
</li>
<li>
If you are installing 1.7 from a computer running the i2b2 Workbench, ensure that the workbench and all eclipse applications are closed prior to installing this release.
</li>
<li>
If you are installing a new instance of i2b2 we recommend you refer to the installation documentation found on the i2b2 community wiki. This documentation will guide you through the entire installation process.
</li>
</ul>
<h2 id="rel1700upgradeNotes">Upgrade Notes</h2>
<p>
i2b2 Release 1.7 contains changes to the following software components:
</p>
<ul>
<li>
Database Scripts
</li>
<li>
i2b2 Server
</li>
<li>
i2b2 Web Client
</li>
<li>
i2b2 Workbench
</li>
</ul>
<h2>Third Party Software Changes</h2>
<p>In release 1.7 the <b>i2b2 Server</b> has been updated to use the following versions of third party software.</p>
<ol>
<li>JBoss has been upgraded to 7.1.1</li>
<li>Apache Ant has been upgraded to 1.8.2</li>
<li>Apache Axis2 has been upgraded to 1.6.2</li>
</ol>
<div class="i2b2-panel">
<table class="i2b2-warning">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_warning.gif" width="16" height="16" align="absmiddle" alt="warning" border="0">
</td>
<td>
<b>Warning</b>
<br>Only the i2b2 Server was upgraded to use the above versions of JBoss, Ant, and Axis2. The i2b2 Workbench will continue to use the previous versions. As a result, the source codes for the server and the workbench client have different plug-ins for the commons.
<p class="i2b2-panel-list">Server edu.harvard.i2b2.server-common</p>
<p class="i2b2-panel-list">Client edu.harvard.i2b2.common</p>
</td>
</tr>
</tbody>
</table>
</div>
<h2 id="rel1700chgSumCore">Change Summary - i2b2 Core Software - Release 1.7.00</h2>
<h3>Improvements</h3>
<ul>
<li>Find Terms: New feature called "Jump to Term in Tree"</li>
<li>Previous Query: Filter list by user</li>
<li>Previous Query: Search Previous Queries View</li>
<li>Previous Query: Page through previous queries by date</li>
<li>Database: PROJECT_ID Column added to PATIENT_MAPPING and ENCOUNTER_MAPPING tables (support for new IM cell)</li>
<li>Demo Data: Updated PATIENT_MAPPING table to support the new IM cell.</li>
</ul>
<h3>New Features</h3>
<ul>
<li>Temporal Queries (New Temporal Query Tool View)</li>
<li>Identity Management Cell (IM)</li>
<li>Identity Management Tables</li>
<li>Managers Tool View</li>
<li>OpenEMPI Support</li>
<li>Patient Mapping View</li>
<li>Patient Sets View</li>
<li>PostgreSQL Database Support</li>
<li>Workplace Find View</li>
</ul>
<h3>Bug Fixes</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-5">CORE-5</a>] - CRC build from source deposits i2b2Common-core.jar in wrong directory</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-70">CORE-70</a>] - I2b2 compilation of CRC Cell fails</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-74">CORE-74</a>] - Typo in i2b2_config_data.js of admin interface</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-81">CORE-81</a>] - No PATIENT_NUM in OBSERVATION_FACT_PK (conflict with documentation)</li>
</ul>
<h3>Documentation</h3>
<ul>
<li>Architecture, design and messaging documents for the new Identity Management (IM) Cell.</li>
<li>Design documentation for the new Temporal Query Tool plug-in.</li>
<li>User guide for the new Temporal Query view.</li>
<li>Documentation for the new views (Patient Set, Patient Mapping, Managers Tool, and Find in Workplace).</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-8">CORE-8</a>] - Suggestions for improvements to installation documents
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-75">CORE-75</a>] - CRC_Design.pdf page numbers are broken, all page numbers are set to 1 of 1, 2 of 2, etc. instead of 1 of xx
</li>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-78">CORE-78</a>] - Errors in I2B2 Hive Installation Guide v 1.7.0
</li>
</ul>
<h3>Tasks</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/CORE-45">CORE-45</a>] - Establish CRCLoader project (eclipse) from exiting ant build file failed
</li>
</ul>
<h2 id="rel1700chgSumWebClient">Change Summary - i2b2 Web Client Software - Release 1.7.</h2>
<h3>New Features</h3>
<ul>
<li>
Temporal Queries (Modification made to existing Query Tool)
</li>
</ul>
<h3>Documentation</h3>
<ul>
<li>[<a href="http://community.i2b2.org/jira/browse/WEBCLIENT-40">WEBCLIENT-40</a>] - Webclient: documentation should state that php and curl are prerequisites for the webclient
</li>
</ul>
<h2 id="rel1700newFeatureDetails">Improvement / New Feature Details</h2>
<h3 id="rel1700newFeatureDetails-tempQry">Temporal Queries</h3>
<p>The <b><i>temporal query</i></b> is a new type of query introduced in release 1.7. There are two components to these queries that make them a little more complex than the type of queries available prior to 1.7 (classic i2b2 queries).</p>
<p>The first component to these queries is the list of events defined by the user.</p>
<p>The second component is the relationship between the events. This relationship is referred to a Temporal Relationship, which is best described as how the different events relate in regards to the time in which the event(s) occurred.</p>
<p>Users can also define a patient or event population in which they wish to run the temporal query against. This step is optional and is not required in order to run the temporal query.</p>
<p>The process in which temporal queries are defined is slightly different in the i2b2 Web Client and the i2b2 Workbench. In the i2b2 Web Client the existing Query Tool view has been modified to accommodate Temporal Queries while a new view called Temporal Query Tool view has been created for the i2b2 Workbench.</p>
<p>The new Temporal Query Tool view and the modifications to the existing Query Tool view extend the query functionalities provided by the classic Query Tool view.</p>
<p>It is important to note that while the manner in which users setup a temporal query is different in each of the clients the overall functionality is the same.</p>
<p>The following two sections will describe how to run Temporal Queries in the i2b2 Web Client and the i2b2 Workbench.</p>
<h4>i2b2 Web Client: Temporal Queries</h4>
<p>In the i2b2 Web Client there are five basic steps in defining a <i>temporal query</i> in the <b>Query Tool view</b>.</p>
<ol>
<li>Change <i>Temporal Constraint</i> to <b>Define sequence of Events</b>.</li>
<li>Define <i>Population in which events occur</i> (optional step).</li>
<li>Define Events</li>
<li><i>Define order of events</i> (temporal relationships)</li>
<li>Run the query</li>
</ol>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_info.gif" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>For detailed information about creating Temporal Queries please see the Temporal Query help file located on-line from within the i2b2 Web Client.
</td>
</tr>
</tbody>
</table>
</div>
<h6>Step 1: Change Temporal Constraint</h6>
<p>The first step is to change the Temporal Constraint to <i>Define sequence of Events</i>.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-1.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-1.png" alt="Temporal Query - Define Sequence of Events" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Step 2: Define Population in which events occur</h6>
<p>Once you have changed the Temporal constraint to be <i>Define sequence of Events</i> a new <b>Page selection box</b> will appear below the Temporal Constraint section. The default page will be <b>Population in which events occur</b>. It is on this page you will define your population requirements.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-2.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-2.png" alt="Temporal Query - Define Population" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Step 3: Define Events</h6>
<p>The events are the first component of a temporal query. There are no restrictions on the number of events you wish to define. The only requirement is that you have to define at least two events.</p>
<p>To define the events simply click on the <i>Page selection box</i> and select <b>Event 1</b> from the drop-down list.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-3.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-3.png" alt="Temporal Query - Define Events" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The groups and constraints for the events work in the same manner as they did for a traditional i2b2 query. Simply drag the items you want to include in Event 1 to the appropriate groups.</p>
<p>Once you have added your items to the groups you can click on the <i>Page selection box</i> and select <b>Event 2</b> from the drop-down list. This will change the page to display the groups for Event 2.</p>
<p>If you need to add a third event you can click on the <b>New Event button</b> located next to the <i>Page selection box</i>.</p>
<h6>Step 4: Define Order of Events (Temporal Relationship)</h6>
<p>As stated earlier the second component of a temporal query is the relationship between the events (temporal relationship). In the i2b2 Web Client this is done on the <b>Define order of events page</b>, which is accessed by clicking on the <i>Page selection box</i> and selecting <b>Define order of events</b> from the drop-down list.</p>
<p>The page will display as follows:</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link"
href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-4.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WC_tempQry-4.png" alt="Temporal Query - Define Events" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Step 5: Run Query</h6>
<p>In the Web Client running a query works the same regardless of whether or not it is a Temporal Query or a traditional i2b2 query. By clickin on the <b>Run Query button</b>, the i2b2 client will send the request to the i2b2 server which will run the query as defined.</p>
<h4>i2b2 Workbench: New Temporal Query Tool View</h4>
<p>In the i2b2 Workbench there are three pages or steps in defining and running a <i>temporal query</i> in the new <b>Temporal Query Tool view</b>.</p>
<ol>
<li>Page 1: Define Population</li>
<li>Page 2: Define Temporal Relationships</li>
<li>Page 3: Review and Submit Query</li>
</ol>
<h4>i2b2 Workbench: New Temporal Query Tool View</h4>
<h4>Define Date Constraints and Exclusions in Temporal Query Tool View</h4>
<h5>Defining the Date Constraints</h5>
<h5>Exclude Panel</h5>
<p>Each page as well as defining constraints is further defined in the next few sections.</p>
<div class="i2b2-panel">
<table class="i2b2-note">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_info.gif" width="16" height="16" align="absmiddle" alt="info" border="0">
</td>
<td>
<b>Note</b>
<br>For detailed information about using the Temporal Query Tool view, please see the help file for this view which is available on-line from within the i2b2 Workbench.
</td>
</tr>
</tbody>
</table>
</div>
<h6>Page 1: Define Population</h6>
<p>On this page you will define your population requirements.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-1.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-1.png" alt="Temporal Query - Define Population" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Page 2: Define Temporal Relationships</h6>
<p>As stated earlier there are two components to a <b><i>temporal query</i></b>; (1) List of events and (2) the relationship between the events.</p>
<p>The second page is where you will define both the events and their relationship.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-2.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-2.png" alt="Temporal Query - Define Relationships" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h6>Page 3: Review and Submit</h6>
<p>On this page the name of the query will default and if you wish to rename it you can do so at this point. Whatever is entered here will be the name given to the query when it is run. In addition you can select the Analysis Types that you want when running the query.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-3.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQry-3.png" alt="Temporal Query - Submit" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h5>Defining Date Constraints and Exclusions in Temporal Query Tool View</h5>
<p>There are some minor differences in terminology or layout that needs to be noted in this release note.</p>
<h4>Defining the Date Constraints</h4>
<p>In the classic Query Tool view you can only define date constraints on the group / panel level. In the new Temporal Query TOol view you can now define a date constraint on either the query or group levels. If you define it on the query level it will default the same date constraint for all the groups and the date constraint on the panel level will not be available for selection.</p>
<p>If you want to define it on the panel level select <b>Group-Specific</b>. Go to the group you wish to define the constraint and click on the column that displays <i>No Date Constraints</i>.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryDtConst.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryDtConst.png" alt="Temporal Query - Date Constraints" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h5>Exclude Panel</h5>
<p>The ability to exclude all items in a group does exist in the new Temporal Query Tool view. However, the method in which it is defined differs between the classic Query Tool view and the Temporal Query Tool view.</p>
<p>In the existing <b>Query Tool view ("Classic")</b> the exclusion constraint was defined by clicking on the button labeled <i>Exclude</i>.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclOld.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclOld.png" alt="Query Tool - Exclude" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>In the <b>Temporal Query Tool view (New)</b> the exclusion constraint was rolled into the window for defining the Occurrence constraint.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclNew.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryExclNew.png" alt="Temporal Query - Exclude" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The <i>Specify Occurrence Constraints</i> windows will open when you click on the box that displays the occurrence constraint. To set the exclusion constraint you need to select "= 0 (No Occurrences)" from the drop-down list.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryOccur.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_tempQryOccur.png" alt="Temporal Query - Occur Constraint" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The above option is equivalent to the <i>Exclude</i> feature in the classic Query Tool view.
</p>
<h3 id="rel1700newFeatureDetails-pqFilterUser">Previous Query: Filter list by user</h3>
<p>New in release 1.7 is the ability to filter the list of previous queries by the user who created the query. In the options dialog <span style="color:#BFBFBF">(<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_options.png" alt="Options Icon" height="20" width="20" style="border: 0px solid black">)</span> window there is a new field called <b>Get previous queries for user</b>. The default is <i>all users</i> and can be changed to a specific user by clicking on the down arrow to display the drop-down list. Once you select the user and click on <b>OK</b>, the Previous Queries view will refresh and display only those previous queries created by the selected user.
</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqFilterByUser.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqFilterByUser.png" alt="Previous Queries - Filter by User" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_caution.gif" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>In i2b2 only managers are allowed to view queries for another user, therefore this feature is only available to those users who have the role of <b>MANAGER</b> defined for the project. If a user does not have the manager role then this field will be inactive and unavailable for selection.
</td>
</tr>
</tbody>
</table>
</div>
<h3 id="rel1700newFeatureDetails-pqSearch">Previous Query: Search Previous Queries View</h3>
<p>
In release 1.7 the ability to search the Previous Queries view has been added. The functionality is very similar to <i>Find Terms</i> view except it will search the <i>Previous Queries</i> view instead of <i>Navigate Terms</i> view. Users can search any of the three levels;
</p>
<ol>
<li>Previous Query (name)</li>
<li>Previous Query Result</li>
<li>Patient</li>
</ol>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqSearch.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqSearch.png" alt="Previous Queries - Search" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-pqPaging">Previous Query: Page through previous queries by date</h3>
<p>Users can now retrieve the next or previous grouping of previous queries by the date in which the query was created.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqPaging.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_pqPaging.png" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The <i>Previous button</i> <span style="color:#BFBFBF">(<img src="https://community.i2b2.org/wiki/download/attachments/851978/button_previous.png" alt="Previous Button" height="20" width="20" style="border: 0px solid black">)</span> will retrieve the group of previous queries that occur <b>prior</b> to the date displayed in the date / time field.</p>
<p>The <i>Next button</i> <span style="color:#BFBFBF">(<img src="https://community.i2b2.org/wiki/download/attachments/851978/button_next.png" alt="Next Button" height="20" width="20" style="border: 0px solid black">)</span> will retrieve the group of previous queries that occur <b>after</b> the date displayed in the date / time field.</p>
<h3>Identity Management Cell (IM)</h3>
<p>A new cell called the Identity Management (IM) Cell was developed in release 1.7. This new cell contains Protected Health Information (PHI), which can be used to identify patients. The IM cell is used to manage this PHI in a manner consistent with the HIPAA privacy rule. The patient data will be available only as a HIPAA defined "Limited Data Set" to most of the hive.</p>
<p>The full functionality of the IM cell will be developed in stages. The initial framework and key services are released as part of the 1.7 release. Some of the key features being released in 1.7 are:</p>
<ol>
<li>New tables to store identifiers from different sites, and patients that are included in a project.</li>
<li>Audit controls are implemented that are in compliance with the HIPAA privacy rules.</li>
<li>Services developed to set and validated an AES key for encrypting and decrypting patient MRNs in the IM cell.</li>
<li>Unencrypted patient identifiers sent in the PDO can be processed through the IM cell to retrieve all site IDs for the patient and project.</li>
</ol>
<p>In addition to the above features, the i2b2 Worbench (eclipse client) has two new views that were created to support the new IM cell. These new views, called <b>Patient Mapping</b> and <b>Admin Tool</b> are further defined in the following two sections called <i>Patient Mapping View</i> and <i>Admin Tool View</i>.</p>
<h3 id="rel1700newFeatureDetails-mgrsView">Managers Tool View</h3>
<p>The <b>Managers Tool</b> view was developed in release 1.7 and works in conjunction with the IM Cell. It currently has two main functions.</p>
<ol>
<li>Set and / or validate that the project key is defined in the IM Cell.</li>
<ul>
<li>The project key is used by the IM cell to decrypte the patient id's that are encrypted.</li>
<li>The Set Key is used to define the key in the IM cell.</li>
<li>The Validate Key is used to verify the key is set.</li>
</ul>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tbody>
<tr>
<td>
<img src="https://community.i2b2.org/wiki/download/attachments/851978/icon_caution.gif" width="16" height="16" align="absmiddle" alt="important" border="0">
</td>
<td>
<b>Important</b>
<br>If you are using the IM cell and your patient identifiers are encyrpted the you need to set the Project key in the IM cell. It is important to note that if you restart your i2b2 server or in the case of the VM image restarting the virtual machine then you will need to re-enter the project key.
<br>
<br>The project key for the i2b2 demo project is: <b>i2b2demodatakey1</b>
<br>
<br>In the VM image you need to log into the i2b2 Workbench as the i2b2 Admin user.
<br>
<p class="i2b2-panel-list">User ID: i2b2
<br>Password: demouser</p>
</td>
</tr>
</tbody>
</table>
</div>
<li>View the audit information.</li>
<ul>
<li>As part of the IM cell an audit table was created to track when a patient in the IM cell was accessed. This new view allows Project Managers or Administrators to run a report to see that audit information. The report can be run for a particular user, patient, or all audit information for the project you are logged into.</li>
</ul>
</ol>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_mgrsTool.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_mgrsTool.png" alt="Managers Tool View" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-ptSetsView">Patient Sets View</h3>
<p>In release 1.7 a new view called <b>Patient Sets</b> was created. This new view will display a list of <i>Patient sets</i> that were created when a query was run. It is similar to the Previous Queries view except it only displays the patient sets and not the previous query or other result sets (i.e. Encounter sets, Number of patients, etc).</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-1.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-1.png" alt="Patient Sets View" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>The patient sets can be expanded to display a list of patients.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-2.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-2.png" alt="Patient Sets View Expanded" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<p>Users can drag an entire patient set or a single patient to other views in the i2b2 Workbench.</p>
<p>Users can also perform a search in which they can search by the name of the patient set or for a list of patient sets that contain a specific patient.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-3.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_ptSets-3.png" alt="Patient Sets View Search" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-workFindView">Workplace Find View</h3>
<p>A new view called <b>Find in Workplace</b> was created in release 1.7. This view is very similar to the <i>Find Terms</i> view except it will search the <i>Workplace</i> view instead of the <i>Navigate Terms</i> view.</p>
<div class="i2b2-images">
<p>
<span class="i2b2-screen-print" style="">
<a class="i2b2-thumbnail-link" href="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_workFind.png">
<img src="https://community.i2b2.org/wiki/download/attachments/8585269/1700_WB_workFind.png" alt="Workplace Find View" height="100" width="100" style="border: 0px solid black">
</a>
</span>
</p>
</div>
<h3 id="rel1700newFeatureDetails-jumpToTerm">Find Terms: New feature called "Jump to Term in Tree"</h3>
<p>A new feature called <b>Jump to Term in Tree</b> has been added to the <i>Find Terms</i> view. Users can now easily jump directly to a term in the <i>Navigate Terms</i> view from the <i>Find Terms</i> view.</p>
<p>Once a term is found in the <i>Find Terms</i> view the user can click on the term using the <i>right mouse button</i> to display the pop-up menu. Selecting "Jump to Term in Tree" from the pop-up menu will bring the <i>Navigate Terms</i> view into focus and the hierarchical tree will automatically open to the location of the term selected in the <i>Find Terms</i> view.</p>
<h3>OpenEMPISupport</h3>
<p>OpenEMPI is an open source Enterprise Master Patient Index (EMPI) which is developed and supported by another community. The i2b2 IM cell has been developed to allow communication with OpenEMPI for those sites that choose to use it as their patient repository.</p>
<p>For additional information on OpenEMPI please see their website by going to the following location: <a href="https://openempi.kenai.com/">https://openempi.kenai.com/</a>
</p>
<h3 id="rel1700newFeatureDetails-postgresql">PostgreSQL Database Support</h3>
<p>The ability to use a PostgreSQL database as an i2b2 database has been added to release 1.7. Both the create and insert data database scripts for PostgreSQL are included in this release.</p>
<h3 id="rel1700newFeatureDetails-newImTables">Data: New Tables created for the IM Cell</h3>
<p>The following new tables were created as part of the new IM cell.</p>
<table class="i2b2-table">
<tr>
<th class="i2b2-th">Table Name</th>
<th class="i2b2-th">Description</th>
</tr>
<tr>
<td class="i2b2-td">IM_MPI_DEMOGRAPHICS</td>
<td class="i2b2-td">Contains General demographic information for the patients.</td>
</tr>
<tr>
<td class="i2b2-td">IM_MPI_MAPPING</td>
<td class="i2b2-td">Maps the patient's <i>i2b2 number</i> and the <i>local MRN</i>.</td>
</tr>
<tr>
<td class="i2b2-td">IM_PROJECT_SITES</td>
<td class="i2b2-td">Contains information about the different sites (Source Systems).</td>
</tr>
<tr>
<td class="i2b2-td">IM_PROJECT_PATIENTS</td>
<td class="i2b2-td">Stores the patients that are part of a project(s).</td>
</tr>
<tr>
<td class="i2b2-td">IM_AUDIT</td>
<td class="i2b2-td">Stores the audit details of patients accessed in the IM cell. This includes; the user, site, and project requesting the access as well as the date in which it was accessed.</td>
</tr>
</table>
<h3 id="rel1700newFeatureDetails-dataNewColumns">Data: New Columns added to support IM cell</h3>
<p>A new column called <b>Project_ID</b> has been added to both the <b>PATIENT_MAPPING</b> and <b>ENCOUNTER_MAPPING</b> tables in the crc. The PROJECT_ID was added to support the IM cell. It will allow sites to track which project a patient is part of.</p>
<h3 id="rel1700newFeatureDetails-dataPtMap">Data: Improved Patient Mapping Data</h3>
<p>The <b>PATIENT_MAPPING</b> table in the CRC has been updated to include the following:</p>
<ul>
<li>Mappings of existing patients to multiple site MRNs.</li>
<li>Project IDs added to patients.</li>
</ul>
<p>Demo data has been added to all of the new IM tables except the AUDIT table. This IM data was added to provide examples for using the new IM cell.</p>
<div class="i2b2-panel">
<table class="i2b2-important">
<colgroup>
<col width="24">
<col>
</colgroup>
<tr>
<td>
<img src="important.gif" width="16" height="16" align="absmiddle" alt="" border="0">
</td>
<td><b>Important</b>
<br>The mapping information added to the CRC and IM tables is strictly for demonstration purposes and does NOT contain real patient information.</td>
</tr>
</table>
</div>
<h3 id="rel1700newFeatureDetails-postgresqlScripts">New PostgreSQL Database Scripts</h3>
<p>The i2b2 database scripts have been updated to include the table creation and data insert scripts for a PostgreSQL database.</p>
<h1>Licensing</h1>
<p>The i2b2 source code is licensed under the i2b2 Software License 2.1. This includes but is not limited to all code in the edu.harvard.i2b2.* package namespace.</p>
<h1>Trademarks</h1>
<p>Microsoft, Windows, Windows 7, Windows Server 2003 and 2008 are either registered trademarks or trademarks of Microsoft Corporation in the United States and / or other countries.</p>
<p>Mac OS is a registered trademark of Apple Inc.</p>
<p>Eclipse Galileo is a registered trademark of the Eclipse Foundation, Inc.</p>
<p>All other trademarks are the property of their respective owners.</p>
</body>
</html>
| 
