Skip to content

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.

Legacy workflow

This builder still requires the retired mapping_revelio_compustat.parquet input. It is retained for reference, not as a runnable supported workflow.

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
Inputs
Dataset Location
ExecuComp people and annual roles Vendor ExecuComp delivery under /data/full/raw/
Employment events /data/full/processed/employment_events_processed/
Revelio--Compustat mapping /data/full/processed/mapping_revelio_compustat.parquet
Build
Component Location
Builder shared/data/build_datasets/match_execucomp_revelio.py
Runtime hct-tower-model-cuda-… (CPU execution)
Entry point python -m shared.data.build_datasets.match_execucomp_revelio
Output
Dataset File / location Grain Key and variables
Unique executive-worker matches execucomp_revelio_unique_matches.parquet in /data/full/raw/execucomp/ Unique matched executive-firm spell Key: execid, gvkey
Variables: n_user, user_id, n_rcid, max_seniority, match_status

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

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

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.