Exchange Price Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Larry Ackerman
- Olga Galis (Deactivated)
Owned by Dmitry Donosiyan (Unlicensed)
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|---|---|---|---|---|---|---|---|---|---|
| objectType | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/exchangePrice/objectType | ||||||
| objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/exchangePrice/objectId | ||||||
| objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/exchangePrice/objectDescription | ||||||
| updateTimestamp | Required | dateTime | SECURITYDBO | PRICE_EXCHANGE | UPDATE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/updateTimestamp | ||
| customElements | Not recommended | CustomElements | reserved for customization | EagleML/referenceTransaction/exchangePrice/customElements/ | |||||
| sourceName | string | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | EagleML/referenceTransaction/exchangePrice/sourceName | ||
| updateSource | string | 944 | in_upd_src | SECURITYDBO | PRICE_EXCHANGE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/updateSource | |
| effectiveDate | Required | date | 1109 | in_eff_dt | SECURITYDBO | PRICE_EXCHANGE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/effectiveDate |
| languageId | integer | not stored in DB | EagleML/referenceTransaction/exchangePrice/languageId | ||||||
| tagNochangecase | string | 4637 | not stored in DB | EagleML/referenceTransaction/exchangePrice/tagNochangecase | |||||
| preserveNull | string | not stored in DB | EagleML/referenceTransaction/exchangePrice/preserveNull | ||||||
| noLoadValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/exchangePrice/noLoadValidationFlag | ||||||
| accountingValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/exchangePrice/accountingValidationFlag | ||||||
| Asset Identifiers Model | EagleML/referenceTransaction/exchangePrice/ | ||||||||
| priceExchangeCode | string | 9036 | not stored in DB | EagleML/referenceTransaction/exchangePrice/priceExchangeCode | |||||
| archiveFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/exchangePrice/archiveFlag | ||||||
| excludePriceDemandFlag | YesNoOptionEnum | 1256 | not stored in DB | EagleML/referenceTransaction/exchangePrice/excludePriceDemandFlag | |||||
| exceptionProcessingSwitch | YesNoOptionEnum | 989 | not stored in DB | EagleML/referenceTransaction/exchangePrice/exceptionProcessingSwitch | |||||
| valuePositionsAtCostSwitch | YesNoOptionEnum | 990 | not stored in DB | EagleML/referenceTransaction/exchangePrice/valuePositionsAtCostSwitch | |||||
| closingPrice | decimal | 481 | in_price | SECURITYDBO | PRICE_EXCHANGE | PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/closingPrice | |
| oidYield | decimal | 39 | in_yld | SECURITYDBO | PRICE_EXCHANGE | YIELD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/oidYield | |
| yieldType | string | 1113 | in_yld_type | SECURITYDBO | PRICE_EXCHANGE | YIELD_TYPE_CODE | CHAR(8) | EagleML/referenceTransaction/exchangePrice/yieldType | |
| priceTypeCode | string | 1843 | in_price_type_code | SECURITYDBO | PRICE_EXCHANGE | PRICE_TYPE_CODE | VARCHAR2(15) | EagleML/referenceTransaction/exchangePrice/priceTypeCode | |
| priceFlag | string | 7042 (1844) | in_price_flag | SECURITYDBO | PRICE_EXCHANGE | PRICING_FLAG | CHAR(2) | EagleML/referenceTransaction/exchangePrice/priceFlag | |
| lastTradedPrice | decimal | 7724 (1845) | in_px_last | SECURITYDBO | PRICE_EXCHANGE | PX_LAST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lastTradedPrice | |
| bidPrice | decimal | 7722 (1846) | in_px_bid | SECURITYDBO | PRICE_EXCHANGE | PX_BID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/bidPrice | |
| askPrice | decimal | 7721 (1847) | in_px_ask | SECURITYDBO | PRICE_EXCHANGE | PX_ASK | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/askPrice | |
| highPrice | decimal | 1848 | in_px_high | SECURITYDBO | PRICE_EXCHANGE | PX_HIGH | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/highPrice | |
| lowPrice | decimal | 1849 | in_px_low | SECURITYDBO | PRICE_EXCHANGE | PX_LOW | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lowPrice | |
| midPrice | decimal | 7725 (1850) | in_px_mid | SECURITYDBO | PRICE_EXCHANGE | PX_MID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/midPrice | |
| priceVolume | decimal | 1851 | in_px_volume | SECURITYDBO | PRICE_EXCHANGE | PX_VOLUME | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/priceVolume | |
| priceLevel | integer | 12007 | in_price_level | SECURITYDBO | PRICE_EXCHANGE | PRICE_LEVEL | NUMBER(38,0) | EagleML/referenceTransaction/exchangePrice/priceLevel | |
| priceCondition | string | 4849 | in_price_condition | SECURITYDBO | PRICE_EXCHANGE | PRICE_CONDITION | VARCHAR2(20) | EagleML/referenceTransaction/exchangePrice/priceCondition | |
| originalPrice | decimal | 893 | in_original_price | SECURITYDBO | PRICE_EXCHANGE | ORIGINAL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/originalPrice | |
| units | decimal | 40 | in_units | SECURITYDBO | PRICE_EXCHANGE | UNITS | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/units | |
| referencePrice | decimal | 1852 | in_px_reference | SECURITYDBO | PRICE_EXCHANGE | PX_REFERENCE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/referencePrice | |
| priceSource | string | 513 | in_src | SECURITYDBO | PRICE_EXCHANGE | PX_SOURCE | CHAR(8) | EagleML/referenceTransaction/exchangePrice/priceSource | |
| priceTolerance | decimal | 45 | not stored in DB | EagleML/referenceTransaction/exchangePrice/priceTolerance | |||||
| calculatedMean | decimal | 11847 | in_calculated_mean | SECURITYDBO | PRICE_EXCHANGE | CALCULATED_MEAN | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/calculatedMean | |
| fairValueFactor | decimal | 10813 | in_fair_value_factor | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/fairValueFactor | |
| dirtyPrice | decimal | 2895 | in_px_dirty | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/dirtyPrice | |
| cleanPriceInclOption | decimal | not stored in DB | EagleML/referenceTransaction/exchangePrice/cleanPriceInclOption | ||||||
| nominalDirtyPrice | decimal | 2896 | in_px_nominal_dirty | SECURITYDBO | PRICE_EXCHANGE | PX_NOMINAL_DIRTY | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/nominalDirtyPrice | |
| cleanInclOptionPrice | decimal | 2897 | in_px_clean_incl_option | SECURITYDBO | PRICE_EXCHANGE | PX_CLEAN_INCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/cleanInclOptionPrice | |
| dirtyInclOptionPrice | decimal | 2898 | in_px_dirty_incl_option | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY_INCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/dirtyInclOptionPrice | |
| cleanExclOptionPrice | decimal | 2899 | in_px_clean_excl_option | SECURITYDBO | PRICE_EXCHANGE | PX_CLEAN_EXCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/cleanExclOptionPrice | |
| dirtyExclOptionPrice | decimal | 2900 | in_px_dirty_excl_option | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY_EXCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/dirtyExclOptionPrice | |
| callOptionPrice | decimal | 2901 | in_px_call_option | SECURITYDBO | PRICE_EXCHANGE | PX_CALL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/callOptionPrice | |
| putOptionPrice | decimal | 8548 | in_px_put_option | SECURITYDBO | PRICE_EXCHANGE | PX_PUT_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/putOptionPrice | |
| fairValuePrice | decimal | 2902 | in_fair_value_price | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_PRICE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/fairValuePrice | |
| fairValueInclAccrued | decimal | 2903 | in_fair_value_incl_accrued | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_INCL_ACCRUED | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/fairValueInclAccrued | |
| averagePrice | decimal | 5595 | in_px_average | SECURITYDBO | PRICE_EXCHANGE | PX_AVERAGE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/averagePrice | |
| fixingPrice | decimal | 5596 | in_px_fixing | SECURITYDBO | PRICE_EXCHANGE | PX_FIXING | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/fixingPrice | |
| grossAskPrice | decimal | 5597 | in_px_gross_ask | SECURITYDBO | PRICE_EXCHANGE | PX_GROSS_ASK | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/grossAskPrice | |
| grossBidPrice | decimal | 5598 | in_px_gross_bid | SECURITYDBO | PRICE_EXCHANGE | PX_GROSS_BID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/grossBidPrice | |
| grossMidPrice | decimal | 5599 | in_px_gross_mid | SECURITYDBO | PRICE_EXCHANGE | PX_GROSS_MID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/grossMidPrice | |
| histClosePrice | decimal | 5600 | in_px_hist_close | SECURITYDBO | PRICE_EXCHANGE | PX_HIST_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/histClosePrice | |
| midClosePrice | decimal | 5602 | in_px_mid_close | SECURITYDBO | PRICE_EXCHANGE | PX_MID_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/midClosePrice | |
| meanPrice | decimal | 10427 | in_px_mean | SECURITYDBO | PRICE_EXCHANGE | PX_MEAN | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/meanPrice | |
| nominalPrice | decimal | 5603 | in_px_nominal | SECURITYDBO | PRICE_EXCHANGE | PX_NOMINAL | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/nominalPrice | |
| officialClosePrice | decimal | 5604 | in_px_official_close | SECURITYDBO | PRICE_EXCHANGE | PX_OFFICIAL_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/officialClosePrice | |
| openPrice | decimal | 7726 (5605) | in_px_open | SECURITYDBO | PRICE_EXCHANGE | PX_OPEN | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/openPrice | |
| sarulePrice | decimal | 5606 | in_px_sarule | SECURITYDBO | PRICE_EXCHANGE | PX_SARULE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/sarulePrice | |
| vwapClosePrice | decimal | 5607 | in_px_vwap_close | SECURITYDBO | PRICE_EXCHANGE | PX_VWAP_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/vwapClosePrice | |
| reinvestDate | date | 5608 | in_reinvest_date | SECURITYDBO | PRICE_EXCHANGE | REINVEST_DATE | DATE | EagleML/referenceTransaction/exchangePrice/reinvestDate | |
| shsUsedForEarningsComp | decimal | 5609 | in_shs_used_for_earnings_comp | SECURITYDBO | PRICE_EXCHANGE | SHS_USED_FOR_EARNINGS_COMP | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/shsUsedForEarningsComp | |
| shsUsedForOwnershipComp | decimal | 5610 | in_shs_used_for_ownership_comp | SECURITYDBO | PRICE_EXCHANGE | SHS_USED_FOR_OWNERSHIP_COMP | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/shsUsedForOwnershipComp | |
| status | string | 5614 | in_status | SECURITYDBO | PRICE_EXCHANGE | STATUS | VARCHAR2(25) | EagleML/referenceTransaction/exchangePrice/status | |
| stcgDist | decimal | 5615 | in_stcg_dist | SECURITYDBO | PRICE_EXCHANGE | STCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/stcgDist | |
| subsidyRatio | decimal | 5616 | in_subsidy_ratio | SECURITYDBO | PRICE_EXCHANGE | SUBSIDY_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/subsidyRatio | |
| totalDist | decimal | 5617 | in_total_dist | SECURITYDBO | PRICE_EXCHANGE | TOTAL_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/totalDist | |
| askAdrPrice | decimal | 10424 | in_px_ask_adr | SECURITYDBO | PRICE_EXCHANGE | PX_ASK_ADR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/askAdrPrice | |
| bidAdrPrice | decimal | 10425 | in_px_bid_adr | SECURITYDBO | PRICE_EXCHANGE | PX_BID_ADR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/bidAdrPrice | |
| lastAdrPrice | decimal | 10426 | in_px_last_adr | SECURITYDBO | PRICE_EXCHANGE | PX_LAST_ADR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lastAdrPrice | |
| priceLastUpdateDate | date | 5601 | in_px_last_update_date | SECURITYDBO | PRICE_EXCHANGE | PX_LAST_UPDATE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/priceLastUpdateDate | |
| basis | decimal | 5581 | in_basis | SECURITYDBO | PRICE_EXCHANGE | BASIS | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/basis | |
| bestRuleName | string | 5582 | in_best_rule_name | SECURITYDBO | PRICE_EXCHANGE | BEST_RULE_NAME | VARCHAR2(15) | EagleML/referenceTransaction/exchangePrice/bestRuleName | |
| expenseRatio | decimal | 5583 | in_expense_ratio | SECURITYDBO | PRICE_EXCHANGE | EXPENSE_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/expenseRatio | |
| incomeDist | decimal | 5584 | in_income_dist | SECURITYDBO | PRICE_EXCHANGE | INCOME_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/incomeDist | |
| lastUpdateDate | date | 7652 (5585) | in_last_update_date | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/lastUpdateDate | |
| lastUpdatePrice | decimal | 5586 | in_last_update_price | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lastUpdatePrice | |
| lastUpdateSource | string | 5587 | in_last_update_source | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_SOURCE | VARCHAR2(20) | EagleML/referenceTransaction/exchangePrice/lastUpdateSource | |
| lastUpdateTime | string | 5588 | in_last_update_time | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_TIME | CHAR(8) | EagleML/referenceTransaction/exchangePrice/lastUpdateTime | |
| ltcgDist | decimal | 5589 | in_ltcg_dist | SECURITYDBO | PRICE_EXCHANGE | LTCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/ltcgDist | |
| mtcgDist | decimal | 5590 | in_mtcg_dist | SECURITYDBO | PRICE_EXCHANGE | MTCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/mtcgDist | |
| naicPrice | decimal | 5591 | in_naic_price | SECURITYDBO | PRICE_EXCHANGE | NAIC_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/naicPrice | |
| navCurrent | decimal | 5592 | in_nav_current | SECURITYDBO | PRICE_EXCHANGE | NAV_CURRENT | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/navCurrent | |
| navReinvest | decimal | 5593 | in_nav_reinvest | SECURITYDBO | PRICE_EXCHANGE | NAV_REINVEST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/navReinvest | |
| otherDist | decimal | 5594 | in_other_dist | SECURITYDBO | PRICE_EXCHANGE | OTHER_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/otherDist | |
| stkdivFlag | string | 10428 | in_stkdiv_flag | SECURITYDBO | PRICE_EXCHANGE | STKDIV_FLAG | VARCHAR2(8) | EagleML/referenceTransaction/exchangePrice/stkdivFlag | |
| stkspltFlag | string | 10429 | in_stksplt_flag | SECURITYDBO | PRICE_EXCHANGE | STKSPLT_FLAG | VARCHAR2(8) | EagleML/referenceTransaction/exchangePrice/stkspltFlag | |
| preFvPrice | decimal | 2502 | in_pre_fv_price | SECURITYDBO | PRICE_EXCHANGE | PRE_FV_PRICE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/preFvPrice | |
| marketDate | date | 2410 | in_market_date | SECURITYDBO | PRICE_EXCHANGE | MARKET_DATE | DATE | EagleML/referenceTransaction/exchangePrice/marketDate | |
| userDate1 | date | 5618 | in_user_date1 | SECURITYDBO | PRICE_EXCHANGE | USER_DATE1 | DATE | EagleML/referenceTransaction/exchangePrice/userDate1 | |
| userDate2 | date | 5619 | in_user_date2 | SECURITYDBO | PRICE_EXCHANGE | USER_DATE2 | DATE | EagleML/referenceTransaction/exchangePrice/userDate2 | |
| userDate3 | date | 5620 | in_user_date3 | SECURITYDBO | PRICE_EXCHANGE | USER_DATE3 | DATE | EagleML/referenceTransaction/exchangePrice/userDate3 | |
| userFee1 | decimal | 5621 | in_user_fee1 | SECURITYDBO | PRICE_EXCHANGE | USER_FEE1 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userFee1 | |
| userFee2 | decimal | 5622 | in_user_fee2 | SECURITYDBO | PRICE_EXCHANGE | USER_FEE2 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userFee2 | |
| userFee3 | decimal | 5623 | in_user_fee3 | SECURITYDBO | PRICE_EXCHANGE | USER_FEE3 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userFee3 | |
| userNav1 | decimal | 5624 | in_user_nav1 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV1 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav1 | |
| userNav2 | decimal | 5625 | in_user_nav2 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV2 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav2 | |
| userNav3 | decimal | 5626 | in_user_nav3 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV3 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav3 | |
| userNav4 | decimal | 5627 | in_user_nav4 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV4 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav4 | |
| userNav5 | decimal | 5628 | in_user_nav5 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV5 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav5 | |
| sourceDetail | string | 5669 (2503) | in_source_detail | SECURITYDBO | PRICE_EXCHANGE | SOURCE_DETAIL | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/sourceDetail | |
| sourceFieldName | string | 5611 | in_source_field_name | SECURITYDBO | PRICE_EXCHANGE | SOURCE_FIELD_NAME | CHAR(30) | EagleML/referenceTransaction/exchangePrice/sourceFieldName | |
| sourceLevel | decimal | 5612 | in_source_level | SECURITYDBO | PRICE_EXCHANGE | SOURCE_LEVEL | NUMBER | EagleML/referenceTransaction/exchangePrice/sourceLevel | |
| sourceSrcIntfcName | string | 5613 | in_source_src_intfc_name | SECURITYDBO | PRICE_EXCHANGE | SOURCE_SRC_INTFC_NAME | CHAR(15) | EagleML/referenceTransaction/exchangePrice/sourceSrcIntfcName | |
| sourceSrcIntfcInst | integer | 4855 | in_source_src_intfc_inst | SECURITYDBO | PRICE_EXCHANGE | SOURCE_SRC_INTFC_INST | NUMBER | EagleML/referenceTransaction/exchangePrice/sourceSrcIntfcInst | |
| priceCurrency | string | 1111 | in_price_currency | SECURITYDBO | PRICE_EXCHANGE | PRICE_CURRENCY | CHAR(8) | EagleML/referenceTransaction/exchangePrice/priceCurrency | |
| percentChange1m | decimal | 18434 | in_percent_change_1m | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_1M | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange1m | |
| percentChange3m | decimal | 18435 | in_percent_change_3m | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_3M | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange3m | |
| percentChange6m | decimal | 18436 | in_percent_change_6m | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_6M | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange6m | |
| percentChange1yr | decimal | 18437 | in_percent_change_1yr | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_1YR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange1yr | |
| percentChangeWtd | decimal | 18438 | in_percent_change_wtd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_WTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeWtd | |
| percentChangeMtd | decimal | 18439 | in_percent_change_mtd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_MTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeMtd | |
| percentChangeQtd | decimal | 18440 | in_percent_change_qtd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_QTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeQtd | |
| percentChangeYtd | decimal | 18441 | in_percent_change_ytd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_YTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeYtd | |
| pxDirtyClean | string | 18442 | in_px_dirty_clean | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY_CLEAN | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/pxDirtyClean | |
| pxSettle | decimal | 18443 | in_px_settle | SECURITYDBO | PRICE_EXCHANGE | PX_SETTLE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/pxSettle | |
| pxSettleLastDate | date | 18444 | in_px_settle_last_date | SECURITYDBO | PRICE_EXCHANGE | PX_SETTLE_LAST_DATE | DATE | EagleML/referenceTransaction/exchangePrice/pxSettleLastDate | |
| quotedSpec | string | 18445 | in_quoted_spec | SECURITYDBO | PRICE_EXCHANGE | QUOTED_SPEC | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/quotedSpec | |
| settlementType | string | 18446 | in_settlement_type | SECURITYDBO | PRICE_EXCHANGE | SETTLEMENT_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/settlementType | |
| actualSettlementPrice | decimal | 18582 | in_px_settle_actual | SECURITYDBO | PRICE_EXCHANGE | PX_SETTLE_ACTUAL | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/actualSettlementPrice | |
| actualSettlementPriceDate | date | 18583 | in_px_settle_actual_date | SECURITYDBO | PRICE_EXCHANGE | PX_SETTLE_ACTUAL_DATE | DATE | EagleML/referenceTransaction/exchangePrice/actualSettlementPriceDate | |
| marketStatus | MarketStatusEnum | 18584 | in_market_status | SECURITYDBO | PRICE_EXCHANGE | MARKET_STATUS | VARCHAR2(15) | EagleML/referenceTransaction/exchangePrice/marketStatus | |
| foreignInstitutionalInvestorLimit | decimal | 18585 | in_fii_limit | SECURITYDBO | PRICE_EXCHANGE | FII_LIMIT | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/foreignInstitutionalInvestorLimit | |
| cleanDirtyFlag | CleanDirtyFlagEnum | 18586 | in_clean_dirty_flag | SECURITYDBO | PRICE_EXCHANGE | CLEAN_DIRTY_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/exchangePrice/cleanDirtyFlag | |
| exchangeListedFlag | YesNoOptionEnum | 18587 | in_exchange_listed_flag | SECURITYDBO | PRICE_EXCHANGE | EXCHANGE_LISTED_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/exchangePrice/exchangeListedFlag | |
| holidayFlag | YesNoOptionEnum | 18588 | in_holiday_flag | SECURITYDBO | PRICE_EXCHANGE | HOLIDAY_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/exchangePrice/holidayFlag | |
| allowPastRate | YesNoOptionEnum | 7001 | not stored in DB | EagleML/referenceTransaction/exchangePrice/allowPastRate | |||||
| bloombergError | string | 7740 | not stored in DB | EagleML/referenceTransaction/exchangePrice/bloombergError | |||||
| sourceDescription | string | 1103 | not stored in DB | EagleML/referenceTransaction/exchangePrice/sourceDescription | |||||
| sourceComments | string | 5669 | not stored in DB | EagleML/referenceTransaction/exchangePrice/sourceComments | |||||
| currencyLastCharacter | string | 7060 | not stored in DB | EagleML/referenceTransaction/exchangePrice/currencyLastCharacter | |||||
| askPriceFlag | YesNoOptionEnum | 7040 | not stored in DB | EagleML/referenceTransaction/exchangePrice/askPriceFlag | |||||
| bidPriceFlag | YesNoOptionEnum | 7041 | not stored in DB | EagleML/referenceTransaction/exchangePrice/bidPriceFlag | |||||
| lastPriceFlag | YesNoOptionEnum | 7044 | not stored in DB | EagleML/referenceTransaction/exchangePrice/lastPriceFlag | |||||
| midPriceFlag | YesNoOptionEnum | 7045 | not stored in DB | EagleML/referenceTransaction/exchangePrice/midPriceFlag | |||||
| pXQuoteLotSize | decimal | 7960 | not stored in DB, used for resolution logic | EagleML/referenceTransaction/exchangePrice/pXQuoteLotSize | |||||
| lastPriceCondition | string | 7015 | not stored in DB | EagleML/referenceTransaction/exchangePrice/lastPriceCondition | |||||
| askPriceCondition | string | 7016 | not stored in DB | EagleML/referenceTransaction/exchangePrice/askPriceCondition | |||||
| bidPriceCondition | string | 7017 | not stored in DB | EagleML/referenceTransaction/exchangePrice/bidPriceCondition | |||||
| price | decimal | 7723 | in_current_value | SECURITYDBO | PRICE_EXCHANGE | PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/price | |
| pricePriceCondition | string | 7018 | not stored in DB | EagleML/referenceTransaction/exchangePrice/pricePriceCondition | |||||
| midPriceCondition | string | 7019 | not stored in DB | EagleML/referenceTransaction/exchangePrice/midPriceCondition | |||||
| originalPriceCondition | string | 7021 | not stored in DB | EagleML/referenceTransaction/exchangePrice/originalPriceCondition | |||||
| priceTypeCodeCondition | string | 7022 | not stored in DB | EagleML/referenceTransaction/exchangePrice/priceTypeCodeCondition | |||||
| unitsCondition | string | 7023 | not stored in DB | EagleML/referenceTransaction/exchangePrice/unitsCondition | |||||
| fairValueFactorCondition | string | 7025 | not stored in DB | EagleML/referenceTransaction/exchangePrice/fairValueFactorCondition | |||||
| useVendorReloadProcess | integer | 9916 | not stored in DB | EagleML/referenceTransaction/exchangePrice/useVendorReloadProcess | |||||
| confidenceInterval | decimal | 10957 | in_confidence_interval | SECURITYDBO | PRICE_EXCHANGE | CONFIDENCE_INTERVAL | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/confidenceInterval | |
| bloombergAskPriceScore | decimal | 18348 | in_ask_score | SECURITYDBO | PRICE_EXCHANGE | ASK_SCORE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/bloombergAskPriceScore | |
| bloombergBidPriceScore | decimal | 18349 | in_bid_score | SECURITYDBO | PRICE_EXCHANGE | BID_SCORE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/bloombergBidPriceScore | |
| bloombergMidPriceScore | decimal | 18350 | in_mid_score | SECURITYDBO | PRICE_EXCHANGE | MID_SCORE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/bloombergMidPriceScore | |
| bloombergQuoteCode | decimal | 10381 | in_quote_type | SECURITYDBO | PRICE_EXCHANGE | QUOTE_TYPE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/bloombergQuoteCode | |
| finalValidationNumber | integer | 4891 | not stored in DB | EagleML/referenceTransaction/exchangePrice/finalValidationNumber | |||||
| dirtyPriceCondition | string | 7050 | not stored in DB | EagleML/referenceTransaction/exchangePrice/dirtyPriceCondition | |||||
| openPriceCondition | string | 7046 | not stored in DB | EagleML/referenceTransaction/exchangePrice/openPriceCondition | |||||
| originalVendorSource | string | 16859 | not stored in DB | EagleML/referenceTransaction/exchangePrice/originalVendorSource | |||||
| commentsOverrideFlag | YesNoOptionEnum | 1257 | not stored in DB | EagleML/referenceTransaction/exchangePrice/commentsOverrideFlag | |||||
| useRdcPricing | YesNoOptionEnum | Toggles RDC load mode if set to Y | EagleML/referenceTransaction/exchangePrice/useRdcPricing | ||||||
| payRecIndicator | string | 4590 | SECURITYDBO | SWAPS | PAY_RECEIVE_IND | VARCHAR2(10) | EagleML/referenceTransaction/exchangePrice/payRecIndicator | ||
| closingPriceCondition | string | 7018 | not stored in DB | EagleML/referenceTransaction/exchangePrice/closingPriceCondition | |||||
| oidYieldPriceCondition | string | 7224 | not stored in DB | EagleML/referenceTransaction/exchangePrice/oidYieldPriceCondition | |||||
| highPriceCondition | string | 7112 | not stored in DB | EagleML/referenceTransaction/exchangePrice/highPriceCondition | |||||
| lowPriceCondition | string | 7096 | not stored in DB | EagleML/referenceTransaction/exchangePrice/lowPriceCondition | |||||
| referencePriceCondition | string | 7120 | not stored in DB | EagleML/referenceTransaction/exchangePrice/referencePriceCondition | |||||
| nominalDirtyPriceCondition | string | 7100 | not stored in DB | EagleML/referenceTransaction/exchangePrice/nominalDirtyPriceCondition | |||||
| cleanInclOptionPriceCondition | string | 7204 | not stored in DB | EagleML/referenceTransaction/exchangePrice/cleanInclOptionPriceCondition | |||||
| dirtyInclOptionPriceCondition | string | 7208 | not stored in DB | EagleML/referenceTransaction/exchangePrice/dirtyInclOptionPriceCondition | |||||
| cleanExclOptionPriceCondition | string | 7212 | not stored in DB | EagleML/referenceTransaction/exchangePrice/cleanExclOptionPriceCondition | |||||
| dirtyExclOptionPriceCondition | string | 7216 | not stored in DB | EagleML/referenceTransaction/exchangePrice/dirtyExclOptionPriceCondition | |||||
| callOptionPriceCondition | string | 7156 | not stored in DB | EagleML/referenceTransaction/exchangePrice/callOptionPriceCondition | |||||
| putOptionPriceCondition | string | 7124 | not stored in DB | EagleML/referenceTransaction/exchangePrice/putOptionPriceCondition | |||||
| fairValuePriceCondition | string | 7244 | not stored in DB | EagleML/referenceTransaction/exchangePrice/fairValuePriceCondition | |||||
| fairValueInclAccruedCondition | string | 7248 | not stored in DB | EagleML/referenceTransaction/exchangePrice/fairValueInclAccruedCondition | |||||
| averagePriceCondition | string | 7128 | not stored in DB | EagleML/referenceTransaction/exchangePrice/averagePriceCondition | |||||
| fixingPriceCondition | string | 7092 | not stored in DB | EagleML/referenceTransaction/exchangePrice/fixingPriceCondition | |||||
| grossAskPriceCondition | string | 7140 | not stored in DB | EagleML/referenceTransaction/exchangePrice/grossAskPriceCondition | |||||
| grossBidPriceCondition | string | 7144 | not stored in DB | EagleML/referenceTransaction/exchangePrice/grossBidPriceCondition | |||||
| grossMidPriceCondition | string | 7148 | not stored in DB | EagleML/referenceTransaction/exchangePrice/grossMidPriceCondition | |||||
| midClosePriceCondition | string | 7132 | not stored in DB | EagleML/referenceTransaction/exchangePrice/midClosePriceCondition | |||||
| meanPriceCondition | string | 7136 | not stored in DB | EagleML/referenceTransaction/exchangePrice/meanPriceCondition | |||||
| nominalPriceCondition | string | 7152 | not stored in DB | EagleML/referenceTransaction/exchangePrice/nominalPriceCondition | |||||
| officialClosePriceCondition | string | 7029 | not stored in DB | EagleML/referenceTransaction/exchangePrice/officialClosePriceCondition | |||||
| vwapClosePriceCondition | string | 7240 | not stored in DB | EagleML/referenceTransaction/exchangePrice/vwapClosePriceCondition | |||||
| askAdrPriceCondition | string | 7228 | not stored in DB | EagleML/referenceTransaction/exchangePrice/askAdrPriceCondition | |||||
| bidAdrPriceCondition | string | 7232 | not stored in DB | EagleML/referenceTransaction/exchangePrice/bidAdrPriceCondition | |||||
| lastAdrPriceCondition | string | 7236 | not stored in DB | EagleML/referenceTransaction/exchangePrice/lastAdrPriceCondition | |||||
| lastUpdatePriceCondition | string | 7196 | not stored in DB | EagleML/referenceTransaction/exchangePrice/lastUpdatePriceCondition | |||||
| naicPriceCondition | string | 7116 | not stored in DB | EagleML/referenceTransaction/exchangePrice/naicPriceCondition | |||||
| navCurrentPriceCondition | string | 7200 | not stored in DB | EagleML/referenceTransaction/exchangePrice/navCurrentPriceCondition | |||||
| userFee1PriceCondition | string | 7168 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userFee1PriceCondition | |||||
| userFee2PriceCondition | string | 7160 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userFee2PriceCondition | |||||
| userFee3PriceCondition | string | 7164 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userFee3PriceCondition | |||||
| userNav1PriceCondition | string | 7172 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userNav1PriceCondition | |||||
| userNav2PriceCondition | string | 7176 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userNav2PriceCondition | |||||
| userNav3PriceCondition | string | 7180 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userNav3PriceCondition | |||||
| userNav4PriceCondition | string | 7184 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userNav4PriceCondition | |||||
| userNav5PriceCondition | string | 7188 | not stored in DB | EagleML/referenceTransaction/exchangePrice/userNav5PriceCondition | |||||
| pxSettleCondition | string | 7088 | not stored in DB | EagleML/referenceTransaction/exchangePrice/pxSettleCondition | |||||
| actualSettlementPriceCondition | string | 7192 | not stored in DB | EagleML/referenceTransaction/exchangePrice/actualSettlementPriceCondition | |||||
| pxYestPriceCondition | string | 7054 | not stored in DB | EagleML/referenceTransaction/exchangePrice/pxYestPriceCondition | |||||
| extendedUpdate | string | 7105 | not stored in DB | EagleML/referenceTransaction/exchangePrice/extendedUpdate | |||||
| pricingEntityId | string | 7107 | in_entity_id | SECURITYDBO | PRICE_EXCHANGE | ENTITY_ID | CHAR(8) | EagleML/referenceTransaction/exchangePrice/pricingEntityId | |
| priceConversionFxRate | decimal | 7682 | in_price_conversion_fx_rate | SECURITYDBO | PRICE_EXCHANGE | PRICE_CONVERSION_FX_RATE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/priceConversionFxRate | |
| priceConversionFxSource | string | 7108 | in_price_conv_fx_source | SECURITYDBO | PRICE_EXCHANGE | PRICE_CONV_FX_SOURCE | VARCHAR2(15) | EagleML/referenceTransaction/exchangePrice/priceConversionFxSource | |
| pxYest | decimal | 7728 | in_px_yest | SECURITYDBO | PRICE_EXCHANGE | PX_YEST | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/pxYest | |
| payPriceLeg | EagleML/referenceTransaction/exchangePrice/payPriceLeg | ||||||||
| receivePriceLeg | Receive Price Leg Model | EagleML/referenceTransaction/exchangePrice/receivePriceLeg | |||||||
Pay Price Leg Model | |||||||||
| notionalAmount | decimal | 7683 | in_pay_leg_notional | SECURITYDBO | PRICE_EXCHANGE | PAY_LEG_NOTIONAL | NUMBER(38,12) | ../notionalAmount | |
| price | decimal | 7680 | in_pay_leg_price_or_mv | SECURITYDBO | PRICE_EXCHANGE | PAY_LEG_PRICE_OR_MV | NUMBER(38,12) | ../price | |
marketValue | decimal | 7680 | in_pay_leg_price_or_mv | SECURITYDBO | PRICE_EXCHANGE | PAY_LEG_PRICE_OR_MV | NUMBER(38,12) | ../marketValue | |
Receive Price Leg Model | |||||||||
| notionalAmount | decimal | 7684 | in_rec_leg_notional | SECURITYDBO | PRICE_EXCHANGE | REC_LEG_NOTIONAL | NUMBER(38,12) | ../notionalAmount | |
| price | decimal | 7681 | in_rec_leg_price_or_mv | SECURITYDBO | PRICE_EXCHANGE | REC_LEG_PRICE_OR_MV | NUMBER(38,12) | ../price | |
| marketValue | decimal | 7681 | in_rec_leg_price_or_mv | SECURITYDBO | PRICE_EXCHANGE | REC_LEG_PRICE_OR_MV | NUMBER(38,12) | ../marketValue | |