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

Grain: one execid, gvkey, year
Location: /data/full/raw/execucomp/execucomp_revelio_matched_pay.parquet

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

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.