Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »


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

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_EXT

DES_NOTES

VARCHAR2(100)

EagleML/referenceTransaction/genericSMF/SMExtension/desNotes

dividendRights


string

10090

in_dividend_rights

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DIVIDEND_RIGHTS

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/dividendRights

dtcRegistered


string

10092

in_dtc_registered

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

DTC_REGISTERED

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/dtcRegistered

industryGroup


string

10099

in_industry_group

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_GROUP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industryGroup

industrySector


string

10100

in_industry_sector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SECTOR

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySector

industrySubgroup


string

10101

in_industry_subgroup

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SUBGROUP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroup

industrySubgroupNumber


string

10102

in_industry_subgroup_number

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SUBGROUP_NUMBER

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumber

issuerIndustry


string

10178

in_issuer_industry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ISSUER_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/issuerIndustry

marketSectorDescription


string

10173

in_market_sector_description

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

MARKET_SECTOR_DESCRIPTION

VARCHAR2(8)

EagleML/referenceTransaction/genericSMF/SMExtension/marketSectorDescription

smdeNaicCode


string

10194

in_smde_naic_code

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

NAIC_CODE

CHAR(8)

EagleML/referenceTransaction/genericSMF/SMExtension/smdeNaicCode

parentCompany


string

10176

in_parent_company

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PARENT_COMPANY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/parentCompany

priceType


string

10096

in_price_type

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRICE_TYPE

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/priceType

redenominationDate


date

10180

in_redenomination_date

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_DATE

DATE

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationDate

redenominationMethod


string

10189

in_redenomination_method

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_METHOD

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationMethod

redenominationPrice


decimal

10191

in_redenomination_price

N

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationPrice

redenominationRoundMethod


string

10190

in_redenomination_round_method

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

REDENOMINATION_ROUND_METHOD

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/redenominationRoundMethod

rmIndustry


string

10200

in_rm_industry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

RM_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/rmIndustry

shortName


string

10177

in_short_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SHORT_NAME

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/shortName

topixIndustry


string

10201

in_topix_industry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TOPIX_INDUSTRY

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/topixIndustry

tradingStatus


string

10192

in_trading_status

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TRADING_STATUS

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/tradingStatus

warrantCurrency


string

10094

in_warrant_currency

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_CURRENCY

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantCurrency

warrantName


string

10098

in_warrant_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_NAME

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantName

warrantTicker


string

10097

in_warrant_ticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_TICKER

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantTicker

warrantUnderlyingCurrency


string

10095

in_warrant_underlying_currency

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_UNDERLYING_CURRENCY

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCurrency

warrantUnderlyingCusip


string

10093

in_warrant_underlying_cusip

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

WARRANT_UNDERLYING_CUSIP

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCusip

cashEquivFlag


string

10526

in_cash_equiv_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

CASH_EQUIV_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/cashEquivFlag

commercialPaperFlag


string

10525

in_commercial_paper_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

COMMERCIAL_PAPER_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/commercialPaperFlag

fifecFlag


string

10524

in_fifec_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FIFEC_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/fifecFlag

fundAdminFlag


string

10534

in_fund_admin_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

FUND_ADMIN_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/fundAdminFlag

initialChrgRebateFlag


string

10531

in_initial_chrg_rebate_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INITIAL_CHRG_REBATE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/initialChrgRebateFlag

internalManageFlag


string

10532

in_internal_manage_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INTERNAL_MANAGE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/internalManageFlag

newIssueFlag


string

10533

in_new_issue_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

NEW_ISSUE_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/newIssueFlag

supraNational


string

10527

in_supra_national

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SUPRA_NATIONAL

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/supraNational

tia1961Flag


string

10535

in_tia_1961_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

TIA_1961_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/tia1961Flag

ucitsFlag


string

10529

in_ucits_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

UCITS_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/ucitsFlag

unsecuredFlag


string

10530

in_unsecured_flag

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

UNSECURED_FLAG

VARCHAR2(3)

EagleML/referenceTransaction/genericSMF/SMExtension/unsecuredFlag

industrySubgroupNum


integer

12364

in_industry_subgroup_num

N

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

INDUSTRY_SUBGROUP_NUM

NUMBER(38)

EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNum

sedol1CountryIso


string

12365

in_sedol1_country_iso

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SEDOL1_COUNTRY_ISO

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/sedol1CountryIso

sedol2CountryIso


string

12366

in_sedol2_country_iso

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

SEDOL2_COUNTRY_ISO

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/SMExtension/sedol2CountryIso

preRedenomCrncy


string

12367

in_pre_redenom_crncy

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRE_REDENOM_CRNCY

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/preRedenomCrncy

preEuroParAmt


decimal

12368

in_pre_euro_par_amt

N

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PRE_EURO_PAR_AMT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/SMExtension/preEuroParAmt

postRedenomCrncy


string

12369

in_post_redenom_crncy

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

POST_REDENOM_CRNCY

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/postRedenomCrncy

postEuroParAmt


decimal

12370

in_post_euro_par_amt

N

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

POST_EURO_PAR_AMT

NUMBER(38,12)

EagleML/referenceTransaction/genericSMF/SMExtension/postEuroParAmt

lseSector


string

12371

in_lse_sector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

LSE_SECTOR

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/lseSector

lseSegment


string

12372

in_lse_segment

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

LSE_SEGMENT

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/lseSegment

icbSectorName


string

12373

in_icb_sector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorName

icbSector


string

12374

in_icb_sector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SECTOR

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSector

icbSubsectorName


string

12375

in_icb_subsector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUBSECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectorName

icbSubsector


string

12376

in_icb_subsector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUBSECTOR

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsector

icbSupersectorName


string

12377

in_icb_supersector_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUPERSECTOR_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectorName

icbSupersector


string

12378

in_icb_supersector

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_SUPERSECTOR

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersector

icbIndustryName


string

12379

in_icb_industry_name

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_INDUSTRY_NAME

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryName

icbIndustry


string

12380

in_icb_industry

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ICB_INDUSTRY

VARCHAR2(20)

EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustry

idBbConnect


integer

12381

in_id_bb_connect

N

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

ID_BB_CONNECT

NUMBER(38)

EagleML/referenceTransaction/genericSMF/SMExtension/idBbConnect

parentCompTicker


string

12382

in_parent_comp_ticker

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

PARENT_COMP_TICKER

VARCHAR2(180)

EagleML/referenceTransaction/genericSMF/SMExtension/parentCompTicker

aggBondL1


string

2504

in_agg_bond_l1

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l1

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL1

aggBondL2


string

2505

in_agg_bond_l2

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l2

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL2

aggBondL3


string

2506

in_agg_bond_l3

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l3

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL3

aggBondL4


string

2507

in_agg_bond_l4

S

sm_extension.inc

SECURITYDBO

SECMASTER_DETAIL_EXT

agg_bond_l4

VARCHAR2(60)

EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL4

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

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
industrySectorNumber
integer16971in_industry_sector_numNsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINDUSTRY_SECTOR_NUMNUMBER(38,0)EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumber
isSubordinated
string16972in_is_subordinatedSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTIS_SUBORDINATEDVARCHAR2(4)EagleML/referenceTransaction/genericSMF/SMExtension/isSubordinated
liquidityProviderId
integer16973in_liquidity_provider_idNsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTLIQUIDITY_PROVIDER_IDNUMBER(38,0)EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderId
adrSponsorType
string17414in_adr_sponsor_typeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTADR_SPONSOR_TYPEVARCHAR2(4)EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorType
fundDistributor
string17415in_fund_distributorSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_DISTRIBUTORVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributor
indexFrequency
string17416in_index_frequencySsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTINDEX_FREQUENCYVARCHAR2(8)EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequency
fundGeoFocus
string16226in_fund_geo_focusSin_fund_mgmt_styleSECURITYDBOSECMASTER_DETAIL_EXTFUND_GEO_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocusc
fundManagementStyle
string16225in_fund_mgmt_styleSin_fund_mgmt_styleSECURITYDBOSECMASTER_DETAIL_EXTFUND_MGMT_STYLEVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStyle
fundRtgClassFocus
string16222in_fund_rtg_class_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_RTG_CLASS_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundRtgClassFocus
fundMarketCapFocus
string16223in_fund_mkt_cap_focusS
SECURITYDBOSECMASTER_DETAIL_EXTFUND_MKT_CAP_FOCUSVARCHAR2(30)EagleML/referenceTransaction/genericSMF/SMExtension/fundMarketCapFocus
fundIndustryFocus
string16224in_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_EXTCAP_CONT_FLOOR_LEVELVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalFloorLevelType
guarantorType
normalizedString18312in_guarantor_typeSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTGUARANTOR_TYPEVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/guarantorType
tier1CapitalIndicator
YesNoOptionEnum18315in_tier1_capitalSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTTIER1_CAPITALVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/tier1CapitalIndicator
tier2CapitalIndicator
YesNoOptionEnum18316in_tier1_capitalSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTTIER2_CAPITALVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/tier2CapitalIndicator
fundShareClass
normalizedString18318in_fund_share_classSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTFUND_SHARE_CLASSVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/fundShareClass
privateFundIndicator
YesNoOptionEnum18373in_private_fundSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTPRIVATE_FUNDVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/privateFundIndicator
ukTaxableFlag
YesNoOptionEnum18499in_uk_taxable_flagSsm_extension.incSECURITYDBOSECURITY_MASTER_EXTUK_TAXABLE_FLAGVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/ukTaxableFlag
typeOfBond
string18565in_type_of_bondSsm_extension.incSECURITYDBOSECMASTER_DETAIL_EXTTYPE_OF_BONDVARCHAR2(255)EagleML/referenceTransaction/genericSMF/SMExtension/typeOfBond
  • No labels