| Key | Value |
|---|---|
| Table | DS00 Metadata |
| Severity | CRITICAL |
| Unique ID | 1000001 |
| Summary | Is the CPP Status Date missing from the period dates in the cost file? |
| Error message | DS00.CPP_Status_Date not in DS03.period_date list. |
This DIQ check ensures the CPP Status Date from the metadata (DS00) aligns with the cost reporting periods in DS03.
The check fails when:
This typically occurs due to:
The check compares DS00.CPP_status_date against all DS03.period_date values.
This test ensures the CPP Status Date (the date of data export) corresponds to an actual cost reporting period or is later than the last cost period. This validation is critical because:
As a CRITICAL check, this must be resolved before data can be uploaded to PARS. Without this alignment, cost and schedule analysis would be based on mismatched time periods.
CREATE FUNCTION [dbo].[fnDIQ_DS00_Meta_IsCPPMissingInDS03PeriodDate] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with Periods as (
SELECT cpp_status_date, period_date
FROM DS03_cost
WHERE upload_ID = @upload_ID
)
SELECT
*
FROM
DummyRow_Get(@upload_ID)
WHERE
(SELECT COUNT(*) FROM Periods WHERE period_date = CPP_status_date) = 0
AND (SELECT COUNT(*) FROM Periods WHERE cpp_status_date > (SELECT MAX(period_date) from periods)) = 0
)