¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070367 |
| Summary | Is the unfavorable cost inc dollar threshold equal to zero? |
| Error message | threshold_cost_inc_Dollar_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 Inc Dollar Threshold" is performed on the DS07 IPMR Header table. This check is designed to verify whether the unfavorable cost increase dollar threshold is equal to zero.
If an error is flagged by this DIQ check, it indicates that the 'threshold_cost_inc_Dollar_unfav' field in the DS07 IPMR Header table has a value of zero. This field represents the threshold for unfavorable cost increases in dollars. A zero value in this field may suggest that no threshold has been set for unfavorable cost increases, which could potentially lead to uncontrolled cost escalations in the project.
The expected value for the 'threshold_cost_inc_Dollar_unfav' field should ideally be a positive number, representing a defined threshold for unfavorable cost increases. A zero value in this field is likely to be an error and should be reviewed and corrected as necessary.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the 'unfavorable cost inc dollar threshold' is equal to zero. The purpose of this test is to ensure that the data in this field is accurate and meaningful. If the threshold is zero, it could indicate that there is a problem with the data entry or calculation, as it is unlikely that a project would have no unfavorable cost increase threshold.
The severity of this test is marked as an 'MINOR', which means it is not a critical issue that would prevent the data from being reviewed, but it could potentially cause minor problems or indicate that the data does not follow all best practices. It is important to address this alert to ensure the accuracy and reliability of the project management data, as it could impact the understanding and analysis of the project's financial performance.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdCostIncDollarUnfavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_cost_Inc_Dollar_unfav,0) = 0
)