Create template for queries and make HiXAgenda/SubAgenda/Afspr-code variable

UMCU-Digital-Health / No_Show

No-show prediction model to reduce the amount of no-shows at the clinics

MIT License

7 stars 2 forks source link

Create template for queries and make HiXAgenda/SubAgenda/Afspr-code variable #70

Open rubenpeters91 opened 5 months ago

rubenpeters91 commented 5 months ago

Currently agenda, subagenda and appointment code are inside the SQL query, but when scaling up, it might be a better idea to make it a template and store the agenda and locations elsewhere. Or move part of the filtering to Python, where the hoofdagenda is still used in SQL, but the exclusion of subagendas and the inclusion of afspraakcodes is done in Python using a config file

rubenpeters91 commented 1 month ago

Idea for new config file setup:


[clinic]

[clinic.example1]
phone_number = "82934"
teleq_name = "Example 1"
main_agenda_code = "Z8492"
subagenda_exclude = true
subagendas = ["Z8362", "Z7493"]
appcode_exclude = true
appcodes = ["VH743", "FH175"]