Vegetation management workflow
One of the largest investor-owned companies in the U.S. utility sector, serving about 1.4 million customers in 29 counties. PPL maintains over 48,000 miles of power lines.
Technical situation
The Vegetation department oversees all tree trimming operations and the managing of the vegetation contractors. The department was using excel spreadsheets to transfer information back and forth to the contractors. Managing the day to day operations along with the regional PPL Forester approval process for work completed in the field was very difficult.
Solution
After analyzing the desired process, Tim Afflerbach designed a new hybrid system using MS Access, SharePoint, and Oracle that streamlined the processes/workflows. The new system manages the data flow between Contractors (2 then, 5 now), PPL Foresters/Line Clearing Inspectors, and Veg Administration. The system is comprised of 3 special database applications (for each of the 3 roles above). All 3 applications use multiple Vegetation SharePoint sites as common data points for all secured transactions.
The new process
- Contractors import work completed reports into local MS Access DB. (Outside Corp. Firewall)
- Contractor uploads actuals into SharePoint. (Actuals now inside Corp. Firewall)
- Forester/LCI approves or denies line items (Notification sent automatically to contractor and Veg Admin for further processing.
- Actuals saved in an Oracle database to be compared with the Yearly estimated Pre-Plans for cost analysis.
Benefits
The entire process is now handled by automated workflows. Foresters/LCIs can filter the thousands of rows of data to now see only the line items they need to approve in a custom dashboard. The process is simpler, faster, and with reduced errors. All roles have custom reports and the data is now safe in a secured Oracle database.