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.