The SASEXCCM Interface Engine (Experimental)

The CRSP/Compustat Merged (CCM) database is organized by company and security according to Compustat’s Permanent SPC Identifier, GVKEY. CCM data is broken down into items, and items can be further qualified by a set of secondary keys. CRSP calls these known collections of keys and values a keyset, and it assigns a numeric code and mnemonic tag to each unique collection. Each keyset represents different output series. Items are also organized into groups for selection and presentation. A group can include other groups, or a group can include items. Items can belong to more than one group.

For example, the Compustat data item SALE has secondary keys for industry format, data format, population source, and consolidation level. A different value of company sales can be available for any combination of these keys, such as a combination that represents the originally reported sales or the final restated sales from a later filing. The SALE data item is a part of the ANNITEM (Annual Time Series Items, including footnotes and data codes) group.

The CCM database contains data items provided by Compustat in addition to structures and supplementary data items provided by CRSP. All data items include a mnemonic and field name. This section provides a summary of Compustat data items whose mnemonic name differs in the CCM database, and a summary of the supplementary data items provided by CRSP. For more information about the Compustat data items, refer to your Compustat data documentation or see www.compustatresources.com/support/index.html. For more information about the supplementary CRSP data items, refer to your CCM Database Guide.

Supplemental CRSP data items are organized as groups. For a list of the supplemental data groups, see the section CCM Data Groups.