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.