¶ Basic Information
| Key | Value |
|---|---|
| Table | DS06 Resources |
| Severity | CRITICAL |
| Unique ID | 1060265 |
| Summary | Is this resource lacking an EOC? |
| Error message | EOC missing (where resource_ID is not blank). |
¶ 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.
This Data Integrity and Quality (DIQ) check is designed to identify any resources within the DS06 Resources table that are missing an End of Cost (EOC) date or value, provided that the resource has a specified resource ID. The essence of this check is to ensure that all resources, which are crucial elements of project management and scheduling, have an associated EOC. The EOC is vital for tracking the financial timeline of resources, indicating when the cost accumulation for a particular resource should cease.
The likely cause of an error flagged by this DIQ check is the absence of an EOC value for a resource that has been assigned a resource ID. This situation could arise due to incomplete data entry or oversight in updating the DS06 Resources table with the necessary EOC information. The fields causing the issue are the 'resource_ID', which is expected to be non-blank for all resources, and the 'eoc', which should contain a date or value indicating the end of cost accumulation for the resource.
To resolve issues flagged by this check, users should ensure that every resource listed in the DS06 Resources table with a non-blank resource ID also has a corresponding EOC value filled in. This will not only comply with data integrity standards but also facilitate accurate and comprehensive project cost management.
¶ Why do we check this?
The DIQ test titled "Resource Missing EOC" for the "DS06 Resources" table is being performed to check if any resource entries are missing an End of Contract (EOC) date or detail, where the resource ID is not blank. This test is crucial because the EOC is a key piece of information that indicates when a resource's availability or contract is expected to end. This information is essential for planning, scheduling, and managing resources effectively within the project management framework, especially in the context of Earned Value Management Systems (EVMS) where accurate forecasting and resource allocation are critical for project success.
The severity of this test is marked as CRITICAL, which is the highest level of severity. This indicates that if a resource is found to be missing an EOC, it is considered a significant issue that must be addressed immediately. Without the EOC information, project managers and stakeholders cannot accurately assess the resource's availability for the project's duration, potentially leading to scheduling conflicts, resource shortages, or budgeting errors. These issues can severely impact the project's ability to meet its objectives on time and within budget. Therefore, identifying and correcting any instances where the EOC is missing is imperative to ensure the integrity and reliability of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_IsResourceMissingEOC] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT *
FROM DS06_schedule_resources
WHERE upload_id = @upload_ID AND ISNULL(resource_ID,'') <> '' AND ISNULL(eoc,'') = ''
)