This next section will cover some details related to using the ECA data. For a more detailed general explanation of compensation worksheets please see the Compensation Module User Manual.
A System Preference has been added to accommodate the ECA COL Calculation; BSHTCACOLN Allow a COL Index less than 1, the Default = EQFALS. This means that the system will default to only producing a Col calculation when the COL index is greater than 100, if you would like a negative COL to be calculated this preference can be changed to EQTRUE.
The ECA COL calculation has the following formula:
COL Calculation = ((Total Spendable Gradient * Annual Base Pay + Total Spendable Constant) * ((COL Index/100) - 1)) / Appropriate Calculation Period