cityofnewyork-us/asset-management-parks-system-amps-labor-xzj8-i3jk

  • amps
  • labor
  • parks
  • plan-amps
  • work orders

Asset Management Parks System (AMPS) – Labor

Asset Management Parks System (AMPS) – Labor

This table contains work order labor records. Each record in this table corresponds to one labor entry and includes general information about that piece of labor. The primary key is BOO_CODE. The BOO_EVENT field can be joined to the Work Orders table on EVT_CODE to know how much labor was booked to 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
BOO_DATEboo_dateboo_dateText
BOO_ONboo_onboo_onText
BOO_ACTboo_actboo_actText
BOO_JESOURCEboo_jesourceboo_jesourceText
BOO_EVENTboo_eventboo_eventNumber
BOO_DESCboo_descboo_descText
BOO_COSTboo_costboo_costText
BOO_RATEboo_rateboo_rateText
BOO_ENTEREDboo_enteredboo_enteredText
BOO_JECATEGORYboo_jecategoryboo_jecategoryText
BOO_CORRECTIONboo_correctionboo_correctionText
BOO_CODEboo_codeboo_codeNumber
BOO_SQLIDENTITYboo_sqlidentityboo_sqlidentityText
BOO_TRADEboo_tradeboo_tradeText
BOO_OFFboo_offboo_offText
BOO_MISCboo_miscboo_miscText
BOO_HOURSboo_hoursboo_hoursText
BOO_OCTYPEboo_octypeboo_octypeText

Upstream Metadata