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.

Sign up for GitHub

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

Jump to bottom

Better bridge tables #109

Open
peterdutey opened this issue Jan 10, 2023 · 0 comments
Open

Better bridge tables #109

peterdutey opened this issue Jan 10, 2023 · 0 comments
Labels
enhancement New feature or request
Projects
Ramses development
Milestone
v0.9.0

Comments

@peterdutey
Copy link
Collaborator

User-reported improvements on bridge tables, thank you @selinapatel1

  1. Bridge tables are currently focused on producing rates for a given set of episodes or encounters.
    This does not easily cater for users who would like to drill down by day.
    Bridge tables could have a 'day drill' function to allow users to easily report for whatever period they are interested in, discarding the part of episodes/encounters that fall outside this date.
    As part of this we could rethink bridge tables more fundamentally with an OLAP/data cube design.
  2. Bridge tables are currently designed for medication as prescribed, not as administered. Bridge tables should offer both.
@peterdutey peterdutey added the enhancement New feature or request label Jan 10, 2023
@peterdutey peterdutey added this to To do in Ramses development via automation Jan 10, 2023
peterdutey added a commit that referenced this issue May 13, 2023
@peterdutey
refactor all bridge_tables and add metrics tables #109
a85e19c 
- remove bridge_encounter_therapy_overlap()
- add bridge_episode_therapy_overlap()
- add bridge_inpatient_episodes_date()
- add bridge_drug_prescriptions_date()
- add create_reporting_inpatient()
- add create_reporting_med_prescribing()
- begin rewriting Ramses.Rmd vignette (getting started)
- change name of Postgres database
@peterdutey peterdutey added this to the v0.8.0 milestone Nov 19, 2023
@peterdutey peterdutey mentioned this issue May 11, 2024
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
Ramses development
  
To do
Milestone
v0.9.0
Development

No branches or pull requests
1 participant
@peterdutey