After you have created a Semantic Mapping, which is covered in detail in the Creating a Semantic Mapping topic, the software generates several recommendations for each mapping term. Once the process for making recommendations is complete, you'll need to review the semantic mapping. This topic explains how to do this. It also explains how you can edit the semantic mapping's name and description.
Prerequisites
- A semantic mapping must have already been created. This is covered in the Creating a Semantic Mapping topic.
- You must have Manage Data Mappings permission.
- The dataset that you want to use must have been imported into FCP.
- Optional: The project must have K-Anonymization set larger than 1 if stricter privacy protections are needed.
What You'll Learn
In this topic you will learn about:
- Accessing the Semantic Mapping page
- Reviewing Semantic Mapping Recommendations
- Verifying that Semantic Mapping Reviews Selections Have Been Applied
- Editing Semantic Mapping Name and Description Details
Accessing the Semantic Mapping Page
To access the Semantic Mapping page, complete the following steps.
- Select Data Mappings from the Main Menu. The Data Mappings page appears.
- Select the Semantic Mappings link. The Semantic Mappings page appears.
The table below defines each field in this page.
Field | Description |
Semantic Mapping Name | Name of the semantic mapping, such as "Procedure", "Condition", or "Drug." |
Description | Description of the mapping. |
Version | Version of the semantic mapping. This increments each time you make a change to the semantic mapping. |
Information Icon (on hover) | The information icon shows a summary of the semantic mapping information. Information shown includes the Dataset, Field, Target, Status, Mapping Coverage and Creator. It also includes the number of unique values and approved mappings, as well as the percentage of approved mappings and mapping coverage. |
Dataset | Name of the original dataset. |
Field | Name of the field to map in the original dataset. |
Target | Name of the Target Vocabulary to map to. For OMOP, it will also list the target Domain (e.g., OMOP Person). |
Status |
Status of the recommendation and approval part of the process. Statuses are:
|
Mapping Coverage | Percent of values mapped, calculated as the number of non-empty values that have an approved mapping divided by the number of non-empty values. If there are < K non-empty values, this percent will be omitted. K is set by the K-Anonymization param at the project level. |
Creator | Name of the person who created the mapping. |
Three-Dot Menu | The three-dot menu (also known as the “meatballs menu”) provides access to two other options: Edit Data Mapping and Delete Data Mapping. |
Reviewing Semantic Mapping Recommendations
Once the data mapping has been created and the software’s recommendations have been generated, you can review and approve them or edit them. To do this, complete the following steps.
- In the Data Mappings > Semantic Mappings page, click the entry for the semantic mapping that you created. The name of the page that appears corresponds to the semantic mapping name. In the example below, the name is "Procedures". A list of sources and the selected target values appears.
The following information appears for each field and recommendation entry.
- Frequency indicates how often the source value appears at the source data.
- Source Value refers to the term in the original dataset that requires mapping.
- Selected Target Value are the five recommendations of target value that are generated by the software. The top recommendation appears first. To see the others, select the drop down menu.
- Status: Indicates whether the recommendation has been approved. Move the slider to the right to approve the recommendation.
- Confidence is a number, expressed as a percentage, that represents the likelihood that the mapping recommendation is accurate. Higher percentages indicate a higher likelihood of accuracy than lower percentages. The confidence number reflects the likelihood for the selected target value.
You can also use the filters to view a subset of records, based on the values you specify.
Reviewing and Approving Semantic Mapping Recommendations
You can review and approve each semantic mapping entry individually or in bulk. Reviewing recommendations in bulk can be quite helpful if you have a lot of semantic mapping entries.
Reviewing Recommendations Individually
Before you review an entry, first look at its frequency, source value, and confidence value. The higher the value, the more confident the software is that the recommended mapping is correct. Do one or more of the following steps to review and select a recommendation.
- By default, the highest recommendation is shown in the Target Value field. Examine the recommendation; if you decide to approve it, move the status slider to the right. It turns green, and the status changes to Approved.
- To see other recommendations, click the arrow in the Target Value field and select another recommendation. Once you select the other recommendation, the status automatically changes to Approved.
- If you do not see the recommendation that you want, add your own by typing information into the field. The status automatically changes to Approved.
- Repeat this process for each remaining "In Review" entry.
Reviewing Recommendations in Bulk
Sometimes, you might have many semantic mapping recommendations that have a high confidence number. You might want to review the semantic mapping entries in bulk to streamline the process. After looking at the frequencies, source values, and confidence values to determine which recommendations you want to accept, complete the following steps.
- Use the filter to show only records with recommendations that are at a specific confidence level and above. For example, you might choose to filter at 97%, meaning that the software is 97% confident that the recommendations are accurate.
- Select the mapping entries by clicking the checkboxes at the beginning of each line. To select all entries on a page, click the checkbox next to Frequency near the top of the page.
- Click on "Approve All"
Reviewing Recommendations in Bulk (Alternative)
Additionally, you can also set a group of values back to in review or to a specific target value. For instance, you might like to select low frequency and low confidence values and set them to concept ID to 0. To do that, complete the following steps:
- Select all records with low frequency. (For example less than 5.)
- Select all records with low confidence. (For example less than 20.)
- Select Set Target Value.
- Set Concept ID to 0.
Verify that Semantic Mapping Selections Have Been Applied
The semantic mapping does not automatically propagate to existing datasets. To verify the Semantic Mapping was implemented, do one or more of the following.
- Look at the mapping coverage. It should change to show the updated percentage of rows in your dataset that have been mapped.
- Open the semantic mapping entry. Note whether the changes have been saved.
- Export the semantic map. For information on how to do this, see Exporting Semantic Mapping entries.
Editing Semantic Mapping Name and Description Details
To edit a semantic mapping name and description, complete the following steps.
- In the Data Mappings > Semantic Mapping page locate the semantic mapping you want to edit. Click the three-dot (meatball) menu at the end of the entry and select Edit Data Mapping.
- In the Edit Semantic Mapping popup window, enter the name and description.
- Select the Save button.
Related Topics