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 |
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 |
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 |
Optional
string | 5891 | in_naic_symbol | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol | |
naicSymbol2 |
Optional
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 |
Optional
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 |
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 |
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 |
Optional
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 |
Optional
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_final_rate_rnd_pr | N | sm_extension.inc | SECURITYDBO |
SECURITY_ |
MASTER_EXT |
FINAL_RATE_ |
ROUND_ |
PREC |
VARCHAR2(60)
EagleML/referenceTransaction/genericSMF/SMExtension/ |
finalRateRoundingPrecision |
corpIssuerEquityTicker
finalRateRoundingDirection | string |
12403 | in_sec_ |
ext_final_ |
rate_ |
rnd_ |
dir | S | sm_extension.inc | SECURITYDBO |
SECURITY_ |
MASTER_EXT |
FINAL_ |
RATE_ |
ROUND_ |
DIR |
VARCHAR2(60)
EagleML/referenceTransaction/genericSMF/SMExtension/ |
finalRateRoundingDirection |
countryOfIssue
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 |
Optional
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 |
Optional
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 |
Optional
string |
10105 | in_ |
des_ |
notes | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
DES_ |
NOTES | VARCHAR2( |
100) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
desNotes |
dividendRights |
Optional
string |
10090 | in_ |
dividend_ |
rights | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
DIVIDEND_ |
RIGHTS | VARCHAR2( |
30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
dividendRights |
dtcRegistered |
Optional
string |
10092 | in_ |
dtc_ |
registered | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
DTC_ |
REGISTERED | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
dtcRegistered |
industrySubgroup
industryGroup | string |
10099 | in_industry_ |
group | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_ |
GROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
industryGroup |
industrySubgroupNumber
industrySector | string |
10100 | in_industry_ |
sector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_ |
SECTOR | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
industrySector |
industrySubgroup |
Optional
string |
10101 | in_ |
industry_ |
subgroup | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
INDUSTRY_ |
SUBGROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
industrySubgroup |
industrySubgroupNumber |
Optional
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 |
Optional
string |
10178 | in_ |
issuer_ |
industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
ISSUER_ |
INDUSTRY |
VARCHAR2( |
60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
issuerIndustry |
parentCompany
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 |
Optional
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 |
10180
in_ |
parent_ |
company | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
PARENT_ |
COMPANY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
parentCompany |
priceType |
Optional
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 |
10191
in_redenomination_ |
date |
S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_ |
DATE | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/ |
redenominationDate |
redenominationMethod |
Optional
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 |
10200
in_ |
redenomination_ |
price |
N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
REDENOMINATION_ |
PRICE |
NUMBER( |
28,12) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
redenominationPrice |
redenominationRoundMethod |
Optional
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 |
Optional
string |
10200 | in_ |
rm_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
RM_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
rmIndustry |
tradingStatus
shortName | string |
10177 | in_ |
short_ |
name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
SHORT_ |
NAME | VARCHAR2( |
30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
shortName |
warrantCurrency
topixIndustry | string |
10201 | in_ |
topix_ |
industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
TOPIX_ |
INDUSTRY | VARCHAR2( |
60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
topixIndustry |
warrantName
tradingStatus | string |
10192 | in_ |
trading_ |
status | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
TRADING_ |
STATUS | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
tradingStatus |
warrantTicker
warrantCurrency | string |
10094 | in_warrant_ |
currency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_ |
CURRENCY | VARCHAR2( |
30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
warrantCurrency |
warrantName |
Optional
string |
10098 | in_warrant_ |
name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_ |
NAME | VARCHAR2( |
60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
warrantName |
warrantTicker |
Optional
string |
10097 | in_warrant_ |
ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_ |
TICKER | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
warrantTicker |
warrantUnderlyingCurrency |
Optional
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 |
Optional
string |
10093 | in_ |
warrant_ |
underlying_ |
cusip | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
WARRANT_ |
UNDERLYING_ |
CUSIP | VARCHAR2( |
60) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
warrantUnderlyingCusip |
fifecFlag
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 |
Optional
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 |
Optional
string |
10524 | in_ |
fifec_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
FIFEC_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
fifecFlag |
fundAdminFlag |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
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 |
Optional
string |
10527 | in_ |
supra_ |
national | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
SUPRA_ |
NATIONAL | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
supraNational |
unsecuredFlag
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 |
integer
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 |
string
12364 | in_ |
industry_ |
subgroup_ |
num |
N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
INDUSTRY_ |
SUBGROUP_ |
NUM |
NUMBER( |
38) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
industrySubgroupNum |
preRedenomCrncy
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 |
12368
in_ |
sedol2_ |
country_ |
iso |
S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
SEDOL2_ |
COUNTRY_ |
ISO |
VARCHAR2( |
30) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
sedol2CountryIso |
preRedenomCrncy |
Optional
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 |
Optional
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 |
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 |
12370 |
12372
in_ |
post_euro_par_amt | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
LSE_SEGMENT
POST_EURO_PAR_AMT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
postEuroParAmt |
icbSectorName
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 |
icbSector |
Optional
string |
12374 | in_icb_ |
sector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_ |
SECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbSector |
icbSupersectorName
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 |
icbSupersector
icbSubsector | string |
12376 | in_icb_ |
subsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_ |
SUBSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbSubsector |
icbSupersectorName |
Optional
string |
12377 | in_icb_ |
supersector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_ |
SUPERSECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbSupersectorName |
icbIndustry
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 |
12381
in_ |
icb_ |
industry_ |
name |
S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
ICB_ |
INDUSTRY_ |
NAME |
VARCHAR2( |
180) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
icbIndustryName |
parentCompTicker
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 |
2504
in_ |
id_ |
bb_ |
connect |
N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT |
ID_ |
BB_ |
CONNECT |
NUMBER( |
38) | EagleML/referenceTransaction/genericSMF/SMExtension/ |
idBbConnect |
aggBondL2
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 |
Optional
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 |
Optional
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 |
Optional
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 |
S
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 |