...
The grids in the following table are meant to provide an idea of the volume of data that can be produced.
Estimated Audit Records per Fund / Performance Frequency | ||
|---|---|---|
Time | Frequency | Records/Fund* |
1 | Day | 2 |
1 | Month | 32 |
1 | Quarter | 91 |
1 | Year | 366 |
5 | Year | 1830 |
10 | Year | 3660 |
5981 | ||
| ||
The number of records grow every time you run the process for a new effective date. For example, if you run the process described in the previous table for 10 days in a row, you have approximately 59,810 audit records per fund.
The following table shows an example field rule (not recommended).
Extreme Volume Case Example (Not a Recommended Workflow) | |||
|---|---|---|---|
| Records/Fund | Funds in Report | Audit Records per Report |
1 Year No Load Pre Tax | 366 | 200 | 73200 |
1 Year No Load Post Tax | 366 | 200 | 73200 |
1 Year No Load Post Liq | 366 | 200 | 73200 |
5 Year No Load Pre Tax | 1830 | 200 | 366000 |
5 Year No Load Post Tax | 1830 | 200 | 366000 |
5 Year No Load Post Liq | 1830 | 200 | 366000 |
10 Year No Load Pre Tax | 3660 | 200 | 732000 |
10 Year No Load Post Tax | 3660 | 200 | 732000 |
10 Year No Load Post Liq | 3660 | 200 | 732000 |
ITDYear No Load Pre Tax* | 3660 | 200 | 732000 |
ITD Year No Load Post Tax* | 3660 | 200 | 732000 |
ITD Year No Load Post Liq* | 3660 | 200 | 732000 |
Sub total | 28548 | 200 | 5,709,600 |
*Assume 10 years of history | |||
The example in the previous table is an extreme case of what can happen if you attempt to log numerous fields for many funds. The fields are common for year end performance reporting but not necessarily for auditing. For example, there are three separate 1 year fields. Each would result in 366 audit records per fund, per effective date.
...