CCM Field Usage Tables

Click on a link below to jump to the specific table.  
Structure: Master Structure: HGIC Structure: IDXCST_HIS
Structure: Company Structure: OFFTITL Structure: SPIDX_CST
Structure: IDX_INDEX Structure: CCM_FILEDATE Structure: CCM_SEGCUR

Structure: SPIND

Structure: CCM_IPCD Structure: CCM_SEGSRC
Structure: COMPHIST Structure: SECURITY Structure: CCM_SEGPROD
Structure: CSTHIST Structure: SECHIST Structure: CCM_SEGCUST
Structure: LINK Structure: SEC_MTHSPT Structure: CCM_SEGDTL
Structure: LINKUSED Structure: SEC_MSPT_FN Structure: CCM_SEGITM
Structure: LINKRNG Structure: SEC_MDIV_FN Structure: CCM_SEGNAICS

Structure: ADJFACT

Structure: SEC_SPIND

Structure: CCM_SEGGEO

Structure: MASTER

Mnemonic Field Name Internal Storage Display Format Field Usage
BEGQTR Quarterly date of earliest data (yyyy.q) int(4) %6d master_itm->arr.master->begqtr
BEGYR Annual date of earlist data (yyyymmdd) int(4) %4d master_itm->arr.master->begyr
CBEGDT First date of Compustat data int(4) %8d master_itm->arr.master->cbegdt
CCMID Permanent record identifier for Compustat company or index data, represents GVKEY for company, GVKEYX for index int(4) %6d master_itm->arr.master->ccmid
CCMIDTYPE Type of key for Compustat data. 1 = company data, 2 = index data int(4) %2d master_itm->arr.master->ccmidtype
CENDT Last date of Compustat data int(4) %8d master_itm->arr.master->cendt
ENDQTR Quarterly date of last data (yyyy.q) int(4) %6d master_itm->arr.master->endqtr
ENDYR Annual date of last data (yyyymmdd) int(4) %4d master_itm->arr.master->endyr
Back to top

 

Structure: COMPANY

Mnemonic Field Name Internal Storage Display Format Field Usage
ADD1-4 Address lines 1-4 char(68) %-65s company_itm->arr.company->add#
ADDZIP Postal code char(24) %-24s company_itm->arr.company->addzip
BUSDESC Business description char(2000) %-2000s company_itm->arr.company->busdesc
CIK CIK number char(12) %-10s company_itm->arr.company->cik
CITY City char(104) %-104s company_itm->arr.company->city
CONM Company name char(256) %-255s company_itm->arr.company->conm
CONML Company legal name char(104) %-100s company_itm->arr.company->conml
COSTAT Postal code char(24) %-1s company_itm->arr.company->addzip
COUNTY County code char(104) %-100s company_itm->arr.company->county
DLDTE Research company deletion date int(4) %8d company_itm->arr.company->dldte
DLRSN Research company reason for deletion char(12) %-8s company_itm->arr.company->dlrsn
EIN Employer identification number char(12) %-10s company_itm->arr.company->ein
FAX Fax number char(24) %-18s company_itm->arr.company->fax
FIC ISO Country code of incorporation char(16) %-3s company_itm->arr.company->fic
FYRC Fiscal year end (current) int(4) %2d company_itm->arr.company->fyrc
GGROUP GICS groups char(12) %-4s company_itm->arr.company->ggroup
GIND GICS industries char(12) %-6s company_itm->arr.company->gind
GSECTOR GICS sectors char(12) %-2s company_itm->arr.company->gsector
GSUBIND GICS sub-industries char(12) %-8s company_itm->arr.company->gsubind
IDBFLAG International/Domestic/Both indicator char(12) %-1s company_itm->arr.company->idbflag
INCORP State/Province of incorporation code char(12) %-8s company_itm->arr.company->incorp
IPODATE Company initial public offering date int(4) %8d company_itm->arr.company->ipodate
LOC ISOCountry code/ headquarters char(4) %-3s company_itm->arr.company->loc
NAICS North American Industry Classification Code char(8) %-6s company_itm->arr.company->naics
PHONE Phone number char(24) %-18s company_itm->arr.company->phone
PRICAN Primary Issue Tag - Canada char(12) %-8s company_itm->arr.company->prican
PRIROW Primary Issue Tag – rest of world char(12) %-8s company_itm->arr.company->prirow
PRIUSA Primary Issue Tag - USA char(12) %-8s company_itm->arr.company->priusa
SIC SIC code int(4) %4d company_itm->arr.company->sic
SPCINDCD S&P industry sector code - reference int(4) %4d company_itm->arr.company->spcindcd
SPCSECCD S&P economic sector code - reference int(4) %4d company_itm->arr.company->spcseccd
STATE State/Province char(12) %-8s company_itm->arr.company->state
STKO Stock ownership code int(4) %1d company_itm->arr.company->stko
WEBURL Website address char(68) %-60s company_itm->arr.company->weburl
Back to top

 

Structure: IDX_INDEX

Mnemonic Field Name Internal Storage Display Format Field Usage
IDX13KEY 13 character key char(16) %-13s idx_index_itm->arr.idx_index->idx13key
IDXCSTFLG Index constituent flag char(4) %-2s idx_index_itm->arr.idx_index->idxcstflg
IDXSTAT Index Status char(2) %-10s idx_index_val->arr.idx_index->idxstat
INDEXCAT Index category code char(12) %-10s idx_index_itm->arr.idx_index->indexcat
INDEXGEO Index geographical area char(12) %-10s idx_index_itm->arr.idx_index->indexgeo
INDEXTYPE Index type char(12) %-10s idx_index_itm->arr.idx_index->indextype
INDEXVAL Index value char(12) %-10s idx_index_itm->arr.idx_index->indexval
SPII S&P industry index code int(4) %4d idx_index_itm->arr.idx_index->spii
SPMI S&P major index code int(4) %4d idx_index_itm->arr.idx_index->spmi
TICI Issue trading ticker char(12) %-8s idx_index_itm->arr.idx_index->tici
XCONM Company Name (Index) char(256) %-255s idx_index_itm->arr.idx_index->xconm
XINDEXID Index ID char(12) %-12s idx_index_itm->arr.idx_index->xindexid
XTIC Ticker/trading symbol (index) char(10) %-10s idx_index_itm->arr.idx_index->xtic
Back to top

 

Structure: SPIND

Mnemonic Field Name Internal Storage Display Format Field Usage
SPIID S&P Industry ID int(4) %4d spind_itm->arr.spind->spiid
SPIMID S&P Major Index ID int(4) %4d spind_itm->arr.spind->spimid
SPITIC S&P Index ticker char(12) %-12s spind_itm->arr.spind->spitic
SPIDESC S&P Index industry description /reference char(256) %-256s spind_itm->arr.spind->spidesc
Back to top

 

Structure: COMPHIST

Comphist field usage assumes an initialized CRSP_ITM comphist_itm attached to the COMPHIST itm_name. Index I in field usage is between 0 and comphist_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
HCHGDT Comphist description effective date int(4) %8d comphist_itm->arr.comphist[i].hchget
HCHGENDDT Comphist description last effective date int(4) %8d comphist_itm->arr.comphist[i].hchgenddt
HDLDTE Historical research company – deletion date int(4) %8d comphist_itm->arr.comphist[i].hdldte
HFYRC Historical fiscal year end month / current int(4) %10d comphist_itm->arr.comphist[i].hfyrc
HIPODATE Historical company official public offering date int(4) %10d comphist_itm->arr.comphist[i].hipodate
HSIC Historical SIC Code int(4) %10d comphist_itm->arr.comphist[i].hsic
HSPCINDCD Historical S&P Industry code int(4) %10d comphist_itm->arr.comphist[i].hspcindcd
HSPCSECCD Historical S&P Economic sector code int(4) %10d comphist_itm->arr.comphist[i].hspcseccd
HSTKO Historical stock ownership code int(4) %10d comphist_itm->arr.comphist[i].hstko
HADD1…4 Historical address lines 1-4 char(68) %-68s comphist_itm->arr.comphist[i].haddl#
HADDZIP Historical postal code char(68) %-24s comphist_itm->arr.comphist[i].haddzip
HBUSDESC Historical business description char(2000) %-2000s comphist_itm->arr.comphist[i].hbusdesc
HCIK Historical CIK number char(12) %-12s comphist_itm->arr.comphist[i].hcik
HCITY Historical city char(104) %-104s comphist_itm->arr.comphist[i].hcity
HCONM Historical company name char(256) %-256s comphist_itm->arr.comphist[i].hconm
HCONML Historical legal company name char(104) %-104s comphist_itm->arr.comphist[i].hconml
HCOSTAT Historical active/inactive status marker char(4) %-4s comphist_itm->arr.comphist[i].hcostat
HCOUNTY Historical county code char(104) %-1044s comphist_itm->arr.comphist[i].hcounty
HDLRSN Historical research company reason for deletion char(12) %-12s comphist_itm->arr.comphist[i].hdlrsn
HEIN Historical employer identification number char(12) %-12s comphist_itm->arr.comphist[i].hein
HFAX Historical fax number char(16) %-16s comphist_itm->arr.comphist[i].hfax
HFIC Historical ISO country code / incorporation char(16) %-16s comphist_itm->arr.comphist[i].hfic
HGGROUP Historical GICS group char(12) %-12s comphist_itm->arr.comphist[i].hggroup
HGIND Historical GICS industries char(12) %-12s comphist_itm->arr.comphist[i].hgind
HGSECTOR Historical GICS sector char(12) %-12s comphist_itm->arr.comphist[i].hgsector
HGSUBIND Historical GICS sub-industries char(12) %-12s comphist_itm->arr.comphist[i].hgsubind
HIDBFLAG Historical international, domestic, both indicator char(12) %-12s comphist_itm->arr.comphist[i].hidbflag
HINCORP Historical state/province of incorporation code char(12) %-12s comphist_itm->arr.comphist[i].hincorp
HLOC Historic ISO country code/ headquarters char(4) %-4s comphist_itm->arr.comphist[i].hloc
HNAICS Historical NAICS codes char(8) %-8s comphist_itm->arr.comphist[i].hnaics
HPHONE Historical phone number char(16) %-16s comphist_itm->arr.comphist[i].hphone
HPRICAN Historical primary issue tag - Cananda char(12) %-12s comphist_itm->arr.comphist[i].hprican
HPRIROW Historical primary issue tag – rest of world char(12) %-12s comphist_itm->arr.comphist[i].hprirow
HPRIUSA Historical primary issue tag - US char(12) %-12s comphist_itm->arr.comphist[i].hpriusa
HSTATE Historical state/province char(12) %-12s comphist_itm->arr.comphist[i].hstate
HWEBURL Historical website url char(68) %-68s comphist_itm->arr.comphist[i].hweburl
Back to top

 

Structure - CSTHIST

Csthist field usage assumes an initialized CRSP_ITM csthist_itm attached to the CSTHIST itm_name. Index i in field usage is between 0 and csthist_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
CST_CHGDT CST History effective date int(4) %8d csthist_itm->arr.csthist[i].cst_chgdt
CST_CHGENDDT CST History last effective date int(4) %8d csthist_itm->arr.csthist[i].cst_chgenddt
CST_DNUM CST History industry code int(4) %4d csthist_itm->arr.csthist[i].cst_dnum
CST_FILE CST History file identification code int(4) %4d csthist_itm->arr.csthist[i].cst_file
CST_ZLIST CST History exchange listing and S&P Index code int(4) %4d csthist_itm->arr.csthist[i].cst_zlist
CST_STATE CST History state identification code int(4) %4d csthist_itm->arr.csthist[i].cst_state
CST_COUNTY CST History county identification code int(4) %4d csthist_itm->arr.csthist[i].cst_county
CST_STINC CST History state incorporation code int(4) %4d csthist_itm->arr.csthist[i].cst_stinc
CST_FINC CST History foreign incorporation code int(4) %4d csthist_itm->arr.csthist[i].cst_finc
CST_XREL CST History industry index relative code int(4) %4d csthist_itm->arr.csthist[i].cst_xrel
CST_STK CST History stock ownership code int(4) %4d csthist_itm->arr.csthist[i].cst_stk
CST_DUP CST History duplicate file code int(4) %4d csthist_itm->arr.csthist[i].cst_dup
CST_CCNDX CST History current Canadian index code int(4) %4d csthist_itm->arr.csthist[i].cst_ccndx
CST_GICS CST History Global Industry Classification Standard Code int(4) %4d csthist_itm->arr.csthist[i].cst_gics
CST_IPODT CST History IPO date int(4) %4d csthist_itm->arr.csthist[i].cst_ipodt
CST_FUNDF1 CST History fundamental file identification code 1 int(4) %4d csthist_itm->arr.csthist[i].cst_fund1
CST_FUNDF2 CST History fundamental file identification code 2 int(4) %4d csthist_itm->arr.csthist[i].cst_fundf2
CST_FUNDF3 CST History fundamental file identification code 3 int(4) %4d csthist_itm->arr.csthist[i].cst_fundf3
CST_NAICS CST History North American Industry Classification char(8) %-8s csthist_itm->arr.csthist[i].cst_naics
CST_CPSPIN CST History primary S&P Index marker char(4) %-4s csthist_itm->arr.csthist[i].cst_cpspin
CST_CSSPIN CST History subset S&P Index marker char(4) %-4s csthist_itm->arr.csthist[i].cst_csspin
CST_CSSPII CST History secondary S&P Index marker char(4) %-4s csthist_itm->arr.csthist[i].cst_csspii
CST_SUBDBT CST History current S&P subordinated debt rating char(8) %-8s csthist_itm->arr.csthist[i].cst_subdbt
CST_CPAPER CST History current S&P commercial paper rating char(4) %-4s csthist_itm->arr.csthist[i].cst_cpaper
CST_SDBT CST History current S&P senior debt rating char(4) %-4s csthist_itm->arr.csthist[i].cst_sdbt
CST_SDBTIM CST History current S&P senior debt rating - footnote char(4) %-4s csthist_itm->arr.csthist[i].cst_sdbtim
CST_CNUM CST History CUSIP issuer code char(16) %-16s csthist_itm->arr.csthist[i].cst_cnum
CST_CIC CST History issuer number char(4) %-4s csthist_itm->arr.csthist[i].cst_cic
CST_CONAME CST History company name char(64) %-64s csthist_itm->arr.csthist[i].cst_coname
CST_INAME CST History industry name char(4) %-4s csthist_itm->arr.csthist[i].cst_iname
CST_SMBL CST History stock ticker symbol char(16) %-16s csthist_itm->arr.csthist[i].cst_smbl
CST_EIN CST History employer identification number char(16) %-16s csthist_itm->arr.csthist[i].cst_ein
CST_INCORP CST History incorporation ISO country code char(4) %-4s csthist_itm->arr.csthist[i].cst_incorp
Back to top

 

Link field usage assumes an initialized CRSP_ITM link_itm attached to the LINK itm_name. Index i in field usage is between 0 and link_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
LINKDT Effective date of the link record int(4) %8d link_itm->arr.link[i].linkdt
LINKENDDT Last effective date of the link record int(4) %8d link_itm->arr.link[i].linkenddt
LPERMNO CRSP PERMNO link during link period int(4) %6d link_itm->arr.link[i].lpermno
LPERMCO CRSP PERMCO link during link period int(4) %10d link_itm->arr.link[i].lpermco
LIID Security identifier char(4) %-3s link_itm->arr.link[i].liid
LNKTYPE Link type code char(4) %-4s link_itm->arr.link[i].lnktype
LINKPRIM Primary security link marker char(4) %-1s link_itm->arr.link[i].linkprim
Back to top

 

Structure: LINKUSED

Linkused field usage assumes an initialized CRSP_ITM linkused_itm attached to the LINKUSED itm_name. Index i in field usage is between 0 and linkused_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
ULINKDT Effective date of the link int(4) %8d linkused_itm->arr.linkused[i].ulinkdt
ULINKENDDT Last effective date of the link int(4) %8d linkused_itm->arr.linkused[i].ulinkenddt
ULINKID Linkused row identifier int(4) %d linkused_itm->arr.linkused[i].ulinkid
UGVKEY GVKEY used in the link int(4) %6d linkused_itm->arr.linkused[i].ugvkey
UPERMNO CRSP PERMNO link during link period int(4) %6d linkused_itm->arr.linkused[i].upermno
UPERMCO CRSP PERMCO link during link period int(4) %6d linkused_itm->arr.linkused[i].upermco
UIID Used Security ID char(4) %-3s linkused_itm->arr.linkused[i].uiid
USEDFLAG Flag marking whether link is used in building composite record char(4) %d linkused_itm->arr.linkused[i].usedflag
ULINKPRIM Used link primary marker char(4) %-1s linkused_itm->arr.linkused[i].ulinkprim
ULINKTYPE Used link type char(4) %-4s linkused_itm->arr.linkused[i].ulinktype
Back to top

 

Structure: LINKRNG

Linkrng field usage assumes an initialized CRSP_ITM linkrng_itm attached to the LINKRNG itm_name. Index i in field usage is between 0 and linkrng_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
RLINKID Linkused row identifier int(4) %8d linkrng_itm->arr.linkrng[i].rlinkid
RKEYSET Keyset applicable to range int(4) %8d linkrng_itm->arr.linkrng[i].rkeyset
RCALID Calendar applicable to range int(4) %8d linkrng_itm->arr.linkrng[i].rcalid
RBEGIND Beginning time series range of link int(4) %8d linkrng_itm->arr.linkrng[i].rbegind
RENDIND Ending time series range of link int(4) %8d linkrng_itm->arr.linkrng[i].rendind
RPREVIND Time series range immediately preceding the link int(4) %8d linkrng_itm->arr.linkrng[i].rprevind
RBEGDT Beginning calendar range of link int(4) %8d linkrng_itm->arr.linkrng[i].rbegdt
RENDDT Ending calendar range of link int(4) %8d linkrng_itm->arr.linkrng[i].renddt
RPREVDT Ending calendar range preceding the link int(4) %8d linkrng_itm->arr.linkrng[i].rprevdt
RFISCAL_DATA_FLG Type of time series, C-calendar or F-fiscal. char(8) %-8s linkrng_itm->arr.linkrng[i].rfiscal_data_flg
Back to top

 

Structure: ADJFACT

Adjfact field usage assumes an initialized CRSP_ITM adjfact_itm attached to the ADJFACT itm_name. Index i in field usage is between 0 and adjfact_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
EFFDATE Effective date- company cumulative factor int(4) %10d linkrng_itm->arr.linkrng[i].effdate
THRUDATE Thu date – company cumulative factor int(4) %10d linkrng_itm->arr.linkrng[i].thrudate
ADJEX Cumulative adjustment factor by Ex-date double(8) %18.4f adjfact_itm->arr.adjfact[i].adjex
ADJPAY Cumulative adjustment factor by Pay-date double(8) %18.4f adjfact_itm->arr.adjfact[i].adjpay
Back to top

 

Structure: HGIC

Hgic field usage assumes an initialized CRSP_ITM hgic_itm attached to the HGIC itm_name. Index i in field usage is between 0 and hgic_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
INDFROM Effective from (start) date int(4) %8d hgic_itm->arr.hgic[i].indfrom
INDTHRU Effective through (last) date int(4) %8d hgic_itm->arr.hgic[i].indthru
GGROUPH Industry group name char(12) %-12s hgic_itm->arr.hgic[i].ggrouph
GINDH Group industry char(12) %-12s hgic_itm->arr.hgic[i].gindh
GSECTORH Group industry sector char(12) %-12s hgic_itm->arr.hgic[i].gsectorh
GSUBINDH Group sub-industries char(12) %-12s hgic_itm->arr.hgic[i].gsubindh
Back to top

 

Structure: OFFTITL

Offtitl field usage assumes an initialized CRSP_ITM offtitl_itm attached to the OFFTITL itm_name. Index i in field usage is between 0 and offtitl_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
OFID Officer ID int(4) %9d offtitl_itm->arr.offtitl[i].ofid
OFCD Officer title char(16) %-8s offtitl_itm->arr.offtitl[i].ofcd
OFNM Officer Name(s) char(40) %-39s offtitl_itm->arr.offtitl[i].ofnm
Back to top

 

Structure: CCM_FILEDATE

Ccm_filedate field usage assumes an initialized CRSP_ITM ccm_filedate_itm attached to the CCM_FILEDATE itm_name. Index i in field usage is between 0 and ccm_filedate_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
FDATADATE Company filing data date int(4) %8d ccm_filedate_itm->arr.ccm_filedate[i].fdatadate
FCONSOL Company consolidation level filedate char(2) %-2s ccm_filedate_itm->arr.ccm_filedate[i].fconsol
FPOPSRC Population source filedate char(2) %-2s ccm_filedate_itm->arr.ccm_filedate[i].fpopsrc
SRCTYPE Document source type filedate char(12) %-12s ccm_filedate_itm->arr.ccm_filedate[i].srctype
FILEDATE Company filing date int(4) %8d ccm_filedate_itm->arr.ccm_filedate[i].filedate
Back to top

 

Structure: CCM_IPCD

Ccm_ipcd field usage assumes an initialized CRSP_ITM ccm_ipcd_itm attached to the CCM_IPCD itm_name. Index i in field usage is between 0 and ccm_ipcd_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
IPDATADATE Industry presentation code data date int(4) %8d ccm_ipcd_itm->arr.ccm_ipcd[i].ipdatadate
IPCONSOL Level of consolidation (Industry presentation code) char(2) %-1s ccm_ipcd_itm->arr.ccm_ipcd[i].ipconsol
IPPOPSRC Population source (Industry presentation code) char(2) %-1s ccm_ipcd_itm->arr.ccm_ipcd[i].ippopsrc
IPCD Industry presentation code char(2) %-1s ccm_ipcd_itm->arr.ccm_ipcd[i].ipcd
Back to top

 

Structure: SECURITY

Mnemonic Field Name Internal Storage Display Format Field Usage
EXCHG Stock exchange int(4) %4d security_itm->arr.security->exchg
DLDTEI Security inactivation date int(4) %8d security_itm->arr.security->dltei
IID_SEQ_ NUM IID sequence number int(4) %8d security_itm->arr.security->iid_seq_num
SBEGDT First date of Compustat data for issue int(4) %8d security_itm->arr.security->sbegdt
SENDDT Last date of Compustat data for issue int(4) %8d security_itm->arr.security->senddt
IID Issue ID char(4) %-3s security_itm->arr.security->iid
SCUSIP CUSIP char(12) %-12s security_itm->arr.security->cusip
DLRSNI Security inactivation code char(12) %-8s security_itm->arr.security->dlrsni
DSCI Security description char(32) %-28s security_itm->arr.security->dsci
EPF Earnings participation flag char(4) %-1s security_itm->arr.security->epf
EXCNTRY Stock exchange country code char(4) %-3s security_itm->arr.security->excntry
ISIN International security identification number char(16) %-12s security_itm->arr.security->isin
SSECSTAT Security status marker char(4) %-4s security_itm->arr.security->ssecstat
SEDOL SEDOL char(8) %-7s security_itm->arr.security->sedol
TIC Ticker/trading symbol char(12) %-8s security_itm->arr.security->tic
TPCI Issue type char(12) %-8s security_itm->arr.security->tpci
Back to top

 

Structure: SECHIST

Sechist field usage assumes an initialized CRSP_ITM sechist_itm attached to the SECHIST itm_name. Index i in field usage is between 0 and sechist_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
HSCHGDT Historical security change date int(4) %8d sechist_itm->arr.sechist[i].hschgdt
HSCHGENDDT Historical security change end date int(4) %8d sechist_itm->arr.sechist[i].hschgenddt
HEXCHG Historical stock exchange int(4) %10d sechist_itm->arr.sechist[i].hexchg
HDLDTEI Historical security inactivation date int(4) %8d sechist_itm->arr.sechist[i].hdldtei
HIID_SEQ_NUM Historical issue ID sequence number int(4) %10d sechist_itm->arr.sechist[i].hiid_seq_num
HIID Historical issue ID char(4) %-3s sechist_itm->arr.sechist[i].hiid
HSCUSIP Historical CUSIP char(12) %-12s sechist_itm->arr.sechist[i].hscusip
HDLRSNI Historical security inactivation code char(12) %-12s sechist_itm->arr.sechist[i].hdhdrsni
HDSCI Historical security description char(32) %-32s sechist_itm->arr.sechist[i].hdsci
HEPF Historical earnings participation flag char(4) %-4s sechist_itm->arr.sechist[i].hepf
HEXCNTRY Historical stock exchange country code char(4) %-4s sechist_itm->arr.sechist[i].hexcntry
HISIN Historical international security identification number char(16) %-16s sechist_itm->arr.sechist[i].hisin
HSSECSTAT Historical security status marker char(4) %-4s sechist_itm->arr.sechist[i].hssecstat
HSEDOL Historical SEDOL char(8) %-8s sechist_itm->arr.sechist[i]hsedol.
HTIC Historical ticker/trading symbol char(12) %-12s sechist_itm->arr.sechist[i].htic
HTPCI Historical issue type char(12) %-12s sechist_itm->arr.sechist[i].htpci
Back to top

 

Structure: SEC_MTHSPT

Sec_mthspt field usage assumes an initialized CRSP_ITM sec_mthspt_itm attached to the MTHSPT itm_name. Index i in field usage is between 0 and mthspt_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
DATADATEM Monthly adjustment factor data date int(4) %10d sec_mthspt_itm->arr.sec_mthspt[i].datadatem
RAWPM Raw adjustment factor – pay date - monthly double(8) %18.4lf sec_mthspt_itm->arr.sec_mthspt[i].rawpm
RAWXM Raw adjustment factor – ex date - monthly double(8) %18.4lf sec_mthspt_itm->arr.sec_mthspt[i].rawxm
Back to top

 

Structure: SEC_MSPT_FN

Sec_mspt_fn field usage assumes an initialized CRSP_ITM sec_smpt_fn_itm attached to the SEC_MSPT_FN itm_name. Index i in field usage is between 0 and sec_mspt_fn_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
DATADATEMF Monthly adjustment factor footnote data date int(4) %10d sec_mspt_fn_itm->arr.sec_mspt_fn[i].datadatemf
DATAITEMMF Monthly split footnote dataitem char(8) %-8s sec_mspt_fn_itm->arr.sec_mspt_fn[i].dataitemmf
RAWPM_FN1..FN5 Raw adjustment factor – pay date – monthly – footnotes 1-5 char(4) %-4s sec_mspt_fn_itm->arr.sec_mspt_fn[i].rawpm_fn1..fn5
RAWXM_FN1..FN5 Raw adjustment factor – ex date – monthly – footnotes 1-5 char(4) %-4s sec_mspt_fn_itm->arr.sec_mspt_fn[i].rawxm_fn1..fn5
Back to top

 

Structure: SEC_MDIV_FN

Sec_mdiv_fn field usage assumes an initialized CRSP_ITM sec_mdiv_fn_itm attached to the SEC_MDIV_FN itm_name. Index i in field usage is between 0 and sec_mdiv_fn_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
DIVDATADATEMF Monthly dividend footnote data date int(4) %10d sec_mdiv_fn_itm->arr.sec_mdiv_fn[i].divdatadatemf
DIVDATAITEMMF Monthly dividend footnote data item char(8) %-8s sec_mdiv_fn_itm->arr.sec_mdiv_fn[i].divdataitemmf
DVPSPM_FN1..FN5 Dividend per share – pay date – monthly – footnotes 1-5 char(4) %-4s sec_mdiv_fn_itm->arr.sec_mdiv_fn[i].dvpspm_fn1..fn5
DVPSXM_FN1..FN5 Dividend per share – ex date – monthly – footnotes 1-5 char(4) %-4s sec_mdiv_fn_itm->arr.sec_mdiv_fn[i].dvpsxm_fn1..fn5
Back to top

 

Structure: SEC_SPIND

Sec_spind field usage assumes an initialized CRSP_ITM sec_spind_itm attached to the SEC_SPIND itm_name. Index i in field usage is between 0 and sec_spind_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SPBEGDATE S&P Index event beginning date int(4) %10d sec_spind_itm->arr.sec_spind[i].spbegdate
SPENDDATE S&P Index event ending date int(4) %10d sec_spind->arr.sec_spind[i].spenddate
SPHIID S&P holdings industry index ID int(4) %4d sec_spind_itm->arr.sec_spind[i].sphiid
SPHMID S&P holdings major index ID int(4) %4d sec_spind->arr.sec_spind[i].sphmid
SPHSEC S&P holdings sector code int(4) %4d sec_spind_itm->arr.sec_spind[i].sphsec
SPH100 S&P holdings S&P 100 marker int(4) %4d sec_spind->arr.sec_spind[i].sph100
SPHCUSIP S&P holdings CUSIP char(12) %-9s sec_spind_itm->arr.sec_spind[i].sphcusip
SPHNAME S&P holdings name char(36) %-31s sec_spind->arr.sec_spind[i].sphname
SPHTIC S&P holdings ticker char(12) %-8s sec_spind_itm->arr.sec_spind[i].sphtic
SPHVG S&P holdings value/growth indicator char(4) %-1s sec_spind->arr.sec_spind[i].sphvg
Back to top

 

Structure: IDXCST_HIS

Idxcst_his field usage assumes an initialized CRSP_ITM idx_csthis_itm attached to the IDX_CSTHIS itm_name. Index i in field usage is between 0 and idx_csthis_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
XFROM S&P constituent from event date int(4) %10d idx_csthis_itm->arr.idx_csthis[i].xfrom
IDX13KEY S&P 13 character key char(16) %-13s Idx_csthis->arr.idx_csthis[i].idx13key
XGVKETX S&P constituent event index GVKEY int(4) %10d Idx_csthisitm->arr.idx_csthis[i].xgvkeyx
Back to top

 

Structure: SPIDX_CST

Spidx_cst field usage assumes an initialized CRSP_ITM spidx_cst_itm attached to the SPIDX_CST itm_name. Index i in field usage is between 0 and spidx_cst_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SXBEGDATE S&P constituent event beginning date int(4) %10d spidx_cst_itm->arr.spidx_cst[i].sxbegdate
SXENDDATE S&P constituent event ending date int(4) %10d spidx_cst_itm->arr.spidx_cst[i].sxenddate
SPFLOAT S&P float shares int(4) %4d spidx_cst_itm->arr.spidx_cst[i].spfloat
INDEXID S&P major index ID char(12) %-10s spidx_cst_itm->arr.spidx_cst[i].indexid
EXCHGX S&P constituent exchange char(8) %-4s spidx_cst_itm->arr.spidx_cst[i].exchgx
TICX S&P holdings ticker char(12) %-10s spidx_cst_itm->arr.spidx_cst[i].ticx
CUSIPX S&P constituent CUSIP char(12) %-9s spidx_cst_itm->arr.spidx_cst[i].cusipx
CONMX S&P constituent name char(44) %-40s spidx_cst_itm->arr.spidx_cst[i].conmx
CONTYPE S&P constituent type char(12) %-10s spidx_cst_itm->arr.spidx_cst[i].contype
CONVAL S&P constituent value char(12) %-10s spidx_cst_itm->arr.spidx_cst[i].conval
Back to top

 

Structure: CCM_SEGCUR

Ccm_segcur field usage assumes an initialized CRSP_ITM ccm_segcur_itm attached to the CCM_SEGCUR itm_name. Index i in field usage is between 0 and ccm_segcur_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SC_DATAYR Data year int(4) %4d ccm_segcur_itm->arr.ccm_segcur[i].sc_datayr
SC_DATAFYR Data fiscal year end month int(4) %2d ccm_segcur_itm->arr.ccm_segcur[i].sc_datafyr
SC_CALYR Data calendar year int(4) %4d ccm_segcur_itm->arr.ccm_segcur[i].sc_calyr
SC_SRCYFYR Source fiscal year end month int(4) %2d ccm_segcur_itm->arr.ccm_segcur[i].sc_srcfyr
SC_XRATE Period end exchange rate double(8) %16.8f ccm_segcur_itm->arr.ccm_segcur[i].sc_xrate
SC_XRATE12 12-month moving exchange rate double(8) %16.8f ccm_segcur_itm->arr.ccm_segcur[i].sc_xrate12
SC_SRCCUR Source currency code char(4) %-3s ccm_segcur_itm->arr.ccm_segcur[i].sc_srccur
SC_CURCD ISO currency code (USD) char(4) %-3s ccm_segcur_itm->arr.ccm_segcur[i].sc_curcd
Back to top

 

Structure: CCM_SEGSRC

Ccm_segsrc field usage assumes an initialized CRSP_ITM ccm_segsrc_itm attached to the CCM_SEGSRC itm_name. Index i in field usage is between 0 and ccm_segsrc_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SS_SRCYR Source year int(4) %4d ccm_segsrc_itm->arr.ccm_segsrc[i].ss_srcyr
SS_SRCFYR Source fiscal year end month int(4) %2d ccm_segsrc_itm->arr.ccm_segsrc[i].ss_srcfyr
SS_CALYR Data calendar year int(4) %4d ccm_segsrc_itm->arr.ccm_segsrc[i].ss_calyr
SS_RCST1 Reserved 1 int(4) %4d ccm_segsrc_itm->arr.ccm_segsrc[i].ss_rcst1
SS_SSRCE Source document code char(4) %-2s ccm_segsrc_itm->arr.ccm_segsrc[i].ss_ssrce
SS_SUCODE Source update code char(4) %-2s ccm_segsrc_itm->arr.ccm_segsrc[i].ss_sucode
SS_CURCD ISO currency code char(4) %-3s ccm_segsrc_itm->arr.ccm_segsrc[i].ss_curcd
SS_SRCCUR Source ISO currency code char(4) %-3s ccm_segsrc_itm->arr.ccm_segsrc[i].ss_srccur
SS_HNAICS Segment primary historical NAICS char(8) %-6s ccm_segsrc_itm->arr.ccm_segsrc[i].ss_hnaics
Back to top

 

Structure: CCM_SEGPROD

Ccm_segprod field usage assumes an initialized CRSP_ITM ccm_segprod_itm attached to the CCM_SEGPROD itm_name. Index i in field usage is between 0 and ccm_segprod_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SP_SRCYR Source year int(4) %4d ccm_segprod_itm->arr.ccm_segprod[i].sp_srcyr
SP_SRCFYR Source fiscal year end month int(4) %2d ccm_segprod_itm->arr.ccm_segprod[i].sp_srcfyr
SP_PDID Product identifier int(4) %4d ccm_segprod_itm->arr.ccm_segprod[i].sp_pdid
SP_PSID Segment link – segment identifier int(4) %4d ccm_segprod_itm->arr.ccm_segprod[i].sp_psid
SP_PSALE External revenues float(4) %10.4f ccm_segprod_itm->arr.ccm_segprod[i].sp_psale
SP_RCST1 Reserved 1 float(4) %10.4f ccm_segprod_itm->arr.ccm_segprod[i].sp_rcst1
SP_PNAICS Product NAICS code char(8) %-6s ccm_segprod_itm->arr.ccm_segprod[i].sp_pnaics
SP_PSTYPE Segment link- segment type char(16) %-83s ccm_segprod_itm->arr.ccm_segprod[i].sp_pstype
SP_PNAME Product name char(64) %-64.64s ccm_segprod_itm->arr.ccm_segprod[i].sp_pname
Back to top

 

Structure: CCM_SEGCUST

Ccm_segcust field usage assumes an initialized CRSP_ITM ccm_segcust_itm attached to the CCM_SEGCUST itm_name. Index i in field usage is between 0 and ccm_segcust_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SC_SRCYR Source year int(4) %4d ccm_segcust_itm->arr.ccm_segcust[i].sc_srcyr
SC_SRCFYR Source fiscal year end month int(4) %2d ccm_segcust_itm->arr.ccm_segcust[i].sc_srcfyr
SC_CDID customer identifier int(4) %4d ccm_segcust_itm->arr.ccm_segcust[i].sc_cdid
SC_CSID Segment link – segment identifier int(4) %4d ccm_segcust_itm->arr.ccm_segcust[i].sc_csid
SC_CSALE customer revenues float(4) %10.4f ccm_segcust_itm->arr.ccm_segcust[i].sc_csale
SC_RCST1 Reserved 1 int(4) %4d ccm_segcust_itm->arr.ccm_segcust[i].sc_rcst1
SC_CTYPE Customer type char(16) %-8s ccm_segcust_itm->arr.ccm_segcust[i].sc_ctype
SC_CGEOCD Geographic area code char(16) %-8s ccm_segcust_itm->arr.ccm_segcust[i].sc_cgeocd
SC_CGEOAR Geographic area type char(16) %-8s ccm_segcust_itm->arr.ccm_segcust[i].sc_cgeoar
SC_CSTYPE Segment link – segment type char(16) %-8s ccm_segcust_itm->arr.ccm_segcust[i].sc_cstype
SC_CNAME Customer name data char(64) %-64.64s ccm_segcust_itm->arr.ccm_segcust[i].sc_cname
Back to top

 

Structure: CCM_SEGDTL

Ccm_segdtl field usage assumes an initialized CRSP_ITM ccm_segdtl_itm attached to the CCM_SEGDTL itm_name. Index i in field usage is between 0 and ccm_segdtl_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SD_SRCYR Source year int(4) %4d ccm_segdtl_itm->arr.ccm_segdtl[i].sd_srcyr
SD_SRCFYR Source fiscal year end month int(4) %2d ccm_segdtl_itm->arr.ccm_segdtl[i].sd_srcfyr
SD_SID Segment identifier int(4) %4d ccm_segdtl_itm->arr.ccm_segdtl[i].sd_sid
SD_RCST1 Reserved 1 int(4) %4d ccm_segdtl_itm->arr.ccm_segdtl[i].sd_rcst1
SD_STYPE Segment type char(16) %-8s ccm_segdtl_itm->arr.ccm_segdtl[i].sd_stype
SD_SOPTP1 Operating segment type 1 char(16) %-8s ccm_segdtl_itm->arr.ccm_segdtl[i].sd_ctype
SD_SOPTP2 Operating segment type char(16) %-8s ccm_segdtl_itm->arr.ccm_segdtl[i].sd_cgeocd
SD_SGEOTP Geographic segment type char(16) %-8s ccm_segdtl_itm->arr.ccm_segdtl[i].sd_cgeoar
SD_SNAME Segment name char(256) %-64.64s ccm_segdtl_itm->arr.ccm_segdtl[i].sd_cname
Back to top

 

Structure: CCM_SEGITM

Ccm_segitm field usage assumes an initialized CRSP_ITM ccm_segitm_itm attached to the CCM_SEGITM itm_name. Index i in field usage is between 0 and ccm_segitm_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SI_DATYR Data year int(4) %4d ccm_segitm_itm->arr.ccm_segitm[i].si_datyr
SI_FISCYR Data fiscal year end month int(4) %4d ccm_segitm_itm->arr.ccm_segitm[i].si_fiscyr
SI_SRCYR Source year int(4) %4d ccm_segitm_itm->arr.ccm_segitm[i].si_srcyr
SI_SRCFYR Source fiscal year end month int(4) %2d ccm_segitm_itm->arr.ccm_segitm[i].si_crsfyr
SI_CALYR Data calendar year int(4) %4d ccm_segitm_itm->arr.ccm_segitm[i].si_calyr
SI_SID Segment identifier int(4) %4d ccm_segitm_itm->arr.ccm_segitm[i].si_sid
SI_EMP Employees int(4) %9d ccm_segitm_itm->arr.ccm_segitm[i].si_emp
SI_SALE Net sales float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_sale
SI_OIBD Operating income before depreciations float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_oibd
SI_DP Depreciation & amortization float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_dp
SI_OIAD Operating income after depreciation float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_oiad
SI_CAPX Capital expenditures float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_capx
SI_IAT Identifiable assets float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_iat
SI_EQEARN Equity in earnings float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_eqearn
SI_INVEQ Investments at equity float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_inveq
SI_RD Research & development float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_rd
SI_OBKLG Order backlog float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_obklg
SI_EXPORTS Export sales float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_exports
SI_INTSEG Inter-segment eliminations int(4) %4d ccm_segitm_itm->arr.ccm_segitm[i].si_intseg
SI_OPINC Operating profit float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_opinc
SI_PI Pretax income float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_pi
SI_IB Income before extraordinary earnings float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_ib
SI_NI Net income (loss) float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_ni
SI_RCST1 Reserved 1 float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_rcst1
SI_RCST2 Reserved 2 float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_rcst2
SI_RCST3 Reserved 3 float(4) %10.4f ccm_segitm_itm->arr.ccm_segitm[i].si_rcst3
SI_SALEF Footnote 1 - sales char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_salef
SI_OPINCF Footnote 2 – operating profit char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_opincf
SI_CAPXF Footnote 3 – capital expenditures char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_capxf
SI_EQEARNF Footnote 4 – equity in earnings char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_eqearnf
SI_EMPF Footnote 5 - employees char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_empf
SI_RDF Footnote 6 – research & development char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_rdf
SI_STYPE Segment type char(16) %-8s ccm_segitm_itm->arr.ccm_segitm[i].si_stype
Back to top

 

Structure: CCM_SEGNAICS

Ccm_segnaics field usage assumes an initialized CRSP_ITM ccm_segnaics_itm attached to the CCM_SEGNAICS itm_name. Index i in field usage is between 0 and ccm_segnaics_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SN_SRCYR Source year int(4) %4d ccm_segnaics_itm->arr.ccm_segnaics[i].sn_srcyr
SN_SRCFYR Source fiscal year end month int(4) %2d ccm_segnaics_itm->arr.ccm_segnaics[i].sn_srcfyr
SN_SID Segment identifier int(4) %4d ccm_segnaics_itm->arr.ccm_segnaics[i].sn_sid
SN_RCST1 Reserved 1 int(4) %4d ccm_segnaics_itm->arr.ccm_segnaics[i].sn_rcst1
SN_STYPE Segment type char(16) %-8s ccm_segnaics_itm->arr.ccm_segnaics[i].sn_stype
SN_SNAICS NAICS code char(8) %-6s ccm_segnaics_itm->arr.ccm_segnaics[i].sn_snaics
SN_RANK Ranking int(4) %4d ccm_segnaics_itm->arr.ccm_segnaics[i].sn_rank
SN_SIC Segment SIC code int(4) %4d ccm_segnaics_itm->arr.ccm_segnaics[i].sn_sic
Back to top

 

Structure: CCM_SEGGEO

Ccm_seggeo field usage assumes an initialized CRSP_ITM ccm_seggeo_itm attached to the CCM_SEGGEO itm_name. Index i in field usage is between 0 and ccm_seggeo_itm-> obj.arr->num -1.

Mnemonic Field Name Internal Storage Display Format Field Usage
SG_SRCYR Source year int(4) %4d ccm_seggeo_itm->arr.ccm_seggeo[i].sg_srcyr
SG_SRCFYR Source fiscal year end month int(4) %2d ccm_seggeo_itm->arr.ccm_seggeo[i].sg_srcfyr
SG_SID Segment identifier int(4) %4d ccm_seggeo_itm->arr.ccm_seggeo[i].sg_sid
SG_RCST1 Reserved 1 int(4) %4d ccm_seggeo_itm->arr.ccm_seggeo[i].sg_rcst1
SG_STYPE Segment type char(16) %-8s ccm_seggeo_itm->arr.ccm_seggeo[i].sg_stype
SG_SGEOCD Geographic area code char(16) %-8s ccm_seggeo_itm->arr.ccm_seggeo[i].sg_sgeocd
SG_SGEOTP Geographic area type char(16) %-8s ccm_seggeo_itm->arr.ccm_seggeo[i].sg_sgeotp
Back to top