1080404 |
Negative or Missing Budget Dollars |
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 |
Is the initial authorization date missing? |
initial_auth_date is blank. |
1080427 |
PM Authorization Missing |
Is this WAD missing a PM authorization date? |
auth_PM_date is blank. |
1080433 |
POP Start After Initial Auth Date |
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 |
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 |
Do the CA & WP WBS IDs match? |
WBS_ID = WBS_ID_WP. |
9080386 |
CA Labor Dollars Misaligned With Cost |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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) |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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) |
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) |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
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 |
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 |
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 |
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. |
9080410 |
WP Indirect Dollars Misaligned With Cost |
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 |
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 |
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). |
9080434 |
CA Indirect Dollars Missing In Cost |
Are the indirect budget dollars for this CA WAD missing in cost? |
budget_indirect_dollars > 0 & DS03.BCWSi_dollars = 0 where EOC = Indirect or is_indirect = Y (by WBS_ID_CA). |