Overview
The Sanitation District had been utilizing Unifier for project management and recently implemented recording contractor pay applications. They needed to output a printed report of the schedule of values progress and requested assistance from DRMcNatty to implement and design.
Challenges
With Unifier hosted in the original Skire shared database, no direct access to the data schema is possible. The query process in Unifier does not provide adequate error trapping when writing the Data View for a report query. Additionally, the Unifier data design complicates data retrieval and display because of how the data is stored.
The most significant challenges were:
- No direct access to the Sanitation District database schema.
- Pay Application (Pay App) data stored in the Pay App BP tables are incomplete and can only record progressed items. This requires creating a more complex SQL query to retrieve a simple report.
Below is a list of some complex issues for the report ing effort:
- No Cost Breakdown Structure (Cost Sheet) by WBS Codes used in Pay Apps. Instead, cost broken down using Work Packages (Bid Items) created outside of the Cost Sheet.
- Mapping tables were used to make the association between Contract, Contract Line Items, SOV, Pay App, Pay App Line Items, Change Order and Change Order Line Items.