¶ Basic Information
| Key | Value |
|---|---|
| Table | DS08 WAD |
| Severity | MINOR |
| Unique ID | 1080410 |
| Summary | Is the EVT missing for this WP/PP-level WAD? |
| Error message | EVT is missing 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 "Missing EVT" is designed to identify any instances in the DS08 Work Authorization Document (WAD) where the EVT field is missing or blank. This check is particularly important for Work Package/Planning Package (WP/PP) level WADs, as indicated by the presence of a non-empty WBS_ID_WP field.
The error message "EVT is missing or blank" is triggered when the EVT field is either not filled in or contains only whitespace characters. This could be due to a data entry error or omission during the data input process.
The expected value for the EVT field is a non-empty string. This means that the field should contain some form of alphanumeric characters and should not be left blank or filled with only spaces.
Please ensure that all WP/PP-level WADs have an associated EVT value to maintain the integrity and quality of the data in the DS08 WAD.
¶ Why do we check this?
This test is being performed to check if the Earned Value Technique (EVT) is missing for the Work Package (WP) or Planning Package (PP) level Work Authorization Document (WAD) in the DS08 WAD table. The Earned Value Technique is a crucial component of project management as it measures project performance and progress in an objective manner.
The severity of this test is marked as an MINOR, which means it's not a critical error but could potentially cause minor problems or indicate that the data doesn't adhere to all best practices. The absence of EVT might not halt the data review process, but it could lead to inaccuracies in project performance evaluation and progress tracking. Therefore, it's important to address this issue to ensure the integrity and quality of the project management data.
¶ Code
CREATE FUNCTION [dbo].[fnDIQ_DS08_WAD_IsEVTMissing] (
@upload_id int = 0
)
RETURNS TABLE
AS RETURN
(
SELECT
*
FROM
DS08_WAD
WHERE
upload_ID = @upload_ID
AND TRIM(ISNULL(WBS_ID_WP,'')) <> ''
AND TRIM(ISNULL(EVT,'')) = ''
)