Fair Value Comparison Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
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 |