Overview

Data mapping is an early step in the requirements gathering and development process of dashboard projects. The attached data mapping template is an Excel file to assist with mapping from source data systems into the Ed-Fi Dashboards.

The data mapping template contains a listing of elements in the Ed-Fi data model and whether the element is required or optional for the Ed-Fi Dashboards. The template includes data to support filtering by Ed-Fi Standard Interchange Schema XSD files.

The Ed-Fi Dashboards can be loaded from a Data Standard v1.2 source or a Data Standard v2.0 source. A separate Excel file is available for each version.

Notes:

• Some data types are listed with a question mark (e.g., int32?, dateTime?). This indicates that the element/field is nullable.
• In the v2.0 template file, a yellow highlight indicates a difference from v1.2.