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