Consolidate Immunization and Prescription Drug Route types

[adunsulag]

The immunizations table route column's datatype is a varchar and the prescriptions table route column is an integer. Both of these tables use the Drug Routes list to populate their route column. The Drug Routes list in list_options combines both integer types (which apparently are used with prescriptions) and string option_id values which are used in Immunization.

We need these two columns to use the same datatypes to avoid confusion and so data will save properly! We should also remove duplicates such as Intramuscular and the IM option in the Drug Routes which also creates confusion.

This is related to #5526.

[stale[bot]]

This issue has been automatically marked as stale because it has not had any recent activity within the past 90 days. It will be closed in 7 days if no further activity occurs.

[stale[bot]]

This issue has been automatically closed because it has not had any recent activity within the past 97 days.