| FK |
AssocPerWithGap |
File Key Type |
Association Periods with Gap Allowed |
The key is made up of two identifying keys (e.g. PERMNO and INDNO) and the period which provides the association between the keys for that period. The periods for a given combination of keys may be contiguous, but is allowed to contain gaps. |
N |
2070001 |
| FK |
AssocRangeWithGap |
File Key Type |
Association Ranges With Gap Allowed |
The key is made up of two identifying keys (e.g. PERMNO and INDNO) and a start and end date pair and provides the association that date range. The range are non-overlapping and can be contiguous, but they are allowed to contain gaps. |
N |
2070005 |
| FK |
Key |
File Key Type |
Single Key Field |
A single key field (e.g. PERMNO) uniquely describes a row. These are sometime called header or entity files. |
N |
2070009 |
| FK |
KeyDtNoGap |
File Key Type |
Key Field with Date and No Gap (i.e. Timeseries) |
A key field and a date with no gaps in the sequence (e.g. PERMNO, DlyCalDt) and form a contiguous timeseries of data. While no rows are missing, data may contain missing values. |
N |
2070013 |
| FK |
KeyDtSeq |
File Key Type |
Key Field with event date and sequence number |
A key field with an event date and a sequence number to uniquely identify the rows (e.g. PERMNO, ExDt, SeqNo), because multiple events can occur on the same event date. |
N |
2070017 |
| FK |
KeyPeriodNoGap |
File Key Type |
Key Field with Period and No Gap (i.e. Timeseries) |
A key field and a period with no gaps in the sequence (e.g. PERMNO, MthYYYYMM) and form a contiguous timeseries of data. While no rows are missing, data may contain missing values. |
N |
2070021 |
| FK |
KeyRangeNoGap |
File Key Type |
Key Field with Range and No Gap |
A key field and date range with no gaps (e.g. PERMNO, SecInfoStartDt, SecInfoEndDt) and form a contiguous time range so that any date between the first start and the last end can be found. While no ranges are missing, data may contain missing values. |
N |
2070025 |
| FK |
KeySeq |
File Key Type |
Key Field combined with sequence field |
Key Field combined with sequence field (e.g. FileName, ColPosition). The sequence numbers start with one and are contiguous |
N |
2070029 |
| FK |
KeySeqSeq |
File Key Type |
Key Field combined with two sequence fields |
Key Field combined with two sequence field (e.g. FileName, ColPosition, SIZColMapSeq). The sequence numbers start with one and are contiguous |
N |
2070033 |
| FK |
KeySeqValue |
File Key Type |
Key Field combined with sequence field and a value |
Key Field combined with sequence field and a value (e.g. FileName, ColPosition, FlagValue). The sequence numbers start with one and are contiguous and the values are alphabetical |
N |
2070037 |
| FK |
KeyValue |
File Key Type |
Key Field combined with a value |
Key Field combined with a value (e.g. FlagType, FlagValue). The Key field and the value are both in alphabetical order. |
N |
2070040 |