Another idea is to have the option to create static tables in the database. These would act as reference tables and could be used for two different purposes…
- A Config file for the process - instead of having a separate Excel file - in fact I think that all processes should by default have a config table within Orchestrator
- A reference table for specific processes, e.g. this table should be something that can be referenced from the process. For example, a list of valid airports that can be flown from. Again , this removes the need for separate Excel reference files.
These tables could be created in a similar way to present with perhaps a check box to say whether it’s a reference table and therefore should not be consumed in the way current queues are.