# 2020.07 Upgrade

## New Features

### Data Warehouse

* Created reporting views in the data warehouse for the different discipline specific reports: -&#x20;
  * Added view dw\.healthy\_hearing\_report\_view containing the Healthy Hearing indicators.&#x20;
  * Added view dw\.strong\_minds\_report\_view containing the Strong Mind indicators.
  * Added view dw\.special\_smiles\_report\_view containing the Special Smiles indicators.&#x20;
  * Added view dw\.funfitness\_report\_view containing the FunFitness indicators.&#x20;
  * Added view dw\.opening\_eyes\_report\_view containing the Opening Eyes indicators.
  * Added view dw\.health\_promotion\_report\_view containing the Health Promotion indicators.
  * Added view dw\.fitfeet\_report\_view containing the Fit Feet indicators.
  * Added view dw\.snapshot\_summary\_of\_event\_report\_view containing the Snapshot Summary of X event(s) indicators.
* Added dw\.dim\_form table in the data warehouse to help different similar concepts used in different forms for the same discipline e.g Strong Mind's Check-in and Check-out forms.

### OpenMRS Platform

#### Athlete Landing Page

* Added the ability to track most recent vitals information in the Vitals tile.
* Created a BMI Trend tile containing a line graph to track BMI over time.

### Discipline Forms

#### Healthy Hearing

* On the Pure Tone Threshold form, added question 'NR/C' on the form.

## Changes

### Data Migration

* Added missed question concept Sextant (33-43) in the SO Concept Dictionary.

### Deployments&#x20;

* Upgraded the three OpenMRS production servers(SO-Americas, SO-Asia and SO-EU-Africa) and HAS-Training server to the 2020.07 Upgrade release version.
* Ran backfills on the data warehouse to update data of corrected grouping concept and concept issues on the discipline forms from the three OpenMRS production servers(SO-Americas, SO-Asia and SO-EU-Africa).&#x20;

## Bug Fixes

### OpenMRS HAS Platform

#### Athlete Landing Page

* Fixed issue with Notes tile showing default Laurem ispsum text.
* Resolved issue with Notes tile being overwritten with Health Promotion Notes

#### Event Management

* Resolved issue of athletes registered not showing in the event where they are registered.

### Discipline Forms

#### Fit Feet

* On the Biomechanics, Joint Range of Motion Static Biomechanics form, fixed issues with the wrong concepts used on the form and corrected past collected data.

#### Healthy Hearing

* On the Otoscopy form, resolved issues with the grouping concept used on the form and corrected past collected data.

#### Health Promotion

* On the Sun Safety form, fixed issues with the wrong concepts used on the form and corrected past collected data.
* On the Screening form, fixed issues with the wrong concept used on the form and corrected past collected data.
* On the Physical Activity form, resolved issues with the grouping concepts used on the form and corrected past collected data.

#### Opening Eyes

* On the Visual Acuity form, fixed the alignment issues on the message "Please ensure the athlete has their glasses on for testing if they wear them for close work." when Unable to Test is checked in Far-Left Eye or Far-Right Eye.
* On the Cover Test form, resolved issues with the grouping concepts used on the form and corrected past collected data.
* On the Visual Acuity form, resolved issues with the grouping concepts used on the form and corrected past collected data.

{% file src="<https://2696600280-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lvoksbjjp_ug_Dtk9-L%2F-MClA_22DOpEouTcr-b_%2F-MClB2Qoqn6NGmNGE1-C%2FFixed%20Grouping%20Concept%20and%20Concept%20Issues.xlsx?alt=media&token=c2f45c3c-4959-48f6-a8a6-1d20f3c72180>" %}
Fixed Grouping Concept and Concept Issues
{% endfile %}

## Known Issues

### Data Warehouse

* Added email alerts to notify Dev and QA of failed data push processes in the data warehouse. (**In QA**) &#x20;

### Data Migration

* Migration of second POC MDE file (**Blocked by fix of grouping concept id issues and reporting views creation priority**)&#x20;
* Client Bug DM: Some entries where migrated to wrong grouping concepts for WWG March 2017 Migration ( **in To Do,** **Blocked by reporting views creations priority**)&#x20;
* Client Bug DM: Some entries are missing grouping concepts related data for WWG March 2017 Migration ( **Blocked by priority to fix outstanding grouping concept issues**)&#x20;
