¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070377 |
| Summary | Is the unfavorable schedule inc dollar threshold equal to zero? |
| Error message | threshold_schedule_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 Schedule Inc Dollar Threshold" is designed to verify the integrity of data in the DS07 IPMR Header table. This check specifically focuses on the 'threshold_schedule_inc_Dollar_unfav' field.
The purpose of this check is to ensure that the 'threshold_schedule_inc_Dollar_unfav' field is not equal to zero. This field represents the unfavorable schedule increase dollar threshold, and a value of zero may indicate a data entry error or a lack of necessary information.
If this DIQ check fails, it means that the 'threshold_schedule_inc_Dollar_unfav' field in the DS07 IPMR Header table contains a value of zero. This is not expected, as the unfavorable schedule increase dollar threshold should typically be a positive value.
To resolve this issue, you should review the data entry process for the 'threshold_schedule_inc_Dollar_unfav' field to ensure that it is being correctly populated. If the value is indeed zero, it may be necessary to review the project's schedule and budget to determine the correct threshold value.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the 'unfavorable schedule inc dollar threshold' is equal to zero. The severity of this test is marked as an 'MINOR', which means it is not a critical issue but could potentially cause minor problems or indicate that the data does not adhere to all best practices.
The importance of this check lies in ensuring the accuracy and reliability of the data. In the context of EVMS (Earned Value Management System) construction project management, the 'unfavorable schedule inc dollar threshold' is a key parameter that should not be zero. If it is zero, it could imply that there are no provisions for unfavorable schedule increments in the budget, which is not a realistic scenario for project management. Therefore, this check helps to identify any potential inaccuracies or inconsistencies in the data that could affect subsequent data analysis and decision-making processes.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdScheduleIncDollarUnfavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_Schedule_Inc_Dollar_unfav,0) = 0
)