# 2020.09 Upgrade ## New Features * Added external system id on the 'Add New Account' page /user registration form for capturing Power BI id. * Added fact\_users table in the Data Warehouse for storing system users' external user ids (Power BI account) and their respective program data access privileges. * Added a tile 'Data Collected' with clinical information( Stage 1, 2a or 2b Hypertensive/Hypotension, BMI weight status, Osteopenia/Osteoporosis, Hearing loss, O2 saturation )on the Athlete's Landing Page ## Changes ### Data Warehouse * Added columns 'total\_other\_screened' and 'total\_unified\_partner\_screened' to the dw\.snapshot\_summary\_of\_event\_report\_view * Added extra 21 indicators from the SAS code document in the dw\.funfitness\_report\_view data warehouse view. * Added the 14 calculated indicators from the SAS code in the dw\.funfitness\_report\_view data warehouse view. * Updated the Strong Mind view to reflect form-ids for similar question concepts from different forms. * Added the program\_name column in the dw\.number\_of\_disciplines\_attended\_view and dw\.snapshot\_summary\_of\_event\_report\_view in the data warehouse views. * Resolved data inconsistencies caused by the change of concepts in the production concept dictionary during SO deployment from 01-2020. Part of changes includes use of Right Biomechanic and Left Biomechanic consistently instead of a mix with Right and Left. ### OpenMRS Platform - Non-Form Changes * Added Canadian Provinces to the delegation options on the Registration form. * Added Canadian Provinces to the program options on the Event creation page. * Added Canadian Provinces to the program options on the 'Add New Account' page. * On the Athlete Landing Page, added a pencil icon on the Family tile for editing relation details. NB: since standard OpenMRS has the 'Confirm' button disabled on the update Relationship form, users need to enable the button via Inspect Element to enable it to save updates. ### Discipline Form Changes #### FUNfitness Forms * On the Screening form, added the option "No diseases or injuries" to the question "Any disease or injuries that may affect screening results?". * On the Flexibility form, added options("Refused to respond", "Unable to respond" and "Unable to understand") to question 1("Do you stretch routinely?"). * On the Flexibility form, removed question 'Unable or refused to perform test' and added question 'Unable to test because athlete' under sections **Hamstring-supine(passive)knee extension**, **CALF- supine(passive)ankle dorsiflexion**, **Anterior hip- Modified Thomas Test** and **SHOULDER- Apley's Test (Functional Shoulder Rotation).** * On the Strength form, added options("Refused to respond", "Unable to respond" and "Unable to understand") to question 2("How much of this strength activity is ONLY related to Special Olympics training, practice, or competition and not done as part of daily life?"). * On the Aerobic Fitness form, removed the option "MIO Heart rate monitor" from the question "How is HR being Measured ? ". * On the Aerobic Fitness form, added options("Refused to respond", "Unable to respond" and "Unable to understand") to question 3("How much of the moderate physical activity is ONLY related to Special Olympics, and not done as a part of daily life?"). * On the Aerobic Fitness form, added a new question 'Unable to test because athlete' and removed question 'Unable or refused to perform test' from the form. #### Healthy Hearing Forms * Removed the special character (–) from the concept names Otoscopy Right Hearing and Otoscopy Left Hearing as it was not being recognized in the data warehouse and external SQL editors for data analysis. #### Health Promotion Forms * On the Body Composition form, updated the 'BMI Percentile(under 20 years of age)' to be a read-only field. #### Opening Eyes Forms * On the Eye Health form, added fields for capturing abnormalities description and upload of a photo of the abnormality. ### Upgrades and Deployments * Upgraded the AWS Aurora RDS instances for SO-EU-Africa, SO-Asia and SO-Americas from Aurora version 1.17.8 to version 1.23.0. * Upgraded the three OpenMRS production servers(SO-Americas, SO-Asia and SO-EU-Africa) and HAS-Training server to the 2020.09 Upgrade version. * Ran backill for the source prod servers on data warehouse ## Bug Fixes ### Opening Eyes Forms * On the Screening form, fixed issues with questions 2 and 3 that have answers( Qn2(Difficulty Seeing, Double Vision) and Qn 3 (Standard Rx and Contact Lenses)) that have sub-questions and ran update queries to fix past collected data in OpenMRS DBs. * On the Eye Health form, corrected the Normal concept id used and ran update queries to fix past collected data in OpenMRS DBs. * On the Eye Health form, corrected the question concept id of the Abnormalities lists used and ran update queries to fix past collected data in OpenMRS DBs. ### Health Promotion Forms * On the Blood Pressure form, corrected the 'Referral made for BP follow-up' concept id used and ran update queries to fix past collected data in OpenMRS DB. {% file src="" %} Concept ID Fixes {% endfile %} ### Data Warehouse * Fixed issue with unknown\_sport and unknown\_program records in the Data Warehouse except those originating from data migration. ## Known Issues * On the OE: Eye Health form, the view button displayed after uploading a photo of abnormality does not work but the image can be downloaded and users view the downloaded file. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://vecnacares.gitbook.io/special-olympics-openmrs-has/release-notes/2020.09-upgrade.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.