Working with Dynamic Date Range filters for Billing Rules

Article author
Dan Jordan
  • Updated

What's the context?


Billing Rules are a powerful feature set in Meddbase which enable you to define available services and their prices.

You may want to set services and prices to only be available within time windows relative to today. For example, at least 1 week after today. Or, at most 4 weeks after today.

The Dynamic Date Range filter feature for selected Billing rules has been designed to address this.

As an alternative to Dynamic Date filters, you can use static Date Range filters for Billing Rules when you want to set fixed dates.

What's in the article?


This article sets out:

What do you need before you get started?


To be able to use Dynamic Date Range filters for Billing Rules, you will need to be on Version 5 of the Billing Rule Service. To enable Version 5, there is configuration activity that needs to take place.

To discuss this please contact the Meddbase Account Management team (email accountmanagement@meddbase.com) for further information.

What are the general principles for Dynamic Date Range filters for Billing Rules?


The general principle is that each Billing Rule for which Dynamic Date Ranges are available can have:

1. A dynamic number of days, weeks or months after today when the Billing Rule becomes valid

2. A dynamic number of days, weeks or months up until which the Billing Rule is valid

3. A dynamic range between which the Billing Rule is valid. Specifically:

3.1 A dynamic number of days, weeks or months after today when the Billing Rule becomes valid

3.2 AND a dynamic number of days, weeks or months up until which the Billing Rule is valid

What types of Billing Rules can have Dynamic Date Ranges applied to them?


The following types of Billing Rules can have Dynamic Date Ranges applied to them:-

  • Price List
  • Provided Services rule
  • Deny Services Rule
  • Patient Self Book Rule
  • Portal Referral Rule

Types_of_Billing_rules_to_which_date_range_applicability_can_be_set

How can a user set up Dynamic Date Ranges for a Billing Rule?


There will be slight variations depending on whether you are updating an existing Billing Rule or creating a new Billing Rule. But the process is similar throughout.

In the scenario where you want to create a new Price List with a Dynamic Date Range you can do as follows:

1. Go to Admin > Billing Rules

2. Find the required company and select + Add Rule > New Price List… from the menu

Select_new_price_list

3. Set the Price List details and Service Prices as required

4. Set the Primary Clinician, Site, Location and Tags as required

The article Setting up Price Lists provides detailed examples of steps 3 and 4.

To apply the Dynamic Date Range:

5. Set the Date is value to Dynamic

6. Click in the Applies from field

6.1. Key in the required value (e.g. 2d to represent 2 days or 1w to represent 1 week)

7. Click in the until…. after today field

7.1 Key in the required value (e.g. 3w to represent 3 weeks)

Add_dynamic_date_range_values_to_Price_List

The Dynamic Date Range is set and the Price List is saved automatically.

8. Add the Price List to the required Charge Band(s)

9. Add other rules to the Charge Band as required

How can Dynamic Date Ranges set for Billing Rules impact on the booking process?


Where Dynamic Date Range values are applied to Billing Rules, they can impact the price and even availability of services for an appointment set for a window of time relative to today. The example scenarios below provide a couple of illustrations.

Example scenario 1 – Price List that applies dynamically in a window of time after today


Let’s say:

1. A Price List has been created with a Dynamic Date range that

1.1. Is valid 2 days after today

1.2. AND is valid up to 8 weeks after today

1.3 It has a Service Price of £110 for a GP appointment

Dynamic_date_range_price_list_example

2. This Price List is added to a Chargeband called 1 - Standard Chargeband

Dynamic_Price_list_shown_on_a_Chargeband

3. No other Billing Rules are set for that Chargeband to impact availability or pricing

4. A patient Christopher Marlowe has been added to 1 - Standard Chargeband that uses these Price Lists

What this means in practice when booking an appointment


From here, let’s say:

1. An appointment is booked for the patient Christopher Marlowe using the Slot Finder

1.1 An Appointment Search is carried out

1.2 The After search parameter of today’s date is set (in this example 16 May 2022)

1.3 Available slots are displayed using the Dynamic Price List

So the Dynamic Date Range applied to the Price List dictates that the next available slots are 2 days after today.

Dynamic_Date_range_price_list_impacting_slot_availability_using_after_today

At the other end of the dynamic date range for the Price List, let’s say:

2. An appointment is booked for the patient Christopher Marlowe using the Slot Finder

2.1 An Appointment Search is carried out

2.2 The After search parameter is set to more than 8 weeks after today (in this example 12 July 2022)

In this case, no slots are returned, as the date falls outside of the Dynamic Date Range window.

Dynamic_Date_range_price_list_-_using_until_after_today_-_no_slots_available

Example scenario 2 - Patient Self-Book rule applies dynamically in a window of time after today


Let's say:

1. A Price List has been created that has a Dynamic date validity of 0 days after today

1.1 It has a Service Price of £110 for a GP Appointment

Price_List_with_a_Dynamic_Date_range_of_zero_days_after_today

2. A Patient Self-Book rule has been created with a Dynamic Date range that

2.1 Is valid 1 week after today

2.2 AND is valid up to 8 weeks after today

2.3 It has GP Appointment in the Services Affected list

Patient_Self_Book_rule_with_Dynamic_Date_range

3. These two Billing Rules have been added to a Chargeband called 2 - Online Chargeband

3.1 This Chargeband is available for online booking by patients in the Patient Portal

3.2 No other Billing Rules are set for that Chargeband to impact availability or pricing

Online_Chargeband_containing_billing_rules_with_dynamic_dates

4. A patient William Shakespeare

4.1 Has been added to 2 - Online Chargeband

4.2 Has registered on the Patient Portal

What this means in practice when booking an appointment on the Patient Portal


From here, let's say:

1. The patient William Shakespeare logs in to the Patient Portal today

1.1. That today is 16 May 2022

2. The patient searches for GP appointments

Then only appointment booking slots are shown which meet the Applies from date criteria of 1 week after today as set in the Patient Self Book Rule.

Online_appointment_search_showing_results_where_dynamic_date_range_filters_used#

Review date


This article was last updated on 2nd December 2024