| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | MAJOR |
| Unique ID | 1030080 |
| Summary | Does this WP or PP have negative budget? |
| Error message | WP or PP found with BCWSi < 0 (Dollars, Hours, or FTEs). |
This DIQ check identifies cost records with negative period budget values (BCWSi), which may indicate errors or legitimate retroactive adjustments.
The check fails when any BCWSi field is negative:
While you cannot authorize "negative work," negative period values can legitimately occur for:
Common problematic causes:
To resolve: Verify negative values have proper authorization and documentation (BCRs, change logs). Check Format 3 and Format 5 for baseline change explanations. Ensure cumulative BCWS remains positive.
This test alerts to negative period budget values which may indicate unauthorized changes or legitimate baseline adjustments requiring review.
Why we monitor negative budgets:
Legitimate negative period values occur during:
Red flags include:
As a MAJOR check, this flags values requiring investigation. Properly documented adjustments can proceed, while unauthorized changes must be corrected.
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_IsBCWSLessThanZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS03_Cost
WHERE
upload_ID = @upload_ID
AND (BCWSi_dollars < 0 OR BCWSi_FTEs < 0 OR BCWSi_hours < 0)
)