¶ Basic Information
| Key | Value |
|---|---|
| Table | DS13 Subcontract |
| Severity | MAJOR |
| Unique ID | 1130527 |
| Summary | Is this 100% complete subcontract missing an actual finish date? |
| Error message | BCWPc_dollars / BAC_dollars = 1 & AF_date missing. |
¶ 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 for the DS13 Subcontract table, titled "Complete Subcontract Missing Actual Finish", is designed to identify any records where a subcontract is marked as 100% complete, but does not have an actual finish date.
The error is likely to be caused by missing data in the 'AF_date' field for subcontracts that are fully completed. The 'BCWPc_dollars' divided by 'BAC_dollars' equals 1, indicating that the subcontract is 100% complete. However, if the 'AF_date' field is missing, this suggests that the actual finish date was not recorded.
To resolve this issue, ensure that all completed subcontracts have an actual finish date recorded in the 'AF_date' field. The expected value for this field should be a valid date that corresponds to when the subcontract was fully completed.
¶ Why do we check this?
This test is being performed on the 'DS13 Subcontract' table to check if there are any complete subcontracts that are missing an actual finish date. The test identifies instances where the ratio of Budgeted Cost of Work Performed in dollars (BCWPc_dollars) to Budget at Completion in dollars (BAC_dollars) equals 1, indicating that the subcontract is 100% complete, but the Actual Finish date (AF_date) is missing.
The importance of this check is to ensure data completeness and accuracy in the project management data. In the context of Earned Value Management Systems (EVMS), having a complete and accurate record of actual finish dates for subcontracts is crucial for project tracking, cost control, and performance analysis. If actual finish dates are missing for completed subcontracts, it could lead to inaccurate project status reporting and potentially mislead project management decisions.
The severity of this check is marked as 'MAJOR', which implies that this issue is likely to cause problems during data analysis. It may not prevent the data from being reviewed, but it could potentially distort the results and interpretations of the analysis if not addressed. Therefore, it is recommended to fix this issue to maintain the integrity and quality of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS13_SubK_IsCostCompleteSubKMissingAFDate] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS13_subK
WHERE
upload_ID = @upload_ID
AND BCWPc_dollars / NULLIF(BAC_dollars,0) = 1
AND AF_date IS NULL
)