Create a clinical data model for Clinical One data

For details on creating a clinical data model for Clinical One data, see this video:

1. On the Home page or Study Manager interface, select the study and the Development lifecycle stage.

2. Click the Study Configuration icon from the navigation bar. Then click the Clinical Data Models tab.

3. Click the Add icon for Clinical Data Models at the top of the left pane.

4. Enter a name and description. See Naming restrictions for details.

5. For the model type, select Input.

6. For Input Type, select Clinical One.

7. To allow visualization tools access to the data contained in the clinical data model, select the Business Area checkbox.

   You can change the default schema name, BA_model_name. This is what users of the visualization tool will see. Limitation: Use a maximum of 19 characters for the schema name if you plan to create custom listings on the model. Do not use spaces or special characters other than underscore (_).

8. Data Mart: A data mart file contains all current data in a clinical data model for export to an external system. Select data mart type(s) to make available:

   Only the types that are available in your environment are displayed.

   • Oracle Export
   • Text Export
   • SAS Export

9. Click OK.

   Note:

   Tables with more than 339 columns may cause problems with data loading, transformations, and display in the Listings pages. See My Oracle Support article 2298558.1 for the latest information.

Next:

• Set up the Clinical One Configuration
  
• Load Clinical One metadata
  
• Compare DMW and Clinical One Metadata
  You can compare the metadata—table and column structure—in any DMW Clinical One model lifecycle stage to any Clinical One lifecycle database for the same study.