| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | MAJOR |
| Unique ID | 1030077 |
| Summary | Is the WBS ID to which this work is apportioned missing? |
| Error message | EVT = J or M but EVT_J_to_WBS_ID is missing. |
The Data Integrity and Quality (DIQ) check titled "Apportioned To WBS ID Missing" is designed to verify the presence of a WBS ID apportioned to when the EVT is either J (apportioned) or M (calculated apportionment).
For EVT of J or M, the WBS ID apportioned to is a crucial piece of information that identifies the specific work package to which costs are apportioned. If this WBS ID apportioed to is missing, it can lead to inaccuracies in cost allocation and tracking, which can in turn affect the overall project management and financial reporting.
The error message "EVT = J or M but EVT_J_to_WBS_ID is missing" indicates that there are records in the DS03 Cost table where the EVT is either 'J' or 'M', but the corresponding WBS ID apportioned to (in field EVT_J_to_WBS_ID) is missing. This is likely due to incomplete data entry or a data import error.
To resolve this issue, ensure that every record in the DS03 Cost table with an EVT of 'J' or 'M' also includes a valid WBS ID in the EVT_J_to_WBS_ID field.
This test is being performed to ensure that the Work Breakdown Structure (WBS) ID apportioned to is identified, which is crucial for tracking and managing costs. The test checks if the Earned Value Technique (EVT) is either 'J' or 'M', but the field EVT_J_to_WBS_ID to which the work is apportioned is missing.
The importance of this check lies in the fact that without the WBS ID apportioned to, it would be impossible to accurately track, manage, and apportion costs within the project. This could lead to mismanagement of resources, inaccurate cost reporting, and potential project overruns.
The severity of this issue is marked as 'MAJOR'. This means that, while the issue isn't required to be fixed before import, it could lead to significant problems in project management and financial reporting if it remains unfixed for extended periods of time.
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_IsApportionedToIDMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS03_Cost
WHERE
upload_ID = @upload_ID
AND EVT IN ('J','M')
AND TRIM(ISNULL(EVT_J_to_WBS_ID,''))=''
)
| Date | Description of Changes |
|---|---|
| 2025-04-02 | Downgraded from CRITICAL to MAJOR. |