We have a decimal property which is not storing any digits after the decimal point. For Ex. 234.56 is saved as 234. Upon investigation, we found that the datatype defined in DB is decimal(10,0), hence it's not storing anything after the decimal.
We do not want to create a new property as this property already exists in Production and there is lot of data associated with it and is also referred in many rules including Report Definition.
The other approach is to alter the Datatype size of this decimal property column in DB table.
However I want to know is there any way to do out of Pega which will not impact Production data too.
***Edited by Moderator Marissa to add Capability tags***