IDRT - Integrated Data Repository Toolkit
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

What is ODM?

The CDISC Operational Data Model (ODM), maintained by the CDISC XML Technologies Team, is designed to facilitate the regulatory-compliant acquisition, archive and interchange of metadata and data for clinical research studies. ODM is a vendor neutral, platform-independent format for interchange and archive of clinical study data. The model includes clinical data along with its associated metadata, administrative data, reference data and audit information. All the information that needs to be shared among different software systems during the study setup, operation, analysis, submission or for long-term retention as part of an archive is included in the model. See details on the CDISC ODM certification program, including a list of ODM-certified company products.

 See Official CDISC-ODM Page

Example File

In the github repository, you can find some CDISC-ODM Example Files.

Import CSDISC-ODM

To import your CDISC-ODM files to i2b2, you have to right click the i2b2 project in the Import Browser and select Import Data -> Import CDISC-ODM.

A new window opens, where you can set different options.

Name

Description

Truncate i2b2 Project?

If you check this, the project will be truncated before the data is uploaded.

Truncate Previous Queries?

This will truncate the previous queries tables.

Database Indexing

Ignore: Don't touch the indexes;
Stop/Start: Stop the indexes before the upload and start them afterwards;
Drop/Create: Drop the indexes before the upload and create them from scratch afterwards.

Set patient_count after import

This will fill the c_totalnum column.

CDISC-ODM Folder

Here you can select the folder that contains all CDISC-ODM files you want to upload.

Include complete Codelists?

This will generate i2b2 ontology items that are in a codelist, even if there are no patients for it.

Include PIDs?

This will generate a new i2b2 folder containing the patient IDs (PID) as items.

Save Settings?

This will save the settings for the next import. Note: The truncate checks are never saved.

If you hit finish the upload starts. You can observe the progress in the progress bar of the Import Browser.

After the import is finished, you can load the i2b2 ontology with the Mapping Editor. If you loaded the sample data linked above, you should see the following result in the Mapping Editor View:

The CDISC-ODM Importer keeps the hierarchy the file suggests. You can make changes to that with the editing functionality of the Mapping Editor.  

  • No labels

3 Comments

  1. Where do I find the included PIDs? Is this some special folder or a standard i2b2 folder in the ontology?

  2. Unfortunately, saving options doesn't work for most entries. Choosing not to include complete codelists seems to have no effect either.

  3. Anonymous

    Where exactly is this importing to? An ontology table (e.g. i2b2metadata.i2b2) and/or CONCEPT_DIMENSION and/or OBSERVATION_FACT?