MFP Audit Details Table

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 Day1	Example Day2
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).