Skip to content

Dropdown Lists

Lists

Lists that feed either the toggle buttons or the select dropdowns are either found in the constants folder, or are seeded to the database in the migrations.

Organisation lists are seeded from constants as are the levels of abstraction associated with them (trust, ICB etc.)

The Epilepsy causes and comorbidities, by contrast are a SNOMED refset seeded from lists inconstants in migration 0006 and 0009 into EpilepsyCause and ComorbidityList respectively.

Syndromes are from lists in the constants folder.

Epilepsy medicines (both rescue and not) are found in the constants folder before saving in the Medicine table.

Semiology Keywords, used to categorize words in the free text descriptions of a seizure event, are taken from a list in the constants folder.

The tables that supply the dropdowns are seeded in the migrations which is a recommended way in the Django documentation to add data, known as data migrations.

Since go-live, E12 have wished on the basis of user feedback, from time to time to add new items to these lists. The process for adding new items should be:

EpilepsyCause

Workflow to add a new cause:

  1. Navigate to the SNOMED CT browser: https://browser.ihtsdotools.org/ and search for the cause and get the SCTID
  2. Add the SCTID, preferredTerm, Term to the epilepsycauses.json in constants for future seeding. Add the same to the django admin in live and staging

[!NOTE] Epilepsy Causes have as of #1224 been deprecated pending a better solution.

Organisations

Just updating the RCPCH_ORGANISATIONS constant will not in itself update the database, but is a necessary step in the process. The workflow needs to be:

Deleting an organisation

  1. check there are no children associated with this organisation. If there are, it must not be deleted
  2. Delete the organisation in the admin. This will delete any relationships it also has with associated trusts/health boards etc as well KPIAggregation models

Updating an organisation

This can be done reasonably straightforwardly in the admin. Note that the ODS Code is a unique identifier and if the update includes an update to this, you are in effect creating a new organisation, rather than editing an existing one. Better therefore to create a new organisation and delete the old. This becomes more complicated if there are children associated with this organisation.

Adding a new organisation

This can be done in the admin. The ODS Code must be unique. The name and ODS code should ideally be mandatory fields but are not currently prescribed as such in the model. Note that you must also allocate the Trust/Health Board, ICB, NHS England Region, London Borough and Country. Add the same details to the RCPCH_ORGANISATIONS constant. This is necessary later when seeding the KPI Aggregation models in the shell:

from epilepsy12.common_view_functions import _seed_all_aggregation_models
_seed_all_aggregation_models()