¶ Basic Information
| Key | Value |
|---|---|
| Table | DS06 Resources |
| Severity | MAJOR |
| Unique ID | 1060255 |
| Summary | Is the start date later than the finish date for this resource? |
| Error message | Resource start_date > finish_date. |
¶ 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 Start Date Later Than Finish Date" is designed to ensure that the start date for a resource in the DS06 Resources table is not later than the finish date.
If an error message "Resource start_date > finish_date" is received, it indicates that there is a data inconsistency where the start date of a resource is recorded as being later than the finish date. This is logically incorrect as a resource cannot start after it has finished.
The fields causing this issue are the 'start_date' and 'finish_date'. The expected values should be such that the 'start_date' is earlier than or equal to the 'finish_date'.
To resolve this issue, review the data entries in the DS06 Resources table and correct any instances where the start date is later than the finish date. This will ensure the integrity and quality of the project management data.
¶ Why do we check this?
This test is being performed to ensure that the start date for a resource is not later than the finish date. This is important because it checks for logical inconsistencies in the data. In project management, a resource cannot finish before it starts, so this test is crucial for maintaining the integrity of the project timeline data.
The severity of this test is marked as a MAJOR. This means that while it may not immediately prevent the data from being reviewed, it is likely to cause problems during analysis. For instance, it could lead to incorrect calculations of project duration or resource allocation, which could in turn affect project planning and decision-making. Therefore, it is important to address this issue to ensure accurate and reliable project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_IsStartDateLaterThanFinish] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS06_schedule_resources
WHERE
upload_id = @upload_ID
AND start_date > finish_date
)