¶ Basic Information
| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | MAJOR |
| Unique ID | 1030064 |
| Summary | Are there estimates still showing in previous periods? |
| Error message | ETCi <> 0 (Dollars, Hours, or FTEs) where period_date <= CPP_Status_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.
The Data Integrity and Quality (DIQ) check titled "Estimates in the Past" is designed to identify any estimates that are still appearing in previous periods within the DS03 Cost table. This check is crucial to ensure the accuracy and reliability of the project management data.
The error is likely to occur when the fields ETCi (Estimate to Complete) in dollars, hours, or FTEs (Full-Time Equivalents) are not zero for periods that are on or before the CPP (Current Period Performance) status date. In other words, if there are any remaining estimates in periods that have already passed, this would trigger the DIQ check.
The expected values for the ETCi fields should be zero for all periods on or before the CPP status date. This is because once a period has passed, there should be no remaining estimates for that period. If the ETCi fields are not zero, this could indicate that the estimates were not updated or closed out properly in the system.
In summary, this DIQ check is important for maintaining the integrity of the project management data by ensuring that all estimates are properly accounted for in the correct periods.
¶ Why do we check this?
This test is being performed to check if there are any estimates still showing in previous periods in the 'DS03 Cost' table. The test is looking for any instances where the Estimated Time to Completion (ETCi) is not equal to zero when the period date is less than or equal to the Current Period Performance Status Date.
The importance of this check is to ensure that all estimates are updated and accurate. If there are estimates still showing in previous periods, it could indicate that the data is not being updated correctly or in a timely manner. This could lead to inaccurate reporting and analysis, which could impact decision-making and project management.
The severity of this check is marked as 'MAJOR', which means that while it may not prevent the data from being reviewed, it is likely to cause problems during analysis. Therefore, it is important to address this issue to ensure the integrity and quality of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_DoesETCExistInThePast] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS03_Cost
WHERE
upload_ID = @upload_ID
AND (ETCi_dollars <> 0 OR ETCi_FTEs <> 0 OR ETCi_hours <> 0)
AND period_date <= CPP_status_date
)