Typically, a transportation agency will keep a list of planned projects and update the projects regularly for when the project will be performed, where it will be performed, the planned treatment, and estimated project cost. This list is termed a master work plan (MWP) in Pavement Analyst. The MWP can serve as the part of the inputs to network analysis. Furthermore, the final list of sections proposed for treatment based upon network analysis results and, as necessary, user intervention can be saved for the next year’s work plan.
During the network analysis, the projects in the existing master work plan are considered “already programmed” and therefore will be excluded from the optimization routine, but still be included in the final work program. In other words, including a master work plan will force the system to apply the defined treatments in the specified years to the defined segments. In analysis, these projects are considered “off the top” and processed before any other project selection is done.
The Pavement Analyst is able to perform this type of analysis procedure and produce the required outputs.
When an MWP is plugged into an optimization analysis, the system will first find the MWP projects that intersect in full or in part with the management sections included based on the analysis scope. Then, these MWP projects together with the original management sections are finest partitioned to create the updated analysis sections. The resulting sections are then placed into the USER_OPTIMIZATION_ENGINE table and proceeded with the defined analysis procedure. However, the analysis procedure will only consider the portions of MWP project that intersect with scoped management sections. After the analysis is finished, when MWP projects are copied into the final scenario work plan, the full MWP project is used even if portion of it is outside the analysis scope boundaries.
Out of the box, the table that stores the Master Work Plan is named PMS_MASTER_WP, and the corresponding window is located under Pavement Analyst > Analysis > Network Analysis > Master Work Plan menu.
PMS_MASTER_WP is a strictly Location-referenced data table (see detailed discussion in in the Tables topic), i.e., the data is identified strictly by a location in the LRS network (route with "from" and "to" point boundaries).
Out of the box, PMS_MASTER_WP table has these columns:
| COLUMN_NAME | DATA_TYPE | DATA_LENGTH | NULLABLE | COMMENTS |
|---|---|---|---|---|
LOC_IDENT | NUMBER | 22 | N | Location # used in SETUP_LOC_IDENT table to store the record’s location in the LRS. This is a system column. |
PLAN_YEAR | NUMBER | 22 | N | Plan year of the project |
PMS_TREATMENT_ID | NUMBER | 22 | Y | Planned treatment |
MWP_PROJECT_STATUS_ID | NUMBER | 22 | Y | MWP project status |
PROJECT_PRICE | NUMBER | 22 | Y | Project cost |
PMS_BUDGET_CAT_ID | NUMBER | 22 | Y | Budget Category |
OWNER_ID | NUMBER | 22 | Y | Owner/Jurisdiction |
PMS_MASTER_WP_TYPE_ID | NUMBER | 22 | N | Master Work Plan Type. The system supports to develop multiple sets of work plans, with the different work plans set being defined as a Master Work Plan Type. Each type is maintained independently from each other. |
BENEFIT | FLOAT | 22 | Y | Benefit |
APPROVED | NUMBER | 22 | Y | Whether the project is approved |
STATE_OWNER_ID | NUMBER | 22 | Y | State owner ID |
LENGTH | NUMBER | 22 | Y | Length of the project |
USER_UPDATE | VARCHAR2 | 400 | Y | Last update user of the record |
DATE_UPDATE | DATE | 7 | Y | Last update date of the record |
COMMENT_STR | VARCHAR2 | 4000 | Y | Comment of the record |
COMMENT_ID | NUMBER | 22 | Y | Attachment |
If a customer has data in addition to the above-mentioned dataset, additional columns can be created and configured in a similar method to Roadway Inventory or Pavement Condition data. The process can be found in “Create Tables” and “Create Windows” chapters in “AgileAssets System Foundation Configuration Guide”.
In the Master Work Plan window, a user can select a Master Work Plan Type from the drop-down list in the “Select WP Type” field at the top of this window, and review/enter the data for the work plan. The data is then used in optimization analysis and reports. When you right-click the table, a shortcut menu is displayed. This menu contains the common commands along with the following special commands:
- Recalculate Cost: This command utilizes the treatment cost formula configured in the Calculated Expressions window. This formula uses the input parameters for treatment costs found in the Master Work Plan window. The result of this formula is then displayed in the Project Cost column.
- Copy Analysis Results: This command displays a dialog box from which you select the scenario analysis and then the line items you want to copy to the Work Plan Data window. Click here for more information on using this command.
- Copy from Master WP: This command displays a dialog box from which you select another work plan and then the line items you want to copy to the Work Plan Data window.
- Copy from Network Master: This command displays a dialog box from which you select the records you want to copy to the Work Plan Data window.
- Create Pavement Construction Record: This command creates a construction history section record from the currently selected master plan record provided a work code is designated for the treatment assigned to the master plan record. The construction history section record is then available for edit and review in the Construction History window.
Note: Once an item in a work plan is used to create a construction history record, this command is no longer available for that line item.
The list of Master Work Plan Type drop-down at the top of the window can be maintained at Work Plan Type window (under Pavement Analyst > Setup > Network Analysis Setup > Work Plan > Work Plan Type menu). The MWP Project Status drop-down field in the table can be maintained at the MWP Project Status window (under Pavement Analyst > Setup > Network Analysis Setup > Work Plan > MWP Project Status menu).
