|
Adjustment Factor Flat Feed |
| Short Field | Sql DataType | Format Desc | Max Width | Field Desc |
| Secid | Integer | 32 bit | 10 | Security ID from EDI database, static number |
| IssuerName | VarChar | Char String | 70 | Name of Issuer on which the price is reported, from EDI security masterfile |
| SectyCD | Char | Char String | 3 | EDI's Masterfile Security Type Code if link established. EQS (Equity), PRF (Preference), DR (Depositary Receipt) (Please see attachment `Security Types` for full details.) |
| ISIN | Char | Char String | 12 | ISIN ISO Standard 6166 |
| Sedol™ | Char | Char String | 7 | Sedol™ Code on which the price is reported. |
| Status | Char | Char String | 1 | The status of the security, whether it is `A` active, or `I` inactive. |
| Market | Char | Char String | 4 | Swift's ISO Standard 10383 Market Identification Code, on which the price is reported |
| Symbol | Char | Char String | 20 | Ticker/localcode from the exchange source. |
| ExDate | Date | yyyymmdd | 8 | Ex-date/effective date of particular event |
| Reason | Char | Integer | 2 | Numeric reason code for event (Please see attachment `Reason`) |
| Factor | Double | 64 bit | 22 | Adjustment factor, factor by which the price must be reduced. |
| Detail | VarChar | Char String | 128 | A short description of the event containing the ratio and/or rate. |
| EventType | VarChar | Char String | 10 | This contains the short event name (xxx). Field named after the long event name so that it appears explicitly in field headings. This makes the event clear in instances when there is no data under the field headings on a particular day. (Please see attachment `Event' for details) |
| EventID | Integer | 32 bit | 10 | Unique EDI Event Identifier at the global level |
| ResSedol™ | Char | Char String | 7 | Sedol™ Code of the security after the event has taken place |
| USCode | Char | Char String | 9 | USCode upon which the price is reported |
| PrimeEx | Char | Char String | 6 | EDI proprietary Exchange Code of primary Listing if known (Please see attachment 'Exchange') |
| Closed | Varchar | Char String | 22 | Price used to calculate adjustment. - Currency code + Price as a character string |
| ResISIN | Char | Char String | 12 | ISIN ISO Standard 6166 of resultant security< |
| ResLocal | Char | Char String | 12 | Local Code of resultant security |
| Sentiment | Double | 64 bit | 22 | Factorial difference between previous close and today's open |
| Errors | Char | Char String | 5 | hexadecimal value indicating any errors encounted in calculating the factor (when any of the following happen the factor is set to 1. This is a bit flag where each bit has the following meanings $0001: No close price found.$0002: No open price found.$0004: Currency mismatch and unable to convert (pre June 2007).$0008: Issue price was equal to or greater than the stock price.$0010: Issue was in the class of an option and therefore impact of little significance and/or difficult to determine.$0020: Last price from PrimeEx used $0040: Open price from PrimeEx used $0080: Factor from PrimeEx used |