¶ Basic Information
| Key | Value |
|---|---|
| Table | DS01 WBS |
| Severity | MINOR |
| Unique ID | 1010010 |
| Summary | Is the WPM name the same as the CAM name? |
| Error message | WPM name is the same as the CAM name for this WBS |
¶ 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 Matches CAM" is designed to ensure that the Work Package Manager (WPM) name is the same as the Control Account Manager (CAM) name in the DS01 Work Breakdown Structure (WBS) table.
If an error is flagged by this DIQ check, it indicates that there is a discrepancy between the WPM and CAM names for a particular Work Breakdown Structure. This could be due to a data entry error or a change in personnel that has not been updated in the system.
The fields causing the issue are the WPM and CAM fields in the DS01 WBS table. The expected values for these fields should be identical. If they are not, it suggests that the WPM and CAM names have not been correctly entered or updated.
To resolve this issue, review the WPM and CAM names in the DS01 WBS table and ensure they match. If they do not, correct the discrepancy and re-run the DIQ check.
¶ Why do we check this?
This test is being performed to check if the Work Package Manager (WPM) name is the same as the Control Account Manager (CAM) name for a particular Work Breakdown Structure (WBS) in the DS01 WBS table. The severity level is an MINOR, which means it's not a critical issue but it might cause minor problems or it indicates that the data doesn't follow all best practices.
The importance of this check is to ensure that there is a clear distinction between the roles of the WPM and the CAM. If the names are the same, it could imply that the same person is handling both roles, which might not be ideal for project management. This could lead to potential conflicts of interest, overloading of responsibilities, or lack of checks and balances. Therefore, this test helps to maintain the integrity and quality of the project management data by ensuring that roles and responsibilities are properly assigned and recorded.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS01_WBS_DoesWPMMatchCAM] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS01_WBS
WHERE
upload_ID = @upload_ID
AND WPM = CAM
AND ISNULL(WPM,'') <> ''
)