Knowledge Base

Entities

Entities

Examples of entities

Entity code types

See also How to use the Quintessence Entity Browser.

Introduction


An entity is any element in the Quintessence database that has data associated with it and is identified by a code, for example, instruments, portfolios, countries or managers. Some entities are associated with TimeSeries data, in other words a series of values at different points in time. Some entities are linked to constituents via a Relationship and as part of that relationship have associated RelationshipData.

Examples of entities


Entity code Examples of associated data Examples of associated data values
GBP Name
Declaration Date Value Date Value
1900/01/01 1900/01/01 POUND STERLING

ZA Name
Declaration Date Value Date Value
1900/01/01 1900/01/01 SOUTH AFRICA

AGL Name
Declaration Date Value Date Value
2011/07/01 2011/07/01 Anglo American

AGL Close prices at points in time
Declaration Date Value Date Value
2012/10/19 2012/10/19 26310
2012/10/18 2012/10/18 26312
2012/10/17 2012/10/17 26450
ABC123

Holdings of constituents at points in time

(Note: this is an example of data that is associated with a relationship between entities)

Entity Code 2012/10/21 2012/10/20 2012/10/19
FRC90 6500000 6500000 6500000
FRC92 4300000 4300000 4300000
FRJ13 18000000 18000000 18000000

Entity code types


Entity codes are created by data providers, authors and users to represent an entity and differentiate it from other entities within a system. The code only needs to be unique within its own system. Because there are multiple systems an entity frequently has multiple codes. Each of these codes is a valid form of identification for that entity.

When an entity might not have a unique code (the code means different things in different systems), the intended entity can be located by Quintessence in two ways:

  1. By qualifying the code with a code type, for example: AB05:StockExchange1 Alpha Code
  2. If a code type is not provided, Quintessence uses the code type precedence as set up by the system administrator. The system selects the code type with the highest precedence, and locates the entity accordingly.

Examples of code types:

ISO Country Code
MarketDataProvider1 Code
Sector Code
StockExchange1 Index Code
StockExchange2 Constituent Code
TimeSeries

In Quintessence, all codes and code types for an entity are linked to that entity. When looking up an entity code in the Quintessence Entity Browser, any alternative code types and codes for that entity are listed:

Searching using AGL:

Searching using 100U:

Back to top