September 24 update

[Jennit07]

• Run files 2017/18 onwards for any bug fixes and new care home methodology
• Update Reference document - going forward, update this each quarter

Development

• attach death dates to activity after death flag Death dates #961
• process deaths lookup needs added to targets process_deaths_lookup needs added to targets #958
• automate process deaths lookup automate process_deaths_lookup  #957 make this automated to pick up files starting with name "get_slf_deaths_lookup_p... #968
• Care home methodology review Review quarter calculation functions #915 - Different from SPSS. SPSS has nursing provider and period in the group_by. Nee... #873
• client flags Add extra client flags to SLF #106
• add cup markers Bring in the cup_marker from the UCD to GP OoHs #775 Bring in the cup_marker from the UCD to Acute #776
• New NSU cohort - 23/24 file Request new NSU extract #959
• get new sparra extract for 24/25 file Get new SPARRA File for 24/25 #976 - email sent to team requesting for August completion
• person_id missing from SDS person_id is missing from SDS #975
• person_id missing from client - Include person_id (from client_id) #714
• investigate a new sc marker for a&e attendances CUP marker for A&E attendances & admissions together #974

Admin

• Create new 24/25 files
• Follow up with Homelessness team about completeness SG publication - how often do we update this? Update - I have asked the question and the team will look into this. I will then update our SOP to ensure we update this annually
• Update documentation Update Documentation  #887
• Run older files with updated R code Run older files with the R code  #893
• decide if to remove IT deaths extract C06 - Deaths fixes  #338

[SwiftySalmon]

re: removing IT death extract #338 this is only used in care home code and I had a look and it would make no difference if we just used the boxi extract.