¶ Basic Information
| Key | Value |
|---|---|
| Table | DS12 Variance CAL |
| Severity | MAJOR |
| Unique ID | 1120499 |
| Summary | Is the original due date for this corrective action after the forecast due date? |
| Error message | original_due_date > forecast_due_date. |
¶ 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.
Test Title: Original Due Date After Forecast Due Date
Test Summary: This test checks if the original due date for a corrective action is set after the forecast due date in the DS12 Variance CAL table.
Error Message: Original Due Date is greater than Forecast Due Date.
Explanation: This error is likely to occur when the original due date for a corrective action is incorrectly entered as a date that is later than the forecast due date. The fields causing this issue are 'original_due_date' and 'forecast_due_date'.
The 'original_due_date' should ideally be a date that is earlier than or equal to the 'forecast_due_date'. If the 'original_due_date' is later than the 'forecast_due_date', it implies that the corrective action is planned to be completed after it was initially forecasted, which is a discrepancy.
To resolve this issue, please review and correct the dates in the 'original_due_date' and 'forecast_due_date' fields as necessary. Ensure that the 'original_due_date' is not set to a date later than the 'forecast_due_date'.
¶ Why do we check this?
This test is being performed on the 'DS12 Variance CAL' table to check if the original due date for a corrective action is after the forecast due date. The severity level is 'MAJOR', which implies that this issue could potentially cause problems during data analysis if not addressed.
The importance of this check lies in ensuring the accuracy and reliability of project scheduling and management. If the original due date is after the forecast due date, it could indicate a problem with the project planning or execution, such as delays or misestimations. This could potentially lead to inaccurate forecasting, project overruns, and inefficient resource allocation. Therefore, this check is crucial for maintaining the integrity and quality of the EVMS construction project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS12_VAR_CAL_IsOrigDateGtForecastDate] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS12_variance_CAL
WHERE
upload_ID = @upload_ID
AND original_due_date > forecast_due_date
)