top of page

Terminology Build

What Does It Do?

The Metadata tool provides a rapid utility to allow you to quickly build a full list of CDISC/NCI controlled terms and code lists for any study in seconds.

What Do You Need?

  • Any version of the CDISC/NCI Controlled Terminology document.

  • A blank Microsoft Excel file.

Guide

  • Open Microsoft Excel.

  • Navigate to the Metadata ribbon.

  • ​Locate the Terminology section of the ribbon.

Ribbon - Terminology.png

  • Click the Build button in the Terminology section.

  • A prompt will appear.

Terminology CDISC Versions Window

  • Select either SDTM or ADaM from the Category drop down list and then the controlled terminology versions will auto-populate.

  • *TIP* if the user is unsure which Category to select, simply select ADaM and this will ensure the search process checks both the SDTM and ADaM controlled terminology documents.

  • Click OK to continue, and the range selection window will appear.

  • Here the user defines the Domain, e.g., DS.

  • Then the Variable Range and Code List Range is selected.

  • The Variable Range contains all the variable names, e.g., STUDYID, USUBJID, etc.

  • The Code List Range contains the code list names, e.g., DOMAIN, NY, NCOMPLT, etc.

  • Once these three components are defined the user can click OK to continue.

  • After some time the code list selection window will appear.

  • The process loops through each variable in the defined variable range, and for any variables which are controlled by a code list, i.e., the code list range is populated. The process looks up the defined code list within the CDSIC/NCI controlled terminology document, and if found returns the code list values.

  • IMPORTANT: When a code list was not found a prompt appears informing the user.

  • Here the user can select one, select all, or skip to the next variable.

  • Once the process is complete the user can choose to manually copy the tables, in full or in part. 

  • Alternatively the user can Export the contents directly into an Excel workbook, like so.

  • To Export the code list information to an existing Excel template, click the Export button under the variable level table.

  • A prompt will appear.

Terminology Export Window

  • Assuming the user wants to export the code lists to an existing worksheet, the Existing Worksheet option as selected.

  • Then the existing worksheet can be selected from the Existing Worksheet drop down list which, will be the name of the existing worksheet the code list information will be exported to, e.g., CT.

  • IMPORTANT: The Worksheet Name field has no impact here and is disabled when the Existing Worksheet option is selected and is disabled.

  • Click to OK to begin the export process. 

  • Once exported, navigate to the chosen worksheet to see the code lists.

Terminology Exported Example

  • The chosen code list has been successfully exported onto the worksheet.

  • The process can be re-run again if required with no impact to previously exported code lists.

bottom of page