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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| BOO_DATE | boo_date | boo_date | Text | |
| BOO_ON | boo_on | boo_on | Text | |
| BOO_ACT | boo_act | boo_act | Text | |
| BOO_JESOURCE | boo_jesource | boo_jesource | Text | |
| BOO_EVENT | boo_event | boo_event | Number | |
| BOO_DESC | boo_desc | boo_desc | Text | |
| BOO_COST | boo_cost | boo_cost | Text | |
| BOO_RATE | boo_rate | boo_rate | Text | |
| BOO_ENTERED | boo_entered | boo_entered | Text | |
| BOO_JECATEGORY | boo_jecategory | boo_jecategory | Text | |
| BOO_CORRECTION | boo_correction | boo_correction | Text | |
| BOO_CODE | boo_code | boo_code | Number | |
| BOO_SQLIDENTITY | boo_sqlidentity | boo_sqlidentity | Text | |
| BOO_TRADE | boo_trade | boo_trade | Text | |
| BOO_OFF | boo_off | boo_off | Text | |
| BOO_MISC | boo_misc | boo_misc | Text | |
| BOO_HOURS | boo_hours | boo_hours | Text | |
| BOO_OCTYPE | boo_octype | boo_octype | Text |