¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070374 |
| Summary | Is the favorable schedule cum percent threshold equal to zero? |
| Error message | threshold_schedule_cum_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 Cum Percent Threshold" is performed on the DS07 IPMR Header data. This check is designed to verify if the favorable schedule cumulative percentage threshold is equal to zero.
If an error is flagged by this DIQ check, it indicates that the 'threshold_schedule_cum_pct_fav' field in the DS07 IPMR Header data is set to zero. This field represents the cumulative percentage threshold for a favorable schedule. A zero value in this field may suggest that no threshold has been set for a favorable schedule, which could potentially lead to issues in project management and tracking.
The expected value for the 'threshold_schedule_cum_pct_fav' field should ideally be a positive number, representing a percentage threshold for a favorable schedule. A zero value in this field may not be appropriate, as it implies that there is no threshold for a favorable schedule.
Please review the data in the 'threshold_schedule_cum_pct_fav' field and ensure that it is set to a positive number representing the appropriate percentage threshold for a favorable schedule.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the favorable schedule cumulative percentage threshold is equal to zero. The test is important because it ensures that the data in the 'threshold_schedule_cum_pct_fav' field is accurate and meaningful. If the threshold is zero, it may indicate that there are no favorable schedule percentages, which could potentially skew the project management data and lead to incorrect analysis or decision-making.
The severity of this test is marked as an 'MINOR', which is less severe than a 'MAJOR' or an 'CRITICAL'. This means that while the issue might not prevent the data from being reviewed, it could potentially cause minor problems or indicate that the data does not follow all best practices. Therefore, it is recommended to address this issue to ensure the highest quality and integrity of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsThresholdScheduleCumPctFavEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND ISNULL(threshold_Schedule_cum_pct_fav,0) = 0
)