Version Log
| Version | Version-Date | Changes |
|---|---|---|
| 2025.0.0 | 2025-05-09 | Partial build for testing and JSNA development |
| 2025.1.0 | 2025-06-05 | Full table build excluding 3 practices: - Forest Surgery (F86026) - WF Community & Family Health Services Ltd (F86644) - Beam Park Medical Practice (Y08371) |
| 2025.1.1 | 2025-06-06 | Fixed no patients in CORE_BK_pt and CORE_CH_pt |
lu_ons - Amended short_id for Barking and Dagenham from 'BD' to 'BK' |
||
lu_imd2019 - Amended area_id to lad_id and area2_id to area_id for consistency and improved usability |
||
| 2025.1.2 | 2025-06-16 | Deleted nolonger_homeless_temp table - left by build in error |
Fixed no data in lu_ethnicity2_map table |
||
Fixed bug in db_tables that meant it reported db_tables contained 0 rows |
||
Refreshed db_tables to provide counts forCORE_BK_pt and CORE_CH_pt |
||
| 2025-06-17 | Access provided to ELDB users and CEG staff | |
| 2025.1.3 | 2025-06-20 | Updated db_version for improved version control |
lu_imd2019 - Amended lad_id for Barking and Dagenham from 'BD' to 'BK' |
||
lu_imd2019 - Amended area_id to area2_id, as it contains combined boroughs and added area_id relating to the same geographies used in other tables. |
||
| 2025.2.0 | 2025-07-17 | Regenerated database to incorporate 3 practices that could not be included in initial build: - Forest Surgery (F86026) - Waltham Forest Community & Family Health Services Ltd (F86644) - Beam Park Medical Practice (Y08371) |
Added Beam Park Medical Practice (Y08371) to lu_practice |
||
Rebuilt depression with correct date range (01/04/2006 onwards) - previously built as 01/04/2007 onwards. |
||
Rebuilt cancer with correct date range (01/04/2003 onwards) - previously built as 01/04/2004 onwards. |
||
Added db_counts - previously missing |
||
Replaced db_codeset_ceg with db_codesets that includes all codesets (CEG and PCD) used in ELDB2025 |