Skip to main content

Search

Welcome to PMG Support

Project Cost History Report

PMG Support
  • Updated

The Project Cost History Report can be accessed on the "Select Report" list on the Standard Reports interface.

Function

The Project Cost History Report lists the project cost changes across all STIPs.

AK STIP Manager Updated Project Cost History Report.png

Generate the Report

Since the Project Cost History Report lists the project cost changes across all STIPs, the STIP and Revision filters will be disabled as they do not apply when this report is run. The user will be able to filter the report using the following fields. The report can be run without these fields being filled, but it will include all Need IDs, regions, MPO, place name, and programs.

Field Used To...
Need ID Textbox Enter the Need ID in whole or in part.
DOT Region Dropdown Select a region to filter the report data; holds all values in the DOT Region code list.
MPO Dropdown Select an MPO to filter the report data; holds all values in the MPO code list.
Place Name Dropdown Select a place name to filter the report data; holds all values in the Place Name field list.
Program Dropdown Select a program to filter the report data; holds all values in the Program code list.

Once these fields are satisfactorily filled, the user can click an output type: "Open as PDF" or "Open in Excel."

Report Format

The report will open in the corresponding output format (PDF or Excel). The report will be broken up into two main areas for each project entry: Project Header and Project Table.

Project Header

The Project Header will include the following information.

  • Need ID: This is the STIP Identifier for the project from the Project Detail tab.
  • Project Title: The latest name for the STIP project as shown on the Project Detail tab.
  • Created Date: This is the earliest Initiated Date found across all STIPs for the project.
  • Added to STIP: This is the earliest Approval Date found across all STIPs for the project and the STIP name associated.
  • Name Change: This is a Yes/No flag to indicate whether the Project’s Title has ever been modified across all STIPs. A Y indicates Yes, a N indicates No.
  • Description Change: This is a Yes/No flag to indicate whether the Project’s Description has ever been modified across all STIPs. A Y indicates Yes, a N indicates No.
  • Project Status: This will read "Please use NID Obligations Report."
  • Initial Estimate: This is the earliest Estimate value found across all STIPs for the project.
  • Approved Estimate: This is the approved Estimate value found in the Active STIP.
  • Latest Estimate: This is the latest Estimate value found in the Active STIP.
  • Current Change: This value is the Latest Estimate minus the Approved Estimate.
  • Total Change: This value is the Latest Estimate minus the Initial Estimate.

Project Table

The report contains a project table for each STIP that the cost was modified in, including the original version for each STIP and the pending version (if applicable). Each project table will include the following fields.

Field Description
STIP The Name and Version of the STIP that corresponds with the Project table (example: 2023 – 2026 Original).
Need ID The STIP Identifier for the project from the Project Detail tab.
Project Title The name for the STIP project.
Phase The name of the work phase associated with the funding record. The funding records with the same work phases are grouped together in the table; after each phase, there is a designated total row showing the dollar amount associated with that work phase.
Fund The abbreviation of the funding category associated with the funding record.
FFY Window Years The funding amounts for the specified record by Phase and Fund.
Remaining The funding amounts for a project that appear after the last year in the reported STIP.
Total Funding The total funding for the table row.
Change Comments A comment documenting the reason for the change.

Comments

0 comments

Please sign in to leave a comment.