December Update TO DO

[Jennit07]

For release

• Include social care data in 2023/24 file
• Investigate ICD10 codes for drug related admissions Investigate ICD10 codes for drug related admissions #836
• Include the keep population flag Include keep_population flag in December update #819
• Deaths fixes C06 - Deaths fixes  #338
• Fix ch_provider Bug - Deal with NA in ch_provider and missing group_by() #858
• Investigate and fix sc_demographics Investigate demographic processing script  #855
• Fix issue with missing end dates in sc creating cases after death Fix missing end dates for social care data #848
• slfhelper::get_chi()
• Request a new 2023/24 SPARRA extract

Internal changes:

• Improve test workbooks Review test workbooks #835
• Fix issue with read_slf_individual reading in different years and different formats Investigate and change format of certain variables for 2014-2016 in episode and individual files #860

[Jennit07]

To Do - pre update checks 20/11/23

• MM - merge ch provider
• MM- check latest sc id and make sure its in all social care
• MM - Investigate demographic file with multiple chi per person
• MM - check if happy with Make improvements to test workbooks #849
• JT - finish checking tests in Create tests for all social care extracts #854
• JT and MM - have a call in afternoon to check targets file and add Create tests for all social care extracts #854
• Make changes to targets file Create tests for all social care extracts #854 (Posit went down through call)
• JT - check PR AT, SDS, HomeCare - fix missing end dates #852
• JT - get boxi extracts 1pm with RV
• JT and MM - check over Keep population flag Keep population #847
• JT - clear out sourcedev and move boxi extracts

[SwiftySalmon]

• MM - check if happy with Make improvements to test workbooks #849 - mm this one needs the hscp2018 function added and then all good

[Jennit07]

Boxi extracts all downloaded and should be appearing in the temp file location. Need to clear out sourcedev before moving them to each year folder