Versions Compared

Old Version 2

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version Current

changes.mady.by.user Kinga Huszno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

...

titleImportant 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

SP ParameterSP Type

Eagle DB

DB Table

DB Field

DB Field Type

XPath

Comments

priceSource

    

 string

PACE_MASTERDBO

INTERFACES

LONG_DESC

 priceType    PACE_MASTERDBOPACE_INV_FIELDS FIELD_DESCRIPTION 

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

priceType

priorPrice

  

1110

priorEffectiveDate 1764 

ESTAR

MONTHLY_PORTFOLIO_VALUATION

CURRENT_PRICE

lastChangeDate

ESTAR

ESTAR_PORTFOLIO_VALUATION

EFFECTIVE

LAST_CHANGE_DATE

 

../extendedPortValuationModel/

priorEffectiveDate   

lastChangeDate

ESTAR

MONTHLY_PORTFOLIO_VALUATION

LAST_CHANGE_DATE

daysPriceUnchanged

8398

ESTAR

MONTHLY

ESTAR_PORTFOLIO_VALUATION

EFFECTIVE_DATE priorPrice 1763  

DAYS_UNCHANGED

../extendedPortValuationModel/daysPriceUnchanged

ESTAR

MONTHLY_PORTFOLIO_VALUATION

DAYS_UNCHANGED

navSequence

integer

3196

ESTAR

ESTAR_PORTFOLIO_VALUATION

PRIOR

NAV_

PRICE

SEQUENCE

 

../extendedPortValuationModel/

priorPrice 1110  

navSequence

ESTAR

MONTHLY_PORTFOLIO_VALUATION

NAV_SEQUENCE

daysCopied

8399

ESTAR

MONTHLY

ESTAR_PORTFOLIO_VALUATION

CURRENT

DAYS_

PRICE lastChangeDate    

COPIED

../extendedPortValuationModel/daysCopied

ESTAR

MONTHLY_PORTFOLIO_VALUATION

DAYS_COPIED

targetSourceName

4507

ESTAR

ESTAR_PORTFOLIO_VALUATION

LAST

TARGET_

CHANGE

SOURCE_

DATE

INST

 

../extendedPortValuationModel/

lastChangeDate    

targetSourceName

ESTAR

MONTHLY_PORTFOLIO_VALUATION

TARGET_SOURCE_INST

fxSourceName

1168

ESTAR

MONTHLY

ESTAR_PORTFOLIO_VALUATION

LAST

FX_

CHANGE_DATE daysPriceUnchanged 8398  

SOURCE_ID

../extendedPortValuationModel/fxSourceName

ESTAR

MONTHLY_PORTFOLIO_VALUATION

FX_SOURCE_ID

originalSourceInstance

integer

3789

ESTAR

ESTAR_PORTFOLIO_VALUATION

DAYS

ORIGINAL_SRC_

UNCHANGED

INST

 

../extendedPortValuationModel/

daysPriceUnchanged   

originalSourceInstance

ESTAR

MONTHLY_PORTFOLIO_VALUATION

DAYS_UNCHANGED 

ORIGINAL_SRC_INST

priorExchangeRate

 

decimal

484

 

 

ESTAR

ESTAR_PORTFOLIO_VALUATION

PRIOR_XRATE

 

../extendedPortValuationModel/priorExchangeRate

 96  

ESTAR

MONTHLY_PORTFOLIO_VALUATION

CURRENT

PRIOR_XRATE

 

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

 

priorUrglSecurityBase

 

 decimal

4745

4746

  

ESTAR

ESTAR_PORTFOLIO_VALUATION

SECURITY_GL_

LOCAL 

BASE

../extendedPortValuationModel/priorUrglSecurityBase

  

 

ESTAR

MONTHLY_PORTFOLIO_VALUATION

SECURITY_GL_

LOCAL 

BASE

priorUrglSecurityLocal

 

 decimal

4746

4745

  

ESTAR

ESTAR_PORTFOLIO_VALUATION

SECURITY_GL_

BASE

LOCAL

 

../extendedPortValuationModel/priorUrglSecurityLocal

   

ESTAR

MONTHLY_PORTFOLIO_VALUATION

SECURITY_GL_

BASE priorUrglCurrencyBase 4619  

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/

priorUrglCurrencyBase   

priorTotalUrglBase

ESTAR

MONTHLY_PORTFOLIO_VALUATION

TOT_URGL_B

 priorTotalUrglBase    ESTARESTAR_PORTFOLIO_VALUATIONURGL_CURRENCY_B ../extendedPortValuationModel/priorTotalUrglBase   ESTARMONTHLY_PORTFOLIO_VALUATIONURGL_CURRENCY_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/

Anchor
pvAssetPrice
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