¶ Basic Information
| Key | Value |
|---|---|
| Table | DS10 CC Log Detail |
| Severity | MAJOR |
| Unique ID | 9100463 |
| Summary | Is this DB transaction being applied to something other than a CA, SLPP, PP, or WP? |
| Error message | category = DB & DS01.type <> CA, SLPP, PP, or WP. |
¶ 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 "DB Transaction On Non-CA, SLPP, PP, or WP" is designed to ensure that DB transactions are only applied to the correct categories. This check is performed on the DS10 CC Log Detail table.
The error message "category = DB & DS01.type <> CA, SLPP, PP, or WP" indicates that a DB transaction is being applied to a category other than CA, SLPP, PP, or WP in the DS01 WBS table. This is not expected as per the standard rules of data integrity and quality.
The fields causing this issue are 'category' in the DS10 CC Log Detail table and 'type' in the DS01 WBS table. The 'category' field should only contain the value 'DB' and the 'type' field should only contain one of the following values: 'CA', 'SLPP', 'PP', or 'WP'.
If you encounter this error, it is likely due to incorrect data entry or a system error that has allowed a DB transaction to be applied to an incorrect category. Please review the data in these fields and correct any discrepancies to ensure data integrity and quality.
¶ Why do we check this?
This test is being performed to ensure that database transactions are being applied correctly within the 'DS10 CC Log Detail' table. Specifically, it checks if a database transaction is being applied to something other than a Control Account (CA), Summary Level Planning Package (SLPP), Planning Package (PP), or Work Package (WP).
The importance of this check is to maintain the integrity and accuracy of the data. If database transactions are being applied to incorrect categories, it could lead to inaccurate data representation, misinterpretation of data, and potential issues during data analysis.
The severity level of this test is 'MAJOR', which implies that if this issue is not addressed, it is likely to cause problems during data analysis. It may not stop the data from being reviewed, but it could potentially lead to incorrect conclusions or decisions based on the data. Therefore, it is crucial to address this issue to ensure the accuracy and reliability of the data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS10_CCLogDetails_IsDBTransactionForDS01WBSType] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
L.*
FROM
DS10_CC_log_detail L INNER JOIN DS01_WBS W ON L.WBS_ID = W.WBS_ID
WHERE
L.upload_ID = @upload_ID
AND W.upload_ID = @upload_ID
AND category = 'DB'
AND W.type NOT IN ('CA','SLPP','PP','WP')
)