Development TODO list

[Moohan]

Short term

SLF Issues

• Preventable beddays - investigate large increase in total_preventable_beddays #757 and 757 investigate large increase in total preventable beddays #779
• Lots of blank datazone in A&E, due to PC8 postcode format Investigate missing datazone from episode file #773

(re)Additions

• HRI - Add HRI back to the individual file #761 Create HRI Variables #778
• Homelessness flags - Homelessness flags #771
• Archive DN and CMH data #777 Amend get_boxi_extract_path function for archiving DN and CMH data  #785

September 23 Update

• NSU cohort for 2022\23. - Create 2022/23 NSU cohort  #768
• Create the new 2023\24 files.
• Final 'regular' update for 2021\22 files.

Medium term

(re) Additions

• Death date fixes - C06 - Deaths fixes  #338
• keep_population flag - (Include keep_population flag in December update #819). LIST analysts requesting this flag again, something to prioritise for the December update.
• social care data
• ICD10 codes for identifying drug related admissions
• review Tests workbook - split out episode/indiv file tests.
• review extract workbook tests

Code clean-up

• Various code improvement suggestions - Remove package wide imports of readr functions #686 Move {targets} and {tarchetypes} to required packages #687 make the slf_path a function #725
• Remove redundant code (e.g. Individual file) Remove some obsolete code #770
• Rename functions for consistency and clarity. Improve documentation. - Fix pgkdown job #605 Reduce the number of dependencies  #580 Check for snake_case once all SPSS has stopped #509 Make sure that all test workbook sheet names are snake_case #508

Tests

• Add missing tests (for data) - add tests for the Delayed Discharges extract #671 add tests for the SC client lookup #672
• Improve existing (data) tests - Simplify create_hscp_test_flags #689

Improvements

• {keyring} setup should be simpler - improve error messages and provide instructions for setting up keyring #545
• Split the tests for episode and individual out into their own workbooks.
• Make the Social Care client info matching better - Match client flags (and info) to all CHIs #107 # 106 Remove the client data from the individual Social Care extracts #741 Update the client lookup processing script to match #742
• Expand person_id to enable unique identification when records don't have a CHI - # 41 - Include person_id (from client_id) #714

Longer term / On-hold

• Bring in the cup_marker from the UCD to GP OoHs and Acute. Bring in the cup_marker from the UCD to GP OoHs #775 Bring in the cup_marker from the UCD to Acute #776
• Cross-year tests Create cross-year tests #11
• Review the cohorts - Create new / modify existing cohorts to take into account all available data.
• Review DN / CMH now data collection has stopped (related Review the DN extract #207)
• NHS 24 added - Add NHS24 data #5
• SAS added - Add SAS data #4
• Add Ethnicity - Gather ethnicity from datasets  #115

[Jennit07]

Hey @Moohan This looks great! Good to see everything in the one place to keep us on track! One thing that came to mind not on this list is a new NSU cohort and also new 23/24 file creation?

[Moohan]

Thanks, I've added those.