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 |
VARCHAR2(60)
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 |
VARCHAR2(60)
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 |
LSE_SEGMENT
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 |