Base Accumulation Examples

Below is an example outlining how the Base Accumulation process determines the appropriate records to include or exclude.

Pool/Base Distribution Setup

Distribution #1:  Two journal records match this distribution, i.e. Activity Class = A, Records 1 and 2.  There are no exclude records defined.  The accumulation total is 2000.00.  Note:  the wildcard '*’ implies that all non-null Task Code values are acceptable. Therefore, Record #3 cannot be included.

Distribution #2:  There are four matching records for the include distribution, i.e. Activity Class = B, Records 4, 5, 6 and 7.  However Record #4 should be excluded from the accumulation as an 'exclude’ distribution has been defined for Distribution #2, i.e. no dollars should be accumulated where activity code = B001 and Task Code = 01.  Even though Record #5 has an activity code = B001, this record should still be included as it is the combination of Activity and Task that defines what records should be excluded in this example.  Therefore, records 5, 6 and 7 should be added to calculate the distribution total.  That total is 7000.00

The total base 1 accumulation is the sum of the distribution totals.  That total is 9000.00.  This becomes the statistical unit for Base 1.

Distribution #1:  There are three matching records for the include distribution, i.e. Activity Class = C, Records 8, 9, and 10.  However two of those records should be excluded from the accumulation as two exclude distributions have been defined.  No dollars should be included where Activity Code = C001 or C002.  Therefore, only record #10 can be included in the accumulation.  The accumulation total = 1000.00.  Note: Record #11 cannot be included originally because the wildcard value '!’ for task code requires that journal records have no value populated in that field.

The total base 1 accumulation is the sum of the distribution totals.  That total is 1000.00.  This becomes the statistical unit for Base 1.