Key | Value |
---|---|
Table | DS03 Cost |
Severity | MAJOR |
Unique ID | 1030098 |
Summary | Does this CA, SLPP, PP, or WP have only Indirect EOCs? |
Error message | CA, SLPP, PP, or WP with only Indirect. |
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 within the DS03 Cost table, any Control Account (CA), Summary Level Planning Package (SLPP), Planning Package (PP), or Work Package (WP) does not have 'Indirect' Elements of Cost (EOCs) only.
An error flagged by this DIQ test indicates that there is a CA, SLPP, PP, or WP which is supposed to contain indirect costs (as indicated by the EOC being 'Indirect' or the is_indirect flag being 'Y') alongside another type of EOC.
The fields causing the issue are primarily the EOC
(Element of Cost) and is_indirect
.
To resolve errors flagged by this DIQ test, review the EOC classifications for accuracy in the affected CA, SLPP, PP, or WP. Ensure that all costs are correctly classified as either direct or indirect according to the project's cost management guidelines, and that indirect costs are collected alongside exactly one other type of EOC, and correct any misclassifications or data entry errors found.
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 DIQ test is performed on the 'DS03 Cost' table to ensure that Control Accounts (CA), Summary Level Planning Packages (SLPP), Planning Packages (PP), or Work Packages (WP) collect Indirect Elements of Cost (EOCs) alongside another EOC type. The purpose of this test is to verify that indirect costs are not isolate from other types of costs within these entities. The importance of this check lies in maintaining the accuracy and clarity of cost reporting and analysis. By ensuring that indirect costs are collected alongside direct costs, it facilitates more accurate cost tracking, allocation, and analysis, which is crucial for effective project management and financial control. The severity level of 'MAJOR' indicates that if indirect costs are isolated from other EOCs, it could likely cause problems during cost analysis or financial reporting, potentially leading to inaccurate project cost assessments or misallocations of funds.
CREATE FUNCTION [dbo].[fnDIQ_DS03_Cost_IsIndirectWorkMissingOtherEOCTypes] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
with NonIndirect AS (
SELECT WBS_ID_CA CAID, ISNULL(WBS_ID_WP,'') WPID
FROM DS03_cost
WHERE upload_ID = @upload_ID AND EOC <> 'Indirect' AND ISNULL(is_indirect,'') <> 'Y'
GROUP BY WBS_ID_CA, ISNULL(WBS_ID_WP,'')
)
SELECT C.*
FROM DS03_Cost C LEFT OUTER JOIN NonIndirect N ON C.WBS_ID_CA = N.CAID AND ISNULL(C.WBS_ID_WP,'') = N.WPID
WHERE upload_ID = @upload_ID
AND (EOC = 'Indirect' OR is_indirect = 'Y')
AND N.CAID IS NULL
)