Bill Period Timeline
Prerequisites
To create a bill period timeline, you need to ensure the following:
-
Bill period is defined in the system.
-
Derived bill period is monthly where the bill dates start from 1st of every month.
On enrolling a group or individual membership, the system creates a timeline for each month of the membership coverage period in the CI_REPRC_REQ_DTL table. It refers the derived bill period while creating the timelines for the repricing record. For example, when a membership is enrolled for the coverage period 01-Jan-2025 to 31-Dec-2025, the system creates a timeline for each month starting from 1st Jan 2025 using the bill period (as shown in the below table).
Bill Period | Bill Period Timeline with Effective Date |
---|---|
01-01-2025 to 01-31-2025 | TL1 with 01-01-2025 |
02-01-2025 to 02-29-2025 | TL2 with 02-01-2025 |
03-01-2025 to 03-31-2025 | TL3 with 03-01-2025 |
04-01-2025 to 04-30-2025 | TL4 with 04-01-2025 |
05-01-2025 to 05-31-2025 | TL5 with 05-01-2025 |
06-01-2025 to 06-30-2025 | TL6 with 06-01-2025 |
07-01-2025 to 07-31-2025 | TL7 with 07-01-2025 |
08-01-2025 to 08-31-2025 | TL8 with 08-01-2025 |
09-01-2025 to 09-30-2025 | TL9 with 09-01-2025 |
10-01-2025 to 10-31-2025 | TL10 with 10-01-2025 |
11-01-2025 to 11-30-2025 | TL11 with 11-01-2025 |
12-01-2025 to 12-31-2025 | TL12 with 12-01-2025 |
However, if a repricing is triggered for a membership due to any change (for example, a newborn entry) effective from 01-Jun-2025, then the system creates a timeline for each month starting from 1st June 2025 using the bill period (as shown in the below table).
Bill Period | Bill Period Timeline with Effective Date |
---|---|
06-01-2025 to 06-30-2025 | TL1 with 01-01-2025 |
07-01-2025 to 07-31-2025 | TL2 with 02-01-2025 |
08-01-2025 to 08-31-2025 | TL3 with 03-01-2025 |
09-01-2025 to 09-30-2025 | TL4 with 04-01-2025 |
10-01-2025 to 10-31-2025 | TL5 with 05-01-2025 |
11-01-2025 to 11-30-2025 | TL6 with 06-01-2025 |
12-01-2025 to 12-31-2025 | TL7 with 07-01-2025 |
To create timelines for a repricing record, you need to attach the Bill Period Timeline Creation (C1-BILLRPCR) algorithm to the Account and Price Item Derivation Post-Processing system event of the age based, tier based, additional fee, benefit, and/or discount charge pricing rule types. The system invokes the C1-BILLRPCR algorithm in the C1-REPC1 batch. This algorithm creates a bill period timeline for the membership. For more information, see C1-BILLRPCR.