The Plan Performance Summary report is designed to display data for a composite of composites, the underlying constituent composites, and the underlying constituent portfolios for various time periods including the corresponding benchmarks.
This report can be run on any business day or month end. This report is intended to be run for any composite of composites of portfolios.
Advanced Report Profiles
Egl Prf Performance Plan Summary
Options
None
Data Used by Report
The following table shows data used by the report.
| Report Element | Data Mart Table | Data Mart Column | Underlying Field Attribute |
|---|---|---|---|
Hierarchy Structure | |||
Composite of Composite | FUND_HIERARCHY | PLAN_ID_GRP | eglEhi-Plan |
Composite | FUND_HIERARCHY | COMPOSITE_ID_GRP | eglEhi-Composite |
Entity | FUND_HIERARCHY | ENTITY_ID_GRP | eglEnt-EntityID |
Data for Hierarchy | |||
Fund Name | FUND_SUMMARY | ENTITY_NAME | eglEnt-Entityname |
Fund Base Currency | FUND_SUMMARY | BASE_CURRENCY | eglEnt-EntityBaseCurrency |
Benchmark | FUND_SUMMARY | BM1_NAME | eglPan-Bm1Name |
Inception Date | FUND_SUMMARY | INCEPTION_DATE | eglEnt-InceptionDate |
Account Returns - Month to Date | PERF_TOTAL_SUMMARY | MTD_RETURN | eglPlk-D-MtdGrossReturn |
Account Returns - Quarter to Date | PERF_TOTAL_SUMMARY | QTD_RETURN | eglPlk-D-QtdGrossReturn |
Account Returns - Year to Date | PERF_TOTAL_SUMMARY | YTD_RETURN | eglPlk-D-YtdGrossReturn |
Account Returns - 1 Year | PERF_TOTAL_EXTENDED | Y1_RETURN | eglPlk-M-Y01GrossReturn |
Account Returns - 3 Years (Ann.) | PERF_TOTAL_EXTENDED | Y3A_RETURN | eglPlk-M-Y03aGrossReturn |
Account Returns - 5 Years (Ann.) | PERF_TOTAL_EXTENDED | Y5A_RETURN | eglPlk-M-Y05aGrossReturn |
Account Returns - 10 Years (Ann.) | PERF_TOTAL_EXTENDED | Y10A_RETURN | eglPlk-M-Y10aGrossReturn |
Account Returns -Since Inception (Ann.) | PERF_TOTAL_EXTENDED | ITDA_RETURN | eglPlk-D-ItdaGrossReturn |
Benchmark Returns - Month to Date | PERF_TOTAL_SUMMARY | MTD_BM1_RETURN | eglPlk-D- Bm1MtdGrossReturn |
Benchmark Returns - Quarter to Date | PERF_TOTAL_SUMMARY | QTD_BM1_RETURN | eglPlk-D- Bm1QtdGrossReturn |
Benchmark Returns - Year to Date | PERF_TOTAL_SUMMARY | YTD_BM1_RETURN | eglPlk-D- Bm1YtdGrossReturn |
Benchmark Returns - 1 Year | PERF_TOTAL_EXTENDED | Y1_BM1_RETURN | eglPlk-M- Bm1Y01GrossReturn |
Benchmark Returns - 3 Years (Ann.) | PERF_TOTAL_EXTENDED | Y3A_BM1_RETURN | eglPlk-M- Bm1Y03aGrossReturn |
Benchmark Returns - 5 Years (Ann.) | PERF_TOTAL_EXTENDED | Y5A_BM1_RETURN | eglPlk-M- Bm1Y05aGrossReturn |
Benchmark Returns - 10 Years (Ann.) | PERF_TOTAL_EXTENDED | Y10A_BM1_RETURN | eglPlk-M- Bm1Y10aGrossReturn |
Benchmark Returns -Since Inception (Ann.) | PERF_TOTAL_EXTENDED | ITDA_BM1_RETURN | eglPlk-D-Bm1ItdaGrossReturn |
Report DLL
The report DLL is named PlanPerformanceSummary.dll.
Add Comment