LAST UPDATED: APRIL 202 4 Financial Data Models CONTENTS AIRPORT 01 BFO-DIRECTORS-STRATEGIC 02 EQUIPMENT SERVICES 03 FERRY 04 MAINTENANCE & OPERATIONS 05 OFFICE OF THE COUNTY ENGINEER 06 DEVELOPMENT AND LAND SERVICES 08 SEWER 09 SUSTAINABLE RESOURCES 10 SURFACE WATER MANAGEMENT 11
Airport Financial Data Model
Jeff Campbell (Manager)
Fund 460-00 Cost Center PW Airport – Tacoma Narrows Administration 54600P0 Airports and Ports PW180 PW-Airport Operations-O PW414 PW - Overhead Cost Center PW Airport – Tacoma Narrows Operations Cost Center PW Airport – Tacoma Narrows Capital Cost Center PW Airport – Thun Administration 54600P0 Airports and Ports 54600P0 Airports and Ports 59446P0 Capital Expenditures/Expenses – Airports and Ports 54600P0 Airports and Ports PW075 PW-Administration -A PW407 PW-Airports-Airside-I Business Units Programs Cost Centers Fund PW075 PW-Administration -A PW414 PW - Overhead Cost Center PW Airport – Thun Capital 54600P0 Airports and Ports 59446P0 Capital Expenditures/Expenses – Airports and Ports PW075 PW-Administration -A PW075 PW-Administration -A PW267 PW-PE-Consultant Studies-I PW065 PW Facility Maintenance PW180 PW-Airport Operations-O PW414 PW - Overhead Cost Center PW Airport – Thun Operations 54600P0 Airports and Ports PW075 PW-Administration -A PW414 PW - Overhead
Internal
Directors Support / Business Accounting & Operations / Strategic Business Cost Center PW PWU Director’s Support Costs Cost Centers Fund Cost Center PW Business & Financial Operations Cost Center PW Business Analysis Cost Center PW-Strategic Business Director’s Support Business and Financial Operations Strategic Business Division Cost Center PW Contract Services 54330P0 General Services Business Units 54330P0 General Services 54330P0 General Services 54330P0 General Services 54310P0 Management 54330P0 General Services Cost Center Infrastructure Asset Management - Lands 54330P0 General Services Cost Center PW-Communications Cost Center PW-Records Management Division of Innovation and Technology (DoIT) 54330P0 General Services 54330P0 General Services Fund 150-01
PPW – Public Works –
Services
Equipment Services Section Financial Data Model
Bruce Wagner (Manager)
Fund 501-00 Cost Center PW ER&R Roads Materials 54820P0 Pits, Quarries and Asphalt Plants PW075 PW-Administration -A PW079 PW-IT systems-A PW383 PW-ESS-Equipment Maintenance & Operations-A PW384 PW-ESS-Fuel & Fuel Equipment-A PW414 PW - Overhead Cost Center PW ESS Management 54860P0 Equipment Rental Services – Central Services PW115 PW PS Clean Air Agency Business Units Programs Cost Centers Fund 55370P0 Pollution Control and Remediation PW075 PW-Administration-A PW370 PW-Traffic- pavement markings-M PW371 PW-Traffic- signs-M PW383 PW-ESS-Equipment Maintenance & Operations-A Cost Center PW ER&R Traffic Materials Cost Center PW ESS Operations 54820P0 Pits, Quarries and Asphalt Plants 54860P0 Equipment Rental Services - Central Services 59448P0 Capital Expenditures/Expenses - Public Works Central Services PW382 PW-ESS-Equipment Upgrades & Replacements-A
PW235 PW-Ferries - Operations-O
PW237 PW-Ferries-Ferry Operations Contract-O
PW-Christine Anderson
PW-Steilacoom II
Ferry Financial Data Model
Ray Williams (Manager)
PW235 PW-Ferries - Operations-O
PW-Anderson Dock
PW-Anderson Terminal
PW-Christine Anderson
PW-Ketron Dock
PW-Steilacoom Dock
PW-Steilacoom II
PW-Steilacoom Terminal
PW-Anderson Dock
PW-Anderson Terminal
PW-Christine Anderson
PW-Ketron Dock
PW-Steilacoom Dock
PW-Steilacoom II
PW-Steilacoom Terminal
59447P0 Capital Expenditure/Expenses
Transits, Railroads and Other Transportation Systems
PW-Anderson Dock
PW-Ketron Dock
PW-Steilacoom Dock
Fund 480-00 Cost Center PW Ferry - Administration 54720P0 Ferries and Water Taxis
Cost Center PW-Ferry-Operations Cost Center PW-Ferry-Maintenance Cost Center PW-Ferry Capital 54720P0 Ferries and Water Taxis 54720P0 Ferries and Water Taxis 54720P0 Ferries and Water Taxis
Business Units Programs Cost Centers Fund PW075 PW-Administration -A PW414 PW - Overhead Fund 480-01 Cost Center PW-Ferry-Operations 54720P0 Ferries and Water Taxis PW-Steilacoom II
Page 4 of 11
PW058
Road Operations Financial Data Model
Mark Shumacher (Manager)
PW058
PW432
PW435
PW436
PW437
PW439
PW444
PW445
PW446
PW447
PW457
Fund 150-00 Fund 153-00 Cost Center PW M&O Maintenance Activities 59431P0 Capital Expenditures/Expenses - Storm Drainage Utilities 59444P0 Capital Expenditures/Expenses - Roads/Streets Operations Cost Center PW M&O Maintenance Activities Cost Center PW M&O Program Support 54230P0 Roadway - Road Maintenance 54240P0 Drainage - Roads Maintenance 54250P0 Structures 54264P0 Traffic Control Devices - Road Maintenance 54266P0 Snow and Ice Control 54267P0 Street Cleaning 54270P0 Roadside 54290P0 Maintenance Administration and Overhead 54210P0 Engineering - Road Maintenance 54350P0 Facilities 54420P0 Engineering - Roads Operations (DESIGN) 54440P0 Planning - Roads/Streets Operations 59444P0 Capital Expenditures/Expenses - Roads/Streets Operations 5911870 Redemption of Long-Term Debt - Centralized Services 5921880 Interest and Other Debt Service Costs - Centralized Services Cost Center PW M&O Program Support 53100P0 Storm Drainage Utilities 55330P0 Flood Control 53400P0 Water Utilities Business Units Programs Cost Centers Fund 53100P0 Storm Drainage Utilities 55330P0 Flood Control 53400P0 Water Utilities
PW Emergency Planning, Response & Safety
M&O Vegetation Spray/Mow Program
M&O Contaminated Waste Disposals
PW430
PW431
M&O Arborist Services
M&O Security Services
PW434
M&O Facility Related Services and Inspections
M&O WCC Crew Charges
M&O Engineering & Geotech Consultants/Services
M&O Environmental Services for Properties
M&O WA. State Dept of Ecology
PW443
M&O Title Reports/Appraisals
M&O Wildlife Abatement Services
M&O Sheriff Levee Patrol Services
M&O Vactor Camera/Pipe Services
M&O Elodea Removal Contract
M&O Quarry Blasting Services PW451 M&O Pressure Washer R&M
M&O Gates & Stentofon R&M
PW448
PW449
PW456
M&O Electrical & Lighting R&M
M&O Refuse (Facilities) PW459 M&O Fire System R&M
PW458
PW Emergency Planning, Response & Safety
M&O Vegetation Spray/Mow Program
M&O Contaminated Waste Disposals
M&O Arborist Services PW435 M&O Facility Related Services and Inspections PW436 M&O WCC Crew Charges PW437 M&O Engineering & Geotech Consultants/Services PW438 M&O Pavement Rating Services PW439 M&O Environmental Services for Properties PW442 M&O CVE Deputy Costs PW443 M&O WA. State Dept of Ecology PW444 M&O Title Reports/Appraisals PW445 M&O Wildlife Abatement Services PW447 M&O Vactor Camera/Pipe Services PW451 M&O Pressure Washer R&M PW452 M&O Tacoma Narrows Tunnel Costs PW454 M&O Crane R&M PW455 M&O Asphalt Tank R&M PW456 M&O Gates & Stentofon R&M PW457 M&O Electrical & Lighting R&M PW458 M&O Refuse (Facilities) PW459 M&O Fire System R&M PW460 M&O Concrete Contract 53400P1 Water Utilities - Non-Prod time PW058 PW Emergency Planning, Response & Safety Fund 501-00 Cost Center PW ER&R Roads Materials 54820P0 Pits, Quarries and Asphalt Plants PW075 PW-Administration -A PW453 M&O Fencing Inventory 54290P0 Maintenance Administration and Overhead PW058 PW Emergency Planning, Response & Safety PW433 M&O After Hours & OOS Call Services PW434 M&O Security Services PW440 M&O Weather Forecasting Services PW441 M&O HR Background Checks PW450 M&O CAMS Costs PW058 PW Emergency Planning, Response & Safety PW433 M&O After Hours & OOS Call Services PW434 M&O Security Services PW440 M&O Weather Forecasting Services PW441 M&O HR Background Checks PW450 M&O CAMS Costs 53400P1 Water Utilities - Non-Prod time PW058 PW Emergency Planning, Response & Safety
PW430
PW431
PW432
Office of the County Engineer Financial Data Model
Melissa McFadden (Manager)
Fund 150-00 54330P0 General Services Cost Center PW – Transportation Improvement Section 54240P0 Drainage – Roads Maintenance 54310P0 Management Fund 148-00 Cost Center PW PWU County Road Fund Related 59530P0 Roadway – Roads & Other Infrastructure 54350P0 Facilities 54420P0 Engineering – Roads Operations (DESIGN) 54440P0 Planning – Roads/Streets Operations 54490P0 Operations Administration and Overhead Fund 151-XX Cost Center PW Traffic Impact Fee (Roads) 54330P0 General Services 54440P0 Planning – Roads/Streets Operations 59530P0 Roadway - Roads & Other Infrastructure 54110P1 Engineering - Roads Construction/Preservation Projects (Preliminary Engineering) 5919570 Redemption of Long-Term Debt –Roads/Streets 5929580 Interest and Other Debt Service CostsRoads/Streets Cost Center PW - Field Engineering Section 54210P0 Engineering - Road Maintenance 54310P0 Management 54310P0 Management 54330P0 General Services 54350P0 Facilities 54420P0 Engineering - Roads Operations (DESIGN) 54490P0 Operations Administration and Overhead Cost Center Traffic Administration 54290P0 Maintenance Administration and Overhead 54350P0 Facilities 54490P0 Operations Administration and Overhead Cost Center Traffic Engineering 54350P0 Facilities 54490P0 Operations Administration and Overhead Business Units Cost Centers Fund Cost Center PW County Engineer / Contract Admin 54310P0 Management 54350P0 Facilities 54420P0 Engineering - Roads Operations (DESIGN) 54490P0 Operations Administration and Overhead Cost Center PW PWU County Road Fund-Related 54310P0 Management 54330P0 General Services 54350P0 Facilities 54490P0 Operations Administration and Overhead 55850P0 Building Permits and Plan Reviews Cost Center Traffic Signals 54264P0 Traffic Control Devices - Road Maintenance 54290P0 Maintenance Administration and Overhead 54310P0 Management Cost Center Transportation Planning 54310P0 Management 54440P0 Planning - Roads/Streets Operations 54490P0 Operations Administration and Overhead Cost Center Traffic Signs & Markings 54290P0 Maintenance Administration and Overhead 54310P0 Management
Office of the County Engineer Financial Data Model
Melissa McFadden (Manager) Fund 320-00 Cost Center PW - Contracts, Non-Labor Direct Cost – CON / TRAFFIC CON Business Units Programs Cost Centers Fund Cost Center PW - Contracts, Non-Labor Direct Cost – DESIGN / BRIDGE DESIGN / TRAFFIC DESIGN Cost Center PW- Contracts, Land, Non-Labor Direct Cost – ROW 59520P0 Right-Of-Way PW150 PW TIP/CFP - Infrastructure PW151 PW TIP/CFP - Preservation 59510P0 Engineering - Roads & Other Infrastructure (Preliminary) 59510P2 Engineering - Roads & Other Infrastructure (Construction) 59510P9 Engineering - Roads & Other Infrastructure (Final Design) 59530P0 Roadway - Roads & Other Infrastructure 59540P0 Drainage - Roads & Other Infrastructure 59561P0 Sidewalks - Roads & Other Infrastructure 59563P0 Street Lighting - Roads & Other Infrastructure 59564P0 Traffic Control Devices - Road & Other Infrastructure 59569P0 Other Traffic and Pedestrian Services - Roads & Other Infrastructure 59570P0 Roadside Development 59510P0 Engineering - Roads & Other Infrastructure (Preliminary) 59510P9 Engineering - Roads & Other Infrastructure (Final Design) Cost Center PW - Field Engineering Section PW - Transportation Improvement Section 59510P0 Engineering - Roads & Other Infrastructure (Preliminary) 59510P2 Engineering - Roads & Other Infrastructure (Construction) 59510P9 Engineering - Roads & Other Infrastructure (Final Design) 59520P0 Right-Of-Way Cost Center PW – Traffic Engineering 59510P0 Engineering - Roads & Other Infrastructure (Preliminary) 59510P2 Engineering - Roads & Other Infrastructure (Construction) 59510P9 Engineering - Roads & Other Infrastructure (Final Design) Cost Center PW County Engineer/Contract Admin 59510P2 Engineering - Roads & Other Infrastructure (Construction) 59510P9 Engineering - Roads & Other Infrastructure (Final Design) PW150 PW TIP/CFP - Infrastructure PW151 PW TIP/CFP - Preservation PW150 PW TIP/CFP - Infrastructure PW151 PW TIP/CFP - Preservation PW150 PW TIP/CFP - Infrastructure PW151 PW TIP/CFP - Preservation PW150 PW TIP/CFP - Infrastructure PW151 PW TIP/CFP - Preservation PW150 PW TIP/CFP - Infrastructure PW151 PW TIP/CFP - Preservation
Development and Land Services Financial Data Model
Jen Tetatzin (Manager)
Fund 001-00 Fund 188-00 Cost Center Blighted Property Maintenance 55930P0 Property Development - Community Services Cost Center Drinking Water Supply Cost Center Permits/Applications 53400P0 Water Utilities 55860P0 Planning - Community Planning and Economic Development 55850P0 Building Permits and Plan Reviews Cost Center Historical Document Preservation 51310P0 Executive Office Business Units Programs Cost Centers Fund 52460P0 Enforcement of Codes and Regulation WRIA Restoration Planning Fund 176-00 Fund 178-00 Cost Center General Information/ Code Enforcement Cost Center Solid Waste Cost Center Land Use Advisory Committee (LUAC) Cost Center Long Range Planning Review of Failing Water Systems 55860P0 Planning - Community Planning and Economic Development 55860P0 Planning - Community Planning and Economic Development Cost Center Sewer Customer Information Cost Center Sewer Permitting and Planning 53500P0 Sewer/Reclaimed Water Utilities 55860P0 Planning - Community Planning and Economic Development 55850P0 Building Permits and Plan Reviews Cost Center Building Permits 55850P0 Building Permits and Plan Reviews Pierce County Regional Council (PCRC)
Sewer Financial Data Model
Steven Hartwig (Manager)
Fund 402-00 Cost Center PW Sewer Administration 53500P0 Sewer/Reclaimed Water Utilities PW075 PW-Administration-A PW156 PW-Training A Cost Center PW Sewer Engineering Cost Center PW Sewer Planning & Programming Cost Center PW Sewer Business Services 53500P0 Sewer/Reclaimed Water Utilities 53500P0 Sewer/Reclaimed Water Utilities 53500P0 Sewer/Reclaimed Water Utilities PW085 PW-Long-range Planning-A Business Units Programs Cost Centers Fund Project Cost Center PW Sewer Maintenance PW Sewer Operations PW052 PW Development Inspection PW053 PW-Development Review-O PW058 PW Emergency Planning, Response & Safety PW999 Kapowsin Water District Receivership PW417 PW-Sewer General Engineering PW256 PW-Legislative Efforts-A PW167 PW Water Utility PW011 PW-Asset Management-O PW018 PW Budget Development & Monitoring PW067 PW Facility Support Cost Center PW Sewer Customer Service 53500P0 Sewer/Reclaimed Water Utilities PW416 Residential Side Sewer Conservation Loan PW015 PW-Customer Billing-Software Mgmt-O PW031 PW-Customer Billing-Collection Program-O PW014 PW-Customer Billing-Exemption Program-O PW147 PW-Customer Billing-TIF Deferral Support-O PW148 PW-Customer Billing-Reimbursables-A PW212 PW-Customer Billing Services-O 53500P0 Sewer/Reclaimed Water Utilities Wastewater Treatment Fertilizer Manufacturing Environmental Serivces Sewer Airport and Ferry M&O Sewer District 1 Parks M&O Etloh Sewer District 1 M&O Sewer District 1 (Project) Sewer District 2 (Project) Chambers Creek Properties Milton Hylebos Dupont Sewer District 2 Parks M&O Sewer SWM M&O Sewer and Traffic Milton Sewer District 2 M&O PW063 PW-Facilities-M PW117 PW-Sewers-Collection System Pumps-M PW168 PW Water Utility M&O PW174 PW-Sewers-WW Treatment Plant-M PW349 PW-Sewers - grinder pumps-P PW350 PW-Sewers-Collection System Pipes-M PW-Reclaimed Water PW172 PW WWTP Industrial Pretreatment PW173 PW-Sewers-WWTP Laboratory-O PW175 PW-Sewers-WWTP Operations-O Sewer District 3 (Project) Cascadia PW011 PW-Asset Management-O PW-Sewers Procurement/Warehouse PW362 PW System Operations-Engineering-O PW069 PW-Fiscal Services-A PW-Compliance Permits-A PW134 PW SoundGRO/Biosolids Fund 425-60 Cost Center PW Sewer Engineering 59435P0 Capital Expenses - Sewer Utilities 53500P0 Sewer/Reclaimed Water Utilities 59435P0 Capital Expenses - Sewer Utilities 59435P0 Capital Expenses - Sewer Utilities 59435P0 Capital Expenses - Sewer Utilities PW167 PW Water Utility PW416 Residential Side Sewer Conservation Loan PW423 Dry Sewer Line Loan PW424 Dry Sewer Line Connection Charge PW425 Commercial Connection Charge Tacoma Narrows Water ALL
PW207 PW-Construction Management-I PW208 PW-Construction Management-P PW206 PW-Construction Contracts-I PW207 PW-Construction Management-I PW208 PW-Construction Management-P PW206 PW-Construction Contracts-I
COST CENTERS
Sustainable Resources Financial Data Model
Ryan Dicks (Manager)
Fund 470-01 Cost Center PW Sustainability 53700P0 Solid Waste Utilities Cost Center PW Environmental Education Cost Center PW Sustainable Resources General Administration Cost Center PW Waste Reduction & Recycling 53700P0 Solid Waste Utilities 53700P0 Solid Waste Utilities 53700P0 Solid Waste Utilities 57100P0 Educational & Recreational PW079 PW-IT systems-A PW414 PW - Overhead Business Units Programs Cost Centers Fund Fund 470-02, 470-04, 470-05 Cost Center PW Closed Landfills 53700P0 Solid Waste Utilities 52120P0 Police Operations 54310P0 Management 55370P0 Pollution Control and Remediation
Surface Water Management Financial Data Model
PW298
PW359
PW415
PW418
PW419
PW421
Fund 153-00 Cost Center PW SWM Environmental Permitting 53100P0 Storm Drainage Utilities Cost Center PW SWM CIP Non-River Cost Center SWM Administration 53100P0 Storm Drainage Utilities 59431P0 Capital Expenditure/Expenses – Storm Drainage Utilities PW033 PW-Outreach & Education-O PW075 PW-Administration -A PW156 PW-Training-A PW414 PW - Overhead Cost Center PW SWM Water Quality Capital Business Units Programs Cost Centers Fund Fund 323-00 Cost Center PW SWM Floodplain and Watershed Services 55330P0 Flood Control 59431P0 Capital Expenditure/Expenses – Storm Drainage Utilities Cost Center PW SWM CIP Non-River 53100P0 Storm Drainage Utilities PW156 PW-Training-A PW263 PW-Operations-O 55330P0 Flood Control PW027 PW CIP Mitigation Monitoring PW169 PW Watershed Planning Cost Center PW SWM NPDES 53100P0 Storm Drainage Utilities 55370P0 Pollution Control and Remediation PW033 PW-Outreach & Education-O PW094 PW NPDES Coordination PW095 PW NPDES Inspection (Commercial) PW096 PW NPDES Inspection (Residential) PW097 PW NPDES Monitoring Cost Center PW SWM Floodplain and Watershed Services 53100P0 Storm Drainage Utilities 55330P0 Flood Control PW037 PW Community Rating System PW070 PW Flood Control Zone District Support PW156 PW-Training-A PW169 PW Watershed Planning
PW-Commissions, Boards & Advisory Comm-Community Engagement-O
PW-Interagency Coordination-O
Kevin Dragon (Manager)
PW195
PW252
PW-Program Development-A
PW-SWM-Water Quality-O
PW-SWM Floodplain Management
PW Floodplains for the Future
Shellfish Protection
PW-Clarks Creek DRA
PW-Clover Creek WQ Plan PW470 Lake Management Cost Center PW SWM CIP River PW251 PW-Improvements-I PW418 PW Floodplains for the Future 55370P0 Pollution Control and Remediation PW115 PW PS Clean Air Agency 55330P0 Flood Control PW169 PW Watershed Planning PW156 PW-Training-A PW156 PW-Training-A PW156 PW-Training-A 55860P0 Planning - Community Planning and Economic Development PW074 PW Funding for External Agencies Cost Center PW SWM Barriers and Habitat Capital Cost Center PW SWM Coastal Flood Cost Center PW SWM Groundwater Flood
PW422
