About Panels and Lookups

The default message stream rules use a set of core panels that perform several complementary functions for the proper processing of data files to load to the Eagle data warehouse:

• Lookups on the Security ID – performs an exact match instead of a "like" lookup. If the Security ID value passed to the file does not exactly match a value in the XREFERENCE table, the Security Alias is not resolved and an error is generated.
• Enhanced lookup on Xref ID – performs an Xref ID lookup using an ordered stack of various Xref ID types using the tag series 7052 thru 7080. The default XRef ID type order of inspection is CUSIP, ISIN, SEDOL, RIC, BBID, SICOVM, VALOREN, CEDEL, INTERNAL, and CINS, with further qualifications allowed using exchange, currency code, inactive flag, and maturity date to refine the lookups.
• Lookups on the Entity ID – performs an exact match instead of a "like" lookup. If the Entity ID value passed to the file does not exactly match a value in the ENTITY table, the Entity ID is not resolved and an error is generated.
  NOTE: Third Party to PACE streams allow resolution of entities using an Account Cross Reference or an Entity Bank Relationship lookup when the rule (not the stored procedure) handles message mapping to the database. Refer to the message stream descriptions that follow and the use of tag 1081 to trigger this feature. 
• Lookups on the Entity Name – performs an exact match instead of a "like" lookup. If the Entity Name value passed to the file does not exactly match a value in the ENTITY table, the Entity ID is not resolved and an error is generated.
• Code Value lookups – performs an exact match. For example, on a trade message, a lookup to the CODE VALUE table for a given broker code performs an exact match lookup. If the Broker Code Value in the file does not exactly match a Code Value in the table, no data is returned and the trade generates an error.

With the exception of the Third Party to PACE default upload stream, which is a direct push to the Eagle data warehouse, Eagle Accounting processing is applied to all incoming messages to ensure valid and robust data is present before sending any message to the database engine for processing.