Interval Types for Grouping Calendar Periods

Interval types group specific calendar periods to accumulate achievements, such as interval-to-date attainment, earnings such as year-to-date earnings, or payments during calculation and payment processing.

There are four delivered interval types:

  • Year

  • Semi Annual

  • Quarter

  • Period

    Period has the same definition as the calendar period.

You can create interval types, as required.

Example of Quarterly Intervals

This example shows how to use interval numbers to group periods into quarters.

Period

Year

From Date

To Date

Interval Number

Jan-15

2022

1-Jan-2022

31-Jan-2022

2022001

Feb-15

2022

1-Feb-2022

28-Feb-2022

2022001

Mar-15

2022

1-Mar-2022

31-Mar-2022

2022001

Apr-15

2022

1-Apr-2022

30-Apr-2022

2022002

May-15

2022

1-May-2022

31-May-2022

2022002

Jun-15

2022

1-Jun-2022

30-Jun-2022

2022002

Jul-15

2022

1-Jul-2022

31-Jul-2022

2022003

Aug-15

2022

1-Aug-2022

31-Aug-2022

2022003

Sep-15

2022

1-Sep-2022

30-Sep-2022

2022003

Oct-15

2022

1-Oct-2022

31-Oct-2022

2022004

Nov-15

2022

1-Nov-2022

30-Nov-2022

2022004

Dec-15

2022

1-Dec-2022

31-Dec-2022

2022004

Example of Yearly Intervals

This example shows how to use an interval number to group periods into a year.

Period

Year

From Date

To Date

Interval Number

Jan-15

2022

1-Jan-2022

31-Jan-2022

2022

Feb-15

2022

1-Feb-2022

28-Feb-2022

2022

Mar-15

2022

1-Mar-2022

31-Mar-2022

2022

Apr-15

2022

1-Apr-2022

30-Apr-2022

2022

May-15

2022

1-May-2022

31-May-2022

2022

Jun-15

2022

1-Jun-2022

30-Jun-2022

2022

Jul-15

2022

1-Jul-2022

31-Jul-2022

2022

Aug-15

2022

1-Aug-2022

31-Aug-2022

2022

Sep-15

2022

1-Sep-2022

30-Sep-2022

2022

Oct-15

2022

1-Oct-2022

31-Oct-2022

2022

Nov-15

2022

1-Nov-2022

30-Nov-2022

2022

Dec-15

2022

1-Dec-2022

31-Dec-2022

2022