¶ Basic Information
| Key | Value |
|---|---|
| Table | DS13 Subcontract |
| Severity | MAJOR |
| Unique ID | 1130512 |
| Summary | Are profit fee initial dollars missing on this subcontract? |
| Error message | profit_fee_initial_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 Initial Dollars Missing" is designed to identify any instances in the DS13 Subcontract table where the 'profit_fee_initial_dollars' field is either missing or has a value of 0.
This field is crucial as it represents the initial profit fee for a subcontract. If this field is missing or has a value of 0, it could indicate that the data was not entered correctly or was not captured at all during the data entry process.
The expected value for the 'profit_fee_initial_dollars' field should be a positive number representing the initial profit fee for the subcontract. If the DIQ check identifies any records where this is not the case, these records should be reviewed and corrected to ensure the accuracy and completeness of the data in the DS13 Subcontract table.
¶ Why do we check this?
This test is being performed on the 'DS13 Subcontract' table to check if the 'profit_fee_initial_dollars' field is missing or has a value of 0. The test is titled 'Profit Fee Initial Dollars Missing' and it has been assigned a severity level of 'MAJOR'.
The importance of this check is to ensure that all subcontracts have an initial profit fee recorded. This is crucial for financial tracking and profitability analysis of the project. If this data is missing or zero, it could lead to inaccurate financial reporting and decision making.
The severity level of 'MAJOR' indicates that while this issue is not critical enough to halt the review of the data, it is likely to cause problems during analysis. Therefore, it is recommended that this issue be addressed to ensure the accuracy and reliability of the project's financial data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS13_SubK_AreProfitFeeInitDollarsMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS13_subK
WHERE
upload_ID = @upload_ID
AND ISNULL(profit_fee_initial_dollars,0) = 0
)