| CL |
CodeSICCD |
Item Class |
SIC - Standard Industrial Classification Code |
US Government created Standard Industrial Classification Code. It is a four digit code, and CRSP uses 0 and 9999 for unknown or unavailable. CRSP does not differentiate among the SIC Code editions |
N |
1550001 |
| CL |
DateAnnual |
Item Class |
Annual Year-End Date |
Date restricted to last trading days of the year and cannot be null and can be found in the PeriodEndDt in the Calendar Period file where period type = A |
N |
1550005 |
| CL |
DateDaily |
Item Class |
Daily Calendar Date |
Daily Calendar Date that can be found in the Exchange Calendar File up to and including the final trading day covered by the CRSP snapshot and cannot be null |
N |
1550009 |
| CL |
DateDaily14 |
Item Class |
Daily Calendar Date - 14 days |
Daily Calendar Date that can be found in the Exchange Calendar File up to and including up to two weeks (14 calendar days) past the final trading day covered by the CRSP snapshot and can be null |
N |
1550013 |
| CL |
DateDaily180 |
Item Class |
Daily Calendar Date - 180 days |
Daily Calendar Date that can be found in the Exchange Calendar File up to and including up to 180 calendar days past the final trading day covered by the CRSP snapshot and can be null |
N |
1550017 |
| CL |
DateDlyEnd |
Item Class |
Daily Calendar End Date |
Daily Calendar Date that is the end of a range and is always paired with a DateDlyStart field and cannot be null |
N |
1550021 |
| CL |
DateDlyStart |
Item Class |
Daily Calendar Start Date |
Daily Calendar Date that is the start of a range and is always paired with a DateDlyEnd field and cannot be null |
N |
1550025 |
| CL |
DateDlyWNull |
Item Class |
Daily Calendar Date With Null |
Daily Calendar Date that can be found in the Exchange Calendar File up to and including the final trading day covered by the CRSP snapshot, but it can be null |
N |
1550029 |
| CL |
DateMonth |
Item Class |
Month-End Date |
Date restricted to last trading days of a month and cannot be null and can be found in the PeriodEndDt in the Calendar Period file where period type = M |
N |
1550033 |
| CL |
DateQuarter |
Item Class |
Quarter-End Date |
Date restricted to last trading days of a quarter and cannot be null and can be found in the PeriodEndDt in the Calendar Period file where period type = Q |
N |
1550037 |
| CL |
DateTrade |
Item Class |
Daily Trading Date |
Daily Trading Date that can be found in the Exchange Calendar File with Trading Day = Y and can be found in the PeriodEndDt in the Calendar Period file where period type = D |
N |
1550041 |
| CL |
DateTrdEnd |
Item Class |
Daily Trading End Date |
Daily Trading Date that is the end of a range and is always paired with a DateTrdStart field and cannot be null |
N |
1550045 |
| CL |
DateTrdStart |
Item Class |
Daily Trading Start Date |
Daily Calendar Date that is the start of a range and is always paired with a DateTrdEnd field and cannot be null |
N |
1550049 |
| CL |
DescVar-255 |
Item Class |
Description field - 255 characters wide |
Description field that is up to 255 characters wide and is restricted to the Alphanumeric, a space, and seven special character +,-.()= |
N |
1550053 |
| CL |
DescVar-50 |
Item Class |
Description field - 50 characters wide |
Description field that is up to 50 characters wide and is restricted to the Alphanumeric, a space, and a hyphen |
N |
1550057 |
| CL |
FlagFix-1 |
Item Class |
Flag that is exactly 1 character |
Flag that is exactly 1 character and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550061 |
| CL |
FlagFix-2 |
Item Class |
Flag that is exactly 2 characters |
Flag that is exactly 2 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550065 |
| CL |
FlagFix-3 |
Item Class |
Flag that is exactly 3 characters |
Flag that is exactly 3 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550069 |
| CL |
FlagFix-4 |
Item Class |
Flag that is exactly 4 characters |
Flag that is exactly 4 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550073 |
| CL |
FlagVar-16 |
Item Class |
Flag that can be up to 16 characters |
Flag that can be up to 16 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550077 |
| CL |
FlagVar-20 |
Item Class |
Flag that can be up to 20 characters |
Flag that can be up to 20 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550081 |
| CL |
FlagVar-3 |
Item Class |
Flag that can be up to 3 characters |
Flag that can be up to 3 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550085 |
| CL |
FlagVar-4 |
Item Class |
Flag that can be up to 4 characters |
Flag that can be up to 4 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550089 |
| CL |
FlagVar-5 |
Item Class |
Flag that can be up to 5 characters |
Flag that can be up to 5 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550093 |
| CL |
FlagVar-6 |
Item Class |
Flag that can be up to 6 characters |
Flag that can be up to 6 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550097 |
| CL |
FlagVar-7 |
Item Class |
Flag that can be up to 7 characters |
Flag that can be up to 7 characters and more information can be found in the Flag Info File and, if appropriate, the Flag Coverage File |
N |
1550101 |
| CL |
IdCNUM |
Item Class |
CNUM - CUSIP Bureau Issuer - Exactly 6 characters |
CNUM - CUSIP Bureau Issuer - Exactly 6 characters wide - See CUSIP Bureau for additional information about the conventions used for this field. |
N |
1550105 |
| CL |
IdCUSIP |
Item Class |
CUSIP Bureau Security - Exactly 8 characters wide |
CUSIP Bureau Security - Exactly 8 characters wide - See CUSIP Bureau for additional information about the conventions used for this field. |
N |
1550109 |
| CL |
IdCUSIP9 |
Item Class |
CUSIP Bureau Security with Check Digit - width 9 |
CUSIP Bureau Security with Check Digit - Exactly 9 characters wide - See CUSIP Bureau for additional information about the conventions used for this field. Note - user defined CUSIPs (nnn99nnn or nnnnnn9n) CRSP uses an X for the check digit |
N |
1550113 |
| CL |
IdFileName |
Item Class |
CRSP File Name |
CRSP File Name that uniquely identifies a row in MetaFileInfo |
N |
1550117 |
| CL |
IdFlagValue |
Item Class |
CRSP Flag Value |
CRSP Flag Value with more information in the Flag Info File and, if appropriate, the Flag Coverage File. When accessing the Flag Info File, Flag Type must also be used. File Name and Column Position must be used when accessing the Flag Coverage File |
N |
1550121 |
| CL |
IdItemName |
Item Class |
CRSP Item Name |
CRSP Item Name that uniquely identifies a row in MetaItemInfo |
N |
1550125 |
| CL |
IdNAICS |
Item Class |
NAICS - North Amer Industry Classification System |
US Government created North American Industry Classification System (NAICS). It is a six-digit code, and CRSP uses an empty string/NULL or 999990 to indicate unknown or unavailable. CRSP does not differentiate among NAICS editions |
N |
1550129 |
| CL |
IdR |
Item Class |
R code for the data type |
R language code for setting to the recommended data type |
N |
1550133 |
| CL |
IdSAS |
Item Class |
SAS code for the data type |
SAS language code used in the SAS length statement for setting to the recommended data type |
N |
1550137 |
| CL |
IdSASForm |
Item Class |
SAS code for the data format |
SAS language code used in the SAS format statement for setting to the recommended SAS format for either display or export |
N |
1550141 |
| CL |
IdSQL |
Item Class |
SQL code for the data type |
SQL language code used in the table creation to set to the recommended datatype |
N |
1550145 |
| CL |
IdTicker |
Item Class |
Ticker - up to 5 upper case letters |
Exchange ticker that is up to five upper case letters and contains no spaces or lower case letters. An empty string/NULL is used for a missing ticker |
N |
1550149 |
| CL |
IdTradingSymbol |
Item Class |
Trading Symbol - up to 7 upper case letters |
Exchange trading symbol that is between one and seven upper case letters and contains no spaces or special characters. An empty string/null is used for a missing Trading Symbol. |
N |
1550153 |
| CL |
KeyColCov |
Item Class |
Column Coverage Key |
Column Coverage Key is the unique surrogate integer key for the MetaColumnCoverage file. |
N |
1550157 |
| CL |
KeyColumn |
Item Class |
Column Key |
Column Key is the unique surrogate integer key for the MetaColumnInfo file |
N |
1550161 |
| CL |
KeyCompno |
Item Class |
NASDAQ Compno |
NASDAQ Compno is a third party foreign key provided by NASDAQ for a company (Issuer). It is not used as a key by CRSP. |
N |
1550165 |
| CL |
KeyFile |
Item Class |
File Key |
File Key is the unique surrogate integer key for the MetaFileInfo file. |
N |
1550169 |
| CL |
KeyFlag |
Item Class |
Flag Key |
Flag Key is the unique surrogate integer key for the MetaFlagInfo file. |
N |
1550173 |
| CL |
KeyFlagCov |
Item Class |
Flag Coverage Key |
Flag Coverage Key is the unique surrogate integer key for the MetaFlagCoverage file. |
N |
1550177 |
| CL |
KeyFlagType |
Item Class |
Flag Type Key |
Flag Type Key is the unique surrogate integer key for the MetaFlagType file |
N |
1550181 |
| CL |
KeyINDFAM |
Item Class |
INDFAM |
INDFAM is the unique CRSP integer key for the IndFamilyInfoHdr file |
N |
1550185 |
| CL |
KeyINDNO |
Item Class |
INDNO |
INDNO is the unique CRSP integer key for the IndSeriesInfoHdr file |
N |
1550189 |
| CL |
KeyIssueno |
Item Class |
NASDAQ Issuno |
NASDAQ Issuno is a third party foreign key provided by NASDAQ for an issue (security). It is not used as a key by CRSP. |
N |
1550193 |
| CL |
KeyItem |
Item Class |
Item Key |
Item Key is the unique surrogate integer key for the MetaItemInfo file. |
N |
1550197 |
| CL |
KeyPERMCO |
Item Class |
PERMCO |
PERMCO is the unique CRSP issuer (company) integer key for the StkIssuerInfoHdr file |
N |
1550201 |
| CL |
KeyPERMNO |
Item Class |
PERMNO |
PERMNO is the unique CRSP security integer key for the StkSecurityInfoHdr file |
N |
1550205 |
| CL |
KeySIZtoCIZ |
Item Class |
SIZ to CIZ Key |
SIZtoCIZ Key is the unique surrogate integer key for the MetaSIZtoCIZ file. |
N |
1550209 |
| CL |
Name100 |
Item Class |
Name Field 100 |
A field used as a name with up to 100 characters that include alphanumeric and some special characters, including .,(). CRSP does not use name fields as keys fields, but they are available for searching and reporting. |
N |
1550213 |
| CL |
Name50 |
Item Class |
Name Field 50 |
A field used as a name with up to 50 characters that include alphanumeric and some special characters, including .,(). CRSP does not use name fields as keys fields, but they are available for searching and reporting. |
N |
1550217 |
| CL |
Name60 |
Item Class |
Name Field 60 |
A field used as a name with up to 60 characters that include alphanumeric and some special characters, including .,(). CRSP does not use name fields as keys fields, but they are available for searching and reporting. |
N |
1550221 |
| CL |
Num1to10 |
Item Class |
Number from 1 to 10 |
A numeric field that will only contain the numbers from 1 to 10, and, if appropriate, a missing/NULL value. |
N |
1550225 |
| CL |
Num1to4 |
Item Class |
Number from 1 to 4 |
A numeric field that will only contain the numbers from 1 to 4, and, if appropriate, a missing/NULL value. |
N |
1550229 |
| CL |
Num1to7 |
Item Class |
Number from 1 to 7 |
A numeric field that will only contain the numbers from 1 to 7, and, if appropriate, a missing/NULL value. |
N |
1550233 |
| CL |
NumCnt100 |
Item Class |
Count from 0 to 100 |
A numeric field used as a count that will only contain the numbers from 0 to 100, and, if appropriate, a missing/NULL value. |
N |
1550237 |
| CL |
NumCnt100K |
Item Class |
Count from 0 to 100,000 |
A numeric field used as a count that will only contain the numbers from 0 to 100,000, and, if appropriate, a missing/NULL value. |
N |
1550241 |
| CL |
NumCnt10K |
Item Class |
Count from 0 to 10,000 |
A numeric field used as a count that will only contain the numbers from 0 to 10,000, and, if appropriate, a missing/NULL value. |
N |
1550245 |
| CL |
NumCnt10M |
Item Class |
Count from 0 to 10,000,000 |
A numeric field used as a count that will only contain the numbers from 0 to 10,000,000, and, if appropriate, a missing/NULL value. |
N |
1550249 |
| CL |
NumCnt1B |
Item Class |
Count from 0 to 1,000,000,000 |
A numeric field used as a count that will only contain the numbers from 0 to 1,000,000,000, and, if appropriate, a missing/NULL value. |
N |
1550253 |
| CL |
NumCnt1K |
Item Class |
Count from 0 to 1,000 |
A numeric field used as a count that will only contain the numbers from 0 to 1,000, and, if appropriate, a missing/NULL value. |
N |
1550257 |
| CL |
NumCnt1M |
Item Class |
Count from 0 to 1,000,000 |
A numeric field used as a count that will only contain the numbers from 0 to 1,000,000, and, if appropriate, a missing/NULL value. |
N |
1550261 |
| CL |
NumCnt20 |
Item Class |
Count from 0 to 20 |
A numeric field used as a count that will only contain the numbers from 0 to 20, and, if appropriate, a missing/NULL value. |
N |
1550265 |
| CL |
NumCnt200 |
Item Class |
Count from 0 to 200 |
A numeric field used as a count that will only contain the numbers from 0 to 200, and, if appropriate, a missing/NULL value. |
N |
1550269 |
| CL |
NumCnt350 |
Item Class |
Count from 0 to 350 |
A numeric field used as a count that will only contain the numbers from 0 to 350, and, if appropriate, a missing/NULL value. |
N |
1550273 |
| CL |
PctShares |
Item Class |
Shares Percentage |
A number calculated by dividing two numbers and it is sometimes expressed as a percent. These fields are often used in other calculations and care should be taken to ensure sufficient precision. |
N |
1550277 |
| CL |
PerAny |
Item Class |
Period Value - Any Frequency |
A period value of any frequency (annual, quarterly, monthly, weekly, daily) found and defined in the MetaCalendarRanges file |
N |
1550281 |
| CL |
PerDay |
Item Class |
Daily Period Value - YYYYMMDD |
A daily period value found and defined in the MetaCalendarRanges file and in the integer YYYYMMDD format with values between 19251231 and the current cut-date. |
N |
1550285 |
| CL |
PerMonth |
Item Class |
Monthly Period Value - YYYYMM |
A monthly period value found and defined in the MetaCalendarRanges file and in the integer YYYYMM format with values between 192512 and the current cut-month |
N |
1550289 |
| CL |
PerQuarter |
Item Class |
Quarterly Period Value - YYYYQ |
A quarterly period value found and defined in the MetaCalendarRanges file and in the integer YYYYQ format with values between 19254 and the current cut-quarter |
N |
1550293 |
| CL |
PerYear |
Item Class |
Annual (Yearly) Period Value - YYYY |
A annual (yearly) period value found and defined in the MetaCalendarRanges file and in the integer YYYY format with values between 1925 and the current cut-year. |
N |
1550297 |
| CL |
QtyShares |
Item Class |
Quantity Shares |
A field used to store shares which are an integer field. |
N |
1550301 |
| CL |
QtyVolume |
Item Class |
Quantity Volume |
A field used to store volumes which are an integer field that has exceeded at time 2,000,000,000 and therefore cannot be stored as a 32-bit integer. |
N |
1550305 |
| CL |
RatioCount |
Item Class |
Ratio of Counts |
A number calculated by dividing one count by another count and usually expressed as a percent. This fields are more often used for filters, reporting, and information and not for additional calculations. |
N |
1550309 |
| CL |
RatioFactor |
Item Class |
Calculation Factors |
A number calculated by dividing two numbers and it is sometimes expressed as a percent. These fields are often used in other calculations and care should be taken to ensure sufficient precision. |
N |
1550313 |
| CL |
RatioIncRet |
Item Class |
Income Return |
A number containing an income return and often expressed as a percent. These numbers have a very limited range being greater than or equal to zero and, except in very unusual circumstances is less than 0.05. |
N |
1550317 |
| CL |
RatioReturn |
Item Class |
Return |
A number containing an index or security return that is often expressed as a percent. These numbers have a limited left tail (all values are greater than or equal to -1) and usually are less than 1.0, and are often used in other calculations and analyses |
N |
1550321 |
| CL |
ValBaseLvl |
Item Class |
Base Index Level |
A number containing the base value for an index, usual a number that is easy to express and remembers, (e.g. 1, 10, 100, 1000). |
N |
1550325 |
| CL |
ValCap |
Item Class |
Security or Issuer Capitalization |
A number containing a security or issuer capitalization. These numbers contain a wide-range of values and with prices in the 1000th and some values in the trillions, a large number of digits can be needed, and are often used in calculations. |
N |
1550329 |
| CL |
ValDivAmt |
Item Class |
Distribution or Dividend Amount |
A number containing a dividend or distribution amounts. While this are most commonly small round numbers (e.g. 0.10, 0.25), this fields can also contain merger terms that can be very large, and are often used in calculation . |
N |
1550333 |
| CL |
ValLevel |
Item Class |
Index Level |
A number containing an index level that reflects an indexes cumulative returns from the base date. This numbers, for some indexes, can get exceptionally large. |
N |
1550337 |
| CL |
ValMktVal |
Item Class |
Market Value for an Index |
A number containing the market value of an indexes. These numbers contain a wide-range of values because micro-cap indexes have lower value, while entire market indexes have values in the trillions.. |
N |
1550341 |
| CL |
ValPrc |
Item Class |
Security Price |
A number containing a security price. Prices are always positive, but there are individual securities close to half a million and stocks well under a dollar. The switch from factional prices to decimal pricing also needs to factored into storage.. |
N |
1550345 |
| CL |
ValPrcVol |
Item Class |
Security Price times Volume |
A number containing the value a very wide range of values, but all great than zero, but can be in the billions and trillions. |
N |
1550349 |
| CL |
ValSecStat |
Item Class |
Security Statistics |
A number containing a security statistics. Storage needs to be flexibility enough that it can handle values in the billions or trillions when market capitalization, quite small when it is a standard deviation, and even negative when a beta. |
N |
1550353 |