¶ Basic Information
| Key | Value |
|---|---|
| Table | DS07 IPMR Header |
| Severity | MAJOR |
| Unique ID | 1070265 |
| Summary | Is the PM EAC Best dollars value zero or negative? |
| Error message | EAC_PM_Best_dollars <= 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 "Negative or Zero PM EAC Best Dollars" is designed to identify any instances where the PM EAC Best dollars value is zero or negative in the DS07 IPMR Header table.
The PM EAC Best dollars field should ideally contain positive values, as it represents the best estimate at completion in dollars for the project management. A zero or negative value in this field could indicate an error in data entry or calculation.
If this DIQ check identifies any records with a zero or negative PM EAC Best dollars value, it suggests that there may be inaccuracies in the project management's financial estimates. These inaccuracies could potentially impact the overall project budget and timeline, and should therefore be corrected as soon as possible.
To resolve this issue, review the data entries for the PM EAC Best dollars field in the DS07 IPMR Header table. Ensure that all values are positive and accurately reflect the project management's best estimate at completion in dollars.
¶ Why do we check this?
This test is being performed on the 'DS07 IPMR Header' table to check if the 'PM EAC Best dollars' value is zero or negative. The 'PM EAC Best dollars' field likely represents the Project Manager's Estimate at Completion (EAC) in terms of best-case scenario dollars. This value should ideally be a positive number, as it represents the expected cost to complete the project.
The severity of this test is marked as a 'MAJOR', which means that if the 'PM EAC Best dollars' value is found to be zero or negative, it could potentially cause problems during the analysis of the data. This could be due to incorrect data entry, calculation errors, or other issues that might distort the true cost picture of the project.
The importance of this check is to ensure the accuracy and reliability of the project cost data. It helps in maintaining the integrity of the data and aids in making informed decisions regarding the project. If the 'PM EAC Best dollars' value is not accurate, it could lead to incorrect project cost forecasts and potentially impact the project's financial management.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS07_IPMR_IsEACPMBestDollarsLtEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS07_IPMR_header
WHERE
upload_ID = @upload_ID
AND EAC_PM_best_dollars <= 0
)