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

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

Entity Common Id Model

EagleML/accountingTransaction/fairValueComparison/

Asset Identifiers Model

EagleML/accountingTransaction/fairValueComparison/

Asset Properties Model

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

Â