Accounting period

If the partitioning policy chosen is "Period", an accounting period is used to determine the period to which Output Events belong in order to inject records in the corresponding partitions.

An accounting period is computed taking into account:

  • The reference Period table.
  • The Collection date (date when the collection is created).
  • The accounting (functional) date (of the line in the collection).

To determine the period, operation date and application date are used by default following the rule defined below. You can, however, define and use your own exit.

Field Description
Current period

Computed ONCE at the beginning of the injection, it takes into account the Collection date, checks the Period table.

The current period is when Begin period < Collection date <= End period.

Accounting period

The accounting period of the line is computed for each line of the Collection:

  • If the operation date is included in the current period that is Current period Begin date < operation date <= current period end date, then the accounting period is the current period.
  • If the operation date is included in the previous period, the Collection date must be checked against the cut off date of the previous period update:
    • If the Collection date is inside this limit, that is, Collection date <= previous period cut off date, the accounting period for the line is the previous period.
    • If the Collection date is not included, the accounting period for the line is the current period.

Sample Period table:

Period name

Begin date
(Operational date)

d/m/yyyy

End date
(Operational date)

d/m/yyyy

Cut-off date

d/m/yyyy

1201 2/1/2012 31/1/2012 3/2/2012
1202 1/2/2012 29/2/2012 5/3/2012
1203 1/3/2012 1/4/2012 4/4/2012
1204 2/4/2012 1/5/2012 4/5/2012
1205 2/5/2012 31/5/2012 5/6/2012
1206 1/6/2012 1/7/2012 4/7/2012
1207 2/7/2012 31/7/2012 3/8/2012
1208 1/8/2012 2/9/2012 5/9/2012
1209 3/9/2012 30/9/2012 3/10/2012
1210 1/10/2012 1/11/2012 6/11/2012
1211 2/11/2012 2/12/2012 5/12/2012
1212 3/12/2012 1/1/2013 8/1/2013
1301 2/1/2013 31/1/2013 5/2/2013

In this example:

  • "Period name" indicates the year and the month.
  • "Begin date" is the date when the period starts.
  • "End date" indicates the date when the period ends.
  • "Cut-off date" is the latest date when a calculation can be taken into account in the period.

To define partitions and define Period tables, see Set partitions in Designer. See also Populate a Period table.

 

Related Links