| Key | Value |
|---|---|
| Table | DS02 OBS |
| Severity | CRITICAL |
| Unique ID | 1020045 |
| Summary | Is the OBS ID repeated across the OBS hierarchy? |
| Error message | OBS ID is not unique across the OBS hierarchy. |
The Data Integrity and Quality (DIQ) check titled "OBS ID Not Unique" is designed to ensure that each Organizational Breakdown Structure (OBS) ID in the DS02 OBS table is unique across the OBS hierarchy.
The error message "OBS ID is not unique across the OBS hierarchy" indicates that there are duplicate OBS IDs present in the DS02 OBS table. This is likely caused by data entry errors or system issues that have allowed the same OBS ID to be used for more than one entry in the OBS hierarchy.
This test is being performed to ensure that the Organizational Breakdown Structure (OBS) ID is unique across the OBS hierarchy in the DS02 OBS table. The OBS ID is a critical identifier used to organize and manage different parts of the project, and if it is not unique, it could lead to confusion, misinterpretation of data, and errors in project management and reporting.
The severity of this test is marked as 'CRITICAL', which is the highest level of severity. This means that if the OBS ID is not unique, it is a critical issue that must be fixed before the data can be reviewed or used for further analysis. This check is important because it ensures the integrity and reliability of the project management data. Without unique OBS IDs, it would be impossible to accurately track and manage different aspects of the project, which could lead to significant issues in project execution and reporting.
CREATE FUNCTION [dbo].[fnDIQ_DS02_OBS_PK] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
-- Insert statements for procedure here
SELECT
*
FROM
DS02_OBS
WHERE
upload_ID = @upload_ID
AND OBS_ID IN (
SELECT OBS_ID
FROM DS02_OBS
WHERE upload_ID = @upload_ID
GROUP BY OBS_ID
HAVING COUNT(OBS_ID) > 1
)
)