CRSP_CCM_LINKRNG - CRSP-Centric Link History Range

The link history is presented by calendar range. If data are presented on a fiscal basis the calendar dates must be interpreted as the proper fiscal period. In this case there can be overlaps generated when links change across GVKEYS or fiscal year end month changes.

CRSP generates a range table with information on the fiscal periods associated with each used link for each time series calendar frequency and keyset. This shows ranges in each of the fiscal and calendar calendars available in the CCM. When there is an overlap and used links provide data for the same fiscal period, the link with the latest filing data date is chosen for the fiscal period. This range table shows the ranges from the GVKEY for each type of time series data used to build the composite record for the PERMNO selected.

Itm_name Type Description
PERMNO* integer, primary key 1 PERMNO key built
RLINKID integer, primary key 2 unique ID set in the link used record, used for joining range data with the appropriate link.
RKEYSET integer, primary key 3 Keyset of time series object
RCALID integer, primary key 4 CRSP calendar of time series
RFISCAL_DATA_FLG char(1) Type of time series data, F = fiscal, C= calendar
RBEGIND integer first index in time series with valid data for this used link
RENDIND integer last index in time series with valid data for this used link
RPREVIND integer index of previous data
RBEGDT integer first calendar date in time series with valid data for this used link.
RENDDT integer last calendar date in time series with valid data for this used link
RPREVDT integer date of previous data

* - see note on CRSP_CCM_LINKUSED PERMNO.