¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070365 |
| Summary | Is the unfavorable cost cum percent threshold equal to zero? |
| Error message | threshold_cost_cum_pct_unfav = 0. |
¶ 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 "Zero Unfavorable Cost Cum Percent Threshold" is designed to verify the integrity of data in the DS07 IPMR Header table. This check specifically focuses on the 'threshold_cost_cum_pct_unfav' field.
The purpose of this check is to ensure that the 'threshold_cost_cum_pct_unfav' field is not equal to zero. This field represents the unfavorable cost cumulative percentage threshold. A value of zero in this field may indicate a data entry error or a calculation error in the project management system.
If the DIQ check identifies records where 'threshold_cost_cum_pct_unfav' is equal to zero, it means that the unfavorable cost cumulative percentage threshold has been set to zero. This is not expected in normal project management scenarios as it would imply that any cost, no matter how small, is considered unfavorable.
To resolve this issue, review the data entry or calculation processes for the 'threshold_cost_cum_pct_unfav' field. Ensure that the values entered are accurate and reflect the true unfavorable cost cumulative percentage threshold for each project.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the unfavorable cost cumulative percentage threshold is equal to zero. The severity level of this test is 'MINOR', which means it's not a critical issue but it might cause minor problems or indicate that the data doesn't follow all best practices.
The importance of this check is to ensure that the unfavorable cost cumulative percentage threshold is not zero. If it is zero, it could mean that there is no threshold set for unfavorable costs, which could potentially lead to financial risks or mismanagement. This check helps to maintain the integrity and quality of the financial data in the EVMS construction project management data at the US Department of Energy.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdCostCumPctUnFavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_cost_cum_pct_unfav,0) = 0
)