Anonymise script for endTB

How to run it?

1. Download the endtb-config using below wget command

   Download endtb-config

   wget https://github.com/Bahmni/endtb-config/archive/release-0.82.zip

   
   

2.  uncompress downloaded file using below command

   unzip file

   unzip release-0.82.zip

   
   

3. Go to anonymise folder

   Navigate to anonymise folder

    cd endtb-config-release-0.82/scripts/anonymise

4. Run the script as below which internally executes the “deidentify_openmrs.sql” on “openmrs” database. 

    

   Navigate to anonymise folder

    ./anonymise.sh

   Running script will prompt for mysql root password, please provide the valid passsword.

What is incorporated in it?

The sql script is self-intuitive as each and every sql statement has the comment for what it does. However, here are the list of things that are incorporated as part of anonymisation script

• Person name is anonymised to have eight random alpha numeric upper case characters.

• Birth date is anonymised in such a way that the script will add or reduce 0-6months / 0-3months / 0-30days to the birth date if the person is more than 15years / between 5 and 15years / less than 5years old respectively. Estimated DoB will be toggled randomly to have either true or false (1 or 0).

• Person attributes of type text will be anonymised to have eight random alpha numeric upper case characters.

• Person attributes of type numeric (which are having form validation as numbers) will be anonymised to have random numbers with 10 digits.

• If the patient identifier prefix (eg. ARM for Armenia)  exists in the system, EMR IDs are anonymised with a combination of random patient identifier prefix (from the list of prefixes available) and a random number (a unique autoincrement id which is given in patient table in openmrs) attached to it (eg. ARM123). If not, it will use ‘ETB’ as the prefix while generating the EMR ID (eg: ETB123).

• Treatment IDs are anonymised to have eight random alpha numeric upper case characters.

The observations anonymisation has been commented out in the script. Once that is uncommented, it will be anonymised as follows.

• Text fields will be anonymised to have eight random alpha numeric upper case characters.

• Numeric fields will be anonymised to have random numbers of 8 digits.

How to customize it?

For person attributes:

 For observations captured on forms: