UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1000001 | CPP Status Date Missing From Cost Periods | ERROR | 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 | WARNING | 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 | ERROR | 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 | ERROR | 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 | ERROR | 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 | ERROR | 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 | ERROR | Is the Parent WBS ID missing? | Parent WBS ID is missing. |
1010032 | WBS ID Not Unique | ERROR | 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 | ERROR | 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 | ERROR | 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 | ERROR | 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 | ERROR | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | Does the SLPP have a child in the WBS hierarchy? | SLPP found with child in the WBS hierarchy. |
1010011 | WP or PP with Child | WARNING | 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 | WARNING | 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 | WARNING | Is the CA, WP, or PP missing a CAM? | CA, WP, or PP is missing a CAM name |
1010018 | Exit Criteria Missing | WARNING | 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 | WARNING | Is the external WBS missing a subproject ID? | External = Y & subproject_ID is missing or blank. |
1010020 | Title Equal to Narrative | WARNING | 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 | WARNING | Is the narrative only one word? | Narrative is only one word. |
1010022 | OBS ID Missing | WARNING | Is the OBS_ID null or blank? | OBS ID is missing |
1010028 | PM Name Inconsistent | WARNING | 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 | WARNING | 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 | WARNING | Is the WBS ID missing delimiters? | WBS ID is missing delimiters (periods recommended). |
1010035 | WPM Name Found on WBS, CA, or SLPP | WARNING | 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 | WARNING | Is this WP / PP missing a WAD? | WBS_ID not in DS08.WBS_ID_WP list. |
9010004 | Different CAM Name from DS04 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | ALERT | Is the WBS ID contained in the title? | WBS Titles should not contain the WBS ID. |
1010009 | WBS ID with Adjacent Letters | ALERT | Does the WBS ID contain letters side by side? | WBS ID contains letters adjacent to one another. |
1010010 | WPM Name Matches CAM | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | 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 | ERROR | Is the OBS ID repeated across the OBS hierarchy? | OBS ID is not unique across the OBS hierarchy. |
1020047 | Root of OBS Not Unique | ERROR | 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 | ERROR | 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 | ERROR | 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 | WARNING | Does the Title contain the OBS ID? | OBS ID found within OBS Title. |
1020042 | Title Equal to Narrative | WARNING | Are the Title and Narrative the same? | Narrative is not distinct from the Title |
1020049 | Parent OBS ID Missing | WARNING | Is the Parent OBS ID missing? | Parent OBS ID is missing. |
1020052 | Title Not Unique | WARNING | Does the Title appear more than once across the OBS hierarchy? | OBS Title is not unique across the OBS hierarchy. |
1020043 | Narrative Missing | ALERT | Is the OBS narrative missing? | Narrative is missing. |
9020041 | CA Marked as External | ALERT | Is this CA marked as external? | CA is marked as external. |
9020046 | OBS ID Missing in DS01 OBS List | ALERT | 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 | ERROR | 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 | ERROR | 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 | ERROR | 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 | ERROR | Is the WP or PP found across multiple Control Accounts? | WBS_ID_WP found across distinct WBS_ID_CA. |
1030108 | Non-Unique Cost Row | ERROR | 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 | ERROR | Has this SLPP, CA, or PP collected performance? | SLPP, CA, or PP found with BCWPi <> 0 (Dollars, Hours, or FTEs). |
9030062 | CA with Budget | ERROR | Does this CA have budget? | CA found with BCWSi > 0 (Dollars, Hours, or FTEs). |
9030078 | Apportionment IDs Mismatch Between Cost and Schedule | ERROR | 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 | WARNING | Were actuals collected in the future? | ACWPi <> 0 (Dollars, Hours, or FTEs) and period_date > cpp_status_date. |
1030060 | Future Performance | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | Does this WP or PP have negative performance? | WP or PP found with BCWPi < 0 (Dollars, Hours, or FTEs). |
1030080 | Negative Budget | WARNING | Does this WP or PP have negative budget? | WP or PP found with BCWSi < 0 (Dollars, Hours, or FTEs). |
1030084 | Negative Estimates | WARNING | 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 | WARNING | 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 | WARNING | Is this WP or PP missing an EVT? | EVT is missing. |
1030099 | Estimates On Completed Work | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | Are there estimates on this CA or PP? | CA or PP with ETCi <> 0 (Dollars, Hours, or FTEs). |
9030071 | SLPP or PP with Actuals | WARNING | 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 | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | Does this CA, WP, or PP have negative actuals? | CA, WP, or PP found with ACWPi < 0 (Dollars, Hours, or FTEs). |
1030081 | Budget Missing | ALERT | 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 | ALERT | Does this work use a 100-0 EVT? | 100-0 EVT (EVT = G) used (This is not recommended). |
1030088 | Labor Missing Actuals | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | Is this period date after PMB end? | Period_date > DS04.ES_Date for milestone_level = 175. |
1030116 | Inconsistent Use of Indirect | ERROR | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | Do the CA & WP WBS IDs match? | WBS_ID_CA = WBS_ID_WP |
1030114 | Indirect With Hours and/or FTEs | ALERT | 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 | ERROR | Does this BL task have negative free float? |
1040118 | BL Task With Negative Total Float | ERROR | Does this BL task have negative total float? |
1040139 | Activity Missing EVT | ERROR | Is this activity missing an EVT? |
1040141 | Missing Apportioned To Task ID | ERROR | Is this apportioned task missing an apportioned to task ID? |
1040206 | Approve Finish Project Milestone Missing in Baseline | ERROR | Is your baseline schedule missing the approve finish project milestone? |
1040207 | Approve Finish Project Milestone Missing in Forecast | ERROR | Is your forecast schedule missing the approve finish project milestone? |
1040208 | Approve Start Project Milestone Missing in Baseline | ERROR | Is your baseline schedule missing the approve start project milestone? |
1040209 | Approve Start Project Milestone Missing in Forecast | ERROR | Is your forecast schedule missing the approve start project milestone? |
1040210 | Schedule Missing | ERROR | Is your schedule data missing either the BL or FC schedule? |
1040215 | Duplicate Task ID | ERROR | Is this task duplicated in the schedule? |
1040220 | WBS Misaligned Between FC & BL | ERROR | Is the WBS ID for this task misaligned between the FC & BL schedules? |
1040107 | CD / BCP Milestones Out of Sequence | WARNING | Is this CD or BCP out of sequence chronologically in the milestone list? |
1040114 | Comingling of SVT & Non-SVT | WARNING | Does this WBS comingle SVT & Non-SVT tasks? |
1040115 | Activity with Original Duration of Zero | WARNING | Does this activity have an original duration of zero? |
1040119 | Completed Activity with Zero Actual Duration | WARNING | Does this completed activity have an actual duration of zero? |
1040121 | Completed Task with Remaining Duration | WARNING | Does this completed task have remaining duration? |
1040123 | Discrete Task Without Non-Physical % Complete Type | WARNING | Does this discrete task have a % Complete type that is not Physical? |
1040124 | WBS Summary Task or Milestone with EVT | WARNING | Does this WBS Summary task or Start/Finish Milestone have an EVT? |
1040125 | Hard Constraint Found | WARNING | Is there a hard constraint on this task? |
1040126 | LOE Task without Duration % Complete | WARNING | Does this LOE task have a % Complete type other than Duration? |
1040127 | Milestone with Non-Zero Duration | WARNING | Does this milestone have a non-zero duration? |
1040128 | Milestone % Complete Not Equal To 0 Or 100% | WARNING | Does this milestone have a % Complete other than 0 or 100%? |
1040130 | RPG Without Approve Repgrogramming Milestone | WARNING | Does RPG exist without an an approve repgrogramming milestone? |
1040132 | SVT or ZBA with EVT | WARNING | Does this SVT or ZBA have an EVT? |
1040133 | SVT Not Of Allowed Milestone Type | WARNING | Is this non-milestone task marked as an SVT? |
1040135 | WBS With Only ZBA Tasks | WARNING | Does this WBS have only ZBA tasks? |
1040143 | Actual Start Later Than Actual Finish | WARNING | Does this task have an Actual Start later than the Actual Finish? (FC) |
1040145 | Baseline Task Missing In Forecast | WARNING | Is this task missing in the forecast schedule? |
1040150 | CD-0 Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the CD-0 milestone? |
1040151 | CD-0 Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the CD-0 milestone? |
1040152 | CD-1 Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the CD-1 milestone? |
1040153 | CD-1 Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the CD-1 milestone? |
1040154 | CD-2 Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the CD-2 milestone? |
1040155 | CD-2 Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the CD-2 milestone? |
1040156 | CD-3 Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the CD-3 milestone? |
1040157 | CD-3 Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the CD-3 milestone? |
1040158 | CD-4 Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the CD-4 milestone? |
1040159 | CD-4 Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the CD-4 milestone? |
1040162 | Contract Completion Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the Contract Completion milestone? |
1040163 | Contract Completion Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the Contract Completion milestone? |
1040166 | Actual Finish Prior to Early Finish Along the Driving Path | WARNING | 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 | WARNING | 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 | WARNING | Is this non-LOE task using a Duration % Complete type? |
1040169 | Early Finish Later Than Late Finish | WARNING | Is the early finish after the late finish? |
1040171 | End of PMB Milestone Missing in Baseline | WARNING | Is your baseline schedule missing the End of PMB milestone? |
1040172 | End of PMB Milestone Missing in Forecast | WARNING | Is your forecast schedule missing the End of PMB milestone? |
1040173 | Early Start Later Than Early Finish | WARNING | Is the early start later than the early finish? |
1040174 | Early Start Later Than Late Start | WARNING | Is the early start later than the late start? |
1040176 | EVT Missing Justification | WARNING | Is this task missing a required justification for the selected EVT? |
1040177 | EVT Misaligned Between BL & FC | WARNING | Is the EVT for this task misaligned between BL & FC schedules? |
1040179 | Actual Start Missing on Finished Task | WARNING | Is this task missing an Actual Start even though it has an Actual Finish? (FC) |
1040180 | Hard Constraint Missing Date | WARNING | Is this hard constraint missing a constraint date? |
1040181 | Hard Constraint Missing Justification | WARNING | Does this task have a hard constraint without a justification? |
1040186 | LOE Mingled With Other EVT Types | WARNING | Is LOE mingled with other EVT types for this WBS? |
1040188 | LOE or WBS Summary Task On Driving Path | WARNING | Is this LOE or WBS summary task on the driving path? |
1040190 | Late Start Later Than Late Finish (FC) | WARNING | Is the late start date later than the late finish? (FC) |
1040191 | Major Milestone Not Coded As SVT | WARNING | Is this major milestone not coded as an SVT? |
1040192 | Milestone Prior To Approve Start Project | WARNING | Is this milestone earlier than the Approve Start Project Milestone? |
1040193 | Milestone After Approve Finish Project | WARNING | Is this milestone after the Approve Finish Project Milestone? |
1040195 | Milestone Typed Improperly | WARNING | Is this milestone not typed as a start or finish milestone? |
1040199 | Completed Task Missing Actual Finish | WARNING | Is this completed task (physical, units, or duration % complete = 100%) missing an Actual Finish? |
1040200 | Started Task Missing Actual Start | WARNING | Is this task with a non-zero % Complete missing an Actual Start? |
1040226 | ZBA Not Coded As Subcontract Alignment Milestone | WARNING | Should this ZBA be coded as a subcontract alignment milestone? |
9040140 | Actual Finish Misaligned With Cost (WP) | WARNING | Is the actual finish for this WP misaligned with last recorded ACWP or BCWP in cost? |
9040144 | Actual Start Misaligned With Cost (WP) | WARNING | Is the actual start for this WP misaligned with last recorded ACWP or BCWP in cost? |
9040149 | Actual Finish Misaligned With Cost (CA) | WARNING | 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) | WARNING | 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 | WARNING | Is this BCP missing an entry in the Change Control log? |
9040170 | Finish Date Misaligned With Cost | WARNING | Is the early finish date for this WBS misaligned with what is in cost (DS03)? |
9040175 | Start Date Misaligned With Cost | WARNING | Is the early start date for this WBS misaligned with what is in cost (DS03)? |
9040182 | HDV CI ID Missing in HDV CI List | WARNING | Is this HDV CI ID missing in the HDV CI list (DS14)? |
9040196 | Milestone With Resources | WARNING | Is this milestone resource-loaded? |
9040198 | WBS Justification Missing | WARNING | Is non-WP, PP, or SLPP WBS type missing a justification? |
9040200 | WBS Summary Task with Logic | WARNING | Does this WBS Summary task have logic? |
9040212 | Subproject Mismatch with WBS Dictionary | WARNING | Is this subproject ID mismatched with what is in DS01 (WBS)? |
9040214 | Resource Loaded SVT or ZBA | WARNING | Is this SVT or ZBA resource loaded? |
9040216 | Missing Logic | WARNING | Is this task missing logic? |
9040217 | Missing Resources | WARNING | Is this task missing resources (DS06)? |
9040219 | Task With Units % Complete Not Materially Resource Loaded | WARNING | Does this task with units % complete have resources with an EOC other than material? |
9040222 | WBS Missing in WBS Dictionary | WARNING | Is this WBS ID missing in the WBS Dictionary? |
9040223 | WBS Missing in Cost | WARNING | Is this WBS ID missing in Cost? |
9040224 | WBS Summary With Resources | WARNING | Is this WBS Summary resource-loaded? |
9040278 | EVT Mismatch | WARNING | Is this task's EVT mismatched with what is in cost? |
9040280 | Reprogramming Missing in CC Log Detail (WP) | WARNING | Is this Work or Planning Planning with reprogramming missing in the CC Log detail? |
1040113 | Task Starts or Finishes after End of PMB | ALERT | Is this task forecasted to start or finish after the end of the PMB? |
1040122 | Task Description Contains Task ID | ALERT | Does the description contain the task ID? |
1040131 | Soft Constraint Found | ALERT | Is there a soft constraint on this task? |
1040136 | Multiple Replanning Milestones In Current Period | ALERT | Do multiple replanning milestones exist in the current period? |
1040137 | Multiple Reprogramming Milestones In Current Period | ALERT | Do multiple reprogramming milestones exist in the current period? |
1040138 | Actual & Remaining Durations Sum to More Than Original | ALERT | Do the actual and remaining durations sum to more than the original? |
1040142 | Actual Start Earlier Than Early Start | ALERT | Does this task have an Actual Start earlier than the Early Start? (FC) |
1040160 | Duplicate CD or BCP Entry | ALERT | Does this CD or BCP appear more than once in the schedule? |
1040161 | Insufficient Constraint Justification | ALERT | Is a sufficient justification lacking for the constraint on this task? |
1040164 | Duplicate Description | ALERT | Is the description for this task duplicated? |
1040165 | Insufficient Description | ALERT | Is the task lacking a proper description? |
1040178 | Forecast Task Missing In Baseline | ALERT | Is this task missing in the baseline schedule? |
1040183 | Insufficient High Float Justification | ALERT | Is a sufficient justification lacking for this task with high float? |
1040184 | High Float Missing Justification (FC) | ALERT | Is this FC task with high float missing a justification in the forecast schedule? |
1040185 | Insufficient Lag Justification | ALERT | Is a sufficient justification lacking for this task with lag? |
1040189 | LOE Type With Mismatched EVT | ALERT | Is the LOE type mismatched with the EVT for this task? |
1040194 | Insufficient Milestone Level Description | ALERT | Is a sufficient milestone level description lacking for this milestone? |
1040197 | Non-CD or BCP Milestone Missing Description | ALERT | Is this non-CD or BCP milestone missing a description? |
1040201 | Units % Complete Type Utilized | ALERT | Is this task using a Units % Complete type? |
1040202 | Planned/Estimated Completion Misaligned with End of PMB | ALERT | 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 | ALERT | Is this major post-CD3 milestone not coded as a finish milestone? |
1040205 | Pre-CD3 Project Milestone Not Coded As Start Milestone | ALERT | Is this major pre-CD3 milestone not coded as a start milestone? |
1040211 | Soft Constraint Missing Date | ALERT | Is this soft constraint missing a constraint date? |
1040221 | Insufficient WBS Justification | ALERT | Is a sufficient WBS justification lacking for this task? |
1040228 | BCP Milestones Without Reprogramming | ALERT | Has a BCP occurred without reprogramming tasks? (FC) |
1040229 | BCP Milestones Without Reprogramming | ALERT | Has a BCP occurred without reprogramming tasks? (BL) |
1040230 | Soft Constraint Missing Justification | ALERT | Does this task have a soft constraint without a justification? |
1040321 | CD-4 Early Start or Finish Dates Misaligned Between FC & BL | ALERT | Are the early start or finish dates for the CD-4 milestone misaligned between FC & BL? |
1040603 | High Float Missing Justification (BL) | ALERT | Is this BL task with high float missing a justification in the baseline schedule? |
1040604 | Calculated & Original Durations Misaligned | ALERT | Is the calculated duration substantially different from the original duration? |
1040605 | WBS Summary Task | ALERT | Is this a WBS Summary task? |
9040116 | Quantitative Risk Analysis Confidence Level for Cost Below 95% Following BCP | ALERT | Is the quantitative risk analysis confidence level for cost below 95% following a BCP? |
9040129 | Replan or Repgramming Milestone Without OTB/OTS Date | ALERT | Does this replanning or reprogramming milestone exist without an OTB/OTS Date? |
9040134 | SVT With Logic | ALERT | Does this SVT have logic? |
9040146 | Calendar Name Missing in DS19 (Schedule Calendar STD) | ALERT | Is this calendar name missing in DS19? |
9040148 | CAM Misaligned with DS01 (WBS) | ALERT | Is the CAM for this task misaligned with what is in DS01 (WBS)? |
9040187 | LOE Task With Improper Logic | ALERT | 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 | ALERT | Is the delta between the Planned/Estimated Completion & End of PMB milestones not equal to UB days? |
9040213 | Non-External SVT | ALERT | Is this SVT not marked as external in the WBS dictionary (DS01)? |
9040225 | Non-WP, PP, or SLPP Type Found in Schedule | ALERT | Is this WBS ID typed as something other than WP, PP, or SLPP in the WBS Dictionary? |
9040277 | EVT Justification Misaligned With Cost | ALERT | Is a similar justification for this EVT missing in cost? |
9040279 | Reprogramming Missing in CC Log Detail (CA) | ALERT | Is this Work or Planning Planning with reprogramming missing in the CC Log detail? |
UID | Title | Severity | Summary | Error Message |
---|---|---|---|---|
1050233 | Schedule Missing Logic | ERROR | 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 | ERROR | 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 | ERROR | 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 | ERROR | Is this task missing in the schedule? | task_ID not found in DS04 task_ID list (by schedule_type). |
1050232 | Lead | WARNING | 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 | WARNING | 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 | WARNING | Is this a start-finish relationship? | Relationship type is start-finish (type = SF). |
9050280 | Lag Missing Justification | ALERT | 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 | ERROR | 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 | ERROR | Is this resource missing a name? | Resource found without a resource name (resource_name = null or blank). |
1060253 | Resource Role Missing Name | ERROR | Is this resource role missing a name? | role_ID is not blank & role_name is blank. |
1060254 | Schedule Missing Resources | ERROR | 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 | ERROR | 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 | ERROR | Are the rates missing for this resource? | Resource_ID missing in DS21.resource_ID list. |
9060301 | Resource Task Missing in Schedule | ERROR | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | Has this resource been scheduled with non-zero lag? | Resource planned lag (lag_planned_date) <> 0. |
1060243 | Resource with Non-Zero Remaining Lag | WARNING | Does this resource have a non-zero remaining lag? | Resource remaining lag (lag_remaining_date) <> 0. |
1060244 | Resources with Negative Remaining Budget | WARNING | 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 | WARNING | 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 | WARNING | Is the start date later than the finish date for this resource? | Resource start_date > finish_date. |
1060256 | Labor Resource Lacking Appropriate EOC | WARNING | 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 | WARNING | Does this labor-type resource have a non-hour UOM type? | type = labor where UOM <> h. |
1060258 | Material Resource with Missing or Numeric UOM | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | ALERT | Is this resource lacking budget dollars and/or units? | Resource found without budget (budget_dollars and/or budget_units = 0). |
1060239 | Mistyped Labor EOC | ALERT | Is this Labor EOC mistyped? | Labor EOC (EOC = labor) does not have a type of labor (type <> labor). |
1060246 | Labor Overlap | ALERT | 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 | ALERT | Is this resource name duplicated across resources? | Resource_name repeats across distinct resource_ids. |
1060250 | Resource With Role | ALERT | 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 | ALERT | 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 | ALERT | Is this role name duplicated across roles? | Resource_name repeats across distinct resource_ids. |
9060284 | Resource Performance Misaligned with Cost | ALERT | 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) | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | Is this resource lacking an EOC? | EOC missing (where resource_ID is not blank). |
1060262 | Uneven Use of Indirect | WARNING | 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 | WARNING | 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 | WARNING | Is this resource duplicated across subprojects? | Count of Resource_id > 1 across distinct subproject_id. |
9060302 | Resource Labor Performance without Cost Labor Actuals (WP) | WARNING | 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) | WARNING | 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) | WARNING | 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 | ALERT | Does this indirect resource have hours? | budget, actual, or remaining units > 0 where EOC = Indirect. |
9060304 | Resource Performance without Cost Actuals (CA) | ALERT | 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) | ALERT | 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) | ALERT | 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 | WARNING | Is the MR reprogramming less than zero? |
1070260 | OTB/OTS Date without MR | WARNING | Is there an OTB/OTS date without MR? |
1070262 | Negative CBB | WARNING | Is CBB negative? |
1070263 | CBB Not Equal to NCC Plus AUW | WARNING | Is CBB not equal to NCC plus AUW? |
1070264 | PM EAC Best Date Earlier Than CPP SD | WARNING | Is the PM EAC Best date earlier than the CPP Status Date? |
1070265 | Negative or Zero PM EAC Best Dollars | WARNING | Is the PM EAC Best dollars value zero or negative? |
1070266 | PM EAC Likely Date Earlier Than CPP SD | WARNING | Is the PM EAC likely date earlier than the CPP Status Date? |
1070267 | PM EAC Dates Chronology Issue | WARNING | Are the PM EAC dates chronologically ordered as best, likely, worst? |
1070268 | Negative or Zero PM EAC Likely Dollars | WARNING | Is the PM EAC Likely dollars value zero or negative? |
1070269 | PM EAC Dollars Out of Order | WARNING | Are the PM EAC dollars increasing in an order other than best, likely, worst? |
1070270 | PM EAC Likely Dollars & CBB Issue | WARNING | Are the PM EAC likely dollars greater than the CBB without an OTB/OTS? |
1070271 | PM EAC Worst Date Earlier Than CPP SD | WARNING | Is the PM EAC Worst date earlier than the CPP Status Date? |
1070272 | Negative or Zero PM EAC Worst Dollars | WARNING | Is the PM EAC Worst dollars value zero or negative? |
1070274 | Negative MR Budget | WARNING | Is the MR budget less than zero? |
1070275 | MR Reprogramming without OTB/OTS Date | WARNING | Is there MR reprogramming without an OTB/OTS date? |
1070276 | Negative NCC | WARNING | Is NCC negative? |
1070355 | Negative Profit Fee | WARNING | Is profit fee negative? |
1070357 | Low Cost QRA | WARNING | Is the quantitative risk analysis confidence level for cost less than 70%? |
1070359 | Low Schedule QRA | WARNING | Is the quantitative risk analysis confidence level for schedule less than 70%? |
1070360 | Negative TAB | WARNING | Is the TAB negative? |
1070381 | Contract Type Missing | WARNING | Is the contract type missing? |
1070382 | Negative UB (Days) | WARNING | Are the UB days negative? |
1070383 | Negative UB (Dollars) | WARNING | Are the UB dollars negative? |
1070384 | Negative UB Estimated (Days) | WARNING | Are the UB estimated days negative? |
1070385 | Negative UB Estimated (Dollars) | WARNING | Are the UB estimated dollars negative? |
9070308 | PM EAC Likely Date After CD-4 | WARNING | Is the PM EAC Likely date later than the CD-4 milestone? |
9070338 | OTB / OTS Without BAC Reprogramming | WARNING | Is there an OTB/OTS date without BAC reprogramming? |
9070339 | OTB / OTS Without CV Reprogramming | WARNING | Is there an OTB/OTS date without CV reprogramming? |
9070340 | OTB / OTS Without Schedule Reprogramming | WARNING | Is there an OTB/OTS date without schedule reprogramming? |
9070341 | OTB / OTS Without SV Reprogramming | WARNING | Is there an OTB/OTS date without SV reprogramming? |
9070351 | CBB Misaligned with PMB, MR, & Overrun | WARNING | 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 | WARNING | Does TAB equal something other than CBB plus BAC Reprogramming? |
9070363 | UB Without UB Change Control | WARNING | Are there UB dollars without UB transactions in the change control log? |
9070365 | 12 Months Since OTB-OTS Without BCP | WARNING | Has it been twelve months since an OTB-OTS date without a BCP? |
9070367 | QRA Confidence Level Low for Cost Following BCP | WARNING | Is the QRA Confidence Level below 90% for cost following a BCP? |
9070368 | QRA Confidence Level Low for Schedule Following BCP | WARNING | Is the QRA Confidence Level below 90% for schedule following a BCP? |
9070369 | PMB + MR <> CBB + Overrun | WARNING | Are the PM and MR equal to something other than CBB plus overrun? |
1070273 | High or Low Escalation Rate Percent | ALERT | Is the escalation rate percentage exceptionally low (below 3%) or high (above 20%)? |
1070335 | UB Estimated Greater Than UB Budgeted (Days) | ALERT | Is the UB estimated days amount greater than UB budgeted? |
1070336 | UB Estimated Greater Than UB Budgeted (Dollars) | ALERT | Is the UB estimated dollar amount greater than UB budgeted? |
1070337 | MR Reprogramming | ALERT | Is there MR reprogramming? |
1070342 | UB Budget Days without UB Budget Dollars | ALERT | Are there UB budget days but no UB budget dollars? |
1070343 | UB Budget without UB Estimate (Days) | ALERT | Are there UB budget days but no UB estimated days? |
1070344 | UB Budget Dollars without UB Budget Days | ALERT | Are there UB budget dollars but no UB budget dayss? |
1070345 | UB Budget without UB Estimate (Dollars) | ALERT | Are there UB budget dollars but no UB estimated dollars? |
1070346 | UB Estimated without UB Budget (Days) | ALERT | Are there UB estimated days but no UB budget days? |
1070347 | UB Estimated Days without UB Estimated Dollars | ALERT | Are there UB estimated days but no UB estimated dollars? |
1070348 | UB Estimated without UB Budget (Dollars) | ALERT | Are there UB estimated dollars but no UB budget dollars? |
1070349 | UB Estimated Dollars without UB Estimated Days | ALERT | Are there UB estimated dollars but no UB estimated days? |
1070354 | Zero Profit Fee | ALERT | Is profit fee zero? |
1070356 | Over-Optimistic Cost QRA | ALERT | Is the quantitative risk analysis confidence level for cost above 95%? |
1070358 | Over-Optimistic Schedule QRA | ALERT | Is the quantitative risk analysis confidence level for schedule above 95%? |
1070362 | Zero Favorable Cost Cum Dollar Threshold | ALERT | Is the favorable cost cum dollar threshold equal to zero? |
1070363 | Zero Unfavorable Cost Cum Dollar Threshold | ALERT | Is the unfavorable cost cum dollar threshold equal to zero? |
1070364 | Zero Favorable Cost Cum Percent Threshold | ALERT | Is the favorable cost cum percent threshold equal to zero? |
1070365 | Zero Unfavorable Cost Cum Percent Threshold | ALERT | Is the unfavorable cost cum percent threshold equal to zero? |
1070366 | Zero Favorable Cost Inc Dollar Threshold | ALERT | Is the favorable cost inc dollar threshold equal to zero? |
1070367 | Zero Unfavorable Cost Inc Dollar Threshold | ALERT | Is the unfavorable cost inc dollar threshold equal to zero? |
1070368 | Zero Favorable Cost Inc Percent Threshold | ALERT | Is the favorable cost inc percent threshold equal to zero? |
1070369 | Zero Unfavorable Cost Inc Percent Threshold | ALERT | Is the unfavorable cost inc percent threshold equal to zero? |
1070370 | Zero Favorable Cost VAC Percent Threshold | ALERT | Is the favorable cost VAC percent threshold equal to zero? |
1070371 | Zero Unfavorable Cost VAC Percent Threshold | ALERT | Is the unfavorable cost VAC percent threshold equal to zero? |
1070372 | Zero Favorable Schedule Cum Dollar Threshold | ALERT | Is the favorable schedule cum dollar threshold equal to zero? |
1070373 | Zero Unfavorable Schedule Cum Dollar Threshold | ALERT | Is the unfavorable schedule cum dollar threshold equal to zero? |
1070374 | Zero Favorable Schedule Cum Percent Threshold | ALERT | Is the favorable schedule cum percent threshold equal to zero? |
1070375 | Zero Unfavorable Schedule Cum Percent Threshold | ALERT | Is the unfavorable schedule cum percent threshold equal to zero? |
1070376 | Zero Favorable Schedule Inc Dollar Threshold | ALERT | Is the favorable schedule inc dollar threshold equal to zero? |
1070377 | Zero Unfavorable Schedule Inc Dollar Threshold | ALERT | Is the unfavorable schedule inc dollar threshold equal to zero? |
1070378 | Zero Favorable Schedule Inc Percent Threshold | ALERT | Is the favorable schedule inc percent threshold equal to zero? |
1070379 | Zero Unfavorable Schedule Inc Percent Threshold | ALERT | Is the unfavorable schedule inc percent threshold equal to zero? |
1070380 | CPE Contract Type | ALERT | Is this a CPE contract type? |
1070389 | Zero Favorable Cost VAC Dollar Threshold | ALERT | Is the favorable cost VAC dollar threshold equal to zero? |
1070390 | Zero Unfavorable Cost VAC Dollar Threshold | ALERT | Is the unfavorable cost VAC dollar threshold equal to zero? |
9070302 | PM EAC Likely Misaligned with Calculated EAC | ALERT | Is the PM EAC Likely dollars value less than the cost-calculated EAC? |
9070303 | PM EAC Best Date Misaligned with Cost Estimates | ALERT | 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 | ALERT | Is the PM EAC Best date earlier than the End of PMB milestone? |
9070305 | PM EAC Likely Date Misaligned with Cost Estimates | ALERT | 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 | ALERT | Is the PM EAC Likely date earlier than the End of PMB milestone? |
9070307 | PM EAC Likely Date After Contract Completion | ALERT | Is the PM EAC Likely date later than the Contract Completion milestone? |
9070310 | RPG without OTB/OTS Date | ALERT | Are there RPG tasks without an OTB/OTS Date? |
9070350 | PM EAC Best Misaligned with Calculated EAC | ALERT | Is the PM EAC Best dollars value less than the cost-calculated EAC? |
9070353 | PM EAC Worst Date Later Than CD-4 | ALERT | Is the PM EAC Worst date later than the CD-4 milestone date? |
9070362 | EAC PM Likely Incommensurate with WAD BAC | ALERT | Is the EAC PM likely considerably different from the BAC as reported in the WADs? |
9070364 | EAC > BAC without OTB / OTS Date | ALERT | Is EAC greater than BAC without an OTB / OTS date? |
9070366 | Profit Fee Misaligned With CC Log Detail | ALERT | 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 | ERROR | 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 | WARNING | 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 | WARNING | Is the initial authorization date missing? | initial_auth_date is blank. |
1080427 | PM Authorization Missing | WARNING | Is this WAD missing a PM authorization date? | auth_PM_date is blank. |
1080433 | POP Start After Initial Auth Date | WARNING | 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 | WARNING | 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 | WARNING | Do the CA & WP WBS IDs match? | WBS_ID = WBS_ID_WP. |
9080386 | CA Labor Dollars Misaligned With Cost | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | ALERT | 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 | ALERT | Is there an EVT for this CA-level WAD? | EVT <> blank or NA & WBS_ID_WP <> blank. |
1080402 | Labor Dollars without Labor Hours | ALERT | Does this WAD have labor dollars but not labor hours? | budget_labor_dollars > 0 & budget_labor_hours = 0. |
1080403 | Labor Hours without Labor Dollars | ALERT | Does this WAD have labor hours but not labor dollars? | budget_labor_hours > 0 & budget_labor_dollars = 0. |
1080405 | CAM Authorization After PM Authorization | ALERT | Is the CAM authorization date later than the PM's? | auth_CAM_date > auth_PM_date. |
1080410 | Missing EVT | ALERT | Is the EVT missing for this WP/PP-level WAD? | EVT is missing or blank. |
1080411 | Initial Authorization After PM Authorization | ALERT | 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 | ALERT | Is the initial authorization date consistent across revisions? | initial_auth_date differs across revisions (by WAD_ID). |
1080418 | Narrative Restates Title | ALERT | Is the narrative the same as the title? | narrative = title. |
1080428 | Repeat PM Authorization Date Across Revisions | ALERT | 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 | ALERT | Is the POP start on or after the POP finish? | pop_start_date >= pop_finish_date. |
1080438 | WPM Authorization Date After CAM Authorization Date | ALERT | Is the WPM's authorization date later than the CAM's? | auth_WPM_date > auth_CAM_date. |
1080440 | WPM Missing | ALERT | 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) | ALERT | 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) | ALERT | 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) | ALERT | 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) | ALERT | 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 | ALERT | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | ERROR | 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 | WARNING | 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 | WARNING | 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 | WARNING | Is the PM name missing on this CC log entry? | PM null or blank. |
9090442 | CC Log ID Missing in CC Log Detail | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | Is the transaction duplicated by transaction & CC log ID? | Count of transaction_ID & CC_log_ID combo > 1. |
1100451 | AUW Dollar Change Exceeds NTE | WARNING | Does this AUW dollar change above the NTE? | AUW = Y & dollars_delta > NTE_dollars_delta. |
1100452 | Negative AUW Dollar Delta with Non-Zero NTE | WARNING | Does this negative AUW dollar change also have an NTE? | AUW = Y & dollars_delta < 0 & NTE_dollars_delta <> 0. |
1100458 | Negative NTE Delta Dollars | WARNING | Is the NTE delta dollars value negative on this transaction? | NTE_dollars_delta < 0. |
1100461 | AUW Change Missing Dollars Delta | WARNING | Is this change to AUW missing a dollar amount? | AUW = Y & dollars_delta = null or zero. |
1100464 | DB Transaction Missing WBS ID | WARNING | Is this DB transaction missing a WBS ID? | category = DB & WBS_ID is missing or blank. |
1100465 | Description Missing | WARNING | Is the description missing? | description is null or blank. |
1100467 | Hours Delta without Dollars | WARNING | Are there hours on this transaction but no dollars? | hours_delta <> 0 & dollars_delta = 0. |
1100474 | POP Start After POP Finish | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | Is this WBS ID missing in the WBS Dictionary? | WBS_ID missing in DS01.WBS_ID list. |
1100466 | Dollars Delta Missing | ALERT | Is the dollars delta for this transaction missing or zero? | dollars_delta missing or 0. |
9100469 | OTB/OTS Transactions Misaligned with Cost (CA) | ALERT | 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) | ALERT | 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 | ERROR | 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 | WARNING | 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 | WARNING | Is the narrative type missing? | narrative_type missing or blank. |
1110491 | Project-Level VAR Without Overall Narrative | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | WARNING | 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 | ALERT | 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 | ALERT | Is the CAL ID missing for this VAR? | CAL_ID is missing or blank. |
1110487 | Cost Variance Root Cause Narrative Missing Impact | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | 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 | WARNING | 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 | WARNING | 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 | WARNING | Is the original due date for this corrective action after the forecast due date? | original_due_date > forecast_due_date. |
1120500 | Duplicate Transaction ID | WARNING | Is the transaction ID on this corrective action duplicated? | Count of transaction_ID > 1. |
1120501 | Transaction ID Missing | WARNING | Is the transaction ID missing? | transaction_ID blank or missing. |
9120496 | CAL ID Missing in Variance CAL ID List | WARNING | 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 | ERROR | 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 | WARNING | Is ACWP missing on this subcontract? | ACWPc_dollars missing or 0. |
1130503 | BAC Dollars Missing | WARNING | Is BAC missing on this subcontract? | BAC_dollars missing or 0. |
1130504 | BAC Initial Dollars Missing | WARNING | Are BAC initial dollars missing on this subcontract? | BAC_initial_dollars missing or 0. |
1130505 | BCWP Dollars Missing | WARNING | Is BCWP missing on this subcontract? | BCWPc_dollars missing or 0. |
1130506 | BCWS Dollars Missing | WARNING | Is BCWS missing on this subcontract? | BCWSc_dollars missing or 0. |
1130507 | EAC Dollars Missing | WARNING | Is EAC missing on this subcontract? | EAC_dollars missing or 0. |
1130508 | MR Dollars Missing | WARNING | Is MR missing on this subcontract? | MR_dollars missing or 0. |
1130509 | MR Initial Dollars Missing | WARNING | Is MR Initial missing on this subcontract? | MR_initial_dollars missing or 0. |
1130510 | Profit Fee Dollars Missing | WARNING | Are profit fee dollars missing on this subcontract? | profit_fee_dollars missing or 0. |
1130511 | Profit Fee Earned Dollars Missing | WARNING | Are profit fee earned dollars missing on this subcontract? | profit_fee_earned_dollars missing or 0. |
1130512 | Profit Fee Initial Dollars Missing | WARNING | Are profit fee initial dollars missing on this subcontract? | profit_fee_initial_dollars missing or 0. |
1130513 | Actual Finish Without Actual Start | WARNING | Is this subcontract with actual finish date missing an actual start? | AF_date found without AS_date. |
1130517 | Actual Finish After Actual Start | WARNING | Is the actual start after the actual finish? | AS_date > AS_date. |
1130523 | Missing BL Finish | WARNING | Is the baseline finish date missing? | BL_finish_date is missing. |
1130524 | BL Start After BL Finish | WARNING | Is the baseline start date after the baseline finish? | BL_start_date > BL_finish_date. |
1130526 | Missing BL Start | WARNING | Is the baseline start date missing? | BL_start_date is missing. |
1130527 | Complete Subcontract Missing Actual Finish | WARNING | Is this 100% complete subcontract missing an actual finish date? | BCWPc_dollars / BAC_dollars = 1 & AF_date missing. |
1130531 | Missing FC Finish | WARNING | Is the forecast finish missing? | FC_finish_date missing. |
1130532 | FC Start After FC Finish | WARNING | Is the forecast start date after the forecast finish? | FC_start_date > FC_finish_date. |
1130534 | Missing FC Start | WARNING | Is the forecast start missing? | FC_start_date missing. |
1130535 | Missing Flow Down | WARNING | Is the flow down missing? | flow_down is missing or blank. |
1130536 | Actuals Without Actual Start | WARNING | Is this subcontract with ACWP missing an actual start date? | ACWPc_dollars > 0 & AS_date missing. |
9130514 | ACWP Misaligned With Cost (CA) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | WARNING | 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 | ALERT | Is the EAC greater than the BAC on this subcontract? | EAC_dollars > BAC_dollars. |
9130516 | Actual Finish Misaligned with Forecast Schedule | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | Is the HDV-CI duplicated? | Count of HDV_CI_ID > 1. |
1140540 | Equipment ID Without SubK ID | WARNING | 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 | WARNING | 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 | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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) | WARNING | 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 | WARNING | 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 | ERROR | Is this risk duplicated by risk ID & revision? | Count of risk_ID & revision combo > 1. |
1150556 | Probability Schedule Min Equal To Or Above 98% | WARNING | 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% | WARNING | Is the minimum probability cost percent equal to or above 98%? | probability_cost_min_pct >= .98. |
9150560 | Risk Missing Impact Task | WARNING | 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 | ALERT | Does this opportunity have an avoid or transfer handling type? | type = O & risk_handling = Avoid or Transfer. |
1150549 | Approved Date After Closed Date | ALERT | Is the approved date after the closed date? | approved_date > closed_date. |
1150550 | Approved Date After Realized Date | ALERT | Is the approved date after the realized date? | approved_date > realized_date. |
1150553 | Probability Cost Min % Greater Than Max % | ALERT | 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% | ALERT | Is the minimum probability cost percent between 92 & 98%? | probability_cost_min_pct >= .92 & < .98. |
1150555 | Probability Schedule Min % Greater Than Max % | ALERT | 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% | ALERT | Is the minimum probability schedule percent between 92 & 98%? | probability_schedule_min_pct >= .92 & < .98. |
1150558 | Realized Date After Closed Date | ALERT | Is the realized date after the closed date? | realized_date > closed_date. |
9150551 | Risk Closed Before Risk Tasks Have Completed | ALERT | 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 | ALERT | 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 | ERROR | 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 | WARNING | 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 | WARNING | 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 | WARNING | Is this risk ID missing in the risk log? | Risk_ID not in DS15.risk_ID list. |
9160571 | Task ID Missing in Baseline Schedule | WARNING | 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 | WARNING | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | Is this WBS / EOC combo duplicated? | Count of combo WBS & EOC combo > 1. |
1170573 | EU Justification Missing | ALERT | 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 | ALERT | 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 | ALERT | Are the EU likely dollars greater than the max dollars? | EU_likely_dollars > EU_max_dollars. |
1170579 | EU Minimum Dollars Greater Than Likely | ALERT | Are the EU minimum dollars greater than the likely dollars? | EU_min_dollars > EU_likely_dollars. |
1170580 | WBS Time Dependence Inconsistent | ALERT | 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 | ALERT | 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) | ALERT | 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) | ALERT | 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 | ALERT | 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 | ALERT | Is this time dependent WBS non-LOE in cost? | time_dependent = Y & DS03.EVT <> A (by WBS_ID). |
9170583 | WBS Missing in WBS Hierarchy | ALERT | Is this WBS missing in the WBS hierarchy? | WBS missing in DS01.WBS_ID list. |
9170584 | WBS Of Non-WP or PP Type | ALERT | 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 | ERROR | Is this schedule EU task duplicated by task ID & schedule type? | Count of task_ID & schedule_type combo > 1. |
1180585 | Schedule EU Justification Missing | ALERT | 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 | ALERT | 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 | ALERT | Are the EU likely days greater than the max days? | EU_likely_days > EU_max_days. |
1180589 | EU Minimum Days Greater Than Likely | ALERT | Are the EU minimum days greater than the likely days? | EU_min_days > EU_likely_days. |
9180588 | EU Maximum Days Less Than Original Duration | ALERT | 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 | ALERT | 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 | ERROR | 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 | WARNING | Are the hours per day negative or greater than 24? | hours_per_day < 0 or hours_per_day > 24. |
1190594 | Shift Exceeds 12 Hours | ALERT | 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 | ERROR | 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 | ALERT | 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 | ALERT | 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 | ALERT | 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 | ERROR | Is this rate duplicated by resource ID? | Count resource_ID > 1. |
1210600 | Indirect Rate Missing Burden | WARNING | Is there a burden ID missing for this indirect rate? | type = I & burden_ID is missing or blank. |
1210599 | Negative Or Zero Rate Dollars | ALERT | Is the rate negative or zero? | rate_dollars <= 0. |
1210601 | Direct Overhead EOC | ALERT | Is this Overhead rate typed as direct? | type = D & EOC = Overhead. |
9210602 | Resource & EOC Combo Missing in Forecast Resources | ALERT | 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 | ALERT | 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) . |