Warehouse Open Lot - Extended Port Valuation Model Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Nov 07, 2024 by Kinga Huszno
1 min read

This model is is extract-only and it is not extracted by default. To add it to your extract you should have the IncludePortfolioValuation task parameter on your RTR.

  • ​IncludePortfolioValuation=Y adds this model partially, only elements before the delimiter included.

  • ​IncludePortfolioValuation=ALL adds full model, including elements after the delimiter.

Element

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

XPath

Element

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

XPath

priceSource

 string

 

PACE_MASTERDBO

INTERFACES

LONG_DESC

 

../extendedPortValuationModel/priceSource

priorEffectiveDate

 

1764

ESTAR

ESTAR_PORTFOLIO_VALUATION

EFFECTIVE_DATE

 

../extendedPortValuationModel/priorEffectiveDate

ESTAR

MONTHLY_PORTFOLIO_VALUATION

EFFECTIVE_DATE

 

priorPrice

 

1763

ESTAR

ESTAR_PORTFOLIO_VALUATION

PRIOR_PRICE

 

../extendedPortValuationModel/priorPrice

1110

ESTAR

MONTHLY_PORTFOLIO_VALUATION

CURRENT_PRICE

 

lastChangeDate

 

 

ESTAR

ESTAR_PORTFOLIO_VALUATION

LAST_CHANGE_DATE

 

../extendedPortValuationModel/lastChangeDate

 

ESTAR

MONTHLY_PORTFOLIO_VALUATION

LAST_CHANGE_DATE

 

daysPriceUnchanged

 

8398

ESTAR

ESTAR_PORTFOLIO_VALUATION

DAYS_UNCHANGED

 

../extendedPortValuationModel/daysPriceUnchanged

 

ESTAR

MONTHLY_PORTFOLIO_VALUATION

DAYS_UNCHANGED

 

navSequence

integer

3196

ESTAR

ESTAR_PORTFOLIO_VALUATION

NAV_SEQUENCE

 

../extendedPortValuationModel/navSequence

ESTAR

MONTHLY_PORTFOLIO_VALUATION

NAV_SEQUENCE

 

daysCopied

 

8399

ESTAR

ESTAR_PORTFOLIO_VALUATION

DAYS_COPIED

 

../extendedPortValuationModel/daysCopied

ESTAR

MONTHLY_PORTFOLIO_VALUATION

DAYS_COPIED

 

targetSourceName

 

4507

ESTAR

ESTAR_PORTFOLIO_VALUATION

TARGET_SOURCE_INST

 

../extendedPortValuationModel/targetSourceName

ESTAR

MONTHLY_PORTFOLIO_VALUATION

TARGET_SOURCE_INST

 

fxSourceName

 

1168

ESTAR

ESTAR_PORTFOLIO_VALUATION

FX_SOURCE_ID

 

../extendedPortValuationModel/fxSourceName

ESTAR

MONTHLY_PORTFOLIO_VALUATION

FX_SOURCE_ID

 

originalSourceInstance

integer

3789

ESTAR

ESTAR_PORTFOLIO_VALUATION

ORIGINAL_SRC_INST

 

../extendedPortValuationModel/originalSourceInstance

 

ESTAR

MONTHLY_PORTFOLIO_VALUATION

ORIGINAL_SRC_INST

 

priorExchangeRate

decimal

484

ESTAR

ESTAR_PORTFOLIO_VALUATION

PRIOR_XRATE

 

../extendedPortValuationModel/priorExchangeRate

 

ESTAR

MONTHLY_PORTFOLIO_VALUATION

PRIOR_XRATE

 

To add the elements below this delimiter, please set IncludePortfolioValuation=ALL in the RTR

priorUrglSecurityBase

 decimal

4746

ESTAR

ESTAR_PORTFOLIO_VALUATION

SECURITY_GL_BASE

 

../extendedPortValuationModel/priorUrglSecurityBase

ESTAR

MONTHLY_PORTFOLIO_VALUATION

SECURITY_GL_BASE

 

priorUrglSecurityLocal

 decimal

4745

ESTAR

ESTAR_PORTFOLIO_VALUATION

SECURITY_GL_LOCAL

 

../extendedPortValuationModel/priorUrglSecurityLocal

ESTAR

MONTHLY_PORTFOLIO_VALUATION

SECURITY_GL_LOCAL

 

priorUrglCurrencyBase

 decimal

493

ESTAR

ESTAR_PORTFOLIO_VALUATION

URGL_CURRENCY_B

 

../extendedPortValuationModel/priorUrglCurrencyBase

ESTAR

MONTHLY_PORTFOLIO_VALUATION

URGL_CURRENCY_B

 

priorTotalUrglBase

 decimal

 4619

ESTAR

ESTAR_PORTFOLIO_VALUATION

TOT_URGL_B

 

../extendedPortValuationModel/priorTotalUrglBase

ESTAR

MONTHLY_PORTFOLIO_VALUATION

TOT_URGL_B

 

urglSecurityBase

decimal

491

HOLDINGDBO

LOT_LEVEL_POSITION

UNREALIZED_SEC_GL

 

../extendedPortValuationModel/urglSecurityBase

urglSecurityLocal

decimal

 

 

 

 

 

../extendedPortValuationModel/urglSecurityLocal

portValuationUpdateTimeStamp

date

 

RULESDBO

PRICE_RULE_SECURITIES

UPDATE_DATE

 

../extendedPortValuationModel/portValuationUpdateTimeStamp

priceLevel

integer

12007

HOLDINGDBO

POSITION_DETAIL

PRICE_LEVEL

 

../extendedPortValuationModel/priceLevel

pvAssetPrice

pvAssetPrice model - see extra table below (repeated node)

../extendedPortValuationModel/pvAssetPrice/

pvAssetPrice Data Map Table

Element

Value Type

Star Tag

Eagle DB

DB Table

DB Field

DB Field Type

XPath

priceType

string

 

SECURITYDBO

SECMASTER_DETAIL_EXT

PRICE_TYPE

 

../extendedPortValuationModel/pvAssetPrice/priceType

sourceDetail

string

 

SECURITYDBO

PRICE

SOURCE_DETAIL

 

../extendedPortValuationModel/pvAssetPrice/sourceDetail

priceRuleActivePrice

decimal

 

RULESDBO

PRICE_RULE_SECURITIES

CURRENT_VALUE

 

../extendedPortValuationModel/pvAssetPrice/priceRuleActivePrice

activePriceSource

string

 

RULESDBO

PRICE_RULE_SECURITIES

SOURCE_SRC_INTFC_INST

 

../extendedPortValuationModel/pvAssetPrice/activePriceSource

priceRuleUpdateTimeStamp

dateTime

 

RULESDBO

PRICE_RULE_SECURITIES

UPDATE_DATE

 

../extendedPortValuationModel/pvAssetPrice/priceRuleUpdateTimeStamp

priceRuleSecurityInstance

integer

 

RULESDBO

PRICE_RULE_SECURITIES

BEST_RULE_SEC_INST

 

../extendedPortValuationModel/pvAssetPrice/priceRuleSecurityInstance