Key | Value |
---|---|
Table | DS06 Resources |
Severity | CRITICAL |
Unique ID | 1060245 |
Summary | Is this resource missing both a resource and role ID? |
Error message | Resource missing both resource_ID and role_ID (resource_ID and role_ID = null or blank). |
The Data Integrity and Quality (DIQ) check titled "Missing Resource & Role ID" is designed to identify any instances in the DS06 Resources table where a resource is missing both a resource ID and a role ID.
The error message "Resource missing both resource_ID and role_ID (resource_ID and role_ID = null or blank)" indicates that the DIQ check has found one or more resources that do not have either of these identifiers.
This issue is likely caused by incomplete data entry or data import. Each resource in the DS06 Resources table should have a unique resource ID and a role ID associated with it. These identifiers are crucial for tracking and managing resources in the EVMS construction project management data.
If a resource is missing both of these identifiers, it may be difficult to accurately track and manage that resource. Therefore, it is important to ensure that all resources have a resource ID and a role ID.
If you encounter this error, you should review the data for the affected resources and add the missing identifiers where necessary. The resource ID should be a unique identifier for the resource, and the role ID should correspond to the role that the resource plays in the project.
This test is being performed to ensure that each resource in the 'DS06 Resources' table has both a resource ID and a role ID. These IDs are crucial for identifying and categorizing resources, and for linking them to their respective roles in the project.
The severity of this test is marked as 'CRITICAL', which is the highest level of severity. This means that if a resource is missing both a resource ID and a role ID, it is a critical issue that must be fixed before the data can be reviewed.
The importance of this check lies in maintaining the integrity and quality of the data. Without these IDs, it would be impossible to accurately track resources and their roles, which could lead to significant errors in project management and analysis. Therefore, ensuring that each resource has both a resource ID and a role ID is essential for accurate and effective project management.
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_IsResourceAndRoleIDMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS06_schedule_resources
WHERE
upload_id = @upload_ID
AND TRIM(ISNULL(resource_ID,'')) = ''
AND TRIM(ISNULL(role_ID,'')) = ''
)