¶ Basic Information
| Key | Value |
|---|---|
| Table | DS11 Variance |
| Severity | MAJOR |
| Unique ID | 9110489 |
| Summary | Is this PP-level VAR type as something other than PP in the WBS Dictionary? |
| Error message | narrative_type = 400 & DS01.type <> PP (by WBS_ID). |
¶ 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 DIQ check titled "PP-Level VAR Mistype In WBS Dictionary" is designed to ensure that the type of PP-level VAR (Variance) in the DS11 Variance table aligns with the type specified in the DS01 WBS (Work Breakdown Structure) Dictionary.
The error is likely to occur when the 'narrative_type' field in the DS11 Variance table is set to '400', but the corresponding 'type' field in the DS01 WBS Dictionary is not set to 'PP'. This discrepancy indicates a misalignment between the two tables, which could lead to inconsistencies in the data.
The expected values for these fields would be '400' for the 'narrative_type' in the DS11 Variance table and 'PP' for the 'type' in the DS01 WBS Dictionary. If these values do not match, it suggests that the PP-level VAR type has been incorrectly entered in the WBS Dictionary.
To resolve this issue, ensure that the 'type' field in the DS01 WBS Dictionary is correctly set to 'PP' whenever the 'narrative_type' in the DS11 Variance table is '400'. This will ensure data integrity and quality across the EVMS construction project management data.
¶ Why do we check this?
This test is being performed on the 'DS11 Variance' table to check for any discrepancies in the type of PP-level VAR in the WBS Dictionary. The test is looking for instances where the PP-level VAR type is listed as something other than 'PP'. This is done by comparing the 'narrative_type' and 'DS01.type' fields for each WBS_ID.
The importance of this check is to ensure consistency and accuracy in the data. If the PP-level VAR type is mislabeled, it could lead to confusion or errors during data analysis. This could potentially impact the accuracy of project management decisions based on this data.
The severity of this check is marked as 'MAJOR', which means that while it's not an immediate threat to the data's usability, it's likely to cause problems during analysis if not addressed. Therefore, it's recommended to correct this issue to maintain the integrity and quality of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS11_VAR_IsPPVARMisalignedWithDS01Type] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
V.*
FROM
DS11_variance V INNER JOIN DS01_WBS W ON V.WBS_ID = W.WBS_ID
WHERE
V.upload_ID = @upload_ID
AND W.upload_ID = @upload_ID
AND narrative_type = '400'
AND W.[type] <> 'PP'
)