¶ Basic Information
| 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). |
¶ What causes this error?
The following text was generated by an AI tool and hasn't been reviewed for accuracy by a human! It might be useful, but it also might have errors. Are you a human? You can help by reviewing it for accuracy! Edit it as needed then remove this message.
The Data Integrity and Quality (DIQ) check titled "Budget Missing" is designed to identify any Work Packages (WP) or Planning Packages (PP) in the DS03 Cost table that are missing budget information. This is determined by checking if the BCWSi (Budgeted Cost of Work Scheduled) in dollars is zero, or if the EOC (Element of Cost) is labeled as 'Labor' and either the BCWSi in Full-Time Equivalents (FTEs) or hours is zero.
If the DIQ check identifies any WP or PP with these conditions, it means that there is missing budget information for these packages. This could be due to an error in data entry or a lack of budget allocation for these packages.
The expected values for the BCWSi fields should be greater than zero to indicate that a budget has been allocated. For the EOC field, if it is labeled as 'Labor', then the BCWSi in FTEs or hours should also be greater than zero.
The DIQ check groups the results by the WBS_ID_WP field, which represents the Work Breakdown Structure ID for the Work Package. This allows for easy identification of the specific packages that are missing budget information.
¶ Why do we check this?
This test is being performed to check if there are any Work Packages (WP) or Planning Packages (PP) in the 'DS03 Cost' table that are missing budget information. The test identifies any instances where the Budgeted Cost of Work Scheduled (BCWSi) is equal to zero, either in terms of dollars or hours/FTEs where the Element of Cost (EOC) is labor.
The importance of this check is to ensure that all work or planning packages have an allocated budget. Without this, it would be impossible to track costs and evaluate the financial performance of the project. This is flagged as an MINOR, indicating that while it's not a critical error, it's a deviation from best practices and could potentially cause minor problems in data analysis or project management.
¶ Code
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,'')) <> ''
)
¶ Changelog
| 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). |