User Guide - Mapping Review Report

The Mapping Review Report is the main output of MappingEDU. It produces a document that's easily sharable with others in your organization, and includes information that allows technologists responsible for implementing data transfers and ETL to begin their work. This section contains conceptual and how-to information about the Mapping Review Report.

What is the Mapping Review Report?

The Mapping Review Report is an Excel file output from MappingEDU, showing the mapping business logic between two standards.

The Mapping Review Report contains:

• The definitions for the Source Data Standard (on the Element List tab of the report).
• The business logic/element mappings (on the Element Mappings tab).
• The definitions of any enumerations in the system (on the Enumeration List tab).
• The business logic/item-level mappings for enumerations (on the Enumeration Mappings tab).

Who is the Audience for the Mapping Review Report?

The primary audience for the Mapping Review Report are technologists, ETL developers, and system integrators who will actually implement the data exchange between the mapped systems. The MappingEDU report may look familiar to those who have previous experience with large-scale mapping projects: MappingEDU basically outputs a report that many users will have built by hand directly in Excel.

A secondary audience are SMEs or other reviewers who may not have access to MappingEDU, or simply prefer to review information in a familiar, tabular format.

How does the Data Mapping Report Get Generated? 

Generating the Mapping Review Report is easy: click on the Reports tab for your project, then click on the Create Report button:

The following screen will appear, allowing you to customize your report in all sorts of ways:

Tips & Tricks

Here are a few items of note regarding the Mapping Review Report:

• You can output custom Data Standard fields to your report. The Mapping Project Report download screen allows you to customize the report in a number of ways. The most requested feature is to output custom fields in the report – simply select the custom fields from the Columns Not in List. (There are so many customization options, this may not be immediately apparent.)

• As noted elsewhere, you can output this report any time, even when a project is not complete. Many users find the Excel version useful for status meetings during a long project lifecycle.