Revelio–Compustat–PERMNO mapping

This crosswalk extends the Revelio–Compustat mapping with one selected CRSP security identifier (permno) per Compustat firm.

flowchart LR
    mapping[(Revelio-Compustat mapping)]
    ccm[(CRSP/Compustat CCM links)]
    extend[Filter valid links and<br/>select one PERMNO]
    output[(Revelio-Compustat-PERMNO mapping)]

    mapping --> extend
    ccm --> extend
    extend --> output

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class mapping,ccm source
    class extend process
    class output data

Grain: one row per retained Revelio rcid
Current location: /data/full/analyses/mapping_revelio_compustat_permno.parquet
Builder: analyses/modules/build_mapping_permno.R
Entry point: analyses/pipelines/run_build_mapping_permno.R

The builder keeps CCM links with LINKTYPE in LU or LC and LINKPRIM in P or C. Because the output is not time varying, it selects the PERMNO with the longest active link window for each gvkey, then attaches it to every mapped rcid for that firm.

Rscript pipelines/run_build_mapping_permno.R \
  --config config/config_tables89_full.yaml

The mapping is reusable across CRSP-linked products, but its current builder and storage location remain under analyses. Its single-PERMNO treatment loses security-link history and should not be interpreted as a time-varying CCM crosswalk. Current consumers are the active patent panel and the public-firm analysis dataset.