1 person found this helpful
You can update the table FormulationPreferences where the AttrName = "StepCalculationPath" and set the AttrValue to the pkid of the calculcation type you want to use from gsmStepCalcTypeLookupItems.
Always back up the database, of course, before trying this out.
Ron, we ran this against FormulationPreferences to update everything that was InputPercent to FixedInputPercent when we went live with 220.127.116.11. however several weeks after go live 238 new rows have showed up in this table set to InputPercent. Are there possibly templates we need to change as well? Can we make sure everyones profile & Preferences are set to FixedInputPercent?
I assume the templates would have been changed alongside the regular specs.
The user's preferred calculation path is in the UserEqtEquivalentPreference table, using the AttrName of "StepCalculationPath"