OMOP
Space shortcuts
Space Tools
OMOP OMOP

Versions Compared

Old Version 3

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version Current

changes.mady.by.user Janice Donahoe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#D7E5F5
borderStylesolid
titleData Installation: Table of Contents

Table of Contents
printablefalse

 

 

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 i2b2 data being loaded is based off the CMS SynPUF 1k sample data that is provided by OMOP.

In this chapter we will be using the scripts provided in the data package to create tables and load them with sample data.

Pre-requisites

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

Image Removed Requirements Section

indentLevel1:

Image Modified

  Installed your

Your i2b2 hivedata and pmdata tables have been installed and loaded with the data provided in the standard i2b2 data file.

indent

Level1

Image Modified  Installed your CDM tables and loaded data from the SynPUF sample data file

indent
Level1

Image Removed  CDM tables reside in the same database / schema as your i2b2 tables

.

The OHDSI maintains the CDM tables, for additional information on setting up these tables, please see the OMOP CDM page.

Image Added  Your CDM database or schema have been setup.

Image Added   A database user has been setup.

  • This user is needed to create and load data into the new i2b2 tables.
  • It is also used by the i2b2 Cells when they need to contact the database or schema.
TO DO: FINISH THIS NOTE

 

html-text
<div class="i2b2-panel">


    

<table class="i2b2-

note

important">


        <colgroup>


            <col width="24">


            

<col>
        

</colgroup>


        <tbody>


            

<tr>


                

<td>
                    

<img src="https://community.i2b2.org/wiki/download/attachments/14091764/icon_

note

important.png" width="16" height="16" align="absmiddle" alt="info" border="0">


                </td>


                

<td>

<b>Note<

<b>Important</b>
                    <br>The i2b2 tables need

<br>In

to

your

reside

i2b2

within

database

the

you

same

may

location

or

as

may

your

not

CDM

have

tables.

installed

During the

crcdata

installation

and

you

metadata

need

tables

to

that

know

are

the

provided

following

in

information

the

about

standard

your

i2b2

CDM

data package. </td>

database.
					<br>
					<ul>
						<li>The url for the location of the database</li>
						<li>Name of your CDM database / schema.</li>
						<li>The username and password for the database user.</li>
					</ul>
                </

tr>

td>
            </

tbody>

tr>
        </

table>

tbody>

</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 

 

 

 

</table>
</div>

OMOP OMOP