| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | MINOR |
| Unique ID | 1030081 |
| Summary | Is this WP or PP missing budget? |
| Error message | WP or PP found with BCWSi = 0 (on Dollars, or Hours / FTEs where EOC = Labor). |
This DIQ check identifies Work Packages (WPs) or Planning Packages (PPs) that have no budget allocated, which violates EVMS principles requiring all authorized work to be budgeted.
The check triggers when:
The check excludes:
In a properly functioning EVMS, zero budget work packages should not exist because:
Common causes of this issue:
To resolve: Ensure budget has been properly distributed to all WPs and PPs. If work is being performed, it must have authorized budget. Zero budget work packages cannot properly measure performance and may result in EVMS compliance issues.
This test identifies violations of the fundamental EVMS principle that all authorized work must have budget.
Why zero budget work packages are problematic:
While this is technically a significant EVMS violation, it's flagged as MINOR because:
However, for current and future work packages, having zero budget represents a real problem that should be addressed to maintain EVMS integrity and enable proper project control.
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_IsBCWSMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS03_Cost
WHERE
upload_ID = @upload_ID
AND (
BCWSi_dollars = 0 OR
(EOC = 'Labor' AND ISNULL(is_indirect,'') <> 'Y' AND (BCWSi_FTEs = 0 OR BCWSi_hours = 0))
)
AND NOT (is_indirect = 'Y' AND EOC = 'Indirect' AND ACWPi_dollars > 0)
AND TRIM(ISNULL(WBS_ID_WP,'')) <> ''
)
| Date | Description of Changes |
|---|---|
| 2024-04-30 | Logic adjusted to account for 'is_indirect' field, which is used to exclude is_indirect = Y. All cases where is_indirect = 'Y' are treated as indirect data. Logic also adjusted to exclude records with empty WBS_ID_WP fields (non-WP/PP data). |