...
The Composite table stores the current version of the security master record, which is typically built by the Reference Data Center. Data stored in the composite table is not identified with a SRC_INTFC_INST or an EFFECTIVE_DATE because the data at this level is the most current data available for source Eagle PACE and is typically used as production data.
The Composite table stores an UPDATE_SOURCE, which identifies the last person or process that modified the record, and an UPDATE_DATE, which specifies when the record was last updated. There is only a single composite record per security. Additional composite records can be built, but the records are stored in the History tables.
Examples of Composite tables include the SECURITY_MASTER table, which stores general security master data, and the EQUITY table, which stores data specific to equity securities. Similar tables also exist to store information for fixed income securities, mortgage backed securities, and other security types. An example of the SECURITY_MASTER table follows.
...
The History table stores records for each vendor source, as well as for the Eagle PACE gold copy and any other gold copy sources. Each history record is stored with a SRC_INTFC_INST and EFFECTIVE_DATE. A new history record is loaded for each source every time a data element changes from the last history record for the source. Therefore, there are multiple history records per security. Data for the most recent Eagle PACE source history record is identical to the SECURITY_MASTER composite record.
Examples of security History tables include SECMASTER_HISTORY and EQUITY_HIST. Similar tables exist for other security types. An example of the SECMASTER_HISTORY table follows.
...
The Time Series table stores date-specific security data, such as prices, analytics, and ratings data. For example, the CUSIP or Currency for a common stock security typically remains the same for as long as the security is issued. However, the price or earnings per share would likely change on a day by day basis.
The Time Series table is not associated with a History table. Each record in the Time Series table is stored with a SECURITY_ALIAS, SRC_INTFC_INST and EFFECTIVE_DATE. A new record is usually added each day, regardless of whether there has been a change in the data.
Examples of Time Series tables include RATINGS, VARIABLE_RATE, SCHEDULE, FX_RATES, and PRICE. An example of the RATINGS table follows.
...
When the Reference Data Center processes the data strategy, the gold copy security record is defined, as shown in the first column of the following diagram.
The Reference Data Center takes a "best of breed" approach between the data sources to create the gold copy security record.
| Anchor | ||||
|---|---|---|---|---|
|