From 1e2c9c5f859d18d4dc7da8eb1d9b719fd6244aaa Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Wed, 17 Mar 2021 22:16:16 -0700 Subject: contractually guaranteed speed no longer required as of 2020, RT#85671 --- FS/FS/Report/FCC_477.pm | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'FS') diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm index 75ddee0d7..bb01db4c8 100644 --- a/FS/FS/Report/FCC_477.pm +++ b/FS/FS/Report/FCC_477.pm @@ -365,10 +365,12 @@ sub fbd_sql { 'adv_speed_down', 'adv_speed_up', 'CASE WHEN is_business IS NOT NULL THEN 1 ELSE 0 END', - 'cir_speed_down', - 'cir_speed_up', ); - push @select, 'blocknum' if $opt{detail}; + push @select, 'cir_speed_down', 'cir_speed_up' + if $opt{date} < 1569826800; #9/30/2019, halfway between the two filing + # "as of" dates when it changed + push @select, 'blocknum' + if $opt{detail}; my $from = 'deploy_zone_block JOIN deploy_zone USING (zonenum) -- cgit v1.2.1