
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"`: Set `gross = base + allowance`
`"cap_net"`: Cap net at gross
`"cap_base"`: Cap base at gross
`"flag"`: Add flag columns `gross_composition_flag`, `net_exceeds_gross_flag`, `base_exceeds_gross_flag`