Skip to content

ExecuComp regression data

This analysis dataset joins matched executive compensation to HCT match quality and annual Compustat controls.

flowchart TB
    pay[(Matched executive pay)]
    scores[(Worker-firm-period scores)]
    comp[(Processed annual Compustat)]
    build[Join executive-firm-years]
    data[(ExecuComp regression data)]

    pay --> build
    scores --> build
    comp --> build
    build --> data

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class pay,scores,comp source
    class build process
    class data data

Grain: one executive-firm-year
Key: execid, gvkey, user_id, company_id, calendar_year
Location: /data/<coverage>/analyses/<mode>/execucomp_regression_table.parquet
Builder: analyses/modules/disaggregated_execucomp.R

For each executive-firm-year, the builder retains the latest matching scored worker-firm period and attaches Compustat fields by gvkey and year. Separate files are built for training and full_training scores.

Rscript pipelines/disaggregated_execucomp.R build_regression_table \
  --config config/config_full.yaml --mode training --overwrite
Rscript pipelines/disaggregated_execucomp.R build_regression_table \
  --config config/config_full.yaml --mode full_training --overwrite

The output is consumed by the executive-compensation analysis.