¶ Basic Information
| Key | Value |
|---|---|
| Table | DS13 Subcontract |
| Severity | MAJOR |
| Unique ID | 1130506 |
| Summary | Is BCWS missing on this subcontract? |
| Error message | BCWSc_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 "BCWS Dollars Missing" is designed to identify any instances in the DS13 Subcontract table where the Budgeted Cost of Work Scheduled (BCWS) in dollars is either missing or recorded as zero.
The BCWS is a critical field in project management as it represents the amount that was originally estimated for the work that was scheduled. If this field is missing or zero, it could indicate that the data for the subcontract was not entered correctly or not entered at all.
The expected value for the BCWS in dollars should be a positive number that reflects the budgeted cost for the scheduled work on 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 integrity and quality of the project management data.
¶ Why do we check this?
This test is being performed on the 'DS13 Subcontract' table to check if the Budgeted Cost of Work Scheduled (BCWS) in dollars is missing or zero. BCWS is a critical parameter in project management as it represents the budgeted cost of work that should have been done according to the schedule.
The severity of this test is marked as 'MAJOR', which implies that if BCWS data is missing or zero, it is likely to cause problems during the analysis of the project's performance. This is because BCWS is used to calculate cost and schedule variances, and without it, the project's performance cannot be accurately assessed.
The importance of this check lies in ensuring the completeness and accuracy of the project's financial data. If BCWS data is missing or zero, it could indicate a data entry error, a problem with the data import process, or that the subcontract has not been budgeted for properly. Any of these issues could lead to inaccurate project performance assessments and flawed decision-making. Therefore, it's crucial to address this warning to maintain the integrity and quality of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS13_SubK_AreBCWSDollarsMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS13_subK
WHERE
upload_ID = @upload_ID
AND ISNULL(BCWSc_dollars,0) = 0
)