¶ Basic Information
| Key | Value |
|---|---|
| Table | DS10 CC Log Detail |
| Severity | MAJOR |
| Unique ID | 1100465 |
| Summary | Is the description missing? |
| Error message | description is null or blank. |
¶ 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 "Description Missing" is designed to identify any records in the DS10 CC Log Detail table where the 'description' field is either null or blank.
The 'description' field is crucial for understanding the context and details of each record in the DS10 CC Log Detail table. If this field is missing or blank, it may lead to incomplete or misleading information about the record.
The DIQ check is performed by examining each record in the DS10 CC Log Detail table. If the 'description' field is found to be null or blank (i.e., it contains no data or only whitespace), the record is flagged by the check.
To ensure data integrity and quality, it is important that all records in the DS10 CC Log Detail table have a valid, non-blank description. If this DIQ check flags any records, you should review the source data and ensure that a valid description is provided for each record.
¶ Why do we check this?
This test is being performed on the 'DS10 CC Log Detail' table to check if there are any entries where the description is missing. The test is looking for instances where the description field is null or blank. The severity of this test 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.
The importance of this check lies in ensuring the completeness of the data. In project management, every piece of information can be crucial for understanding the context and making informed decisions. If the description is missing, it could lead to misunderstandings or misinterpretations of the data. Therefore, this check helps to maintain the integrity and quality of the data by ensuring that all necessary information is included.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS10_CCLogDetails_IsDescriptionMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS10_CC_log_detail
WHERE
upload_ID = @upload_ID
AND TRIM(ISNULL([description],'')) = ''
)