20250313 08335800 1.0 FALSE 002 SW_Work_Orders_VUEWorks_View 150000000 5000 20250313 08360300 20250313 08360300 dataset Amy LaMar Business Support Senior Business Process Analyst 817-392-2384 100 Fort Worth Trl Fort Worth 76102 US amy.lamar@fortworthtexas.gov TX Amy LaMar 20250313 Enterprise Geodatabase Table 10.9.1 Esri ArcGIS 13.3.2.52636 SW_Work_Orders_VUEWorks_View 2025-03-11T00:00:00 Amy LaMar Business Support Senior Business Process Analyst 817-392-2384 100 Fort Worth Trl Fort Worth 76102 US amy.lamar@fortworthtexas.gov TX Amy LaMar Data is a view from VUEWorks operational tables and is automatically updated with latest information. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Department Only</SPAN></P></DIV></DIV></DIV> 1 -97.627 -97.017 32.984 32.564 Stormwater workorders by Asset ID from VUEWorks to evaluate asset maintenance and labor data in GIS. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Stormwater workorders by Asset ID from VUEWorks to evaluate asset maintenance and labor data in GIS by filtering the Department field for 'TPW Stormwater'. The Asset ID field will be used to join the assets in the Stormwater Infrastructure database to the workorder data in VUEWorks.</SPAN></P></DIV></DIV></DIV> Transportation and Public Works - Stormwater Management/Streets and Stormwater Operations Stormwater Management Stormwater TPW Amy LaMar Business Support Senior Business Process Analyst 817-392-2384 100 Fort Worth Trl Fort Worth 76102 US amy.lamar@fortworthtexas.gov TX Amy LaMar Amy LaMar EPSG 5.3(9.0.0) SW_Work_Orders_VUEWorks_View Table 116606 XXAttributeContainerXX OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. WorkorderNo The workorder number that is auto-generated in VUEWorks when a workorder in created. Originator Text 100 WorkorderNo 0 0 Asset_ID The unique ID for each asset record generated in GIS in the Stormwater Infrastructure database. The Asset ID is tagged in the workorder to tie the labor to assets. Originator Text 50 Asset_ID 0 0 Group Gives the option to filter workorders categorized under the listed groups: CCTV Program, Channel Management, Emergency Response, Flood Warning, Inlet Maintenance, Stormwater Concrete, Stormwater Infrastructure Management, Vegetation Originator Text 50 Group 0 0 Location Address or relative location of associated labor Originator Text 256 Location 0 0 ParentRecordNo Parent record number is associated with the Workorder Ref ID field in VUEWorks. Originator Text 100 ParentRecordNo 0 0 OpenedDate Begin Date field in VUEWorks Originator Date 10 OpenedDate 0 0 ClosedDate End Date in VUEWorks Originator Date 10 ClosedDate 0 0 Type Reactive, Proactive or General Originator Text 50 Type 0 0 ActivityDescription Activity Description in VUEWorks. Filtering options include but not limited to Channel Maintenance, Priority Call, Customer Service Investigation, CCTV Contract, Drainage Structure Repair. Originator Text 50 ActivityDescription 0 0 LaborHours Hours entered by field staff in the Labor tab of the workorder. Originator Double 18 4 LaborHours 4