| Key | Value |
|---|---|
| Table | DS02 OBS |
| Severity | CRITICAL |
| Unique ID | 1020050 |
| Summary | Is the Parent OBS ID missing in the OBS ID list? |
| Error message | Parent OBS ID not found in the OBS ID list. |
The Data Integrity and Quality (DIQ) check titled "Parent OBS ID Missing In OBS List" is designed to verify the consistency of the Organizational Breakdown Structure (OBS) in the DS02 OBS table.
The test checks if there are any instances where the Parent OBS ID does not exist in the list of OBS IDs. This could occur if a record was deleted from the OBS ID list but still referenced as a parent in another record, or if there was an error during data entry.
This test is being performed to ensure that every Parent OBS (Organizational Breakdown Structure) ID in the DS02 OBS table is also present in the OBS ID list. The OBS is a hierarchical, tree-structured view of a project's organization, and each element in the OBS can have a unique ID. The Parent OBS ID refers to the ID of the parent element in this hierarchy.
The importance of this check is to maintain the integrity of the hierarchical structure of the project's organization. If a Parent OBS ID is missing from the OBS ID list, it means there is a break in the hierarchy, which could lead to confusion and errors in project management and reporting.
The severity of this check is marked as 'CRITICAL', which is the highest level of severity. This means that if a Parent OBS ID is missing, it is a critical issue that must be fixed before the data can be reviewed or used for further analysis. This is because the integrity and accuracy of the project's organizational structure are crucial for effective project management and control.
CREATE FUNCTION [dbo].[fnDIQ_DS02_OBS_IsParentMissingFromOBSIDList] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
-- Insert statements for procedure here
SELECT
*
FROM
DS02_OBS
WHERE
upload_ID = @upload_ID
AND [external] = 'N'
AND parent_OBS_ID NOT IN (SELECT OBS_ID FROM DS02_OBS WHERE upload_ID=@upload_ID)
)