2020.09 Upgrade

Vesion 1.0.14, Released On: 10.17.2020

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

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.

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.

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.

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.

On the Body Composition form, updated the 'BMI Percentile(under 20 years of age)' to be a read-only field.

On the Eye Health form, added fields for capturing abnormalities description and upload of a photo of the abnormality.

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

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.

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.

Fixed issue with unknown_sport and unknown_program records in the Data Warehouse except those originating from data migration.

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.

Last updated 4 years ago

Was this helpful?