The SASEXCCM Interface Engine

CCM Data Groups

CCM items are organized into groups for ease of selection and presentation. Each group is given a group name. These names are unique and do not overlay with item names. A group can be made up of either items or other groups. Items can belong to more than one group. Table 40.7 provides a summary of some groups. Refer to your CCM Database Guide for more information about CCM data groups.

Table 40.7: Selected Xpressfeed Primary and CRSP Supplemental Groups

Item Name

Description

MASTER

CCM company ID and range data

COMPANY

CCM company header information

IDX_INDEX

CCM idx_index header information

SPIND

Standard & Poor’s (S&P) index header (pre-GICS)

COMPHIST

CCM company header history

CSTHIST

CST header history

LINK

Link history

LINKUSED

CCM company CRSP link used data

LINKRNG

CCM company CRSP link range data

ADJFACT

CCM company adjustment factor history

HGIC

CCM company GICS code history

OFFTITL

CCM company officer title data

CCM_FILEDATE

CCM company filing date data

CCM_IPCD

CCM industry presentation code data

SECURITY

CCM security header information

SECHIST

CCM security header history

SEC_MTHSPT

CCM security monthly split events

SEC_MSPT_FN

CCM security monthly split event footnotes

SEC_MDIV_FN

CCM security monthly dividend event footnotes

SEC_SPIND

CCM security S&P information events

IDXCST_HIS

CCM security historical index constituents

SPIDX_CST

CCM security S&P index constituent events

CCM_SEGCUR

CCM operating segment currency rate data

CCM_SEGSRC

CCM operating segment source data

CCM_SEGPROD

CCM operating segment product data

CCM_SEGCUST

CCM operating segment customer data

CCM_SEGDTL

CCM operating segment detail data

CCM_SEGITM

CCM operating segment item data

CCM_SEGNAICS

CCM operating segment NAICS data

CCM_SEGGEO

CCM operating segment geographic data