---
description: >-
  Accessing the data load report presents information on the last 3 loads. 
  Making a load selection from the list presents the different reports available
  for the selected data load.
---

# Data load reports

There are 4 different reports which can be presented:

1. **Exception** **report:** provides a user with list of exceptions that arose during ETL job execution. If the Exception report is not empty, then the upload status is **Failed**

![Example: Exception Report](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FlS1oLvuk21xq1bj84HqG%2Fimage.png?alt=media\&token=cacee758-d952-44b5-83d6-1cb6cb2cd46d)

2\. **Source data table report:** A set of upload statistics for every REACT data table for the given ETL run on the study data. Only includes 'mappable' data tables, these are tables which were mapped in the clinical study setup in Admin UI

![Example: Source Data Table Report](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2F3EetJfvIDJh9JhKitLxa%2Fimage.png?alt=media\&token=6f036653-4457-42c3-9795-98125b4cc926)

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FqDXZcJGkN6O7T3bGqJKi%2Fimage.png?alt=media\&token=6ca97be1-b44e-4074-9c98-052740d71be0) No errors

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FoAG8nb2b0nCSWVw4UnF2%2Fimage.png?alt=media\&token=a0fce784-8c77-4527-85bd-016cce05fc76) Error classification type 5&#x20;

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FQXdJ3IwPyuT47nlvgQyX%2Fimage.png?alt=media\&token=b62ec6ab-b851-47bc-93f3-cd9163bbd4a4)an error of type 5 where only one of either the number of unique subjects for the study in the source data table row is zero, or the number of unique subjects in the REACT data table row is zero

3\. **Source data field report:** a set of upload statistics for every REACT data field, based on whether the mapped data column in the raw data was successfully accessed and uploaded - Only includes fields that are mapped in the clinical study setup in Admin UI.

![Example: Source Data Field Report](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FGjjF8ltEqjHhPPHPPEC1%2Fimage.png?alt=media\&token=a40949a1-857b-498a-a557-46124b92daab)

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FEYSkCzI3eMzw4B6bodWu%2Fimage.png?alt=media\&token=57671a31-bcce-4360-ae78-d2de3ad79de0)No errors

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FmLuyNFMg8KBoQibcpzSJ%2Fimage.png?alt=media\&token=31f11092-20e0-4f02-9493-b0d9a5aae3ea) some but less than 50% of the values were not parsed due to classification type 4 errors

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2Fe7v5NDJlghtelZKxUYWz%2Fimage.png?alt=media\&token=6325635a-907c-4f7e-ba08-895a19002b9f) the data file is missing (classification type 2 error), the mapped column is missing (classification type 3 error) or more than 50% of the data values are of the wrong type

4\. **Source data value report:** a list of the data values where each row represents a single mapped data value for which there has been a problem parsing or uploading that value into the specified REACT data field

![Example: Source Data Value Report](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2Ft1o5MiOfs7sVlBfi7msR%2Fimage.png?alt=media\&token=9b895b07-9d44-4bcb-b708-0486f70676e3)

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FZmBeKXO1NCXEXExMICKg%2Fimage.png?alt=media\&token=19c30897-6f25-4ca3-a9e3-479f043c3db5) an error of type classification 6 but not classification type 4, meaning that the value was parsed from the input data and uploaded to the system

![](https://3564003943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaPy975iGMCUpGQJ0Cr1R%2Fuploads%2FGBzM4E3UMwfGO99r8ub3%2Fimage.png?alt=media\&token=819532a4-4d88-46d7-bd9c-3b8d1763f94e)more than 50% of the values were not parsed due to classification type 4 errors.
