cityofnewyork-us/asset-management-parks-system-amps-transactions-gcys-vvnq

  • amps
  • materials
  • parks
  • parts
  • plan-amps
  • + 2

Asset Management Parks System (AMPS) – Transactions

Asset Management Parks System (AMPS) – Transactions

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 <a href="https://docs.google.com/document/d/1UwyGGncb6oFMiOfgz73G-iM8Yea9ubz4931hPeBO9YQ/edit?usp=sharing">this link</a>

For the Data Dictionary, please follow <a href="https://docs.google.com/spreadsheets/d/1pDr-BUe4LS7DvATfbOnd8UrV6s77krJgzqdq_gVYWqc/edit?usp=sharing">this link </a>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
TRA_TYPEtra_typetra_typeText
TRA_STATUStra_statustra_statusText
TRA_CREATEDtra_createdtra_createdText
TRA_REQtra_reqtra_reqText
TRA_TOENTITYtra_toentitytra_toentityText
TRA_TOCODEtra_tocodetra_tocodeText
TRA_UPDATEDtra_updatedtra_updatedText
TRA_FROMENTITYtra_fromentitytra_fromentityText
TRA_DATEtra_datetra_dateText
TRA_UPDATECOUNTtra_updatecounttra_updatecountText
TRA_SQLIDENTITYtra_sqlidentitytra_sqlidentityNumber
TRA_DESCtra_desctra_descText
TRA_CODEtra_codetra_codeNumber
TRA_FROMCODEtra_fromcodetra_fromcodeText

Upstream Metadata