> For the complete documentation index, see [llms.txt](https://atd-dts.gitbook.io/atd-knack-operations/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://atd-dts.gitbook.io/atd-knack-operations/signs-and-markings/signs-or-work-orders.md).

# Signs | Work Orders

**Problem**: Signs and Markings needed a way to track signs work orders

**Solution**: Add an area to the Signs and Markings Operations App for Signs Work Orders

## Build Information 

### Object tables used

* `dosa_tracking` (table that tracks DOSAs)
* `inventory_items` (table of inventory item materials used for signs)
* `work_orders_signs` (table of signs work orders)
* `work_order_signs_locations` (table of sign locations)
* `work_orders_signs_asset_spec` (table of sign specifications)
* `work_orders_signs_asset_spec_actual` (table of sign specifications to report)
* `work_orders_signs_markings_attachments` (table of plans and/or photos for work order)
* `work_orders_signs_markings_comments` (table of comments made for work order)
* `work_orders_signs_markings_time_log` (table that tracks time worked)

### Connections

* `csr_issues` (for work orders signs object - table that tracks issues of CSRs) 
* `csr_flex_notes` (for work orders signs object - table of flex notes of CSRs)
* `reimburseable_tracking` (for work orders signs object - table that tracks reimburseables)
* `street_names` (for work orders markings object - Street, From/To Street in order to not have typos on location names.)
* `fleet_vehicles` (table of fleet vehicle options for time log object)
* `accounts` (audit fields: Created Date/By, Modified Date/By)