¶ Basic Information
| Key | Value |
|---|---|
| Table | DS08 WAD |
| Severity | MAJOR |
| Unique ID | 9080430 |
| Summary | Is the POP finish for this Control Account WAD before the last recorded SPAE value in cost? |
| Error message | pop_finish_date < max DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by CA WBS ID). |
¶ 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 "POP Finish Before Cost Finish (CA)" is designed to ensure that the Period of Performance (POP) finish date for a given Control Account Work Authorization Document (WAD) in DS08 WAD table is not earlier than the last recorded Schedule Performance Analysis Evaluation (SPAE) value in the DS03 cost table.
The error message "pop_finish_date < max DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by CA WBS ID)" indicates that the POP finish date is earlier than the maximum period date in DS03 where any of the following fields are not equal to zero: Budgeted Cost of Work Scheduled (BCWS), Budgeted Cost of Work Performed (BCWP), Actual Cost of Work Performed (ACWP), or Estimate to Complete (ETC). This is determined on a per Control Account Work Breakdown Structure (CA WBS) ID basis.
This error is likely caused by incorrect or inconsistent data entry in the DS08 WAD and DS03 cost tables. The POP finish date in the DS08 WAD table should not be earlier than the last recorded SPAE value in the DS03 cost table. If it is, this suggests that there may be cost data recorded after the project was supposed to have finished, which could indicate a data entry error or a problem with the project timeline.
To resolve this issue, review the POP finish dates in the DS08 WAD table and the SPAE values in the DS03 cost table for the affected CA WBS IDs. Ensure that the POP finish dates are not earlier than the last recorded SPAE values. If necessary, update the POP finish dates in the DS08 WAD table or the SPAE values in the DS03 cost table to correct the data.
¶ Why do we check this?
This test is being performed to ensure that the Planned Order of Performance (POP) finish date for a specific Control Account Work Authorization Document (WAD) is not set before the last recorded Schedule Performance Analysis Evaluation (SPAE) value in cost. This is important because it checks for logical consistency in the project timeline. If the POP finish date is before the last cost recording, it implies that costs are being recorded after the project is supposed to have been completed, which could indicate a problem with either the scheduling or cost recording processes.
The severity of this check is marked as a MAJOR. This means that while it may not prevent the data from being reviewed, it is likely to cause problems during analysis. For instance, it could lead to inaccurate cost performance analysis or flawed project timeline predictions. Therefore, it is crucial to address this issue to ensure accurate and reliable project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS08_WAD_IsPOPFinishBeforeDS03FinishCA] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with CostFinish as (
SELECT WBS_ID_CA CAWBS, MAX(period_date) Period
FROM DS03_cost
WHERE upload_ID = @upload_ID AND (
BCWSi_dollars <> 0 OR BCWSi_hours <> 0 OR BCWSi_FTEs <> 0 OR
BCWPi_dollars <> 0 OR BCWPi_hours <> 0 OR BCWPi_FTEs <> 0 OR
ACWPi_dollars <> 0 OR ACWPi_hours <> 0 OR ACWPi_FTEs <> 0 OR
ETCi_dollars <> 0 OR ETCi_hours <> 0 OR ETCi_FTEs <> 0
)
GROUP BY WBS_ID_CA
)
SELECT
W.*
FROM
DS08_WAD W
INNER JOIN LatestCAWADRev_Get(@upload_ID) R ON W.WBS_ID = R.WBS_ID
AND W.auth_PM_date = R.PMAuth
INNER JOIN CostFinish C ON W.WBS_ID = C.CAWBS
AND POP_finish_date < C.[Period]
WHERE
upload_ID = @upload_ID
AND TRIM(ISNULL(W.WBS_ID_WP,'')) = ''
)