Backend table values are not matching with frontend Compensation plan salary changes values.

Summary

Backend table values are not matching with frontend Compensation plan salary changes values.

Content

Hi,

 

we proposed new Gross salary with some percentage of current gross salary. we are using standard fields to display these new base salary and change in amount proposed and in percentage of current Gross salary.

 

But when fetching salary change details in report for same plan and persons,the salary change value is different to which we proposed in front-end. 

 

we are using below query to fetch person salary change values for a particular plan.

===============================================================

SELECT plan_id, 

      person_number,

  base_salary,

  base_salary_change_val,