¶ Basic Information
| Key | Value |
|---|---|
| Table | DS01 WBS |
| Severity | MAJOR |
| Unique ID | 1010035 |
| Summary | Is the WPM name attached to a WBS, CA, or SLPP? |
| Error message | WPM name found for WBS, CA, or SLPP (WP or PP only) |
¶ 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 "WPM Name Found on WBS, CA, or SLPP" is designed to verify the association of the Work Package Manager (WPM) name with a Work Breakdown Structure (WBS), Control Account (CA), or Summary Level Planning Package (SLPP). This check is performed on the DS01 WBS table.
The DIQ check is looking for instances where a WPM name is present, but the associated type is neither a Work Package (WP) nor a Planning Package (PP). The 'type' field should only contain 'WP' or 'PP' when a WPM name is attached. If the 'type' field contains any other value, this would be flagged as an error by the DIQ check.
The likely cause of this error would be incorrect data entry, where a WPM name has been associated with a type other than 'WP' or 'PP'. To resolve this issue, ensure that the 'type' field only contains 'WP' or 'PP' when a WPM name is present.
¶ Why do we check this?
This test is being performed to ensure that the Work Package Manager (WPM) name is correctly associated with a Work Breakdown Structure (WBS), Control Account (CA), or Summary Level Planning Package (SLPP). The test is checking if the WPM name is found for WBS, CA, or SLPP, which should only be associated with a Work Package (WP) or Planning Package (PP).
The importance of this check is to maintain the accuracy and consistency of the project management data. If the WPM name is incorrectly associated, it could lead to confusion, miscommunication, or errors in project management and execution. This could potentially impact the project's timeline, budget, or resource allocation.
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 recommended to correct this issue to ensure the integrity and quality of the EVMS construction project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS01_WBS_IsWPMFoundOnNonPPorWP] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS01_WBS
WHERE
upload_ID = @upload_ID
AND ISNULL(WPM,'') <> ''
AND type NOT IN ('WP','PP')
)