Repository Maintenance Reports

The Repository Maintenance Reports are:

Preliminary Repository Report

In an Activation process, some terms and relations in the predictionary data fail activation or are not validated. The Preliminary Repository Report lists these terms and relations within a specified Activation Group. Specify the Activation Data Scope to view a set of predictionary data. To run this report, you must have maintenance privileges. The Preliminary Repository Report displays the following:

  • Errors Only: These are terms and relations that have failed activation or have not been validated via the Check option in the Activation process. The Errors list also includes terms and relations associated with Informative Notes that have not been activated and validated.

  • All: A list of terms and relations that have add, delete or update (DML) statements against them but do not get activated. Also, those terms and relations associated with Informative Notes that have DML statements but remain unactivated, are listed.

The Preliminary Repository Report displays data in four sections.

  • Pre-dictionary Contents: Displays term names sorted by Activation Group, Domain, Dictionary and Dictionary level. For each term, the report also lists DML statements and error message.

  • Pre-dictionary Relations: Displays relations sorted by Activation Group, Domain, Dictionary and Dictionary level. The report lists the source term and the reference term with their respective dictionary levels, the DML statement for the relation and the error message.

  • Dictionary Contents with Pre-dictionary Informative notes: Displays content similar to that in the Pre-dictionary Contents section.

  • Dictionary Relations with Pre-dictionary Informative Notes: Displays content similar to that in the Pre-dictionary Relations section.

The Preliminary Repository Report does not describe the Informative Notes in detail. To view the Notes, select the term or relation in the Repository Authoring window. Click on Informative Notes. The Maintain Informative Notes window displays information for the selected term.

To generate a Preliminary Repository Report:

  1. Select Repository maintenance in the navigator window.
  2. Select Preliminary Repository Report.
  3. Fill in the general report specifications. See Setting Parameters.
  4. Enter a value for Job Specific parameters:
    • Activation Group: Select an Activation Group from the list.

    • Activation Data Scope: Select the kind of data to be returned. The options are All and Errors Only.

    • Template: Select the template you want to use for this report. If your company has created a custom template, it appears in the list of values. The Oracle Template is the default template.

  5. Submit the job. See Running a Job.

Dictionary Version and Release Information Report

TMS creates a new dictionary version each time you do one or more of the following and run Activation:

  • add, modify, or delete a dictionary term

  • modify a dictionary relation

  • modify a cross-dictionary relation

  • modify a dictionary term Informative Note

For example, suppose your current dictionary version is MedDRA 9. When you add a new dictionary term and run Activation for the first time, a new build of the dictionary is created (build =1) and now the dictionary version is MedDRA 9.1.

Note:

A dictionary is assigned a version number which is the same as its Release Label Prefix. For every subsequent activation of the dictionary a build number is generated. This build number is appended to the Release Label Prefix to provide the Release Label.

In our example, MedDRA9.1, 9. is the Release Label Prefix and 1 is the build number. The Release Label is 9.1.

The Dictionary Version and Release Information Report tracks dictionary versions. The unique identifier for each version is the date and time stamp. If you have associated a virtual dictionary with your dictionary version, then it is also listed.

The Dictionary Version and Release Information Report displays the following data:

  • Release Labels with cut-off dates

  • Virtual Dictionaries, if any

The report identifies the name of the active dictionary that it was run for. It then lists the following information in a row:

  • Dictionary Name: The full name of the active dictionary.

  • Dictionary Short Name: The short name of the active dictionary as entered in the Define Dictionaries form.

  • Release Label Prefix: This is the label prefix of the dictionary as entered in the Define Dictionaries form. See Defining a Dictionary.

    For each build of the active dictionary, the report gives the following information:

  • Release Label: This column shows the Release Label of the dictionary version.

  • Cut-off Date: This column lists the cut-off date and time for each release.

  • Virtual Dictionary Information: In these columns you can see information related to any virtual dictionaries associated with the release.

    • Dictionary Name: This is the virtual dictionary name.

    • Short Name: This is the short name for the virtual dictionary as entered in the Define Dictionaries form.

To generate a Dictionary Version and Release Information Report:

  1. Select the Dictionary Version and Release Information Report from the Repository Maintenance menu.
  2. Fill in the general report specifications. See Setting Parameters.
  3. Enter a value for each Job Specific parameter:
    • Active Dictionaries: Select the dictionary for which you want to run this report.

    • Template: Select the template for the report. If your company has created a custom template, it appears in the list of values. The Oracle template is the default.

  4. Submit the job. See Running a Job.