...
Identifiers for each security are stored in SECURITYDBO.XREFERENCE (identifiers are also called xreference (or cross-reference ) identifiers or xrefs).
SECURITYDBO.SECURITY_MASTER and SECURITYDBO.XREFERENCE tables are linked with the SECURITY_ALIAS field. This is a one-to-many relationship, one record in SECURITY_MASTER can have several corresponding records in SECURITYDBO.XREFERENCE table.
...
- Primary Asset Id, Primary Asset Type – Eagle identifier, which uniquely defines a security record. Stored in SECURITYDBO.SECURITY_MASTER.PRIMARY_ASSET_ID, SECURITYDBO.SECURITY_MASTER.PRIMARPRIMARY_ASSET_TYPE fields. As it is an xreference identifier at the same time, it is also stored in SECURITYDBO.XREFERENCE table.
- Standard widely used identifiers – ticker, cusip, cusipPay, cusipReceive, isin, sedol, reuters, bloombergId, sicovmId, valorenId, cedel, internalId, cinsId, uniqueProductId, uniqueSwapId
- Vendor-specific identifiers – <xId>AAAA</xId><XIdType>BBBB</xIdType>
...