NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After Importing

The results after importing are displayed one row per Value Meaningentry in the template. All VM Match user results are kept in one database table, and without filtering results, they are all displayed in the same grid. So, after selecting "Go to Data Manager" enter " or select "VM Match" again and filter for your batch name and , then click "Apply Filter" to see just your results

To see the details of each row of matches, select "Edit" and select "VM Matched Results".

Use Cases

This feature can be used to match any terms to Concepts by selecting the "Concepts Only" command, including finding concepts for a new DEC.text strings entered into the template to:

  1. Existing caDSR Value Meanings (VM). caDSR VMs are already associated with Concepts
  2. Concepts from NCI Thesaurus or selected external terminologies

By selecting the appropriate command, end user can control the breadth of the matching algorithm.

Terms can be the Permissible Value if the value is text, or the name a variable. 

"User Tips" Column

The User Tips column is used by the system instead of the VM Nameuser supplied name. Sometimes the VM Name string from your form or data is not very representative of the its meaning, or consists of too many terms. If a "User Tip" is entered it is used instead of the VM Nameimported name. User Tips can be entered through the front end , or starting in Sprint 47, can be entered into the Template for each row and imported. entered into the Template for each row and imported. 

Matched Results

The system indicates how many matches were found, why each row was considered a match, and the type of match that was run. Once a match is selected, it is displayed in the table of summary results by row.

Algorithm

Punctuation and spaces are removed. The "Rule Description" explains why each match was selected. The algorithm does not currently account for spelling errors.

"Run Match" VM Header Command

Select the rows to run the match algorithm against and select the "RUN MATCH" Command. Punctuation and spaces are removed. This command will try to find Exact or Like Matches using the caDSR Value Meaning (VM) preferred name for existing VMs, Concept Preferred name and Synonyms.

Click "VM Matched Results" to review recommended matches. If you do not find a desired match, select "Run VM Match Unrestricted".

"Run Match - VM Only" VM Header Command

This match searches only for existing VM names that matchare good matches to either the name of synonyms. It includes exact matches to the name or alternate VM names.

"Run VM - Match Unrestricted" 

VM Header Command

This match searches VM Names does not stop after finding exact matches. It extends the search to emphasize matches on the longest term in addition to more extensive "like" matches. 

"Run Match - Concepts Only" VM Header Command

This match searches only for Concepts by name and synonyms.

"Run Match Concepts Only - Unrestricted" VM Header Command

This match searches only for Concepts by name and synonyms the longest term in addition to more extensive matches. 

"Run Match - Terminology"

This matches allows the user to select a specific terminology to search for Concepts by name, synonyms or Concept Code.

"VM Matched Results"

If there is only one exact match, the system will automatically associate the matched result with the imported VM Name.

If there are multiple matches the user can select a row from "VM Matched Results" and select the "Set Preferred" command.

Multiple Concepts can be selected one at a time to post coordinate concepts. The system will appended the concept to the preferred concept string and generate the resulting name in the order the concepts are selected.  This can be viewed by selecting the Node with the Concept Name to view the selected items. The concepts and be reordered manually, but be sure to reorder the concept names, or clear the results, "Save" and then select concepts again from the matched results. 

Advancing through the imported VMs

When on the "VM Match Header" you can advance to the next VM in your imported file by using the "Rows x of xxx" arrows.

VM Match Header.

Column Order

The main column in VM Match is the VM Name. The processing is designed to find matching concepts based on the name and insert the Concept Name and Concept Code into the table next to the VM NAME unless "User Tips" are entered. This order of the columns makes it easier to populate the PV/VM Template using cut and paste. 

Exporting results

Use the "Delivery Options" command to export the VM Match results into and Excel file. This simplifies creating the list of PV/VMs for PV/VM Import to populate and existing Value Domain.

...