| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MAJOR |
| Unique ID | 9070351 |
| Summary | Is the stated CBB value in the IPMR header plus the cost Overrun equal to the PMB plus MR? |
| Error message | CBB_dollars <> PMB (DS03.DB + DS07.UB_bgt) + MR_bgt + MR_rpg - Overrun (Sum of DS03.BAC_rpg). |
This DIQ check verifies a fundamental EVMS equation: the Contract Budget Base (CBB) must equal the Performance Measurement Baseline (PMB) plus Management Reserve (MR) minus any overrun.
The formula is: CBB = PMB + MR - Overrun
Where:
The check fails when these components don't balance, which commonly occurs due to:
To resolve: Verify all budget components are current and that recent baseline changes, reprogramming actions, or MR transactions have been properly recorded in all affected fields.
This test validates one of the most fundamental EVMS relationships, ensuring the total contract value (CBB) properly accounts for all budget components.
This check is critical because:
Common root causes of misalignment:
As a MAJOR check, this indicates significant EVMS health issues that undermine confidence in cost reporting and require immediate investigation to maintain system credibility.
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsCBBNEqToPMBPlusMRMinusOverrun] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with Cost as (
SELECT SUM(BCWSi_dollars) DB, SUM(ISNULL(BAC_rpg,0)) Rpg
FROM DS03_cost
WHERE upload_ID = @upload_ID
)
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND CBB_dollars <> (SELECT DB FROM Cost) + ISNULL(UB_bgt_dollars,0) + --PMB
ISNULL(MR_bgt_dollars,0) + ISNULL(MR_rpg_dollars,0) - --MR
(SELECT Rpg FROM Cost) --overrun
)