Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

string10195blp_yellow_keySSECMASTERDETAILBLPYELLOWKEYblpYellowKeycorpIssuerEquityTicker10179corpissuerequitytickerSECMASTERDETAILCORPORATEISSUEREQUITYTICKERcorpIssuerEquityTickerarsAuctionStatus16968arsauction_statusARSAUCTION_STATUS50arsAuctionStatusassociatedVariableCusip16969associatedvariable_cusipASSOCIATEDVARIABLE_CUSIP50associatedVariableCusip

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

assetStatus


string

5400

in_sec_ext_asset_status

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

ASSET_STATUS

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/assetStatus

changeDate


dateTime

5433

in_sec_ext_change_dt

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

CHANGE_DT

DATE

EagleML/referenceTransaction/genericSMF/SMExtension/changeDate

erisaFlag


string

10523

in_erisa_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ERISA_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/erisaFlag

fixedIncomeIndustry


string

10202

in_fixed_income_industry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FIXED_INCOME_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/fixedIncomeIndustry

prvtPlace


string

1421

in_prvt_place

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER

PRVT_PLACE

CHAR(2)

EagleML/referenceTransaction/genericSMF/SMExtension/prvtPlace

modifiedBy


string

5435

in_sec_ext_modified_by

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

MODIFIED_BY

VARCHAR2(32)

EagleML/referenceTransaction/genericSMF/SMExtension/modifiedBy

reviewedBy


string

5437

in_sec_ext_reviewed_by

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

REVIEWED_BY

VARCHAR2(32)

EagleML/referenceTransaction/genericSMF/SMExtension/reviewedBy

smSecType


string

5439

in_sec_ext_sm_sec_type

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

SM_SEC_TYPE

VARCHAR2(16)

EagleML/referenceTransaction/genericSMF/SMExtension/smSecType

wiFlag


string

5440

in_sec_ext_wi_flag

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

WI_FLAG

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/SMExtension/wiFlag

smSecurityType


string

10175

in_smde_security_type

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SECURITY_TYPE

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/smSecurityType

naicCode


string

10194

in_naic_code

S

sm_extension.inc

SECURITYDBO

FIXED_INCOME

NAIC_CODE

CHAR(8)

EagleML/referenceTransaction/genericSMF/SMExtension/naicCode

naicDate


date

5890

in_naic_date

S

sm_extension.inc

SECURITYDBO

NAIC

naic_date

DATE

EagleML/referenceTransaction/genericSMF/SMExtension/naicDate

naicSymbol


string

5891

in_naic_symbol

S

sm_extension.inc

SECURITYDBO

NAIC

naic_symbol

CHAR(15)

EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol

naicSymbol2


string

5892

in_naic_symbol2

S

sm_extension.inc

SECURITYDBO

NAIC

naic_symbol2

CHAR(15)

EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol2

naicSymbol3


string

5893

in_naic_symbol3

S

sm_extension.inc

SECURITYDBO

NAIC

naic_symbol3

CHAR(15)

EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol3

naicMarketCode


string

5856

in_naic_market_code

S

sm_extension.inc

SECURITYDBO

NAIC

naic_market_code

CHAR(40)

EagleML/referenceTransaction/genericSMF/SMExtension/naicMarketCode

naicRate


decimal

5894

in_naic_rate

N

sm_extension.inc

SECURITYDBO

NAIC

naic_rate

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/SMExtension/naicRate

liquidity


string

5434

in_sec_ext_liquidity

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

liquidity

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/SMExtension/liquidity

pricingCusip


string

5436

in_sec_ext_pricing_cusip

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

pricing_cusip

VARCHAR2(9)

EagleML/referenceTransaction/genericSMF/SMExtension/pricingCusip

remicEligibleInd


string

5441

in_sec_ext_remic_eligible_ind

S

fixedincome_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

remic_eligible_ind

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/SMExtension/remicEligibleInd

cdInstmtType


string

5432

in_sec_ext_cd_instmt_type

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

cd_instmt_type

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/cdInstmtType

roundFlag


string

5438

in_sec_ext_round_flag

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

round_flag

VARCHAR2(1)

EagleML/referenceTransaction/genericSMF/SMExtension/roundFlag

assetBenchmark


string

5399

in_sec_ext_asset_benchmark

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

asset_benchmark

VARCHAR2(9)

EagleML/referenceTransaction/genericSMF/SMExtension/assetBenchmark

granularityCategory


string

11476

in_sec_ext_granularity_cat

S

sm_extension.inc

SECURITYDBO

SECURITY_MASTER_EXT

GRANULARITY_CATEGORY

CHAR(20)

EagleML/referenceTransaction/genericSMF/SMExtension/granularityCategory

groupCode


string

5858

in_group_code

S

sm_extension.inc

SECURITYDBO

NAIC

group_code

CHAR(4)

EagleML/referenceTransaction/genericSMF/SMExtension/groupCodeblpYellowKey

finalRateRoundingPrecision
integer12402in_sec_ext_final_rate_rnd_prNsm_extension.incSECURITYDBOSECURITY_MASTER_EXTFINAL_RATE_ROUND_PREC

VARCHAR2(60)


EagleML/referenceTransaction/genericSMF/SMExtension/finalRateRoundingPrecision
finalRateRoundingDirection
string12403in_sec_ext_final_rate_rnd_dirSsm_extension.incSECURITYDBOSECURITY_MASTER_EXTFINAL_RATE_ROUND_DIR

VARCHAR2(60)


EagleML/referenceTransaction/genericSMF/SMExtension/finalRateRoundingDirection

countryOfIssueblpYellowKey


string

1019310195

in_countryblp_ofyellow_issuekey

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

COUNTRYBLP_OFYELLOW_ISSUEKEY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/countryOfIssueblpYellowKey

desNotescorpIssuerEquityTicker


string

1010510179

in_corp_issuer_desequity_notesticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTDES_

NOTESCORPORATE_ISSUER_EQUITY_TICKER

VARCHAR2(10060)

EagleML/referenceTransaction/genericSMF/SMExtension/desNotescorpIssuerEquityTicker

dividendRightscountryOfIssue


string

1009010193

in_dividendcountry_of_rightsissue

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DIVIDENDCOUNTRY_OF_RIGHTSISSUE

VARCHAR2(3060)

EagleML/referenceTransaction/genericSMF/SMExtension/dividendRightscountryOfIssue

dtcRegistereddesNotes


string

1009210105

in_dtcdes_registerednotes

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DTCDES_REGISTEREDNOTES

VARCHAR2(60100)

EagleML/referenceTransaction/genericSMF/SMExtension/dtcRegistereddesNotes

industryGroupdividendRights


string

1009910090

in_industrydividend_grouprights

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRYDIVIDEND_GROUPRIGHTS

VARCHAR2(6030)

EagleML/referenceTransaction/genericSMF/SMExtension/industryGroupdividendRights

industrySectordtcRegistered


string

1010010092

in_industrydtc_sectorregistered

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRYDTC_SECTORREGISTERED

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySectordtcRegistered

industrySubgroupindustryGroup


string

1010110099

in_industry_subgroupgroup

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SUBGROUPGROUP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupindustryGroup

industrySubgroupNumberindustrySector


string

1010210100

in_industry_subgroup_numbersector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SUBGROUP_NUMBERSECTOR

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumberindustrySector

issuerIndustryindustrySubgroup


string

1017810101

in_issuerindustry_industrysubgroup

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ISSUERINDUSTRY_INDUSTRYSUBGROUP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/issuerIndustryindustrySubgroup

marketSectorDescriptionindustrySubgroupNumber


string

1017310102

in_marketindustry_sectorsubgroup_descriptionnumber

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

MARKETINDUSTRY_SECTORSUBGROUP_DESCRIPTIONNUMBER

VARCHAR2(860)

EagleML/referenceTransaction/genericSMF/SMExtension/marketSectorDescriptionindustrySubgroupNumber

smdeNaicCodeissuerIndustry


string

1019410178

in_smdeissuer_naic_codeindustry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

NAICISSUER_CODEINDUSTRY

CHARVARCHAR2(860)

EagleML/referenceTransaction/genericSMF/SMExtension/smdeNaicCodeissuerIndustry

parentCompanymarketSectorDescription


string

1017610173

in_market_parentsector_companydescription

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PARENTMARKET_SECTOR_COMPANYDESCRIPTION

VARCHAR2(608)

EagleML/referenceTransaction/genericSMF/SMExtension/parentCompanymarketSectorDescription

priceTypesmdeNaicCode


string

1009610194

in_smde_pricenaic_typecode

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRICENAIC_TYPECODE

VARCHAR2CHAR(608)

EagleML/referenceTransaction/genericSMF/SMExtension/priceTypesmdeNaicCode

redenominationDateparentCompany


datestring

1018010176

in_redenominationparent_datecompany

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATIONPARENT_DATEDATECOMPANY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationDateparentCompany

redenominationMethodpriceType


string

1018910096

in_redenominationprice_methodtype

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATIONPRICE_METHODTYPE

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationMethodpriceType

redenominationPriceredenominationDate


decimaldate

1019110180

in_redenomination_pricedate

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_PRICENUMBER(28,12)DATE

DATE

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationPriceredenominationDate

redenominationRoundMethodredenominationMethod


string

1019010189

in_redenomination_round_method

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_ROUND_METHOD

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationRoundMethodredenominationMethod

rmIndustryredenominationPrice


stringdecimal

1020010191

in_rmredenomination_industryprice

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

RMREDENOMINATION_INDUSTRYPRICE

VARCHAR2NUMBER(6028,12)

EagleML/referenceTransaction/genericSMF/SMExtension/rmIndustryredenominationPrice

shortNameredenominationRoundMethod


string

1017710190

in_shortredenomination_round_namemethod

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SHORTREDENOMINATION_ROUND_NAMEMETHOD

VARCHAR2(3060)

EagleML/referenceTransaction/genericSMF/SMExtension/shortNameredenominationRoundMethod

topixIndustryrmIndustry


string

1020110200

in_topixrm_industry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TOPIXRM_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/topixIndustryrmIndustry

tradingStatusshortName


string

1019210177

in_tradingshort_statusname

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TRADINGSHORT_STATUSNAME

VARCHAR2(6030)

EagleML/referenceTransaction/genericSMF/SMExtension/tradingStatusshortName

warrantCurrencytopixIndustry


string

1009410201

in_warranttopix_currencyindustry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANTTOPIX_CURRENCYINDUSTRY

VARCHAR2(3060)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantCurrencytopixIndustry

warrantNametradingStatus


string

1009810192

in_warranttrading_namestatus

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANTTRADING_NAMESTATUS

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantNametradingStatus

warrantTickerwarrantCurrency


string

1009710094

in_warrant_tickercurrency

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_TICKERCURRENCY

VARCHAR2(6030)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantTickerwarrantCurrency

warrantUnderlyingCurrencywarrantName


string

1009510098

in_warrant_underlying_currencyname

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_UNDERLYING_CURRENCYNAME

VARCHAR2(3060)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCurrencywarrantName

warrantUnderlyingCusipwarrantTicker


string

1009310097

in_warrant_underlying_cusipticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_UNDERLYING_CUSIPTICKER

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCusipwarrantTicker

cashEquivFlagwarrantUnderlyingCurrency


string

1052610095

in_cashwarrant_equivunderlying_flagcurrency

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

CASHWARRANT_EQUIVUNDERLYING_FLAGCURRENCY

VARCHAR2(330)

EagleML/referenceTransaction/genericSMF/SMExtension/cashEquivFlagwarrantUnderlyingCurrency

commercialPaperFlagwarrantUnderlyingCusip


string

1052510093

in_commercialwarrant_paperunderlying_flagcusip

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

COMMERCIALWARRANT_PAPERUNDERLYING_FLAGCUSIP

VARCHAR2(360)

EagleML/referenceTransaction/genericSMF/SMExtension/commercialPaperFlagwarrantUnderlyingCusip

fifecFlagcashEquivFlag


string

1052410526

in_fifeccash_equiv_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FIFECCASH_EQUIV_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/fifecFlagcashEquivFlag

fundAdminFlagcommercialPaperFlag


string

1053410525

in_fundcommercial_adminpaper_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FUNDCOMMERCIAL_ADMINPAPER_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/fundAdminFlagcommercialPaperFlag

initialChrgRebateFlagfifecFlag


string

1053110524

in_initialfifec_chrg_rebate_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INITIAL_CHRGFIFEC_REBATE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/initialChrgRebateFlagfifecFlag

internalManageFlagfundAdminFlag


string

1053210534

in_internalfund_manageadmin_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INTERNALFUND_MANAGEADMIN_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/internalManageFlagfundAdminFlag

newIssueFlaginitialChrgRebateFlag


string

1053310531

in_initial_newchrg_issuerebate_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

NEWINITIAL_CHRG_ISSUEREBATE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/newIssueFlaginitialChrgRebateFlag

supraNationalinternalManageFlag


string

1052710532

in_internal_supramanage_nationalflag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SUPRAINTERNAL_MANAGE_NATIONALFLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/supraNationalinternalManageFlag

tia1961FlagnewIssueFlag


string

1053510533

in_tianew_1961issue_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TIANEW_1961ISSUE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/tia1961FlagnewIssueFlag

ucitsFlagsupraNational


string

1052910527

in_ucitssupra_flagnational

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

UCITSSUPRA_FLAGNATIONAL

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/ucitsFlagsupraNational

unsecuredFlagtia1961Flag


string

1053010535

in_unsecuredtia_1961_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

UNSECUREDTIA_1961_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/unsecuredFlagtia1961Flag

industrySubgroupNumucitsFlag


integerstring

1236410529

in_industryucits_subgroup_numflag

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTINDUSTRY

UCITS_SUBGROUP_NUMFLAG

NUMBERVARCHAR2(383)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumucitsFlag

sedol1CountryIsounsecuredFlag


string

1236510530

in_sedol1unsecured_country_isoflag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTSEDOL1

UNSECURED_COUNTRY_ISOFLAG

VARCHAR2(303)

EagleML/referenceTransaction/genericSMF/SMExtension/sedol1CountryIsounsecuredFlag

sedol2CountryIsoindustrySubgroupNum


stringinteger

1236612364

in_sedol2industry_countrysubgroup_isonum

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SEDOL2INDUSTRY_COUNTRYSUBGROUP_ISONUM

VARCHAR2NUMBER(3038)

EagleML/referenceTransaction/genericSMF/SMExtension/sedol2CountryIsoindustrySubgroupNum

preRedenomCrncysedol1CountryIso


string

1236712365

in_presedol1_redenomcountry_crncyiso

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRESEDOL1_REDENOMCOUNTRY_CRNCYISO

VARCHAR2(18030)

EagleML/referenceTransaction/genericSMF/SMExtension/preRedenomCrncysedol1CountryIso

preEuroParAmtsedol2CountryIso


decimalstring

1236812366

in_presedol2_eurocountry_par_amtiso

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRESEDOL2_EUROCOUNTRY_PAR_AMTISO

NUMBERVARCHAR2(38,1230)

EagleML/referenceTransaction/genericSMF/SMExtension/preEuroParAmtsedol2CountryIso

postRedenomCrncypreRedenomCrncy


string

1236912367

in_postpre_redenom_crncy

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

POSTPRE_REDENOM_CRNCY

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/postRedenomCrncypreRedenomCrncy

postEuroParAmtpreEuroParAmt


decimal

1237012368

in_postpre_euro_par_amt

N

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

POSTPRE_EURO_PAR_AMT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/SMExtension/postEuroParAmtpreEuroParAmt

lseSectorpostRedenomCrncy


string

1237112369

in_lsepost_sectorredenom_crncy

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

LSEPOST_REDENOM_SECTORCRNCY

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/lseSectorpostRedenomCrncy

lseSegmentpostEuroParAmt


stringdecimal

1237212370

in_post_lseeuro_par_segmentamt

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

LSE_SEGMENT

VARCHAR2(180POST_EURO_PAR_AMT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/SMExtension/lseSegmentpostEuroParAmt

icbSectorNamelseSector


string

1237312371

in_icblse_sector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICBLSE_SECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorNamelseSector

icbSectorlseSegment


string

1237412372

in_icblse_sectorsegment

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICBLSE_SECTORSEGMENT

VARCHAR2(20180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorlseSegment

icbSubsectorNameicbSectorName


string

1237512373

in_icb_subsectorsector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUBSECTORSECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectorNameicbSectorName

icbSubsectoricbSector


string

1237612374

in_icb_subsectorsector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUBSECTORSECTOR

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectoricbSector

icbSupersectorNameicbSubsectorName


string

1237712375

in_icb_supersectorsubsector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUPERSECTORSUBSECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectorNameicbSubsectorName

icbSupersectoricbSubsector


string

1237812376

in_icb_supersectorsubsector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUPERSECTORSUBSECTOR

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectoricbSubsector

icbIndustryNameicbSupersectorName


string

1237912377

in_icb_industrysupersector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_INDUSTRYSUPERSECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryNameicbSupersectorName

icbIndustryicbSupersector


string

1238012378

in_icb_industrysupersector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_INDUSTRYSUPERSECTOR

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryicbSupersector

idBbConnecticbIndustryName


integerstring

1238112379

in_idicb_bbindustry_connectname

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

IDICB_BBINDUSTRY_CONNECTNAME

NUMBERVARCHAR2(38180)

EagleML/referenceTransaction/genericSMF/SMExtension/idBbConnecticbIndustryName

parentCompTickericbIndustry


string

1238212380

in_parenticb_comp_tickerindustry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTPARENT

ICB_COMP_TICKERINDUSTRY

VARCHAR2(18020)

EagleML/referenceTransaction/genericSMF/SMExtension/parentCompTickericbIndustry

aggBondL1idBbConnect


stringinteger

250412381

in_aggid_bondbb_l1connect

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

aggID_bondBB_l1CONNECT

VARCHAR2NUMBER(6038)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL1idBbConnect

aggBondL2parentCompTicker


string

250512382

in_aggparent_bondcomp_l2ticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

aggPARENT_bondCOMP_l2TICKER

VARCHAR2(60180)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL2parentCompTicker

aggBondL3aggBondL1


string

25062504

in_agg_bond_l3l1

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l3l1

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL3aggBondL1

aggBondL4aggBondL2


string

25072505

in_agg_bond_l4l2

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l4l2

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL4aggBondL2

redCodeaggBondL3


string

25172506

in_agg_redbond_codel3

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

redagg_bond_codel3

VARCHAR2(2560)

EagleML/referenceTransaction/genericSMF/SMExtension/redCodeaggBondL3

contingentConvertibleaggBondL4


string

168352507

in_agg_contingentbond_convertiblel4

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

CONTINGENTagg_bond_CONVERTIBLEl4

VARCHAR2(160)

EagleML/referenceTransaction/genericSMF/SMExtension/contingentConvertibleaggBondL4

redCode


string

2517

in_

red_

code

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

red_

code

VARCHAR2(

25)

EagleML/referenceTransaction/genericSMF/SMExtension/

redCode

contingentConvertible


string

16835

in_

contingent_

convertible

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

CONTINGENT_

CONVERTIBLE

VARCHAR2(

1)

EagleML/referenceTransaction/genericSMF/SMExtension/

contingentConvertible

bloombergSectorCodearsAuctionStatus
string1697016968in_bloombergars_sectorauction_codestatusSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTBLOOMBERGARS_SECTORAUCTION_CODESTATUSVARCHAR2(50)EagleML/referenceTransaction/genericSMF/SMExtension/bloombergSectorCodearsAuctionStatus
industrySectorNumberassociatedVariableCusip
integerstring1697116969in_industryassociated_sectorvariable_numcusipNSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINDUSTRYASSOCIATED_SECTORVARIABLE_NUMCUSIPNUMBERVARCHAR2(38,050)EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumberassociatedVariableCusip
isSubordinatedbloombergSectorCode
string1697216970in_isbloomberg_subordinatedsector_codeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTISBLOOMBERG_SECTOR_SUBORDINATEDCODEVARCHAR2(450)EagleML/referenceTransaction/genericSMF/SMExtension/isSubordinatedbloombergSectorCode
liquidityProviderIdindustrySectorNumber
integer1697316971in_liquidityindustry_providersector_idnumNsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTLIQUIDITYINDUSTRY_PROVIDERSECTOR_IDNUMNUMBER(38,0)EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderIdindustrySectorNumber
adrSponsorTypeisSubordinated
string1741416972in_adris_sponsor_typesubordinatedSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTADRIS_SPONSOR_TYPESUBORDINATEDVARCHAR2(4)EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorTypeisSubordinated
fundDistributorliquidityProviderId
stringinteger1741516973in_liquidity_fundprovider_distributoridSNsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDLIQUIDITY_PROVIDER_DISTRIBUTORIDVARCHAR2NUMBER(3038,0)EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributorliquidityProviderId
indexFrequencyadrSponsorType
string1741617414in_adr_indexsponsor_frequencytypeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINDEXADR_SPONSOR_FREQUENCYTYPEVARCHAR2(84)EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequencyadrSponsorType
fundGeoFocusfundDistributor
string1622617415in_fund_geo_focusdistributorSin_fund_mgmt_stylesm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_GEO_FOCUSDISTRIBUTORVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocuscfundDistributor
fundManagementStyleindexFrequency
string1622517416in_fundindex_mgmt_stylefrequencySin_fund_mgmt_stylesm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDINDEX_MGMT_STYLEFREQUENCYVARCHAR2(308)EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStyleindexFrequency
fundRtgClassFocusfundGeoFocus
string1622216226in_fund_rtg_classgeo_focusSin_fund_mgmt_styleSECURITYDBOSECMASTER_DETAIL_EXTFUND_RTG_CLASSGEO_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundRtgClassFocusfundGeoFocusc
fundMarketCapFocusfundManagementStyle
string1622316225in_fund_mktmgmt_cap_focusstyleSin_fund_mgmt_styleSECURITYDBOSECMASTER_DETAIL_EXTFUND_MKTMGMT_CAP_FOCUSSTYLEVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundMarketCapFocusfundManagementStyle
fundIndustryFocusfundRtgClassFocus
string1622416222in_fund_industryrtg_class_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_RTG_INDUSTRYCLASS_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundIndustryFocusfundRtgClassFocus
fundMaturityBandFocusfundMarketCapFocus
string1622716223in_fund_maturitymkt_bandcap_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_MATURITYMKT_BANDCAP_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundMaturityBandFocusfundMarketCapFocus
aifmdFlagfundIndustryFocus
string17439in_aifmd_flag16224in_fund_industry_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_INDUSTRY_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundIndustryFocus
fundMaturityBandFocus
string16227in_fund_maturity_band_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_MATURITY_BAND_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundMaturityBandFocus
aifmdFlag
string17439in_aifmd_flagSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTAIFMD_FLAGVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlag
exchangeCode
string17441in_exch_codeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTEXCH_CODEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCode
exchangeMarketStatus
string17444in_exchange_market_statusSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTEXCHANGE_MARKET_STATUSVARCHAR2(20)EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatus
fundRedemptionFrequency
string17445in_fund_redemption_freqSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_REDEMPTION_FREQVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequency
fundType
string17442in_fund_typeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_TYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundType
inflationLinkedFlag
string17443in_inflation_linked_flagSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINFLATION_LINKED_FLAGVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlag
msciCountryCode
string17446in_msci_country_codeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTMSCI_COUNTRY_CODEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCode
quoteUnits
string17440in_quote_unitsSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTQUOTE_UNITSVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnits
baselIII
BaselIIIEnum18304in_basel_iiiSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTBASEL_IIIVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/baselIII
contingentCapitalIndicator
YesNoOptionEnum18305in_cap_contingentSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONTINGENTVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalIndicator
contingentCapitalType
ContingentCapitalTypeEnum18306in_cap_contingent_typeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONTINGENT_TYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalType
contingentCapitalTriggerLevel
decimal18307in_cap_cont_trig_levelFsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONT_TRIG_LEVELNUMBER(38,12)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalTriggerLevel
contingentCapitalPriceLevelType
normalizedString18308in_cap_cont_price_levelSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONT_PRICE_LEVELVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalPriceLevelType
contingentCapitalFloorLevelType
normalizedString18309in_cap_cont_floor_levelSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTAIFMD_FLAGCAP_CONT_FLOOR_LEVELVARCHAR2(30255)EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlagcontingentCapitalFloorLevelType
exchangeCodeguarantorType
stringnormalizedString1744118312in_exchguarantor_codetypeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTEXCHGUARANTOR_CODETYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCodeguarantorType
exchangeMarketStatustier1CapitalIndicator
stringYesNoOptionEnum1744418315in_exchangetier1_market_statuscapitalSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTEXCHANGETIER1_MARKET_STATUSCAPITALVARCHAR2(20255)EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatustier1CapitalIndicator
fundRedemptionFrequencytier2CapitalIndicator
stringYesNoOptionEnum1744518316in_fundtier1_redemption_freqcapitalSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDTIER2_REDEMPTION_FREQCAPITALVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequencytier2CapitalIndicator
fundTypefundShareClass
stringnormalizedString1744218318in_fund_typeshare_classSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_TYPESHARE_CLASSVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundTypefundShareClass
inflationLinkedFlagprivateFundIndicator
stringYesNoOptionEnum1744318373in_inflationprivate_linked_flagfundSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINFLATIONPRIVATE_LINKED_FLAGFUNDVARCHAR2(30255)EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlagprivateFundIndicator
msciCountryCodeukTaxableFlag
stringYesNoOptionEnum1744618499in_msciuk_countrytaxable_codeflagSsm_extension.incSECURITYDBOSECMASTERSECURITY_DETAILMASTER_EXTMSCIUK_COUNTRYTAXABLE_CODEFLAGVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCodeukTaxableFlag
quoteUnitstypeOfBond
string1744018565in_type_quoteof_unitsbondSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTQUOTETYPE_OF_UNITSBONDVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnitstypeOfBond