| 9180588 |
EU Maximum Days Less Than Original Duration |
Minor changes to metadata. Logic adjusted to account for the addition of subproject_id field. |
| 9040203 |
Planned/Estimated Completion & End of PMB Delta Misaligned with UB |
Minor changes to metadata. Logic adjusted to compare Delta and UB as not equal, rather than Delta being less than or equal to UB. |
| 9180591 |
Schedule EU Task Missing in Schedule |
Minor changes to metadata. Logic adjusted to account for the addition of subproject_id field. |
| 9030092 |
Material Comingled with Non-Overhead EOCs |
Minor changes to metadata. |
| 1030093 |
Insufficient Overhead |
Minor changes to metadata. |
| 1190593 |
Duplicate Calendar Name |
Minor changes to metadata. Logic adjusted to account for 'subproject_id' field, as well as for minor optimizations. |
| 1030097 |
Zero SPAEcum |
Minor changes to metadata. Logic adjusted to account for the addition of is_indirect field. Minor adjustment to treatment of missing 'WBS_ID_WP' values for both grouping and filtering purposes. |
| 1200595 |
Duplicate Calendar Exception |
Minor changes to metadata. Logic adjusted to account for the addition of subproject_ID field. |
| 1030110 |
Subcontract Comingled with Non-Overhead EOCs |
Minor changes to metadata. |
| 1040215 |
Duplicate Task ID |
Minor changes to metadata. Logic adjusted to account for the addition of subproject_id field. |
| 1030108 |
Non-Unique Cost Row |
Minor changes to metadata. Logic adjusted to account for the addition of the 'is_indirect' field. All cases where 'is_indirect' is missing or null are treated as empty strings. |
| 1040321 |
CD-4 Early Start or Finish Dates Misaligned Between FC & BL |
Minor changes to metadata. Logic adjusted to account for the addition of subproject_ID field and for minor code optimization. |
| 1050236 |
Non-Unique Relationship |
Minor changes to metadata. Logic adjusted to account for the addition of 'subproject_ID' and 'predecessor_subproject_ID' fields. |
| 9060285 |
Cost Actuals without Resource Performance |
Minor changes to metadata. |
| 9060285 |
Cost Actuals without Resource Performance (WP) |
Minor changes to metadata. |
| 9060289 |
Cost Labor Actuals without Resource Labor Performance |
Minor changes to metadata. |
| 9060289 |
Cost Labor Actuals without Resource Labor Performance (WP) |
Minor changes to metadata. |
| 9060288 |
Resource Labor Performance without Cost Labor Actuals |
Minor changes to metadata. |
| 9080394 |
CA Overhead Dollars Misaligned With Cost |
Minor changes to metadata. Logic adjusted to account for replacement of 'budget_overhead_dollars' field with 'budget_indirect_dollars'. |
| 1010019 |
External WBS Without Subproject ID |
Minor changes to metadata. |
| 9080395 |
WP Overhead Dollars Misaligned With Cost |
Minor changes to metadata. |
| 1060256 |
Labor Resource Lacking Appropriate EOC |
Minor changes to metadata. Logic adjusted to include records where EOC is either null or does not belong to 'Labor' or 'Indirect', rather than excluding records with EOC values 'Labor' and 'Overhead'. |
| 9060286 |
Resource Performance without Cost Actuals |
Minor changes to metadata. |
| 1040132 |
SVT or ZBA with EVT |
Minor changes to metadata. |
| 1010018 |
Exit Criteria Missing |
Minor changes to metadata. Logic adjusted to simplify the condition for checking empty or null exit_criteria by using a more streamlined approach. |
| 9010024 |
Overhead Missing From Project |
Minor changes to metadata. |
| 9060283 |
Resource Loaded CA or WBS |
Minor changes to metadata. Logic adjusted to account for addition of subproject_id field. Logic adjusted to filter WBS_ID directly in the query for DS04_schedule, using a subquery to check conditions in DS01_WBS, rather than creating a separate WBS filter step. |
| 9040134 |
SVT With Logic |
Minor changes to metadata. Logic adjusted to account for addition of 'subproject_ID' field and for improved filtering of subtypes. |
| 1060241 |
Task with Overhead EOC Only |
Minor changes to metadata. |
| 1060241 |
Task with Indirect EOC Only |
Minor changes to metadata. |
| 1060240 |
Uneven Use of Overhead |
Minor changes to metadata. |
| 1060253 |
Resource Role Missing Name |
Minor changes to metadata. |
| 9040150 |
Actual Start Misaligned With Cost (CA) |
Minor changes to metadata. |
| 9080421 |
CA Overhead Dollars Missing In Cost |
Minor changes to metadata. |
| 9080422 |
WP Overhead Dollars Missing In Cost |
Minor changes to metadata. |
| 1040145 |
Baseline Task Missing In Forecast |
Minor changes to metadata. Logic adjusted to account for the addition of 'subproject_id' field. |
| 9060301 |
Resource Task Missing in Schedule |
Minor changes to metadata. Logic adjusted to account for the addition of 'subproject_ID' field. |
| 1060259 |
Non-Unique Resource or Role |
Minor changes to metadata. Logic adjusted to include 'EOC' and 'subproject_ID' fields as part of the test. |
| 1040160 |
Duplicate CD or BCP Entry |
Minor changes to metadata. Logic adjusted to account for the addition of subproject_id field. |
| 1040166 |
Actual Finish Prior to Early Finish Along the Driving Path |
Minor changes to metadata. Logic adjusted to account for 'subproject_id' field. |
| 1040167 |
Actual Start Prior to Early Start Along the Driving Path |
Minor changes to metadata. Logic adjusted to account for the addition of 'subproject_ID' field, as well as to improve readability. |
| 1040177 |
EVT Misaligned Between BL & FC |
Minor changes to metadata. Logic adjusted to account for addition of 'subproject_id' field. |
| 1040178 |
Forecast Task Missing In Baseline |
Minor changes to metadata. Logic adjusted to account for addition of 'subproject_id' field. |
| 1040603 |
High Float Missing Justification (BL) |
Minor changes to metadata. |
| 1040184 |
High Float Missing Justification (FC) |
Minor changes to metadata. |
| 9030068 |
PP Starting Within 3-6 Months |
Minor changes to metadata. Logic adjusted to consider a period date within 3-6 months from the current project status date, rather than 4-6 months. |
| 9030068 |
PP Starting Within 4-6 Months |
Minor changes to metadata. Logic adjusted to consider a period date within 3-6 months from the current project status date, rather than 4-6 months. |
| 1040192 |
Milestone Prior To Approve Start Project |
Minor changes to metadata. Logic adjusted to account for the addition of the 'subproject_id' field. |
| 1040193 |
Milestone After Approve Finish Project |
Minor changes to metadata. Logic adjusted to account for the addition of 'subproject_ID' and 'predecessor_subproject_ID' fields. |
| 1030089 |
Labor Missing Performance |
Logic adjusted to exclude records where is_indirect is 'Y'. |
| 1060249 |
Resource Role with Non-Labor EOC |
Logic adjusted to include records where EOC is not null. |
| 9060297 |
Resource Remaining Dollars Misaligned with Cost BCWR |
Logic adjusted to use 'is_indirect' field as part of logic for determining indirect data, rather than simply using the 'EOC' field. Logic adjusted to account for the addition of 'subproject_ID'. |
| 9010016 |
WP or PP Missing from Schedule (BL) |
Minor code optimization. |
| 9060296 |
Resource Finishing Later Than Task |
Logic adjusted to account for 'subproject_id' field. Additionally, the query now explicitly filters resources by 'schedule_type = 'BL''. |
| 9030102 |
WP or PP Missing In BL Schedule |
Minor code optimization. |
| 1040139 |
Activity Missing EVT |
Logic adjusted to exclude records where the subtype is either 'SVT' or 'ZBA', in addition to the existing filters. |
| 1060246 |
Labor Overlap |
Logic adjusted to account for the addition of subproject_ID field. Minor organizational changes otherwise. |
| 9060292 |
Resource Non-Labor Hours Recorded Alongside Cost Labor Hours |
Logic adjusted to exclude indirect labor costs by filtering out records where 'is_indirect' is 'Y' in the 'CostWBS' section. Logic adjusted to account for the addition of 'subproject_ID' field. Logic adjusted to exclude resources with an 'EOC' value of 'Labor' in both the 'ScheduleWBS' and final selection sections, where previously there was no such filter. |
| 1030046 |
Incommensurate Future Budget & Estimates |
Minor organizational changes. |
| 9040196 |
Milestone With Resources |
Logic adjusted to account for the addition of subproject_id field. |
| 1030074 |
0-100 Budget Spread Improperly |
Logic adjusted to account for the addition of is_indirect field. All cases where is_indirect = 'Y' are treated as indirect data. |
| 9040200 |
WBS Summary Task with Logic |
Logic adjusted to account for the addition of subproject_id field. |
| 1040220 |
WBS Misaligned Between FC & BL |
Logic adjusted to account for the addition of 'subproject_ID' field. |
| 9040223 |
WBS Missing in Cost |
Logic adjusted to filter out records from 'DS04_schedule' that have a matching 'WBS_ID' in 'DS03_cost', using a new method. Previously, it directly excluded 'WBS_ID' present in 'DS03_cost'. Now, it creates a temporary list of distinct 'WBS_ID_WP' from 'DS03_cost' and then performs a left join to exclude those 'WBS_ID'. |
| 9040187 |
LOE Task With Improper Logic |
Logic overhaul. DIQ now flags the following LOE & apportioned tasks (EVT = A, J, M or type = LOE): 1. Those without two predecessors (one SS, one FF); 2. Those with successors; 3. Those without immediate, discrete predecessors. Logic also adjusted to account for the addition of 'subproject_ID' field. |
| 9060287 |
Resource Labor Performance Misaligned with Cost |
Logic adjusted to account for the 'is_indirect' field being added to DS03_Cost. Logic adjusted to account for the addition of 'subproject_ID' field. |
| 9040216 |
Missing Logic |
Logic adjusted to account for the addition of the 'subproject_id' field. |
| 9040219 |
Task With Units % Complete Not Materially Resource Loaded |
Logic adjusted to account for the addition of 'subproject_ID' field. Logic adjusted to improve non-material filtering. |
| 1040176 |
EVT Missing Justification |
Logic adjusted to include records where 'justification_float_high' is inadequate. |
| 9040222 |
WBS Missing in WBS Dictionary |
Minor code optimization. |
| 9070362 |
EAC PM Likely Incommensurate with WAD BAC |
Logic adjusted to use 'budget_indirect_dollars' instead of 'budget_overhead_dollars'. |
| 9200596 |
Calendar Name Missing In Standard Calendar List |
Logic adjusted to account for the addition of 'subproject_id' field, as well as for a minor code optimization. |
| 1040107 |
CD / BCP Milestones Out of Sequence |
Logic adjusted to account for the addition of 'subproject_id' field. Exception created for milestone_level = 170 (planned/estimated completion without UB), which should have the same date as milestone_level = 175 (End of PMB). |
| 9030072 |
WP or PP Missing In FC Schedule |
Minor code optimization. |
| 1050234 |
SS or FF Improperly Linked With Other Relationship Types |
Logic adjusted to account for the addition of the predecessor_subproject_ID field. |
| 1060261 |
FC Resource Missing Among BL Resoures |
Logic adjusted to account for the addition of subproject_id field. |
| 9030100 |
Cost Missing Resources |
Logic adjusted to account for the addition of subproject_id field. Logic adjusted to account for the addition of 'is_indirect' field. All cases where 'is_indirect' = 'Y' are treated as indirect data. |
| 9010015 |
WP or PP Missing from Schedule (FC) |
Minor code optimization. |
| 9070369 |
PMB + MR <> CBB + Overrun |
Logic adjusted to replace 'budget_overhead_dollars' with 'budget_indirect_dollars'. |
| 1060260 |
BL Resource Missing Among FC Resoures |
Logic adjusted to account for the addition of subproject_id field. |
| 9040224 |
WBS Summary With Resources |
Logic adjusted to account for the addition of subproject_id field. |
| 1060237 |
Resource without Budget |
Logic adjusted to filter out resources where EOC is 'Indirect'. |
| 9040214 |
Resource Loaded SVT or ZBA |
Logic adjusted to account for the addition of subproject_id field. Logic adjusted to filter records based on subtype being either 'SVT' or 'ZBA', rather than excluding records where subtype is empty or null. |
| 9050282 |
Task Missing in Schedule |
Logic adjusted to account for the addition of 'subproject_ID' field. |
| 9010029 |
Subproject ID Missing in Schedule |
Minor code optimization. |
| 1060247 |
Duplicate Resource Name |
Logic adjusted to account for the addition of 'subproject_ID' field, as well as for improved readability. |
| 9060284 |
Resource Performance Misaligned with Cost |
Logic adjusted to account for addition of 'is_indirect' and 'subproject_ID' fields. |
| 9010014 |
CA or SLPP Missing from Cost |
Logic adjusted to exclude external WBS, as well as for minor optimization. |
| 1030075 |
50-50 Budget Spread Improperly |
Logic adjusted to account for the addition of the is_indirect field. All cases where is_indirect = 'Y' are treated as indirect data. Logic also adjusted to include a filter that excludes records with empty WBS_ID_WP fields. |
| 1030088 |
Labor Missing Actuals |
Logic adjusted to exclude records where is_indirect is 'Y', in addition to the existing filters. |
| 9040217 |
Missing Resources |
Logic adjusted to account for the addition of the 'subproject_id' field. |
| 1030081 |
Budget Missing |
Logic adjusted to account for 'is_indirect' field, which is used to exclude is_indirect = Y. All cases where is_indirect = 'Y' are treated as indirect data. Logic also adjusted to exclude records with empty WBS_ID_WP fields (non-WP/PP data). |
| 1020040 |
Title Contains OBS ID |
Logic adjusted to use a case-sensitive search for 'Title' using 'OBS_ID', rather than a case-insensitive search. |
| 9010013 |
WP or PP Missing from Cost |
Logic adjusted to exclude external WBS, as well as for minor optimization. |
| 9060294 |
EOC Combo Misaligned with Cost |
Logic adjusted to account for the addition of 'is_indirect' field. All cases where 'is_indirect' = 'Y' are treated as indirect data. Logic adjusted to account for the addition of 'subproject_id' field. Logic adjusted to include EOC in test. |
| 9050280 |
Lag Missing Justification |
Logic adjusted to account for 'subproject_id' field, as well as for code maintainability. |
| 9060298 |
Resource Remaining Units Misaligned with Cost BCWR Hours |
Logic adjusted to account for the addition of 'subproject_ID' and 'is_indirect' fields. |
| 1030091 |
Labor Missing Estimates |
Logic adjusted to account for 'is_indirect' field, which is used to exclude is_indirect = Y. All cases where is_indirect = 'Y' are treated as indirect data. |
| 9060293 |
Calendar Missing In Standard Calendar List |
Logic adjusted to account for the addition of 'subproject_id' field, as well as for a minor code optimization. |
| 9060300 |
Resource Starting Earlier Than Task |
Logic adjusted to account for the addition of 'subproject_id' field, as well as for a minor code optimization. |
| 9060290 |
Resource Budgets Misaligned with Cost |
Logic adjusted to account for addition of 'is_indirect' and 'subproject_id' fields. |
| 9170579 |
WBS & EOC Combo Missing in Cost |
Logic adjusted to account for addition of 'is_indirect' field. |
| 1080404 |
Negative or Missing Budget Dollars |
Logic adjusted to account for replacement of 'budget_overhead_dollars' with 'budget_indirect_dollars'. |
| 9050281 |
Predecessor Missing in Schedule |
Logic adjusted to account for the addition of 'subproject_id' field. |
| 9030324 |
WP / PP EVT Misaligned with WAD |
Logic adjusted to classify 'C' as 'Discrete', where previously it was not included in this classification. |
| 9060291 |
Resource Labor Units Misaligned with Cost |
Logic adjusted to account for addition of 'is_indirect' and 'subproject_id' fields. |