Learn how to configure your Vault to enable the MedDRA Hierarchy Updates for CMQ and Vault Reporting.

About the Feature

Support for the MedDRA Hierarchy Updates for CMQ and Vault Reporting were added to Vault Safety in 22R1. This feature allows users to configure CMQs (Custom MedDRA Queries) with higher-level MedDRA terms for enhanced Vault Reporting. New MedDRA Hierarchy and MedDRA query actions are also available in this release.

Manage the MedDRA Dictionary and Use MedDRA Queries provide more information about this feature.

23R1 Update: Automatic MedDRA Hierarchy Updates

As of Vault Safety version 23R1, when a new central MedDRA dictionary version is downloaded and activated, hierarchy changes are automatically reflected in your Vault. This includes hierarchy updates for CMQs and MedDRA Join records for Vault Reporting. Although updates are automated, the Update MedDRA Hierarchy user action is still available.

In addition, when the MedDRA dictionary version is updated, the full dictionary is now downloaded to your Vault, including localized terms. Therefore, the Download Full MedDRA Dictionary user action has been deprecated and is no longer available.

For more information, see Add the Update MedDRA Hierarchy Action.

Update the MedDRA Criteria Object

Update the Criteria VQL for the MedDRA Term field:

  1. Go to Admin > Configuration > Objects > MedDRA Criteria.
  2. Go to the Object Types tab.
  3. Select MedDRA Query Criteria from the table heading.
  4. Select MedDRA Term.
  5. Update the Criteria VQL field:
    (meddra_hierarchy__v = null AND pt_code__v != null AND primary_soc__v = true) OR
    ( meddra_hierarchy__v != null AND meddra_hierarchy__v = 'llt__v' AND primary_soc__v = true )
    OR ( meddra_hierarchy__v != null AND meddra_hierarchy__v != 'llt__v'
  6. Save the page.

meddra-term-criteria-vql

Update the MedDRA Object

Add fields to the MedDRA layout:

  1. Go to Admin > Configuration > Objects > MedDRA.
  2. In the Layouts tab, select the MedDRA Detail Page Layout.
  3. Add the following fields to the Details section:
    • SOC
    • HLGT
    • HLT
    • PT
    • MedDRA Hierarchy
  4. Save the page.

meddra-layout

Update the Dictionary Object

Add new MedDRA dictionary actions and enable them in your Vault.

Add the Update MedDRA Hierarchy Action

You must add the Update MedDRA Hierarchy action to the Dictionary object:

  1. Go to Admin > Configuration > Objects > Dictionary.
  2. In the Actions tab, select Create. A Create Action window appears.
  3. In the Create Action window, select Update MedDRA Hierarchy from the dropdown menu.
  4. On the Create Action page, select the Available in All Lifecycle States checkbox.
  5. Make sure the information on this page matches the following image:
    create-update-meddra-hierarchy-action
  6. Save the action. An Atomic Action Security Default window appears.
  7. Complete the Atomic Action Security Default window using the following image:
    meddra-hierarchy-actions-atomic-security

Enable the Update MedDRA Hierarchy Action

You must enable the Update MedDRA Hierarchy action in your Vault.

  1. Go to Admin > Configuration > Objects > Dictionary > Object Types.
  2. Select Action on the Object Types page and select the Update MedDRA Hierarchy checkbox in the MedDRA Dictionary column.
  3. Save the page.

Update the MedDRA Query Object

Add a new action to the MedDRA Query object:

  1. In the Admin Area, go to Configuration > Objects > MedDRA Query.
  2. In the Actions tab, select Create. A Create Action window appears.
  3. Select Copy MedDRA Query from the dropdown.
  4. Select the Available in All Lifecycle States checkbox.
  5. Make sure the information on this page matches the following image:
    create-copy-meddra-query-action
  6. Save the action. An Atomic Action Security Default window appears.
  7. Complete the Atomic Action Security Default window using the following image:
    meddra-query-actions-atomic-security

Grant Permissions

Grant the “Read” permission to the MedDRA Join object for the following Permission Sets:

  • Case Entry Actions
  • Case Intake Actions
  • Case Review Actions
  • Safety Operations Actions
  • Safety Writer
  • Submissions Actions
  • Case Distributions Actions
  1. In the Admin area, go to Users & Groups > Permission Sets.
  2. Select the respective permission set.
  3. Go to the Objects tab.
  4. Select the Read checkbox next to MedDRA Join.

Configure Report Setup for MedDRA Join

Follow the steps in this section to create new MedDRA Join multi-pass Report Types and Report Views.

Create a MedDRA Join Report Type

  1. In the Admin area, go to Configuration > Report Types.
  2. Select Create.
  3. On the Create Report Type page, complete the following information:
    • Label: MedDRA Join
    • Name: meddra_join__c
    • Description: MedDRA Join
    • Primary Reporting Object: MedDRA Join
      create-meddra-join-report-type

Create a MedDRA Join Report View

  1. In the Admin area, go to Configuration > Report Views.
  2. Select Create.
  3. On the Create Report View page, select MedDRA Join from the Report Type list.
  4. Enter MedDRA Join in the Name field.
  5. Select Continue.
  6. To save the report view, select Run, and then select Save.

Create a Multi-Pass Report Type

  1. In the Admin area, go to Configuration > Report Types.
  2. Select Create.
  3. On the Create Report Type page, complete the following information:
    • Label: SMQ/CMQ Search with Hierarchy
    • Name: smqcmq_search_with_hierarchy__c
    • Class: Multi-Pass
    • Report View: MedDRA Terms (SMQ/CMQ)
  4. To create the first relationship, select Add Relationship under the MedDRA Terms (SMQ/CMQ) Report View. An Add Relationship window appears.
  5. Complete the information using the following image:
    smqcmq-search-relationship1
  6. To create the second relationship, select Add Relationship under the MedDRA Join Report View. An Add Relationship window appears.
  7. Complete the information using the following image:
    smqcmq-search-relationship2
  8. Save the page.

smqcmq-search-report-type

Configure Reports in Vault Safety

The following sections reference the user side of Vault Safety. Go to Analytics > Reports to configure MedDRA query reports and delete existing MedDRA query reports in Vault Safety template.

You must configure new SMQ/CMQ reports in order to include CMQs with non-LLT MedDRA terms in the search. We recommend deleting the existing MedDRA Query reports in template to avoid confusion.

Delete MedDRA Query Reports in Template

The following image shows the MedDRA Query reports that already exist in your Vault:

smqcmq-deleted-reports

Follow these steps to delete the above reports:

  1. Select menu button next to the report.
  2. Select Delete.

Create MedDRA SMQ/CMQ Reports

Use the instructions below to create the following reports:

  • SMQ/CMQ Search by Product using Root Query
  • SMQ/CMQ Search by Product across Multiple Queries
  • SMQ/CMQ Search by Study using Root Query
  • SMQ/CMQ Search by Study across Multiple Queries
  1. On the Analytics > Reports page, select Create.
  2. Select MedDRA Criteria > SMQ/CMQ Search with Hierarchy.
  3. Use this table to create the 4 reports.
  4. Save the page.

smqcmq-product-root-query-report smqcmq-product-multiple-queries-report smqcmq-study-root-query-report smqcmq-study-multiple-queries-report

Name Filters Edit Columns
SMQ/CMQ Search by Product using Root Query
Field Condition Prompt
Case > Organization equals Yes
Case > Product equals Yes
MedDRA Query > Root Query equals Yes
MedDRA Criteria > Scope in Yes
  • Case > Name
  • Case > Seriousness
  • Case > Expectedness
  • Case Adverse Event > Event (LLT)
  • MedDRA Query > Name
  • MedDRA > Term (Code)
SMQ/CMQ Search by Product across Multiple Queries
Field Condition Prompt
Case > Organization equals Yes
Case > Product equals Yes
MedDRA Criteria > MedDRA Query in Yes
MedDRA Criteria > Scope in Yes
  • Case > Name
  • Case > Seriousness
  • Case > Expectedness
  • Case Adverse Event > Event (LLT)
  • MedDRA Query > Name
  • MedDRA > Term (Code)
SMQ/CMQ Search by Study using Root Query
Field Condition Prompt
Case > Organization equals Yes
Case > Study equals Yes
MedDRA Query > Root Query equals Yes
MedDRA Criteria > Scope in Yes
  • Case > Name
  • Case > Seriousness
  • Case > Expectedness
  • Case Adverse Event > Event (LLT)
  • MedDRA Query > Name
  • MedDRA > Term (Code)
SMQ/CMQ Search by Study across Multiple Queries
Field Condition Prompt
Case > Organization equals Yes
Case > Study equals Yes
MedDRA Criteria > MedDRA Query in Yes
MedDRA Criteria > Scope in Yes
  • Case > Name
  • Case > Seriousness
  • Case > Expectedness
  • Case Adverse Event > Event (LLT)
  • MedDRA Query > Name
  • MedDRA > Term (Code)