Skip to content

Matched executive pay

This dataset links ExecuComp executives to Revelio workers and attaches annual compensation and overlapping Revelio job titles.

flowchart TB
    exec[(ExecuComp)]
    events[(Revelio employment and names)]
    mapping[(Revelio-Compustat mapping)]
    people[(ExecuComp-Revelio unique matches)]
    match[Attach annual pay and<br/>overlapping Revelio title]
    pay[(Matched executive pay)]

    exec --> match
    events --> match
    mapping --> match
    people --> match
    match --> pay

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class exec,events,mapping,people source
    class match process
    class pay data
Inputs
Dataset Location
ExecuComp--Revelio unique matches /data/full/raw/execucomp/execucomp_revelio_unique_matches.parquet
ExecuComp annual pay Vendor ExecuComp delivery under /data/full/raw/
Employment events /data/full/processed/employment_events_processed/
Build
Component Location
Builder shared/data/build_datasets/enrich_execucomp_revelio_matches.py
Runtime hct-tower-model-cuda-… (CPU execution)
Entry point python -m shared.data.build_datasets.enrich_execucomp_revelio_matches
Output
Dataset File / location Grain Key and variables
Matched executive pay execucomp_revelio_matched_pay.parquet in /data/full/raw/execucomp/ Executive-firm-year Key: execid, gvkey, year
Variables include user_id, company_id, salary, bonus, total_compensation, revelio_title, revelio_seniority

The person-matching builder produces the unique executive-worker spells. The enrichment builder expands those matches to annual ExecuComp pay and keeps the highest-seniority overlapping Revelio title.

python -m shared.data.build_datasets.enrich_execucomp_revelio_matches
python -m shared.data.build_datasets.enrich_execucomp_revelio_matches --inspect

There is currently no project Slurm wrapper for this builder. Run the direct command in a CPU job using the model CUDA image.

The intermediate unique-match file is /data/full/raw/execucomp/execucomp_revelio_unique_matches.parquet. The final output feeds the ExecuComp regression data.

The current analysis configs point to /data/full/processed/execucomp/execucomp_revelio_matched_pay.parquet, while the shared builder defaults to the /data/full/raw/execucomp/ location shown above. This path mismatch must be resolved operationally before running the downstream builder; the documentation does not assume an unimplemented migration.