Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

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




  • No labels