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, yearVariables 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.
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.