A salary comparison needs the same currency, time basis and contracted hours. The people table stores an annual actual salary. Divide it by FTE to compare a part-time employee with a full-time band; a zero FTE makes that comparison undefined. Compa-ratio divides normalized annual salary by the band midpoint. Range penetration subtracts the band minimum and divides by the width from minimum to maximum. Those are different measures. A person below the minimum has negative penetration, and someone above the maximum has penetration above one. Keep those values visible. These exercises teach arithmetic and investigation, not a legal finding or a pay recommendation for a real person.
Compare like-for-like annual amounts and use the assigned band minimum.
Compare like-for-like annual amounts and use the assigned band minimum.