cityofnewyork-us/asset-management-parks-system-amps-transaction-ub9z-gccp

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

Asset Management Parks System (AMPS) – Transaction Details

Asset Management Parks System (AMPS) – Transaction Details

This table contains specific information about each part that is included in a transaction. Each record has information about one type of part in the transaction. A single transaction could have multiple lines (one for each type of part) in this table. The TRL_TRANS field can be joined to the Transactions table on TRA_CODE to know which parts were part the transaction.

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
TRL_DATEtrl_datetrl_dateText
PAR_CREATEDpar_createdpar_createdText
TRL_PARTtrl_parttrl_partText
TRL_TYPEtrl_typetrl_typeText
PAR_UPDATEDpar_updatedpar_updatedText
PAR_CLASSpar_classpar_classText
PAR_UDFCHAR02par_udfchar02par_udfchar02Text
TRL_REQLINEtrl_reqlinetrl_reqlineText
TRL_PRICEtrl_pricetrl_priceNumber
PAR_SQLIDENTITYpar_sqlidentitypar_sqlidentityText
TRL_ATTACHtrl_attachtrl_attachText
PAR_CODEpar_codepar_codeText
TRL_REQtrl_reqtrl_reqText
PAR_NOTUSEDpar_notusedpar_notusedText
TRL_ACTtrl_acttrl_actText
TRL_EVENTtrl_eventtrl_eventText
TRL_LINEtrl_linetrl_lineText
PAR_UPDATECOUNTpar_updatecountpar_updatecountText
PAR_LASTSTATUSUPDATEpar_laststatusupdatepar_laststatusupdateText
TRL_BINtrl_bintrl_binText
TRL_DESCtrl_desctrl_descText
TRL_SQLIDENTITYtrl_sqlidentitytrl_sqlidentityNumber
TRL_UPDATEDtrl_updatedtrl_updatedText
PAR_UDFCHAR01par_udfchar01par_udfchar01Text
PAR_UOMpar_uompar_uomText
TRL_AVGPRICEtrl_avgpricetrl_avgpriceText
TRL_STOREtrl_storetrl_storeText
TRL_TRANStrl_transtrl_transNumber
PAR_DESCpar_descpar_descText
TRL_CREATEDtrl_createdtrl_createdText
TRL_QTYtrl_qtytrl_qtyText

Upstream Metadata