¶ Basic Information
| Key | Value |
|---|---|
| Table | DS10 CC Log Detail |
| Severity | MAJOR |
| Unique ID | 1100479 |
| Summary | Are there no MR entries in the CC Log detail? |
| Error message | Count where category = MR is 0. |
¶ 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 "MR Entry Missing in CC Log Detail" is designed to ensure that there are entries in the DS10 CC Log Detail table that are categorized as 'MR'.
If this DIQ check fails, it means that there are no entries in the DS10 CC Log Detail table that have 'MR' as their category. This could be due to an error in data entry, where the 'MR' category was not properly assigned to any entries, or it could be due to a lack of 'MR' entries in the data source itself.
The field causing the issue is the 'category' field in the DS10 CC Log Detail table. The expected value for this field, for at least some entries, is 'MR'. If no entries have 'MR' as their category, the DIQ check will fail.
To resolve this issue, ensure that there are entries in the DS10 CC Log Detail table that are categorized as 'MR'. This may involve correcting data entry errors or adding 'MR' entries to the data source.
¶ Why do we check this?
This test is being performed to check if there are any Material Requisition (MR) entries in the 'DS10 CC Log Detail' table. The test is checking for the presence of MR entries because they are crucial for tracking the request and acquisition of materials in the construction project management process.
The severity of this test is marked as 'MAJOR', which implies that the absence of MR entries is likely to cause problems during data analysis. This could potentially lead to inaccurate project tracking, budgeting, and scheduling, as the procurement of materials is a critical aspect of project management.
The importance of this check lies in ensuring the completeness and accuracy of the data. Without MR entries, the data set would not provide a full picture of the project's progress and could lead to misinformed decision-making. Therefore, it's crucial to address this issue to maintain the integrity and quality of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS10_CCLogDetails_IsMREntryMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with CCLogDetail as (
SELECT *
FROM DS10_CC_log_detail
WHERE upload_ID = @upload_id
)
SELECT
*
FROM
DummyRow_Get(@upload_id)
WHERE
NOT EXISTS (SELECT 1 FROM CCLogDetail WHERE category = 'MR')
AND (SELECT COUNT(*) FROM CCLogDetail) > 0 --run only if rows exist in DS10
)