---
description: >-
  This page details some key things to note when mapping mandatory Adverse
  Events data and an example video.
---

# Mandatory data mappings

In the Adverse Events (AEs) mappings table what is represented in the Source data column field from the source data file and the [Aggregation functions](../../../data-loading/data-loading-overview/general-overview#mapping-a-specific-data-type) play a key role in successful loading of data

### AE Mapping table

When mapping source data columns to the mapping table ensuring the fields are populated with the correct data and that the data is in the format required for the mapping field - text, numeric, date or time is important

{% embed url="https://github.com/digital-ECMT/ACUITY_docs/blob/main/AE%20Data%20Loading%20Docs/Adverse%20Event%20Table_v1.0.docx" %}
**Adverse Events Mapping Table**
{% endembed %}

**Data fields requiring dates** - from the _aggregation functio&#x6E;_&#x73; select the date format that is represented in the source data file

**Maximum severity grade** for this field the Source data column _in the mappings table_ will be populated with multiple column names from the source data file. &#x20;

All the columns in the source data file containing AE grade changes must be mapped, including the column which contains the starting severity grade

Note: when adding multiple column names from a source data file in the Source data column each column name is followed by a comma and space - example: AE\_SSG, AESGC1, AESGC2,&#x20;

_**Aggregation functions: Max value**_ should be selected for the data field Maximum severity grade.  This will allow the system to identify the maximum severity grade of an AE for a particular subject &#x20;

Saving the mappings results in the maximum severity grade field being highlighted pink - this is a prompt to check this field is correctly populated as it's populated with several source data file column names.  Note: the field is highlighted pink even if the mappings are correct

**TRAINING VIDEO:** This video walks through an example of mapping mandatory AE data, highlighting the areas above

{% embed url="https://www.youtube.com/watch?index=1&list=PLPVGbGwDUYYS4QPs2cVdL5dVexu0sJzpQ&v=TwkVfTvaAfQ" %}
**Adverse Events: Mandatory Data Mappings**
{% endembed %}
