cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

FY25 ECM Report Set Up [Modification] to create new #19074

Open rebekkabry opened 1 month ago

rebekkabry commented 1 month ago

Build a report that will pull FY25 Emergency Tickets. Keep in the exist structure as STORM 24 output. Ensure column names are consistent with GIS template.

TOP: GIS BOTTOM: MAXIMO EXPORT

total_rec Column Binding csr311number srreportdate srstatus srworkgroup wonum wostatus woworkgroup Aggregation wodescription woreportdate problemcode failureclass srdescription wldescription srnumber probdescription srdetaillongdesc map_page woactualfinish hours_diff wldetaillongdesc fulladdress serviceaddress prob_area srprobdescription srticketuid worklogid srpriority woworkgroupdesc saddresscode classification        
total_rec Column Binding csr311number srreportdate srstatus srworkgroup wonum wostatus woworkgroup Aggregation wodescription woreportdate problemcode failureclass srdescription wldescription srnumber probdescription srdetaillongdesc map_page woactualfinish hours_diff wldetaillongdesc fulladdress serviceaddress prob_area srprobdescription srticketuid worklogid srpriority woworkgroupdesc saddresscode classification regiondistrict createdby crewid holdreason

image

rebekkabry commented 1 month ago

9/18/24