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