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
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.
* - see note on CRSP_CCM_LINKUSED PERMNO.