¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MINOR |
| Unique ID | 1070358 |
| Summary | Is the quantitative risk analysis confidence level for schedule above 95%? |
| Error message | QRA_CL_schedule_pct > .95. |
¶ 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.
Test Title: Over-Optimistic Schedule QRA
This Data Integrity and Quality (DIQ) check is performed on the DS07 IPMR Header table. The purpose of this test is to identify instances where the Quantitative Risk Analysis (QRA) confidence level for the schedule is above 95%.
The QRA confidence level is a measure of the certainty that the project will be completed within the defined schedule. A value above 95% may indicate an overly optimistic schedule, which could lead to unrealistic expectations and potential project management issues.
The field causing the issue in this test is 'QRA_CL_Schedule_pct'. If the value in this field is greater than 0.95 (or 95%), the DIQ check will flag it as a potential issue.
In general, QRA confidence levels should be realistic and reflect the true complexity and risk associated with the project. If the value is consistently above 95%, it may be necessary to review the project schedule and risk analysis process to ensure they are accurate and realistic.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the quantitative risk analysis (QRA) confidence level for the schedule is above 95%. The test is titled 'Over-Optimistic Schedule QRA'. The purpose of this test is to ensure that the project schedule is not overly optimistic, which could lead to unrealistic expectations and potential project delays.
The severity of this test is marked as an 'MINOR', which means it is not a critical issue that would prevent the data from being reviewed, but it could potentially cause minor problems or indicate that the data does not follow all best practices.
The importance of this check lies in maintaining the integrity and quality of the project management data. Overly optimistic schedules can lead to poor project planning and execution, which can ultimately impact the success of the project. Therefore, it is crucial to ensure that the QRA confidence level for the schedule is realistic and achievable.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsQRAScheduleHigh] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND QRA_CL_Schedule_pct > .95
)