The following data displays all of the preventive and corrective work orders at the Water Resource Department. The provided data is from 10/01/2018 to Current Date and is updated on a daily basis. The date column is based on the actual finished date of each of the work order task and its only showing finished work order tasks. The divisions are classified based on the crews assigned to respective division as for special projects such as customer funded the department field in empty in Work and Asset Management (WAM) system. The data set can be filtered down to each individual division to measure their respective preventive vs corrective work performed as classified in the Work Type columns. As each division reports preventive and corrective work differently the type is classified differently for all divisions. WRF/WTD classifies the work based on the type field, WSM classifies it based on work class category and WWM is based on failure codes. The Budget column represents the burden or overhead charges associated with that task and costs have to be posted in WAM in order for it to have any values. Labor hours are the approved time sheets that are entered in WAM.
This dataset has the following 10 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Id | id | text | WRD150656901 WRD150656902 WRD150656903 WRD150656904 WRD150656907 view top 100 |
DATE | date | calendar_date | 2020-11-21T00:00:00.000 2020-01-29T00:00:00.000 2019-10-15T00:00:00.000 2020-01-30T00:00:00.000 2022-02-26T00:00:00.000 view top 100 |
WORK ORDER NO | work_order_no | number | 2005514 1936667 2049937 1904926 1940636 view top 100 |
WORK ORDER TASK NO | work_order_task_no | number | 1 2 3 4 5 view top 100 |
WORK TYPE | work_type | text | PREVENTATIVE CORRECTIVE view top 100 |
DIVISION | department | text | WSM MISSING WRF WWM WTD view top 100 |
AREA | area | text | WTRMAINT WWM RECLAIMWTR NWWRF COSME view top 100 |
CREW | crew | text | WSM2 WSM1 WSM12 WSM9 WSM4 view top 100 |
LABOR HOURS | labor_hours | number | 0.2 0.5 1 0.1 0.4 view top 100 |
BUDGET | budget | number | 4.13 3.12 6.4 16.95 8.32 view top 100 |