¶ Basic Information
| Key | Value |
|---|---|
| Table | DS13 Subcontract |
| Severity | MAJOR |
| Unique ID | 1130511 |
| Summary | Are profit fee earned dollars missing on this subcontract? |
| Error message | profit_fee_earned_dollars missing or 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 "Profit Fee Earned Dollars Missing" is designed to identify any instances in the DS13 Subcontract table where the 'profit_fee_earned_dollars' field is either missing or has a value of zero.
This field is crucial as it represents the profit fee earned from a subcontract. If this field is missing or zero, it could indicate that the data was not entered correctly or that the subcontract did not generate any profit fee, which might require further investigation.
The error is likely to be caused by either a data entry error, where the 'profit_fee_earned_dollars' field was not filled in, or a calculation error, where the profit fee earned was incorrectly calculated as zero.
The expected value for the 'profit_fee_earned_dollars' field would be any positive number representing the profit fee earned from the subcontract. If the DIQ check identifies any instances where this field is missing or zero, these records should be reviewed and corrected as necessary.
¶ Why do we check this?
This test is being performed on the 'DS13 Subcontract' table to check if there are any missing or zero values in the 'profit_fee_earned_dollars' field. The test is titled 'Profit Fee Earned Dollars Missing' and it is currently in the 'TEST' status.
The importance of this check is to ensure that all subcontracts have a recorded profit fee earned in dollars. This is crucial for accurate financial tracking and project cost management. If this data is missing or zero, it could lead to inaccurate financial reporting and analysis, which could in turn impact decision-making and overall project outcomes.
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. It is therefore important to address this issue to ensure the integrity and quality of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS13_SubK_AreProfitFeeEarnedDollarsMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS13_subK
WHERE
upload_ID = @upload_ID
AND ISNULL(profit_fee_earned_dollars,0) = 0
)