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