| MT |
Closest |
SIZ to CIZ Mapping Type |
Closest Match - non-exact |
A use of an SIZ column that doesn't have a direct match, because of a change in algorithm, but it has one or more highly correlated CIZ columns where one of them is expected to be an acceptable replacement. |
N |
2590001 |
| MT |
Combined |
SIZ to CIZ Mapping Type |
SIZ columns combine to form a CIZ column |
Two or more SIZ columns combine to form a single CIZ columns. For example, SIZ items COMNAM and SHRCLS combine to form CIZ item SecurityNm |
N |
2590005 |
| MT |
ConvChange |
SIZ to CIZ Mapping Type |
Convention Change |
An SIZ column has a fairly direct match to a CIZ column, but there is convention change that prevents it from being a direct mapping. There is more detail about the convention change in SIZtoCIZSubType. |
N |
2590009 |
| MT |
DateToYYYY |
SIZ to CIZ Mapping Type |
Date to YYYY |
SIZ has the value stored as the last trading day of the year in date format, but CIZ has the year portion stored as an integer in YYYY format. More information about the annual period can be found in the MetaCalendarPeriod file. |
N |
2590013 |
| MT |
DateToYYYYMM |
SIZ to CIZ Mapping Type |
Date to YYYYMM |
SIZ has the value stored as the last trading day of the month in date format, but CIZ has the year and month portion stored as an integer in YYYY format. More information about the monthly period can be found in the MetaCalendarPeriod file. |
N |
2590017 |
| MT |
DateToYYYYMMDD |
SIZ to CIZ Mapping Type |
Date to YYYYMMDD |
SIZ has the value stored as the trading day stored in date format, but CIZ has the year portion stored the value in integer YYYYMMDD format. More information about the daily period can be found in the MetaCalendarPeriod file. |
N |
2590021 |
| MT |
DateToYYYYQ |
SIZ to CIZ Mapping Type |
Date to YYYYQ |
SIZ has the value stored as the last trading day of the quarter in format, but CIZ stores an integer in YYYYQ format (e.g. July-Sep 1995 is 19953). More information about the quarterly period can be found in the MetaCalendarPeriod file. |
N |
2590025 |
| MT |
Denormalized |
SIZ to CIZ Mapping Type |
Denormalized (duplicated) Data |
SIZ value has been stored in a secondary place in CIZ to reduce the need for joining tables. For example, the previous TCAP value is copied and stored in DlyPrevCap column so that the single row in StkDlySecurityInfo now has both current and previous cap. |
N |
2590029 |
| MT |
Documentation |
SIZ to CIZ Mapping Type |
Columns from Documentation |
The SIZ equivalent value was available only in the documentation. It is now included in the CIZ file. |
N |
2590033 |
| MT |
Exact |
SIZ to CIZ Mapping Type |
Exact Match |
SIZ column is an exact match to the CIZ column |
N |
2590037 |
| MT |
ManyToOne |
SIZ to CIZ Mapping Type |
Many to One |
Row-Mapping-Type - One or more SIZ rows are summarized into a single CIZ row. For example one or more SIZ SFZ_DIS rows are summarized to form a couple of columns in a single rows of CIZ's StkDlySecurityInfo. The SIZtoCIZSubType points to more details. |
N |
2590041 |
| MT |
Mapped |
SIZ to CIZ Mapping Type |
Mapped from Integer to Flag |
A numeric code in SIZ is mapped to a mnemonic character flag in CIZ. The SIZtoCIZSubType points to the mapping table. |
N |
2590045 |
| MT |
NameCleanup |
SIZ to CIZ Mapping Type |
Name Column Cleanup |
The SIZ to CIZ mapping is not an exact match because the name column was edited for clarity. For example, the Index Name was expanded. (should we just change these in legacy - is there space?) |
N |
2590049 |
| MT |
Normalized |
SIZ to CIZ Mapping Type |
Normalized Data |
Row-Mapping-Type - One or more SIZ rows have been normalized to a single CIZ row. For example, Issuer and Index Family tables have been created and simplifies access when only one value per issue is desired |
N |
2590053 |
| MT |
OneToMany |
SIZ to CIZ Mapping Type |
One to Many |
Row-Mapping-Type - One SIZ rows requires many CIZ rows. For example, some columns of the SIZ's SFZ_MTH table require every row from CIZ's StkDlySecurityInfo for the PERMNO and the month to get an equivalent item. (do we need this case?) |
N |
2590057 |
| MT |
OneToOne |
SIZ to CIZ Mapping Type |
One to One |
Row-Mapping-Type - One SIZ row maps to one CIZ row. This is the most common row mapping type in SIZtoCIZ. |
N |
2590061 |
| MT |
Reassign |
SIZ to CIZ Mapping Type |
Reassignment Process |
Reassignment is analogous to recalculation. This is used for portfolio numbers and assigned INDNOs and indicates that the recalculation of statistics and breakpoints will result in a relative small number of reassignments rather than an exact match. |
N |
2590065 |
| MT |
Recalc |
SIZ to CIZ Mapping Type |
Recalculation Process |
The SIZ values were built from CRSPAccess data, where many items were stored in single precision. In CIZ, the values are stored double precision. The recalculated values will not match the original values exactly. |
N |
2590069 |
| MT |
Split |
SIZ to CIZ Mapping Type |
Split Code |
A numeric code in SIZ is mapped to multiple mnemonic character flags in CIZ. The SIZtoCIZSubType points to more detail about the mapping. |
N |
2590073 |
| MT |
SplitToOne |
SIZ to CIZ Mapping Type |
Split Rows to One |
Row-Mapping-Type - One SIZ row maps to one CIZ row, but it is split between two different files depending on the key. This is used for the SIZ SFZ_RB file, where some INDNOs are now in IndIssRebalanceSummary and some are in IndSecRebalanceSummary |
N |
2590077 |
| MT |
Zero-ManyToMany |
SIZ to CIZ Mapping Type |
Zero-Many to One |
Row-Mapping-Type - Zero, one, or many SIZ rows maps to one or many CIZ rows. This is an unusual case for SIZ's SFZ_NDI file mapping to the CIZ's StkDlySecurityInfo for some columns. See in SIZtoCIZSubType for more information. |
N |
2590081 |
| MT |
Zero-ManyToNormalize |
SIZ to CIZ Mapping Type |
Zero-OneToNormalized |
Row-Mapping-Type - Zero, one, or many SIZ rows to one normalized CIZ row. This is specific to SIZ's SFZ_PORTM mapping to CIZ's StkIndIssStatistic. See SIZtoCIZSubType for more detail |
N |
2590085 |
| MT |
Zero-ManyToOne |
SIZ to CIZ Mapping Type |
Zero-Many to Many |
Row-Mapping-Type - Zero, one, or many SIZ rows to One CIZ rows. This is specific to SIZ's SFZ_NDI mapping to CIZ's StkIssuerInfoHist and StkDlySecurityInfo for some columns. See SIZtoCIZSubType for more details. |
N |
2590089 |
| MT |
Zero-OneToMany |
SIZ to CIZ Mapping Type |
Zero-One to Many |
Row-Mapping-Type - Zero or one SIZ rows maps to one or many CIZ rows. This is an unusual case for SIZ's SFZ_NDI file mapping to the CIZ's StkDlySecurityInfo for some columns. See in SIZtoCIZSubType for more information. |
N |
2590093 |
| MT |
Zero-OneToOne |
SIZ to CIZ Mapping Type |
Zero-OneToOne |
Row-Mapping-Type - Zero or One SIZ row maps to one CIZ row. This applies to SIZ's SFZ_DP_DLY and SFZ_DS_DLY that map one to one to CIZ's StkDlySecurityData and StkDlyPrimarySecurityData except for when DlyDelFlg = 'Y' when the rows don't exist in SIZ. |
N |
2590097 |