| Key | Value |
|---|---|
| Table | DS03 Cost |
| Severity | CRITICAL |
| Unique ID | 1030119 |
| Summary | Is this indirect EOC marked as Is_indirect = N? |
| Error message | EOC = indirect where is_indirect = N. |
The Data Integrity and Quality (DIQ) check titled "Indirect EOC With Is_indirect = N" is performed on the DS03 Cost table. This check is designed to identify if indirect rows with EOC = Indirect also show is_indirect = 'Y'. The check runs on both CA/SLPP & WP/PP level data.
This test, titled "Indirect EOC With Is_indirect = N", is being performed on the 'DS03 Cost' table to ensure that indirects are collected properly. The severity of this test is marked as 'CRITICAL', which is the highest level of severity, indicating that this issue must be resolved before the data can be reviewed further.
The importance of this check lies in the need for accurate and clear cost tracking, without which proper analysis can be accomplished.
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_DoesIndEOCHaveIsIndEqN] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT *
FROM DS03_cost
where upload_ID = @upload_id and is_indirect = 'N' and EOC = 'indirect'
)