¶ Basic Information
| Key | Value |
|---|---|
| Table | DS04 Schedule |
| Severity | MINOR |
| Unique ID | 1040189 |
| Summary | Is the LOE type mismatched with the EVT for this task? |
| Error message | Task of type = LOE has a mismatched EVT (EVT should be A or blank). |
¶ 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 "LOE Type With Mismatched EVT" is designed to identify any inconsistencies between the Level of Effort (LOE) type and the Earned Value Technique (EVT) for a given task in the DS04 Schedule table.
The LOE type refers to tasks that are ongoing efforts with no definitive end, such as project management or system maintenance. The EVT is a method used to measure the performance and progress of these tasks. For tasks of LOE type, the EVT should either be 'A' or left blank.
If an error is flagged by this DIQ check, it indicates that a task marked as LOE type has an EVT that is neither 'A' nor blank. This inconsistency could be due to a data entry error or a misunderstanding of the LOE and EVT fields.
To resolve this issue, review the tasks identified by the DIQ check and ensure that the EVT for each LOE task is either 'A' or blank. If the EVT is not one of these expected values, it should be corrected to maintain data integrity and quality.
¶ Why do we check this?
This test is being performed on the 'DS04 Schedule' table to check if the Level of Effort (LOE) type is mismatched with the Earned Value Technique (EVT) for a particular task. The Level of Effort is a project management term that refers to the work required to complete a task, while the Earned Value Technique is a method for measuring project performance and progress.
The test is important because a mismatch between the LOE type and the EVT could lead to inaccurate measurements of project performance and progress, which could in turn lead to incorrect decision-making.
The severity of this test is marked as an 'MINOR', which means that while it may not immediately prevent the data from being reviewed, it could potentially cause minor problems or indicate that the data does not adhere to all best practices. Therefore, it is recommended to address this issue to ensure the accuracy and reliability of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS04_Sched_IsLOETypeMismatchedWithEVT] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS04_schedule
WHERE
upload_id = @upload_ID
AND type = 'LOE'
AND TRIM(ISNULL(EVT,'')) NOT IN ('A','')
)