¶ Basic Information
| Key | Value |
|---|---|
| Table | DS06 Resources |
| Severity | MAJOR |
| Unique ID | 1060243 |
| Summary | Does this resource have a non-zero remaining lag? |
| Error message | Resource remaining lag (lag_remaining_days) <> 0. |
¶ 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 "Resource with Non-Zero Remaining Lag" is designed to verify the integrity of data in the DS06 Resources table. This check specifically looks at the 'lag_remaining_days' field for each resource in the table.
The purpose of this check is to ensure that no resource has a non-zero value in the 'lag_remaining_days' field. In the context of project management, 'lag' refers to the delay between tasks that are dependent on each other. A non-zero value in the 'lag_remaining_days' field would indicate that there is a delay in the completion of a task, which could potentially impact the overall project timeline.
If this DIQ check returns an error, it means that one or more resources in the DS06 Resources table have a non-zero value in the 'lag_remaining_days' field. This could be due to a data entry error or a delay in task completion. The expected value for the 'lag_remaining_days' field is zero, indicating that there is no delay in task completion.
To resolve this issue, review the resources with a non-zero 'lag_remaining_days' value and correct any data entry errors. If the non-zero value is due to a delay in task completion, you may need to adjust your project timeline or take steps to address the delay.
¶ Why do we check this?
This test is being performed on the 'DS06 Resources' table to check if any resource has a non-zero remaining lag. The remaining lag refers to the amount of time that must pass before a particular resource can start its work, after its dependencies have been completed. If a resource has a non-zero remaining lag, it means there is still some time left before it can begin its work, even after all its dependencies are done.
The severity of this test is marked as 'MAJOR', which means that while it's not an immediate threat to the data's integrity, it could potentially cause problems during analysis. For instance, if a resource has a non-zero remaining lag, it could delay the overall project timeline, which could lead to inaccurate project completion estimates.
This check is important because it helps ensure that the project management data is accurate and reliable. By identifying resources with non-zero remaining lags, project managers can better plan and manage their resources, ensuring that projects are completed on time and within budget.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_IsRemainingLagNEqToZero] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS06_schedule_resources
WHERE
upload_id = @upload_ID
AND lag_remaining_days <> 0
)