¶ Basic Information
| Key | Value |
|---|---|
| Table | DS06 Resources |
| Severity | MAJOR |
| Unique ID | 1060257 |
| Summary | Does this labor-type resource have a non-hour UOM type? |
| Error message | type = labor where UOM <> h. |
¶ 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 "Labor Resource with Non-Hour UOM Type" is designed to ensure that all labor-type resources in the DS06 Resources table are measured in hours.
The test checks for any instances where a labor-type resource has a unit of measure (UOM) that is not hours ('h'). If such instances are found, it indicates a mismatch between the resource type and its unit of measure.
The error is likely to be caused by incorrect data entry in the 'type' and 'UOM' fields of the DS06 Resources table. For example, a labor-type resource might have been incorrectly assigned a non-hour unit of measure such as 'days' or 'weeks'.
To resolve this issue, ensure that all labor-type resources in the DS06 Resources table have 'h' as their unit of measure. This will ensure consistency and accuracy in the representation and calculation of labor resources.
¶ Why do we check this?
This test is being performed to ensure that all labor-type resources in the 'DS06 Resources' table are using the correct unit of measure (UOM), which should be hours (h). The test is checking for any instances where the UOM for labor is not hours, which could lead to inaccuracies in labor cost calculations and resource allocation.
The importance of this check lies in maintaining the consistency and accuracy of the data. In project management, labor resources are typically measured in hours, and using a different UOM could lead to misinterpretations or errors in data analysis. This could further impact project scheduling, budgeting, and overall management.
The severity level is marked as 'MAJOR', which means that while this issue may not prevent the data from being reviewed, it is likely to cause problems during analysis. Therefore, it is recommended to address this issue to ensure the integrity and quality of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS06_Res_AreLaborTypeAndUOMMismatched] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS06_schedule_resources
WHERE
upload_id = @upload_ID
AND type = 'Labor'
AND UOM <> 'h'
)