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 |