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 |
|---|---|---|---|---|---|---|---|
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 | ../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 | ||