
Fix salary component inconsistencies
fix_salary_components.RdCorrects violations of wage bill consistency rules: gross ≥ base + allowance, gross ≥ net, gross ≥ base.
Usage
fix_salary_components(
data,
strategy = c("recalculate_gross", "cap_net", "cap_base", "flag")
)Arguments
- data
A data.frame with columns
gross_salary_lcu,base_salary_lcu,net_salary_lcu,allowance_lcu.- strategy
Correction strategy:
"recalculate_gross": Setgross = base + allowance"cap_net": Cap net at gross"cap_base": Cap base at gross"flag": Add flag columnsgross_composition_flag,net_exceeds_gross_flag,base_exceeds_gross_flag