¶ Basic Information
| Key | Value |
|---|---|
| Table | DS10 CC Log Detail |
| Severity | MAJOR |
| Unique ID | 1100452 |
| Summary | Does this negative AUW dollar change also have an NTE? |
| Error message | AUW = Y & dollars_delta < 0 & NTE_dollars_delta <> 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 AUW Dollar Delta with Non-Zero NTE" is designed to identify potential issues in the DS10 CC Log Detail table. This check is specifically looking for records where the AUW field is marked as 'Y', indicating an Authorized Unpriced Work, but the associated dollar change (dollars_delta) is negative. This is an unusual situation as it suggests that the authorized work is resulting in a decrease in cost, which is not typically expected.
In addition, this check also verifies that the NTE (Not to Exceed) dollar change (NTE_dollars_delta) is not zero. This is because an AUW with a non-zero NTE dollar change implies that there is a cost limit set for the work, which should not be the case if the dollar change is negative.
If this DIQ check identifies any records, it suggests that there may be errors in the data entry or calculation for these fields. The expected values for an AUW record would typically be a positive dollars_delta and a non-zero NTE_dollars_delta. If these conditions are not met, it may indicate that the AUW status, the dollar change, or the NTE dollar change for the work has been incorrectly recorded or calculated.
¶ Why do we check this?
This test is being performed on the 'DS10 CC Log Detail' table to check for instances where there is a negative Authorized Unpriced Work (AUW) dollar change that also has a Non-Total Estimate (NTE). The test is looking for records where AUW is marked as 'Y', the dollar change is less than zero, and the NTE dollar change is not equal to zero.
The importance of this check is to ensure the accuracy and consistency of financial data in the project management system. A negative AUW dollar change with a non-zero NTE could indicate an error or inconsistency in the data, which could potentially lead to incorrect financial calculations or projections.
The severity of this check is marked as 'MAJOR', which means that while it may not prevent the data from being reviewed, it is likely to cause problems during analysis if not addressed. It is therefore important to investigate and resolve any instances where this condition is met to ensure the integrity and reliability of the project's financial data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS10_CCLogDetails_AreAUWDollarsNegativeAndNTENonZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS10_CC_log_detail
WHERE
upload_ID = @upload_ID
AND AUW = 'Y'
AND dollars_delta < 0
AND NTE_dollars_delta IS NOT NULL
AND NTE_dollars_delta <> 0
)