The following table list the tables that store the parameter and results of optimization analysis scenarios.
| Table | Description | Associated Window |
|---|---|---|
PMS_ANALYSIS_SCENARIO | List of all scenarios and scenario parameters | Optimization Analysis window, Setup tab, Scenarios pane |
SCENARIO_FINANCIAL_PARAMS | Financial parameters associated with each scenario. | Optimization Analysis window, Setup tab, Yearly Financial Parameters pane |
PMS_OPTIM_CONSTR | Constraints and objects associated with each scenario. | Optimization Analysis window, Setup tab, Constraints pane |
PMS_ANALYSIS_SCENARIO_WP | list of suggested repairs (Work Plan) | Optimization Analysis window, Results tab |
PMS_REPORT_CONSTR_RESULTS | reporting functions values | Optimization Analysis window, Report tab. |
PMS_OPTIM_CONSTR_RESULTS | Constraints values after analysis | Optimization Analysis window, Constraints Results tab |
PMS_ANALYSIS_OPTIM_RES_LOC | Section’s location and year-independent data (e.g. inventory data) | Detailed Optimization Results window, Road Section pane |
PMS_ANALYSIS_OPTIM_RES_DET | Each section’s detailed analysis result data, e.g. condition, treatments and costs. | Detailed Optimization Results window, Named Details pane |
MY_PROJECT | List of section strategy types for each section | Section Strategy window, Strategy Assigned to Road Section pane |
MY_PROJECT_DET | List of detailed section strategies for each section in each year | Section Strategy window, Strategy Details pane |
