¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070373 |
| Summary | Is the unfavorable schedule cum dollar threshold equal to zero? |
| Error message | threshold_schedule_cum_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 Schedule Cum Dollar Threshold" is performed on the DS07 IPMR Header table. This check is designed to verify whether the unfavorable schedule cumulative dollar threshold is equal to zero.
If an error is flagged by this DIQ check, it indicates that the 'threshold_schedule_cum_dollar_unfav' field in the DS07 IPMR Header table has a value of zero. This field represents the cumulative dollar threshold for unfavorable schedule variances. A zero value in this field may suggest that no threshold has been set for unfavorable schedule variances, which could potentially lead to oversight of significant schedule deviations.
The expected value for the 'threshold_schedule_cum_dollar_unfav' field should ideally be a positive number, representing a defined threshold for unfavorable schedule variances. If the value is zero, it may require review and correction to ensure accurate project management and reporting.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the unfavorable schedule cumulative dollar threshold is equal to zero. The test is important because it ensures that the data in the 'threshold_schedule_cum_dollar_unfav' field is accurate and meaningful.
The severity of this test is marked as 'MINOR', which is less severe but indicates that there might be minor problems or that the data doesn't follow all best practices. If the unfavorable schedule cumulative dollar threshold is indeed zero, it might not necessarily halt the data review process, but it could potentially cause issues during analysis. For instance, it could indicate a lack of budgeting for unfavorable schedule scenarios, which could lead to inaccurate project cost forecasting and management. Therefore, it's important to address this alert to ensure the integrity and quality of the EVMS construction project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdScheduleCumDollarUnFavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_Schedule_cum_dollar_unfav,0) = 0
)