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 Toolkit | Index Toolkit | Attribution Toolkit | GIPS Toolkit | Retail Funds Toolkit | 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 |
0 Comments