From: Mark Wells <mark@freeside.biz>
Date: Wed, 18 Feb 2015 23:50:45 +0000 (-0800)
Subject: use media type codes in broadband subscription report, #28020
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=e11f3188435b30c193fd1443913ed77953e14dea

use media type codes in broadband subscription report, #28020
---

diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm
index c93c919ea..75ddee0d7 100644
--- a/FS/FS/Report/FCC_477.pm
+++ b/FS/FS/Report/FCC_477.pm
@@ -400,7 +400,8 @@ sub fbs_sql {
 
   my @select = (
     "$censustract AS censustract",
-    'technology',
+    '(technology - technology % 10) AS media_type',
+      # media types are multiples of 10
     'broadband_downstream',
     'broadband_upstream',
     "SUM($q)",