Readmission of previously well babies

[tomjemmett]

There is a subtle difference between the old logic used when we extracted from our Sql server and what we are using here.

Previously, we join the nhp inpatients view to itself. We now join the nhp inpatients table (which only includes a subset of providers) to the base inpatients table (which includes all providers).

The subtle difference is in the Sql version, the inpatients view is filtered to remove well babies. So, our new logic is including more "readmissions" because we have cases where a baby is readmitted within 28 days of birth, but we previously didn't count this as a readmission because we were filtering out the well baby rows.

I think that this is an oversite, and the new logic is correct. This issue is being created purely to note this difference and allow anyone to have a differing opinion.

[StatsRhian]

• Needs to be checked by Jake
• Then added to data log on project information

[tomjemmett]

For v3.0.0 matched the logic in v2.2.0. Keeping issue open so we can review in the next sprint

[yiwen-h]

• Discussion for analytical steering group
• Add clarification to project information
• Flag with Alex - possibility to include with paeds mitigators? - Analyse what conditions these previously well babies are being readmitted with

[yiwen-h]

@tomjemmett would like to do more work on this before it goes to analytical steering group

[yiwen-h]

• @yiwen-h to explain issue to @alexanderlawless
• @yiwen-h to add clarification to project_information

[yiwen-h]

This is no longer a data science issue. Have scheduled meeting with @DandyOoh ; if not suitable for the paeds mitigators, will pass to Mitigator Review process.