cityofaustin / atd-data-tech

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

Maximo Report Request [New] SBODTE Monthly Performance Measure report (CONCRETE and SIDEWALKS) #17146

Open adry-martinez opened 4 months ago

adry-martinez commented 4 months ago

Division manager is requesting a Sidewalk Maintenance report on:

where the team is working each week and day (once a week on Thursdays) a summary report (location, staff, materials, hours for power washers and cyclones for each night) (daily by 9 am, Mon-Fri)

image.png
adry-martinez commented 3 months ago

Pull: from 24-168427 (Great-Grandparent) Get count from Children (within Parents) WONUM, DESCRIPTION, COUNT of MATTRANS DATE, REMEDY, SQFT (ACT_SIDEWALK_PWRWASH), # OF QUANTITY IN GALLONS BASED OFF OF SBO1124, HOURS WORKED (group labor hours by date)

image.png
rebekkabry commented 1 week ago

image 24-168427