The tables that store the parameter and results of optimization analysis scenarios are the following:

TableDescriptionAssociated 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

PMSX_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

PMSX_ANALYSIS_OPTIM_RES_LOC

Section’s location and year-independent data (e.g. inventory data)

Detailed Optimization Results window, Road Section pane

PMSX_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

  • No labels