WNP@HWPROD1> sta HRA_by_location.sql LOCATION COUNT_HRA_COMPLETED ------------------------------ ------------------- Level 1 14 Office 154 PL-Indy Foundry 1 PL-Indy Plant 2 PL-Navistar WHQ 2 PL-PDC York 1 Production 29 7 rows selected. LOCATION COUNT_TOTAL_USERS ------------------------------ ----------------- Austin FE Store 1 Baltimore Pts Distr Cntr 2 Cantera 14 Cincinnati Trk RO 2 Ft Wayne Nav Tech Center 3 Indianapolis Casting Corp 3 Indianapolis Engine Plant 4 Knoxville NAC 3 Level 1 25 Melrose Park Plant 5 Miami Fleet Ryder Export 1 No Data 17 Office 412 PL - Navistar WHQ (Lisle) 280 PL- Modec EV Alliance LLC 6 PL- Monaco RV LLC - Wakarusa 493 PL- WAP - West Point Assm Plan 16 PL-Acxiom 269 PL-Bison LLC Milford 119 PL-Bowling Green 12 PL-Brookfield 23 PL-Continental Mfg. Co LTD 162 PL-Continental Mfg. Co. Dallas 13 PL-Continental Mfg.Co.Ft Laudr 3 PL-Defense/New Breed Logistics 1 PL-FORT LAUDERDALE UTC 2 PL-Fleet Office AR 6 PL-Fleet Office MO 3 PL-Fleet Office NC 1 PL-Fleet Office PA 3 PL-Fontana UTC 3 PL-Foreign Service 60 PL-Ft. Wayne TDTC 1695 PL-Huntsville 437 PL-IC Bus - Tulsa 1615 PL-IC Corp - Conway 713 PL-Indy Foundry 435 PL-Indy Plant 560 PL-Intl Big Bore Diesel LLC 260 PL-Knoxville NAC 156 PL-MI-Navistar Defense 68 PL-Marshfield MO Core Ctr 9 PL-Marshfield Trk Pts Cntr 5 PL-Melrose Park Campus 2535 PL-Miami Office 58 PL-Mixer - Greensboro 5 PL-Mixer - Nashville Office 2 PL-Monaco RV - Coburg 652 PL-Monaco RV - Harrisburg 1 PL-Monaco Work from Home 6 PL-NBC Tower 14 PL-Navistar Financial 245 PL-Navistar WHQ 2407 PL-Navistar Washington DC 8 PL-PBE Location 1 PL-PDC Atlanta 98 PL-PDC Dallas 90 PL-PDC Las Vegas 50 PL-PDC Portland 25 PL-PDC West Chicago 231 PL-PDC York 161 PL-PPT/Eaton 8 PL-Pure Power Technologies 83 PL-Pure Power Technologies MFG 356 PL-Region Midwest / PDC Annex 12 PL-Region Northeast 20 PL-Region Southeast/East 24 PL-Region Southwest 17 PL-Region Western 14 PL-SST Truck Co - Garland 1076 PL-Sara Lee Bldg 24 PL-Springfield Assembly Pl 1670 PL-Springfield TSC 137 PL-TRC Ft. Wayne 160 PL-UTC Atlanta GA 14 PL-UTC Baltimore MD 11 PL-UTC Charlotte NC 12 PL-UTC Columbus OH 21 PL-UTC Denver CO 16 PL-UTC Detroit MI 14 PL-UTC Indy IN 14 PL-UTC Kansas City MO 13 PL-UTC Melrose Pk IL 19 PL-UTC Nashville TN 16 PL-UTC O Fallon MO 1 PL-UTC Oakland CA 11 PL-UTC Philadelphia PA 17 PL-UTC Sacramento CA 10 PL-UTC Shreveport LA 14 PL-UTC Tampa FL 13 PL-Uptime Parts 85 PL-Waukesha 344 PL-Westmont Trng Cntr 5 PL-Woodridge Engineering 3 PL-Workhorse Custom Chassis 383 PL-Workhorse Sales Corp. 35 PL-Working From Home 356 Production 215 Profession 1 Springfield Assembly Plant 1 TESTLOCATION 20 Tulsa Bus Plant 11 Workhorse Sales Corp 1 1 104 rows selected. WNP@HWPROD1> spool off