Generic SMF - MIFID Model

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

isAdmittedToTradng

 

string

17735

 

 

 

SECURITYDBO

SECURITY_MIFID

IS_ADMITTED_TO_TRADNG

 

EagleML/referenceTransaction/genericSMF/mifidModel/isAdmittedToTradng

isLiquidInstrument

 

string

17746

 

 

 

SECURITYDBO

SECURITY_MIFID

IS_LIQUID_INSTRUMENT

 

EagleML/referenceTransaction/genericSMF/mifidModel/isLiquidInstrument

largeInScaleShares

 

decimal

17751

 

 

 

SECURITYDBO

SECURITY_MIFID

LARGE_IN_SCALE_SHARES

 

EagleML/referenceTransaction/genericSMF/mifidModel/largeInScaleShares

largeInScaleValue

 

decimal

17743

 

 

 

SECURITYDBO

SECURITY_MIFID

LARGE_IN_SCALE_VALUE

 

EagleML/referenceTransaction/genericSMF/mifidModel/largeInScaleValue

lisPostTradeEuroCrncy

 

decimal

17742

 

 

 

SECURITYDBO

SECURITY_MIFID

LIS_POST_TRADE_EURO_CRNCY

 

EagleML/referenceTransaction/genericSMF/mifidModel/lisPostTradeEuroCrncy

lisPostTradeLc

 

decimal

17749

 

 

 

SECURITYDBO

SECURITY_MIFID

LIS_POST_TRADE_LC

 

EagleML/referenceTransaction/genericSMF/mifidModel/lisPostTradeLc

lisPreTradeEurCrncy

 

decimal

17741

 

 

 

SECURITYDBO

SECURITY_MIFID

LIS_PRE_TRADE_EUR_CRNCY

 

EagleML/referenceTransaction/genericSMF/mifidModel/lisPreTradeEurCrncy

lisPreTradeLc

 

decimal

17750

 

 

 

SECURITYDBO

SECURITY_MIFID

LIS_PRE_TRADE_LC

 

EagleML/referenceTransaction/genericSMF/mifidModel/lisPreTradeLc

mifidAdt

 

string

17737

 

 

 

SECURITYDBO

SECURITY_MIFID

MIFID_ADT

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifidAdt

mifidAssetClass

 

string

17736

 

 

 

SECURITYDBO

SECURITY_MIFID

MIFID_ASSET_CLASS

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifidAssetClass

mifidUnderlyingIndex

 

string

17740

 

 

 

SECURITYDBO

SECURITY_MIFID

MIFID_UNDERLYING_INDEX

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifidUnderlyingIndex

postTradeEuroCrncy

 

decimal

17745

 

 

 

SECURITYDBO

SECURITY_MIFID

POST_TRADE_EURO_CRNCY

 

EagleML/referenceTransaction/genericSMF/mifidModel/postTradeEuroCrncy

preTradeEuroCrncy

 

decimal

17744

 

 

 

SECURITYDBO

SECURITY_MIFID

PRE_TRADE_EURO_CRNCY

 

EagleML/referenceTransaction/genericSMF/mifidModel/preTradeEuroCrncy

refIndexIsin

 

string

17739

 

 

 

SECURITYDBO

SECURITY_MIFID

REF_INDEX_ISIN

 

EagleML/referenceTransaction/genericSMF/mifidModel/refIndexIsin

refIndexTerm

 

string

17752

 

 

 

SECURITYDBO

SECURITY_MIFID

REF_INDEX_TERM

 

EagleML/referenceTransaction/genericSMF/mifidModel/refIndexTerm

sstiPostTradeLc

 

decimal

17748

 

 

 

SECURITYDBO

SECURITY_MIFID

SSTI_POST_TRADE_LC

 

EagleML/referenceTransaction/genericSMF/mifidModel/sstiPostTradeLc

sstiPreTradeLc

 

decimal

17747

 

 

 

SECURITYDBO

SECURITY_MIFID

SSTI_PRE_TRADE_LC

 

EagleML/referenceTransaction/genericSMF/mifidModel/sstiPreTradeLc

tickSizeLiquidityBand

 

string

17738

 

 

 

SECURITYDBO

SECURITY_MIFID

TICK_SIZE_LIQUIDITY_BAND

 

EagleML/referenceTransaction/genericSMF/mifidModel/tickSizeLiquidityBand

userGroupChar1

 

string

17642

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR1

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar1

userGroupChar2

 

string

17643

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR2

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar2

userGroupChar3

 

string

17644

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR3

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar3

userGroupChar4

 

string

17645

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR4

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar4

userGroupChar5

 

string

17646

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR5

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar5

userGroupChar6

 

string

17647

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR6

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar6

userGroupChar7

 

string

17648

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR7

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar7

userGroupChar8

 

string

17649

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR8

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar8

userGroupChar9

 

string

17650

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR9

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar9

userGroupChar10

 

string

17651

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR10

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar10

userGroupChar11

 

string

17652

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR11

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar11

userGroupChar12

 

string

17653

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR12

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar12

userGroupChar13

 

string

17654

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR13

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar13

userGroupChar14

 

string

17655

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR14

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar14

userGroupChar15

 

string

17656

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_CHAR15

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupChar15

userGroupDate1

 

date

17657

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_DATE1

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupDate1

userGroupDate2

 

date

17658

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_DATE2

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupDate2

userGroupDate3

 

date

17659

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_DATE3

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupDate3

userGroupDate4

 

date

17660

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_DATE4

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupDate4

userGroupDate5

 

date

17661

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_DATE5

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupDate5

userGroupFloat1

 

decimal

17662

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT1

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat1

userGroupFloat2

 

decimal

17663

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT2

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat2

userGroupFloat3

 

decimal

17664

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT3

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat3

userGroupFloat4

 

decimal

17665

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT4

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat4

userGroupFloat5

 

decimal

17666

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT5

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat5

userGroupFloat6

 

decimal

17667

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT6

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat6

userGroupFloat7

 

decimal

17668

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT7

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat7

userGroupFloat8

 

decimal

17669

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT8

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat8

userGroupFloat9

 

decimal

17670

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT9

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat9

userGroupFloat10

 

decimal

17671

 

 

 

SECURITYDBO

SECURITY_MIFID

USER_GROUP_FLOAT10

 

EagleML/referenceTransaction/genericSMF/mifidModel/userGroupFloat10

bloombergGeneratedCFICode

 

string

 

 

 

 

SECURITYDBO

SECURITY_MIFID

BBG_CFI_CODE

 

EagleML/referenceTransaction/genericSMF/mifidModel/bloombergGeneratedCFICode

mifidAdmittedToTradingIndicator

 

string

 

 

 

 

SECURITYDBO

SECURITY_MIFID

MIFID_ATT_REQUEST_IND

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifidAdmittedToTradingIndicator

mifiUKAdmittedToTradingIndicator

 

string

 

 

 

 

SECURITYDBO

SECURITY_MIFID

UK_MIFI_ATT_REQUEST_IND

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifiUKAdmittedToTradingIndicator

mifidAdmittedToTradingTerminationDate

 

date

 

 

 

 

SECURITYDBO

SECURITY_MIFID

ATT_TERMINATION_DATE

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifidAdmittedToTradingTerminationDate

mifiUKAdmittedToTradingTerminationDate

 

date

 

 

 

 

SECURITYDBO

SECURITY_MIFID

UK_ATT_TERMINATION_DATE

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifiUKAdmittedToTradingTerminationDate

mifiUKIsTradedOnTradingVenue

 

string

 

 

 

 

SECURITYDBO

SECURITY_MIFID

UK_MIFI_IS_TOTV

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifiUKIsTradedOnTradingVenue

mifiUKIsTradedOnUKTradingVenue

 

string

 

 

 

 

SECURITYDBO

SECURITY_MIFID

UK_MIFI_IS_UK_TOTV

 

EagleML/referenceTransaction/genericSMF/mifidModel/mifiUKIsTradedOnUKTradingVenue

notionalCurrency

 

CurrencyCode

 

 

 

 

SECURITYDBO

SECURITY_MIFID

NOTIONAL_CURRENCY_1

 

EagleML/referenceTransaction/genericSMF/mifidModel/notionalCurrency