¶ Basic Information
| Key | Value |
|---|---|
| Table | DS08 WAD |
| Severity | MAJOR |
| Unique ID | 9080622 |
| Summary | Is this WP WBS ID missing in the WBS dictionary? |
| Error message | WBS_ID_WP not in DS01.WBS_ID list. |
¶ 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 "WP WBS ID Missing in WBS Dictionary" is designed to verify the presence of Work Package (WP) Work Breakdown Structure (WBS) IDs in the WBS dictionary. This check is performed on the DS08 Work Authorization Document (WAD) table.
The error message "WBS_ID_WP not in DS01.WBS_ID list" indicates that there are instances where the WP WBS ID from the DS08 WAD table is not found in the list of WBS IDs in the DS01 WBS Dictionary table. This discrepancy could be due to missing entries in the WBS dictionary or incorrect WP WBS IDs in the DS08 WAD table.
The fields causing this issue are the 'WBS_ID_WP' field in the DS08 WAD table and the 'WBS_ID' field in the DS01 WBS Dictionary table. The expected values for the 'WBS_ID_WP' field in the DS08 WAD table should match the values in the 'WBS_ID' field in the DS01 WBS Dictionary table.
To resolve this issue, ensure that all WP WBS IDs in the DS08 WAD table have corresponding entries in the DS01 WBS Dictionary table. This will ensure consistency and accuracy of the WBS IDs across the project management data.
¶ Why do we check this?
This test is being performed to check if the Work Package (WP) Work Breakdown Structure (WBS) ID is missing in the WBS dictionary. The WBS dictionary is a crucial component of the project management system as it provides detailed information about each component of the WBS, including tasks, deliverables, and milestones.
The test is important because if the WP WBS ID is missing, it could lead to confusion, miscommunication, or errors in project management and execution. It could also make it difficult to track the progress of specific tasks or deliverables, which could impact the overall project timeline and budget.
The severity of this test is marked as a MAJOR. This means that while the issue is not critical and the data can still be reviewed, it is likely to cause problems during analysis. It is recommended to address this issue to ensure accurate and efficient project management and data analysis.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS08_WAD_IsWPWBSMissingInDS01] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS08_WAD
WHERE
upload_ID = @upload_ID
AND auth_PM_date IS NOT NULL
AND WBS_ID_WP NOT IN (SELECT WBS_ID FROM DS01_WBS WHERE upload_ID = @upload_ID)
)