Updates Controlled Coded Terminologies

Updates Overview 
Updates to coded terminology dictionaries can be applied to a single or between two dictionaries.  This update is accessible from the main screen as shown here:

The four main tasks performed by the update tools include:

There are two types of dictionaries that can be updated from the update screen.  The controlled coded terminology is selected in this example as shown here:

Edit 
Coded values and the associated decoded values for any set of coded terminologies can be edited and updated.  This is accomplished by selecting the coded name and clicking on the edit button.  This will present the edit dictionary screen as shown here:



This will list all the coded and associated decoded terms for the selected dictionary.  You can perform the following tasks within the edit screen:

  • Delete Terms - You can select one or more terms on the list and then click on the "Delete" button.  After confirmation, it will remove the selected terms.
  • Add Terms - You need to type in new unique values in the two text entries below the coded value and decoded value list and then click on the Add button.  This will insert the value into the current dictionary.
  • Update Existing Terms - A terms needs to be first selected.  The original text will then be shown in the two text entries below the lists.  Apply updates to the entries and click on the update button.  

Delete 
Dictionaries contain many sets of coded and decoded terms.  Each set is grouped together and identified through a single name which is used as a unique identifier.  This is referred to as the "Coded Name".  You can choose to delete the set of coded values and decoded values associated with the identified coded name by selecting on the coded name and clicking on the "Delete" button.

A confirmation is presented before the deletion is actually applied.  Once applied, the list of coded and decoded terms will no longer be available through this dictionary.

Add 
Sets of coded terms can be added from a source dictionary to a destination dictionary.  You can apply this by selecting one or more source sets of coded terminologies through the "Coded Name" list.  You would then select the update type of "Add" as shown here:

You would then click on the OK button to add the selected set of coded terms from the source to the destination dictionary.

Reconcile
Sets of coded terms which are stored in different dictionaries needs to be synchronized.  In this case, if the sets of coded and decoded names are different, there will be a reconciliation.  This can be applied by first selecting one coded name from the source dictionary and then selecting another coded name from the destination.  The "Reconcile" type is selected and then the OK button is selected to have the reconcile screen displayed.

The reconciling process would then display those coded name sets that are mismatch for your reconcilliation.  The following example shows how the same coded name have different coded and decoded values.

The steps to performing the reconciliation as follows:

  1. Select Coded Name - A list of coded names is listed between the two dictionaries that are being reconciled.  You can select on the coded name from either the two dictionaries or the names listed below under the "Coded Name Differences".
  2. Source Destination - You would then determine between the two sets of source and destination, which is the correct set.  This can be selected through the radio buttons or by clicking on the list of coded or decoded values.
  3. Reconcile - By clicking on the reconcile button, you will apply the selected reconcile coded name.

Saving Update Macro Code
The same selections that is made in the graphical user interface can be expressed in macro named %tupdate.   You can select this through the "Save Code..." button.  The sample code that is generated would look like:

libname Thesqa "C:\Program Files\MetaXceed\ThesQA\data";

%tupdate(inthes = CDISC 3.1.1 Controlled Terminology,
              outthes = Sample Coded Terms,
              type = Add,
              dtype = code);

This same program can then be executed in batch mode to perform the same dictionary update.

Reviewing Update History
An audit trail of all dictionaries that was updated is kept in the history.  This history can be reviewed and searched through the "History" button.  A history view looks like the following:

The audit trail captures all data that has been updated including when and who has applied it.  This information can be searched by any field.  The search criteria in which you specified will be applied to all the fields captured in the audit history.

 
v
      ThesQA - Manage Controll Terminology, Meta-Xceed Inc.© 2009
Bookmark and Share