Performance Toolkit Commit Mappings
- Pamela Totas (Deactivated)
This section describes the commit mappings used with the Performance Toolkit.
The commit mapping process defines the link between the fields used to calculate returns, as well as supporting data, and the PERFORM database. For each column in the PERF_SEC_RETURNS table in the PERFORM database, the following table identifies the Toolkit fields for each Toolkit sleeve that commit data to that column. This table also shows the name of the corresponding field used in Performance Toolkit . The shaded, or highlighted, rows in this table identify database columns for your use that do not have related Toolkit fields.
Perf_Sec_Returns Column | Calculation | Index | Attribution | GIPS | Retail Funds | Toolkit 2.0 |
|---|---|---|---|---|---|---|
ABAL | eglPrf-GrossABAL | eglPrf-GrossABAL | eglPrf-GrossABAL | eglPrf-GrossABAL | ||
PSR_USER_FLOAT1 | eglPrf-GrossBegMktVal | eglPrf-GrossBegMktVal | eglPrf-GrossBegMktVal | eglDmf-CurrentNAV | eglPrf-GrossBegMktVal | |
PSR_USER_FLOAT2 | eglPrf-GrossEndMktVal | eglPrf-GrossEndMktVal | eglPrf-GrossEndMktVal | eglDmf-CurrentNetAssets | eglPrf-GrossEndMktVal | |
PSR_USER_FLOAT3 | eglPrf-GrossNegFlows | eglDmf-CurrentShrOutstanding | eglPrf-GrossNegFlows | |||
PSR_USER_FLOAT4 | eglPrf-GrossPosFlows | eglDmf-1Day | eglPrf-GrossPosFlows | |||
PSR_USER_FLOAT5 | eglPrf-GrossTotFlows | eglDmf-MonthToDt | eglPrf-GrossTotFlows | |||
PSR_USER_FLOAT6 | eglPrf-GrossGainLoss | eglDmf-QtrToDt | eglPrf-GrossGainLoss | |||
PSR_USER_FLOAT7 | eglPrf-GrossInvestBase | eglPrf-GrossInvestBase | eglPrf-GrossInvestBase | eglPrf-GrossInvestBase | eglDmf-FiscalYTD | eglPrf-GrossInvestBase |
PSR_USER_FLOAT8 | eglPrf-GrossReturn | eglPrf-GrossReturn | eglPrf-GrossReturn | eglPrf-GrossReturn | eglDmf-YrToDt | eglPrf-GrossReturn |
PSR_USER_FLOAT9 | eglPrf-LongBegMktVal | eglDmf-1Yr | eglPrf-LongBegMktVal | |||
PSR_USER_FLOAT10 | eglPrf-LongEndMktVal | eglDmf-1YrLd | eglPrf-LongEndMktVal | |||
PSR_USER_FLOAT11 | eglPrf-LongNegFlows | eglDmf-ITD | eglPrf-LongNegFlows | |||
PSR_USER_FLOAT12 | eglPrf-LongPosFlows | eglDmf-ITDAnn | eglPrf-LongPosFlows | |||
PSR_USER_FLOAT13 | eglPrf-LongTotFlows | eglDmf-CurrentIncDist | eglPrf-LongTotFlows | |||
PSR_USER_FLOAT14 | eglPrf-LongGainLoss | eglDmf-CurrentCapGainDist | eglPrf-LongGainLoss | |||
PSR_USER_FLOAT15 | eglPrf-LongInvestBase | eglDmf-1Month | eglPrf-LongInvestBase | |||
PSR_USER_FLOAT16 | eglPrf-LongReturn | eglDmf-3M | eglPrf-LongReturn | |||
PSR_USER_FLOAT17 | eglPrf-ShortBegMktVal | eglDmf-6Month | eglPrf-ShortBegMktVal | |||
PSR_USER_FLOAT18 | eglPrf-ShortEndMktVal | eglDmf-1YrGrRatio | eglPrf-ShortEndMktVal | |||
PSR_USER_FLOAT19 | eglPrf-ShortNegFlows | eglDmf-3YAnn | eglPrf-ShortNegFlows | |||
PSR_USER_FLOAT20 | eglPrf-ShortPosFlows | eglDmf-3YLdAnn | eglPrf-ShortPosFlows | |||
PSR_USER_FLOAT21 | eglPrf-ShortTotFlows | eglDmf-3YrGrRatioAnn | eglPrf-ShortTotFlows | |||
PSR_USER_FLOAT22 | eglPrf-ShortGainLoss | eglDmf-5YAnn | eglPrf-ShortGainLoss | |||
PSR_USER_FLOAT23 | eglPrf-ShortInvestBase | eglDmf-5YLdAnn | eglPrf-ShortInvestBase | |||
PSR_USER_FLOAT24 | eglPrf-ShortReturn | eglDmf-5YrGrRatioAnn | eglPrf-ShortReturn | |||
PSR_USER_FLOAT25 | eglPrf-LocalBegMktVal | eglDmf-10YAnn | eglPrf-LocalBegMktVal | |||
PSR_USER_FLOAT26 | eglPrf-LocalEndMktVal | eglDmf-10YLdAnn | eglPrf-LocalEndMktVal | |||
PSR_USER_FLOAT27 | eglPrf-LocalNegFlows | eglDmf-10YrGrRatioAnn | eglPrf-LocalNegFlows | |||
PSR_USER_FLOAT28 | eglPrf-LocalPosFlows | eglDmf-ITDAnnLd | eglPrf-LocalPosFlows | |||
PSR_USER_FLOAT29 | eglPrf-LocalTotFlows | eglDmf-ITDGrRatioAnn | eglPrf-LocalTotFlows | |||
PSR_USER_FLOAT30 | eglPrf-LocalGainLoss | eglDmf-ITDEndValue | eglPrf-LocalGainLoss | |||
PSR_USER_FLOAT31 | eglPrf-LocalInvestBase | eglPrf-LocalInvestBase | ||||
PSR_USER_FLOAT32 | eglPrf-LocalReturn | eglPrf-LocalReturn | eglPrf-LocalReturn | eglPrf-LocalReturn | ||
PSR_USER_FLOAT33 | eglPrf-LocalLongBegMktVal | eglPrf-LocalLongBegMktVal | ||||
PSR_USER_FLOAT34 | eglPrf-LocalLongEndMktVal | eglPrf-LocalLongEndMktVal | ||||
PSR_USER_FLOAT35 | eglPrf-LocalLongNegFlows | eglPrf-LocalLongNegFlows | ||||
PSR_USER_FLOAT36 | eglPrf-LocalLongPosFlows | eglPrf-LocalLongPosFlows | ||||
PSR_USER_FLOAT37 | eglPrf-LocalLongTotFlows | eglPrf-LocalLongTotFlows | ||||
PSR_USER_FLOAT38 | eglPrf-LocalLongGainLoss | eglPrf-LocalLongGainLoss | ||||
PSR_USER_FLOAT39 | eglPrf-LocalLongInvestBase | eglPrf-LocalLongInvestBase | ||||
PSR_USER_FLOAT40 | eglPrf-LocalLongReturn | eglPrf-LocalLongReturn | ||||
PSR_USER_FLOAT41 | eglPrf-LocalShortBegMktVal | eglPrf-LocalShortBegMktVal | ||||
PSR_USER_FLOAT42 | eglPrf-LocalShortEndMktVal | eglPrf-LocalShortEndMktVal | ||||
PSR_USER_FLOAT43 | eglPrf-LocalShortNegFlows | eglPrf-LocalShortNegFlows | ||||
PSR_USER_FLOAT44 | eglPrf-LocalShortPosFlows | eglPrf-LocalShortPosFlows | ||||
PSR_USER_FLOAT45 | eglPrf-LocalShortTotFlows | eglPrf-LocalShortTotFlows | ||||
PSR_USER_FLOAT46 | eglPrf-LocalShortGainLoss | eglPrf-LocalShortGainLoss | ||||
PSR_USER_FLOAT47 | eglPrf-LocalShortInvestBase | eglPrf-LocalShortInvestBase | ||||
PSR_USER_FLOAT48 | eglPrf-LocalShortReturn | eglPrf-LocalShortReturn | ||||
PSR_USER_FLOAT49 | eglPrf-GrossUnitValue | |||||
PSR_USER_FLOAT50 | eglPrf-NetReturn | eglPrf-NetReturn | eglPrf-NetReturn | eglPrf-NetReturn | ||
PSR_USER_FLOAT51 | eglPrf-NetTotFlows | eglPrf-NetUnitValue | ||||
PSR_USER_FLOAT52 | eglPrf-PrincipalBegMktVal | |||||
PSR_USER_FLOAT53 | eglPrf-PrincipalEndMktVal | |||||
PSR_USER_FLOAT54 | eglPrf-PrincipalTotFlows | |||||
PSR_USER_FLOAT55 | eglPrf-PrincipalReturn | |||||
PSR_USER_FLOAT56 | eglPrf-IncomeBegAccrued | |||||
PSR_USER_FLOAT57 | eglPrf-IncomeEndAccrued | |||||
PSR_USER_FLOAT58 | eglPrf-IncomeTotFlows | |||||
PSR_USER_FLOAT59 | eglPrf-IncomeReturn | |||||
PSR_USER_FLOAT60 | eglPrf-FI-EffectiveYield | eglPrf-FI-EffectiveYield | ||||
PSR_USER_FLOAT61 | eglPrf-FI-EffectiveDuration | eglPrf-FI-EffectiveDuration | ||||
PSR_USER_FLOAT62 | eglPrf-FI-EffectiveConvexity | eglPrf-FI-EffectiveConvexity | ||||
PSR_USER_FLOAT63 | ||||||
PSR_USER_FLOAT64 | ||||||
PSR_USER_FLOAT65 | ||||||
PSR_USER_FLOAT66 | ||||||
PSR_USER_CHAR1 | eglPrf-FI-YieldCurveID | eglPrf-FI-YieldCurveID |