cityofnewyork-us/asset-management-parks-system-amps-transaction-ub9z-gccp
Icon for Socrata external plugin
 
Readme
Updated 6 days ago
Indexed 3 hours ago

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