Skip to main content

Instrument Attribute Value

Data Dictionary - Entity Table: Instrument_Attribute_Value#

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. This table serves to hold the values of the attributes for each individual instrument.

Primary Key ('id').ENGINE = InnoDB..
Column NameData TypePK Primary Key, NN-Not Null, NullExampleComments
idBIGINT(12)PK, NN1PrimaryKey-ID, Not Null (auto creates)
ValueVARCHAR(45)NULLe.g: US2058871029, TRE.MC, 6178, OMFSPF, AAValue of the attribute
Instrument_AttributeBIGINT(12)NULL1Id from Instrument_Attribute_Definition for the specific attribute.
InstrumentBIGINT(12)NULL1Instrument ID from the Instrument table for the specific instrument. NB! There are no constraints to enforce referential integrity across Instrument and Instrument_Attribute tables. This allows duplicate Instruments to be created. We recommend the user to establish operational process or naming conventions to minimize issues resulting from duplicates.
ValueInstrument_Attribute(Instrument_Attribute)Instrument_Attribute_ Definition (id)NO ACTIONNO ACTION
ValueInstrument(Instrument)Instrument (id)NO ACTIONNO ACTION
Instrument_Attribute_idxInstrument_Attribute_ Value(Instrument_Attribute ASC)VISIBLE.
Instrument_idxInstrument_Attribute_ Value(Instrument ASC)VISIBLE.