Important Note
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 | 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 | ||