Skip to main content

Instrument Attribute Definition

Data Dictionary - Entity Table: Instrument_Attribute_Definition#

Instrument Attributes represent identification codes (ISIN, SEDOL, CUSIP, etc.) and product specific metrics (yield, maturity, etc.) This information is used for drive all processes such as trading, evaluating the risk for the portfolio and other operational procedures. Instrument_Attribute_Definition table serves to classify the different attribute types and link them to specific asset classes. This table would store all attributes for an instrument exept for the name (which is in the Instrument table).

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
Attribute_NameVARCHAR(45)NULLFIGI, ISIN, Ticker, Credit Rating, DurationName of the Attribute. It can represent identification codes (ISIN, SEDOL), corporate ratings (Fitch, S&P), product specific metrics (market cap,maturity, duration) , etc.
Attribute_TypeVARCHAR(45)NULLAttribute type allows flexible grouping the attributes based on the purpose it serves within the organization, i.e Market (describing the market on which the instrument is traded), Trading&Settlement (facilitating the trading process), Corporate&Legal (describing the company or legal entity), etc.
Instrument_TypeBIGINT(12)NULL1Instrument Type id, see Insturment_Type Table.
Instrument_Type(Instrument_Type)InstrumentType (id)NO ACTIONNO ACTION
Instrument_Type_idxInstrument_Attribute_ Definition(Instrument_Type ASC)VISIBLE.