| 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 or 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 either a resource ID or a role ID. These IDs are used for linking them to other data 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 an ID, it is a critical issue that must be fixed before the data can be reviewed.
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,'')) = ''
)