Also in this page:
Element | Optional/Required | Value Type | Star Tag | SP Parameter (EagleML version >= 13.1) | SP Parameter (EagleML version < 13.1) | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
---|---|---|---|---|---|---|---|---|---|---|---|
objectType | ObjectTypeEnum | EagleML/referenceTransaction/genericIssueAnalytic/objectType | |||||||||
objectId | ObjectId | EagleML/referenceTransaction/genericIssueAnalytic/objectId | |||||||||
objectDescription | FeedTypeEnum | EagleML/referenceTransaction/genericIssueAnalytic/objectDescription | |||||||||
updateTimestamp | dateTime | EagleML/referenceTransaction/genericIssueAnalytic/updateTimestamp | |||||||||
customElements | Not recommended | CustomElements - complex group | EagleML/referenceTransaction/genericIssueAnalytic/customElements | ||||||||
sourceName | string | 1102 | in_short_desc | in_short_desc | S | used in resolution logics | EagleML/referenceTransaction/genericIssueAnalytic/sourceName | ||||
updateSource | Required | string | 944 | in_update_source | in_update_source | S | SECURITYDBO | SECURITY_ANALYTICS | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/updateSource |
effectiveDate | Required | date | 1109 | in_effective_date | in_effective_date | S | SECURITYDBO | SECURITY_ANALYTICS | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/effectiveDate |
languageId | integer | EagleML/referenceTransaction/genericIssueAnalytic/languageId | |||||||||
tagNochangecase | string | EagleML/referenceTransaction/genericIssueAnalytic/tagNochangecase | |||||||||
preserveNull | string | EagleML/referenceTransaction/genericIssueAnalytic/preserveNull | |||||||||
noLoadValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/genericIssueAnalytic/noLoadValidationFlag | ||||||||
accountingValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/genericIssueAnalytic/accountingValidationFlag | ||||||||
Asset Identifiers Model | EagleML/referenceTransaction/genericIssueAnalytic/ | ||||||||||
analyticCurrency | CurrencyCode | 8607 | in_se_currency | in_currency | S | SECURITYDBO | SECURITY_ANALYTICS | CURRENCY | CHAR(3) | EagleML/referenceTransaction/genericIssueAnalytic/analyticCurrency | |
convexity | decimal | 8608 | in_se_convexity | in_convexity | F | SECURITYDBO | SECURITY_ANALYTICS | CONVEXITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/convexity | |
modDuration | decimal | 8609 | in_se_mod_duration | in_mod_duration | F | SECURITYDBO | SECURITY_ANALYTICS | MOD_DURATION | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/modDuration | |
ytm | decimal | 8610 | in_se_ytm | in_ytm | F | SECURITYDBO | SECURITY_ANALYTICS | YTM | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytm | |
ytnc | decimal | 8611 | in_se_ytnc | in_ytnc | F | SECURITYDBO | SECURITY_ANALYTICS | YTNC | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytnc | |
ytnp | decimal | 8612 | in_se_ytnp | in_ytnp | F | SECURITYDBO | SECURITY_ANALYTICS | YTNP | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytnp | |
yts | decimal | 8613 | in_se_yts | in_yts | F | SECURITYDBO | SECURITY_ANALYTICS | YTS | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/yts | |
effectiveYield | decimal | 8614 | in_se_eff_yld | in_eff_yld | F | SECURITYDBO | SECURITY_ANALYTICS | EFF_YLD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveYield | |
durationToWorst | decimal | 8615 | in_se_dur_to_wrst | in_dur_to_wrst | F | SECURITYDBO | SECURITY_ANALYTICS | DUR_TO_WRST | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/durationToWorst | |
yto | decimal | 8616 | in_se_yto | in_yto | F | SECURITYDBO | SECURITY_ANALYTICS | YTO | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/yto | |
cpr | decimal | 8617 | in_se_cpr | in_cpr | F | SECURITYDBO | SECURITY_ANALYTICS | CPR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/cpr | |
effectiveDuration | decimal | 8618 | in_se_eff_dur | in_eff_dur | F | SECURITYDBO | SECURITY_ANALYTICS | EFF_DUR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveDuration | |
psa | decimal | 8619 | in_se_psa | in_psa | F | SECURITYDBO | SECURITY_ANALYTICS | PSA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/psa | |
oas | decimal | 8620 | in_se_oas | in_oas | F | SECURITYDBO | SECURITY_ANALYTICS | OAS | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/oas | |
oad | decimal | 8621 | in_se_oad | in_oad | F | SECURITYDBO | SECURITY_ANALYTICS | OAD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/oad | |
oay | decimal | 8622 | in_se_oay | in_oay | F | SECURITYDBO | SECURITY_ANALYTICS | OAY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/oay | |
wal | decimal | 8623 | in_se_wal | in_wal | F | SECURITYDBO | SECURITY_ANALYTICS | WAL | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/wal | |
wam | decimal | 8624 | in_se_wam | in_wam | F | SECURITYDBO | SECURITY_ANALYTICS | WAM | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/wam | |
wac | decimal | 8625 | in_se_wac | in_wac | F | SECURITYDBO | SECURITY_ANALYTICS | WAC | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/wac | |
ytw | decimal | 8626 | in_se_ytw | in_ytw | F | SECURITYDBO | SECURITY_ANALYTICS | YTW | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytw | |
maturityInYears | decimal | 8627 | in_se_mat_yrs | in_mat_yrs | F | SECURITYDBO | SECURITY_ANALYTICS | MAT_YRS | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/maturityInYears | |
actualDayToAccrue | decimal | 8628 | in_se_act_day_to_accrue | in_act_day_to_accrue | F | SECURITYDBO | SECURITY_ANALYTICS | ACT_DAY_TO_ACCRUE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/actualDayToAccrue | |
cashFlowDuration | decimal | 8629 | in_se_cash_flw_duration | in_cash_flw_duration | F | SECURITYDBO | SECURITY_ANALYTICS | CASH_FLW_DURATION | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/cashFlowDuration | |
pd3 | decimal | 8630,8725 | in_se_pd3 | in_pd3 | F | SECURITYDBO | SECURITY_ANALYTICS | PD3 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd3 | |
pd4 | decimal | 8631 | in_se_pd4 | in_pd4 | F | SECURITYDBO | SECURITY_ANALYTICS | PD4 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd4 | |
effectiveSpreadDuration | decimal | 8632 | in_se_eff_spread_dur | in_eff_spread_dur | F | SECURITYDBO | SECURITY_ANALYTICS | EFF_SPREAD_DUR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveSpreadDuration | |
mortgageEffectiveElasticity | decimal | 8633 | in_se_mtg_eff_elasticity | in_mtg_eff_elasticity | F | SECURITYDBO | SECURITY_ANALYTICS | MTG_EFF_ELASTICITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/mortgageEffectiveElasticity | |
mortgageThreasElasticity | decimal | 8634 | in_se_mtg_threas_elasticity | in_mtg_threas_elasticity | F | SECURITYDBO | SECURITY_ANALYTICS | MTG_THREAS_ELASTICITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/mortgageThreasElasticity | |
mortgageTurnoverElasticity | decimal | 8635 | in_se_mtg_turnover_elasticity | in_mtg_turnover_elasticity | F | SECURITYDBO | SECURITY_ANALYTICS | MTG_TURNOVER_ELASTICITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/mortgageTurnoverElasticity | |
smmRate | decimal | 8636 | in_se_smm_rate | in_smm_rate | F | SECURITYDBO | SECURITY_ANALYTICS | SMM_RATE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/smmRate | |
strippedYield | decimal | 8637 | in_se_stripped_yield | in_stripped_yield | F | SECURITYDBO | SECURITY_ANALYTICS | STRIPPED_YIELD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/strippedYield | |
term | decimal | 8638 | in_se_term | in_term | F | SECURITYDBO | SECURITY_ANALYTICS | TERM | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/term | |
macaulayDuration | decimal | 8639 | in_se_macaulay_duration | in_macaulay_duration | F | SECURITYDBO | SECURITY_ANALYTICS | MACAULAY_DURATION | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/macaulayDuration | |
ytnConv | decimal | 8640 | in_se_ytnconv | in_ytnconv | F | SECURITYDBO | SECURITY_ANALYTICS | YTNCONV | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytnConv | |
dtm | decimal | 8641 | in_se_dtm | in_dtm | F | SECURITYDBO | SECURITY_ANALYTICS | DTM | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/dtm | |
cashFlowYield | decimal | 8642 | in_se_cash_flow_yield | in_cash_flow_yield | F | SECURITYDBO | SECURITY_ANALYTICS | CASH_FLOW_YIELD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/cashFlowYield | |
accruedFactor | decimal | 8643 | in_se_accrued_factor | in_accrued_factor | F | SECURITYDBO | SECURITY_ANALYTICS | ACCRUED_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/accruedFactor | |
effectiveSpread | decimal | 8644 | in_se_eff_spread | in_eff_spread | F | SECURITYDBO | SECURITY_ANALYTICS | EFF_SPREAD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveSpread | |
oad2 | decimal | 8645 | in_se_oad2 | in_oad2 | F | SECURITYDBO | SECURITY_ANALYTICS | OAD2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/oad2 | |
oad3 | decimal | 8646 | in_se_oad3 | in_oad3 | F | SECURITYDBO | SECURITY_ANALYTICS | OAD3 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/oad3 | |
modToWorst | decimal | 8647 | in_se_mod_to_wrst | in_mod_to_wrst | F | SECURITYDBO | SECURITY_ANALYTICS | MOD_TO_WRST | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/modToWorst | |
averageLifeDate | date | 8648 | in_se_average_life_date | in_average_life_date | S | SECURITYDBO | SECURITY_ANALYTICS | AVERAGE_LIFE_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/averageLifeDate | |
averageMaturity | date | 8649 | in_se_average_maturity | in_average_maturity | S | SECURITYDBO | SECURITY_ANALYTICS | AVERAGE_MATURITY | DATE | EagleML/referenceTransaction/genericIssueAnalytic/averageMaturity | |
delta | decimal | 8650,8739 | in_se_delta | in_delta | F | SECURITYDBO | SECURITY_ANALYTICS | DELTA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/delta | |
gamma | decimal | 8651,874 | in_se_gamma | in_gamma | F | SECURITYDBO | SECURITY_ANALYTICS | GAMMA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/gamma | |
theta | decimal | 8652,8741 | in_se_theta | in_theta | F | SECURITYDBO | SECURITY_ANALYTICS | THETA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/theta | |
vega | decimal | 8653,8742 | in_se_vega | in_vega | F | SECURITYDBO | SECURITY_ANALYTICS | VEGA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/vega | |
rDayCount | integer | 8654 | in_se_r_day_cnt | in_r_day_cnt | I | SECURITYDBO | SECURITY_ANALYTICS | R_DAY_CNT | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/rDayCount | |
pDayCount | integer | 8655 | in_se_p_day_cnt | in_p_day_cnt | I | SECURITYDBO | SECURITY_ANALYTICS | P_DAY_CNT | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/pDayCount | |
beta | decimal | 8665 | in_se_beta | in_beta | F | SECURITYDBO | SECURITY_ANALYTICS | BETA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/beta | |
effectiveConvexity | decimal | 8657 | in_se_eff_convexity | in_eff_convexity | F | SECURITYDBO | SECURITY_ANALYTICS | EFF_CONVEXITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveConvexity | |
mappingCusip | string | 10451 | in_se_mapping_cusip | in_mapping_cusip | S | SECURITYDBO | SECURITY_ANALYTICS | MAPPING_CUSIP | CHAR(12) | EagleML/referenceTransaction/genericIssueAnalytic/mappingCusip | |
analyticPrice | decimal | 10452 | in_se_price | in_price | I | SECURITYDBO | SECURITY_ANALYTICS | PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticPrice | |
releaseStatus | string | not stored in DB | EagleML/referenceTransaction/genericIssueAnalytic/releaseStatus | ||||||||
releaseDate | date | not stored in DB | EagleML/referenceTransaction/genericIssueAnalytic/releaseDate | ||||||||
annDomesticYield | decimal | 2865 | in_se_ann_domestic_yield | in_ann_domestic_yield | F | SECURITYDBO | SECURITY_ANALYTICS | ANN_DOMESTIC_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/annDomesticYield | |
annCompoundYield | decimal | 2866 | in_se_ann_compound_yield | in_ann_compound_yield | F | SECURITYDBO | SECURITY_ANALYTICS | ANN_COMPOUND_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/annCompoundYield | |
semiAnnDomesticYield | decimal | 2867 | in_se_semi_ann_domestic_yield | in_semi_ann_domestic_yield | F | SECURITYDBO | SECURITY_ANALYTICS | SEMI_ANN_DOMESTIC_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/semiAnnDomesticYield | |
semiAnnCompoundYield | decimal | 2868 | in_se_semi_ann_compound_yield | in_semi_ann_compound_yield | F | SECURITYDBO | SECURITY_ANALYTICS | SEMI_ANN_COMPOUND_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/semiAnnCompoundYield | |
quarterlyCompoundYield | decimal | 2869 | in_se_quarterly_compound_yield | in_quarterly_compound_yield | F | SECURITYDBO | SECURITY_ANALYTICS | QUARTERLY_COMPOUND_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/quarterlyCompoundYield | |
monthlyCompoundYield | decimal | 2870 | in_se_monthly_compound_yield | in_monthly_compound_yield | F | SECURITYDBO | SECURITY_ANALYTICS | MONTHLY_COMPOUND_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/monthlyCompoundYield | |
trueYtm | decimal | 2871 | in_se_true_ytm | in_true_ytm | F | SECURITYDBO | SECURITY_ANALYTICS | TRUE_YTM | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/trueYtm | |
trueYieldAnn | decimal | 2872 | in_se_true_yield_ann | in_true_yield_ann | F | SECURITYDBO | SECURITY_ANALYTICS | TRUE_YIELD_ANN | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/trueYieldAnn | |
trueYieldSemiAnn | decimal | 2873 | in_se_true_yield_semi_ann | in_true_yield_semi_ann | F | SECURITYDBO | SECURITY_ANALYTICS | TRUE_YIELD_SEMI_ANN | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/trueYieldSemiAnn | |
usStreetYield | decimal | 2874 | in_se_us_street_yield | in_us_street_yield | F | SECURITYDBO | SECURITY_ANALYTICS | US_STREET_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/usStreetYield | |
usTreasuryYield | decimal | 2875 | in_se_us_treasury_yield | in_us_treasury_yield | F | SECURITYDBO | SECURITY_ANALYTICS | US_TREASURY_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/usTreasuryYield | |
japanSimpleYield | decimal | 2876 | in_se_japan_simple_yield | in_japan_simple_yield | F | SECURITYDBO | SECURITY_ANALYTICS | JAPAN_SIMPLE_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/japanSimpleYield | |
moneyMktAct365Yield | decimal | 2877 | in_se_money_mkt_act365_yield | in_money_mkt_act365_yield | F | SECURITYDBO | SECURITY_ANALYTICS | MONEY_MKT_ACT365_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/moneyMktAct365Yield | |
moneyMktAct360Yield | decimal | 2878 | in_se_money_mkt_act360_yield | in_money_mkt_act360_yield | F | SECURITYDBO | SECURITY_ANALYTICS | MONEY_MKT_ACT360_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/moneyMktAct360Yield | |
nominalYield | decimal | 2879 | in_se_nominal_yield | in_nominal_yield | F | SECURITYDBO | SECURITY_ANALYTICS | NOMINAL_YIELD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/nominalYield | |
rhoRate | decimal | 4930 | in_se_rho_rate | in_rho_rate | F | SECURITYDBO | SECURITY_ANALYTICS | RHO_RATE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/rhoRate | |
rhoHoldingCost | decimal | 4931 | in_se_rho_holding_cost | in_rho_holding_cost | F | SECURITYDBO | SECURITY_ANALYTICS | RHO_HOLDING_COST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/rhoHoldingCost | |
yieldBenchmark | decimal | 4932 | in_se_yield_benchmark | in_yield_benchmark | F | SECURITYDBO | SECURITY_ANALYTICS | YIELD_BENCHMARK | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/yieldBenchmark | |
convexityToWorst | decimal | 4933 | in_se_convexity_to_wrst | in_convexity_to_wrst | F | SECURITYDBO | SECURITY_ANALYTICS | CONVEXITY_TO_WRST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/convexityToWorst | |
rateAnnualCompounding | decimal | 4934 | in_se_rate_ann_compound | in_rate_ann_compound | F | SECURITYDBO | SECURITY_ANALYTICS | RATE_ANN_COMPOUND | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/rateAnnualCompounding | |
holdingCostAnnualCompounding | decimal | 4935 | in_se_holding_cost_ann_comp | in_holding_cost_ann_compound | F | SECURITYDBO | SECURITY_ANALYTICS | HOLDING_COST_ANN_COMPOUND | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/holdingCostAnnualCompounding | |
storageCost | decimal | 8505 | in_se_storage_cost | in_storage_cost | F | SECURITYDBO | SECURITY_ANALYTICS | STORAGE_COST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/storageCost | |
convenienceValue | decimal | 8506 | in_se_convenience_value | in_convenience_value | F | SECURITYDBO | SECURITY_ANALYTICS | CONVENIENCE_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/convenienceValue | |
impliedRepoRate | decimal | 8507 | in_se_implied_repo_rate | in_implied_repo_rate | F | SECURITYDBO | SECURITY_ANALYTICS | IMPLIED_REPO_RATE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/impliedRepoRate | |
annualizedRepoRate | decimal | 8508 | in_se_annualized_repo_rate | in_annualized_repo_rate | F | SECURITYDBO | SECURITY_ANALYTICS | ANNUALIZED_REPO_RATE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/annualizedRepoRate | |
modifiedConvexity | decimal | 8509 | in_se_modified_convexity | in_modified_convexity | F | SECURITYDBO | SECURITY_ANALYTICS | MODIFIED_CONVEXITY | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/modifiedConvexity | |
bid | decimal | 8658 | in_sea_bid | in_bid | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BID | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/bid | |
eps12Mnth | decimal | 8659 | in_sea_eps_12mnth | in_eps_12mnth | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | EPS_12MNTH | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/eps12Mnth | |
ask | decimal | 8660 | in_sea_ask | in_ask | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | ASK | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ask | |
high52Week | decimal | 8661 | in_sea_high_52week | in_high_52week | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | HIGH_52WEEK | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/high52Week | |
low52Week | decimal | 8662 | in_sea_low_52week | in_low_52week | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | LOW_52WEEK | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/low52Week | |
highdate52Week | date | 8663 | in_sea_highdate_52week | in_highdate_52week | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | HIGHDATE_52WEEK | DATE | EagleML/referenceTransaction/genericIssueAnalytic/highdate52Week | |
lowdate52Week | date | 8664 | in_sea_lowdate_52week | in_lowdate_52week | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | LOWDATE_52WEEK | DATE | EagleML/referenceTransaction/genericIssueAnalytic/lowdate52Week | |
betaEQ | decimal | 8665 | in_sea_beta | in_beta | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BETA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/betaEQ | |
netYld | decimal | 8666 | in_sea_net_yld | in_net_yld | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | NET_YLD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/netYld | |
exchangeCode | string | 8667 | in_sea_exchange_code | in_exchange_code | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | EXCHANGE_CODE | CHAR(10) | EagleML/referenceTransaction/genericIssueAnalytic/exchangeCode | |
sharesOutstanding | decimal | 8668 | in_sea_shares_outstanding | in_shares_outstanding | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHARES_OUTSTANDING | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sharesOutstanding | |
sales | decimal | 8669 | in_sea_sales | in_sales | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SALES | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sales | |
salesPerShare | decimal | 8670 | in_sea_sales_per_share | in_sales_per_share | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SALES_PER_SHARE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/salesPerShare | |
returnEqty | decimal | 8671 | in_sea_return_eqty | in_return_eqty | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | RETURN_EQTY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/returnEqty | |
bookvaluePershare | decimal | 8679 | in_sea_book_val_per_shr | in_book_val_per_shr | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BOOK_VAL_PER_SHR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/bookvaluePershare | |
div12mnthPerShare | decimal | 8673 | in_sea_div_12mnth_per_share | in_div_12mnth_per_share | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_12MNTH_PER_SHARE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/div12mnthPerShare | |
peRatio | decimal | 8674 | in_sea_pe_ratio | in_pe_ratio | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | PE_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/peRatio | |
indDivYld | decimal | 8675 | in_sea_ind_div_yld | in_ind_div_yld | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | IND_DIV_YLD | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/indDivYld | |
ytdTotalReturn | decimal | 8676 | in_sea_ytd_total_return | in_ytd_total_return | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | YTD_TOTAL_RETURN | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytdTotalReturn | |
netIncome | decimal | 8677 | in_sea_net_income | in_net_income | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | NET_INCOME | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/netIncome | |
analystCode | string | 8678 | in_sea_analyst_code | in_analyst_code | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | ANALYST_CODE | CHAR(8) | EagleML/referenceTransaction/genericIssueAnalytic/analystCode | |
bookValPerShr | decimal | 8672 | in_sea_bookvalue_pershare | in_bookvalue_pershare | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BOOKVALUE_PERSHARE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/bookValPerShr | |
bookY0 | decimal | 8680 | in_sea_book_y0 | in_book_y0 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BOOK_Y0 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/bookY0 | |
bookYm1 | decimal | 8681 | in_sea_book_ym1 | in_book_ym1 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BOOK_YM1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/bookYm1 | |
bookYm2 | decimal | 8682 | in_sea_book_ym2 | in_book_ym2 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BOOK_YM2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/bookYm2 | |
cashFlowEst | decimal | 8683 | in_sea_cash_flow_est | in_cash_flow_est | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | CASH_FLOW_EST | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/cashFlowEst | |
cashFlowFree3Y | decimal | 8684 | in_sea_cash_flow_free_3y | in_cash_flow_free_3y | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | CASH_FLOW_FREE_3Y | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/cashFlowFree3Y | |
debtCap | decimal | 8685 | in_sea_debt_cap | in_debt_cap | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DEBT_CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/debtCap | |
debtCapFn | decimal | 8686 | in_sea_debt_cap_fn | in_debt_cap_fn | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DEBT_CAP_FN | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/debtCapFn | |
discPercent | decimal | 8687 | in_sea_disc_percent | in_disc_percent | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DISC_PERCENT | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/discPercent | |
divGr3YE | decimal | 8688 | in_sea_div_gr_3y_e | in_div_gr_3y_e | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_GR_3Y_E | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divGr3YE | |
divGr5YH | decimal | 8689,8918 | in_sea_div_gr_5y_h | in_div_gr_5y_h | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_GR_5Y_H | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divGr5YH | |
divIndic | decimal | 8690 | in_sea_div_indic | in_div_indic | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_INDIC | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divIndic | |
divNorm | decimal | 8691 | in_sea_div_norm | in_div_norm | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_NORM | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divNorm | |
divPoS1 | decimal | 8692 | in_sea_div_po_s1 | in_div_po_s1 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_PO_S1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divPoS1 | |
divPoS1Fn | decimal | 8693 | in_sea_div_po_s1_fn | in_div_po_s1_fn | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_PO_S1_FN | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divPoS1Fn | |
divPoS2 | decimal | 8694 | in_sea_div_po_s2 | in_div_po_s2 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_PO_S2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divPoS2 | |
divPoS4 | decimal | 8695 | in_sea_div_po_s4 | in_div_po_s4 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_PO_S4 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divPoS4 | |
divY0H | decimal | 8696 | in_sea_div_y0_h | in_div_y0_h | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_Y0_H | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divY0H | |
indexListed | string | 8697 | in_sea_index_listed | in_index_listed | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | INDEX_LISTED | CHAR(50) | EagleML/referenceTransaction/genericIssueAnalytic/indexListed | |
fndChar | string | 8698 | in_sea_fnd_char | in_fnd_char | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | FND_CHAR | CHAR(20) | EagleML/referenceTransaction/genericIssueAnalytic/fndChar | |
fndCharNum | string | 8699 | in_sea_fnd_char_num | in_fnd_char_num | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | FND_CHAR_NUM | CHAR(20) | EagleML/referenceTransaction/genericIssueAnalytic/fndCharNum | |
fileDate | date | 8700 | in_sea_file_date | in_file_date | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | FILE_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/fileDate | |
gainPct | decimal | 8701 | in_sea_gain_sea_pct | in_gain_pct | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | GAIN_PCT | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/gainPct | |
sharesCur | decimal | 8702 | in_sea_shares_cur | in_shares_cur | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHARES_CUR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sharesCur | |
sharesAvg | decimal | 8703 | in_sea_shares_avg | in_shares_avg | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHARES_AVG | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sharesAvg | |
marketCap | decimal | 8704 | in_sea_market_cap | in_market_cap | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | MARKET_CAP | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/marketCap | |
monthFye | decimal | 8705 | in_sea_month_fye | in_month_fye | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | MONTH_FYE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/monthFye | |
nyseBeta | decimal | 8706 | in_sea_nyse_beta | in_nyse_beta | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | NYSE_BETA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/nyseBeta | |
quarterEnd | string | 8707 | in_sea_quarter_end | in_quarter_end | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | QUARTER_END | CHAR(20) | EagleML/referenceTransaction/genericIssueAnalytic/quarterEnd | |
recommendation | string | 8708 | in_sea_recommendation | in_recommendation | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | RECOMMENDATION | CHAR(20) | EagleML/referenceTransaction/genericIssueAnalytic/recommendation | |
sharesAvgYm2 | decimal | 8709 | in_sea_shares_avg_ym2 | in_shares_avg_ym2 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHARES_AVG_YM2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sharesAvgYm2 | |
sharesY0 | decimal | 8710 | in_sea_shares_y0 | in_shares_y0 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHARES_Y0 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sharesY0 | |
sharesYm2 | decimal | 8711 | in_sea_shares_ym2 | in_shares_ym2 | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHARES_YM2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/sharesYm2 | |
splitDate | date | 8712 | in_sea_split_date | in_split_date | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SPLIT_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/splitDate | |
splitFactor | decimal | 8713 | in_sea_split_factor | in_split_factor | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SPLIT_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/splitFactor | |
divPoS1X | decimal | 8714 | in_sea_div_po_s1_x | in_sea_div_po_s1_x | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_PO_S1_X | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divPoS1X | |
declaredDate | date | 8715 | in_sea_declared_date | in_declared_date | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DECLARED_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/declaredDate | |
splitFactorInfo | string | 8716 | in_sea_split_factor_info | in_split_factor_info | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SPLIT_FACTOR_INFO | VARCHAR2(30) | EagleML/referenceTransaction/genericIssueAnalytic/splitFactorInfo | |
divExFlag | string | 8717 | in_sea_div_ex_flag | in_div_ex_flag | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIV_EX_FLAG | VARCHAR2(8) | EagleML/referenceTransaction/genericIssueAnalytic/divExFlag | |
basis | decimal | 8718 | in_sea_basis | in_basis | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | BASIS | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/basis | |
shsUsedForEarningsComp | decimal | 8719 | in_sea_shs_used_for_earn_comp | in_shs_used_for_earnings_comp | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHS_USED_FOR_EARNINGS_COMP | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/shsUsedForEarningsComp | |
shsUsedForOwnershipComp | decimal | 8720 | in_sea_shs_used_for_own_comp | in_shs_used_for_ownership_comp | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | SHS_USED_FOR_OWNERSHIP_COMP | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/shsUsedForOwnershipComp | |
recordStatus | string | 8721 | in_sea_record_status | in_record_status | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | RECORD_STATUS | CHAR(2) | EagleML/referenceTransaction/genericIssueAnalytic/recordStatus | |
lastDivType | string | 8722 | in_sea_last_div_type | in_last_div_type | S | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | LAST_DIV_TYPE | CHAR(50) | EagleML/referenceTransaction/genericIssueAnalytic/lastDivType | |
dvdSh12mNet | decimal | 11743 | in_sea_dvd_sh_12m_net | in_dvd_sh_12m_net | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DVD_SH_12M_NET | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/dvdSh12mNet | |
dvdShIndNet | decimal | 11774 | in_sea_dvd_sh_ind_net | in_dvd_sh_ind_net | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DVD_SH_IND_NET | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/dvdShIndNet | |
indxGeneralPeRatio | decimal | 11775 | in_sea_indx_general_pe_ratio | in_indx_general_pe_ratio | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | INDX_GENERAL_PE_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/indxGeneralPeRatio | |
weightedAvgPx | decimal | 11776 | in_sea_weighted_avg_px | in_weighted_avg_px | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | WEIGHTED_AVG_PX | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/weightedAvgPx | |
pxToBookRatio | decimal | 11777 | in_sea_px_to_book_ratio | in_px_to_book_ratio | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | PX_TO_BOOK_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pxToBookRatio | |
alpha | decimal | 11778 | in_sea_alpha | in_alpha | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | ALPHA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/alpha | |
annualDividend | decimal | 3233 | not stored in DB | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/annualDividend | ||||||
divyieldFy0 | decimal | 11779 | in_sea_dividend_yield | in_dividend_yield | F | SECURITYDBO | SECURITY_ANALYTICS_EQUITY | DIVYIELD_FY0 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/divyieldFy0 | |
pd1FI | decimal | 8723 | in_sef_pd1 | in_pd1 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd1FI | |
pd2FI | decimal | 8724 | in_sef_pd2 | in_pd2 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd2FI | |
pd4FI | decimal | not stored in DB | EagleML/referenceTransaction/genericIssueAnalytic/pd4FI | ||||||||
pd3FI | decimal | 8725 | in_sef_pd3 | in_pd3 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD3 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd3FI | |
pd5FI | decimal | 8726 | in_sef_pd5 | in_pd5 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD5 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd5FI | |
pd10FI | decimal | 8727 | in_sef_pd10 | in_pd10 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD10 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd10FI | |
pd20FI | decimal | 8728 | in_sef_pd20 | in_pd20 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD20 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd20FI | |
pd30FI | decimal | 8729 | in_sef_pd30 | in_pd30 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PD30 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pd30FI | |
volatility | decimal | 8730 | in_sef_volatility | in_volatility | F | SECURITYDBO | SECURITY_ANALYTICS_FI | VOLATILITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/volatility | |
ytwCalldate | decimal | 8731 | in_sef_ytw_calldate | in_ytw_calldate | F | SECURITYDBO | SECURITY_ANALYTICS_FI | YTW_CALLDATE | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ytwCalldate | |
effectiveDurDollars | decimal | 8732 | in_sef_effective_dur_dollars | in_effective_dur_dollars | F | SECURITYDBO | SECURITY_ANALYTICS_FI | EFFECTIVE_DUR_DOLLARS | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveDurDollars | |
pricePsa | decimal | 8733 | in_sef_price_psa | in_price_psa | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PRICE_PSA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/pricePsa | |
nominalConvexity | decimal | 8734 | in_sef_nominal_convexity | in_nominal_convexity | F | SECURITYDBO | SECURITY_ANALYTICS_FI | NOMINAL_CONVEXITY | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/nominalConvexity | |
priceCpr | decimal | 8735 | in_sef_price_cpr | in_price_cpr | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PRICE_CPR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceCpr | |
priceSource | string | 8736 | in_sef_price_source | in_price_source | S | SECURITYDBO | SECURITY_ANALYTICS_FI | PRICE_SOURCE | CHAR(6) | EagleML/referenceTransaction/genericIssueAnalytic/priceSource | |
payDate | date | 8737 | in_sef_pay_date | in_pay_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | PAY_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/payDate | |
fluxDate | date | 8738 | in_sef_flux_date | in_flux_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | FLUX_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/fluxDate | |
deltaFI | decimal | 8739 | in_sef_delta | in_delta | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DELTA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/deltaFI | |
gammaFI | decimal | 8740 | in_sef_gamma | in_gamma | F | SECURITYDBO | SECURITY_ANALYTICS_FI | GAMMA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/gammaFI | |
thetaFI | decimal | 8741 | in_sef_theta | in_theta | F | SECURITYDBO | SECURITY_ANALYTICS_FI | THETA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/thetaFI | |
vegaFI | decimal | 8742 | in_sef_vega | in_vega | F | SECURITYDBO | SECURITY_ANALYTICS_FI | VEGA | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/vegaFI | |
undAssetCode | string | 8743 | in_sef_und_asset_code | in_und_asset_code | S | SECURITYDBO | SECURITY_ANALYTICS_FI | UND_ASSET_CODE | CHAR(9) | EagleML/referenceTransaction/genericIssueAnalytic/undAssetCode | |
userGroup1 | string | 8744 | in_sef_user_group1 | in_user_group1 | S | SECURITYDBO | SECURITY_ANALYTICS_FI | USER_GROUP1 | CHAR(4) | EagleML/referenceTransaction/genericIssueAnalytic/userGroup1 | |
scaleFactor | decimal | 8745 | in_sef_scale_factor | in_scale_factor | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SCALE_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/scaleFactor | |
userGroup4 | string | 8746 | in_sef_user_group4 | in_user_group4 | S | SECURITYDBO | SECURITY_ANALYTICS_FI | USER_GROUP4 | CHAR(4) | EagleML/referenceTransaction/genericIssueAnalytic/userGroup4 | |
matureDate | date | 8747 | in_sef_mature_date | in_mature_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | MATURE_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/matureDate | |
worstDate | date | 8748 | in_sef_worst_date | in_worst_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | WORST_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/worstDate | |
nextCallDate | date | 8749 | in_sef_next_call_date | in_next_call_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | NEXT_CALL_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/nextCallDate | |
fiDate1 | date | 8750 | in_sef_fi_date1 | in_fi_date1 | S | SECURITYDBO | SECURITY_ANALYTICS_FI | FI_DATE1 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/fiDate1 | |
fiDate2 | date | 8751 | in_sef_fi_date2 | in_fi_date2 | S | SECURITYDBO | SECURITY_ANALYTICS_FI | FI_DATE2 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/fiDate2 | |
saFiFloat1 | decimal | 8752 | in_sef_sa_fi_float1 | in_sa_fi_float1 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat1 | |
saFiFloat2 | decimal | 8753 | in_sef_sa_fi_float2 | in_sa_fi_float2 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat2 | |
saFiFloat3 | decimal | 8754 | in_sef_sa_fi_float3 | in_sa_fi_float3 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat3 | |
saFiFloat4 | decimal | 8755 | in_sef_sa_fi_float4 | in_sa_fi_float4 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT4 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat4 | |
saFiFloat5 | decimal | 8756 | in_sef_sa_fi_float5 | in_sa_fi_float5 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT5 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat5 | |
saFiFloat6 | decimal | 8757 | in_sef_sa_fi_float6 | in_sa_fi_float6 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT6 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat6 | |
saFiFloat7 | decimal | 8758 | in_sef_sa_fi_float7 | in_sa_fi_float7 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT7 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat7 | |
saFiFloat8 | decimal | 8759 | in_sef_sa_fi_float8 | in_sa_fi_float8 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT8 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat8 | |
saFiFloat9 | decimal | 8760 | in_sef_sa_fi_float9 | in_sa_fi_float9 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT9 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat9 | |
saFiFloat10 | decimal | 8761 | in_sef_sa_fi_float10 | in_sa_fi_float10 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT10 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat10 | |
saFiFloat11 | decimal | 8762 | in_sef_sa_fi_float11 | in_sa_fi_float11 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT11 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat11 | |
saFiFloat12 | decimal | 8763 | in_sef_sa_fi_float12 | in_sa_fi_float12 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT12 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat12 | |
saFiFloat13 | decimal | 8764 | in_sef_sa_fi_float13 | in_sa_fi_float13 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT13 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat13 | |
saFiFloat14 | decimal | 8765 | in_sef_sa_fi_float14 | in_sa_fi_float14 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT14 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat14 | |
saFiFloat15 | decimal | 8766 | in_sef_sa_fi_float15 | in_sa_fi_float15 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT15 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat15 | |
saFiFloat16 | decimal | 8767 | in_sef_sa_fi_float16 | in_sa_fi_float16 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT16 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat16 | |
saFiFloat17 | decimal | 8768 | in_sef_sa_fi_float17 | in_sa_fi_float17 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SA_FI_FLOAT17 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/saFiFloat17 | |
yieldToWorstPut | decimal | 10537 | in_sef_yield_to_worst_put | in_yield_to_worst_put | F | SECURITYDBO | SECURITY_ANALYTICS_FI | YIELD_TO_WORST_PUT | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/yieldToWorstPut | |
effectiveModifiedDuration | decimal | 10540 | in_sef_effective_modified_dur | in_effective_modified_duration | I | SECURITYDBO | SECURITY_ANALYTICS_FI | EFFECTIVE_MODIFIED_DURATION | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/effectiveModifiedDuration | |
accruedInterest | decimal | 2880 | in_sef_accrued_interest | in_accrued_interest | F | SECURITYDBO | SECURITY_ANALYTICS_FI | ACCRUED_INTEREST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/accruedInterest | |
nominalAccruedInterest | decimal | 2881 | in_sef_nominal_accrued_intrst | in_nominal_accrued_interest | F | SECURITYDBO | SECURITY_ANALYTICS_FI | NOMINAL_ACCRUED_INTEREST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/nominalAccruedInterest | |
daysAccruedInterest | integer | 2882 | in_sef_days_accrued_interest | in_days_accrued_interest | I | SECURITYDBO | SECURITY_ANALYTICS_FI | DAYS_ACCRUED_INTEREST | NUMBER(38) | EagleML/referenceTransaction/genericIssueAnalytic/daysAccruedInterest | |
basisPointValue | decimal | 2883 | in_sef_basis_point_value | in_basis_point_value | F | SECURITYDBO | SECURITY_ANALYTICS_FI | BASIS_POINT_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/basisPointValue | |
yieldChgBpIncrease | decimal | 2884 | in_sef_yield_chg_bp_increase | in_yield_chg_bp_increase | F | SECURITYDBO | SECURITY_ANALYTICS_FI | YIELD_CHG_BP_INCREASE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/yieldChgBpIncrease | |
nextCashflowDate | date | 2885 | in_sef_next_cashflow_date | in_next_cashflow_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | NEXT_CASHFLOW_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/nextCashflowDate | |
prevCashflowDate | date | 2886 | in_sef_prev_cashflow_date | in_prev_cashflow_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | PREV_CASHFLOW_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/prevCashflowDate | |
daysToNextCashflow | integer | 2887 | in_sef_days_to_next_cashflow | in_days_to_next_cashflow | I | SECURITYDBO | SECURITY_ANALYTICS_FI | DAYS_TO_NEXT_CASHFLOW | NUMBER(38) | EagleML/referenceTransaction/genericIssueAnalytic/daysToNextCashflow | |
remainingCashflows | integer | 2888 | in_sef_remaining_cashflows | in_remaining_cashflows | I | SECURITYDBO | SECURITY_ANALYTICS_FI | REMAINING_CASHFLOWS | NUMBER(38) | EagleML/referenceTransaction/genericIssueAnalytic/remainingCashflows | |
couponExDate | date | 2889 | in_sef_coupon_ex_date | in_coupon_ex_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | COUPON_EX_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/couponExDate | |
expectedExerciseYears | decimal | 2890 | in_sef_expected_exercise_years | in_expected_exercise_years | F | SECURITYDBO | SECURITY_ANALYTICS_FI | EXPECTED_EXERCISE_YEARS | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/expectedExerciseYears | |
callExerciseProbability | decimal | 2891 | in_sef_call_exercise_prob | in_call_exercise_probability | F | SECURITYDBO | SECURITY_ANALYTICS_FI | CALL_EXERCISE_PROBABILITY | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/callExerciseProbability | |
putExerciseProbability | decimal | 2892 | in_sef_put_exercise_prob | in_put_exercise_probability | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PUT_EXERCISE_PROBABILITY | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/putExerciseProbability | |
redemptionValue | decimal | 2893 | in_sef_redemption_value | in_redemption_value | F | SECURITYDBO | SECURITY_ANALYTICS_FI | REDEMPTION_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/redemptionValue | |
currentCoupon | decimal | 2894 | in_sef_current_coupon | in_current_coupon | F | SECURITYDBO | SECURITY_ANALYTICS_FI | CURRENT_COUPON | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/currentCoupon | |
shortDesc | string | 1102 | in_src_intfc_inst | in_src_intfc_inst | S | SECURITYDBO | SECURITY_ANALYTICS_FI | SRC_INTFC_INST | CHAR(15) | EagleML/referenceTransaction/genericIssueAnalytic/shortDesc | |
localAccIntFactor | string | not stored in DB | EagleML/referenceTransaction/genericIssueAnalytic/localAccIntFactor | ||||||||
yieldValueOf32Nd | decimal | 8510 | in_sef_yield_value_of_32nd | in_yield_value_of_32nd | F | SECURITYDBO | SECURITY_ANALYTICS_FI | YIELD_VALUE_OF_32ND | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/yieldValueOf32Nd | |
dollarDuration | decimal | 8525 | in_sef_dollar_duration | in_dollar_duration | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DOLLAR_DURATION | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/dollarDuration | |
dv01 | decimal | 8526 | in_sef_dv01 | in_dv01 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV01 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/dv01 | |
basisPointValueCurve | decimal | 8527 | in_sef_basis_point_value_curve | in_basis_point_value_curve | F | SECURITYDBO | SECURITY_ANALYTICS_FI | BASIS_POINT_VALUE_CURVE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/basisPointValueCurve | |
presentValueCashFlows | decimal | 8528 | in_sef_present_value_cash_fl | in_present_value_cash_flows | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PRESENT_VALUE_CASH_FLOWS | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/presentValueCashFlows | |
pvCashFlowsPosShock | decimal | 8529 | in_sef_pv_cash_flows_pos_shock | in_pv_cash_flows_pos_shock | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PV_CASH_FLOWS_POS_SHOCK | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/pvCashFlowsPosShock | |
pvCashFlowsNegShock | decimal | 8530 | in_sef_pv_cash_flows_neg_shock | in_pv_cash_flows_neg_shock | F | SECURITYDBO | SECURITY_ANALYTICS_FI | PV_CASH_FLOWS_NEG_SHOCK | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/pvCashFlowsNegShock | |
recoveryRate | decimal | 8531 | in_sef_recovery_rate | in_recovery_rate | F | SECURITYDBO | SECURITY_ANALYTICS_FI | RECOVERY_RATE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/recoveryRate | |
valuePayoff | decimal | 8532 | in_sef_value_payoff | in_value_payoff | F | SECURITYDBO | SECURITY_ANALYTICS_FI | VALUE_PAYOFF | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/valuePayoff | |
valuePremium | decimal | 8533 | in_sef_value_premium | in_value_premium | F | SECURITYDBO | SECURITY_ANALYTICS_FI | VALUE_PREMIUM | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/valuePremium | |
dv0x | decimal | 8534 | in_sef_dv0x | in_dv0x | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV0X | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/dv0x | |
couponPrincipal | decimal | 8546 | in_sef_coupon_principal | in_coupon_principal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | COUPON_PRINCIPAL | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/couponPrincipal | |
matDateCashFlow | decimal | 8944 | in_sef_mat_date_cash_flow | in_mat_date_cash_flow | F | SECURITYDBO | SECURITY_ANALYTICS_FI | MAT_DATE_CASH_FLOW | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/matDateCashFlow | |
indexRatio | decimal | 4936 | in_sef_index_ratio | in_index_ratio | F | SECURITYDBO | SECURITY_ANALYTICS_FI | INDEX_RATIO | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/indexRatio | |
currentResetRate | decimal | 4937 | in_sef_current_reset_rate | in_current_reset_rate | F | SECURITYDBO | SECURITY_ANALYTICS_FI | CURRENT_RESET_RATE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/currentResetRate | |
currentBalance | decimal | 4938 | in_sef_current_balance | in_current_balance | F | SECURITYDBO | SECURITY_ANALYTICS_FI | CURRENT_BALANCE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/currentBalance | |
forwardRate | decimal | 4939 | in_sef_forward_rate | in_forward_rate | F | SECURITYDBO | SECURITY_ANALYTICS_FI | FORWARD_RATE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/forwardRate | |
compensationPayment | decimal | 4940 | in_sef_compensation_payment | in_compensation_payment | F | SECURITYDBO | SECURITY_ANALYTICS_FI | COMPENSATION_PAYMENT | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/compensationPayment | |
referenceIndexValue | decimal | 4941 | in_sef_reference_index_value | in_reference_index_value | F | SECURITYDBO | SECURITY_ANALYTICS_FI | REFERENCE_INDEX_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/referenceIndexValue | |
zSpread | decimal | 4942 | in_sef_z_spread | in_z_spread | F | SECURITYDBO | SECURITY_ANALYTICS_FI | Z_SPREAD | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/zSpread | |
nextCouponExDate | date | 4943 | in_sef_next_coupon_ex_date | in_next_coupon_ex_date | S | SECURITYDBO | SECURITY_ANALYTICS_FI | NEXT_COUPON_EX_DATE | DATE | EagleML/referenceTransaction/genericIssueAnalytic/nextCouponExDate | |
basisPointValueWrst | decimal | 4944 | in_sef_basis_point_value_wrst | in_basis_point_value_wrst | F | SECURITYDBO | SECURITY_ANALYTICS_FI | BASIS_POINT_VALUE_WRST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/basisPointValueWrst | |
yieldChgBpIncrWrst | decimal | 4945 | in_sef_yield_chg_bp_incr_wrst | in_yield_chg_bp_increase_wrst | F | SECURITYDBO | SECURITY_ANALYTICS_FI | YIELD_CHG_BP_INCR_WRST | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/yieldChgBpIncrWrst | |
discountMargin | decimal | 4947 | in_sef_discount_margin | in_discount_margin | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DISCOUNT_MARGIN | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/discountMargin | |
dv100 | decimal | 16836 | in_sef_dv100 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV100 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/dv100 | ||
sdv01 | decimal | 16837 | in_sef_sdv01 | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SDV01 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/sdv01 | ||
dv01Bid | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV01_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/dv01Bid | ||||
dv01Ask | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV01_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/dv01Ask | ||||
dv01Mid | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV01_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/dv01Mid | ||||
sdv01Bid | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SDV01_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/sdv01Bid | ||||
sdv01Ask | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SDV01_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/sdv01Ask | ||||
sdv01Mid | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | SDV01_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/sdv01Mid | ||||
dv100Bid | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV100_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/dv100Bid | ||||
dv100Ask | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV100_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/dv100Ask | ||||
dv100Mid | decimal | F | SECURITYDBO | SECURITY_ANALYTICS_FI | DV100_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/dv100Mid | ||||
priceEarnEquityModel | PriceEarnEquityModel - complex type (see extra table below) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/ | |||||||||
ePSEquityModel | EPSEquityModel - complex type (see extra table below) | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/ | |||||||||
analyticsUserModel | AnalyticsUserModel - complex type (see extra table below) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/ | |||||||||
analyticDervModel | AnalyticDervModel - complex type (see extra table below) | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/ | |||||||||
analyticExtModel | AnalyticExtModel - complex type (see extra table below) | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/ | |||||||||
Elements of the following models are loaded via dynamic SQL PriceEarnEquityModel Data Map Table | |||||||||||
Element | Optional/Required | Value Type | Star Tag | SP Parameter (EagleML version >= 13.1) | SP Parameter (EagleML version < 13.1) | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
priceToBook | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | PRICE_TO_BOOK | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/priceToBook | |||||
priceCashFlow | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | PRICE_CASH_FLOW | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/priceCashFlow | |||||
rpeEst1L1 | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | RPE_EST1_L1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/rpeEst1L1 | |||||
rpeEst2L1 | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | RPE_EST2_L1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/rpeEst2L1 | |||||
peEst1L1 | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | PE_EST1_L1 | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/peEst1L1 | |||||
meanEstLongTermGrowth | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | MEAN_EST_LONG_TERM_GROWTH | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/meanEstLongTermGrowth | |||||
priceToSales | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | PRICE_TO_SALES | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/priceToSales | |||||
avgRoe5Yr | decimal | SECURITYDBO | SECURITY_PRICE_EARN_EQUITY | AVG_ROE_5Y (v15) AVG_ROE_5YR (other versions) | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/priceEarnEquityModel/avgRoe5Yr | |||||
EPSEquityModel Data Map Table | |||||||||||
Element | Optional/Required | Value Type | Star Tag | SP Parameter (EagleML version >= 13.1) | SP Parameter (EagleML version < 13.1) | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
epsChgY2L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_CHG_Y2_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsChgY2L1 | ||||||
epsChgY2L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_CHG_Y2_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsChgY2L2 | ||||||
epsChgY3L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_CHG_Y3_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsChgY3L1 | ||||||
epsChgY3L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_CHG_Y3_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsChgY3L2 | ||||||
epsChgY4L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_CHG_Y4_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsChgY4L1 | ||||||
epsChgY4L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_CHG_Y4_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsChgY4L2 | ||||||
epsEst1X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_EST1_X | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsEst1X | |||||
epsEst1XFN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_EST1_X_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsEst1XFN | ||||||
epsEst2X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_EST2_X | NUMBER(28,12) | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsEst2X | |||||
epsEst2XFN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_EST2_X_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsEst2XFN | ||||||
epsGrBase | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_GR_BASE | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsGrBase | ||||||
epsGrS2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_GR_S2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsGrS2 | ||||||
epsGrS4 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_GR_S4 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsGrS4 | ||||||
epsGrY3 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_GR_Y3 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsGrY3 | ||||||
epsGrY5 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_GR_Y5 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsGrY5 | ||||||
epsGrY10 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_GR_Y10 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsGrY10 | ||||||
epsY0X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y0_X | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY0X | ||||||
epsY0XFN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y0_X_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY0XFN | ||||||
epsY1X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y1_X | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY1X | ||||||
epsY1XFN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y1_X_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY1XFN | ||||||
epsY2X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y2_X | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY2X | ||||||
epsY2XFN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y2_X_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY2XFN | ||||||
epsY3X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y3_X | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY3X | ||||||
epsY3XFN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y3_X_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY3XFN | ||||||
epsY0L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y0_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY0L1 | ||||||
epsY0L1FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y0_L1_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY0L1FN | ||||||
epsY0L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y0_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY0L2 | ||||||
epsY0L2FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_YO_L2_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY0L2FN | ||||||
epsY1L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y1_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY1L1 | ||||||
epsY1L1FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y1_L1_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY1L1FN | ||||||
epsY1L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y1_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY1L2 | ||||||
epsY1L2FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y1_L2_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY1L2FN | ||||||
epsY2L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y2_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY2L1 | ||||||
epsY2L1FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y2_L1_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY2L1FN | ||||||
epsY2L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y2_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY2L2 | ||||||
epsY2L2FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y2_L2_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY2L2FN | ||||||
epsY3L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y3_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY3L1 | ||||||
epsY3L1FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y3_L1_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY3L1FN | ||||||
epsY3L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y3_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY3L2 | ||||||
epsY3L2FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y3_L2_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY3L2FN | ||||||
epsY4L1 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y4_L1 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY4L1 | ||||||
epsY4L1FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y4_L1_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY4L1FN | ||||||
epsY4L2 | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y4_L2 | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY4L2 | ||||||
epsY4L2FN | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_Y4_L2_FN | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsY4L2FN | ||||||
epsYcQCX | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_YC_QC_X | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsYcQCX | ||||||
epsYcQP | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_YC_QP | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsYcQP | ||||||
epsYpQC | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_YP_QC | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsYpQC | ||||||
epsLast12Mnth | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_LAST_12MNTH | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsLast12Mnth | ||||||
epsLtmL1X | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_LTM_L1_X | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsLtmL1X | ||||||
epsNorm | decimal | SECURITYDBO | SECURITY_EPS_EQUITY | EPS_NORM | EagleML/referenceTransaction/genericIssueAnalytic/ePSEquityModel/epsNorm | ||||||
AnalyticsUserModel Data Map TableThis model might have issues on 2015R3 ORA regions - contact your Eagle representative in that case | |||||||||||
Element | Optional/Required | Value Type | Star Tag | SP Parameter (EagleML version >= 13.1) | SP Parameter (EagleML version < 13.1) | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
userSaChar1 | string | 16312 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR1 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar1 | ||||
userSaChar2 | string | 16319 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR2 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar2 | ||||
userSaChar3 | string | 16320 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR3 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar3 | ||||
userSaChar4 | string | 16321 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR4 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar4 | ||||
userSaChar5 | string | 16322 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR5 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar5 | ||||
userSaChar6 | string | 16323 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR6 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar6 | ||||
userSaChar7 | string | 16324 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR7 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar7 | ||||
userSaChar8 | string | 16325 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR8 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar8 | ||||
userSaChar9 | string | 16326 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR9 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar9 | ||||
userSaChar10 | string | 16313 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR10 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar10 | ||||
userSaChar11 | string | 16314 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR11 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar11 | ||||
userSaChar12 | string | 16315 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR12 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar12 | ||||
userSaChar13 | string | 16316 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR13 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar13 | ||||
userSaChar14 | string | 16317 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR14 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar14 | ||||
userSaChar15 | string | 16318 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR15 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar15 | ||||
userSaChar16* (supported only in 2017R1) | string | 16415 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR16 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar16 | ||||
userSaChar17* (supported only in 2017R1) | string | 16416 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR17 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar17 | ||||
userSaChar18* (supported only in 2017R1) | string | 16417 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR18 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar18 | ||||
userSaChar19* (supported only in 2017R1) | string | 16418 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR19 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar19 | ||||
userSaChar20* (supported only in 2017R1) | string | 16419 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR20 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar20 | ||||
userSaChar21* (supported only in 2017R1) | string | 16420 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR21 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar21 | ||||
userSaChar22* (supported only in 2017R1) | string | 16421 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR22 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar22 | ||||
userSaChar23* (supported only in 2017R1) | string | 16422 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR23 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar23 | ||||
userSaChar24* (supported only in 2017R1) | string | 16423 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR24 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar24 | ||||
userSaChar25* (supported only in 2017R1) | string | 16424 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR25 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar25 | ||||
userSaChar26* (supported only in 2017R1) | string | 16425 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR26 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar26 | ||||
userSaChar27* (supported only in 2017R1) | string | 16426 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR27 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar27 | ||||
userSaChar28* (supported only in 2017R1) | string | 16327 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR28 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar28 | ||||
userSaChar29* (supported only in 2017R1) | string | 16328 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR29 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar29 | ||||
userSaChar30* (supported only in 2017R1) | string | 16329 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_CHAR30 | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaChar30 | ||||
userSaDate1 | date | 16327 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE1 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate1 | ||||
userSaDate2 | date | 16329 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE2 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate2 | ||||
userSaDate3 | date | 16330 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE3 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate3 | ||||
userSaDate4 | date | 16331 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE4 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate4 | ||||
userSaDate5 | date | 16332 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE5 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate5 | ||||
userSaDate6 | date | 16333 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE6 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate6 | ||||
userSaDate7 | date | 16334 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE7 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate7 | ||||
userSaDate8 | date | 16335 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE8 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate8 | ||||
userSaDate9 | date | 16336 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE9 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate9 | ||||
userSaDate10 | date | 16328 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_DATE10 | DATE | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaDate10 | ||||
userSaFloat1 | decimal | 16337 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT1 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat1 | ||||
userSaFloat2 | decimal | 16348 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT2 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat2 | ||||
userSaFloat3 | decimal | 16359 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT3 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat3 | ||||
userSaFloat4 | decimal | 16370 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT4 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat4 | ||||
userSaFloat5 | decimal | 16381 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT5 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat5 | ||||
userSaFloat6 | decimal | 16392 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT6 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat6 | ||||
userSaFloat7 | decimal | 16403 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT7 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat7 | ||||
userSaFloat8 | decimal | 16405 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT8 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat8 | ||||
userSaFloat9 | decimal | 16406 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT9 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat9 | ||||
userSaFloat10 | decimal | 16338 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT10 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat10 | ||||
userSaFloat11 | decimal | 16339 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT11 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat11 | ||||
userSaFloat12 | decimal | 16340 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT12 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat12 | ||||
userSaFloat13 | decimal | 16341 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT13 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat13 | ||||
userSaFloat14 | decimal | 16342 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT14 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat14 | ||||
userSaFloat15 | decimal | 16343 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT15 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat15 | ||||
userSaFloat16 | decimal | 16344 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT16 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat16 | ||||
userSaFloat17 | decimal | 16345 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT17 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat17 | ||||
userSaFloat18 | decimal | 16346 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT18 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat18 | ||||
userSaFloat19 | decimal | 16347 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT19 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat19 | ||||
userSaFloat20 | decimal | 16349 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT20 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat20 | ||||
userSaFloat21 | decimal | 16350 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT21 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat21 | ||||
userSaFloat22 | decimal | 16351 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT22 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat22 | ||||
userSaFloat23 | decimal | 16352 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT23 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat23 | ||||
userSaFloat24 | decimal | 16353 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT24 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat24 | ||||
userSaFloat25 | decimal | 16354 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT25 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat25 | ||||
userSaFloat26 | decimal | 16355 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT26 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat26 | ||||
userSaFloat27 | decimal | 16356 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT27 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat27 | ||||
userSaFloat28 | decimal | 16357 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT28 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat28 | ||||
userSaFloat29 | decimal | 16358 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT29 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat29 | ||||
userSaFloat30 | decimal | 16360 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT30 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat30 | ||||
userSaFloat31 | decimal | 16361 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT31 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat31 | ||||
userSaFloat32 | decimal | 16362 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT32 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat32 | ||||
userSaFloat33 | decimal | 16363 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT33 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat33 | ||||
userSaFloat34 | decimal | 16364 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT34 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat34 | ||||
userSaFloat35 | decimal | 16365 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT35 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat35 | ||||
userSaFloat36 | decimal | 16366 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT36 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat36 | ||||
userSaFloat37 | decimal | 16367 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT37 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat37 | ||||
userSaFloat38 | decimal | 16368 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT38 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat38 | ||||
userSaFloat39 | decimal | 16369 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT39 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat39 | ||||
userSaFloat40 | decimal | 16371 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT40 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat40 | ||||
userSaFloat41 | decimal | 16372 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT41 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat41 | ||||
userSaFloat42 | decimal | 16373 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT42 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat42 | ||||
userSaFloat43 | decimal | 16374 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT43 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat43 | ||||
userSaFloat44 | decimal | 16375 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT44 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat44 | ||||
userSaFloat45 | decimal | 16376 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT45 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat45 | ||||
userSaFloat46 | decimal | 16377 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT46 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat46 | ||||
userSaFloat47 | decimal | 16378 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT47 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat47 | ||||
userSaFloat48 | decimal | 16379 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT48 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat48 | ||||
userSaFloat49 | decimal | 16380 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT49 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat49 | ||||
userSaFloat50 | decimal | 16382 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT50 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat50 | ||||
userSaFloat51 | decimal | 16383 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT51 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat51 | ||||
userSaFloat52 | decimal | 16384 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT52 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat52 | ||||
userSaFloat53 | decimal | 16385 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT53 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat53 | ||||
userSaFloat54 | decimal | 16386 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT54 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat54 | ||||
userSaFloat55 | decimal | 16387 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT55 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat55 | ||||
userSaFloat56 | decimal | 16388 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT56 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat56 | ||||
userSaFloat57 | decimal | 16389 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT57 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat57 | ||||
userSaFloat58 | decimal | 16390 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT58 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat58 | ||||
userSaFloat59 | decimal | 16391 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT59 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat59 | ||||
userSaFloat60 | decimal | 16393 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT60 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat60 | ||||
userSaFloat61 | decimal | 16394 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT61 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat61 | ||||
userSaFloat62 | decimal | 16395 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT62 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat62 | ||||
userSaFloat63 | decimal | 16396 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT63 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat63 | ||||
userSaFloat64 | decimal | 16397 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT64 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat64 | ||||
userSaFloat65 | decimal | 16398 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT65 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat65 | ||||
userSaFloat66 | decimal | 16399 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT66 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat66 | ||||
userSaFloat67 | decimal | 16400 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT67 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat67 | ||||
userSaFloat68 | decimal | 16401 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT68 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat68 | ||||
userSaFloat69 | decimal | 16402 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT69 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat69 | ||||
userSaFloat70 | decimal | 16404 | SECURITYDBO | SECURITY_ANALYTICS_USER | USER_SA_FLOAT70 | NUMBER(38,12) | EagleML/referenceTransaction/genericIssueAnalytic/analyticsUserModel/userSaFloat70 | ||||
AnalyticDervModel Data Map Table | |||||||||||
deltaBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | DELTA_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/deltaBid | |||||
deltaAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | DELTA_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/deltaAsk | |||||
deltaMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | DELTA_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/deltaMid | |||||
deltaLast | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | DELTA_LAST | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/deltaLast | |||||
gammaBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | GAMMA_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/gammaBid | |||||
gammaAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | GAMMA_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/gammaAsk | |||||
gammaMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | GAMMA_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/gammaMid | |||||
gammaLast | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | GAMMA_LAST | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/gammaLast | |||||
vegaBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | VEGA_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/vegaBid | |||||
vegaAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | VEGA_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/vegaAsk | |||||
vegaMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | VEGA_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/vegaMid | |||||
vegaLast | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | VEGA_LAST | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/vegaLast | |||||
impliedVolatility | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | IMPLIED_VOLATILITY | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/impliedVolatility | |||||
impliedVolatilityBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | IMPLIED_VOLATILITY_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/impliedVolatilityBid | |||||
impliedVolatilityAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | IMPLIED_VOLATILITY_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/impliedVolatilityAsk | |||||
impliedVolatilityMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | IMPLIED_VOLATILITY_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/impliedVolatilityMid | |||||
impliedVolatilityLast | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | IMPLIED_VOLATILITY_LAST | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/impliedVolatilityLast | |||||
intrinsicValue | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | INTRINSIC_VALUE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/intrinsicValue | |||||
tradeMatchVolatilityPrice | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | TRADE_MATCH_VOL_PRICE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/tradeMatchVolatilityPrice | |||||
theoreticalValue | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | THEORETICAL_VALUE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/theoreticalValue | |||||
optionUndNotionallRisk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | OPTION_UNDL_NOTL_RISK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/optionUndNotionallRisk | |||||
optionBeyRisk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | OPTION_BEY_RISK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/optionBeyRisk | |||||
optionPointValue | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | OPTION_POINT_VALUE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/optionPointValue | |||||
daysToExpiration | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | DAYS_TO_EXPIRATION | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/daysToExpiration | |||||
ctdBeyRisk | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | CTD_BEY_RISK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/ctdBeyRisk | |||||
financeRate | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | FINANCE_RATE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/financeRate | |||||
financeRateCurrency | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | FINANCE_RATE_CURRENCY | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/financeRateCurrency | |||||
timeValue | decimal | SECURITYDBO | SECURITY_ANALYTICS_DERV | TIME_VALUE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticDervModel/timeValue | |||||
AnalyticExtModel Data Map Table | |||||||||||
roundLotSize | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | ROUND_LOT_SIZE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/roundLotSize | |||||
priceToCashFlow | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | PRICE_TO_CASH_FLOW | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/priceToCashFlow | |||||
tradeLotSize | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | TRADE_LOT_SIZE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/tradeLotSize | |||||
sortinoRatio | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | SORTINO_RATIO | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/sortinoRatio | |||||
abbrevTradingPeriod | string | SECURITYDBO | SECURITY_ANALYTICS_EXT | ABBREV_TRADING_PERIOD | VARCHAR2(255) | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/abbrevTradingPeriod | |||||
averageVolume5d | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | AVERAGE_VOLUME_5D | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/averageVolume5d | |||||
averageVolume20d | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | AVERAGE_VOLUME_20D | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/averageVolume20d | |||||
interpolYieldSpread | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | INTERPOL_YLD_SPREAD | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/interpolYieldSpread | |||||
interpolYieldSpreadGovt | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | INTERPOL_YLD_SPREAD_GOVT | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/interpolYieldSpreadGovt | |||||
zBasisConstMaturity | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | ZSPREAD_BASIS_CONST_MTY | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/zBasisConstMaturity | |||||
assetSwapSpread | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | ASSET_SWAP_SPREAD | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/assetSwapSpread | |||||
ytmBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | YTM_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/ytmBid | |||||
ytmAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | YTM_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/ytmAsk | |||||
ytmMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | YTM_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/ytmMid | |||||
pricePositionMultiplier | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | PRICE_POS_MULTIPLIER | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/pricePositionMultiplier | |||||
maxDrawdownLength | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MAX_DRAWDOWN_LENGTH | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/maxDrawdownLength | |||||
maxDrawdownPercent | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MAX_DRAWDOWN_PERCENT | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/maxDrawdownPercent | |||||
dvdYield12m | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | DVD_YLD_12M | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/dvdYield12m | |||||
peRatioEst | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | PE_RATIO_EST | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/peRatioEst | |||||
epsLtg | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | EPS_LTG | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/epsLtg | |||||
downsideRisk | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | DOWNSIDE_RISK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/downsideRisk | |||||
totalVotingShares | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | TOTAL_VOTING_SHARES | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/totalVotingShares | |||||
totalNonVotingShares | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | TOTAL_NON_VOTING_SHARES | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/totalNonVotingShares | |||||
convexityOasBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | CONVEXITY_OAS_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/convexityOasBid | |||||
convexityOasAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | CONVEXITY_OAS_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/convexityOasAsk | |||||
convexityOasMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | CONVEXITY_OAS_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/convexityOasMid | |||||
modDurationBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MOD_DURATION_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/modDurationBid | |||||
modDurationAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MOD_DURATION_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/modDurationAsk | |||||
modDurationMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MOD_DURATION_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/modDurationMid | |||||
macaulayDurationBid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MACAULAY_DURATION_BID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/macaulayDurationBid | |||||
macaulayDurationAsk | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MACAULAY_DURATION_ASK | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/macaulayDurationAsk | |||||
macaulayDurationMid | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | MACAULAY_DURATION_MID | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/macaulayDurationMid | |||||
sharpeRatio | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | SHARPE_RATIO | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/sharpeRatio | |||||
underlyingContValue | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | UNDERLYING_CONT_VALUE | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/underlyingContValue | |||||
volatility30d | decimal | SECURITYDBO | SECURITY_ANALYTICS_EXT | VOLATILITY_30D | NUMBER | EagleML/referenceTransaction/genericIssueAnalytic/analyticExtModel/volatility30d |