| Key | Value |
|---|---|
| Table | DS01 WBS |
| Severity | MAJOR |
| Unique ID | 1010019 |
| Summary | Is the external WBS missing a subproject ID? |
| Error message | External = Y & subproject_ID is missing or blank. |
The Data Integrity and Quality (DIQ) check titled "External WBS Without Subproject ID" is designed to identify any instances in the DS01 WBS table where an external Work Breakdown Structure (WBS) is missing a subproject ID.
This DIQ check is triggered when a WBS is marked as 'external' (i.e., the 'external' field is set to 'Y'), but the 'subproject_ID' field is either missing or blank. This could be due to a data entry error, or a problem with the process used to import or generate the data.
To resolve this issue, ensure that each external WBS in the DS01 WBS table is associated with a valid subproject ID. If a subproject ID is missing or blank, it should be added or corrected as necessary.
This test is being performed to ensure that all external Work Breakdown Structures (WBS) in the DS01 WBS table have a corresponding subproject ID. The Work Breakdown Structure is a key project deliverable that organizes the team's work into manageable sections and WBS elements external to the project WBS are associated with a subproject ID.
The test is checking for instances where the WBS is marked as external (External = Y) but the subproject_ID field is missing or blank. This is important because without a subproject ID, it can be difficult to track and manage the specific tasks, resources, and costs associated with that part of the project.
The severity of this check is marked as a MAJOR. This means that while the data can still be reviewed, the absence of subproject IDs for external WBS could cause problems during analysis. It could lead to confusion, misallocation of resources, or inaccuracies in project tracking and reporting. Therefore, it is recommended to address this issue to ensure data integrity and quality.
CREATE FUNCTION [dbo].[fnDIQ_DS01_WBS_IsExternalMissingSubprojectID] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS01_WBS
WHERE
upload_ID = @upload_ID
AND [external] = 'Y'
AND TRIM(ISNULL(subproject_ID, '')) = ''
)