Obs ItemName ItemHdr XpressfeedMnemonic CRSP Long Name Description/Full Compustat Name ItemNameType
1 KYGVKEY GVKEY N/A Global Company Key - Key Selection Global Company Key - Key Selection NA
2 HCHGDT HCHGDT CHGDT effective date of this description effective date of this description HS
3 HCHGENDDT HCHGENDDT CHGENDDT last effective date of this description last effective date of this description HS
4 LPERMNO LPERMNO Link Permno PERMNO from link; 0 is used for a missing or not applicable link LD
5 LPERMCO LPERMCO Link Permco PERMCO from link; 0 is used for a missing or not applicable link LD
6 LINKRANGETYPECD LINKRANGETYPECD Link Link Range Type Code Not in Compustat documentation LD
7 HCIK HCIK CIK Historical CIK Number Historical CIK Number HS
8 HEIN HEIN EIN Historical Employer Identification Number Historical Employer Identification Number HS
9 HSTKO HSTKO STKO Historical Stock Ownership Code Historical Stock Ownership Code HS
10 HCONM HCONM CONM Historical Company Name Historical Company Name HS
11 HFYRC HFYRC FYRC Historical Fiscal Year-end Month / Current Historical Fiscal Year-end Month / Current HS
12 HCOSTAT HCOSTAT COSTAT Historical Active/Inactive Status Marker Historical Active/Inactive Status Marker HS
13 HIPODATE HIPODATE IPODATE Historical Company Initial Public Offering Date Historical Company Initial Public Offering Date HS
14 HDLDTE HDLDTE DLDTE Historical Research Company / Deletion Date Historical Research Company / Deletion Date HS
15 HDLRSN HDLRSN DLRSN Historical Research Company Reason for Deletion Historical Research Company Reason for Deletion HS
16 HPRIUSA HPRIUSA PRIUSA Historical Primary Issue Tag / US Historical Primary Issue Tag / US HS
17 HPRICAN HPRICAN PRICAN Historical Primary Issue Tag / Canada Historical Primary Issue Tag / Canada HS
18 HPRIROW HPRIROW PRIROW Historical Primary Issue Tag / Rest of World Historical Primary Issue Tag / Rest of World HS
19 HIDBFLAG HIDBFLAG IDBFLAG Historical International, Domestic, Both Indicator Historical "International, Domestic, Both Indicator" HS
20 HFIC HFIC FIC Historical ISO Country Code / Incorporation Historical ISO Country Code / Incorporation HS
21 HLOC HLOC LOC Historical ISO Country Code / Headquarters Historical ISO Country Code / Headquarters HS
22 HINCORP HINCORP INCORP Historical State/Province of Incorporation Code Historical State/Province of Incorporation Code HS
23 HSTATE HSTATE STATE Historical State/Province Historical State/Province HS
24 HCOUNTY HCOUNTY COUNTY Historical County Code Historical County Code HS
25 HCITY HCITY CITY Historical City Historical City HS
26 HSIC HSIC SIC Historical SIC Code Historical SIC Code HS
27 HNAICS HNAICS NAICS Historical North American Industry Classification Code Historical North American Industry Classification Code HS
28 HGSECTOR HGSECTOR GSECTOR Historical GICS Sectors Historical GICS Sectors HS
29 HGGROUP HGGROUP GGROUP Historical GICS Groups Historical GICS Groups HS
30 HGIND HGIND GIND Historical GICS Industries Historical GICS Industries HS
31 HGSUBIND HGSUBIND GSUBIND Historical GICS Sub-Industries Historical GICS Sub-Industries HS
32 HSPCINDCD HSPCINDCD SPCINDCD Historical S&P Industry Sector Code Historical S&P Industry Sector Code HS
33 HSPCSECCD HSPCSECCD SPCSECCD Historical S&P Economic Sector Code Historical S&P Economic Sector Code HS
34 HCONML HCONML CONML Historical Company Legal Name Historical Company Legal Name HS
35 HWEBURL HWEBURL WEBURL Historical Web URL Historical Web URL HS
36 HPHONE HPHONE PHONE Historical Phone Number Historical Phone Number HS
37 HFAX HFAX FAX Historical Fax Number Historical Fax Number HS
38 HADD1 HADD1 ADD1 Historical Address Line 1 Historical Address Line 1 HS
39 HADD2 HADD2 ADD2 Historical Address Line 2 Historical Address Line 2 HS
40 HADD3 HADD3 ADD3 Historical Address Line 3 Historical Address Line 3 HS
41 HADD4 HADD4 ADD4 Historical Address Line 4 Historical Address Line 4 HS
42 HADDZIP HADDZIP ADDZIP Historical Postal Code Historical Postal Code HS
43 HBUSDESC HBUSDESC BUSDESC Historical Business Description Historical Business Description HS