MFP Audit Details Table
- Kavitha Thangaswamy (Unlicensed)
- Pamela Totas (Deactivated)
The PERFORMDBO.MFP_AUDIT_DETAILS table contains detailed statistics for a performance period for the given audit ID/field ID.
The example in the following table is for field 2222. This is a 1 day return and therefore has two days of audit details. The details for field 3333 (a 1 month return) would encompass 32 records. All the distribution activity columns are NULL.
This means that there were no distributions during this performance period (1 day) for this fund. If, for example, there was an income distribution that reinvested, all the activity columns preempted with INC would have been populated accordingly.
Column | Description | Example Day 1 | Example Day 2 |
|---|---|---|---|
AUDIT_ID | Unique ID assigned to an entity/effective date/source/frequency | 123 | 123 |
FIELD_ATTRIBUTE_ID | ID of the dynamic mutual fund performance field | 2222 | 2222 |
NAV_DATE | The interim dates of the performance period being processed | 12/30/2005 | 12/31/2005 |
REINVEST_PRICE | The price used for reinvest activity | 10 | 9.99 |
SELL_PRICE | The price used for determining the intermediate market values and ending redeemable value | 10 | 9.99 |
SHARE_BALANCE | Cumulative share balance | 100 | 100 |
MARKET_VALUE | Current market value (cumulative shares * sell price) not adjusted for back end loads or applicable taxes | 1000 | 999 |
COST_BASIS | Cumulative cost basis | 1000 | 1000 |
PTD_RET_UNAUDITED | Derived: Period to date UNAUDITED return ((market_value / 1000)-1)*100 | 0 | -0.01 |
LTCG_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
LTCG_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
LTCG_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
LTCG_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
LTCG_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
LTCG_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
STCG_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
STCG_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
STCG_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
STCG_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
STCG_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
STCG_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
INC_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
INC_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
INC_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
INC_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
INC_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
INC_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
TEINC_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
TEINC_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
TEINC_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
TEINC_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
TEINC_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
TEINC_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
QINC_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
QINC_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
QINC_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
QINC_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
QINC_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
QINC_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
MTCG_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
MTCG_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
MTCG_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
MTCG_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
MTCG_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
MTCG_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
SINC_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
SINC_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
SINC_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
SINC_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
SINC_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
SINC_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
FTC_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
FTC_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
FTC_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
FTC_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
FTC_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
FTC_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
ROC_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
ROC_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
ROC_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
ROC_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
ROC_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
ROC_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
S1250_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
S1250_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
S1250_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
S1250_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
S1250_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
S1250_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
RETCG_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
RETCG_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
RETCG_PRETAX_ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
RETCG_POSTTAX_ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
RETCG_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
RETCG_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
EXPTOT_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
EXPTOT_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
EXPTOT_PRETAX_ ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
EXPTOT_ _ ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
EXPTOT_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
EXPTOT_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
WVRTOT_DISTR_AMT | Per share amount of this distribution type | NULL | NULL |
WVRTOT_TAX_RATE | Tax rate applied to this distribution type | NULL | NULL |
WVRTOT_PRETAX_ ACCR_AMT | The dollar amount (pre tax) of reinvestment | NULL | NULL |
WVRTOT_POSTTAX_ ACCR_AMT | The dollar amount (post tax) of reinvestment | NULL | NULL |
WVRTOT_REINVEST_SHARES | Additional shares from reinvestment of this distribution type | NULL | NULL |
WVRTOT_REINVEST_DATE | Reinvest date for this distribution type | NULL | NULL |
UPDATE_DATE | Update date | MFP_AUDIT_ PROC | MFP_AUDIT_ PROC |
UPDATE_SOURCE | Update source | MFP_AUDIT_ PROC | MFP_AUDIT_ PROC |
Interpretation
The daily details for FUND1 for a 1 day return show that a $1,000 investment, yielded 100 starting shares. There were no additional shares added through reinvested distributions. At the end of the period, the NAV had dropped to 9.99 resulting in an unadjusted redeemable market value of $999.
Note that adjustments for load and taxes are reflected in the summary table. It is the TAX_ADJ_EMV (on MFP_AUDIT_SUMMARY) that is used as the ending value used for the return calculation. This table shows that there is a periodtodate unaudited return of -.01.
This is referential data to show the cumulative percent change in market value and is not necessarily the return that shows on the Performance Analysis report (that is also stored on the summary table).