¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070378 |
| Summary | Is the favorable schedule inc percent threshold equal to zero? |
| Error message | threshold_schedule_inc_pct_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 Schedule Inc Percent Threshold" is designed to verify the integrity of data in the DS07 IPMR Header table. This check specifically focuses on the 'threshold_schedule_inc_pct_fav' field.
The purpose of this check is to ensure that the 'threshold_schedule_inc_pct_fav' field is not equal to zero. This field represents the favorable schedule increase percentage threshold. A zero value 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_schedule_inc_pct_fav' is equal to zero, it means that the favorable schedule increase percentage threshold has not been properly set. This could potentially impact the accuracy of project management data and subsequent analyses.
To resolve this issue, review the data entry process for the 'threshold_schedule_inc_pct_fav' field. Ensure that the correct values are being entered and that any calculations feeding into this field are accurate. The expected value for 'threshold_schedule_inc_pct_fav' should be a positive number representing the favorable schedule increase percentage threshold.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the favorable schedule increase percent threshold is equal to zero. The test is important because it ensures that the data in the 'threshold_schedule_inc_pct_fav' field is accurate and meaningful. If the threshold is zero, it may indicate that there is no room for any favorable schedule increase, which could be a potential issue in project management.
The severity of this test is marked as an '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 test result is true, it doesn't necessarily mean that the data is incorrect or unusable, but it may not adhere to the best practices for data management in the EVMS construction project. Therefore, it's important to review and correct this issue if necessary to ensure the quality and integrity of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdScheduleIncPctFavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_Schedule_Inc_pct_fav,0) = 0
)