ExecuComp–Revelio unique matches

This persisted person mapping identifies ExecuComp executive-firm spells that have one exact Revelio worker match at the same mapped firm and during overlapping employment years.

flowchart TB
    exec[(ExecuComp people and annual roles)]
    events[(Revelio employment events)]
    names[(Revelio worker names)]
    firms[(Revelio-Compustat mapping)]
    match[Match firm, normalized name,<br/>and overlapping years]
    output[(ExecuComp-Revelio unique matches)]

    exec --> match
    events --> match
    names --> match
    firms --> match
    match --> output

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class exec,events,names,firms source
    class match process
    class output data

Grain and key: uniquely matched execid, gvkey spell
Location: /data/full/raw/execucomp/execucomp_revelio_unique_matches.parquet
Builder: shared/data/build_datasets/match_execucomp_revelio.py

The builder first maps ExecuComp gvkey values to Revelio firms, restricts candidate workers by firm and seniority, then compares normalized executive and worker names over overlapping employment years. It writes the unique-match Parquet beside a JSON matching summary.

python -m shared.data.build_datasets.match_execucomp_revelio

The builder describes this matching procedure as a prototype rather than a production crosswalk. The current match is nevertheless the required input to matched executive compensation, so its filters and diagnostics should be reviewed whenever source files change.