| 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). |
This DIQ check verifies that the CD-0 (Approve Mission Need) milestone is present in the baseline schedule.
CD-0 is a mandatory federal milestone per DOE Order 413.3B. All PARS projects have approved CD-0 dates before uploading schedules. This milestone is identified by milestone_level = 110.
The absence of this required milestone indicates:
This is NOT a case where the milestone is optional or unknown - all PARS projects have this date approved by DOE.
To resolve: Add the CD-0 milestone to your schedule with milestone_level = 110, using the approved date from your project's CD documentation.
This test verifies that mandatory federal milestones are properly integrated into contractor schedules.
Per DOE Order 413.3B, all CD milestones are required for every PARS project. The absence of these milestones represents a significant disconnect between federal oversight and contractor project management.
Why this matters:
The fact that these milestones are missing despite being mandatory and already approved indicates a systemic issue with how contractors integrate federal requirements into their project schedules.
As a MAJOR check, we allow data submission while flagging this significant issue. However, projects should prioritize adding all federal milestones to maintain proper alignment with DOE oversight requirements.
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
)