Fair Value Comparison Data Map Table
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
---|---|---|---|---|---|---|---|---|---|---|
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 |
EagleML/accountingTransaction/fairValueComparison/ | ||||||||||
EagleML/accountingTransaction/fairValueComparison/ | ||||||||||
EagleML/accountingTransaction/fairValueComparison/ | ||||||||||
baseCurrency |  |  | string | 86 | base_currency | securitydbo | security_master | base_currency  | CHAR(50) | EagleML/accountingTransaction/fairValueComparison/baseCurrency |
longShortIndicator |  |  | string | 15 | long_short_ind | rulesdbo | fv_pval_comparison_detail | long_short_ind | CHAR(1) | EagleML/accountingTransaction/fairValueComparison/longShortIndicator |
effectiveDate | Â | Â | date | 36 | ceffective_date | Â | Â | Â | CHAR(8) | EagleML/accountingTransaction/fairValueComparison/effectiveDate |
topEntityName | Â | Â | string | 1159 | top_entity_name | pace_masterdbo | temp_comp_resolve | top_entity_name | CHAR(30) | EagleML/accountingTransaction/fairValueComparison/topEntityName |
currentQuantity | Â | Â | decimal | 122 | qty_priced | rulesdbo | fv_pval_comparison_detail | current_quantity | FLOAT | EagleML/accountingTransaction/fairValueComparison/currentQuantity |
exchangeRate | Â | Â | decimal | 484 | prior_xrate | rulesdbo | fv_pval_comparison_detail | exchange_rate | FLOAT | EagleML/accountingTransaction/fairValueComparison/exchangeRate |
amortizedCostLocal | Â | Â | decimal | 4601 | amort_cost_local | rulesdbo | fv_pval_comparison_detail | amortized_cost_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/amortizedCostLocal |
amortizedCostBase | Â | Â | decimal | 4602 | amort_cost_base | rulesdbo | fv_pval_comparison_detail | amortized_cost_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/amortizedCostBase |
fairValuePriceLocal | Â | Â | decimal | 11084 | fair_value_price_local | rulesdbo | fv_pval_comparison_detail | fair_value_price_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/fairValuePrice Local |
fairValuePriceBase | Â | Â | decimal | 11083 | fair_value_price_base | rulesdbo | fv_pval_comparison_detail | fair_value_price_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/fairValuePriceBase |
fairValueMarketValueLocal | Â | Â | decimal | 9174 | fair_value_market_value_local | rulesdbo | fv_pval_comparison_detail | fair_value_market_value_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/fairValueMarketValueLocal |
fairValueMarketValueBase | Â | Â | decimal | 9175 | fair_value_market_value_base | rulesdbo | fv_pval_comparison_detail | fair_value_market_value_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/fairValueMarketValueBase |
marketClosePriceLocal | Â | Â | decimal | 11085 | market_close_price_local | rulesdbo | fv_pval_comparison_detail | market_close_price_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/marketClosePriceLocal |
marketClosePriceBase | Â | Â | decimal | 10813 | market_close_price_base | rulesdbo | fv_pval_comparison_detail | market_close_price_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/marketClosePriceBase |
closeMarketValueLocal | Â | Â | decimal | 9180 | close_market_value_local | rulesdbo | fv_pval_comparison_detail | close_market_value_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/closeMarketValueLocal |
closeMarketValueBase | Â | Â | decimal | 9181 | close_market_value_base | rulesdbo | fv_pval_comparison_detail | close_market_value_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/closeMarketValueBase |
marketOpenPriceLocal | Â | Â | decimal | 9167 | market_open_price_local | rulesdbo | fv_pval_comparison_detail | market_open_price_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/marketOpenPriceLocal |
marketOpenPriceBase | Â | Â | decimal | 9170 | market_open_price_base | rulesdbo | fv_pval_comparison_detail | market_open_price_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/marketOpenPriceBase |
openMarketValueLocal | Â | Â | decimal | 9171 | open_market_value_local | rulesdbo | fv_pval_comparison_detail | open_market_value_local | FLOAT | EagleML/accountingTransaction/fairValueComparison/openMarketValueLocal |
openMarketValueBase | Â | Â | decimal | 9172 | open_market_value_base | rulesdbo | fv_pval_comparison_detail | open_market_value_base | FLOAT | EagleML/accountingTransaction/fairValueComparison/openMarketValueBase |
percentFairValueClosePrice | Â | Â | decimal | 9178 | percent_fair_value_close_price | Â rulesdbo | fv_pval_comparison_detail | percent_fair_value_close_price | FLOAT | EagleML/accountingTransaction/fairValueComparison/percentFairValueClosePrice |
percentFairValueOpenPrice | Â | Â | decimal | 9179 | percent_fair_value_open_price | rulesdbo | fv_pval_comparison_detail | percent_fair_value_open_price | FLOAT | EagleML/accountingTransaction/fairValueComparison/percentFairValueOpenPrice |
differenceFairValueCloseValue | Â | Â | decimal | 9176 | diff_fair_value_close_value | rulesdbo | fv_pval_comparison_detail | diff_fair_value_close_value | FLOAT | EagleML/accountingTransaction/fairValueComparison/differenceFairValueCloseValue |
differenceFairValueOpenValue | Â | Â | decimal | 9177 | diff_fair_value_open_value | rulesdbo | fv_pval_comparison_detail | diff_fair_value_open_value | FLOAT | EagleML/accountingTransaction/fairValueComparison/differenceFairValueOpenValue |
directionallyCorrect | Â | Â | string | 989 | directionally_correct | rulesdbo | fv_pval_comparison_detail | directionally_correct | CHAR(5) | EagleML/accountingTransaction/fairValueComparison/directionallyCorrect |
fairValuePriceCloserToOpen | Â | Â | string | 990 | fair_value_closer_to_open | rulesdbo | fv_pval_comparison_detail | fair_value_closer_to_open | CHAR(5) | EagleML/accountingTransaction/fairValueComparison/fairValuePriceCloserToOpen |
shareClass | Â | Â | string | 34 | share_class | rulesdbo | fv_pval_comparison | share_class | CHAR(10) | EagleML/accountingTransaction/fairValueComparison/shareClass |
priceSource | Â | Â | string | 1282 | src_intfc_inst_desc | Â | Â | Â | CHAR(50) | EagleML/accountingTransaction/fairValueComparison/priceSource |
openPriceType | Â | Â | string | 1843 | field_id_desc | pace_masterdbo | pace_inv_fields | field_description | CHAR(100) | EagleML/accountingTransaction/fairValueComparison/openPriceType |
allocationPercentage | Â | Â | decimal | 267 | allocation_percentage | rulesdbo | fv_pval_comparison | Â | FLOAT | EagleML/accountingTransaction/fairValueComparison/allocationPercentage |
impactFairValueToMarketClose | Â | Â | decimal | 5389 | impact_fair_value_to_market_close | not stored in DB | FLOAT | EagleML/accountingTransaction/fairValueComparison/impactFairValueToMarketClose | ||
impactFairValueToOpen | Â | Â | decimal | 5386 | impact_fair_value_to_open | not stored in DB | FLOAT | EagleML/accountingTransaction/fairValueComparison/impactFairValueToOpen | ||
 fairValueTotalNetAssets |  |  | decimal | 3193 | fair_value_total_net_assets | rulesdbo | fv_pval_comparison | fair_value_total_net_assets | FLOAT | EagleML/accountingTransaction/fairValueComparison/fairValueTotalNetAssets |
 closePriceTotalNetAssets |  |  | decimal | 5387 | close_price_total_net_assets | rulesdbo | fv_pval_comparison | close_price_total_net_assets | FLOAT | EagleML/accountingTransaction/fairValueComparison/closePriceTotalNetAssets |
 openPriceTotalNetAssets |  |  | decimal | 5388 | open_price_total_net_assets | rulesdbo | fv_pval_comparison | open_price_total_net_assets | FLOAT | EagleML/accountingTransaction/fairValueComparison/openPriceTotalNetAssets |
 NAVFairValue |  |  | decimal | 3195 | nav_fair_value | rulesdbo | fv_pval_comparison | nav_fair_value | FLOAT | EagleML/accountingTransaction/fairValueComparison/NAVFairValue |
 NAVClose |  |  | decimal | 5391 | nav_close | rulesdbo | fv_pval_comparison | nav_close | FLOAT | EagleML/accountingTransaction/fairValueComparison/NAVClose |
 NAVOpen |  |  | decimal | 5392 | nav_open | rulesdbo | fv_pval_comparison | nav_open | FLOAT | EagleML/accountingTransaction/fairValueComparison/NAVOpen |
 sharesOutstanding |  |  | decimal | 3209 | shares_outstanding | rulesdbo | fv_pval_comparison | shares_outstanding | FLOAT | EagleML/accountingTransaction/fairValueComparison/sharesOutstanding |
Â