arnabnaha wrote on Saturday, August 24, 2013:
Hi…
I was entering a rabies vaccine info in the immunisation module of openemr. everything was fine but, when I entered the dosage as 0.5 ml of IM injection, after saving the immunisation, it automatically made the amount 1 ml…this is not true…how can I use decimal in dosage?
blankev wrote on Saturday, August 24, 2013:
The vaccination dose in the MySQL data base is registered as INT 11. Lots of discussion going on for Integers 1, Integers 4, Integers 11 (for big numbers) and TinyInt (for smaller numbers).
My solution would be to use something like Decimal (6,2) for number fields in MySQL.
Decimal fields are:
The total amount of characters including the decimal point and the total number of decimals after the point 999.99 is: Decimal 6,2 (six comma two). If you change this in the Database of OpenEMR 0.5 ml is accepted in Immunizations as 0.50 ml. If this is the solution I can’t tell, but converting 0.5 ml int0 1 ml is a BUG!
Do we need two decimals for Immunization or only one? Do we need a total characters of 6 or will 3 suffice, Immunizations are usually less than 10 ml or before and and one after the point, so even three would be enough DEC(3,1).
Since I am an Implementer and not a Developer I don’t know what to do with this BUG. But if you follow my advise, it works. Remember that every new version, there might be a reason to change this field again.
Since Immunoglobulins are included in the Immunization tables, we might need a DEC(5,2) to be safe for all Code-types included.