| | | | SP Parameter (EagleML version >= 13.1) | SP Parameter (EagleML version < 13.1) | | | | | | |
|---|
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 |
nextSinkPrice | | decimal | 16702 | | | | SECURITYDBO | SECURITY_ANALYTICS_FI | NEXT_SINK_PRICE | | EagleML/referenceTransaction/genericIssueAnalytic/nextSinkPrice |
marketYield | | decimal | 16703 | | | | SECURITYDBO | SECURITY_ANALYTICS_FI | MARKET_YIELD | | EagleML/referenceTransaction/genericIssueAnalytic/marketYield |
optionCost | | decimal | 16704 | | | | SECURITYDBO | SECURITY_ANALYTICS_FI | OPTION_COST | | EagleML/referenceTransaction/genericIssueAnalytic/optionCost |
nomSpread | | decimal | 16706 | | | | SECURITYDBO | SECURITY_ANALYTICS_FI | NOM_SPREAD | | EagleML/referenceTransaction/genericIssueAnalytic/nomSpread |
modifiedDurationIndicator | | string | 18266 | | | | SECURITYDBO | SECURITY_ANALYTICS_FI | MODDURIND | | EagleML/referenceTransaction/genericIssueAnalytic/modifiedDurationIndicatior |
globalFacilityAmount | | decimal | 18268 | | | | SECURITYDBO | SECURITY_ANALYTICS | GLOBAL_FACILITY_AMOUNT | | EagleML/referenceTransaction/genericIssueAnalytic/globalFacilityAmount |
privateSecurityType | | string | 18269 | | | | SECURITYDBO | SECURITY_ANALYTICS | PVT_SECURITY_TYPE | | EagleML/referenceTransaction/genericIssueAnalytic/privateSecurityType |
absCollateralDescription | | string | 18270 | | | | SECURITYDBO | SECURITY_ANALYTICS | ABS_COLLATERAL | | EagleML/referenceTransaction/genericIssueAnalytic/absCollateralDescription |
riskCurrencyBloc | | string | 18271 | | | | SECURITYDBO | SECURITY_ANALYTICS | RISK_BLOC | | EagleML/referenceTransaction/genericIssueAnalytic/riskCurrencyBloc |
cashFlowIndicator | | YesNoOption | 18272 | | | | SECURITYDBO | SECURITY_ANALYTICS | DB_CF_IND | | EagleML/referenceTransaction/genericIssueAnalytic/cashFlowIndicator |
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/ |
analyticMtgModel | AnalyticMtgModel - complex type (see extra table below) | |
Elements of the following models are loaded via dynamic SQL
Please note that some fields are not available on certain DB versions
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 |
benchmarkSpreadBid | | decimal | 18323 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | BENCHMARK_SPREAD_BID | NUMBER | genericIssueAnalytic/analyticExtModel/benchmarkSpreadBid |
benchmarkSpreadMid | | decimal | 18324 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | BENCHMARK_SPREAD_MID | NUMBER | genericIssueAnalytic/analyticExtModel/benchmarkSpreadMid |
benchmarkSpreadAsk | | decimal | 18325 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | BENCHMARK_SPREAD_ASK | NUMBER | genericIssueAnalytic/analyticExtModel/benchmarkSpreadAsk |
benchmarkId | | string | 18326 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | BENCHMARK_ID | VARCHAR2(255) | genericIssueAnalytic/analyticExtModel/benchmarkId |
indexSide | | string | 18327 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | INDEX_SIDE | VARCHAR2(255) | genericIssueAnalytic/analyticExtModel/indexSide |
workoutDate | | date | 18394 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | WORKOUT_DATE | DATE | genericIssueAnalytic/analyticExtModel/workoutDate |
workoutPrice | | decimal | 18395 | | | | SECURITYDBO | SECURITY_ANALYTICS_EXT | WORKOUT_PRICE | NUMBER | genericIssueAnalytic/analyticExtModel/workoutPrice |