Project Controls Suite
R-32: Data Quality & Completeness Report
Data Date: 28 Feb 2026
Data Quality & Completeness Report
Pacific Rail Corridor Upgrade — PMO Data Quality Audit — 28 February 2026 Submission
Overall Quality Score
71%
Grade: C+ (target ≥85%)
Required Fields at 100%
4 of 9
5 required fields below 100%
Activities Missing ≥1 Code
340
12.0% of all activities
Duplicate Activity Names
47
Pairs identified
Naming Violations
128
Non-conformant to NCS standard
Overall Quality Score Breakdown
71%
Data Quality
Grade C+
Target: 85%
Score Component Breakdown
Field Completeness Matrix
| Category | Field / UDF / Code | Total | Populated | Empty | % Complete | Status | PMO Mandate |
|---|---|---|---|---|---|---|---|
| Required Fields — Must be 100% populated per Contract Schedule Management Plan Clause 5.1 | |||||||
| Required | Activity ID | 2,847 | 2,847 | 0 | 100.0% | Compliant | Mandatory |
| Required | Activity Name | 2,847 | 2,847 | 0 | 100.0% | Compliant | Mandatory |
| Required | WBS Assignment | 2,847 | 2,847 | 0 | 100.0% | Compliant | Mandatory |
| Required | Original Duration | 2,847 | 2,847 | 0 | 100.0% | Compliant | Mandatory |
| Required | Responsible Party Code | 2,847 | 2,418 | 429 | 84.9% | Non-Compliant | Mandatory |
| Required | Discipline Code | 2,847 | 2,507 | 340 | 88.1% | Non-Compliant | Mandatory |
| Required | Work Area Code | 2,847 | 2,591 | 256 | 91.0% | Non-Compliant | Mandatory |
| Required | Phase / Stage Code | 2,847 | 2,678 | 169 | 94.1% | Warning | Mandatory |
| Required | Resource Assignment | 2,847 | 2,703 | 144 | 94.9% | Warning | Mandatory |
| Recommended UDF Fields — Target 90%+ populated per PMO Schedule Data Requirements | |||||||
| UDF | UDF: Planned Crew Size | 2,847 | 2,204 | 643 | 77.4% | Below Target | Recommended |
| UDF | UDF: Sub-Contractor Name | 2,847 | 2,018 | 829 | 70.9% | Below Target | Recommended |
| UDF | UDF: Scope of Work Reference | 2,847 | 1,768 | 1,079 | 62.1% | Below Target | Recommended |
| UDF | UDF: Risk Register Link | 2,847 | 1,412 | 1,435 | 49.6% | Below Target | Recommended |
| UDF | UDF: IFC Drawing Reference | 2,847 | 2,391 | 456 | 84.0% | Below Target | Recommended |
| UDF | UDF: Permit Required (Y/N) | 2,847 | 2,712 | 135 | 95.3% | Compliant | Recommended |
| Activity Code Fields — Required for Cost Account and WBS Reporting Integration | |||||||
| Code | Cost Account Code (CAC) | 2,847 | 2,641 | 206 | 92.8% | Warning | Mandatory |
| Code | Milestone Type Code | 412 | 412 | 0 | 100.0% | Compliant | Optional |
| Code | Inspection Hold Point Flag | 2,847 | 2,180 | 667 | 76.6% | Below Target | Recommended |
| Code | Priority Code (H/M/L) | 2,847 | 1,924 | 923 | 67.6% | Below Target | Recommended |
Duplicate Activity Name Check
47 duplicate activity name pairs were identified. Duplicate names create confusion in reports and can mask data entry errors. The Naming Convention Standard (NCS-2024) requires globally unique names across the project schedule.
| Activity ID 1 | Activity ID 2 | Duplicate Name | WBS 1 | WBS 2 |
|---|---|---|---|---|
| RC-1041 | RC-2204 | Install Sleeper Fastenings | 02.01 | 04.02 |
| RC-1810 | RC-3301 | Signal Cable Pulling | 05.03 | 07.01 |
| RC-2044 | RC-2810 | Ballast Tamping — Zone B | 02.02 | 02.04 |
| ... 44 additional duplicate pairs (full list in Appendix DQ-1) ... | ||||
Naming Convention Violations (NCS-2024 Standard)
| Violation Type | Rule Violated | Count | Example Activity Name | Action Required |
|---|---|---|---|---|
| Format | NCS-R-01: Name must begin with verb (Mobilise/Install/Test/Inspect) | 54 | Track Gangs - Zone 4 (missing verb) | Rename |
| Format | NCS-R-02: Name must include location reference in brackets [Zone X / Area Y] | 38 | Lay Rail Track (no location) | Rename |
| Length | NCS-R-03: Maximum 80 characters | 17 | Install Overhead Line Equipment including stanchions, registration arms, and droppers at all attachment points [Sector 3 North bound line between km 142.3 and km 148.7] | Truncate |
| Format | NCS-R-04: No special characters except hyphen, brackets, forward slash | 12 | Test & Commission Signal Box #4 (use of # and &) | Rename |
| Convention | NCS-R-05: Milestone names must end in "— Complete" or "— Approved" | 7 | Piling Done (should end in — Complete) | Rename |
Contractor Remediation Plan — Required Actions by 28 Mar 2026
| Priority | Issue | Count | Deadline | Owner | Status |
|---|---|---|---|---|---|
| P1 — Critical | Populate Responsible Party Code for all 429 activities | 429 | 14 Mar 2026 | Scheduler | In Progress |
| P1 — Critical | Assign Discipline Code to 340 uncoded activities | 340 | 14 Mar 2026 | Scheduler | In Progress |
| P1 — Critical | Assign Work Area Code to 256 activities | 256 | 14 Mar 2026 | Scheduler | In Progress |
| P2 — High | Resolve 47 duplicate activity name pairs per NCS-2024 | 47 | 21 Mar 2026 | Lead Scheduler | Not Started |
| P2 — High | Correct 128 naming convention violations | 128 | 21 Mar 2026 | Lead Scheduler | Not Started |
| P3 — Medium | Populate UDF: Sub-Contractor Name (currently 70.9%) | 829 | 28 Mar 2026 | Package Managers | Not Started |
| P3 — Medium | Populate UDF: Scope of Work Reference (currently 62.1%) | 1,079 | 28 Mar 2026 | Engineering | Not Started |
| P4 — Low | Populate UDF: Risk Register Link (currently 49.6%) | 1,435 | 30 Apr 2026 | Risk Manager | Not Started |
Data Quality Assessment Summary — 28 February 2026
- PMO mandate status: The schedule currently scores 71% against the PMO Data Quality target of 85%. At this submission, 5 of 9 required fields are below 100% — non-compliance with Schedule Management Plan Clause 5.1. The contractor has acknowledged the deficiencies and a remediation plan was submitted on 01 Mar 2026.
- Critical gap — Activity Codes: 340 activities are missing at least one required code. These activities account for 62% of all PMO reporting failures this period, as cross-WBS and discipline-level reports cannot be generated reliably for uncoded activities. The issue is concentrated in newly added activities from Change Directive CD-2025-44 (Track Upgrade Extension to Km 156).
- UDF shortfall is the largest single contributor to the below-target score. The Scope of Work Reference (62.1%) and Risk Register Link (49.6%) fields are significantly below target. The PM has committed to completing these fields as part of the next monthly update cycle.
- Positive indicators: Activity naming conventions are 95.3% compliant — a marked improvement from 82% at the previous audit. Permit Required flags are 95.3% populated. Milestones are 100% coded.
- Resubmission: A re-audit will be conducted on 28 Mar 2026. The contractor must achieve ≥85% overall quality score or the monthly payment certificate will be held pending compliance per Contract Clause 14.3(b).