Skip to content

Importing and running price concession emails

Chris Wood edited this page Aug 23, 2022 · 3 revisions

Concessionary pricing

Price concessions are granted by the Department of Health and Social Care (DHSC) on a monthly basis with the current list published on the PSNC website. The concessions list is updated ad-hoc throughout the month, with a final list published on the last working day of the month.

Notification of Price Concessions update

Notifications are received on the #rss Slack channel when a new/updated concessions list is available.

Importing and running price concessions emails

The following commands should be followed on the #technoise Slack channel

Step 1: Importing

To initiate scraping of the data from the price concession list:
@Bennett_Bot op ncso import

  • Once completed, two message will appear confirming this.
  • If zero new concessions are imported this could be due to the RSS alert being sent ahead of the PSNC page update - check the PSNC page and re-run the above command once the PSNC page has updated.

Step 2: Report

To get a status update from the price concession list:
@Bennett_Bot op ncso report

The report will appear as a Slack message and detail total concessions, concessions for the current month and the number of unreconciled concessions.

Step 3: Reconcile (if applicable)

If there are unreconciled concessions you will be prompted to reconcile with the following command:
@Bennett_Bot ncso reconcile concession [ID] against vmpp [VMPP ID]

  • [ID] should be replaced with the appropriate ID from the Slack NCSO Report Message
  • [VMPP ID] should be replaced with the appropriate Virtual Medicinal Product Packs. This can be found using the OpenPrescribing dm+d browser and selecting the appropriate Virtual Medicinal Product Pack (based on drug, formulation, strength and pack size). The VMPP ID will appear at the top of the page after "VMPP" and also in the URL. (VMPP ID is also given in the table that can be accessed via the RSS alert although these aren't included within the main PSNC Price Concession page).

Repeat the above step if there are multiple unreconciled concessions. Once reconciling is complete re-run the following command to ensure all have been reconciled:
@Bennett_Bot op ncso report

Step 4: Send alerts

Initiate alert emails process with the following command:
@Bennett_Bot op ncso send alerts

This command will take about 30-40 minutes to complete. A notification message will appear once completed e.g. "Sent 218 alerts". During the process a notification should also appear in the #doorbell2 channel as this email address is subscripted to receive alerts for price concessions for NHS Oxfordshire CCG.