Asset Management Parks System (AMPS) – Transactions

gcys-vvnqCity Government14 columns

This table contains information about transactions. A transaction tracks the movement of parts and materials between store houses and work orders. Each record represents a single transaction. The primary key is TRA_CODE. When TRA_TOENTITY is “EVNT” then you can use the TRA_TOCODE field to join to the Work Orders table on EVT_CODE to know which transactions are associated with each work order. For the User Guide, please follow this link For the Data Dictionary, please follow this link

View on NYC Open Data

Quality

A94.4 / 100

From a 500-row sample across 13 columns.

completeness100/ 25% weight

consistency77/ 20% weight

accuracy100/ 20% weight

timeliness100/ 15% weight

usability95/ 20% weight

Related datasets

Sample rows

tra_code	tra_desc	tra_type	tra_date	tra_status	tra_fromentity	tra_fromcode	tra_toentity	tra_tocode	tra_updatecount	tra_created	tra_updated
10000	Stock initialization	RECV	2009-05-04T00:00:00.000	A	COMP	*	STOR	Q-TS	0	2009-05-04T13:20:00.000	2009-05-04T13:20:00.000
10001

Columns

14 queryable · 14 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`tra_code`	text	—	0%	`86364483643612377`
`tra_desc`	text	—	0%	`ICORRECTION(DEFAULT TRANSACTION DES…`
`tra_type`	categorical	—	0%	`IRECVMISC`of 6
`tra_date`	datetime	—	0%	`2010-04-15T00:00:00.0002010-11-19T00:00:00.0002009-05-04T00:00:00.000`

Query this from your own app

GET /api/datasets/gcys-vvnq
GET /api/datasets/gcys-vvnq/quality
GET /api/datasets/gcys-vvnq/related
GET /api/columns?dataset=gcys-vvnq