¶ Basic Information
| Key | Value |
|---|---|
| Table | DS04 Schedule |
| Severity | MINOR |
| Unique ID | 1040165 |
| Summary | Is the task lacking a proper description? |
| Error message | Task is lacking at least two words in its description. |
¶ 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 "Insufficient Description" is designed to ensure that each task in the DS04 Schedule table has a proper description. This check is important because a well-defined task description is crucial for clear communication and effective project management.
The DIQ check identifies tasks that are lacking a proper description. Specifically, it flags tasks where the description field contains less than two words. This is based on the assumption that a meaningful description of a task would require at least two words.
If this DIQ check flags any tasks, it means that those tasks have insufficient descriptions. The issue lies in the 'description' field of the DS04 Schedule table. The expected value for this field is a string of at least two words.
To resolve this issue, review the flagged tasks and update their descriptions to be more detailed and informative. This will not only pass the DIQ check but also improve the overall quality and clarity of the project schedule.
¶ Why do we check this?
This test is being performed to ensure that each task in the 'DS04 Schedule' table has a proper description. The importance of this check is to maintain the clarity and understanding of each task. Without a sufficient description, it can lead to confusion or misinterpretation of the task's purpose, which can negatively impact the project's execution and management. The severity level of this test is 'MINOR', which means it's not a critical issue, but it's still important to follow best practices for data quality and integrity. It's recommended to have at least two words in the task description to provide enough context about the task.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS04_Sched_IsDescriptionInsufficient] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS04_schedule
WHERE
upload_ID = @upload_ID
AND CHARINDEX(' ',TRIM([description])) = 0
)