Security Data

SECURITY Defined Structure

The SECURITY structure contains security level header data.

Mnemonic Field Name Format
EXCHG Stock exchange integer
DLDTEI Security inactivation date integer
IID_SEQ_ NUM IID sequence number integer
SBEGDT First date of Compustat data for issue integer
SENDDT Last date of Compustat data for issue integer
IID Issue ID character
SCUSIP CUSIP character
DLRSNI Security inactivation code character
DSCI Security description character
EPF Earnings participation flag character
EXCNTRY Stock exchange country code character
ISIN International security identification number character
SSECSTAT Security status marker character
SEDOL SEDOL character
TIC Ticker/trading symbol character
TPCI Issue type character

SECHIST Defined Structure

The SECHIST structure contains security header history data.

Mnemonic Field Name Format
HSCHGDT Historical security change date integer
HSCHGENDDT Historical security change end date integer
HEXCHG Historical stock exchange integer
HDLDTEI Historical security inactivation date integer
HIID_SEQ_NUM Historical issue ID sequence number integer
HIID Historical issue ID character
HSCUSIP Historical CUSIP character
HDLRSNI Historical security inactivation code character
HDSCI Historical security description character
HEPF Historical earnings participation flag character
HEXCNTRY Historical stock exchange country code character
HISIN Historical international security identification number character
HSSECSTAT Historical security status marker character
HSEDOL Historical SEDOL character
HTIC Historical ticker/trading symbol character
HTPCI Historical issue type character

SEC_MTHSPT Defined Structure

The SEC_MTHSPT structure contains security monthly split event data.

Mnemonic Field Name Format
DATADATEM Monthly adjustment factor data date integer
RAWPM Raw adjustment factor – pay date - monthly floating point double precision
RAWXM Raw adjustment factor – ex date - monthly floating point double precision

SEC_MSPT_FN Defined Structure

The SEC_MSPT_FN structure contains security monthly split event footnotes.

Mnemonic Field Name Format
DATADATEMF Monthly adjustment factor footnote data date integer
DATAITEMMF Monthly split footnote dataitem character
RAWPM_FN1..FN5 Raw adjustment factor – pay date – monthly – footnotes 1-5 character
RAWXM_FN1..FN5 Raw adjustment factor – ex date – monthly – footnotes 1-5 character

SEC_MDIV_FN Defined Structure

The SEC_MDIV_FN structure contains security monthly dividend event footnotes.

Mnemonic Field Name Format
DIVDATADATEMF Monthly dividend footnote data date integer
DIVDATAITEMMF Monthly dividend footnote data item character
DVPSPM_FN1..FN5 Dividend per share – pay date – monthly – footnotes 1-5 character
DVPSXM_FN1..FN5 Dividend per share – ex date – monthly – footnotes 1-5 character

SEC_SPIND Defined Structure

The SEC_SPIND structure contains data associated with security S&P Industry events.

Mnemonic Field Name Format
SPBEGDATE S&P Index event beginning date integer
SPENDDATE S&P Index event ending date integer
SPHIID S&P holdings industry index ID integer
SPHMID S&P holdings major index ID integer
SPHSEC S&P holdings sector code integer
SPH100 S&P holdings S&P 100 marker integer
SPHCUSIP S&P holdings CUSIP character
SPHNAME S&P holdings name character
SPHTIC S&P holdings ticker character
SPHVG S&P holdings value/growth indicator character

IDXCST_HIS Defined Structure

The IDXCST_HIS structure contains security historical industry constituent data.

Mnemonic Field Name Format
XFROM S&P constituent from event date integer
IDX13KEY S&P 13 character key character
XGVKETX S&P constituent event index GVKEY integer

SPIDX_CST Defined Structure

The SPIDX_CST structure contains security S&P index constituent events.

Mnemonic Field Name Format
SXBEGDATE S&P constituent event beginning date integer
SXENDDATE S&P constituent event ending date integer
SPFLOAT S&P float shares integer
INDEXID S&P major index ID character
EXCHGX S&P constituent exchange character
TICX S&P holdings ticker character
CUSIPX S&P constituent CUSIP character
CONMX S&P constituent name character
CONTYPE S&P constituent type character
CONVAL S&P constituent value character