¶ Basic Information
| Key | Value |
|---|---|
| Table | DS09 CC Log |
| Severity | MAJOR |
| Unique ID | 9090442 |
| Summary | Is this CC Log ID missing in the log detail? |
| Error message | CC_log_ID missing in DS10.CC_log_ID list. |
¶ 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.
This Data Integrity and Quality (DIQ) check is designed to ensure that every CC Log ID in the DS09 CC Log table is also present in the DS10 CC Log Detail table. The CC Log ID is a crucial piece of information that links these two tables together, and its absence in the DS10 CC Log Detail table could lead to incomplete or inaccurate data analysis.
The error message "CC_log_ID missing in DS10.CC_log_ID list" indicates that there are one or more CC Log IDs in the DS09 CC Log table that cannot be found in the DS10 CC Log Detail table. This discrepancy could be due to a variety of reasons, such as data entry errors, missing records, or issues with data synchronization between the two tables.
To resolve this issue, you should verify the CC Log IDs in both tables and ensure that they match. Any missing CC Log IDs in the DS10 CC Log Detail table should be added as soon as possible to maintain data integrity and quality.
¶ Why do we check this?
This test is being performed to check if there are any missing CC Log IDs in the CC Log Detail. The CC Log ID is a unique identifier for each entry in the CC Log, and it is crucial for maintaining data integrity and ensuring accurate data tracking and analysis.
The severity of this test is marked as a MAJOR, which means that while it may not immediately prevent the data from being reviewed, it is likely to cause problems during analysis. If the CC Log ID is missing, it could lead to difficulties in tracking specific entries, linking data across tables, and could potentially result in inaccurate analysis or reporting.
Therefore, this check is important as it helps to ensure that all entries in the CC Log are correctly and uniquely identified, which is essential for maintaining the integrity and quality of the EVMS construction project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS09_CCLog_IsCCLogMissingInDS10] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS09_CC_log
WHERE
upload_ID = @upload_ID
AND CC_log_ID NOT IN (
SELECT CC_log_ID
FROM DS10_CC_log_detail
WHERE upload_ID = @upload_ID
)
)