Standard dictionary for `govhr` • govhr

Overview

This article describes the standard dictionary for govhr, organized into four main modules: Establishment, Personnel, Contract, and Allowance. These modules are designed to organize and standardize information about public sector personnel across different countries and administrative levels.

Module 1: Establishment

The Establishment module captures information about public sector institutions, including ministries, departments, and agencies, along with their sector classification and geographic/administrative location.

Fields

Field Name	Variable Name	Description
Establishment ID	`est_id`	Unique identifier assigned to each establishment.
Establishment Name (Native)	`est_name_native`	Official Establishment name in the country’s native language.
Establishment Name (English)	`est_name_english`	Official Establishment name translated into English.
Sector	`sector`	The COFOG sector classification an establishment belongs to at the adm1 level.
Reference Date	`ref_date`	Date of the HRMIS record.
Administration 1 Name	`adm1`	First-level administrative division. For example, a Ministry or Secretariat.
Administration 1 Code	`adm1_code`	First-level administrative division code, if available.
Administration 2 Name	`adm2`	Second-level administrative division. For example, a Department or Division.
Administration 2 Code	`adm2_code`	Second-level administrative division code, if available.
Administration 3 Name	`adm3`	Third-level administrative division. For example, an Agency or Unit.
Administration 3 Code	`adm3_code`	Third-level administrative division code, if available.
Geography 1 Name	`geo1`	First-level geographic division. For example, a state or region.
Geography 2 Name	`geo2`	Second-level geographic division. For example, a municipality or county.
Country Code	`country_code`	Official World Bank ISO 3-letter country code.
Country Name	`country_name`	Official World Bank country name.

Notes

Sector: Uses the COFOG (Classification of the Functions of Government) classification to categorize establishments.
Administration vs. Geography: Administration levels (adm1/adm2/adm3) refer to institutional/administrative divisions (e.g., Ministry, Department, Agency), while geography levels (geo1/geo2) refer to physical location (e.g., state/region, municipality/county).

Module 2: Personnel

The Personnel module contains demographic and employment information about individual public sector employees.

Fields

Field Name	Variable Name	Description
Personnel ID	`personnel_id`	Unique identifier assigned to each worker.
Reference Date	`ref_date`	Date of the HRMIS record.
Date of Birth	`birth_date`	The date of birth of a person.
Age	`age`	The age of the person.
Gender	`gender`	Gender of the person.
Educational Attainment	`educat7`	Educational attainment in 7-level classification, following the World Bank’s GLD convention.
Tribe	`tribe`	Person’s ethnic or tribal affiliation.
Race	`race`	Person’s race or broad ethnic classification.
Employment Status	`employment_status`	Employment status of the person (active or retired).
Person Tenure	`personnel_tenure`	How much time a person has worked in the public sector.
Type of Service	`service_type`	The type of service of a person: civilian or military.
First Employment Date	`first_employment_date`	Date personnel enter the public service for the first time.

Notes

Employment Status: Used together with ref_date to detect movement events such as hires, fires, and retirements (see classify_personnel_event()).
Educational Attainment: Follows the World Bank’s Global Labor Database (GLD) 7-level classification convention.
Tenure Fields: personnel_tenure tracks overall public sector tenure, distinct from contract_tenure in the Contract module, which tracks tenure within a specific contract.
Privacy Considerations: This module contains sensitive personal information and should be handled according to applicable data protection regulations.

Module 3: Contract

The Contract module captures details about employment contracts, compensation, and job characteristics.

Fields

Field Name	Variable Name	Description
Contract ID	`contract_id`	Unique identifier assigned to each contract.
Personnel ID	`personnel_id`	Unique identifier assigned to each worker.
Establishment ID	`est_id`	Unique identifier assigned to each establishment.
Reference Date	`ref_date`	Date of the HRMIS record.
Base Salary (Local Currency)	`base_salary_lcu`	Basic pay before allowances and deductions.
Gross Salary (Local Currency)	`gross_salary_lcu`	Total compensation before taxes and deductions.
Net Salary (Local Currency)	`net_salary_lcu`	Take-home pay after taxes and deductions.
Allowance (Local Currency)	`allowance_lcu`	Allowances after salary has been paid.
Contract Type (International)	`contract_type_international`	Type of employment contract following ILO standard ICSE-18 classifications. For example: permanent (e.g., civil servant), etc.
Contract Type (Native)	`contract_type_native`	Type of employment contract in native language.
Occupation (Native)	`occupation_native`	Worker’s occupation title in the native language.
Occupation (English)	`occupation_english`	Worker’s occupation title in English.
ISCO Occupation Name	`occupation_isconame`	Occupation mapped to ISCO-08 classification.
ISCO Code	`occupation_iscocode`	ISCO-08 occupation code.
Start Date	`start_date`	Start date of the employment contract.
End Date	`end_date`	End date of the employment contract, if applicable.
Working Hours	`whours`	Total weekly or monthly working hours as per contract.
Pay Grade	`paygrade`	Pay grade or salary scale classification of a contract.
Seniority	`seniority`	The level within the paygrade of a specific contract.
Contract Tenure	`contract_tenure`	How much time a person has worked in a given contract.

Notes

Compensation Fields: Base, gross, and net salary fields (local currency only) allow analysis of gross-to-net ratios and the effect of deductions and allowances. Itemized allowance amounts are tracked separately in the Allowance module.
Contract Type (International): Follows the ILO’s ICSE-18 (International Classification of Status in Employment) standard for cross-country comparability, while contract_type_native preserves local terminology.
Occupation Coding: Both native and standardized (ISCO-08) classifications enable within-country detail and cross-country comparability.
Tenure vs. Seniority: contract_tenure tracks time worked in the current contract, while seniority tracks the level within the paygrade.

Module 4: Allowance

The Allowance module captures detailed, itemized allowance payments associated with a contract, allowing analysis of allowance composition beyond the aggregate allowance_lcu figure in the Contract module.

Fields

Field Name	Variable Name	Description
Personnel ID	`personnel_id`	Identifier assigned to each person.
Contract ID	`contract_id`	Unique identifier assigned to each contract.
Reference Date	`ref_date`	Date of the HRMIS record.
Allowance Type	`allowance_type`	The allowance type.
Allowance Value	`allowance_value`	Allowance value for the specific allowance type in local currency units.

Notes

Granularity: Unlike the aggregate allowance_lcu field in the Contract module, this module stores one row per allowance type per contract per reference date, enabling detailed breakdowns of allowance composition.

Relationship between modules

The four modules are related as follows:

Establishment (1) ←→ (N) Contract
Personnel (1) ←→ (N) Contract
Contract (1) ←→ (N) Allowance

One establishment can have many contracts.
One person can have multiple contracts (over time or concurrent).
One contract can have multiple itemized allowances.