Move factEpisodes functions from Power Query to Python

SocialFinanceDigitalLabs / sf-fons-platform

1 stars 0 forks source link

Closed MichaelHanksSF closed 1 month ago

MichaelHanksSF commented 4 months ago

There are currently three processes that Power Query runs in the Dynamic Sufficiency dashboard that Python would manage more efficiently:

a process to work out what the most recent 'S' episode (from RNE) is for a given child per row
a process to work out what the most recent DECOM is for a given child per row
a process that provides the most recent submission year for a given LA (though this may be redundant as already included in #69.

MichaelHanksSF commented 1 month ago

Closing as linked to issue #50 in pipeline code.