Versions Compared

Key

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

...

2507aggbondl4aggbondl460aggBondL4redCode2517redcoderedcode25redCodecontingentConvertible16835contingentconvertibleCONTINGENTCONVERTIBLE1contingentConvertible

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/groupCode

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

blpYellowKey

string

10195

in_blp_yellow_key


string

10195

in_blp_yellow_key

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

BLP_YELLOW_KEY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/blpYellowKey

corpIssuerEquityTicker


string

10179

in_corp_issuer_equity_ticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

CORPORATE_ISSUER_EQUITY_TICKER

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/corpIssuerEquityTicker

countryOfIssue


string

10193

in_country_of_issue

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

COUNTRY_OF_ISSUE

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/countryOfIssue

desNotes


string

10105

in_des_notes

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTBLP

DES_YELLOW_KEYNOTES

VARCHAR2(60100)

EagleML/referenceTransaction/genericSMF/SMExtension/blpYellowKeydesNotes

corpIssuerEquityTickerdividendRights


string

1017910090

in_corp_issuer_equity_tickerdividend_rights

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTCORPORATE_ISSUER_EQUITY_

TICKERDIVIDEND_RIGHTS

VARCHAR2(6030)

EagleML/referenceTransaction/genericSMF/SMExtension/corpIssuerEquityTickerdividendRights

countryOfIssuedtcRegistered


string

1019310092

in_countrydtc_of_issueregistered

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTCOUNTRY

DTC_OF_ISSUEREGISTERED

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/countryOfIssuedtcRegistered

desNotesindustryGroup


string

1010510099

in_desindustry_notesgroup

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DESINDUSTRY_NOTESGROUP

VARCHAR2(10060)

EagleML/referenceTransaction/genericSMF/SMExtension/desNotesindustryGroup

dividendRightsindustrySector


string

1009010100

in_dividendindustry_rightssector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DIVIDENDINDUSTRY_RIGHTSSECTOR

VARCHAR2(3060)

EagleML/referenceTransaction/genericSMF/SMExtension/dividendRightsindustrySector

dtcRegisteredindustrySubgroup


string

1009210101

in_dtcindustry_registeredsubgroup

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DTCINDUSTRY_REGISTEREDSUBGROUP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/dtcRegisteredindustrySubgroup

industryGroupindustrySubgroupNumber


string

1009910102

in_industry_groupsubgroup_number

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SUBGROUP_GROUPNUMBER

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industryGroupindustrySubgroupNumber

industrySectorissuerIndustry


string

1010010178

in_issuer_industry_sector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ISSUER_INDUSTRY_SECTOR

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorissuerIndustry

industrySubgroupmarketSectorDescription


string

1010110173

in_industrymarket_sector_subgroupdescription

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRYMARKET_SECTOR_SUBGROUPDESCRIPTION

VARCHAR2(608)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupmarketSectorDescription

industrySubgroupNumbersmdeNaicCode


string

1010210194

in_industrysmde_subgroupnaic_numbercode

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTINDUSTRY

NAIC_SUBGROUP_NUMBERCODE

VARCHAR2CHAR(608)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumbersmdeNaicCode

issuerIndustryparentCompany


string

1017810176

in_issuerparent_industrycompany

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ISSUERPARENT_INDUSTRYCOMPANY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/issuerIndustryparentCompany

marketSectorDescriptionpriceType


string

1017310096

in_marketprice_sector_descriptiontype

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTMARKET

PRICE_SECTOR_DESCRIPTIONTYPE

VARCHAR2(860)

EagleML/referenceTransaction/genericSMF/SMExtension/marketSectorDescriptionpriceType

smdeNaicCoderedenominationDate


stringdate

1019410180

in_smderedenomination_naic_codedate

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

NAICREDENOMINATION_CODECHAR(8)DATE

DATE

EagleML/referenceTransaction/genericSMF/SMExtension/smdeNaicCoderedenominationDate

parentCompanyredenominationMethod


string

1017610189

in_parentredenomination_companymethod

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PARENTREDENOMINATION_COMPANYMETHOD

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/parentCompanyredenominationMethod

priceTyperedenominationPrice


stringdecimal

1009610191

in_redenomination_price_type

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_PRICE_TYPE

VARCHAR2NUMBER(6028,12)

EagleML/referenceTransaction/genericSMF/SMExtension/priceTyperedenominationPrice

redenominationDateredenominationRoundMethod


datestring

1018010190

in_redenomination_round_datemethod

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_ROUND_DATEDATEMETHOD

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationDateredenominationRoundMethod

redenominationMethodrmIndustry


string

1018910200

in_redenominationrm_methodindustry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATIONRM_METHODINDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationMethodrmIndustry

redenominationPriceshortName


decimalstring

1019110177

in_redenominationshort_pricename

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATIONSHORT_PRICENAME

NUMBERVARCHAR2(28,1230)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationPriceshortName

redenominationRoundMethodtopixIndustry


string

1019010201

in_redenominationtopix_round_methodindustry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTREDENOMINATION

TOPIX_ROUND_METHODINDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationRoundMethodtopixIndustry

rmIndustrytradingStatus


string

1020010192

in_rmtrading_industrystatus

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

RMTRADING_INDUSTRYSTATUS

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/rmIndustrytradingStatus

shortNamewarrantCurrency


string

1017710094

in_shortwarrant_namecurrency

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SHORTWARRANT_NAMECURRENCY

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/shortNamewarrantCurrency

topixIndustrywarrantName


string

1020110098

in_topixwarrant_industryname

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TOPIXWARRANT_INDUSTRYNAME

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/topixIndustrywarrantName

tradingStatuswarrantTicker


string

1019210097

in_tradingwarrant_statusticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TRADINGWARRANT_STATUSTICKER

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/tradingStatuswarrantTicker

warrantCurrencywarrantUnderlyingCurrency


string

1009410095

in_warrant_underlying_currency

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_UNDERLYING_CURRENCY

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantCurrencywarrantUnderlyingCurrency

warrantNamewarrantUnderlyingCusip


string

1009810093

in_warrant_nameunderlying_cusip

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_NAMEUNDERLYING_CUSIP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantNamewarrantUnderlyingCusip

warrantTickercashEquivFlag


string

1009710526

in_cash_warrantequiv_tickerflag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANTCASH_EQUIV_TICKERFLAG

VARCHAR2(603)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantTickercashEquivFlag

warrantUnderlyingCurrencycommercialPaperFlag


string

1009510525

in_warrantcommercial_underlyingpaper_currencyflag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANTCOMMERCIAL_UNDERLYINGPAPER_CURRENCYFLAG

VARCHAR2(303)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCurrencycommercialPaperFlag

warrantUnderlyingCusipfifecFlag


string

1009310524

in_warrantfifec_underlying_cusipflag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTWARRANT

FIFEC_UNDERLYING_CUSIPFLAG

VARCHAR2(603)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCusipfifecFlag

cashEquivFlagfundAdminFlag


string

1052610534

in_cashfund_equivadmin_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

CASHFUND_EQUIVADMIN_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/cashEquivFlagfundAdminFlag

commercialPaperFlaginitialChrgRebateFlag


string

1052510531

in_initial_commercialchrg_paperrebate_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

COMMERCIALINITIAL_CHRG_PAPERREBATE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/commercialPaperFlaginitialChrgRebateFlag

fifecFlaginternalManageFlag


string

1052410532

in_fifecinternal_manage_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FIFECINTERNAL_MANAGE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/fifecFlaginternalManageFlag

fundAdminFlagnewIssueFlag


string

1053410533

in_fundnew_adminissue_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FUNDNEW_ADMINISSUE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/fundAdminFlagnewIssueFlag

initialChrgRebateFlagsupraNational


string

1053110527

in_initial_chrg_rebate_flagsupra_national

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTINITIAL_CHRG_REBATE_

FLAGSUPRA_NATIONAL

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/initialChrgRebateFlagsupraNational

internalManageFlagtia1961Flag


string

1053210535

in_internaltia_manage1961_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INTERNALTIA_MANAGE1961_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/internalManageFlagtia1961Flag

newIssueFlagucitsFlag


string

1053310529

in_new_issueucits_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

NEW_ISSUEUCITS_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/newIssueFlagucitsFlag

supraNationalunsecuredFlag


string

1052710530

in_supraunsecured_nationalflag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SUPRAUNSECURED_NATIONALFLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/supraNationalunsecuredFlag

tia1961FlagindustrySubgroupNum


stringinteger

1053512364

in_tiaindustry_1961subgroup_flagnum

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TIAINDUSTRY_1961SUBGROUP_FLAGNUM

VARCHAR2NUMBER(338)

EagleML/referenceTransaction/genericSMF/SMExtension/tia1961FlagindustrySubgroupNum

ucitsFlagsedol1CountryIso


string

1052912365

in_ucitssedol1_country_flagiso

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

UCITSSEDOL1_COUNTRY_FLAGISO

VARCHAR2(330)

EagleML/referenceTransaction/genericSMF/SMExtension/ucitsFlagsedol1CountryIso

unsecuredFlagsedol2CountryIso


string

1053012366

in_sedol2_unsecuredcountry_flagiso

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

UNSECUREDSEDOL2_COUNTRY_FLAGISO

VARCHAR2(330)

EagleML/referenceTransaction/genericSMF/SMExtension/unsecuredFlagsedol2CountryIso

industrySubgroupNumpreRedenomCrncy


integerstring

1236412367

in_industrypre_subgroupredenom_numcrncy

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRYPRE_SUBGROUPREDENOM_NUMCRNCY

NUMBERVARCHAR2(38180)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumpreRedenomCrncy

sedol1CountryIsopreEuroParAmt


stringdecimal

1236512368

in_pre_sedol1euro_countrypar_isoamt

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTSEDOL1

PRE_EURO_COUNTRYPAR_ISOAMT

VARCHAR2NUMBER(3038,12)

EagleML/referenceTransaction/genericSMF/SMExtension/sedol1CountryIsopreEuroParAmt

sedol2CountryIsopostRedenomCrncy


string

1236612369

in_sedol2post_countryredenom_isocrncy

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SEDOL2POST_COUNTRYREDENOM_ISOCRNCY

VARCHAR2(30180)

EagleML/referenceTransaction/genericSMF/SMExtension/sedol2CountryIsopostRedenomCrncy

preRedenomCrncypostEuroParAmt


stringdecimal

1236712370

in_prepost_euro_redenompar_crncyamt

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTPRE

POST_EURO_REDENOMPAR_CRNCYAMT

VARCHAR2NUMBER(18038,12)

EagleML/referenceTransaction/genericSMF/SMExtension/preRedenomCrncypostEuroParAmt

preEuroParAmtlseSector


decimalstring

1236812371

in_pre_euro_par_amtNlse_sector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRE_EURO_PAR_AMT

NUMBER(38,12LSE_SECTOR

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/preEuroParAmtlseSector

postRedenomCrncylseSegment


string

1236912372

in_postlse_redenom_crncysegment

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTPOST

LSE_REDENOM_CRNCYSEGMENT

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/postRedenomCrncylseSegment

postEuroParAmticbSectorName


decimalstring

1237012373

in_posticb_eurosector_par_amtname

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

POST_EUROICB_PARSECTOR_AMTNAME

NUMBERVARCHAR2(38,12180)

EagleML/referenceTransaction/genericSMF/SMExtension/postEuroParAmticbSectorName

lseSectoricbSector


string

1237112374

in_lseicb_sector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

LSEICB_SECTOR

VARCHAR2(18020)

EagleML/referenceTransaction/genericSMF/SMExtension/lseSectoricbSector

lseSegmenticbSubsectorName


string

1237212375

in_lseicb_subsector_segmentname

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

LSEICB_SUBSECTOR_SEGMENTNAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/lseSegmenticbSubsectorName

icbSectorNameicbSubsector


string

1237312376

in_icb_sector_namesubsector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SECTOR_NAMESUBSECTOR

VARCHAR2(18020)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorNameicbSubsector

icbSectoricbSupersectorName


string

1237412377

in_icb_supersector_sectorname

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SECTORSUPERSECTOR_NAME

VARCHAR2(20180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSectoricbSupersectorName

icbSubsectorNameicbSupersector


string

1237512378

in_icb_subsector_namesupersector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUBSECTOR_NAMESUPERSECTOR

VARCHAR2(18020)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectorNameicbSupersector

icbSubsectoricbIndustryName


string

1237612379

in_icb_subsectorindustry_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUBSECTORINDUSTRY_NAME

VARCHAR2(20180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectoricbIndustryName

icbSupersectorNameicbIndustry


string

1237712380

in_icb_supersector_nameindustry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUPERSECTOR_NAMEINDUSTRY

VARCHAR2(18020)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectorNameicbIndustry

icbSupersectoridBbConnect


stringinteger

1237812381

in_icbid_bb_supersectorconnect

SN

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICBID_BB_SUPERSECTORCONNECT

VARCHAR2NUMBER(2038)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectoridBbConnect

icbIndustryNameparentCompTicker


string

1237912382

in_icbparent_industrycomp_nameticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICBPARENT_INDUSTRYCOMP_NAMETICKER

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryNameparentCompTicker

icbIndustryaggBondL1


string

123802504

in_agg_icbbond_industryl1

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICBagg_bond_INDUSTRYl1

VARCHAR2(2060)

EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryaggBondL1

idBbConnectaggBondL2


integerstring

123812505

in_idagg_bbbond_connectl2

NS

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

IDagg_BBbond_CONNECTl2

NUMBERVARCHAR2(3860)

EagleML/referenceTransaction/genericSMF/SMExtension/idBbConnectaggBondL2

parentCompTickeraggBondL3


string

123822506

in_parentagg_compbond_tickerl3

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PARENTagg_COMPbond_TICKERl3

VARCHAR2(18060)

EagleML/referenceTransaction/genericSMF/SMExtension/parentCompTickeraggBondL3

aggBondL1aggBondL4


string

25042507

in_agg_bond_l1l4

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l1l4

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL1aggBondL4

aggBondL2redCode


string

25052517

in_aggred_bond_l2code

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTagg

red_bond_l2code

VARCHAR2(6025)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL2redCode

aggBondL3contingentConvertible


string

250616835

in_aggcontingent_bond_l3convertible

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXTagg

CONTINGENT_bond_l3CONVERTIBLE

VARCHAR2(601)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL3contingentConvertibleaggBondL4

arsAuctionStatus
string16968in_ars_auction_statusSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTARS_AUCTION_STATUSVARCHAR2(50)EagleML/referenceTransaction/genericSMF/SMExtension/arsAuctionStatus
associatedVariableCusip
string16969in_associated_variable_cusipSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTASSOCIATED_VARIABLE_CUSIPVARCHAR2(50)EagleML/referenceTransaction/genericSMF/SMExtension/associatedVariableCusip
bloombergSectorCode
string16970in_bloomberg_sector_codeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTBLOOMBERG_SECTOR_CODEVARCHAR2(50)EagleML/referenceTransaction/genericSMF/SMExtension/bloombergSectorCode
arsAuctionStatusindustrySectorNumber
stringinteger1696816971in_arsindustry_auctionsector_statusnumSNsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTARSINDUSTRY_AUCTIONSECTOR_STATUSNUMVARCHAR2NUMBER(5038,0)EagleML/referenceTransaction/genericSMF/SMExtension/arsAuctionStatusindustrySectorNumber
associatedVariableCusipisSubordinated
string1696916972in_associatedis_variable_cusipsubordinatedSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTASSOCIATEDIS_VARIABLE_CUSIPSUBORDINATEDVARCHAR2(504)EagleML/referenceTransaction/genericSMF/SMExtension/associatedVariableCusipisSubordinated
bloombergSectorCodeliquidityProviderId
stringinteger1697016973in_bloombergliquidity_sectorprovider_codeidSNsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTBLOOMBERGLIQUIDITY_SECTORPROVIDER_CODEIDVARCHAR2NUMBER(5038,0)EagleML/referenceTransaction/genericSMF/SMExtension/bloombergSectorCodeliquidityProviderId
industrySectorNumberadrSponsorType
integerstring1697117414in_industryadr_sectorsponsor_numtypeNSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINDUSTRYADR_SECTORSPONSOR_NUMTYPENUMBERVARCHAR2(38,04)EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumberadrSponsorType
isSubordinatedfundDistributor
string1697217415in_isfund_subordinateddistributorSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTISFUND_SUBORDINATEDDISTRIBUTORVARCHAR2(430)EagleML/referenceTransaction/genericSMF/SMExtension/isSubordinatedfundDistributor
liquidityProviderIdindexFrequency
integerstring1697317416in_liquidityindex_provider_idfrequencyNSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTLIQUIDITYINDEX_PROVIDER_IDFREQUENCYNUMBERVARCHAR2(38,08)EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderIdindexFrequency
adrSponsorTypefundGeoFocus
string1741416226in_adrfund_sponsorgeo_typefocusSsm_extension.incin_fund_mgmt_styleSECURITYDBOSECMASTER_DETAIL_EXTADRFUND_SPONSORGEO_TYPEFOCUSVARCHAR2(430)EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorTypefundGeoFocusc
fundDistributorfundManagementStyle
string1741516225in_fund_distributormgmt_styleSsm_extension.incin_fund_mgmt_styleSECURITYDBOSECMASTER_DETAIL_EXTFUND_DISTRIBUTORMGMT_STYLEVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributorfundManagementStyle
indexFrequencyfundRtgClassFocus
string1741616222in_fund_rtg_indexclass_frequencyfocusSsm_extension.inc
SECURITYDBOSECMASTER_DETAIL_EXTINDEX_FREQUENCYFUND_RTG_CLASS_FOCUSVARCHAR2(830)EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequencyfundRtgClassFocus
fundGeoFocusfundMarketCapFocus
string1622616223in_fund_geomkt_cap_focusSin_fund_mgmt_style
SECURITYDBOSECMASTER_DETAIL_EXTFUND_MKT_GEOCAP_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocuscfundMarketCapFocus
fundManagementStylefundIndustryFocus
string1622516224in_fund_mgmtindustry_stylefocusSin_fund_mgmt_style
SECURITYDBOSECMASTER_DETAIL_EXTFUND_MGMTINDUSTRY_STYLEFOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStylefundIndustryFocus
fundRtgClassFocusfundMaturityBandFocus
string1622216227in_fund_rtgmaturity_classband_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_RTGMATURITY_CLASSBAND_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundRtgClassFocusfundMaturityBandFocus
fundMarketCapFocusaifmdFlag
string1622317439in_fund_mkt_cap_focusaifmd_flagSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_MKT_CAP_FOCUSAIFMD_FLAGVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundMarketCapFocusaifmdFlag
fundIndustryFocusexchangeCode
string1622417441in_fundexch_industry_focuscodeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDEXCH_INDUSTRY_FOCUSCODEVARCHAR2(30255)EagleML/referenceTransaction/genericSMF/SMExtension/fundIndustryFocusexchangeCode
fundMaturityBandFocusexchangeMarketStatus
string1622717444in_fundexchange_maturity_band_focusSmarket_statusSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDEXCHANGE_MATURITYMARKET_BAND_FOCUSSTATUSVARCHAR2(3020)EagleML/referenceTransaction/genericSMF/SMExtension/fundMaturityBandFocusexchangeMarketStatus
aifmdFlagfundRedemptionFrequency
string1743917445in_aifmdfund_redemption_flagfreqSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTAIFMDFUND_REDEMPTION_FLAGFREQVARCHAR2(30255)EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlagfundRedemptionFrequency
exchangeCodefundType
string1744117442in_exchfund_codetypeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTEXCHFUND_CODETYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCodefundType
exchangeMarketStatusinflationLinkedFlag
string1744417443in_exchangeinflation_marketlinked_statusflagSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTEXCHANGEINFLATION_MARKETLINKED_STATUSFLAGVARCHAR2(2030)EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatusinflationLinkedFlag
fundRedemptionFrequencymsciCountryCode
string1744517446in_fundmsci_redemptioncountry_freqcodeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDMSCI_REDEMPTIONCOUNTRY_FREQCODEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequencymsciCountryCode
fundTypequoteUnits
string1744217440in_fundquote_typeunitsSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDQUOTE_TYPEUNITSVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundTypequoteUnits
inflationLinkedFlagbaselIII
stringBaselIIIEnum1744318304in_inflationbasel_linked_flagiiiSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINFLATIONBASEL_LINKED_FLAGIIIVARCHAR2(30255)EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlagbaselIII
msciCountryCodecontingentCapitalIndicator
stringYesNoOptionEnum1744618305in_mscicap_country_codecontingentSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTMSCICAP_COUNTRY_CODECONTINGENTVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCodecontingentCapitalIndicator
quoteUnitscontingentCapitalType
stringContingentCapitalTypeEnum1744018306in_quotecap_contingent_unitstypeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTQUOTECAP_CONTINGENT_UNITSTYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnitscontingentCapitalType
baselIIIcontingentCapitalTriggerLevel
BaselIIIEnumdecimal1830418307in_cap_baselcont_trig_iiilevelSFsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTBASEL_IIIVARCHAR2(255CAP_CONT_TRIG_LEVELNUMBER(38,12)EagleML/referenceTransaction/genericSMF/SMExtension/baselIIIcontingentCapitalTriggerLevel
contingentCapitalIndicatorcontingentCapitalPriceLevelType
YesNoOptionEnumnormalizedString1830518308in_cap_cont_price_contingentlevelSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONT_PRICE_CONTINGENTLEVELVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalIndicatorcontingentCapitalPriceLevelType
contingentCapitalTypecontingentCapitalFloorLevelType
ContingentCapitalTypeEnumnormalizedString1830618309in_cap_contingentcont_floor_typelevelSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONTINGENTCONT_FLOOR_TYPELEVELVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalTypecontingentCapitalFloorLevelType
contingentCapitalTriggerLevelguarantorType
decimalnormalizedString1830718312in_cap_cont_trig_levelFguarantor_typeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONT_TRIG_LEVELNUMBER(38,12GUARANTOR_TYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalTriggerLevelguarantorType
contingentCapitalPriceLevelTypetier1CapitalIndicator
normalizedStringYesNoOptionEnum1830818315in_cap_cont_price_leveltier1_capitalSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONT_PRICE_LEVELTIER1_CAPITALVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalPriceLevelTypetier1CapitalIndicator
contingentCapitalFloorLevelTypetier2CapitalIndicator
normalizedStringYesNoOptionEnum1830918316in_cap_cont_floor_leveltier1_capitalSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTCAP_CONT_FLOOR_LEVELTIER2_CAPITALVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalFloorLevelTypetier2CapitalIndicator
guarantorTypefundShareClass
normalizedString1831218318in_fund_guarantorshare_typeclassSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTGUARANTORFUND_SHARE_TYPECLASSVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/guarantorTypefundShareClass
tier1CapitalIndicatorprivateFundIndicator
YesNoOptionEnum1831518373in_tier1private_capitalfundSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTTIER1PRIVATE_CAPITALFUNDVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/tier1CapitalIndicatorprivateFundIndicator
tier2CapitalIndicatorukTaxableFlag
YesNoOptionEnum1831618499in_tier1uk_taxable_capitalflagSsm_extension.incSECURITYDBOSECMASTERSECURITY_DETAILMASTER_EXTTIER2UK_TAXABLE_CAPITALFLAGVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/tier2CapitalIndicatorukTaxableFlag
fundShareClasstypeOfBond
normalizedStringstring1831818565in_fundtype_shareof_classbondSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUNDTYPE_SHAREOF_CLASSBONDVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundShareClasstypeOfBond