| Key | Value |
|---|---|
| Table | DS01 WBS |
| Severity | MINOR |
| Unique ID | 1010040 |
| Summary | Is this WP/PP missing a WPM? |
| Error message | WPM missing or blank where type = WP/PP. |
This DIQ check flags Work Package (WP) and Planning Package (PP) WBS elements that have no Work Package Manager (WPM) assigned.
The check fails when, for the upload:
type is WP or PP, ANDWPM value is missing — NULL, empty, or only whitespaceThis typically occurs due to:
Only WP and PP rows are evaluated; other WBS element types are not expected to carry a WPM and are ignored.
This test ensures every work and planning package has an accountable manager. This validation is important because:
As a MINOR check, a missing WPM should be reviewed and corrected, but it does not block further data processing.
CREATE FUNCTION [dbo].[fnDIQ_DS01_WBS_IsWPMMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
/*
Flag WP/PP WBS elements without WPM
*/
SELECT
*
FROM
DS01_WBS
WHERE
upload_ID = @upload_ID
AND [type] IN ('WP', 'PP')
AND TRIM(ISNULL(WPM,'')) = ''
)