¶ Basic Information
| Key | Value |
|---|---|
| Table | DS06 Resources |
| Severity | CRITICAL |
| Unique ID | 1060253 |
| Summary | Is this resource role missing a name? |
| Error message | role_ID is not blank & role_name is 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 "Resource Role Missing Name" is designed to identify any instances in the DS06 Resources table where a resource role is missing a name. This issue arises when a resource role item is found, but the corresponding resource name is not provided.
The fields causing this issue are 'role_ID' and 'role_name'. The 'role_ID' field is not blank, indicating that a resource role has been identified. However, the 'role_name' field is blank, suggesting that the name of this resource role has not been provided.
In order to maintain data integrity and quality, it is expected that every identified resource role ('role_ID' field) should have a corresponding resource name ('role_name' field). If a resource role is identified, the name of this role should also be provided.
If this DIQ check identifies any instances where a resource role is missing a name, it is recommended to review the data entry process for the DS06 Resources table to ensure that all necessary information is being accurately captured.
¶ Why do we check this?
This test is being performed to ensure that all resource roles in the 'DS06 Resources' table have an associated resource name. The test checks if there are any instances where the role name is not blank, but the resource name is blank. This is a critical check because the absence of a resource name can lead to confusion and misinterpretation of data, especially when the role name is present.
The severity of this test is marked as 'CRITICAL', which is the highest level of severity. This means that if a resource role is found without a resource name, it is a serious issue that must be fixed before the data can be reviewed. This is important because the integrity and quality of the data are compromised if there are missing or incomplete entries. It could lead to inaccurate analysis and decision-making based on this data. Therefore, ensuring that each resource role has a corresponding resource name is crucial for maintaining data integrity and quality.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_IsResourceRoleMissingName] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS06_schedule_resources
WHERE
upload_id = @upload_ID
AND TRIM(ISNULL(role_ID,'')) <> ''
AND TRIM(ISNULL(role_name,''))=''
)
¶ Changelog
| Date | Description of Changes |
|---|---|
| 2024-04-30 | Minor metadata updates & corrections. |