Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sufficiency episodes table changes #65

Open
3 tasks
MichaelHanksSF opened this issue Nov 6, 2024 · 0 comments
Open
3 tasks

Sufficiency episodes table changes #65

MichaelHanksSF opened this issue Nov 6, 2024 · 0 comments

Comments

@MichaelHanksSF
Copy link

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 Pipeline: Port Episodes fix to dagster sf-fons-platform#69.

Additionally, we should create a new copy of the episodes table (factPlacementEpisodes) from factEpisodes that follows the logic for only including episodes that correspond to actual placement changes. see regional demand model datacontainer for pre-written logic.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant