¶ Basic Information
| Key | Value |
|---|---|
| Table | DS04 Schedule |
| Severity | MINOR |
| Unique ID | 1040194 |
| Summary | Is a sufficient milestone level description lacking for this milestone? |
| Error message | Milestone is lacking a sufficient milestone level description (at least two words required). |
¶ 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 Milestone Level Description" is performed on the DS04 Schedule table. This check is designed to ensure that each milestone in the schedule has a sufficient description.
The error message "Milestone is lacking a sufficient milestone level description (at least two words required)" indicates that the milestone level description field in the DS04 Schedule table does not contain at least two words. This is likely due to an oversight during data entry or a lack of available information at the time of entry.
The milestone level description field is crucial for understanding the purpose and context of each milestone. Therefore, it is expected that this field should contain at least two words to provide a meaningful description. If this error is encountered, it is recommended to review the data entry process for the milestone level description field and ensure that sufficient information is being provided.
¶ Why do we check this?
This test is being performed on the 'DS04 Schedule' table to check the adequacy of the milestone level descriptions. The test is checking if the descriptions provided for each milestone are sufficient, with a requirement of at least two words.
The importance of this check is to ensure that each milestone is adequately described, which is crucial for understanding the progress and status of the project. Without sufficient descriptions, it may be difficult to understand the purpose or significance of a milestone, which could lead to confusion or misinterpretation of the project's progress.
The severity of this issue is marked as an 'MINOR', which means it's not a critical error that would prevent the data from being reviewed, but it's a deviation from best practices. If not addressed, it could potentially cause minor problems in understanding or analyzing the project's progress.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS04_Sched_IsMSLevelDescriptionInsufficient] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS04_schedule
WHERE
upload_ID = @upload_ID
AND CHARINDEX(' ',TRIM([milestone_level_description])) = 0
)