Map columns to data to be derived from TMS

For details on mapping columns to data to be derived from TMS, see this video:

Prerequisites: The study must be assigned to a TMS dictionary domain and your administrator must have defined a TMS Set for the dictionary.

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

2. Select a target model and click Check Out.

3. Select the target table that contains data you want to code in TMS.

4. Click the TMS tab, then click the Add icon. The Add TMS Column Association window appears.

5. Select the TMS Set to use. The system displays the TMS Set description, base dictionary, and primary column name, which is the name of the dictionary level defined as the coding level in your TMS installation.

6. Select the primary column. The system displays all VARCHAR2 data type columns in the clinical data model table. Select the one whose value you want to have coded in TMS.

   The system displays the derived columns defined for the selected TMS Set.

7. In the Column Name field, select the table column to map to each TMS Set derived column that you need in your study. You do not need to map all the TMS Set columns.

   If you have not yet added columns to the table to receive the derived data from TMS, click OK, then add the columns in the Columns tab. Then click the Edit icon in the TMS tab and map the new columns to the TMS Set derived columns.

8. Click OK.

Back to Set up clinical data models