Generic SMF - SM Extension Model Data Map Table
- Natalie Gesin (Deactivated)
- Alexey Chunikhin
- Kinga Huszno
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 |
| integer | 12402 | in_sec_ext_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 |
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 |
| 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 |
| 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 |
| 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 | in_industry_sector_num | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SECTOR_NUM | NUMBER(38,0) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumber |
isSubordinated |
| 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 | in_liquidity_provider_id | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LIQUIDITY_PROVIDER_ID | NUMBER(38,0) | EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderId |
adrSponsorType |
| string | 17414 | in_adr_sponsor_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ADR_SPONSOR_TYPE | VARCHAR2(4) | EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorType |
fundDistributor |
| string | 17415 | in_fund_distributor | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_DISTRIBUTOR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributor |
indexFrequency |
| string | 17416 | in_index_frequency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDEX_FREQUENCY | VARCHAR2(8) | EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequency |
fundGeoFocus |
| 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 |
| 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 | S |
| SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_RTG_CLASS_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundRtgClassFocus |
fundMarketCapFocus |
| string | 16223 | in_fund_mkt_cap_focus | S |
| SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_MKT_CAP_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundMarketCapFocus |
fundIndustryFocus |
| string | 16224 | in_fund_industry_focus | S |
| SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_INDUSTRY_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundIndustryFocus |
fundMaturityBandFocus |
| string | 16227 | in_fund_maturity_band_focus | S |
| SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_MATURITY_BAND_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundMaturityBandFocus |
aifmdFlag |
| string | 17439 | in_aifmd_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | AIFMD_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlag |
exchangeCode |
| 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 | in_exchange_market_status | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCHANGE_MARKET_STATUS | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatus |
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 |
| string | 17442 | in_fund_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundType |
inflationLinkedFlag |
| 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 |
| 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 |
| string | 17440 | in_quote_units | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | QUOTE_UNITS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnits |
baselIII |
| BaselIIIEnum | 18304 | in_basel_iii | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | BASEL_III | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/baselIII |
contingentCapitalIndicator |
| YesNoOptionEnum | 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 | 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 | 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 | 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 | in_guarantor_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GUARANTOR_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/guarantorType |
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 | 18316 | in_tier1_capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TIER2_CAPITAL | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/tier2CapitalIndicator |
fundShareClass |
| normalizedString | 18318 | in_fund_share_class | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_SHARE_CLASS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundShareClass |
privateFundIndicator |
| YesNoOptionEnum | 18373 | in_private_fund | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRIVATE_FUND | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/privateFundIndicator |
ukTaxableFlag |
| YesNoOptionEnum | 18499 | in_uk_taxable_flag | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | UK_TAXABLE_FLAG | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/ukTaxableFlag |
typeOfBond |
| string | 18565 | in_type_of_bond | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TYPE_OF_BOND | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/typeOfBond |
principlesBasedBondClass |
| string | 18622 | in_princpls_based_bond_class |
| sm_extension.inc | SECURITYDBO | NAIC | PRINCPLS_BASED_BOND_CLASS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/principlesBasedBondClass |
principlesBasedBondAttribute |
| string | 18623 | in_princpls_based_bond_attrbte |
| sm_extension.inc | SECURITYDBO | NAIC | PRINCPLS_BASED_BOND_ATTRBTE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/principlesBasedBondAttribute |
absAssetType |
| string | 18624 | in_abs_asset_type |
| sm_extension.inc | SECURITYDBO | NAIC | ABS_ASSET_TYPE | VARCHAR2(80) | EagleML/referenceTransaction/genericSMF/SMExtension/absAssetType |
principlesBasedBondChar |
| string | 18625 | in_princpls_based_bond_char |
| sm_extension.inc | SECURITYDBO | NAIC | PRINCPLS_BASED_BOND_CHAR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/principlesBasedBondChar |