About this chapter

The data installation chapter outlines the process of installing the i2b2 data that is specific to the i2b2 on OMOP project. This process involves creating tables, procedures, views as well as loading data into the tables. The data being loaded is based off the CMS SynPUF 1k sample data that is provided by OMOP.

Pre-requisites

 Before moving forward with the installation of the i2b2 on OMOP tables the following requirements must be met.

NOTE:

In your i2b2 database you may or may not have installed the crcdata and metadata tables that are provided in the standard i2b2 data package. 

TO DO: FINISH THIS NOTE

<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/14091764/icon_note.png" width="16" height="16" align="absmiddle" alt="info" border="0">
                    </td>
                    <td>
                        <b>Note</b>
                        <br>In your i2b2 database you may or may not have installed the crcdata and metadata tables that are provided in the standard i2b2 data package.
                    </td>
                </tr>
            </tbody>
        </table>
    </div>

Order of Installation

It is important the tables, procedures, and views are installed in the order defined below. Failure to do so will result in errors when running the scripts.

CRC Tables

•  crcdata: create tables
•  crcdata: create procedures
•  crcdata: load data
•  crcdata: create OMOP views

Ontology Tables

•  metadata: create tables
•  metadata: load data 

Workplace Tables

•  workdata: create tables
•  workdata: load data