¶ Basic Information
| Key | Value |
|---|---|
| Table | DS04 Schedule |
| Severity | MINOR |
| Unique ID | 1040228 |
| Summary | Has a BCP occurred without reprogramming tasks? (FC) |
| Error message | BCP milestone(s) found (milestone_level = 131 - 135) without accompanying RPG tasks (RPG = Y). (FC) |
¶ 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 "BCP Milestones Without Reprogramming" is designed to identify instances in the DS04 Schedule table where a Baseline Change Proposal (BCP) has occurred without corresponding reprogramming tasks.
The error message "BCP milestone(s) found (milestone_level = 131 - 135) without accompanying RPG tasks (RPG = Y)" indicates that there are BCP milestones (with milestone levels between 131 and 135) that do not have associated reprogramming tasks (where RPG = 'Y') in the schedule type 'FC'.
This discrepancy could be due to a variety of reasons such as data entry errors, missing data, or a BCP being approved without the necessary reprogramming tasks being assigned.
To resolve this issue, you should ensure that every BCP milestone in the 'FC' schedule type has an associated reprogramming task. This means that for every BCP milestone (milestone level between 131 and 135), there should be a corresponding entry where RPG = 'Y'.
If you find BCP milestones without corresponding reprogramming tasks, you should investigate the cause and correct the data as necessary. This could involve adding the missing reprogramming tasks or correcting any data entry errors.
By ensuring that all BCP milestones have associated reprogramming tasks, you can maintain the integrity and quality of the data in the DS04 Schedule table.
¶ Why do we check this?
This test is being performed on the 'DS04 Schedule' table to check for instances where a Baseline Change Proposal (BCP) has occurred without corresponding reprogramming tasks. The test is looking for BCP milestones (milestone_level = 131 - 135) that do not have accompanying RPG tasks (RPG = Y).
The importance of this check is to ensure that any changes to the baseline (BCP) are properly accounted for with reprogramming tasks. This is crucial for maintaining accurate and reliable project management data. If a BCP occurs without reprogramming tasks, it could lead to inconsistencies and inaccuracies in the data, which could in turn affect project planning and decision-making.
The severity of this check is classified as an MINOR. This means that while it may not immediately prevent the data from being reviewed, it could potentially cause minor problems or indicate that the data does not fully adhere to best practices. Therefore, it is recommended to address this issue to maintain the highest quality and integrity of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS04_Sched_DoesBCPExistWithoutRPGFC] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with BCPCount as (
SELECT COUNT(*) BCPcnt
FROM DS04_schedule
WHERE upload_ID = @upload_ID AND milestone_level BETWEEN 131 AND 135 AND schedule_type = 'FC'
), RPGCount as (
SELECT COUNT(*) RPGcnt
FROM DS04_schedule
WHERE upload_ID = @upload_ID AND RPG = 'Y' AND schedule_type = 'FC'
)
SELECT
*
FROM
DummyRow_Get(@upload_ID)
WHERE
(SELECT TOP 1 BCPcnt FROM BCPCount) > 0
AND (SELECT TOP 1 RPGcnt FROM RPGCount) = 0
)