| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | MAJOR |
| Unique ID | 1030079 |
| Summary | Does this WP or PP have negative performance? |
| Error message | WP or PP found with BCWPi < 0 (Dollars, Hours, or FTEs). |
This DIQ check identifies Work Packages (WP) or Planning Packages (PP) with negative period performance values (BCWPi), which may indicate errors or legitimate retroactive adjustments.
The check fails when any BCWPi field is negative:
While you cannot "unaccomplish" work, negative period values can legitimately occur for:
Common problematic causes:
Note: This check excludes Summary Level Planning Packages (SLPPs).
To resolve: Verify negative values have proper authorization and documentation. Check Format 3 and Format 5 for adjustment explanations. Ensure cumulative BCWP remains positive.
This test alerts to negative period performance values which may indicate unauthorized changes or legitimate earned value adjustments requiring review.
Why we monitor negative BCWP:
Legitimate negative period values occur when:
Red flags include:
As a MAJOR check, this flags values requiring investigation. Properly authorized adjustments with documentation can proceed, while unauthorized changes or data errors must be corrected.
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_IsBCWPLessThanZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS03_Cost
WHERE
upload_ID = @upload_ID
AND TRIM(ISNULL(WBS_ID_WP,'')) <> ''
AND (BCWPi_dollars < 0 OR BCWPi_FTEs < 0 OR BCWPi_hours < 0)
)