Sample Code for: Creating Public Payroll Indicators:  A Methodological Guide

By Innovation in Citizen Services Division (VPS/IFD/ICS)

The R code is used to calculate and standardize payroll indicators from common-format personnel records. Specifically, it provides working examples for deriving each key indicator (wage bill growth, employment growth, average pay trajectories, pay equity, gender pay gap, turnover, promotions/career progression, and retirement projections), so governments can compute these measures for the whole administration, for specific agencies, or for employee subgroups (e.g., by job, gender, contract). The code also illustrates recommended calculations and helps address common data errors, enabling comparable, reproducible salary indicators across countries.

Show more

Metadata & use

Identifier https://doi.org/10.60966/6x55ayx4
License Creative Commons Attribution 4.0 International
Published date 2025-11-06
Modified date 2025-11-06
Tags/Keywords public payrolls · public pay · public employment · turnover · gender pay gaps
Language Spanish
Temporal coverage 2025-2025
Country
Latin America and the Caribbean
Publisher
Inter-American Development Bank
Author
Naranjo, Sandra
Bastidas, Mateo
Avalos, Beatriz
Data collection type Administrative Data
Data structure Structured Data
Data notes

This sample R code allows users to replicate the public payroll analysis in any country in Latin America and the Caribbean

Additional materials

Load more