Skip Headers
Oracle® Thesaurus Management System User's Guide
Release 4.6.2

Part Number E18827-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

What's New

This section describes the new features and enhancements included in recent releases of Oracle Thesaurus Management System (TMS). All changes are included in the current release.

New Features in Release 4.6.2

Release 4.6.2 includes upgrades to the technology stack, leveraging more up-to-date capabilities and tools and alleviating end-of-support windows for legacy components. The technology stack is the same as for Oracle Clinical 4.6.2, facilitating integration between the two systems.

New Features in Release 4.6.1

Release 4.6.1 includes the following new features:

Classification to Nonapproved Dictionary Terms Can Be Allowed

You can allow classifying terms to nonapproved dictionary terms in selected domains. For example, in a domain used for an active study you can prevent classification to nonapproved terms, but in a domain used for post-marketing surveillance, you can allow classification to nonapproved terms to prevent unnecessary reclassification after a dictionary upgrade. Global VTAs cannot be linked to nonapproved dictionary terms.

This change affects many features and is documented in each relevant section:

Filtering and Multirecord Selection for Task Allocation by Term

Task Allocation now includes a Filter button and standard TMS filter functionality to limit the terms displayed. In addition, you can select multiple terms at the same time using either Shift+Click or Ctrl+Click to assign the terms. See "Using Manual Allocation by Term".

New Informative Note Attribute for Use in RDC Special Listings

The Oracle Clinical Remote Data Capture (RDC) Option Release 4.5.3 and above has a Special Listings feature that displays concomitant medications and adverse events for patients. This feature is available only when TMS is integrated with Oracle Clinical and displays parent questions mapped to TMS dictionaries with the question responses to all other questions in the parent question's question group that are defined as nonderived and displayed.

By default, the system displays the TMS dictionary name in the action drop-down list on the RDC Home page, Casebooks page, and elsewhere. You can change this to the text of your choice by defining a new type of Informative Note called RDC Action Text for each dictionary. The system substitutes the text you supply in the Value field of the Informative Note for the dictionary name; see "RDC Action Informative Notes".

See also "Planning Question Groups and DCMs for RDC Special Listings".

New Features in Release 4.6

Release 4.6 includes the following new features described in the following sections:

In addition, see "Documentation Changes" for more information.

Internal Actions

Until Release 4.6, all Actions were external. They were sent to an external source data system to convey information and request an Action on the part of an external system user. Release 4.6 introduces Internal Actions that are used inside TMS. They serve two purposes:

In addition, external Actions have been renamed: Conditional Actions are now called Answerable Actions, Never Expire Actions are now called Unanswerable Actions, and Single Term Actions are now called Discrepancy Comments.

The new windows that support this feature are Approve Action Assignments (in the Omission Management menu) and Maintain Action Assignments (in the VTA Maintenance menu).

For further information see "Defining and Using Actions" and "Approving Action Assignments".

Task Allocation and Activity Lists

Beginning in Release 4.6, you can explicitly allocate tasks to specific users, including classifying omissions and approving unapproved VTAs and Actions. You can use the following methods:

Using the Filter pop-up, you can create activity lists of the omissions, unapproved VTAs, or unapproved Actions that are assigned to you and use these lists as your daily "To Do" list. If you have the necessary privileges, you can create activity lists for other users to track their progress.

Task allocation is optional. You can use activity lists to save lists of tasks that satisfy filter criteria you set, even if you are not using task allocation.

There is a new menu item called Task Allocation that includes four new windows and a new report, respectively: Maintain User Task Allocation Pools, Task Allocation by Term, Task Allocation by Quantity, Maintain Direct Allocation Error Logs, and Unfulfillable Assignments. Two new windows under Omission Management support activity lists: Activity List and Maintain Activities.

See Chapter 9, "Allocating Tasks to TMS Users" and "Setting Filters and Creating Activity Lists", "Using Activity Lists", and "Maintaining Activity Lists" for more information.

Term Status History

Release 4.6 introduces new term statuses and sub-statuses that track a term's process throughout its life cycle. You can see a term's current status and sub-status in the following windows:

You can bring up a display of a term's complete status history by clicking the Status/Notes button from most of the windows listed above. In the non-browser windows you can add a note when you change a term's status. (See Chapter 10, "Omission Management" and the sections on each of the windows above.)

Data Access Groups

You can create Data Access Groups (DAGs), which allow you to selectively restrict the data users can see. As before, database roles determine which windows a user can access. DAG assignments dictate the data users can see in those windows and whether they can make changes to the data.

You can also designate a user as a superuser. Superusers can see and operate on all data and cannot belong to a DAG (the pre-4.6 behavior).

When you define a DAG you can make the following specifications:

You define a DAG and then assign users to it. A single user can be assigned to multiple DAGs. The user then has access to the sum of data allowed by all his or her DAG assignments.

There is a new menu item called Security that supports DAGs. It includes the original, now modified, Define Users window as well as new windows Define Security Columns and Maintain DAGs. It also includes a new report, DAG and Setting Inconsistencies and a new job, Create/Drop EXT_VALUE Indexes.

See "Using Data Access Groups (DAGs) for Security".

Advanced Term History and Dictionary Release Labeling

Release 4.6 introduces dictionary Release Labeling and a new type of named relation called Release Label (RL). When you define a dictionary, you must now specify a label prefix for the dictionary. Each time you run Activation, TMS applies a Release Label to the successfully activated terms and relations in the Activation Group. The label consists of the prefix you define plus a build number that represents the number of times Activation has been run on the dictionary. For example, if you defined a label prefix of 3.0. for WHO-Drug 3.0, the system would label the first Activation Group 3.0.1; the system would label the second Activation Group 3.0.2.

When you upgrade to Release 4.6 from an earlier version of TMS, the upgrade process looks for a dictionary version-type Informative Note for each dictionary you have already defined and, if there is one, populates the label prefix with that value. For each existing virtual dictionary, the upgrade process creates a Release Label that consists of the prefix (if any) and an appended number: either 1 or, if there are more than one virtual dictionaries with no dictionary version Informative Note value (or the same value) a unique number among those virtual dictionaries. The upgrade process inserts a period/full stop (.) between the prefix and the appended number if the prefix does not already include one.

You can use named relations of type Release Label to record the relationship between a term in one dictionary or dictionary version to another, for complex changes such as term merging or term splitting that TMS cannot maintain automatically. For example, if a new release of MedDRA splits Term A into Term A and Term B, you can create a named relation of type Release Label between Term A in the older dictionary version and Term B in the newer dictionary version.

You can view term history, including Release Label named relations, in the HTML Browser. Do a search in the Terminology tab and then click the term to see the Term Details window with a Related Release Label section.

One new window supports this feature: Release Label Authoring under the Repository Maintenance menu.

See "Defining a Dictionary" for information on defining a label prefix. See "Defining Named Relations" for information on defining named relations of type Release Label. See "Using the Release Label Authoring Window" for information on creating a Release Label named relation between two terms.

Dictionary Upgrade Analysis

In Release 4.6 you can analyze the impact that upgrading to a new version of a dictionary will have on your existing VTAs and omissions before activating it. A new job performs many of the changes you will need to make. Several reports allow you to see the changes, and a new form allows you to see changes and to make changes manually to terms and relations, including VTAs, while they are still in the predictionary tables to avoid problems during and after Activation.

There is a new menu item, Dictionary Upgrade, with a new window and several new reports and jobs.

See Chapter 8, "Upgrading to a New Dictionary Version" for more information.

Filter Dictionaries: Support for MedDRA SMQs

Release 4.6 supports MedDRA Standardized MedDRA Queries (SMQs) with a new dictionary type called a filter dictionary and a new Informative Note type called algorithm Informative Note. In the HTML Browser you can search for source terms using MedDRA SMQs and retrieve external system information about the source terms.

The HTML Browser includes several new screens to support this feature.

See "Filter Dictionaries" and "Searching for Terms Using Filter Dictionaries" for more information.

Disconnected System Integration (DSI) Enhancements

Release 4.6 introduces the following DSI enhancements. See "Using TMS with Disconnected Systems" for further information.

Note:

The XML schemas required for both sponsor and source sites have changed to support these enhancements. See Appendix B, "Disconnected System Integration XML Files."

For more information, see "Using TMS with Disconnected Systems".

New Reports and New Appearance for All Reports

Release 4.6 uses Oracle XML Publisher to format reports. All reports have a new appearance. In addition, you can customize the template to change the appearance of reports if you want to; see "Customizing Report Templates" for more information.

Release 4.6 includes the following new reports:

New HTML Browser Functionality

Release 4.6 expands HTML Browser functionality to complement several new features:

See "Searching for Terms Using Filter Dictionaries" and "Viewing VTA and Omission Status Information" for more information.

In addition, it is now possible to search for omissions as well as classified verbatim terms in the HTML Browser. You perform this action from a new Verbatim Term Status tab. See "Performing a Simple Verbatim Term Status Search" for more information.

Minor Enhancements

Release 4.6 includes the following minor enhancements.

Applying Informative Notes to Omissions

In the Classify VT Omissions window, you can now apply Informative Notes to unique occurrences of verbatim term omissions (VTOs) in a domain/dictionary combination. See "Using the Status/Notes Pop-up Window" for more information.

Restricting Informative Note Attributes to Specific Dictionaries

When you define new Informative Note attributes you must now specify one or more dictionaries within which they can be used. Then when you add an Informative Note to a term, relation, or dictionary, TMS allows you to use only Informative Note attributes that have been specified for use with the appropriate dictionary.

When you upgrade to Release 4.6 from an earlier version, the upgrade process populates the new "Applies To" field for your existing Informative Note attributes with the dictionaries with which they are currently used. If you want to use an Informative Note attribute with additional dictionaries, use the Define Dictionary Informative Note Attributes window. See "Defining Informative Note Attributes" for more information.

Creating Users for Loading Dictionaries and for Administration Tasks

Due to changes required to implement Data Access Groups, you no longer create a user during dictionary loading for the purpose of loading the dictionary. You can now grant dictionary loading privileges to any user through the TMS Define User window by setting the new Load User check box to Yes. See "Defining Users" for more information.

The tmsadduser.sql script now creates a user with OPA_ADMIN privileges. This user has access to the Define Users window in the UI and can create all other user accounts.

User Profile Setting for Requiring Approval for VTAs and Actions

A new user profile setting allows you to specify users who can create approved VTAs and Actions even in dictionary/domain combinations where approval is required. See "TMS_PROCESS_DICTIONARY" for more information.

Declassifying Verbatim Terms in the Approve VTAs Window

Users with Reclassify or Classify privileges can now declassify verbatim terms in the Approve VTAs window. As in the Classify VT Omissions window, users with Classify privileges have a configurable period of time in which they can change their own classifications. Users with Reclassify privileges have no time limit. See "Understanding the Approve VTAs Window" for more information.

Displaying a Meaningful Value for X Areas

You can write a function to replace the X Area ID with a meaningful value for X Areas in reports and on screen. For Oracle Clinical, the X Area is a study and TMS now displays the study name instead of the X Area ID. If you prefer, you can write a function to display a different value for Oracle Clinical X Areas. See "Defining the External System in TMS" for more information.

External Value Length Increased to 500 Characters

The user-defined external values (and those predefined for Oracle Clinical) have been increased in size so that you can store values of up to 500 characters. The previous limit was 30 characters.

Users with Browse-Only Privileges Do Not See the Source Data Icon in the HTML Browser

Users with browse-only privileges now do not see the Source Data icon.

Documentation Changes

We documented the new features and made the following changes to the Oracle Thesaurus Management System User's Guide:

New Features in Release 4.5.2

The enhancements included in Release 4.5.2 relate primarily to integration with Oracle Clinical:

In addition, the Define Users window has been moved to a new location: the newly created Security menu. Therefore the TMS_DEFINE_PRIV privilege is no longer required to access the Define Users window; only OPA_ADMIN is required. The documentation in Chapter 3, "Administration" has been updated accordingly.

Deriving Data from Two Dictionaries

To allow deriving data from two dictionaries for a single term collected in Oracle Clinical, Release 4.5.2 makes two changes:

This functionality may also be useful in other circumstances. See "Using a Derived Question as a Parent Question".

Parameterizing Batch Validation Failure

Until Release 4.6, if Oracle Clinical Batch Validation encountered a serious problem during the TMS processing portion, the whole Batch Validation process failed. You can now choose whether or not you want this to happen by setting a new reference codelist value in Oracle Clinical. Also, if the errors encountered during TMS processing are not serious, Batch Validation will not fail, but will display a warning.

For more information, see "OCL_STATE".

Running Only the TMS Portion of Batch Validation

A new job is available in Oracle Clinical for running only the TMS portion of Batch Validation. See "Running Only the TMS Portion of Batch Validation".

New Installer

The installation and migration of Release 4.5.2 requires a new Installer, which handles a fresh installation as well as migration from previous versions 4.5.x and above.

New Features in Release 4.5.1

Release 4.5.1 included the following new features:

Disconnected System Integration

The Disconnected System Integration (DSI) feature provides a customized XML-based batch data load process that enables you to use TMS as a central dictionary classification tool for systems located remotely and operated by different businesses or research organizations.

DSI is designed specifically to allow a pharmaceutical company sponsoring a clinical trial that is being conducted by multiple contract research organizations (CROs), to use TMS as a central classification tool for terminology quality control. CROs send their source data to the sponsor, with contextual information (such as patient ID and document number) and preliminary classifications. The import process at the sponsor site compares the CRO's classifications to the sponsor's and enters data in the sponsor database and/or creates warnings or errors associated with faulty data. When the sponsor sends the data back to the CRO, the CRO's import process overwrites CRO classifications with those of the sponsor, if there are conflicts, and passes on any Actions created at the sponsor site for particular terms.

The sponsor instance stores all CRO source terms and contextual information, and runs TMS Synchronization on CRO data. However, the sponsor instance does not have a UI drill-down capability for CRO data, and, if the sponsor is using Oracle Clinical, OC Batch Validation does not run on CRO data.

The sponsor must use TMS. The CRO must use either TMS or another dictionary coding system that is capable of processing XML files in the required DSI structure. The external source data system feeding data into TMS can be Oracle Clinical, the Oracle Adverse Events Reporting System, or a third-party system.

For more information, see "Using TMS with Disconnected Systems".

Note:

The Disconnected System Integration feature does not support the UTF8 character set.

Fixing Classification Mistakes

Until Release 4.5.1, when a TMS user made a mistake classifying a verbatim term, he or she required reclassification privileges to fix the problem. In Release 4.5.1, the user has a certain number of hours in which to fix the mistake, even without reclassification privileges.

There is a new short value in the TMS_CONFIGURATION reference codelist called MTRECCLASSHOUR. The long value sets the number of hours after the initial classification during which users can change the classification.

During that time, the user has access to the Reclassify Verbatim Terms window, but the window displays only VTAs created by that user. The user will be able to change only those classifications that he or she created within the time limit set in the reference codelist.

This information is included in "Classify the Verbatim Term" and in "Reclassifying and Declassifying Verbatim Terms".

Deleting Domain Elements

Until Release 4.5.1, you could not delete a TMS domain element in Oracle Clinical if any classifications or omissions existed for that domain/dictionary combination in any study. Now you can delete a project or study's domain element if no classifications or omissions exist for that particular project or study.

This information is included in "Linking an Oracle Clinical Study to TMS".

New Symmetric Replication Process

Release 4.5.1 includes a new model for symmetric replication. In the original multi-master approach, multiple instances replicated information to each other. In the new approach, which uses materialized views, slave instances send new data to a single master instance first, and then data on the master is replicated to all sites. The new approach prevents the No Data Found errors that sometimes occurred in the old model.

This change requires extra steps during the installation of Release 4.5.1, but thereafter the difference in approach is transparent to the user.

The new symmetric replication model was introduced in Release 4.0.6.12 and was patched in 4.0.6.14. Therefore the installation process is different if you are upgrading from either of those versions of TMS than if you are upgrading from any other version (Release 4.5 did not include the new symmetric replication model). The installation steps for each type of upgrade are included in the release notes for Release 4.5.1.