¶ Basic Information
| Key | Value |
|---|---|
| Table | DS04 Schedule |
| Severity | MAJOR |
| Unique ID | 1040150 |
| Summary | Is your baseline schedule missing the CD-0 milestone? |
| Error message | No row found for CD-0 milestone (milestone_level = 110) in baseline schedule (schedule_type = BL). |
¶ 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 "CD-0 Milestone Missing in Baseline" is designed to verify the presence of the CD-0 milestone in the baseline schedule of the DS04 Schedule table.
The CD-0 milestone is a critical project milestone that signifies the approval of mission need. It is represented by a milestone level of 110 in the data. The baseline schedule is denoted by the schedule type 'BL'.
If the DIQ check returns an error message stating "No row found for CD-0 milestone (milestone_level = 110) in baseline schedule (schedule_type = BL)", it indicates that the CD-0 milestone is missing from the baseline schedule in the DS04 Schedule table.
This error is likely caused by either an omission in data entry or a mistake in data import. The fields causing the issue are the 'milestone_level' and 'schedule_type'. The expected values for these fields are 110 and 'BL' respectively.
To resolve this issue, ensure that the CD-0 milestone is included in the baseline schedule with the correct milestone level and schedule type.
¶ Why do we check this?
This test is being performed to check if the baseline schedule in the DS04 Schedule table is missing the CD-0 milestone. The CD-0 milestone, also known as the "Approve Mission Need" milestone, is a critical part of the project lifecycle in the Department of Energy. It signifies the formal approval to explore alternative concepts and technologies and to define the project requirements before proceeding with the project.
The severity of this test is marked as a MAJOR. This means that while the absence of the CD-0 milestone in the baseline schedule may not immediately prevent the data from being reviewed, it is likely to cause problems during the analysis of the project's progress and performance. It could lead to inaccurate project timelines, cost estimates, and resource allocation.
The importance of this check lies in ensuring the completeness and accuracy of the project schedule data. It helps in maintaining the integrity of the project management data by ensuring that all critical milestones are included in the baseline schedule. This, in turn, aids in effective project planning, monitoring, and control.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS04_Sched_IsCD0MissingInBL] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT *
FROM DummyRow_Get(@upload_ID)
WHERE
(SELECT COUNT(*) FROM DS04_schedule WHERE upload_ID = @upload_ID AND schedule_type = 'BL' AND milestone_level = 110) = 0
)