¶ Basic Information
| Key | Value |
|---|---|
| Table | DS08 WAD |
| Severity | MAJOR |
| Unique ID | 9080409 |
| Summary | Is the EVT for this WP/PP-level WAD misaligned with what is in cost? |
| Error message | EVT <> DS03.EVT (by WBS_ID_WP). |
¶ 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 "EVT Misaligned with Cost" is designed to ensure that the Earned Value Technique (EVT) for each Work Package (WP) or Planning Package (PP) level Work Authorization Document (WAD) in DS08 aligns with the corresponding EVT in DS03 cost data.
The test compares the EVT values in DS08 WAD and DS03 cost data for each WP/PP identified by the WBS_ID_WP field. If the EVT values do not match, the test flags an error.
The likely cause of this error is a discrepancy in the EVT data entry between the DS08 WAD and DS03 cost data. This could be due to a data entry error, a change in the EVT that was not updated in both datasets, or a mismatch in the WBS_ID_WP identifiers used in the two datasets.
To resolve this error, you should ensure that the EVT for each WP/PP in DS08 WAD matches the EVT in DS03 cost data. Also, verify that the WBS_ID_WP identifiers are consistent across both datasets.
¶ Why do we check this?
This test is being performed to ensure that the Earned Value Technique (EVT) for a particular Work Package (WP) or Planning Package (PP) level Work Authorization Document (WAD) is aligned with the cost data. The EVT is a measure used in project management to track the performance and progress of a project and it should be consistent with the cost data for accurate project tracking and forecasting.
The importance of this check is to ensure that the project's performance is being accurately measured and reported. If the EVT is misaligned with the cost, it could lead to inaccurate project performance reports, which could in turn lead to poor decision making. This could potentially lead to cost overruns, delays, and other project management issues.
The severity of this check is marked as a MAJOR. This means that while it may not immediately prevent the data from being reviewed, it is likely to cause problems during analysis if not addressed. It is therefore important to correct this misalignment to ensure accurate and reliable project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS08_WAD_IsEVTMisalignedWithDS03] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with CostEVT as (
SELECT WBS_ID_WP, EVT
FROM DS03_cost
WHERE upload_ID = @upload_ID
GROUP BY WBS_ID_WP, EVT
)
SELECT
W.*
FROM
DS08_WAD W INNER JOIN CostEVT C ON W.WBS_ID_WP = C.WBS_ID_WP
AND W.EVT <> C.EVT
WHERE
W.upload_ID = @upload_ID
AND TRIM(ISNULL(W.WBS_ID_WP,'')) <> ''
)