¶ Basic Information
| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | MINOR |
| Unique ID | 1030089 |
| Summary | Is this Labor missing Performance Dollars, Hours, or FTEs? |
| Error message | EOC = Labor with BCWPi <> 0 for either Dollars, Hours, or FTEs, but where at least one other BCWPi = 0. |
¶ 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 "Labor Missing Performance" is designed to identify potential issues in the DS03 Cost table. Specifically, it looks for instances where labor costs have been recorded, but there is missing performance data in terms of dollars, hours, or full-time equivalents (FTEs).
The error is likely to occur when the 'EOC' field is marked as 'Labor', indicating that labor costs have been incurred, but at least one of the following fields: 'BCWPi_dollars', 'BCWPi_FTEs', or 'BCWPi_hours' is recorded as zero. This suggests that while labor costs have been recorded, the corresponding performance data is missing or incomplete.
The expected values for the 'BCWPi_dollars', 'BCWPi_FTEs', and 'BCWPi_hours' fields should be greater than zero when the 'EOC' field is marked as 'Labor'. If any of these fields are zero, it indicates a potential data integrity issue that should be investigated and corrected to ensure accurate project management data.
¶ Why do we check this?
This test is being performed on the 'DS03 Cost' table to check for any instances where labor is missing performance in terms of dollars, hours, or full-time equivalents (FTEs). The test is looking for any end of contract (EOC) labor entries that have a non-zero budgeted cost of work performed index (BCWPi) for either dollars, hours, or FTEs, but where at least one other BCWPi is zero.
The importance of this check is to ensure that all labor costs are accurately accounted for in the project management data. If there are missing performance metrics, it could lead to inaccurate cost projections and budgeting issues. This could potentially cause problems during the analysis of the data, hence the severity of this check is marked as an 'MINOR'. While it may not prevent the data from being reviewed, it indicates that there might be minor problems or that the data doesn't follow all best practices.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_IsLaborMissingBCWPDollarsHoursOrFTEs] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS03_Cost
WHERE
upload_ID = @upload_ID
AND EOC = 'Labor'
AND ISNULL(is_indirect,'') <> 'Y'
AND (BCWPi_dollars <> 0 OR BCWPi_FTEs <> 0 OR BCWPi_hours <> 0)
AND (BCWPi_dollars = 0 OR BCWPi_FTEs = 0 OR BCWPi_hours = 0)
)
¶ Changelog
| Date | Description of Changes |
|---|---|
| 2024-04-30 | Logic adjusted to exclude records where is_indirect is 'Y'. |