¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MAJOR |
| Unique ID | 9070367 |
| Summary | Is the QRA Confidence Level below 90% for cost following a BCP? |
| Error message | QRA_CL_cost_pct < .9 & count where DS09.type = BCP or where DS04.milestone_level between 131 & 135 > 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 "QRA Confidence Level Low for Cost Following BCP" is designed to identify instances where the QRA Confidence Level for cost is below 90% following a Baseline Change Proposal (BCP). This check is performed on the data in the DS07 IPMR Header table.
The error is likely to be caused by one of two scenarios. The first scenario is when there is a record in the DS09 CC Log table where the type is 'BCP'. The second scenario is when there is a record in the DS04 Schedule table where the milestone level is between 131 and 135. If either of these scenarios is true and the QRA Confidence Level for cost is below 90%, the DIQ check will flag an error.
The fields causing the issue are the 'type' field in the DS09 CC Log table, the 'milestone_level' field in the DS04 Schedule table, and the 'QRA_CL_cost_pct' field in the DS07 IPMR Header table. The expected values for these fields are 'BCP' for the 'type' field, a number between 131 and 135 for the 'milestone_level' field, and a number greater than or equal to 0.9 for the 'QRA_CL_cost_pct' field.
If the DIQ check flags an error, it indicates that the QRA Confidence Level for cost is below the acceptable threshold following a Baseline Change Proposal, which may require further investigation or corrective action.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check the Quality Risk Assessment (QRA) Confidence Level for cost following a Baseline Change Proposal (BCP). The test is checking if the QRA Confidence Level is below 90% for cost after a BCP has been implemented. This is important because a low QRA Confidence Level could indicate potential risks or issues with the cost estimates following a BCP, which could impact the overall project budget and timeline.
The severity of this test is marked as a 'MAJOR', which means that while it may not immediately prevent the data from being reviewed, it is likely to cause problems during analysis if not addressed. This could potentially lead to inaccurate cost projections or risk assessments, which could negatively impact decision-making and project management. Therefore, it is crucial to address this issue to ensure the integrity and quality of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsQRACLCostLowFollowingBCP] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND (
(SELECT COUNT(*) FROM DS09_CC_log WHERE upload_ID = @upload_ID AND type = 'BCP') > 0
OR (SELECT COUNT(*) FROM DS04_schedule WHERE upload_ID = @upload_id AND milestone_level BETWEEN 131 AND 135) > 0
)
AND QRA_CL_cost_pct < .9
)