Information Technology - Project Schedule and Budget Variance
citydata.mesaaz.gov | Last Updated 22 Jun 2022This data set lists projects currently in process and managed by the Department of Information Technology. Projects are noted if they are in an implementation phase, which would make their schedule and budget adherence applicable. Budget is listed and determined by project manager if they are within budget, at or under budget, to date. Schedule is determined by project start date, project manager original go live estimate and current go live estimate and /or actual go live date.
This dataset has the following 17 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| RowId | rowid | number | Unique Row Identifier | 204 14 3 486 348 view top 100 |
| Project Name | project_name | text | Name of the project | Mobile Device Management Backup Rearchitecture Public Safety CAD Replacement LIVE! eBen Mesa Data Center Move Phase III view top 100 |
| Project Description | project_description | text | Simple explanation of project objective | Replace the City’s public safety system with an enhanced CAD & MCT solution Enable City departments (including ITD, Transportation and Engineering) to track all City owned conduit and fiber, including technical specifications, use, funding, initial location, destination and o Upgrade the City’s Utility billing & customer service solution, including enhancing citizen experience with online bill pay & info/ services access, bill presentment updates Provide wayfinding in the downtown district, enhance visibility of the arts, businesses & other services, encourage additional tourism, provide light rail information, engage citizens, and create a re FirstNet is a dedicated communications network that provides first responders exclusive access to bandwidth and prioritized connectivity during emergency situations. view top 100 |
| Project Manager/Contact | project_manager_contact | text | Name of project manager/contact | Clint Potts Lauren Lupica Renee Stewart Scott Parker Tom Donnelly view top 100 |
| Project Status | project_status | text | Status could be from the initiating (development) phase to underway (implementing) to Live. Projects in initial phases are not counted in budget and schedule metrics as the data (budget, dates) is being developed. | Underway Complete Live! LIVE! On Hold view top 100 |
| Project Current Status | project_current_status | text | Project Current Status | Complete! This project is in the early planning and scope/ charter ratification. Management Consultant RFP responses have been received; evaluation underway. Shortlisting & interviews coming up at the end of May/ early June respectively. RFI responses expected by 5/30. As-is bu On hold pending vendor providing a product solution that will interface LMR and LTE 9/1/2019 Phase II view top 100 |
| ITD Metric Flag | itd_metric_flag | text | Is the project managed by DoIT (Department of Information Technology) | Y N/A N view top 100 |
| Budget Metric | budget_metric | text | Is the project managed by DoIT (Department of Information Technology) and in a phase where budget can be considered | N Y N/A y N view top 100 |
| Schedule Metric | schedule_metric | text | Is the project managed by DoIT (Department of Information Technology) and in a phase where schedule can be considered | N/A view top 100 |
| Start Date | start_date | calendar_date | Date project was initiated | 1900-01-01T00:00:00.000 2018-07-01T00:00:00.000 2019-03-26T00:00:00.000 2020-07-01T00:00:00.000 2019-03-20T00:00:00.000 view top 100 |
| Planned Go Live | planned_go_live | calendar_date | Estimated date the project will go live | 1900-01-01T00:00:00.000 2019-06-30T00:00:00.000 2020-09-30T00:00:00.000 2020-06-30T00:00:00.000 2020-12-31T00:00:00.000 view top 100 |
| Actual (Project Go Live) | actual_project_go_live | calendar_date | The actual date a project goes Live | 1900-01-01T00:00:00.000 2019-06-30T00:00:00.000 2020-09-30T00:00:00.000 2019-06-06T00:00:00.000 2018-11-15T00:00:00.000 view top 100 |
| Schedule Variance | schedule_variance | text | The deviation of a project is calculated using the actual go live and its estimated go live. (Is it ahead, on or behind schedule). Noted in a mathematical calculation where zero is on schedule. | 0 0.13 -0.0793650793650794 -0.0893617021276596 view top 100 |
| On Schedule? | on_schedule | number | Is the schedule variance within 10 percent of zero – the industry standard for acceptable variance from estimated schedule | 1 2 0 view top 100 |
| Budget (Goods & Services) | budget_goods_services | text | Projects Budget | 0 2500000 50000 100000 4500000 view top 100 |
| Within Budget? | within_budget | number | Project manager reporting on current project spending and whether it is at or under the original budgeted amount | 2 1 view top 100 |
| Quarter Start Date | quarter_start_date | calendar_date | The date the reported quarter started | 2018-07-01T00:00:00.000 2019-01-01T00:00:00.000 2019-04-01T00:00:00.000 2020-10-01T00:00:00.000 2021-01-01T00:00:00.000 view top 100 |