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 |
Optional
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 |
Optional
dateTime | 5433 | in_sec_ext_change_dt | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | CHANGE_DT | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/changeDate |
erisaFlag |
Optional
string | 10523 | in_erisa_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ERISA_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/erisaFlag | |
fixedIncomeIndustry |
Optional
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 |
Optional
string | 1421 | in_prvt_place | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER | PRVT_PLACE | CHAR(2) | EagleML/referenceTransaction/genericSMF/SMExtension/prvtPlace | |
modifiedBy |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
string | 10175 | in_smde_security_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/smSecurityType | |
naicCode |
Optional
string | 10194 | in_naic_code | S | sm_extension.inc | SECURITYDBO | FIXED_INCOME | NAIC_CODE | CHAR(8) | EagleML/referenceTransaction/genericSMF/SMExtension/naicCode | |
naicDate |
Optional
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 |
Optional
string | 5893 | in_naic_symbol3 | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol3 | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol3 | |
naicMarketCode |
Optional
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 |
Optional
string | 5434 | in_sec_ext_liquidity | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | liquidity | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/liquidity | |
pricingCusip |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
string | 5858 | in_group_code | S | sm_extension.inc | SECURITYDBO | NAIC | group_code | CHAR(4) | EagleML/referenceTransaction/genericSMF/SMExtension/groupCode |
| finalRateRoundingPrecision |
| integer |
| 12402 |
10195
| in_ |
| sec_ext_ |
S
| final_rate_rnd_pr | N | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | FINAL_RATE_ROUND_PREC | EagleML/referenceTransaction/genericSMF/SMExtension/finalRateRoundingPrecision | |||||
| finalRateRoundingDirection | string | 12403 | in_sec_ext_final_rate_rnd_dir | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | FINAL_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 |
corpIssuerEquityTicker
ucitsFlag | string |
10529 | in_ |
ucits_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
UCITS_FLAG | VARCHAR2( |
3) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
ucitsFlag |
unsecuredFlag |
Optional
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 |
10105
in_industry_ |
subgroup_ |
num |
N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
INDUSTRY_SUBGROUP_ |
NUM |
NUMBER( |
38) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
industrySubgroupNum |
sedol1CountryIso |
Optional
string |
12365 | in_ |
sedol1_country_ |
iso | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
SEDOL1_COUNTRY_ |
ISO | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
sedol1CountryIso |
dtcRegistered
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 |
industryGroup
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 |
10100
in_pre_euro_ |
par_ |
amt |
N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
INDUSTRY_SECTOR
PRE_EURO_PAR_AMT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
preEuroParAmt |
postRedenomCrncy |
Optional
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 |
string
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 |
issuerIndustry
lseSector | string |
12371 | in_ |
lse_ |
sector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
LSE_ |
SECTOR | VARCHAR2( |
180) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
lseSector |
lseSegment |
Optional
string |
12372 | in_ |
lse_ |
segment | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
LSE_ |
SEGMENT | VARCHAR2( |
180) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
lseSegment |
icbSectorName |
Optional
string |
12373 | in_ |
icb_ |
sector_ |
name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
ICB_SECTOR_ |
NAME |
VARCHAR2( |
180) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbSectorName |
parentCompany
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 |
date
12376 | in_ |
icb_ |
subsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
ICB_ |
SUBSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbSubsector |
redenominationMethod
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 |
decimal
12378 | in_ |
icb_ |
supersector |
S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
ICB_ |
SUPERSECTOR |
VARCHAR2( |
20) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbSupersector |
icbIndustryName |
Optional
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 |
Optional
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 |
10177
in_id_ |
bb_ |
connect |
N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
SHORT_NAME
ID_BB_CONNECT | NUMBER(38) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
idBbConnect |
parentCompTicker |
Optional
string |
12382 | in_parent_ |
comp_ |
ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
PARENT_COMP_ |
TICKER | VARCHAR2( |
180) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
parentCompTicker |
tradingStatus
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 |
warrantCurrency
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 |
warrantName
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 |
Optional
string |
2507 | in_agg_ |
bond_ |
l4 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
agg_bond_ |
l4 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
aggBondL4 |
warrantUnderlyingCurrency
redCode | string |
2517 | in_ |
red_ |
code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
red_ |
code | VARCHAR2( |
25) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
redCode |
contingentConvertible |
Optional
string |
16835 | in_ |
contingent_ |
convertible | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
CONTINGENT_ |
CONVERTIBLE | VARCHAR2( |
1) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
contingentConvertible |
| arsAuctionStatus |
Optional
| string |
| 16968 | in_ |
| ars_ |
| auction_ |
| status | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| ARS_ |
| AUCTION_ |
| STATUS | VARCHAR2( |
| 50) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| arsAuctionStatus |
| associatedVariableCusip |
Optional
| string |
| 16969 | in_ |
| associated_ |
| variable_ |
| cusip | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| ASSOCIATED_ |
| VARIABLE_ |
| CUSIP | VARCHAR2( |
| 50) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| associatedVariableCusip |
| bloombergSectorCode |
Optional
| string |
| 16970 | in_bloomberg_ |
| sector_ |
| code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| BLOOMBERG_SECTOR_ |
| CODE | VARCHAR2( |
| 50) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| bloombergSectorCode |
| industrySectorNumber |
| integer |
| 16971 |
10534
| in_ |
| industry_ |
| sector_ |
| num |
| N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| INDUSTRY_ |
| SECTOR_ |
| NUM |
| NUMBER( |
| 38,0) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| industrySectorNumber |
| isSubordinated |
Optional
| string |
| 16972 | in_ |
| is_subordinated | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| IS_SUBORDINATED | VARCHAR2( |
| 4) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| isSubordinated |
| liquidityProviderId |
| integer |
| 16973 |
10532
| in_ |
| liquidity_ |
| provider_ |
| id |
| N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| LIQUIDITY_ |
| PROVIDER_ |
| ID |
| NUMBER( |
| 38,0) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| liquidityProviderId |
| adrSponsorType |
Optional
| string |
| 17414 | in_ |
| adr_ |
| sponsor_ |
| type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| ADR_ |
| SPONSOR_ |
| TYPE | VARCHAR2( |
| 4) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| adrSponsorType |
supraNational
| fundDistributor | string |
| 17415 | in_ |
| fund_ |
| distributor | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_ |
| DISTRIBUTOR | VARCHAR2( |
| 30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundDistributor |
tia1961Flag
| indexFrequency | string |
| 17416 | in_ |
| index_ |
| frequency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| INDEX_ |
| FREQUENCY | VARCHAR2( |
| 8) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| indexFrequency |
| fundGeoFocus |
Optional
| string |
| 16226 | in_ |
| fund_geo_ |
| focus | S |
| in_fund_mgmt_style | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_GEO_ |
| FOCUS | VARCHAR2( |
| 30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundGeoFocusc |
| fundManagementStyle |
Optional
| string |
| 16225 | in_fund_ |
| mgmt_ |
| style | S |
| in_fund_mgmt_style | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_MGMT_ |
| STYLE | VARCHAR2( |
| 30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundManagementStyle |
| fundRtgClassFocus |
| string |
| 16222 | in_ |
| fund_rtg_ |
| class_ |
| focus |
N
sm_extension.inc
| S | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_RTG_ |
| CLASS_ |
| FOCUS |
| VARCHAR2( |
| 30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundRtgClassFocus |
| fundMarketCapFocus |
Optional
| string |
| 16223 | in_fund_ |
| mkt_ |
| cap_ |
| focus | S |
| SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_MKT_ |
| CAP_ |
| FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundMarketCapFocus |
| fundIndustryFocus |
Optional
| string |
| 16224 | in_ |
| fund_ |
| industry_ |
| focus | S |
sm_extension.inc
| SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_ |
| INDUSTRY_ |
| FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundIndustryFocus |
| fundMaturityBandFocus |
Optional
| string |
| 16227 | in_fund_ |
| maturity_ |
| band_ |
| focus | S |
sm_extension.inc
| SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_MATURITY_ |
| BAND_ |
| FOCUS | VARCHAR2( |
| 30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundMaturityBandFocus |
| aifmdFlag |
| string |
| 17439 |
12368
| in_ |
| aifmd_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
PRE_EURO_PAR_AMT
| AIFMD_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| aifmdFlag |
| exchangeCode |
Optional
| string |
| 17441 | in_ |
| exch_ |
| code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| EXCH_ |
| CODE | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| exchangeCode |
| exchangeMarketStatus |
| string |
| 17444 |
12370
| in_ |
| exchange_ |
| market_ |
| status |
| S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| EXCHANGE_ |
| MARKET_ |
| STATUS |
| VARCHAR2( |
| 20) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| exchangeMarketStatus |
lseSector
| fundRedemptionFrequency | string |
| 17445 | in_ |
| fund_redemption_ |
| freq | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_REDEMPTION_ |
| FREQ | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundRedemptionFrequency |
| fundType |
Optional
| string |
| 17442 | in_ |
| fund_ |
| type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_ |
| TYPE | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundType |
| inflationLinkedFlag |
Optional
| string |
| 17443 | in_ |
| inflation_ |
| linked_ |
| flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| INFLATION_ |
| LINKED_ |
| FLAG | VARCHAR2( |
| 30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| inflationLinkedFlag |
| msciCountryCode |
Optional
| string |
| 17446 | in_msci_ |
| country_ |
| code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| MSCI_COUNTRY_ |
| CODE | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| msciCountryCode |
| quoteUnits |
Optional
| string |
| 17440 | in_ |
| quote_ |
| units | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| QUOTE_ |
| UNITS | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| quoteUnits |
| baselIII |
| BaselIIIEnum |
string
| 18304 | in_ |
| basel_ |
| iii | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| BASEL_ |
| III | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| baselIII |
| contingentCapitalIndicator |
| YesNoOptionEnum |
string
| 18305 | in_ |
| cap_ |
| contingent | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| CAP_ |
| CONTINGENT | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| contingentCapitalIndicator |
| contingentCapitalType |
| ContingentCapitalTypeEnum |
| 18306 | in_ |
| cap_contingent_ |
| type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| CAP_CONTINGENT_ |
| TYPE | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| contingentCapitalType |
| contingentCapitalTriggerLevel |
| decimal |
| 18307 |
12379
| in_ |
| cap_cont_ |
| trig_ |
| level |
| F | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| CAP_CONT_ |
| TRIG_ |
| LEVEL |
| NUMBER( |
| 38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| contingentCapitalTriggerLevel |
| contingentCapitalPriceLevelType |
| normalizedString |
string
| 18308 | in_ |
| cap_cont_price_level | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| CAP_CONT_PRICE_LEVEL | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| contingentCapitalPriceLevelType |
| contingentCapitalFloorLevelType |
| normalizedString |
| 18309 |
12381
| in_ |
| cap_cont_ |
| floor_ |
| level |
| S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| CAP_CONT_ |
| FLOOR_ |
| LEVEL |
| VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| contingentCapitalFloorLevelType |
| guarantorType |
| normalizedString |
| 18312 |
12382
| in_ |
| guarantor_ |
| type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| GUARANTOR_ |
| TYPE | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| guarantorType |
aggBondL1
| tier1CapitalIndicator |
| YesNoOptionEnum |
| 18315 | in_ |
| tier1_ |
| capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| TIER1_ |
| CAPITAL | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| tier1CapitalIndicator |
| tier2CapitalIndicator |
| YesNoOptionEnum |
string
| 18316 | in_ |
| tier1_ |
| capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| TIER2_ |
| CAPITAL | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| tier2CapitalIndicator |
| fundShareClass |
| normalizedString |
| 18318 |
2506
| in_ |
| fund_ |
| share_ |
| class | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| FUND_ |
| SHARE_ |
| CLASS | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| fundShareClass |
| privateFundIndicator |
Optional
| YesNoOptionEnum |
| 18373 | in_ |
| private_ |
| fund | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| PRIVATE_ |
| FUND | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| privateFundIndicator |
| ukTaxableFlag |
| YesNoOptionEnum |
string
| 18499 | in_uk_ |
| taxable_ |
| flag | S | sm_extension.inc | SECURITYDBO |
| SECURITY_ |
| MASTER_EXT |
| UK_TAXABLE_ |
| FLAG | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
| ukTaxableFlag |
| typeOfBond |
Optional
| string |
16835
| 18565 | in_type_of_bond | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
| TYPE_OF_ |
| BOND | VARCHAR2( |
| 255) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
...
| typeOfBond |