¶ Basic Information
| Key | Value |
|---|---|
| Table | DS06 Resources |
| Severity | MAJOR |
| Unique ID | 1060241 |
| Summary | Is this task resource-loaded with only Indirect EOC resources? |
| Error message | Task lacking EOC other than Indirect (task_ID where EOC = Indirect). |
¶ 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 "Task with Overhead EOC Only" is designed to identify tasks in the DS06 Resources table that are resource-loaded with only Overhead EOC resources.
The DIQ check is looking for tasks where the EOC (Element of Cost) field is marked as 'Overhead' and there are no other types of EOC associated with the task. This could indicate a potential issue with the task's resource loading, as tasks typically should have more than just overhead costs associated with them.
If a task is flagged by this DIQ check, it means that the task has been identified as having only 'Overhead' in the EOC field and no other types of EOC. This could be due to an error in data entry or a misclassification of the task's resources.
To resolve this issue, you should review the flagged tasks and ensure that the resources associated with them are correctly classified. If a task should have other types of EOC associated with it, update the EOC field accordingly. If the task is indeed only associated with overhead costs, you may want to review the task's resource loading to ensure it is accurate and appropriate.
¶ Why do we check this?
This test is being performed to check if there are any tasks in the 'DS06 Resources' table that are resource-loaded with only Overhead EOC resources. The severity of this test is marked as 'MAJOR', which means that if this issue is not addressed, it is likely to cause problems during the analysis of the data.
The importance of this check lies in ensuring the accuracy and completeness of the resource allocation in the tasks. If a task is only loaded with Overhead EOC resources, it might indicate that other necessary resources are missing. This could lead to inaccurate project cost estimations and could potentially impact the overall project management and execution. Therefore, it is crucial to identify and rectify such issues for maintaining the integrity and quality of the EVMS construction project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_IsIndirectOnItsOwn] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with Ind as (
select task_ID, schedule_type, TRIM(ISNULL(subproject_ID,'')) SubP
from DS06_schedule_resources
where upload_ID = @upload_ID and EOC = 'Indirect'
), NonI as (
select task_ID, schedule_type, TRIM(ISNULL(subproject_ID,'')) SubP
from DS06_schedule_resources
where upload_ID = @upload_ID and EOC <> 'Indirect' AND EOC IS NOT NULL
), Flags as (
select Ind.task_ID, Ind.schedule_type, Ind.SubP
from Ind left outer join NonI on Ind.task_ID = NonI.task_ID AND Ind.schedule_type = NonI.schedule_type AND Ind.SubP = NonI.SubP
where NonI.task_ID is null
)
SELECT R.*
FROM DS06_schedule_resources R INNER JOIN Flags F ON R.task_ID = F.task_ID AND R.schedule_type = F.schedule_type AND TRIM(ISNULL(R.subproject_ID,'')) = F.SubP
WHERE R.upload_id = @upload_ID AND R.EOC = 'Indirect'
)
¶ Changelog
| Date | Description of Changes |
|---|---|
| 2024-04-30 | DIQ adjusted to account for conversion of EOC = Overhead to EOC = Indirect. |