MFP Audit Summary Table
- Kavitha Thangaswamy (Unlicensed)
- Pamela Totas (Deactivated)
The PERFORMDBO.MFP_AUDIT_SUMMARY table contains summary statistics for a performance period for the given audit ID (fund/date/source/freq). See the following table for details.
Note there are two examples in the following table. This means that for the given audit ID (123), there were two audit fields executed (field #2222 and #3333). Note that in these examples, each field represents a different performance period. Field 2222 is a 1 day return (12/30—12/31) while field 3333 is a 1 month return (11/30—12/31).
Column | Description | Example 1 | Example 2 |
|---|---|---|---|
AUDIT_ID | Unique ID assigned to a unique combination of [entity/effective date/source/frequency]. | 123 | 123 |
FIELD_ATTRIBUTE_ID | ID of the dynamic mutual fund performance field | 2222 | 3333 |
BEGIN_DATE | Start date of the performance period being logged | 12/30/2005 | 11/30/2005 |
END_DATE | End date of the performance period being logged | 12/31/2005 | 12/31/2005 |
AUDIT_TYPE | Indicates if this field (thus the audit data), is pre tax, post-tax or post liquidation. | PRE_TAX_PRE_LIQ | PRE_TAX_PRE_LIQ |
AUDIT_CATEGORY | Category from dynamic mutual fund field | Audit Daily | Audit Daily |
AUDIT_EFFECT | Effect from dynamic mutual fund field | Total Return | Total Return |
AUDIT_LOAD_IND | Indicates if this field (thus the audit data), is load adjusted or no load | Y | Y |
AUDIT_ERROR_CODE | For potential future use | NULL | NULL |
AUDIT_ERROR_DESC | For potential future use | NULL | NULL |
CDSC_AMOUNT | The calculated dollar amount of the CDSC fee | 50 | 50 |
REDEMPTION_AMOUNT | The calculated dollar amount of the redemption fee | 0 | 0 |
LOAD_ADJ_EMV | The ending redeemable value, adjusted for applicable loads | 950 | 987.3610808 |
TAX_ADJ_EMV | The ending redeemable value, adjusted for applicable loads and taxes | 950 | 987.3610808 |
GROWTH_RATE | The growth rate associated with the cumulative return | 0.95 | 0.987361081 |
CUME_RETURN | The cumulative return (this is what is displayed in the performance analysis report for dynamic fields that do not have annualization enabled | -5.00 | -1.264 |
ANN_GROWTH_RATE | The growth rate associated with the annualized return (only populated if annualization is enabled on the dynamic field) | NULL | NULL |
ANN_RETURN | The annualized return (this is what is displayed in the Performance Analysis report for dynamic fields that have annualization enabled | NULL | NULL |
HIGH_PRICE | Derived: The highest price during the performance period | 10 | 10.1 |
HIGH_PRICE_DATE | Derived: The date of the highest price (if multiple then earliest) | 12/30/2005 | 12/27/2005 |
LOW_PRICE | Derived: The lowest price during the performance period | 9.99 | 9.5 |
LOW_PRICE_DATE | Derived: The date of the lowest price (if multiple then earliest) | 12/31/2005 | 12/2/2005 |
BUY_PRICE | The buy price from day 0 of performance period | 10 | 9.65 |
OFFER_PRICE | Derived: The calculated offer price (buy price / (1-front load)) | 10 | 9.65 |
ADJ_INITIAL_INV | Derived: Representative 'initial investment' for front end loaded funds. | 1000 | 1000 |
INITIAL_INV | The initial investment (currently always $1,000) | 1000 | 1000 |
CDSC_PCT | The fee percentage used to calculate the CDSC_AMOUNT | 0.05 | 0.05 |
UPDATE_DATE | Update date | 5/18/2006 | 5/18/2006 |
UPDATE_SOURCE | Update source | MFP_AUDIT_PROC | MFP_AUDIT_PROC |
Interpretation
For a single fund/end date combination (FUND1 as of 12/31/2005), two performance calculation fields were submitted for audit logging. The first was a 1 day load adjusted return. The second was a 1 month load adjusted return. There are a series of data points for each combination of audit ID/field attribute ID. Each record contains the pertinent information for that specific performance field (field attribute ID) for that specific fund/end date (audit ID).