FR |
Annual |
File Row Frequency |
Annual Period - YYYY or AnnCalDt |
There is one period per year and the period is in the form of YYYY and the last trading day of the period is AnnCalDt |
N |
2150001 |
FR |
AssocAnnual |
File Row Frequency |
Association Periods with Annual Data |
Similar to ANNUAL, but there is up to one row per year for the combination of entity keys (e.g. PERMNO and INDNO), and the period is in the form of YYYY and the last trading day of the period is AnnCalDt |
N |
2150005 |
FR |
AssocDateRange |
File Row Frequency |
Association Periods with Data Ranges |
Similar to DATERANGE, but there is up to one row per non-overlapping range for the combination of entity keys (e.g. PERMNO and INDNO), and the range is indicated by a start and end date. |
N |
2150009 |
FR |
AssocQuarterly |
File Row Frequency |
Association Periods with Quarterly Data |
Similar to ANNUAL but there is up to one row per quarter for the combination of entity keys (e.g. PERMNO and INDNO), and the period is in the form of YYYYQ and the last trading day of the period is QtrCalDt |
N |
2150013 |
FR |
Column |
File Row Frequency |
Column - 1 row per column - file and item |
There is one row per file per column position. This is a different order, but the same as one row per file per item and is used for the MetaColumnInfo and MetaColumnCoverage files. |
N |
2150017 |
FR |
ColumnSeq |
File Row Frequency |
ColumnSeq - 1 row per column and sequence number |
There is one or more rows row per file per column position. This is used only for the MetaSIZtoCIZ mapping file where there are one or more rows per SIZ Column (SIZ File and SIZ Column Position). |
N |
2150021 |
FR |
ColumnValue |
File Row Frequency |
ColumnValue - 1 row per column per value |
Similar to Column, but it has a summary of each value contained in the column. This is used only for the MetaFlagCoverage file. |
N |
2150025 |
FR |
Daily |
File Row Frequency |
Daily Period - YYYYMMDD or DlyCalDt |
There is one period per trading day and the period is in the form of YYYYMMDD and the trading day is DlyCalDt |
N |
2150029 |
FR |
DateRange |
File Row Frequency |
Date Range - Start and End |
The row contains and is applicable to a date range |
N |
2150033 |
FR |
Monthly |
File Row Frequency |
Monthly Period - YYYYMM or MthCalDt |
There is one period per month and the period is in the form of YYYYMM and the last trading day of the period is MthCalDt |
N |
2150037 |
FR |
Observation |
File Row Frequency |
Observation - Event Date |
The row describes a single observation |
N |
2150041 |
FR |
PeriodFreq |
File Row Frequency |
Period Frequency - 1 row per period per frequency |
There is one row per period per frequency. So every date has one row per frequency. For example, December 15, 1982 is part of the 1982 annual period, the 19824 quarterly, 198212 monthly. |
N |
2150045 |
FR |
Quarterly |
File Row Frequency |
Quarterly Period - YYYYQ or QtrCalDt |
There is one period per quarter and the period is in the form of YYYYQ and the last trading day of the period is QtrCalDt |
N |
2150049 |
FR |
Single |
File Row Frequency |
Single Row Per Entity |
There is a single row per entity (e.g. Security) and are always FileKeyType of KEY. |
N |
2150053 |
FR |
TypeValue |
File Row Frequency |
Type Value - 1 Row per flag type and flag value |
There is one row per flag type and flag value used only for MetaFlagInfo |
N |
2150057 |