This DIQ list was updated to the latest version of the DID and DIQ specification on 4/29/2024 and is currently up to date. A full list of changes made between v4 and v5 of these DIQs is available here.
The following DIQ (Data Integrity and Quality) Checks are performed on all PARS JSON CPP Uploads after they are uploaded into PARS. Please note that these checks are performed in addition to the JSON validation which confirms data fields are present and correctly formatted - more information on the validation proces can be found here.
Uploads that trip one or more DIQ checks marked as Critical below will not be loaded into PARS, and the data issues must be resolved and the data reuploaded. Checks marked as Major or Minor still represent data concerns, but will not block uploads. Critical, Major, and Minor checks all contribute towards a Data Quality score in development by PM. This score will not be used for Compliance purposes, but may be used to track trends in data quality or to recognize contractors who go above and beyond in achieving high quality data.
DIQs as described here are not used for Compliance purposes. A set of DIQ-C (Compliance) checks is in development which will use a subset of the DIQs here and additional checks along with thresholds to validate EVMS compliance in the future.
DIQs as described here are not used for project performance evaluation. A set of DIQ-P (Performance) checks is in development which will use a subset of the DIQs here and additional checks along with thresholds to evaluate project performance in the future.
While there is no true DS00 in the PARS CPP JSON Format, it's often used as a shorthand for the "metadata" level checks included in every file, the section that includes the PARSID and CPP Status Date fields.
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1000001 | CPP Status Date Missing From Cost Periods | CRITICAL | Is the CPP Status Date missing from the period dates in the cost file? | DS00.CPP_Status_Date not in DS03.period_date list. |
1000002 | CPP Status Date Is After CD-4 | MAJOR | Is the CPP Status Date after CD-4? | DS00.CPP_Status_Date > min DS04.ES_date or EF_date where milestone_level = 190. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1010002 | WBS Level Contiguity | CRITICAL | Are the WBS Levels contiguous in the WBS hierarchy? | WBS level is not contiguous with prior levels in the WBS hierarchy. |
1010016 | CA or SLPP with WP Ancestor | CRITICAL | Is this CA or SLPP at a lower level in the WBS hierarchy than a WP in the same branch? | CA or SLPP found at a lower level in the WBS hierarchy than a WP in the same branch. |
1010017 | CA or WBS Without Child | CRITICAL | Does the Control Account or WBS Type have a child in the WBS hierarchy? | CA or WBS element missing child. |
1010025 | Parent Lower in WBS Hierarchy than Child | CRITICAL | Is the parent lower in the WBS hierarchy than its child? | Parent found at a lower level in the WBS hierarchy than its child, i.e. Parent Level > Child Level. |
1010026 | Parent WBS ID Missing | CRITICAL | Is the Parent WBS ID missing? | Parent WBS ID is missing. |
1010032 | WBS ID Not Unique | CRITICAL | Is the WBS ID repeated across the WBS hierarchy? | WBS ID is not unique across the WBS hierarchy. |
1010033 | Root of WBS hierarchy must be of type WBS | CRITICAL | Is the top element of your WBS hierarchy of a type other than WBS? | Level 1 WBS element not of type WBS. |
1010034 | Root of WBS not unique | CRITICAL | Is the root of the WBS hierarchy (Level 1) unique? | WBS hierarchy contains more than one Level 1 WBS element. |
1010036 | WP or PP At Level 1 or 2 | CRITICAL | Is the WP or PP at Level 1 or 2 in the WBS hierarchy? | WP or PP at Level 1 or 2 in the WBS hierarchy |
1010039 | Parent WBS ID Missing In WBS List | CRITICAL | Is the Parent WBS ID missing in the WBS ID list? | Parent WBS ID not found in the WBS ID list. |
1010003 | CA with CA Child | MAJOR | Does the CA have a CA as a child in the WBS hierarchy? | CA found with child of type CA in the WBS hierarchy. |
1010005 | Single CAM Across WBS Hierarchy | MAJOR | Was only one unique CAM used across the WBS? | Only a single CAM found for all WBS Elements; more than one CAM is required across the WBS hierarchy |
1010006 | Single OBS Across WBS Hierarchy | MAJOR | Was more than one unique OBS_ID used across the WBS? | Only a single OBS_ID found for all WBS Elements; more than one OBS ID is required across the WBS hierarchy |
1010007 | SLPP with Child | MAJOR | Does the SLPP have a child in the WBS hierarchy? | SLPP found with child in the WBS hierarchy. |
1010011 | WP or PP with Child | MAJOR | Does the WP or PP have a child in the WBS hierarchy? | WP or PP found with child in the WBS hierarchy. |
1010014 | CAM Not Consistent in CA Branch | MAJOR | Does the CA have a different CAM from its descendants? | CA and its descendents do not share the same CAM. |
1010015 | CA, WP, or PP Missing CAM | MAJOR | Is the CA, WP, or PP missing a CAM? | CA, WP, or PP is missing a CAM name |
1010018 | Exit Criteria Missing | MAJOR | Is the Exit Criteria missing? | exit_criteria required where type = CA or SLPP. Provide if available for type = WBS, WP, or PP. |
1010019 | External WBS Without Subproject ID | MAJOR | Is the external WBS missing a subproject ID? | External = Y & subproject_ID is missing or blank. |
1010020 | Title Equal to Narrative | MAJOR | Are the Title and Narrative the same? | Narrative is not distinct from the Title (Narrative should be your scope paragraph from your WBS Dictionary) |
1010021 | Insufficient WBS Narrative | MAJOR | Is the narrative only one word? | Narrative is only one word. |
1010022 | OBS ID Missing | MAJOR | Is the OBS_ID null or blank? | OBS ID is missing |
1010028 | PM Name Inconsistent | MAJOR | Is the PM name inconsistent for SLPPs and high-level WBSs? | The CAM name for SLPPs and high-level WBSs is not consistent. (Note: At high levels, the value in the CAM field should represent the PM.) |
1010030 | Title Not Unique | MAJOR | Does the Title appear more than once across the WBS hierarchy? | WBS Title is not unique across the WBS hierarchy. |
1010031 | WBS ID Missing Delimiters | MAJOR | Is the WBS ID missing delimiters? | WBS ID is missing delimiters (periods recommended). |
1010035 | WPM Name Found on WBS, CA, or SLPP | MAJOR | Is the WPM name attached to a WBS, CA, or SLPP? | WPM name found for WBS, CA, or SLPP (WP or PP only) |
9010002 | WP / PP Missing WAD | MAJOR | Is this WP / PP missing a WAD? | WBS_ID not in DS08.WBS_ID_WP list. |
9010004 | Different CAM Name from DS04 | MAJOR | Does the CAM name for this WBS differ from what is in DS04? | CAM name differs between DS01 and DS04. |
9010013 | WP or PP Missing from Cost | MAJOR | Is this WP or PP WBS ID missing in cost? | WBS_ID where type = WP or PP missing in DS03.WBS_ID_WP list (where BCWSi_Dollars, Hours, or FTEs > 0). |
9010014 | CA or SLPP Missing from Cost | MAJOR | Is this CA or SLPP WBS ID missing in cost? | WBS_ID where type = CA or SLPP missing in DS03.WBS_ID_CA list (where BCWSi_Dollars, Hours, or FTEs > 0). |
9010015 | WP or PP Missing from Schedule (FC) | MAJOR | Is this WP or PP WBS ID missing in your forecast schedule? | WBS_ID where type = WP or PP missing in DS04.WBS_ID list where schedule_type = FC. |
9010016 | WP or PP Missing from Schedule (BL) | MAJOR | Is this WP or PP WBS ID missing in your baseline schedule? | WBS_ID where type = WP or PP missing in DS04.WBS_ID list where schedule_type = BL. |
9010023 | OBS ID Missing in DS02 OBS List | MAJOR | Is the OBS ID missing in DS02 OBS? | OBS ID missing in the DS02 OBS ID list |
9010030 | CA WBS ID Missing in WAD List | MAJOR | Is this CA missing in the WAD list? | WBS_ID where DS01.type = CA not in DS08.WBS_ID list. |
1010008 | WBS ID contained in Title | MINOR | Is the WBS ID contained in the title? | WBS Titles should not contain the WBS ID. |
1010009 | WBS ID with Adjacent Letters | MINOR | Does the WBS ID contain letters side by side? | WBS ID contains letters adjacent to one another. |
1010010 | WPM Name Matches CAM | MINOR | Is the WPM name the same as the CAM name? | WPM name is the same as the CAM name for this WBS |
1010013 | BWC ID Found on CA or WBS | MINOR | Is there a BWC ID for a WBS element of type CA or WBS? | BWC ID found on WBS element of type CA or WBS |
1010027 | Parent WBS ID Missing From Child WBS ID | MINOR | Is the Parent WBS ID missing from the Child WBS ID? | Parent WBS ID was not not found in the Child WBS ID. |
1010037 | WP or PP Missing CA Ancestor | MINOR | Is a CA missing from the ancestry tree of this WP or PP? | WP or PP missing CA ancestry tree |
9010001 | WP or PP Missing EU | MINOR | Is this WP or PP missing in the WBS EU log? | WBS_ID not in DS17.WBS_ID list where DS01.type = WP or PP. |
9010029 | Subproject ID Missing in Schedule | MINOR | Is the subproject ID missing in the schedule? | Subproject ID missing in DS04 Schedule |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1020039 | OBS Levels Not Contiguous | CRITICAL | Are the OBS levels contiguous in the OBS hierarchy? | OBS level is not contiguous with prior levels in the OBS hierarchy. |
1020045 | OBS ID Not Unique | CRITICAL | Is the OBS ID repeated across the OBS hierarchy? | OBS ID is not unique across the OBS hierarchy. |
1020047 | Root of OBS Not Unique | CRITICAL | Is the root of the OBS hierarchy (Level 1) unique? | OBS hierarchy contains more than one Level 1 OBS element. |
1020048 | Parent Lower in OBS Hierarchy than Child | CRITICAL | Is the parent lower in the OBS hierarchy than its child? | Parent found at a lower level in the OBS hierarchy than its child, i.e. Parent Level > Child Level. |
1020050 | Parent OBS ID Missing In OBS List | CRITICAL | Is the Parent OBS ID missing in the OBS ID list? | Parent OBS ID not found in the OBS ID list. |
1020040 | Title Contains OBS ID | MAJOR | Does the Title contain the OBS ID? | OBS ID found within OBS Title. |
1020042 | Title Equal to Narrative | MAJOR | Are the Title and Narrative the same? | Narrative is not distinct from the Title |
1020049 | Parent OBS ID Missing | MAJOR | Is the Parent OBS ID missing? | Parent OBS ID is missing. |
1020052 | Title Not Unique | MAJOR | Does the Title appear more than once across the OBS hierarchy? | OBS Title is not unique across the OBS hierarchy. |
1020043 | Narrative Missing | MINOR | Is the OBS narrative missing? | Narrative is missing. |
9020041 | CA Marked as External | MINOR | Is this CA marked as external? | CA is marked as external. |
9020046 | OBS ID Missing in DS01 OBS List | MINOR | Is the OBS ID missing in the DS01 OBS List? | OBS ID is missing in the DS02 OBS ID list. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1030058 | Actuals At CA and WP Level | CRITICAL | Are actuals collected at both the CA and WP level? | CAs and WPs found with ACWPi <> 0 (Dollars, Hours, or FTEs) |
1030072 | WP or PP with Multiple EVT Groups | CRITICAL | Does this WP or PP have more than one EVT group? | WP or PP where EVT group is not uniform (EVTs are not all LOE, Discrete, Apportioned, or Planning Package for this WP or PP data). |
1030077 | Apportioned To WBS ID Missing | CRITICAL | Is the WBS ID to which this work is apportioned missing? | EVT = J or M but EVT_J_to_WBS_ID is missing. |
1030106 | WP or PP Found Across Multiple CAs | CRITICAL | Is the WP or PP found across multiple Control Accounts? | WBS_ID_WP found across distinct WBS_ID_CA. |
1030108 | Non-Unique Cost Row | CRITICAL | Is this row duplicated by period date, CA WBS ID, WP WBS ID, EOC, EVT, & is_indirect? | Count of period_date, WBS_ID_CA, WBS_ID_WP, EOC, EVT, is_indirect combo > 1. |
9030061 | Performance On SLPP, CA, or PP | CRITICAL | Has this SLPP, CA, or PP collected performance? | SLPP, CA, or PP found with BCWPi <> 0 (Dollars, Hours, or FTEs). |
9030062 | CA with Budget | CRITICAL | Does this CA have budget? | CA found with BCWSi > 0 (Dollars, Hours, or FTEs). |
9030078 | Apportionment IDs Mismatch Between Cost and Schedule | CRITICAL | Is the WBS ID to which this work is apportioned mismatched in cost and schedule? | EVT = J or M where EVT_J_to_WBS_ID does not equal the WBS ID in Schedule. |
1030059 | Future Actuals | MAJOR | Were actuals collected in the future? | ACWPi <> 0 (Dollars, Hours, or FTEs) and period_date > cpp_status_date. |
1030060 | Future Performance | MAJOR | For this WP, was performance collected in the future? | WP found with BCWPi <> 0 (Dollars, Hours, or FTEs) and period_date > cpp_status_date. |
1030064 | Estimates in the Past | MAJOR | Are there estimates still showing in previous periods? | ETCi <> 0 (Dollars, Hours, or FTEs) where period_date <= CPP_Status_Date. |
1030067 | BCWSi <> BCWPi for LOE | MAJOR | Is there a delta between BCWS and BCWP for this LOE work? | BCWSi <> BCWPi for LOE work (Dollar, Hours, or FTEs). |
1030074 | 0-100 Budget Spread Improperly | MAJOR | Is the budget for this 0-100 work spread across more than a one period? | 0-100 work found with BCWSi > 0 (Dollar, Hours, or FTEs) in more than one period. |
1030075 | 50-50 Budget Spread Improperly | MAJOR | Is the budget for this 50-50 work spread improperly? (Must be across two consecutive periods and with the same value.) | 50-50 work (EVT = E) where BCWSi (Dollar, Hours, or FTEs) was found in either one period only or more than two, non-consecutive periods more than 45 days apart, or spread unevenly. |
1030079 | Negative Performance | MAJOR | Does this WP or PP have negative performance? | WP or PP found with BCWPi < 0 (Dollars, Hours, or FTEs). |
1030080 | Negative Budget | MAJOR | Does this WP or PP have negative budget? | WP or PP found with BCWSi < 0 (Dollars, Hours, or FTEs). |
1030084 | Negative Estimates | MAJOR | Does this CA, WP, or PP have negative estimates? | CA, WP, or PP found with ETCi < 0 (Dollars, Hours, or FTEs). |
1030086 | EVT Justification Missing | MAJOR | Is this WP or PP missing an EVT Justification? | EVT Justification is missing for EVT = B,G, H, J, L, M, N, O, or P. |
1030087 | EVT Missing | MAJOR | Is this WP or PP missing an EVT? | EVT is missing. |
1030099 | Estimates On Completed Work | MAJOR | Are there estimates on this WP even though it is complete? | ETCi <> 0 (Dollars, Hours, or FTEs) on completed work (BCWPc / BCWSc > 99%). |
1030109 | Invalid Use of NA EVT | MAJOR | Has EVT of type NA been selected for non-Control Account data? | EVT = NA on WP row or CA row not marked as type 'CA' in DS01 (WBS). |
9030057 | Cost Periods Not One Month Apart | MAJOR | Is this period date less than 20 or more than 36 days apart from either the previous or next period? | Period_date is not within 20-36 days from previous or next period. |
9030065 | Estimates on PP or CA | MAJOR | Are there estimates on this CA or PP? | CA or PP with ETCi <> 0 (Dollars, Hours, or FTEs). |
9030071 | SLPP or PP with Actuals | MAJOR | Does this SLPP or PP have actuals? | SLPP or PP found with ACWPi <> 0 (Dollars, Hours, or FTEs). |
9030072 | WP or PP Missing In FC Schedule | MAJOR | Is this WP or PP missing in the FC Schedule? | WBS_ID_WP missing from DS04.WBS_ID list (where schedule_type = FC). |
9030074 | VAC without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the VAC is tripping the unfavorable dollar threshold? | abs(BCWSi_dollars - ACWPi_dollars - ETCi_dollars) > abs(DS07.threshold_cost_VAC_dollar_unfav) & DS11.narrative_overall is missing or blank where DS11.narrative_type = 120 (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030082 | CA Missing In WBS | MAJOR | Is this CA missing in the WBS (DS01)? | The CA WBS ID was not found in the WBS (DS01). |
9030083 | CA Type Mismatched With WBS Dictionary | MAJOR | Is this Control Account WBS ID typed as something other than CA in the WBS Dictionary? | WBS_ID_CA not in DS01.WBS_ID list where DS01.type = CA. |
9030096 | SLPP or PP Type Mismatch with DS01 (WBS) | MAJOR | Is this SLPP or PP mistyped in DS01 (WBS)? | EVT = K but DS01 (WBS) type is not SLPP or PP. (Note: This flag also appears if DS01 type = PP but no WP ID is missing and if type = SLPP but a WP ID was found.) |
9030100 | Cost Missing Resources | MAJOR | Is this WP or PP missing accompanying Resources (DS06) by EOC? | WP or PP with BCWSi <> 0 (Dollars, Hours, or FTEs) is missing Resources (DS06) by EOC. |
9030101 | WP / PP Missing in WBS Dictionary | MAJOR | Is this WP WBS / PP ID missing in the WBS Dictionary? | WBS_ID_WP missing from DS01.WBS_ID list. |
9030102 | WP or PP Missing In BL Schedule | MAJOR | Is this WP or PP missing in the BL Schedule? | WBS_ID_WP missing from DS04.WBS_ID list (where schedule_type = BL). |
9030104 | WP or PP Type Mismatch with Type in WBS Dictionary | MAJOR | Is this Work Package or Package typed as something other than WP or PP in the WBS Dictionary? | WBS_ID_WP found DS01.WBS_ID where type <> PP or WP. |
9030105 | WP or PP Parent Mismatched with DS01 (WBS) Parent | MAJOR | Is the parent ID of this WP or PP misaligned with what is in DS01 (WBS)? | The parent ID for this WP or PP does not align with the parent ID found in DS01 (WBS). |
9030311 | Incremental CV without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental CV is tripping the favorable dollar threshold? | DS03.CVi abs(BCWPi - ACWPi) > abs(DS07.threshold_cost_inc_dollar_fav) & DS11.narrative_RC_CVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030312 | CV without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the CV is tripping the favorable dollar threshold? | DS03.CVc abs(BCWP - ACWP) > abs(DS07.threshold_cost_cum_dollar_fav) & DS11.narrative_RC_CVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030313 | CV without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the CV is tripping the unfavorable dollar threshold? | DS03.CVc abs(BCWP - ACWP) > abs(DS07.threshold_cost_cum_dollar_unfav) & DS11.narrative_RC_CVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030314 | CV Percent without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the CV percent is tripping the favorable percent threshold? | DS03.CVc % abs((BCWP - ACWP) / BCWP) > abs(DS07.threshold_cost_cum_dollar_fav) & DS11.narrative_RC_CVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030315 | CV Percent without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the CV percent is tripping the unfavorable percent threshold? | DS03.CVc % abs((BCWP - ACWP) / BCWP) > abs(DS07.threshold_cost_cum_dollar_unfav) & DS11.narrative_RC_CVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030316 | SV without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the SV is tripping the favorable dollar threshold? | DS03.SVc abs(BCWP - BCWS) > abs(DS07.threshold_schedule_cum_dollar_fav) & DS11.narrative_RC_SVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030317 | SV without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the SV is tripping the unfavorable dollar threshold? | DS03.SVc abs(BCWP - BCWS) > abs(DS07.threshold_schedule_cum_dollar_unfav) & DS11.narrative_RC_SVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030318 | SV Percent without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the SV percent is tripping the favorable percent threshold? | DS03.SVc % abs((BCWP - BCWS) / BCWS) > abs(DS07.threshold_schedule_cum_pct_fav) & DS11.narrative_RC_SVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030319 | SV Percent without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the SV percent is tripping the unfavorable percent threshold? | DS03.SVc % abs((BCWP - BCWS) / BCWS) > abs(DS07.threshold_schedule_cum_pct_unfav) & DS11.narrative_RC_SVc is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030320 | VAC without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the VAC is tripping the favorable dollar threshold? abs(BCWSi_dollars - ACWPi_dollars - ETCi_dollars) > abs(DS07.threshold_cost_VAC_dollar_fav) & DS11.narrative_overall is missing or blank where DS11.narrative_type = 120 (by DS03.WBS_ID_CA & DS11.WBS_ID). | |
9030321 | Incremental CV without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental CV is tripping the unfavorable dollar threshold? | DS03.CVi abs(BCWPi - ACWPi) > abs(DS07.threshold_cost_inc_dollar_unfav) & DS11.narrative_RC_CVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030322 | Incremental CV Percent without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental CV percent is tripping the favorable percent threshold? | DS03.CVi abs((BCWPi - ACWPi) / BCWPi) > abs(DS07.threshold_cost_inc_pct_fav) & DS11.narrative_RC_CVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030323 | Incremental CV Percent without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental CV percent is tripping the unfavorable percent threshold? | DS03.CVi abs((BCWPi - ACWPi) / BCWPi) > abs(DS07.threshold_cost_inc_pct_unfav) & DS11.narrative_RC_CVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030324 | WP / PP EVT Misaligned with WAD | MAJOR | Is the EVT for this WP or PP misaligned with the EVT in the WAD? | DS03.EVT <> DS08.EVT (by WBS_ID_WP). |
9030325 | Incremental SV without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental SV is tripping the favorable dollar threshold? | DS03.SVi abs(BCWPi - BCWSi) > abs(DS07.threshold_schedule_inc_dollar_fav) & DS11.narrative_RC_SVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030326 | Incremental SV without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental SV is tripping the unfavorable dollar threshold? | DS03.SVi abs(BCWPi - BCWSi) > abs(DS07.threshold_schedule_inc_dollar_unfav) & DS11.narrative_RC_SVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030327 | Incremental SV Percent without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental SV percent is tripping the favorable percent threshold? | DS03.SVi abs((BCWPi - BCWSi) / BCWSi) > abs(DS07.threshold_schedule_inc_pct_fav) & DS11.narrative_RC_SVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030328 | Incremental SV Percent without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the incremental SV percent is tripping the unfavorable percent threshold? | DS03.SVi abs((BCWPi - BCWSi) / BCWSi) > abs(DS07.threshold_schedule_inc_pct_unfav) & DS11.narrative_RC_SVi is missing or blank (by DS03.WBS_ID_CA & DS11.WBS_ID). |
9030329 | VAC Percent without Root Cause Narrative (Favorable) | MAJOR | Is a root cause narrative missing for this CA where the VAC % is tripping the favorable percent threshold? abs((BCWSi_dollars - ACWPi_dollars - ETCi_dollars) / BCWSi_dollars) > abs(DS07.threshold_cost_VAC_pct_fav) & DS11.narrative_overall is missing or blank where DS11.narrative_type = 120 (by DS03.WBS_ID_CA & DS11.WBS_ID). | |
9030330 | VAC Percent without Root Cause Narrative (Unfavorable) | MAJOR | Is a root cause narrative missing for this CA where the VAC % is tripping the unfavorable percent threshold? abs((BCWSi_dollars - ACWPi_dollars - ETCi_dollars) / BCWSi_dollars) > abs(DS07.threshold_cost_VAC_pct_unfav) & DS11.narrative_overall is missing or blank where DS11.narrative_type = 120 (by DS03.WBS_ID_CA & DS11.WBS_ID). | |
1030046 | Incommensurate Future Budget & Estimates | MINOR | Is there more than a 50% delta between future BCWS & ETC dollars for this chunk of work? (Or, if BCWS is missing, is there at least $1,000 of ETC without BCWSi?) | abs((BCWSi_dollars - ETCi_dollars) / BCWSi_dollars) > .5 (or ETCi_dollars > 1000 where BCWSi = 0) where period_date > CPP_status_date. |
1030063 | CC Found Without CC Description | MINOR | Is there are CC without an accompanying description? | CC ID found without an accompanying CC description |
1030066 | Estimates Found A Year or More After Last Recorded Budget | MINOR | Does this WP or PP show estimates a year or more after the last recorded period of budget? | Last period_date where ETCi <> 0 is twelve or more months after last period_date of BCWSi <> 0 (on Dollars, Hours, or FTEs). |
1030076 | Negative Actuals | MINOR | Does this CA, WP, or PP have negative actuals? | CA, WP, or PP found with ACWPi < 0 (Dollars, Hours, or FTEs). |
1030081 | Budget Missing | MINOR | Is this WP or PP missing budget? | WP or PP found with BCWSi = 0 (on Dollars, or Hours / FTEs where EOC = Labor). |
1030085 | 100-0 EVT | MINOR | Does this work use a 100-0 EVT? | 100-0 EVT (EVT = G) used (This is not recommended). |
1030088 | Labor Missing Actuals | MINOR | Is this Labor missing Actual Dollars, Hours, or FTEs? | EOC = Labor with ACWPi <> 0 for either Dollars, Hours, or FTEs, but where at least one other ACWPi = 0. |
1030089 | Labor Missing Performance | MINOR | Is this Labor missing Performance Dollars, Hours, or FTEs? | EOC = Labor with BCWPi <> 0 for either Dollars, Hours, or FTEs, but where at least one other BCWPi = 0. |
1030091 | Labor Missing Estimates | MINOR | Is this Labor missing Estimated Dollars, Hours, or FTEs? | EOC = Labor with ETCi <> 0 for either Dollars, Hours, or FTEs, but where at least one other ETCi = 0. |
1030097 | Zero SPAEcum | MINOR | Is this WBS missing Budget, Performance, Actuals, and Estimates? | Cumulative BCWS, BCWP, ACWP, and ETC are all equal to zero for this piece of work (Dollars, Hours, and FTEs). |
9030056 | Cost Estimates After PMB End | MINOR | Is there estimated work after the PMB end? | Period_date of last recorded ETCi (Dollars, Hours, or FTEs) > DS04.ES_Date for milestone_level = 175. |
9030068 | PP Starting Within 4-6 Months | MINOR | Is this PP scheduled to start within 4-6 months? | PP with BCWSi > 0 (Dollar, Hours, or FTEs) and period_date within 4-6 months of CPP Status Date. |
9030070 | Reprogramming Without OTB/OTS Date | MINOR | Is there BAC, CV, or SV repgrogramming but not OTB/OTS Date? | BAC_rpg, CV_rpg, or SV_rpg <> 0 but without OTB_OTS_Date in DS07 (IPMR Header). |
9030073 | Cost Periods Found After CD-4 Approved | MINOR | Are there period dates after CD-4 approved? | Period Dates found after CD-4 approved (DS04.milestone_level = 190). |
9030095 | Cost Period After PMB End | MINOR | Is this period date after PMB end? | Period_date > DS04.ES_Date for milestone_level = 175. |
1030116 | Inconsistent Use of Indirect | CRITICAL | Is indirect distributed inconsistently? | Possible Reasons: 1) indirect actuals found where is_indirect = Y, and both EOC = Indirect and EOC <> Indirect are used; 2) is_indirect utilized in some WPs/CAs and missing in others; 3) indirect actuals found at both the CA & WP levels; 4) data found where is_indirect = N but EOC = Indirect. |
1030094 | Insufficient Indirect | MAJOR | Is this WP or PP lacking sufficient Indirect? (Minimally 10% of the total budget by period) | BCWSi_dollars/hours/FTEs for this WP or PP makes up less than 10% of total budget for this period (on Dollars, Hours, or FTEs). |
1030095 | Material Found Alongside Non-Overhead EOCs | MAJOR | Does this WP/PP comingle Material with other EOC types (excluding Indirect)? | EOC = Material & Subcontract, ODC, or Labor by WBS_ID_WP. |
1030098 | Indirect Not Mingled With Other EOCs | MAJOR | Does this CA, SLPP, PP, or WP have only Indirect EOCs? | CA, SLPP, PP, or WP with only Indirect. |
1030112 | Subcontract Found Alongside Non-Indirect EOC | MAJOR | Does this WP/PP mingle Subcontract with other EOC types (excluding Indirect)? | EOC = Subcontract & Material, ODC, or Labor by WBS_ID_WP. |
1030113 | ODC Found Alongside Non-Indirect EOC | MAJOR | Does this WP/PP mingle ODC with other EOC types (excluding Indirect)? | EOC = ODC & Material, Subcontract, or Labor by WBS_ID_WP. |
1030115 | Improper Collection of Indirect | MAJOR | Is indirect collected at the CA level or via the EOC field (rather than using is_indirect)? | EOC = Indirect, is_indirect missing, or is_indirect = Y/N found at the CA level (where WBS_ID_WP is blank). |
1030117 | Labor Found Alongside Non-Indirect EOC | MAJOR | Does this WP/PP mingle Labor with other EOC types (excluding Indirect)? | EOC = Labor & Material, Subcontract, or ODC by WBS_ID_WP. |
1060269 | CA WBS Matches WP WBS | MAJOR | Do the CA & WP WBS IDs match? | WBS_ID_CA = WBS_ID_WP |
1030114 | Indirect With Hours and/or FTEs | MINOR | Does this indirect have hours or FTEs? | EOC = 'Indirect' or is_indirect = 'Y' AND (BCWSi, BCWPi, ACWPi, or ETCi hours or FTEs > 0) |
UID | Title | Summary | Error Message |
---|---|---|---|
1040117 | BL Task With Negative Free Float | CRITICAL | Does this BL task have negative free float? |
1040118 | BL Task With Negative Total Float | CRITICAL | Does this BL task have negative total float? |
1040139 | Activity Missing EVT | CRITICAL | Is this activity missing an EVT? |
1040141 | Missing Apportioned To Task ID | CRITICAL | Is this apportioned task missing an apportioned to task ID? |
1040206 | Approve Finish Project Milestone Missing in Baseline | CRITICAL | Is your baseline schedule missing the approve finish project milestone? |
1040207 | Approve Finish Project Milestone Missing in Forecast | CRITICAL | Is your forecast schedule missing the approve finish project milestone? |
1040208 | Approve Start Project Milestone Missing in Baseline | CRITICAL | Is your baseline schedule missing the approve start project milestone? |
1040209 | Approve Start Project Milestone Missing in Forecast | CRITICAL | Is your forecast schedule missing the approve start project milestone? |
1040210 | Schedule Missing | CRITICAL | Is your schedule data missing either the BL or FC schedule? |
1040215 | Duplicate Task ID | CRITICAL | Is this task duplicated in the schedule? |
1040220 | WBS Misaligned Between FC & BL | CRITICAL | Is the WBS ID for this task misaligned between the FC & BL schedules? |
1040107 | CD / BCP Milestones Out of Sequence | MAJOR | Is this CD or BCP out of sequence chronologically in the milestone list? |
1040114 | Comingling of SVT & Non-SVT | MAJOR | Does this WBS comingle SVT & Non-SVT tasks? |
1040115 | Activity with Original Duration of Zero | MAJOR | Does this activity have an original duration of zero? |
1040119 | Completed Activity with Zero Actual Duration | MAJOR | Does this completed activity have an actual duration of zero? |
1040121 | Completed Task with Remaining Duration | MAJOR | Does this completed task have remaining duration? |
1040123 | Discrete Task Without Non-Physical % Complete Type | MAJOR | Does this discrete task have a % Complete type that is not Physical? |
1040124 | WBS Summary Task or Milestone with EVT | MAJOR | Does this WBS Summary task or Start/Finish Milestone have an EVT? |
1040125 | Hard Constraint Found | MAJOR | Is there a hard constraint on this task? |
1040126 | LOE Task without Duration % Complete | MAJOR | Does this LOE task have a % Complete type other than Duration? |
1040127 | Milestone with Non-Zero Duration | MAJOR | Does this milestone have a non-zero duration? |
1040128 | Milestone % Complete Not Equal To 0 Or 100% | MAJOR | Does this milestone have a % Complete other than 0 or 100%? |
1040130 | RPG Without Approve Repgrogramming Milestone | MAJOR | Does RPG exist without an an approve repgrogramming milestone? |
1040132 | SVT or ZBA with EVT | MAJOR | Does this SVT or ZBA have an EVT? |
1040133 | SVT Not Of Allowed Milestone Type | MAJOR | Is this non-milestone task marked as an SVT? |
1040135 | WBS With Only ZBA Tasks | MAJOR | Does this WBS have only ZBA tasks? |
1040143 | Actual Start Later Than Actual Finish | MAJOR | Does this task have an Actual Start later than the Actual Finish? (FC) |
1040145 | Baseline Task Missing In Forecast | MAJOR | Is this task missing in the forecast schedule? |
1040150 | CD-0 Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the CD-0 milestone? |
1040151 | CD-0 Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the CD-0 milestone? |
1040152 | CD-1 Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the CD-1 milestone? |
1040153 | CD-1 Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the CD-1 milestone? |
1040154 | CD-2 Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the CD-2 milestone? |
1040155 | CD-2 Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the CD-2 milestone? |
1040156 | CD-3 Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the CD-3 milestone? |
1040157 | CD-3 Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the CD-3 milestone? |
1040158 | CD-4 Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the CD-4 milestone? |
1040159 | CD-4 Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the CD-4 milestone? |
1040162 | Contract Completion Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the Contract Completion milestone? |
1040163 | Contract Completion Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the Contract Completion milestone? |
1040166 | Actual Finish Prior to Early Finish Along the Driving Path | MAJOR | Does this FC task along the Driving Path have an Actual Finish earlier than the BL Early Finish? |
1040167 | Actual Start Prior to Early Start Along the Driving Path | MAJOR | Does this task along the Driving Path have an Actual Start earlier than the Early Start? (BL) |
1040168 | Duration % Complete Type On Non-LOE Task | MAJOR | Is this non-LOE task using a Duration % Complete type? |
1040169 | Early Finish Later Than Late Finish | MAJOR | Is the early finish after the late finish? |
1040171 | End of PMB Milestone Missing in Baseline | MAJOR | Is your baseline schedule missing the End of PMB milestone? |
1040172 | End of PMB Milestone Missing in Forecast | MAJOR | Is your forecast schedule missing the End of PMB milestone? |
1040173 | Early Start Later Than Early Finish | MAJOR | Is the early start later than the early finish? |
1040174 | Early Start Later Than Late Start | MAJOR | Is the early start later than the late start? |
1040176 | EVT Missing Justification | MAJOR | Is this task missing a required justification for the selected EVT? |
1040177 | EVT Misaligned Between BL & FC | MAJOR | Is the EVT for this task misaligned between BL & FC schedules? |
1040179 | Actual Start Missing on Finished Task | MAJOR | Is this task missing an Actual Start even though it has an Actual Finish? (FC) |
1040180 | Hard Constraint Missing Date | MAJOR | Is this hard constraint missing a constraint date? |
1040181 | Hard Constraint Missing Justification | MAJOR | Does this task have a hard constraint without a justification? |
1040186 | LOE Mingled With Other EVT Types | MAJOR | Is LOE mingled with other EVT types for this WBS? |
1040188 | LOE or WBS Summary Task On Driving Path | MAJOR | Is this LOE or WBS summary task on the driving path? |
1040190 | Late Start Later Than Late Finish (FC) | MAJOR | Is the late start date later than the late finish? (FC) |
1040191 | Major Milestone Not Coded As SVT | MAJOR | Is this major milestone not coded as an SVT? |
1040192 | Milestone Prior To Approve Start Project | MAJOR | Is this milestone earlier than the Approve Start Project Milestone? |
1040193 | Milestone After Approve Finish Project | MAJOR | Is this milestone after the Approve Finish Project Milestone? |
1040195 | Milestone Typed Improperly | MAJOR | Is this milestone not typed as a start or finish milestone? |
1040199 | Completed Task Missing Actual Finish | MAJOR | Is this completed task (physical, units, or duration % complete = 100%) missing an Actual Finish? |
1040200 | Started Task Missing Actual Start | MAJOR | Is this task with a non-zero % Complete missing an Actual Start? |
1040226 | ZBA Not Coded As Subcontract Alignment Milestone | MAJOR | Should this ZBA be coded as a subcontract alignment milestone? |
9040140 | Actual Finish Misaligned With Cost (WP) | MAJOR | Is the actual finish for this WP misaligned with last recorded ACWP or BCWP in cost? |
9040144 | Actual Start Misaligned With Cost (WP) | MAJOR | Is the actual start for this WP misaligned with last recorded ACWP or BCWP in cost? |
9040149 | Actual Finish Misaligned With Cost (CA) | MAJOR | Is the actual finish for this WBS misaligned with what is in cost? (Note: Comparison is at the CA WBS level, where ACWP has been collected) |
9040150 | Actual Start Misaligned With Cost (CA) | MAJOR | Is the actual start for this WBS misaligned with what is in cost? (Note: Comparison is at the CA WBS level, where ACWP has been collected) |
9040151 | BCP Missing in Change Control | MAJOR | Is this BCP missing an entry in the Change Control log? |
9040170 | Finish Date Misaligned With Cost | MAJOR | Is the early finish date for this WBS misaligned with what is in cost (DS03)? |
9040175 | Start Date Misaligned With Cost | MAJOR | Is the early start date for this WBS misaligned with what is in cost (DS03)? |
9040182 | HDV CI ID Missing in HDV CI List | MAJOR | Is this HDV CI ID missing in the HDV CI list (DS14)? |
9040196 | Milestone With Resources | MAJOR | Is this milestone resource-loaded? |
9040198 | WBS Justification Missing | MAJOR | Is non-WP, PP, or SLPP WBS type missing a justification? |
9040200 | WBS Summary Task with Logic | MAJOR | Does this WBS Summary task have logic? |
9040212 | Subproject Mismatch with WBS Dictionary | MAJOR | Is this subproject ID mismatched with what is in DS01 (WBS)? |
9040214 | Resource Loaded SVT or ZBA | MAJOR | Is this SVT or ZBA resource loaded? |
9040216 | Missing Logic | MAJOR | Is this task missing logic? |
9040217 | Missing Resources | MAJOR | Is this task missing resources (DS06)? |
9040219 | Task With Units % Complete Not Materially Resource Loaded | MAJOR | Does this task with units % complete have resources with an EOC other than material? |
9040222 | WBS Missing in WBS Dictionary | MAJOR | Is this WBS ID missing in the WBS Dictionary? |
9040223 | WBS Missing in Cost | MAJOR | Is this WBS ID missing in Cost? |
9040224 | WBS Summary With Resources | MAJOR | Is this WBS Summary resource-loaded? |
9040278 | EVT Mismatch | MAJOR | Is this task's EVT mismatched with what is in cost? |
9040280 | Reprogramming Missing in CC Log Detail (WP) | MAJOR | Is this Work or Planning Planning with reprogramming missing in the CC Log detail? |
1040113 | Task Starts or Finishes after End of PMB | MINOR | Is this task forecasted to start or finish after the end of the PMB? |
1040122 | Task Description Contains Task ID | MINOR | Does the description contain the task ID? |
1040131 | Soft Constraint Found | MINOR | Is there a soft constraint on this task? |
1040136 | Multiple Replanning Milestones In Current Period | MINOR | Do multiple replanning milestones exist in the current period? |
1040137 | Multiple Reprogramming Milestones In Current Period | MINOR | Do multiple reprogramming milestones exist in the current period? |
1040138 | Actual & Remaining Durations Sum to More Than Original | MINOR | Do the actual and remaining durations sum to more than the original? |
1040142 | Actual Start Earlier Than Early Start | MINOR | Does this task have an Actual Start earlier than the Early Start? (FC) |
1040160 | Duplicate CD or BCP Entry | MINOR | Does this CD or BCP appear more than once in the schedule? |
1040161 | Insufficient Constraint Justification | MINOR | Is a sufficient justification lacking for the constraint on this task? |
1040164 | Duplicate Description | MINOR | Is the description for this task duplicated? |
1040165 | Insufficient Description | MINOR | Is the task lacking a proper description? |
1040178 | Forecast Task Missing In Baseline | MINOR | Is this task missing in the baseline schedule? |
1040183 | Insufficient High Float Justification | MINOR | Is a sufficient justification lacking for this task with high float? |
1040184 | High Float Missing Justification (FC) | MINOR | Is this FC task with high float missing a justification in the forecast schedule? |
1040185 | Insufficient Lag Justification | MINOR | Is a sufficient justification lacking for this task with lag? |
1040189 | LOE Type With Mismatched EVT | MINOR | Is the LOE type mismatched with the EVT for this task? |
1040194 | Insufficient Milestone Level Description | MINOR | Is a sufficient milestone level description lacking for this milestone? |
1040197 | Non-CD or BCP Milestone Missing Description | MINOR | Is this non-CD or BCP milestone missing a description? |
1040201 | Units % Complete Type Utilized | MINOR | Is this task using a Units % Complete type? |
1040202 | Planned/Estimated Completion Misaligned with End of PMB | MINOR | Are the start/finish dates between the Planned/Estimated Completion and End of PMB milestones misaligned? |
1040204 | Post-CD3 Project Milestone Not Coded As Finish Milestone | MINOR | Is this major post-CD3 milestone not coded as a finish milestone? |
1040205 | Pre-CD3 Project Milestone Not Coded As Start Milestone | MINOR | Is this major pre-CD3 milestone not coded as a start milestone? |
1040211 | Soft Constraint Missing Date | MINOR | Is this soft constraint missing a constraint date? |
1040221 | Insufficient WBS Justification | MINOR | Is a sufficient WBS justification lacking for this task? |
1040228 | BCP Milestones Without Reprogramming | MINOR | Has a BCP occurred without reprogramming tasks? (FC) |
1040229 | BCP Milestones Without Reprogramming | MINOR | Has a BCP occurred without reprogramming tasks? (BL) |
1040230 | Soft Constraint Missing Justification | MINOR | Does this task have a soft constraint without a justification? |
1040321 | CD-4 Early Start or Finish Dates Misaligned Between FC & BL | MINOR | Are the early start or finish dates for the CD-4 milestone misaligned between FC & BL? |
1040603 | High Float Missing Justification (BL) | MINOR | Is this BL task with high float missing a justification in the baseline schedule? |
1040604 | Calculated & Original Durations Misaligned | MINOR | Is the calculated duration substantially different from the original duration? |
1040605 | WBS Summary Task | MINOR | Is this a WBS Summary task? |
9040116 | Quantitative Risk Analysis Confidence Level for Cost Below 95% Following BCP | MINOR | Is the quantitative risk analysis confidence level for cost below 95% following a BCP? |
9040129 | Replan or Repgramming Milestone Without OTB/OTS Date | MINOR | Does this replanning or reprogramming milestone exist without an OTB/OTS Date? |
9040134 | SVT With Logic | MINOR | Does this SVT have logic? |
9040146 | Calendar Name Missing in DS19 (Schedule Calendar STD) | MINOR | Is this calendar name missing in DS19? |
9040148 | CAM Misaligned with DS01 (WBS) | MINOR | Is the CAM for this task misaligned with what is in DS01 (WBS)? |
9040187 | LOE Task With Improper Logic | MINOR | Is this LOE task missing at least one FF and SS predecessor (both discrete)? |
9040203 | Planned/Estimated Completion & End of PMB Delta Misaligned with UB | MINOR | Is the delta between the Planned/Estimated Completion & End of PMB milestones not equal to UB days? |
9040213 | Non-External SVT | MINOR | Is this SVT not marked as external in the WBS dictionary (DS01)? |
9040225 | Non-WP, PP, or SLPP Type Found in Schedule | MINOR | Is this WBS ID typed as something other than WP, PP, or SLPP in the WBS Dictionary? |
9040277 | EVT Justification Misaligned With Cost | MINOR | Is a similar justification for this EVT missing in cost? |
9040279 | Reprogramming Missing in CC Log Detail (CA) | MINOR | Is this Work or Planning Planning with reprogramming missing in the CC Log detail? |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1050233 | Schedule Missing Logic | CRITICAL | Is schedule logic missing for either the BL or FC schedule? | Zero logic rows found for either the BL or FC schedule (schedule_type = BL or FC). |
1050236 | Non-Unique Relationship | CRITICAL | Is this row duplicated by schedule_type, task_ID, predecessor_task_ID, subproject_ID, and predecessor_subproject_ID? | Count of schedule_type, task_ID, predecessor_task_ID, subproject_ID, and predecessor_subproject_ID combo > 1. |
9050281 | Predecessor Missing in Schedule | CRITICAL | Is this predecessor missing in the schedule? | predecessor_task_ID not found in DS04 task_ID list (by schedule_type). |
9050282 | Task Missing in Schedule | CRITICAL | Is this task missing in the schedule? | task_ID not found in DS04 task_ID list (by schedule_type). |
1050232 | Lead | MAJOR | Is the lag for this task less than zero, i.e. a lead? | Lag_days < 0. |
1050234 | SS or FF Improperly Linked With Other Relationship Types | MAJOR | Does this SS or FF relationship exist alongside an FS or SF relationship? | Predecessor has at least one SS or FF relationship (type = SS or FF) and one non-SS or non-FF relationship tied to it (type = SF or FS). |
1050235 | Start-Finish Relationship | MAJOR | Is this a start-finish relationship? | Relationship type is start-finish (type = SF). |
9050280 | Lag Missing Justification | MINOR | Is the lag for this task missing a justification? | Lag_days <> 0 and lacking a justification in DS04 schedule (justification_lag is null or blank). |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1060245 | Missing Resource & Role ID | CRITICAL | Is this resource missing both a resource and role ID? | Resource missing both resource_ID and role_ID (resource_ID and role_ID = null or blank). |
1060248 | Resource Missing Name | CRITICAL | Is this resource missing a name? | Resource found without a resource name (resource_name = null or blank). |
1060253 | Resource Role Missing Name | CRITICAL | Is this resource role missing a name? | role_ID is not blank & role_name is blank. |
1060254 | Schedule Missing Resources | CRITICAL | Is either the BL or FC schedule missing resources? | Zero resource rows found for either the BL or FC schedule (schedule_type = BL or FC). |
1060259 | Non-Unique Resource or Role | CRITICAL | Is this resource / role duplicated by schedule type, task ID, EOC, subproject ID, and resource or role ID? | Count of schedule_type, task_ID, EOC, subproject_ID and resource_ID or role_id combo > 1. |
9060299 | Resource Missing Rates | CRITICAL | Are the rates missing for this resource? | Resource_ID missing in DS21.resource_ID list. |
9060301 | Resource Task Missing in Schedule | CRITICAL | Is the task this resource is assigned to missing in the schedule? | Task_ID missing in DS04.task_ID list (by schedule_type & subproject_ID). |
1060236 | Resources with Negative Performance | MAJOR | Does this resource have negative performance dollars and/or units? | Resource found with negative performance (actual_dollars < 0 and/or actual_units < 0). |
1060238 | Resources with Negative Budget | MAJOR | Does this resource have negative budget dollars and/or units? | Resource found with negative budget (budget_dollars < 0 and/or budget_units < 0). |
1060241 | Task with Indirect EOC Only | MAJOR | Is this task resource-loaded with only Indirect EOC resources? | Task lacking EOC other than Indirect (task_ID where EOC = Indirect only). |
1060242 | Non-Zero Resource Lag Planned | MAJOR | Has this resource been scheduled with non-zero lag? | Resource planned lag (lag_planned_date) <> 0. |
1060243 | Resource with Non-Zero Remaining Lag | MAJOR | Does this resource have a non-zero remaining lag? | Resource remaining lag (lag_remaining_date) <> 0. |
1060244 | Resources with Negative Remaining Budget | MAJOR | Does this resource have negative remaining budget (dollars and/or units)? | Resource found with negative remaining budget (remaining_dollars < 0 and/or remaining_units < 0). |
1060249 | Resource Role with Non-Labor EOC | MAJOR | Does this role have a non-labor EOC type? | Role found where EOC is not labor (role_ID is not blank and EOC <> labor). |
1060255 | Resource Start Date Later Than Finish Date | MAJOR | Is the start date later than the finish date for this resource? | Resource start_date > finish_date. |
1060256 | Labor Resource Lacking Appropriate EOC | MAJOR | Is the EOC for this labor type resource something other than Labor or Indirect? | type = labor where EOC <> Labor or Indirect. |
1060257 | Labor Resource with Non-Hour UOM Type | MAJOR | Does this labor-type resource have a non-hour UOM type? | type = labor where UOM <> h. |
1060258 | Material Resource with Missing or Numeric UOM | MAJOR | Does this material-type resource have missing or numeric UOM? | type = material where UOM is blank or numeric. |
1060260 | BL Resource Missing Among FC Resoures | MAJOR | Is this BL resource missing among the FC resources? | Combo of task_ID, resource_ID, role_ID, & EOC (where schedule_type = BL) not found in DS06 (where schedule_type = FC). |
1060261 | FC Resource Missing Among BL Resoures | MAJOR | Is this FC resource missing among the BL resources? | Combo of task_ID, resource_ID, role_ID, & EOC (where schedule_type = BL) not found in DS06 (where schedule_type = BL). |
9060283 | Resource Loaded CA or WBS | MAJOR | Is this WBS of type CA or WBS resource loaded? | WBS ID of type CA or WBS (DS01.type = CA or WBS) found with resources (task_ID found in DS06.task_ID list by subproject). |
9060287 | Resource Labor Performance Misaligned with Cost | MAJOR | Are the resource labor performance units misaligned with the cost labor performance hours? | Resource labor performance units (actual_units where EOC or type = Labor) <> cost labor performance hours (SUM of DS03.BCWPi_dollars where EOC = Labor). |
9060289 | Cost Labor Actuals without Resource Labor Performance (WP) | MAJOR | Are there labor actual hours in cost without labor performance units in resources? (WP) | Resource labor performance units = 0 (actual_units where EOC or type = Labor) while cost labor actuals hours > 0 (SUM of DS03.ACWPi_hours where EOC = Labor) (Test runs at WP level). |
9060291 | Resource Labor Units Misaligned with Cost | MAJOR | Are the labor budget units in resources misaligned with the labor budget hours in cost? | Resource labor budget units (budget_units where EOC or type = Labor) <> cost labor DB (SUM of DS03.BCWSi_dollars where EOC = Labor) by WBS_ID. |
9060292 | Resource Non-Labor Hours Recorded Alongside Cost Labor Hours | MAJOR | Are there non-labor budget hours in resources recorded in the same WBS as labor budget hours in cost? | Resource labor budget hours > 0 (Sum of budget_units where type <> Labor and UOM = h) and cost labor DB hours > 0 (Sum of DS03.BCWSi_dollars where EOC = Labor) by WBS_ID. |
9060294 | EOC Combo Misaligned with Cost | MAJOR | Is the combo of resource EOCs for this task/WBS misaligned with what is in cost? | Combo of resource EOCs for this DS04.task's WBS ID do not align with combo of DS03 EOCs. |
9060295 | Subcontract Resource Missing in SubK List | MAJOR | Is this subcontract resource missing in the subcontract list? | Subcontract EOC task_id (EOC = subcontract) missing in DS13.task_ID list. |
9060296 | Resource Finishing Later Than Task | MAJOR | Is this resource scheduled to finish after its parent task? | Resource finish (finish_date) > DS04.EF_date (by task_ID). |
9060300 | Resource Starting Earlier Than Task | MAJOR | Is this resource scheduled to start before its parent task? | Start_date < DS04.ES_date (by task_ID; BL schedule only). |
1060237 | Resource without Budget | MINOR | Is this resource lacking budget dollars and/or units? | Resource found without budget (budget_dollars and/or budget_units = 0). |
1060239 | Mistyped Labor EOC | MINOR | Is this Labor EOC mistyped? | Labor EOC (EOC = labor) does not have a type of labor (type <> labor). |
1060246 | Labor Overlap | MINOR | Is this labor resource scheduled to work on multiple tasks at the same time? | Labor resource start/finish dates overlap across multiple task_IDs. |
1060247 | Duplicate Resource Name | MINOR | Is this resource name duplicated across resources? | Resource_name repeats across distinct resource_ids. |
1060250 | Resource With Role | MINOR | Does this resource have a resource ID and a role ID? | Resource item found with both a resource and role ID (resource_ID and role_ID are not blank). |
1060251 | Resource Task without Resource Assigned Starting Soon | MINOR | Is this task lacking a resource ID planned to start soon (within 3 months)? | Resource item without an ID is planned to start within three months (resource_ID is blank & start_date is within 3 months of CPP SD). |
1060252 | Duplicate Role Name | MINOR | Is this role name duplicated across roles? | Resource_name repeats across distinct resource_ids. |
9060284 | Resource Performance Misaligned with Cost | MINOR | Is the performance recorded for this task misaligned with what is in cost (by EOC)? | Resource performance (actual_dollars) <> DS03.BCWPc (BCWPi_dollars) by EOC. |
9060285 | Cost Actuals without Resource Performance (WP) | MINOR | Are there actuals in cost without performance in resources (by WP WBS & EOC)? | Resource performance (actual_dollars) = 0 even though DS03.ACWPc > 0 (SUM of ACWSi_dollars) by WBS_ID_WP & EOC. |
9060290 | Resource Budgets Misaligned with Cost | MINOR | Are the resource budget dollars misaligned with what is in cost? | Resource budget_dollars <> cost DB (SUM of DS03.BCWSi_dollars) by WBS_ID & EOC. |
9060293 | Calendar Missing In Standard Calendar List | MINOR | Is this calendar name missing in the standard calendar list? | calendar_name not found in DS19.calendar_name list. |
9060297 | Resource Remaining Dollars Misaligned with Cost BCWR | MINOR | Are the resource remaining dollars flowing up to the schedule WBS misaligned with the BCWR in cost (by WBS_ID & EOC)? | Sum of resource remaining dollars rolled up into DS04.WBS_ID do not align with BCWR in DS03 (by WBS_ID & EOC). |
9060298 | Resource Remaining Units Misaligned with Cost BCWR Hours | MINOR | Are the resource remaining units flowing up to the schedule WBS misaligned with the BCWR hours in cost (by WBS_ID & EOC)? | Sum of resource remaining hours rolled up into DS04.WBS_ID do not align with BCWR hours in DS03 (by WBS_ID & EOC). |
1060265 | Resource Missing EOC | CRITICAL | Is this resource lacking an EOC? | EOC missing (where resource_ID is not blank). |
1060262 | Uneven Use of Indirect | MAJOR | Is Indirect EOC used for some tasks but not all? | Task lacking Indirect EOC despite Indirect use elsewhere (if Indirect is used on tasks, it must be used for all tasks). |
1060264 | EOCs Improperly Mingled | MAJOR | Are material, ODC, subcontract, or labor EOCs comingled in the same task? | Task_ID found with combo of material, ODC, subcontract, and/or labor EOC. |
1060266 | Duplicate Resource | MAJOR | Is this resource duplicated across subprojects? | Count of Resource_id > 1 across distinct subproject_id. |
9060302 | Resource Labor Performance without Cost Labor Actuals (WP) | MAJOR | Are there resource labor performance units recorded without labor actual hours in cost at the WP level? | Resource labor performance units > 0 (actual_units where EOC or type = Labor) while cost labor actuals hours = 0 (SUM of DS03.ACWPi_hours where EOC = Labor) by WBS_ID_WP. |
9060303 | Resource Labor Performance without Cost Labor Actuals (CA) | MAJOR | Are there resource labor performance units recorded without labor actual hours in cost at the CA level? | Resource labor performance units > 0 (actual_units where EOC or type = Labor) while cost labor actuals hours = 0 (SUM of DS03.ACWPi_hours where EOC = Labor) by WBS_ID_CA. |
9060307 | Cost Labor Actuals without Resource Labor Performance (CA) | MAJOR | Are there labor actual hours in cost without labor performance units in resources? (CA) | Resource labor performance units = 0 (actual_units where EOC or type = Labor) while cost labor actuals hours > 0 (SUM of DS03.ACWPi_hours where EOC = Labor) (Test runs at CA level). |
1060267 | Indirect With Hours | MINOR | Does this indirect resource have hours? | budget, actual, or remaining units > 0 where EOC = Indirect. |
9060304 | Resource Performance without Cost Actuals (CA) | MINOR | Has this resource recorded performance even though actuals are not recorded in cost (by EOC, at the CA level)? | Resource performance (actual_dollars) > 0 even though DS03.ACWPc = 0 (SUM of ACWSi_dollars) by EOC (CA level). |
9060305 | Resource Performance without Cost Actuals (WP) | MINOR | Has this resource recorded performance even though actuals are not recorded in cost (by EOC, at the WP level)? | Resource performance (actual_dollars) > 0 even though DS03.ACWPc = 0 (SUM of ACWSi_dollars) by EOC (WP level). |
9060306 | Cost Actuals without Resource Performance (CA) | MINOR | Are there actuals in cost without performance in resources (by CA WBS & EOC)? | Resource performance (actual_dollars) = 0 even though DS03.ACWPc > 0 (SUM of ACWSi_dollars) by WBS_ID_CA & EOC. |
UID | Title | Summary | Error Message |
---|---|---|---|
1070259 | Negative MR Reprogramming | MAJOR | Is the MR reprogramming less than zero? |
1070260 | OTB/OTS Date without MR | MAJOR | Is there an OTB/OTS date without MR? |
1070262 | Negative CBB | MAJOR | Is CBB negative? |
1070263 | CBB Not Equal to NCC Plus AUW | MAJOR | Is CBB not equal to NCC plus AUW? |
1070264 | PM EAC Best Date Earlier Than CPP SD | MAJOR | Is the PM EAC Best date earlier than the CPP Status Date? |
1070265 | Negative or Zero PM EAC Best Dollars | MAJOR | Is the PM EAC Best dollars value zero or negative? |
1070266 | PM EAC Likely Date Earlier Than CPP SD | MAJOR | Is the PM EAC likely date earlier than the CPP Status Date? |
1070267 | PM EAC Dates Chronology Issue | MAJOR | Are the PM EAC dates chronologically ordered as best, likely, worst? |
1070268 | Negative or Zero PM EAC Likely Dollars | MAJOR | Is the PM EAC Likely dollars value zero or negative? |
1070269 | PM EAC Dollars Out of Order | MAJOR | Are the PM EAC dollars increasing in an order other than best, likely, worst? |
1070270 | PM EAC Likely Dollars & CBB Issue | MAJOR | Are the PM EAC likely dollars greater than the CBB without an OTB/OTS? |
1070271 | PM EAC Worst Date Earlier Than CPP SD | MAJOR | Is the PM EAC Worst date earlier than the CPP Status Date? |
1070272 | Negative or Zero PM EAC Worst Dollars | MAJOR | Is the PM EAC Worst dollars value zero or negative? |
1070274 | Negative MR Budget | MAJOR | Is the MR budget less than zero? |
1070275 | MR Reprogramming without OTB/OTS Date | MAJOR | Is there MR reprogramming without an OTB/OTS date? |
1070276 | Negative NCC | MAJOR | Is NCC negative? |
1070355 | Negative Profit Fee | MAJOR | Is profit fee negative? |
1070357 | Low Cost QRA | MAJOR | Is the quantitative risk analysis confidence level for cost less than 70%? |
1070359 | Low Schedule QRA | MAJOR | Is the quantitative risk analysis confidence level for schedule less than 70%? |
1070360 | Negative TAB | MAJOR | Is the TAB negative? |
1070381 | Contract Type Missing | MAJOR | Is the contract type missing? |
1070382 | Negative UB (Days) | MAJOR | Are the UB days negative? |
1070383 | Negative UB (Dollars) | MAJOR | Are the UB dollars negative? |
1070384 | Negative UB Estimated (Days) | MAJOR | Are the UB estimated days negative? |
1070385 | Negative UB Estimated (Dollars) | MAJOR | Are the UB estimated dollars negative? |
9070308 | PM EAC Likely Date After CD-4 | MAJOR | Is the PM EAC Likely date later than the CD-4 milestone? |
9070338 | OTB / OTS Without BAC Reprogramming | MAJOR | Is there an OTB/OTS date without BAC reprogramming? |
9070339 | OTB / OTS Without CV Reprogramming | MAJOR | Is there an OTB/OTS date without CV reprogramming? |
9070340 | OTB / OTS Without Schedule Reprogramming | MAJOR | Is there an OTB/OTS date without schedule reprogramming? |
9070341 | OTB / OTS Without SV Reprogramming | MAJOR | Is there an OTB/OTS date without SV reprogramming? |
9070351 | CBB Misaligned with PMB, MR, & Overrun | MAJOR | Is the stated CBB value in the IPMR header plus the cost Overrun equal to the PMB plus MR? |
9070361 | TAB Misaligned with BAC Repgrogramming & CBB | MAJOR | Does TAB equal something other than CBB plus BAC Reprogramming? |
9070363 | UB Without UB Change Control | MAJOR | Are there UB dollars without UB transactions in the change control log? |
9070365 | 12 Months Since OTB-OTS Without BCP | MAJOR | Has it been twelve months since an OTB-OTS date without a BCP? |
9070367 | QRA Confidence Level Low for Cost Following BCP | MAJOR | Is the QRA Confidence Level below 90% for cost following a BCP? |
9070368 | QRA Confidence Level Low for Schedule Following BCP | MAJOR | Is the QRA Confidence Level below 90% for schedule following a BCP? |
9070369 | PMB + MR <> CBB + Overrun | MAJOR | Are the PM and MR equal to something other than CBB plus overrun? |
1070273 | High or Low Escalation Rate Percent | MINOR | Is the escalation rate percentage exceptionally low (below 3%) or high (above 20%)? |
1070335 | UB Estimated Greater Than UB Budgeted (Days) | MINOR | Is the UB estimated days amount greater than UB budgeted? |
1070336 | UB Estimated Greater Than UB Budgeted (Dollars) | MINOR | Is the UB estimated dollar amount greater than UB budgeted? |
1070337 | MR Reprogramming | MINOR | Is there MR reprogramming? |
1070342 | UB Budget Days without UB Budget Dollars | MINOR | Are there UB budget days but no UB budget dollars? |
1070343 | UB Budget without UB Estimate (Days) | MINOR | Are there UB budget days but no UB estimated days? |
1070344 | UB Budget Dollars without UB Budget Days | MINOR | Are there UB budget dollars but no UB budget dayss? |
1070345 | UB Budget without UB Estimate (Dollars) | MINOR | Are there UB budget dollars but no UB estimated dollars? |
1070346 | UB Estimated without UB Budget (Days) | MINOR | Are there UB estimated days but no UB budget days? |
1070347 | UB Estimated Days without UB Estimated Dollars | MINOR | Are there UB estimated days but no UB estimated dollars? |
1070348 | UB Estimated without UB Budget (Dollars) | MINOR | Are there UB estimated dollars but no UB budget dollars? |
1070349 | UB Estimated Dollars without UB Estimated Days | MINOR | Are there UB estimated dollars but no UB estimated days? |
1070354 | Zero Profit Fee | MINOR | Is profit fee zero? |
1070356 | Over-Optimistic Cost QRA | MINOR | Is the quantitative risk analysis confidence level for cost above 95%? |
1070358 | Over-Optimistic Schedule QRA | MINOR | Is the quantitative risk analysis confidence level for schedule above 95%? |
1070362 | Zero Favorable Cost Cum Dollar Threshold | MINOR | Is the favorable cost cum dollar threshold equal to zero? |
1070363 | Zero Unfavorable Cost Cum Dollar Threshold | MINOR | Is the unfavorable cost cum dollar threshold equal to zero? |
1070364 | Zero Favorable Cost Cum Percent Threshold | MINOR | Is the favorable cost cum percent threshold equal to zero? |
1070365 | Zero Unfavorable Cost Cum Percent Threshold | MINOR | Is the unfavorable cost cum percent threshold equal to zero? |
1070366 | Zero Favorable Cost Inc Dollar Threshold | MINOR | Is the favorable cost inc dollar threshold equal to zero? |
1070367 | Zero Unfavorable Cost Inc Dollar Threshold | MINOR | Is the unfavorable cost inc dollar threshold equal to zero? |
1070368 | Zero Favorable Cost Inc Percent Threshold | MINOR | Is the favorable cost inc percent threshold equal to zero? |
1070369 | Zero Unfavorable Cost Inc Percent Threshold | MINOR | Is the unfavorable cost inc percent threshold equal to zero? |
1070370 | Zero Favorable Cost VAC Percent Threshold | MINOR | Is the favorable cost VAC percent threshold equal to zero? |
1070371 | Zero Unfavorable Cost VAC Percent Threshold | MINOR | Is the unfavorable cost VAC percent threshold equal to zero? |
1070372 | Zero Favorable Schedule Cum Dollar Threshold | MINOR | Is the favorable schedule cum dollar threshold equal to zero? |
1070373 | Zero Unfavorable Schedule Cum Dollar Threshold | MINOR | Is the unfavorable schedule cum dollar threshold equal to zero? |
1070374 | Zero Favorable Schedule Cum Percent Threshold | MINOR | Is the favorable schedule cum percent threshold equal to zero? |
1070375 | Zero Unfavorable Schedule Cum Percent Threshold | MINOR | Is the unfavorable schedule cum percent threshold equal to zero? |
1070376 | Zero Favorable Schedule Inc Dollar Threshold | MINOR | Is the favorable schedule inc dollar threshold equal to zero? |
1070377 | Zero Unfavorable Schedule Inc Dollar Threshold | MINOR | Is the unfavorable schedule inc dollar threshold equal to zero? |
1070378 | Zero Favorable Schedule Inc Percent Threshold | MINOR | Is the favorable schedule inc percent threshold equal to zero? |
1070379 | Zero Unfavorable Schedule Inc Percent Threshold | MINOR | Is the unfavorable schedule inc percent threshold equal to zero? |
1070380 | CPE Contract Type | MINOR | Is this a CPE contract type? |
1070389 | Zero Favorable Cost VAC Dollar Threshold | MINOR | Is the favorable cost VAC dollar threshold equal to zero? |
1070390 | Zero Unfavorable Cost VAC Dollar Threshold | MINOR | Is the unfavorable cost VAC dollar threshold equal to zero? |
9070302 | PM EAC Likely Misaligned with Calculated EAC | MINOR | Is the PM EAC Likely dollars value less than the cost-calculated EAC? |
9070303 | PM EAC Best Date Misaligned with Cost Estimates | MINOR | Is the PM EAC Best date earlier than the last recorded ETC plus estimated UB? |
9070304 | PM EAC Best Date Prior to End of PMB Milestone | MINOR | Is the PM EAC Best date earlier than the End of PMB milestone? |
9070305 | PM EAC Likely Date Misaligned with Cost Estimates | MINOR | Is the PM EAC likely date earlier than the last recorded ETC plus estimated UB? |
9070306 | PM EAC Likely Date Prior to End of PMB Milestone | MINOR | Is the PM EAC Likely date earlier than the End of PMB milestone? |
9070307 | PM EAC Likely Date After Contract Completion | MINOR | Is the PM EAC Likely date later than the Contract Completion milestone? |
9070310 | RPG without OTB/OTS Date | MINOR | Are there RPG tasks without an OTB/OTS Date? |
9070350 | PM EAC Best Misaligned with Calculated EAC | MINOR | Is the PM EAC Best dollars value less than the cost-calculated EAC? |
9070353 | PM EAC Worst Date Later Than CD-4 | MINOR | Is the PM EAC Worst date later than the CD-4 milestone date? |
9070362 | EAC PM Likely Incommensurate with WAD BAC | MINOR | Is the EAC PM likely considerably different from the BAC as reported in the WADs? |
9070364 | EAC > BAC without OTB / OTS Date | MINOR | Is EAC greater than BAC without an OTB / OTS date? |
9070366 | Profit Fee Misaligned With CC Log Detail | MINOR | Is profit fee misaligned with the dollars delta for profit fee transactions in the CC log detail? |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1080441 | Duplicate WAD | CRITICAL | Is this WAD a duplicate by WAD ID, WBS ID, WP WBS ID, & revision? | Count of WAD_ID, WBS_ID, WBS_ID_WP, & revision combo > 1. |
1080404 | Negative or Missing Budget Dollars | MAJOR | Does this WAD have only negative or zero budget dollar values? | budget_labor_dollars <= 0 & budget_labor_hours <= 0 & budget_material_dollars <= 0 & budget_ODC_dollars <= 0 & budget_subcontract_dollars <= 0. |
1080413 | Initial Authorization Date Missing | MAJOR | Is the initial authorization date missing? | initial_auth_date is blank. |
1080427 | PM Authorization Missing | MAJOR | Is this WAD missing a PM authorization date? | auth_PM_date is blank. |
1080433 | POP Start After Initial Auth Date | MAJOR | Is the POP start later than the initial auth date for the latest WAD revision? | pop_start_date > initial_auth_date. |
1080434 | POP Start Earlier Than Previous Revision | MAJOR | Is the POP start of this WAD revision earlier than the POP start of the prior revision? | pop_start_date < pop_start_date of prior auth_PM_date. |
1080439 | CA & WP WBS Match | MAJOR | Do the CA & WP WBS IDs match? | WBS_ID = WBS_ID_WP. |
9080386 | CA Labor Dollars Misaligned With Cost | MAJOR | Are the labor budget dollars for this CA WAD misaligned with what is in cost? | budget_labor_dollars <> SUM(DS03.BCWSi_dollars) where EOC = labor (by WBS_ID_CA). |
9080387 | WP Labor Dollars Misaligned With Cost | MAJOR | Are the labor budget dollars for this WP/PP WAD misaligned with what is in cost? | budget_labor_dollars <> SUM(DS03.BCWSi_dollars) where EOC = labor (by WBS_ID_WP). |
9080388 | CA Labor Hours Misaligned With Cost | MAJOR | Are the labor budget hours for this CA WAD misaligned with what is in cost? | budget_labor_hours <> SUM(DS03.BCWSi_hours) where EOC = labor (by WBS_ID_CA). |
9080389 | WP Labor Hours Misaligned With Cost | MAJOR | Are the labor budget hours for this WP/PP WAD misaligned with what is in cost? | budget_labor_hours <> SUM(DS03.BCWSi_hours) where EOC = labor (by WBS_ID_WP). |
9080390 | CA Material Dollars Misaligned With Cost | MAJOR | Are the material budget dollars for this CA WAD misaligned with what is in cost? | budget_material_dollars <> SUM(DS03.BCWSi_dollars) where EOC = material (by WBS_ID_CA). |
9080391 | WP Material Dollars Misaligned With Cost | MAJOR | Are the material budget dollars for this WP WAD misaligned with what is in cost? | budget_material_dollars <> SUM(DS03.BCWSi_dollars) where EOC = material (by WBS_ID_WP). |
9080392 | CA ODC Dollars Misaligned With Cost | MAJOR | Are the ODC budget dollars for this CA WAD misaligned with what is in cost? | budget_ODC_dollars <> SUM(DS03.BCWSi_dollars) where EOC = ODC (by WBS_ID_CA). |
9080393 | WP ODC Dollars Misaligned With Cost | MAJOR | Are the ODC budget dollars for this WP/PP WAD misaligned with what is in cost? | budget_ODC_dollars <> SUM(DS03.BCWSi_dollars) where EOC = ODC (by WBS_ID_WP). |
9080394 | CA Overhead Dollars Misaligned With Cost | MAJOR | Are the overhead budget dollars for this CA WAD misaligned with what is in cost? | budget_overhead_dollars <> SUM(DS03.BCWSi_dollars) where EOC = overhead (by WBS_ID_CA). |
9080396 | CA Subcontract Dollars Misaligned With Cost | MAJOR | Are the subcontract budget dollars for this CA WAD misaligned with what is in cost? | budget_subcontract_dollars <> SUM(DS03.BCWSi_dollars) where EOC = subcontract (by WBS_ID_CA). |
9080397 | WP Subcontract Dollars Misaligned With Cost | MAJOR | Are the subcontract budget dollars for this WP/PP WAD misaligned with what is in cost? | budget_subcontract_dollars <> SUM(DS03.BCWSi_dollars) where EOC = subcontract (by WBS_ID_WP). |
9080400 | SLPP with CAM Authorization | MAJOR | Does this SLPP WAD have a CAM authorization date? | auth_CAM_date found where DS01.type = SLPP (by WBS_ID). |
9080401 | SLPP or PP WAD with Inappropriate EVT | MAJOR | Is EVT for this SLPP or WP-level WAD something other than K? | EVT <> K for SLPP or PP WAD (by DS01.WBS_ID). |
9080406 | CAM Authorization Missing | MAJOR | Is a CAM authorization date missing for this non-SLPP WAD? | auth_CAM_date is null / blank where DS01.type <> SLPP (by WBS_ID or WBS_ID_WP). |
9080407 | CAM Misaligned with WBS Hierarchy (CA) | MAJOR | Is the CAM on this CA WAD misaligned with what is in the WBS hierarchy? | DS08.CAM <> DS01.CAM (by WBS_ID). |
9080408 | CAM Misaligned with WBS Hierarchy (WP) | MAJOR | Is the CAM on this WP/PP WAD misaligned with what is in the WBS hierarchy? | DS08.CAM <> DS01.CAM (by WBS_ID_WP). |
9080409 | EVT Misaligned with Cost | MAJOR | Is the EVT for this WP/PP-level WAD misaligned with what is in cost? | EVT <> DS03.EVT (by WBS_ID_WP). |
9080414 | CA Labor Dollars Missing In Cost | MAJOR | Are the labor budget dollars for this CA WAD missing in cost? | budget_labor_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = labor (by WBS_ID_CA). |
9080415 | WP Labor Dollars Missing In Cost | MAJOR | Are the labor budget dollars for this WP/PP WAD missing in cost? | budget_labor_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = labor (by WBS_ID_WP). |
9080416 | CA Material Dollars Missing In Cost | MAJOR | Are the material budget dollars for this CA WAD missing in cost? | budget_material_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = material (by WBS_ID_CA). |
9080417 | WP Material Dollars Missing In Cost | MAJOR | Are the material budget dollars for this WP/PP WAD missing in cost? | budget_material_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = material (by WBS_ID_WP). |
9080419 | CA ODC Dollars Missing In Cost | MAJOR | Are the ODC budget dollars for this CA WAD missing in cost? | budget_ODC_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = ODC (by WBS_ID_CA). |
9080420 | WP ODC Dollars Missing In Cost | MAJOR | Are the ODC budget dollars for this WP/PP WAD missing in cost? | budget_ODC_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = ODC (by WBS_ID_WP). |
9080423 | PM Authorization After Earliest Recorded CA Performance or Actuals | MAJOR | Is the PM authorization date for this Control Account later than the CA' first recorded instance of either actuals or performance? | auth_PM_date > minimum DS03.period_date where ACWPi or BCWPi > 0 (by WBS_ID). |
9080424 | PM Authorization After Earliest Recorded WP Performance or Actuals | MAJOR | Is the PM authorization date for this Work Package later than the WP' first recorded instance of either actuals or performance? | auth_PM_date > minimum DS03.period_date where ACWPi or BCWPi > 0 (by WBS_ID_WP). |
9080425 | PM Authorization After CA Actual Start | MAJOR | Is the PM authorization date for this Control Account WAD later than the CA's Actual Start date? | auth_PM_date > DS04.AS_date (by WBS_ID). |
9080426 | PM Authorization After WP Actual Start | MAJOR | Is the PM authorization date for this Work Package WAD later than the WP's Actual Start date? | auth_PM_date > DS04.AS_date (by WBS_ID_WP). |
9080430 | POP Finish Before Cost Finish (CA) | MAJOR | Is the POP finish for this Control Account WAD before the last recorded SPAE value in cost? | pop_finish_date < max DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by CA WBS ID). |
9080431 | POP Finish Before Baseline Early Finish (CA) | MAJOR | Is the POP finish for this Control Account WAD before the baseline early finish? | pop_finish < DS04.EF_date where schedule_type = BL (by DS08.WBS_ID & DS04.WBS_ID via DS01.WBS_ID & DS01.parent_WBS_ID). |
9080432 | POP Finish Before Baseline Early Finish (WP) | MAJOR | Is the POP finish for this Work Package WAD before the baseline early finish date? | pop_finish < DS04.EF_date where schedule_type = BL (by DS08.WBS_ID_WP & DS04.WBS_ID_WP). |
9080436 | CA Subcontract Dollars Missing In Cost | MAJOR | Are the subcontract budget dollars for this CA WAD missing in cost? | budget_subcontract_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = subcontract (by WBS_ID_CA). |
9080437 | WP Subcontract Dollars Missing In Cost | MAJOR | Are the subcontract budget dollars for this WP/PP WAD missing in cost? | budget_subcontract_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = subcontract (by WBS_ID_WP). |
9080604 | POP Finish After Project Planned Completion Milestone | MAJOR | Is the POP finish later than the planned completion milestone? | pop_finish > DS04.ES_date/EF_date where milestone_level = 170 & schedule_type = BL. |
9080607 | CA & WP Parent-Child Relationship Differs from WBS Hierarchy | MAJOR | Does the parent-child relationship for these CA & WP WBS IDs differ from what's in the WBS hierarchy? | WBS_ID / WBS_ID_WP combo <> DS01.WBS_ID / parent_WBS_ID combo. |
9080608 | CA WBS ID Missing in WBS Dictionary | MAJOR | Is this CA WBS ID missing in the WBS dictionary? | WBS_ID not in DS01.WBS_ID list. |
9080609 | CA / SLPP WAD Mistyped In WBS Dictionary | MAJOR | Is this CA / SLPP WAD type as something other than CA or SLPP in the WBS dictionary? | DS01.type <> CA or SLPP for this WBS_ID. |
9080610 | WAD Missing In WBS Dictionary | MAJOR | Is this PM-authorized WAD missing in the WBS Dictionary (by either WP WBS ID if it exists, or the CA WBS ID)? | WBS_ID_CA or WBS_ID_WP missing from DS01.WBS_ID list (where DS08.auth_PM_date is populated). |
9080611 | POP Finish Before Cost Finish (CA) | MAJOR | Is the POP finish for this Control Account before the last recorded SPAE value in cost? | pop_finish_date < max DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by DS08.WBS_ID & DS03.WBS_ID_CA). |
9080612 | POP Finish Before Cost Finish (WP) | MAJOR | Is the POP finish for this Work Package WAD before the last recorded SPAE value in cost? | pop_finish_date < max DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by WP WBS ID). |
9080613 | POP Start After Cost Start (CA) | MAJOR | Is the POP start for this Control Account WAD after the first recorded SPAE value in cost? | pop_start_date > min DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by CA WBS ID). |
9080614 | POP Start After Cost Start (CA) | MAJOR | Is the POP start for this Control Account after the first recorded SPAE value in cost? | pop_start_date > max DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by DS08.WBS_ID & DS03.WBS_ID_CA). |
9080615 | POP Start After Cost Start (WP) | MAJOR | Is the POP start for this Work Package WAD after the first recorded SPAE value in cost? | pop_start_date > min DS03.period_date where BCWS, BCWP, ACWP, or ETC <> 0 (by DS08.WBS_ID_WP & DS03.WBS_ID_WP). |
9080616 | POP Start After Schedule Actual Start (CA) | MAJOR | Is the POP Start for this CA WAD after the schedule actual start? | POP_start_date > DS04.AS_date where schedule_type = FC (compare by DS08.WBS_ID, DS01.WBS_ID, DS01.parent_WBS_ID, & DS04.WBS_ID). |
9080618 | POP Start After Schedule Forecast Start (CA) | MAJOR | Is the POP Start for this Control Account WAD after the forecast start? | POP_start_date > DS04.ES_date where schedule_type = BL (compare by DS08.WBS_ID, DS01.WBS_ID, DS01.parent_WBS_ID, & DS04.WBS_ID). |
9080619 | POP Start After Schedule Forecast Start (WP) | MAJOR | Is the POP Start for this Work Package WAD after the schedule forecast start? | POP_start_date > DS04.ES_date where schedule_type = BL (compare by DS08.WBS_ID_WP & DS04.WBS_ID). |
9080620 | WBS Type WAD | MAJOR | Is this WAD a WBS type WBS element in the WBS dictionary? | WBS_ID or WBS_ID_WP in DS01.WBS_ID list where DS01.type = WBS. |
9080622 | WP WBS ID Missing in WBS Dictionary | MAJOR | Is this WP WBS ID missing in the WBS dictionary? | WBS_ID_WP not in DS01.WBS_ID list. |
9080623 | WP WAD Mistyped In WBS Dictionary | MAJOR | Is this WP WAD type as something other than WP or PP in the WBS dictionary? | DS01.type <> WP or PP for this WBS_ID. |
1080398 | WP/PP EOC Comingled (Dollars) | MINOR | Does this WP/PP WAD have comingled EOCs? | EOC budget dollars > 0 for at least two non-Overhead EOC types, e.g. budget_labor_dollars <> 0 & budget_material_dollar <> 0. |
1080399 | EVT on CA-Level WAD | MINOR | Is there an EVT for this CA-level WAD? | EVT <> blank or NA & WBS_ID_WP <> blank. |
1080402 | Labor Dollars without Labor Hours | MINOR | Does this WAD have labor dollars but not labor hours? | budget_labor_dollars > 0 & budget_labor_hours = 0. |
1080403 | Labor Hours without Labor Dollars | MINOR | Does this WAD have labor hours but not labor dollars? | budget_labor_hours > 0 & budget_labor_dollars = 0. |
1080405 | CAM Authorization After PM Authorization | MINOR | Is the CAM authorization date later than the PM's? | auth_CAM_date > auth_PM_date. |
1080410 | Missing EVT | MINOR | Is the EVT missing for this WP/PP-level WAD? | EVT is missing or blank. |
1080411 | Initial Authorization After PM Authorization | MINOR | Is the initial authorization date for this WAD after the PM date? | initial_auth_date > auth_PM_date (for earliest WAD revision). |
1080412 | Inconsistent Initial Authorization Date | MINOR | Is the initial authorization date consistent across revisions? | initial_auth_date differs across revisions (by WAD_ID). |
1080418 | Narrative Restates Title | MINOR | Is the narrative the same as the title? | narrative = title. |
1080428 | Repeat PM Authorization Date Across Revisions | MINOR | Do multiple revisions share the same PM authorization date? | auth_PM_date repeated where revisions are not the same (by WBS_ID & WBS_ID_WP). |
1080435 | POP Start On or After POP Finish | MINOR | Is the POP start on or after the POP finish? | pop_start_date >= pop_finish_date. |
1080438 | WPM Authorization Date After CAM Authorization Date | MINOR | Is the WPM's authorization date later than the CAM's? | auth_WPM_date > auth_CAM_date. |
1080440 | WPM Missing | MINOR | Is this WPM name missing on this WAD? | WPM is missing or blank where auth_WPM_date found. |
9080429 | POP Finish After Project Planned Completion Milestone (FC) | MINOR | Is the POP finish later than the planned completion milestone in the forecast scheduel? | pop_finish > DS04.ES_date/EF_date where milestone_level = 170 & schedule_type = FC. |
9080605 | POP Finish Before Forecast Early Finish (CA) | MINOR | Is the POP finish for this Control Account WAD before the forecast early finish? | pop_finish < DS04.EF_date where schedule_type = FC (by DS08.WBS_ID & DS04.WBS_ID via DS01.WBS_ID & DS01.parent_WBS_ID). |
9080606 | POP Finish Before Forecast Early Finish (WP) | MINOR | Is the POP finish for this Work Package WAD before the forecast early finish date? | pop_finish < DS04.EF_date where schedule_type = FC (by DS08.WBS_ID_WP & DS04.WBS_ID_WP). |
9080617 | POP Start After Schedule Actual Start (WP) | MINOR | Is the POP start for this Work Package WAD after the actual start in the forecast schedule? | pop_start > DS04.AS_date where schedule_type = FC (by DS08.WBS_ID_WP & DS04.WBS_ID_WP). |
9080621 | WPM Mismatched With WBS Dictionary | MINOR | Is the WPM name for this WAD mismatched with what is in the WBS Dictionary? | WPM <> DS01.WPM (by DS08.WBS_ID_WP & DS01.WBS_ID). |
9080410 | WP Indirect Dollars Misaligned With Cost | MAJOR | Are the indirect budget dollars for this WP/PP WAD misaligned with what is in cost? | budget_indirect_dollars <> SUM(DS03.BCWSi_dollars) where EOC = Indirect or is_indirect = Y (by WBS_ID_WP). |
9080411 | CA Indirect Dollars Misaligned With Cost | MAJOR | Are the indirect budget dollars for this CA WAD misaligned with what is in cost? | budget_indirect_dollars <> SUM(DS03.BCWSi_dollars) where EOC = Indirect or is_indirect = Y (by WBS_ID_CA). |
9080433 | WP Indirect Dollars Missing In Cost | MAJOR | Are the indirect budget dollars for this WP/PP WAD missing in cost? | budget_indirect_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = indirect (by WBS_ID_WP). |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1090440 | Duplicate CC Log Entry | CRITICAL | Is this CC Log entry duplicated by CC Log ID & Supplement ID? | Count of CC_log_ID & CC_log_ID_supplement combo > 1. |
1090439 | Approved Date After Implementation Date | MAJOR | Is the approved date later than the implementation date? | approved_date > implementation_date. |
1090441 | Original UB CC Log ID Missing in CC Log ID List | MAJOR | Is this Original UB CC Log ID missing in the CC Log ID list? | CC_log_ID_original_UB missing in CC_log_ID list. |
1090447 | Missing PM | MAJOR | Is the PM name missing on this CC log entry? | PM null or blank. |
9090442 | CC Log ID Missing in CC Log Detail | MAJOR | Is this CC Log ID missing in the log detail? | CC_log_ID missing in DS10.CC_log_ID list. |
9090443 | Log Dollars Delta Misaligned With Log Detail Delta | MAJOR | Is the dollars delta for this CC Log entry misaligned with what is in the CC Log detail table? | dollars_delta <> SUM(DS10.dollars_delta) (by CC_log_ID). |
9090444 | Log Hours Delta Misaligned With Log Detail Delta | MAJOR | Is the hours delta for this CC Log entry misaligned with what is in the CC Log detail table? | hours_delta <> SUM(DS10.hours_delta) (by CC_log_ID). |
9090446 | PM Misaligned with WADs | MAJOR | Is the PM name misaligned with what is in the WADs? | PM <> DS08.PM where approved_date > CPP_SD_Date - 1. |
9090449 | BCP Change Control Without BCP | MAJOR | Does this BCP change control log entry exist without a BCP in the schedule? | type = BCP & count = 0 where DS04.milestone_level between 131 & 135. |
1090449 | Risk Missing | MINOR | Are risk IDs missing in the CC log? | Count of CC log entries > 5 & Count of risk_id = 0. |
9090445 | Implementation Date Missing or Unreasonable | MINOR | Is the implementation date missing or is it considerably after the approved date? | implementation_date is missing or > the next DS03.period_date after the current DS09.approved_date. |
9090448 | Risk Missing in Risk Register | MINOR | Is this risk ID missing in the risk register? | risk_id missing in DS15.risk_ID list. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1100478 | Duplicate CC Log Detail Transaction | CRITICAL | Is the transaction duplicated by transaction & CC log ID? | Count of transaction_ID & CC_log_ID combo > 1. |
1100451 | AUW Dollar Change Exceeds NTE | MAJOR | Does this AUW dollar change above the NTE? | AUW = Y & dollars_delta > NTE_dollars_delta. |
1100452 | Negative AUW Dollar Delta with Non-Zero NTE | MAJOR | Does this negative AUW dollar change also have an NTE? | AUW = Y & dollars_delta < 0 & NTE_dollars_delta <> 0. |
1100458 | Negative NTE Delta Dollars | MAJOR | Is the NTE delta dollars value negative on this transaction? | NTE_dollars_delta < 0. |
1100461 | AUW Change Missing Dollars Delta | MAJOR | Is this change to AUW missing a dollar amount? | AUW = Y & dollars_delta = null or zero. |
1100464 | DB Transaction Missing WBS ID | MAJOR | Is this DB transaction missing a WBS ID? | category = DB & WBS_ID is missing or blank. |
1100465 | Description Missing | MAJOR | Is the description missing? | description is null or blank. |
1100467 | Hours Delta without Dollars | MAJOR | Are there hours on this transaction but no dollars? | hours_delta <> 0 & dollars_delta = 0. |
1100474 | POP Start After POP Finish | MAJOR | Is the POP start on this transaction later than the POP finish? | POP_start_date > POP_finish_date. |
1100479 | MR Entry Missing in CC Log Detail | MAJOR | Are there no MR entries in the CC Log detail? | Count where category = MR is 0. |
9100450 | AUW Transaction Dollars Misaligned With Project Level AUW | MAJOR | Are the dollars delta for AUW-related transactions misaligned with the AUW dollar value in the IPMR header? | Sum of dollars_delta where AUW = Y <> DS07.AUW_dollars. |
9100453 | DB Dollar Transactions Misaligned with Cost (CA) | MAJOR | Do the DB transaction dollars for this Control Account sum to something other than the DB in cost? | Sum of dollars_delta where category = DB <> Sum of DS03.BCWSi_dollars (by WBS_ID_CA). |
9100454 | DB Dollar Transactions Misaligned with Cost (WP) | MAJOR | Do the DB transaction dollars for this Work Package sum to something other than the DB in cost? | Sum of dollars_delta where category = DB <> Sum of DS03.BCWSi_dollars (by WBS_ID_WP). |
9100455 | DB Hour Transactions Misaligned with Cost (CA) | MAJOR | Do the DB transaction hours for this Control Account sum to something other than the DB in cost? | Sum of hours_delta where category = DB <> Sum of DS03.BCWSi_hours (by WBS_ID_CA). |
9100456 | DB Hour Transactions Misaligned with Cost (WP) | MAJOR | Do the DB transaction hours for this Work Package sum to something other than the DB in cost? | Sum of hours_delta where category = DB <> Sum of DS03.BCWSi_hours (by WBS_ID_WP). |
9100457 | MR Transaction Dollars Misaligned With Project Level MR | MAJOR | Are the dollars delta for MR-related transactions misaligned with the MR dollar value in the IPMR header? | Sum of dollars_delta where category = MR <> DS07.MR_dollars. |
9100459 | UB Transaction Dollars Misaligned With Project Level UB | MAJOR | Are the dollars delta for UB-related transactions misaligned with the UB dollar value in the IPMR header? | Sum of dollars_delta where category = UB <> DS07.UB_bgt_dollars. |
9100460 | OTB or OTS Transaction Dollars Without OTB-OTS Date | MAJOR | Are there OTB/OTS transactions when no OTB/OTS date exists? | Sum of dollars_delta where category = OTB, OTS, or OTB-OTS <> 0 & DS07.OTB_OTS_date is missing. |
9100462 | CC Log ID Missing in CC Log | MAJOR | Is the CC Log Id for this transaction missing in the CC Log table? | CC_log_ID not in DS09.CC_log_ID list. |
9100463 | DB Transaction On Non-CA, SLPP, PP, or WP | MAJOR | Is this DB transaction being applied to something other than a CA, SLPP, PP, or WP? | category = DB & DS01.type <> CA, SLPP, PP, or WP. |
9100468 | UB, MR, or CNT Transaction Below Project Level | MAJOR | Is this UB, MR, or CNT transaction being applied below the project level? | category = UB, MR, or CNT & DS01.level <> 1 (by WBS_ID). |
9100471 | POP Finish Misaligned with WAD (CA) | MAJOR | Is the POP finish for this Control Account misaligned with what is in the WAD? | POP_finish_date <> DS08.POP_finish_date (select latest revision; check is on CA level). |
9100472 | POP Finish Misaligned with WAD (WP) | MAJOR | Is the POP finish for this Work Package misaligned with what is in the WAD? | POP_finish_date <> DS08.POP_finish_date (select latest revision; check is on WP/PP level). |
9100473 | POP Finish Misaligned with WAD (CA) | MAJOR | Is the POP finish for this Control Account misaligned with what is in the WAD? | POP_finish_date <> DS08.POP_finish_date (select latest revision; check is on CA level). |
9100475 | POP Start Misaligned with WAD (CA) | MAJOR | Is the POP start for this Control Account misaligned with what is in the WAD? | POP_start_date <> DS08.POP_start_date (select latest revision; check is on CA level). |
9100476 | POP Start Misaligned with WAD (WP) | MAJOR | Is the POP start for this Work Package misaligned with what is in the WAD? | POP_start_date <> DS08.POP_start_date (select latest revision; check is on WP/PP level). |
9100477 | POP Start Misaligned with WAD (CA) | MAJOR | Is the POP start for this Control Account misaligned with what is in the WAD? | POP_start_date <> DS08.POP_start_date (select latest revision; check is on CA level). |
9100479 | WBS Missing In WBS Dictionary | MAJOR | Is this WBS ID missing in the WBS Dictionary? | WBS_ID missing in DS01.WBS_ID list. |
1100466 | Dollars Delta Missing | MINOR | Is the dollars delta for this transaction missing or zero? | dollars_delta missing or 0. |
9100469 | OTB/OTS Transactions Misaligned with Cost (CA) | MINOR | Do the OTB/OTS transaction dollars for this Control Account sum to something other than the BAC reprogramming in cost? | Sum of dollars_delta where category = OTB, OTS, or OTB-OTS <> Sum of DS03.BAC_rpg (by WBS_ID_CA). |
9100470 | OTB/OTS Transactions Misaligned with Cost (WP) | MINOR | Do the OTB/OTS transaction dollars for this Work Package sum to something other than the BAC reprogramming in cost? | Sum of dollars_delta where category = OTB, OTS, or OTB-OTS <> Sum of DS03.BAC_rpg (by WBS_ID_WP). |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1110495 | Duplicate VAR | CRITICAL | Is this VAR duplicated by WBS ID & Narrative type? | Count of WBS_ID & narrative_type combo > 1. |
1110480 | Project-Level VAR With Root Cause Narrative | MAJOR | Does this project-level VAR have a root cause narrative? | narrative_type < 200 & narrative_RC_SVi, narrative_RC_SVc, narrative_RC_CVi, or narrative_RC_CVc. |
1110488 | Narrative Type Missing | MAJOR | Is the narrative type missing? | narrative_type missing or blank. |
1110491 | Project-Level VAR Without Overall Narrative | MAJOR | Is this project-level VAR missing an overall narrative? | narrative_type < 200 & narrative_overall is missing or blank. |
1110494 | Root Cause And/Or Impact Narrative Missing | MAJOR | Is this VAR missing either a root cause or an impact narrative (or both)? | VAR is missing either a RC SV or CV narrative or an impact narrative (or both). |
9110482 | Approved Date After CAL Dates | MAJOR | Is the approved date for this variance later than the dates for the corrective action date? | approved_date > DS12.initial_date, DS12.original_due_date, DS12.forecast_due_date, or DS12.closed_date (by CAL_ID). |
9110485 | CAL ID Missing in Corrective Action Log | MAJOR | Is the CAL ID missing in the Corrective Action Log? | CAL_ID missing in DS12.CAL_ID list. |
9110486 | CA-Level VAR Mistype In WBS Dictionary | MAJOR | Is this CA-level VAR type as something other than CA in the WBS Dictionary? | narrative_type = 300 & DS01.type <> CA (by WBS_ID). |
9110489 | PP-Level VAR Mistype In WBS Dictionary | MAJOR | Is this PP-level VAR type as something other than PP in the WBS Dictionary? | narrative_type = 400 & DS01.type <> PP (by WBS_ID). |
9110490 | Project-Level VAR Misaligned With Project-Level WBS | MAJOR | Is this project-level VAR not at Level 1 in the WBS Hierarchy? | narrative_type < 200 & DS01.level > 1 (by WBS_ID). |
9110492 | SLPP-Level VAR Mistype In WBS Dictionary | MAJOR | Is this SLPP-level VAR type as something other than SLPP in the WBS Dictionary? | narrative_type = 200 & DS01.type <> SLPP (by WBS_ID). |
9110494 | WBS ID Missing In WBS Hierarchy | MAJOR | Is the WBS ID for this VAR missing in the WBS Hierarchy? | WBS_ID not in DS01.WBS_ID list. |
9110495 | WP-Level VAR Mistype In WBS Dictionary | MAJOR | Is this WP-level VAR type as something other than WP in the WBS Dictionary? | narrative_type = 500 & DS01.type <> WP (by WBS_ID). |
1110481 | SLPP or PP VAR With Root Cause Narrative | MINOR | Is there a root cause SV or CV narrative for this SLPP or PP VAR? | narrative_type = 200 or 400 & narrative_RC_SVi, narrative_RC_SVc, narrative_RC_CVi, or narrative_RC_CVc. |
1110484 | CAL ID Missing | MINOR | Is the CAL ID missing for this VAR? | CAL_ID is missing or blank. |
1110487 | Cost Variance Root Cause Narrative Missing Impact | MINOR | Is there a cost variance root cause narrative without an impact statement? | narrative_RC_CVi or narrative_RC_CVc found but narrative_impact_cost is blank or missing. |
1110493 | Schedule Variance Root Cause Narrative Missing Impact | MINOR | Is there a schedule variance root cause narrative without an impact statement? | narrative_RC_SVi or narrative_RC_SVc found but narrative_impact_schedule is blank or missing. |
9110483 | Approved Date Outside Current Period | MINOR | Is the approved date before the last or after the current status date? | approved_date < DS00.CPP_Status_Date - 1 & approved_date > DS00.CPP_Status_Date. |
9110496 | CV Root Cause Narrative Missing CAL Cost Narrative | MINOR | Is this CVi or CVc VAR narrative missing a corrective action log entry with a cost narrative? | narrative_RC_CVc or narrative_RC_CVi found without DS12.narrative_cost (by CAL_ID). |
9110497 | SV Root Cause Narrative Missing CAL Schedule Narrative | MINOR | Is this SVi or SVc VAR narrative missing a corrective action log entry with a schedule narrative? | narrative_RC_SVc or narrative_RC_SVi found without DS12.narrative_schedule (by CAL_ID). |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1120502 | Duplicate VAR CAL Entry | CRITICAL | Is this VAR CAL entry duplicated by CAL ID & transaction ID? | Count of CAL_ID & transaction_ID combo > 1. |
1120497 | Closed Date Before Original Due Date | MAJOR | Is the closed date for this corrective action before the original due date? | closed_date < original_due_date. |
1120498 | Initial Date After Original Due Date | MAJOR | Is the initial date for this corrective action after the original due date? | initial_date > original_due_date. |
1120499 | Original Due Date After Forecast Due Date | MAJOR | Is the original due date for this corrective action after the forecast due date? | original_due_date > forecast_due_date. |
1120500 | Duplicate Transaction ID | MAJOR | Is the transaction ID on this corrective action duplicated? | Count of transaction_ID > 1. |
1120501 | Transaction ID Missing | MAJOR | Is the transaction ID missing? | transaction_ID blank or missing. |
9120496 | CAL ID Missing in Variance CAL ID List | MAJOR | Is this CAL missing in the variance CAL list? | CAL_ID not in DS11.CAL_ID list. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1130538 | Duplicate Subcontract Task | CRITICAL | Is this subcontract task duplicated by subcontract ID, subcontract PO ID, & task ID? | Count of subK_id, subK_task_id, & task_ID combo > 1. |
1130502 | ACWP Dollars Missing | MAJOR | Is ACWP missing on this subcontract? | ACWPc_dollars missing or 0. |
1130503 | BAC Dollars Missing | MAJOR | Is BAC missing on this subcontract? | BAC_dollars missing or 0. |
1130504 | BAC Initial Dollars Missing | MAJOR | Are BAC initial dollars missing on this subcontract? | BAC_initial_dollars missing or 0. |
1130505 | BCWP Dollars Missing | MAJOR | Is BCWP missing on this subcontract? | BCWPc_dollars missing or 0. |
1130506 | BCWS Dollars Missing | MAJOR | Is BCWS missing on this subcontract? | BCWSc_dollars missing or 0. |
1130507 | EAC Dollars Missing | MAJOR | Is EAC missing on this subcontract? | EAC_dollars missing or 0. |
1130508 | MR Dollars Missing | MAJOR | Is MR missing on this subcontract? | MR_dollars missing or 0. |
1130509 | MR Initial Dollars Missing | MAJOR | Is MR Initial missing on this subcontract? | MR_initial_dollars missing or 0. |
1130510 | Profit Fee Dollars Missing | MAJOR | Are profit fee dollars missing on this subcontract? | profit_fee_dollars missing or 0. |
1130511 | Profit Fee Earned Dollars Missing | MAJOR | Are profit fee earned dollars missing on this subcontract? | profit_fee_earned_dollars missing or 0. |
1130512 | Profit Fee Initial Dollars Missing | MAJOR | Are profit fee initial dollars missing on this subcontract? | profit_fee_initial_dollars missing or 0. |
1130513 | Actual Finish Without Actual Start | MAJOR | Is this subcontract with actual finish date missing an actual start? | AF_date found without AS_date. |
1130517 | Actual Finish After Actual Start | MAJOR | Is the actual start after the actual finish? | AS_date > AS_date. |
1130523 | Missing BL Finish | MAJOR | Is the baseline finish date missing? | BL_finish_date is missing. |
1130524 | BL Start After BL Finish | MAJOR | Is the baseline start date after the baseline finish? | BL_start_date > BL_finish_date. |
1130526 | Missing BL Start | MAJOR | Is the baseline start date missing? | BL_start_date is missing. |
1130527 | Complete Subcontract Missing Actual Finish | MAJOR | Is this 100% complete subcontract missing an actual finish date? | BCWPc_dollars / BAC_dollars = 1 & AF_date missing. |
1130531 | Missing FC Finish | MAJOR | Is the forecast finish missing? | FC_finish_date missing. |
1130532 | FC Start After FC Finish | MAJOR | Is the forecast start date after the forecast finish? | FC_start_date > FC_finish_date. |
1130534 | Missing FC Start | MAJOR | Is the forecast start missing? | FC_start_date missing. |
1130535 | Missing Flow Down | MAJOR | Is the flow down missing? | flow_down is missing or blank. |
1130536 | Actuals Without Actual Start | MAJOR | Is this subcontract with ACWP missing an actual start date? | ACWPc_dollars > 0 & AS_date missing. |
9130514 | ACWP Misaligned With Cost (CA) | MAJOR | Are the actuals for this subcontract misaligned with what is in cost? | ACWPc_dollars <> sum of DS03.ACWPi_dollars where EOC = Subcontract (by DS01.WBS_ID, DS01.parent_WBS_ID, FC DS04.WBS_ID, & DS03.WBS_ID_CA). |
9130515 | ACWP Misaligned With Cost (WP) | MAJOR | Are the actuals for this subcontract misaligned with what is in cost? | ACWPc_dollars <> sum of DS03.ACWPi_dollars where EOC = Subcontract (by FC DS04.WBS_ID & DS03.WBS_ID_WP). |
9130519 | BAC Misaligned With Cost (WP) | MAJOR | Is the budget for this subcontract misaligned with what is in cost? | BAC_dollars <> sum of DS03.BCWSi_dollars where EOC = Subcontract (by FC DS04.WBS_ID & DS03.WBS_ID_WP). |
9130520 | BCWP Misaligned With Cost (WP) | MAJOR | Is the performance for this subcontract misaligned with what is in cost? | BCWPc_dollars <> sum of DS03.BCWPi_dollars where EOC = Subcontract (by FC DS04.WBS_ID & DS03.WBS_ID_WP). |
9130521 | BCWS Misaligned With Cost (WP) | MAJOR | Is the cumulative budget for this subcontract misaligned with what is in cost? | BCWSc_dollars <> sum of DS03.BCWSi_dollars where EOC = Subcontract & period_date <= CPP_Status_Date (by FC DS04.WBS_ID & DS03.WBS_ID_WP). |
9130528 | EAC Misaligned With Cost (CA) | MAJOR | Is the estimate at completion for this subcontract misaligned with what is in cost? | EAC_dollars <> sum of DS03.ACWPi_dollars + DS03.ETCi_dollars where EOC = Subcontract (by DS01.WBS_ID, DS01.parent_WBS_ID, FC DS04.WBS_ID, & DS03.WBS_ID_CA). |
9130529 | EAC Misaligned With Cost (WP) | MAJOR | Is the estimate at completion for this subcontract misaligned with what is in cost? | EAC_dollars <> sum of DS03.ACWPi_dollars + DS03.ETCi_dollars where EOC = Subcontract (by FC DS04.WBS_ID & DS03.WBS_ID_WP). |
9130537 | Task ID Missing in Forecast Schedule | MAJOR | Is this task id missing in the forecast schedule? | task_ID not in DS04.task_ID where schedule_type = FC. |
9130538 | Task ID Missing in Labor Resources | MAJOR | Is this task id missing in the forecast labor resources? | task_ID not in DS06.task_ID where EOC = Labor & schedule_type = FC. |
1130537 | EAC Dollars > BAC Dollars | MINOR | Is the EAC greater than the BAC on this subcontract? | EAC_dollars > BAC_dollars. |
9130516 | Actual Finish Misaligned with Forecast Schedule | MINOR | Is the actual finish date misaligned with the actual finish in the forecast schedule? | AF_date <> DS04.AF_date where schedule_type = FC (by task_ID). |
9130518 | Actual Start Misaligned with Forecast Schedule | MINOR | Is the actual start date misaligned with the actual start in the forecast schedule? | AS_date <> DS04.AS_date where schedule_type = FC (by task_ID). |
9130522 | BL Finish Misaligned with Baseline Schedule | MINOR | Is the baseline finish date misaligned with the early finish in the baseline schedule? | BL_finish_date <> DS04.EF_date where schedule_type = BL (by task_ID). |
9130525 | BL Start Misaligned with Baseline Schedule | MINOR | Is the baseline start date misaligned with the early start in the baseline schedule? | BL_start_date <> DS04.ES_date where schedule_type = BL (by task_ID). |
9130530 | FC Finish Misaligned with Forecast Schedule | MINOR | Is the forecast finish date misaligned with the early finish in the forecast schedule? | FC_finish_date <> DS04.EF_date where schedule_type = FC (by task_ID). |
9130533 | FC Start Misaligned with Forecast Schedule | MINOR | Is the forecast start date misaligned with the early start in the forecast schedule? | FC_start_date <> DS04.ES_date where schedule_type = FC (by task_ID). |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1140543 | Duplicate HDV-CI ID | CRITICAL | Is the HDV-CI duplicated? | Count of HDV_CI_ID > 1. |
1140540 | Equipment ID Without SubK ID | MAJOR | Is there an equipment ID without a subcontract ID? | equipment_ID found while subK_ID is missing or blank. |
1140547 | Subcontract PO ID Missing Subcontract ID | MAJOR | Is there a subcontract PO ID without a subcontract ID? | subK_PO_ID found but subK_ID is missing or blank. |
9140539 | Subcontract PO & Subcontract ID Combo Misaligned with Subcontract Work Data | MAJOR | Is this combo subcontract PO & subcontract ID misaligned with what is in the subcontract data? | Combo of subK_PO_ID & subK_ID <> combo of DS13.subK_PO_ID & DS13.subK_ID. |
9140541 | Equipment Without Subcontract or Material Resources (BL) | MAJOR | Is the equipment for this HDV-CI missing accompanying baseline subcontract or material resources? | equipment_ID found where subK_ID not in DS13.subK_ID list with DS06 BL resources of EOC = material or subcontract (by DS14.subK_ID & DS13.subK_ID, and DS13.task_ID & DS06.task_ID). |
9140542 | Equipment Without Subcontract or Material Resources (FC) | MAJOR | Is the equipment for this HDV-CI missing accompanying forecast subcontract or material resources? | equipment_ID found where subK_ID not in DS13.subK_ID list with DS06 FC resources of EOC = material or subcontract (by DS14.subK_ID & DS13.subK_ID, and DS13.task_ID & DS06.task_ID). |
9140544 | HDV-CI Missing in Schedule (FC) | MAJOR | Is the HDV-CI missing in the forecast schedule? | HDV_CI_ID not in DS04.HDV_CI_ID list where schedule_type = FC. |
9140545 | HDV-CI Missing in Schedule (FC) | MAJOR | Is the HDV-CI missing in the forecast schedule? | HDV_CI_ID not in DS04.HDV_CI_ID list where schedule_type = FC. |
9140546 | Subcontract ID Missing in Subcontract Work Records | MAJOR | Is the subcontract ID missing in the subcontract dataset? | subK_ID not in DS14.subK_ID list. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1150559 | Risk Duplicated | CRITICAL | Is this risk duplicated by risk ID & revision? | Count of risk_ID & revision combo > 1. |
1150556 | Probability Schedule Min Equal To Or Above 98% | MAJOR | Is the minimum probability schedule percent equal to or above 98%? | probability_schedule_min_pct >= .98. |
1150561 | Probability Cost Min Equal To Or Above 98% | MAJOR | Is the minimum probability cost percent equal to or above 98%? | probability_cost_min_pct >= .98. |
9150560 | Risk Missing Impact Task | MAJOR | Is this risk missing an impact task in the risk log? | risk_ID not in DS16.task_ID list where risk_task_type = Impact. |
1150548 | Opportunity With Avoid Or Transfer Handling Type | MINOR | Does this opportunity have an avoid or transfer handling type? | type = O & risk_handling = Avoid or Transfer. |
1150549 | Approved Date After Closed Date | MINOR | Is the approved date after the closed date? | approved_date > closed_date. |
1150550 | Approved Date After Realized Date | MINOR | Is the approved date after the realized date? | approved_date > realized_date. |
1150553 | Probability Cost Min % Greater Than Max % | MINOR | Is the minimum probability cost percent greater than the max percent? | probability_cost_min_pct > probability_cost_max_pct. |
1150554 | Probability Cost Min Between 92 - 98% | MINOR | Is the minimum probability cost percent between 92 & 98%? | probability_cost_min_pct >= .92 & < .98. |
1150555 | Probability Schedule Min % Greater Than Max % | MINOR | Is the minimum probability schedule percent greater than the max percent? | probability_schedule_min_pct > probability_schedule_max_pct. |
1150557 | Probability Schedule Min Between 92 - 98% | MINOR | Is the minimum probability schedule percent between 92 & 98%? | probability_schedule_min_pct >= .92 & < .98. |
1150558 | Realized Date After Closed Date | MINOR | Is the realized date after the closed date? | realized_date > closed_date. |
9150551 | Risk Closed Before Risk Tasks Have Completed | MINOR | Is the closed date before all the risk's tasks have finished? | closed_date < FC DS04.EF_date (by DS15.risk_ID & DS16.risk_ID, and DS16.task_ID & DS04.task_ID). |
9150552 | Risk Mitigation Task Missing In Baseline Schedule | MINOR | Is this risk mitigation task missing in the baseline schedule? | risk_handling = Mitigate & risk_ID not in BL DS04.RMT_ID list. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1160569 | Duplicate Risk Task | CRITICAL | Is this risk task duplicated by risk ID & task ID? | Count of combo of risk_ID & task_ID > 1. |
1160565 | Impact Cost Dollar Spread Missing | MAJOR | Are the minimum, likely, and max impact cost dollars all equivalent? | impact_cost_minimum_dollars = impact_cost_likely_dollars = impact_cost_max_dollars. |
1160568 | Impact Schedule Day Spread Missing | MAJOR | Are the minimum, likely, and max impact schedule days all equivalent? | impact_schedule_minimum_days = impact_schedule_likely_days = impact_schedule_max_days. |
9160570 | Risk ID Missing In Risk Log | MAJOR | Is this risk ID missing in the risk log? | Risk_ID not in DS15.risk_ID list. |
9160571 | Task ID Missing in Baseline Schedule | MAJOR | Is this task ID missing in the baseline schedule? | task_ID not in DS04.task_ID list where schedule_type = BL. |
9160572 | Task ID Missing in Forecast Schedule | MAJOR | Is this task ID missing in the forecast schedule? | task_ID not in DS04.task_ID list where schedule_type = FC. |
1160561 | Event With Impact | MINOR | Does this event task have an impact value on cost and/or schedule? | risk_task_type = Event & non-zero value found in impact_schedule_min_days, impact_schedule_likely_days, impact_schedule_max_days, impact_cost_min_dollars, impact_cost_likely_dollars, or impact_cost_max_dollars. |
1160562 | Impact Missing Impact Value | MINOR | Is this impact task missing an impact value on cost and/or schedule? | risk_task_type = Impact & value missing on at least one of impact_schedule_min_days, impact_schedule_likely_days, impact_schedule_max_days, impact_cost_min_dollars, impact_cost_likely_dollars, or impact_cost_max_dollars. |
1160563 | Likely Impact Cost Dollars Greater Than Max Dollars | MINOR | Are the likely impact dollars for cost greater than the max impact dollars? | impact_cost_likely_dollars > impact_cost_max_dollars. |
1160564 | Minimum Impact Cost Dollars Greater Than Likely Dollars | MINOR | Are the minimum impact dollars for cost greater than the likely impact dollars? | impact_cost_minimum_dollars > impact_cost_likely_dollars. |
1160566 | Likely Impact Schedule Days Greater Than Max Days | MINOR | Are the likely impact days for schedule greater than the max impact days? | impact_schedule_likely_days > impact_schedule_max_days. |
1160567 | Minimum Impact Schedule Days Greater Than Likely Days | MINOR | Are the minimum impact days for schedule greater than the likely impact days? | impact_schedule_minimum_days > impact_schedule_likely_days. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1170582 | Duplicate Estimate Uncertainty Entry | CRITICAL | Is this WBS / EOC combo duplicated? | Count of combo WBS & EOC combo > 1. |
1170573 | EU Justification Missing | MINOR | Is an EU justification missing for why the min dollars equal the likely, the likel equal the max, or the min equal the max? | justification_EU is missing or blank & EU_min_dollars = EU_likely_dollars, EU_likely_dollars = EU_max_dollars, or EU_max_dollars = EU_min_dollars. |
1170574 | EU Lacking Spread | MINOR | Are the EU minimum, likely, and maximum dollars all equal? | EU_min_dollars = EU_likely_dollars = EU_max_dollars. |
1170575 | EU Likely Dollars Greater Than Max | MINOR | Are the EU likely dollars greater than the max dollars? | EU_likely_dollars > EU_max_dollars. |
1170579 | EU Minimum Dollars Greater Than Likely | MINOR | Are the EU minimum dollars greater than the likely dollars? | EU_min_dollars > EU_likely_dollars. |
1170580 | WBS Time Dependence Inconsistent | MINOR | Is the time dependent flag inconsistent within this WBS? | time_dependent is not all Y or all N by WBS_ID. |
9170576 | EU Max Dollars Less Than DB | MINOR | Are the EU maximum dollars less than the cost DB for this WBS_ID / EOC combo? | EU_max_dollars < DS03.DB by WBS_ID_WP & EOC. |
9170577 | EU Max Dollars Less Than EAC (CA) | MINOR | Are the EU maximum dollars less than the cost EAC (at the CA level)? | EU_max_dollars < DS03.EAC by WBS_ID_CA & EOC. |
9170578 | EU Max Dollars Less Than EAC (WP) | MINOR | Are the EU maximum dollars less than the cost EAC for this WBS / EOC combo? | EU_max_dollars < DS03.EAC by WBS_ID_WP & EOC. |
9170579 | WBS & EOC Combo Missing in Cost | MINOR | Is this WBS_ID / EOC combo missing in the cost processor? | Combo of WBS_ID_WP & EOC missin in DS03. |
9170581 | Non-LOE Time Dependence | MINOR | Is this time dependent WBS non-LOE in cost? | time_dependent = Y & DS03.EVT <> A (by WBS_ID). |
9170583 | WBS Missing in WBS Hierarchy | MINOR | Is this WBS missing in the WBS hierarchy? | WBS missing in DS01.WBS_ID list. |
9170584 | WBS Of Non-WP or PP Type | MINOR | Is this WBS of a type other than WP or PP? | WBS_ID not in DS01.WBS_ID where type = WP or PP. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1180590 | Duplicate Schedule EU Task | CRITICAL | Is this schedule EU task duplicated by task ID & schedule type? | Count of task_ID & schedule_type combo > 1. |
1180585 | Schedule EU Justification Missing | MINOR | Is the EU justification missing to explain why the min EU days equal the likely, the likely equal the max, or the min equal the max? | justification_EU is missing or blank & EU_min_days = EU_likely_days, EU_likely_days = EU_max_days, or EU_max_days = EU_min_days. |
1180586 | Schedule EU Lacking Spread | MINOR | Are the EU minimum, likely, and maximum days all equal? | EU_min_days = EU_likely_days = EU_max_days. |
1180587 | EU Likely Days Greater Than Max | MINOR | Are the EU likely days greater than the max days? | EU_likely_days > EU_max_days. |
1180589 | EU Minimum Days Greater Than Likely | MINOR | Are the EU minimum days greater than the likely days? | EU_min_days > EU_likely_days. |
9180588 | EU Maximum Days Less Than Original Duration | MINOR | Are the EU maximum days for this task less than the original duration? | EU_max_days < DS04.duration_original_days by schedule_type, task_ID, and subproject_ID. |
9180591 | Schedule EU Task Missing in Schedule | MINOR | Is this schedule EU task missing in its respective schedule? | task_ID not in DS04.task_ID list (by schedule_type, task_ID, and subproject_ID). |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1190593 | Duplicate Calendar Name | CRITICAL | Is this calendar name duplicated in the dataset (by subproject_ID)? | Count calendar_name > 1 (by subproject_id). |
1190592 | Hours Per Day Less Than Zero Or Greater Than 24 | MAJOR | Are the hours per day negative or greater than 24? | hours_per_day < 0 or hours_per_day > 24. |
1190594 | Shift Exceeds 12 Hours | MINOR | Are the hours of any of your shifts in excess of 12 hours? | Hours delta between std*##_DDD_shift*#start_time & std##DDD_shift#_stop_time > 12. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1200595 | Duplicate Calendar Exception | CRITICAL | Is this calendar exception duplicated by calendar name, subproject, & exception date? | Count of calendar_name, subproject_ID, & exception_date combo > 1. |
1200597 | Non-Workday Exception Missing Shift | MINOR | Is this non-workday exception missing a shift? | exceptionwork_day = N & no exception_shift#start_time or exception_shift#_finish_time found. |
1200598 | Shift Exception In Excess Of 12 Hours | MINOR | Is this shift exception longer than 12 hours? | Delta between exceptionshift#start_time & exception_shift#_finish_time found > 12. |
9200596 | Calendar Name Missing In Standard Calendar List | MINOR | Is this calendar missing in the standard list of calendars? | calendar_name not in DS19.calendar_name list. |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1210602 | Duplicate Rate | CRITICAL | Is this rate duplicated by resource ID? | Count resource_ID > 1. |
1210600 | Indirect Rate Missing Burden | MAJOR | Is there a burden ID missing for this indirect rate? | type = I & burden_ID is missing or blank. |
1210599 | Negative Or Zero Rate Dollars | MINOR | Is the rate negative or zero? | rate_dollars <= 0. |
1210601 | Direct Overhead EOC | MINOR | Is this Overhead rate typed as direct? | type = D & EOC = Overhead. |
9210602 | Resource & EOC Combo Missing in Forecast Resources | MINOR | Is this resource EOC missing in the forecast resources? | resource_ID & EOC combo not found in DS06.resource_ID & DS06.EOC (where schedule_type = FC). |
9210603 | Labor Rate Escalation Exceeds Allowable Rate in the IPMR Header | MINOR | Did the rate change for this labor resource between last FY and this FY exceed the allowed rate as provided in the IPMR header? | (DS21.rate_dollars for current FY - DS21.rate_dollars previous FY) / DS21.rate_dollars previous FY - DS07.escalation_rate_pct > .02 (by resource_ID) . |