Skip to content

HR leadership data

This family identifies annual HR leaders at Revelio firms and creates a linked public-company CHRO and top-HR panel without using HCT scores.

Legacy workflow

The public-company builder shown here still requires the retired mapping_revelio_compustat.parquet input. It is retained for reference, not as a runnable supported workflow.

flowchart TB
    positions[(Revelio positions)]
    mapping[(Revelio-Compustat mapping)]
    comp[(Processed annual Compustat)]
    ccm[(CRSP/Compustat CCM links)]
    classify[Classify titles and<br/>select annual leaders]
    leaders[(HR-leadership firm-year data)]
    public[(Public-company CHRO data)]

    positions --> classify --> leaders
    leaders --> public
    mapping --> public
    comp --> public
    ccm --> public

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class positions,mapping,comp,ccm source
    class classify process
    class leaders,public data
Inputs
Dataset Location
Raw Revelio position records Vendor Revelio position delivery under /data/full/raw/
Revelio--Compustat mapping /data/full/processed/mapping_revelio_compustat.parquet
Processed annual Compustat and CCM links /data/full/processed/compustat_annual.parquet and vendor CRSP links
Build
Component Location
Builder shared/data/build_datasets/{chro_panel,chro_public_panel}.py
Runtime hct-tower-model-cuda-… (CPU execution)
Entry point python -m shared.data.build_datasets.chro_panel and chro_public_panel
Output
Dataset File / location Grain Key and variables
HR-leadership firm-year panel revelio_hr_exec_firm_year.parquet in /data/full/raw/chro/ Firm-year Key: rcid, year
Variables include chro_user_id, top_hr_user_id, hr_exec_score, chro, top_hr, chro_transition
Public-company CHRO panel revelio_chro_public_firm_year.parquet in /data/full/raw/chro/ Public firm-year Key: gvkey, year
Variables include rcid, permno, chro_user_id, top_hr_user_id, hr_exec_score, chro, top_hr

The reusable pipeline has two principal products:

Product Builder
revelio_hr_exec_firm_year.parquet chro_panel.py classifies titles and selects strict CHRO and top-HR leaders
revelio_chro_public_firm_year.parquet chro_public_panel.py adds gvkey and optional permno
python -m shared.data.build_datasets.chro_panel
python -m shared.data.build_datasets.chro_public_panel

There is currently no project Slurm wrapper for these builders. Run the direct commands in a CPU job using the model CUDA image.

The first builder reads raw Revelio positions because it needs title fields not retained in the canonical employment-event contract. It can optionally write revelio_hr_exec_spells.parquet. The public-panel builder joins the Revelio-Compustat mapping and annual Compustat, optionally attaches a year-valid PERMNO from CCM, and writes two coverage sidecars.

ExecuComp titles provide a partial external validation through shared.data.build_datasets.validate_chro_execucomp. The separate CHRO with model MQ dataset belongs to the analysis layer.