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