Asset Management Parks System (AMPS) - Work Orders
This table is the primary table for information about work orders, and contains general information - including a description of the work, assigned title, request date and completion date - about each work order. Each row represents a single work order. The primary key field is EVT_CODE. The EVT_OBJECT field can be joined to the Assets table on OBJ_CODE to know which asset the work order was for. For the User Guide, please follow this link For the Data Dictionary, please follow this link
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- As needed
- Actually updates about every
- 7 days
- Publisher last updated the data
- Oct 7, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 7, 2026, 11:54 AM
- Rows in our copy
- 2,228,045
- Rows at the source
- 2,228,045
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
The publisher has not provided a data dictionary.
0 of 55 columns carry a concept; 55 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
evt_udfchar12 | EVT_UDFCHAR12 | Indicates if work request was generated on a phone or desktop | Not bound | Text | evt_udfchar12 | text | — | |
evt_perioduom | EVT_PERIODUOM | Period of scheduled task | Not bound | Text | evt_perioduom | text | — | |
evt_code | EVT_CODE | Unique ID for each work order | Not bound | Number | evt_code | numeric | Yes | — |
evt_warranty | EVT_WARRANTY | Indicates if equipment was repair was covered under warranty | Not bound | Text | evt_warranty | text | — | |
evt_udfchkbox05 | EVT_UDFCHKBOX05 | Indicates if a document is attached to work order | Not bound | Text | evt_udfchkbox05 | text | — | |
evt_udfchar02 | EVT_UDFCHAR02 | Subclass of work order for data modification requests | Not bound | Text | evt_udfchar02 | text | — | |
evt_updatecount | EVT_UPDATECOUNT | Number of times the work order record has been updated | Not bound | Number | evt_updatecount | numeric |
Download
This file was produced on Oct 7, 2026, 10:03 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/8sdw-8vja
- Version
- Content hash:
e6ee9b15e448131ae2f9017c1cf1eec0224d8a6ba97fd51e4a6a805be14cf990 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 7, 2026, 11:54 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 7, 2026, 3:48 PM | full_replace | success | 2,228,045 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 7, 2026, 3:48 PM | incremental | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 3:45 PM | full_replace | success | 2,224,030 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 3:44 PM | incremental | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 23, 2026, 3:37 PM | full_replace | success | 2,222,368 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.83 |
| Sep 23, 2026, 3:37 PM | incremental | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.83 |
| Sep 16, 2026, 4:12 PM | full_replace | success | 2,220,853 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.81 |
| Sep 16, 2026, 4:12 PM | incremental | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.81 |
| Sep 9, 2026, 3:15 AM | full_replace | success | 2,218,057 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 9, 2026, 3:15 AM | incremental | aborted | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |