¶ Basic Information
| Key | Value |
|---|---|
| Table | DS04 Schedule |
| Severity | MAJOR |
| Unique ID | 1040179 |
| Summary | Is this task missing an Actual Start even though it has an Actual Finish? (FC) |
| Error message | AS_date missing on task with AF_date (FC). |
¶ 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 "Actual Start Missing on Finished Task" is designed to identify any tasks in the DS04 Schedule table that have an Actual Finish date (AF_date) but are missing an Actual Start date (AS_date). This check is specifically for tasks of the 'FC' schedule type and excludes tasks of the 'SM' type.
If this DIQ check identifies any tasks that meet these criteria, it indicates that there may be an error in the data entry or data import process. Every task that has an Actual Finish date should also have an Actual Start date. The absence of an Actual Start date for a task that has been finished is inconsistent and could lead to inaccuracies in project management and reporting.
To resolve this issue, review the tasks identified by this DIQ check and ensure that each one has both an Actual Start date and an Actual Finish date. If the Actual Start date is missing, it should be added to the DS04 Schedule table. If the task should not have an Actual Finish date, then the Actual Finish date should be removed.
¶ Why do we check this?
This test is being performed on the 'DS04 Schedule' table to check if there are any tasks that have an Actual Finish date (AF_date) but are missing an Actual Start date (AS_date). The test is titled 'Actual Start Missing on Finished Task' and it is designed to identify any inconsistencies in the data related to task scheduling.
The importance of this check lies in ensuring the accuracy and completeness of the project management data. In a construction project, every task should have both a start and finish date. If a task has an Actual Finish date but no Actual Start date, it could lead to inaccuracies in project timelines, scheduling, and overall project management. This could further lead to incorrect analysis and decision-making based on this data.
The severity of this issue is marked as 'MAJOR', which means that while it may not prevent the data from being reviewed, it is likely to cause problems during analysis. Therefore, it is crucial to address this issue to maintain the integrity and quality of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS04_Sched_IsFinishedTaskMissingActualStart] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS04_schedule
WHERE
upload_id = @upload_ID
AND schedule_type = 'FC'
AND AF_date IS NOT NULL
AND AS_date IS NULL
AND type != 'SM'
)