Fair Value Comparison Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Nov 17, 2017 by Dmitry Donosiyan (Unlicensed)
1 min read
ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXPath
objectType         EagleML/accountingTransaction/fairValueComparison/objectType
objectId         EagleML/accountingTransaction/fairValueComparison/objectId
objectDescription         EagleML/accountingTransaction/fairValueComparison/objectDescription
updateTimestamp         EagleML/accountingTransaction/fairValueComparison/updateTimestamp
updateSource         EagleML/accountingTransaction/fairValueComparison/updateSource
Entity Common Id ModelEagleML/accountingTransaction/fairValueComparison/
Asset Identifiers ModelEagleML/accountingTransaction/fairValueComparison/
Asset Properties ModelEagleML/accountingTransaction/fairValueComparison/
baseCurrency  string86base_currencysecuritydbosecurity_masterbase_currency  CHAR(50)EagleML/accountingTransaction/fairValueComparison/baseCurrency
longShortIndicator  string15long_short_indrulesdbofv_pval_comparison_detail long_short_indCHAR(1)EagleML/accountingTransaction/fairValueComparison/longShortIndicator
effectiveDate  date36ceffective_date   CHAR(8)EagleML/accountingTransaction/fairValueComparison/effectiveDate
topEntityName  string1159top_entity_namepace_masterdbotemp_comp_resolvetop_entity_nameCHAR(30)EagleML/accountingTransaction/fairValueComparison/topEntityName
currentQuantity  decimal122qty_pricedrulesdbofv_pval_comparison_detailcurrent_quantityFLOATEagleML/accountingTransaction/fairValueComparison/currentQuantity
exchangeRate  decimal484prior_xraterulesdbofv_pval_comparison_detailexchange_rateFLOATEagleML/accountingTransaction/fairValueComparison/exchangeRate
amortizedCostLocal  decimal4601amort_cost_localrulesdbofv_pval_comparison_detailamortized_cost_localFLOATEagleML/accountingTransaction/fairValueComparison/amortizedCostLocal
amortizedCostBase  decimal4602amort_cost_baserulesdbofv_pval_comparison_detailamortized_cost_baseFLOATEagleML/accountingTransaction/fairValueComparison/amortizedCostBase
fairValuePriceLocal  decimal11084fair_value_price_localrulesdbofv_pval_comparison_detailfair_value_price_localFLOATEagleML/accountingTransaction/fairValueComparison/fairValuePrice Local
fairValuePriceBase  decimal11083fair_value_price_baserulesdbofv_pval_comparison_detailfair_value_price_baseFLOATEagleML/accountingTransaction/fairValueComparison/fairValuePriceBase
fairValueMarketValueLocal  decimal9174fair_value_market_value_localrulesdbofv_pval_comparison_detailfair_value_market_value_localFLOATEagleML/accountingTransaction/fairValueComparison/fairValueMarketValueLocal
fairValueMarketValueBase  decimal9175fair_value_market_value_baserulesdbofv_pval_comparison_detailfair_value_market_value_baseFLOATEagleML/accountingTransaction/fairValueComparison/fairValueMarketValueBase
marketClosePriceLocal  decimal11085market_close_price_localrulesdbofv_pval_comparison_detailmarket_close_price_localFLOATEagleML/accountingTransaction/fairValueComparison/marketClosePriceLocal
marketClosePriceBase  decimal10813market_close_price_baserulesdbofv_pval_comparison_detailmarket_close_price_baseFLOATEagleML/accountingTransaction/fairValueComparison/marketClosePriceBase
closeMarketValueLocal  decimal9180close_market_value_localrulesdbofv_pval_comparison_detailclose_market_value_localFLOATEagleML/accountingTransaction/fairValueComparison/closeMarketValueLocal
closeMarketValueBase  decimal9181close_market_value_baserulesdbofv_pval_comparison_detailclose_market_value_baseFLOATEagleML/accountingTransaction/fairValueComparison/closeMarketValueBase
marketOpenPriceLocal  decimal9167market_open_price_localrulesdbofv_pval_comparison_detailmarket_open_price_localFLOATEagleML/accountingTransaction/fairValueComparison/marketOpenPriceLocal
marketOpenPriceBase  decimal9170market_open_price_baserulesdbofv_pval_comparison_detailmarket_open_price_baseFLOATEagleML/accountingTransaction/fairValueComparison/marketOpenPriceBase
openMarketValueLocal  decimal9171open_market_value_localrulesdbofv_pval_comparison_detailopen_market_value_localFLOATEagleML/accountingTransaction/fairValueComparison/openMarketValueLocal
openMarketValueBase  decimal9172open_market_value_baserulesdbofv_pval_comparison_detailopen_market_value_baseFLOATEagleML/accountingTransaction/fairValueComparison/openMarketValueBase
percentFairValueClosePrice  decimal9178percent_fair_value_close_price rulesdbofv_pval_comparison_detailpercent_fair_value_close_priceFLOATEagleML/accountingTransaction/fairValueComparison/percentFairValueClosePrice
percentFairValueOpenPrice  decimal9179percent_fair_value_open_pricerulesdbofv_pval_comparison_detailpercent_fair_value_open_priceFLOATEagleML/accountingTransaction/fairValueComparison/percentFairValueOpenPrice
differenceFairValueCloseValue  decimal9176diff_fair_value_close_valuerulesdbofv_pval_comparison_detaildiff_fair_value_close_valueFLOATEagleML/accountingTransaction/fairValueComparison/differenceFairValueCloseValue
differenceFairValueOpenValue  decimal9177diff_fair_value_open_valuerulesdbofv_pval_comparison_detaildiff_fair_value_open_valueFLOATEagleML/accountingTransaction/fairValueComparison/differenceFairValueOpenValue
directionallyCorrect  string989directionally_correctrulesdbofv_pval_comparison_detaildirectionally_correctCHAR(5)EagleML/accountingTransaction/fairValueComparison/directionallyCorrect
fairValuePriceCloserToOpen  string990fair_value_closer_to_openrulesdbofv_pval_comparison_detailfair_value_closer_to_openCHAR(5)EagleML/accountingTransaction/fairValueComparison/fairValuePriceCloserToOpen
shareClass  string34share_classrulesdbofv_pval_comparisonshare_classCHAR(10)EagleML/accountingTransaction/fairValueComparison/shareClass
priceSource  string1282src_intfc_inst_desc   CHAR(50)EagleML/accountingTransaction/fairValueComparison/priceSource
openPriceType  string1843field_id_descpace_masterdbopace_inv_fieldsfield_descriptionCHAR(100)EagleML/accountingTransaction/fairValueComparison/openPriceType
allocationPercentage  decimal267allocation_percentagerulesdbofv_pval_comparison FLOATEagleML/accountingTransaction/fairValueComparison/allocationPercentage
impactFairValueToMarketClose  decimal5389impact_fair_value_to_market_closenot stored in DBFLOATEagleML/accountingTransaction/fairValueComparison/impactFairValueToMarketClose
impactFairValueToOpen  decimal5386impact_fair_value_to_opennot stored in DBFLOATEagleML/accountingTransaction/fairValueComparison/impactFairValueToOpen
 fairValueTotalNetAssets  decimal3193fair_value_total_net_assetsrulesdbofv_pval_comparisonfair_value_total_net_assetsFLOATEagleML/accountingTransaction/fairValueComparison/fairValueTotalNetAssets
 closePriceTotalNetAssets  decimal5387close_price_total_net_assetsrulesdbofv_pval_comparisonclose_price_total_net_assetsFLOATEagleML/accountingTransaction/fairValueComparison/closePriceTotalNetAssets
 openPriceTotalNetAssets  decimal5388open_price_total_net_assetsrulesdbofv_pval_comparisonopen_price_total_net_assetsFLOATEagleML/accountingTransaction/fairValueComparison/openPriceTotalNetAssets
 NAVFairValue  decimal3195nav_fair_valuerulesdbofv_pval_comparisonnav_fair_valueFLOATEagleML/accountingTransaction/fairValueComparison/NAVFairValue
 NAVClose  decimal5391nav_closerulesdbofv_pval_comparisonnav_closeFLOATEagleML/accountingTransaction/fairValueComparison/NAVClose
 NAVOpen  decimal5392nav_openrulesdbofv_pval_comparisonnav_openFLOATEagleML/accountingTransaction/fairValueComparison/NAVOpen
 sharesOutstanding  decimal3209shares_outstandingrulesdbofv_pval_comparisonshares_outstandingFLOATEagleML/accountingTransaction/fairValueComparison/sharesOutstanding