¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070366 |
| Summary | Is the favorable cost inc dollar threshold equal to zero? |
| Error message | threshold_cost_inc_dollar_fav = 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 Favorable Cost Inc Dollar Threshold" is performed on the DS07 IPMR Header table. This check is designed to verify the integrity of the data in the 'threshold_cost_inc_dollar_fav' field.
The purpose of this check is to ensure that the 'Favorable Cost Inc Dollar Threshold' is not equal to zero. If the value in this field is zero, it indicates that there may be an error or omission in the data entry process.
The 'Favorable Cost Inc Dollar Threshold' field should ideally contain a positive value, representing the dollar threshold for cost increases that are considered favorable. A zero value in this field could potentially distort the project's financial analysis and projections.
If this DIQ check returns any records, it means that there are instances where the 'Favorable Cost Inc Dollar Threshold' is equal to zero. In such cases, the data in the 'threshold_cost_inc_dollar_fav' field should be reviewed and corrected as necessary to ensure the accuracy and reliability of the project management data.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the favorable cost inc dollar threshold is equal to zero. The test is important because it ensures that the data in the 'threshold_cost_inc_dollar_fav' field is accurate and meaningful. If the threshold is zero, it may indicate that there are no favorable cost increments, which could potentially skew the project's financial analysis.
The severity of this test is marked as an 'MINOR', which means it's not a critical issue that would prevent the data from being reviewed, but it's still important to address. If left unchecked, it could lead to minor problems in the data analysis or indicate that the data doesn't follow all best practices. Therefore, it's recommended to review and correct this issue to ensure the integrity and quality of the EVMS construction project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdCostIncDollarFavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_cost_Inc_Dollar_Fav,0) = 0
)