Context
After 1.5.1 Release, the consortium decided to change the Audiometry Results concepts to Numeric type. For which a liquibase migration was written which did the below.
...
Hence the below query is provided to MSF for migrating value coded Audiometry obs to numeric with below logic.
Current option selected | Numeric equivalent |
|---|---|
1= "0 to 20 db" | 10 |
2= "21 to 40 dB" | 30 |
3= "41 to 55 dB" | 48 |
4= "56 to 70 dB" | 63 |
5= "71 to 90 dB" | 80 |
6= "91+ dB" | 100 |
| Warning |
|---|
This is available in Release 2.0 only |
SQL Script
Below is the SQL script to be run on the Bahmni server as a root user using below commands:
| Code Block | ||
|---|---|---|
| ||
sudo su wget https://bahmni.atlassian.net/wiki/download/attachments/115977107/audiometryMigration.sql mysql -u root -p openmrs < audiometerymigrationaudiometryMigration.sql |
| Info | ||
|---|---|---|
| ||