| compheader | |
| Variable Name | Description |
| weburl | Website Address |
| stko | Stock Ownership Code |
| state | State/Province |
| spcseccd | S&P Economic Sector Code - Reference |
| spcindcd | S&P Industry Sector Code - Reference |
| sic | SIC Code |
| priusa | Primary Issue Tag - USA |
| prirow | Primary Issue Tag - Rest of World |
| prican | Primary Issue Tag - Canada |
| phone | Phone Number |
| naics | North American Industry Classification Code |
| loc | ISO Country Code / Headquarters |
| ipodate | Company Initial Public Offering Date |
| incorp | State/Province of Incorporation Code |
| idbflag | International/Domestic/Both Indicator |
| gvkey | Standard and Poor\'\'s Identifier |
| gsubind | GICS Sub-industries |
| gsector | GICS Sectors |
| gind | GICS Industries |
| ggroup | GICS Groups |
| fyrc | Fiscal Year End |
| fic | ISO Country Code of Incorporation |
| fax | Fax Number |
| ein | Employer Identification Number |
| dlrsn | Research Company Reason for Deletion |
| dldte | Research Company Deletion Date |
| county | County Code |
| costat | Postal Code |
| conml | Company Legal Name |
| conm | Company Name |
| city | City |
| cik | CIK Number |
| busdesc | Business Description |
| addzip | Postal Code |
| add4 | Address Lines 4 |
| add3 | Address Lines 3 |
| add2 | Address Lines 2 |
| add1 | Address Lines 1 |
| compmaster | |
| Variable Name | Description |
| begyr | Annual date of earlist data (yyyy) |
| cbegdt | First date of Compustat data |
| ccmid | Permanent record identifier for Compustat company or index data, represents GVKEY for company, GVKEYX for index |
| ccmidtype | Type of key for Compustat data. 1 = company data, 2 = index data |
| cenddt | Last date of Compustat data |
| endyr | Annual date of last data (yyyy) |
| qbegqtr | Quarterly date of earlist data (q) |
| qbegyr | Quarterly date of earlist data (yyyy) |
| qendqtr | Quarterly date of last data (q) |
| qendyr | Quarterly date of last data (yyyy) |
| comphistory | |
| Variable Name | Description |
| gvkey | Standard and Poor\'\'s Identifier |
| hadd1 | Historical Address Lines 1 |
| hadd2 | Historical Address Lines 2 |
| hadd3 | Historical Address Lines 3 |
| hadd4 | Historical Address Lines 4 |
| haddzip | Historical Postal Code |
| hbusdesc | Historical Business Description |
| hchgdt | Comphist description effective date |
| hchgenddt | Comphist description last effective date |
| hcik | Historical CIK Number |
| hcity | Historical City |
| hconm | Historical Company Name |
| hconml | Historical Company Legal Name |
| hcostat | Historical Postal Code |
| hcounty | Historical County Code |
| hdldte | Historical Research Company Deletion Date |
| hdlrsn | Historical Research Company Reason for Deletion |
| hein | Historical Employer Identification Number |
| hfax | Historical Fax Number |
| hfic | Historical ISO Country Code of Incorporation |
| hfyrc | Historical Fiscal Year End |
| hggroup | Historical GICS Groups |
| hgind | Historical GICS Industries |
| hgsector | Historical GICS Sectors |
| hgsubind | Historical GICS Sub-industries |
| hidbflag | Historical International/Domestic/Both Indicator |
| hincorp | Historical State/Province of Incorporation Code |
| hipodate | Historical Company Initial Public Offering Date |
| hloc | Historical ISO Country Code / Headquarters |
| hnaics | Historical North American Industry Classification Code |
| hphone | Historical Phone Number |
| hprican | Historical Primary Issue Tag - Canada |
| hprirow | Historical Primary Issue Tag - Rest of World |
| hpriusa | Historical Primary Issue Tag - USA |
| hsic | Historical SIC Code |
| hspcindcd | Historical S&P Industry Sector Code - Reference |
| hspcseccd | Historical S&P Economic Sector Code - Reference |
| hstate | Historical State/Province |
| hstko | Historical Stock Ownership Code |
| hweburl | Historical Website Address |
| cst_history | |
| Variable Name | Description |
| ccndx | CST History Current Canadian Index Code |
| chgdt | CST History Effective Date |
| chgenddt | CST History Last Effective Date |
| cic | CST History Issuer Number |
| cnum | CST History CUSIP Issuer Code |
| coname | CST History Company Name |
| country | CST History County Identification Code |
| cpaper | CST History Current S and P Commercial Paper Rating |
| cpspin | CST History Primary S and P Index Marker |
| csspii | CST History Subset S and P Index Marker |
| csspin | CST History Secondary S and P Index Marker |
| dnum | CST History Industry Code |
| dup | CST History Duplicate File Code |
| ein | CST History Employer Identification Number |
| file | CST History File Identification Code |
| finc | CST History Foreign Incorporation Code |
| fundf1 | CST History Fundamental File Identification Code 1 |
| fundf2 | CST History Fundamental File Identification Code 2 |
| fundf3 | CST History Fundamental File Identification Code 3 |
| gics | CST History Global Industry Classification Standard Code |
| gvkey | Gvkey |
| iname | CST History Industry Name |
| incorp | CST History Incorporation ISO Country Code |
| ipodt | CST History IPO Date |
| naics | CST History North American Industry Classification |
| sdbt | CST History Current S and P Senior Debt Rating |
| sdbtim | CST History Current S and P Senior Debt Rating - Footnote |
| smbl | CST History Stock Ticker Symbol |
| state | CST History State Identification Code |
| stinc | CST History State Incorporation Code |
| stk | CST History Stock Ownership Code |
| subdt | CST History Current S and P Suboordinated Debt RAting |
| xrel | CST History Industry Index Relative Code |
| zlist | CST History Echange Listing + S and P Index Code |
| Sechead | |
| Variable Name | Description |
| dldtei | Security Inactivation Date |
| dlrsni | Security Inactivation Code |
| dsci | Security Description |
| epf | Earnings Participation Flag |
| exchg | Stock Exchange |
| excntry | Stock Exchange Country Code |
| gvkey | Standard and Poor\'\'s Identifier |
| iid | Issue ID |
| iid_seq_num | IID Sequence Number |
| isin | International Security Identification Number |
| sbegdt | First Date of Compustat Data for issue |
| scusip | CUSIP |
| sedol | SEDOL |
| senddt | Last Date of Compustat Data for issue |
| ssecstat | Security Status Marker |
| tic | Ticker/Trading Symbol |
| tpci | Issue Type |
| sechist | |
| Variable Name | Description |
| gvkey | Standard and Poor\'\'s Identifier |
| hdldtei | Historical Security Inactivation Date |
| hdlrsni | Historical Security Inactivation Code |
| hdsci | Historical Security Description |
| hepf | Historical Earnings Participation Flag |
| hexchg | Historical Stock Exchange |
| hexcntry | Historical Stock Exchange Country Code |
| hiid | Historical Issue ID |
| hiid_seq_num | Historical IID Sequence Number |
| hisin | Historical International Security Identification Number |
| hschgdt | Historical Security Change Date |
| hschgenddt | Historical Security Change End Date |
| hscusip | Historical CUSIP |
| hsedol | Historical SEDOL |
| hssecstat | Historical Security Status Marker |
| htic | Historical Ticker/Trading Symbol |
| htpci | Historical Issue Type |
| iid | Issue ID |