package Common::Consts;

# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#    Copyright RoyaltyShare, Inc. 2005
#    All Rights Reserved.  Licensed Software.
#
#    THIS IS UNPUBLISHED PROPRIETARY SOURCE CODE OF RoyaltyShare, Inc.
#    The copyright notice above does not evidence any actual or
#    intended publication of such source code.
#
#    PROPRIETARY INFORMATION, PROPERTY OF RoyaltyShare, Inc.
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#    $Source$
# ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

use strict;
use warnings;

use Exporter;
use constant VARS => qw(
  $DEBUG

  @NAVIGATION_TABS

  %CLIENT_DB_OLD
  %CLIENT_NAME_CLEAN
  %CLIENT_SALE_AGG
  %CODE_TO_COUNTRY
  %COUNTRY_TO_CODE
  %COUNTRY_CODE
  %CURRENCY_CODE
  %CURRENCY_TO_COUNTRY
  %FILE_STATUS
  %FILE_TYPE
  %FRENCH_MONTH_MAP
  %SERVICE_NAME_CLEAN
  %URLS
);

use vars qw(@ISA @EXPORT_OK);
use vars VARS;

@EXPORT_OK = VARS;
@ISA       = 'Exporter';

use lib '/app/tools/data_classes/lib';

{
    $DEBUG = 0;

    @NAVIGATION_TABS = qw(tracker reports users contact);

    %FILE_TYPE = (
        0 => "unknown",
        1 => "tab",
        2 => "csv",
        3 => "pipe",
        4 => "excel",
        5 => "xml",
    );

    %FILE_STATUS = (
        0 => "unknown",
        1 => "new",
        2 => "pending",
        3 => "open",
        4 => "closed",
    );

    # !!! I would like to move this stuff into a database...

    # clients which get sale aggregates built
    # see for info:
    # /app/tools/stats/bin/build_sale_aggregates.pl
    # /app/tools/stats/bin/build_all_client_sale_aggregates.pl
    %CLIENT_SALE_AGG = (
        999 => {
            period_type   => 'Q',
            priority      => 999,
            active        => 1,
            good_sale_min => 75,
        },
        1 => {
            period_type   => 'Q',
            priority      => 1,
            active        => 1,
            good_sale_min => 75,
        },
        2 => {
            period_type   => 'Q',
            priority      => 2,
            active        => 1,
            good_sale_min => 75,
        },
        3 => {
            period_type   => 'Q',
            priority      => 3,
            active        => 1,
            good_sale_min => 75,
        },
        4 => {
            period_type   => 'Q',
            priority      => 4,
            active        => 1,
            good_sale_min => 75,
        },
        5 => {
            period_type   => 'Q',
            priority      => 5,
            active        => 0,
            good_sale_min => 75,
        },
        6 => {
            period_type   => 'Q',
            priority      => 6,
            active        => 1,
            good_sale_min => 75,
        },
        7 => {
            period_type   => 'Q',
            priority      => 7,
            active        => 0,
            good_sale_min => 75,
        },
        8 => {
            period_type   => 'Q',
            priority      => 8,
            active        => 0,
            good_sale_min => 75,
        },
        9 => {
            period_type   => 'Q',
            priority      => 9,
            active        => 1,
            good_sale_min => 75,
        },
        10 => {
            period_type   => 'Q',
            priority      => 10,
            active        => 1,
            good_sale_min => 75,
        },
        11 => {
            period_type   => 'Q',
            priority      => 11,
            active        => 1,
            good_sale_min => 75,
        },
        12 => {
            period_type   => 'Q',
            priority      => 12,
            active        => 1,
            good_sale_min => 75,
        },
        13 => {
            period_type   => 'Q',
            priority      => 13,
            active        => 1,
            good_sale_min => 75,
        },
        14 => {
            period_type   => 'Q',
            priority      => 14,
            active        => 1,
            good_sale_min => 75,
        },
        15 => {
            period_type   => 'Q',
            priority      => 15,
            active        => 1,
            good_sale_min => 75,
        },
        16 => {
            period_type   => 'Q',
            priority      => 16,
            active        => 1,
            good_sale_min => 75,
        },
        17 => {
            period_type   => 'Q',
            priority      => 17,
            active        => 1,
            good_sale_min => 75,
        },
        18 => {
            period_type   => 'Q',
            priority      => 18,
            active        => 1,
            good_sale_min => 75,
        },
        19 => {
            period_type   => 'Q',
            priority      => 19,
            active        => 1,
            good_sale_min => 75,
        },
        20 => {
            period_type   => 'Q',
            priority      => 20,
            active        => 1,
            good_sale_min => 75,
        },
        21 => {
            period_type   => 'Q',
            priority      => 21,
            active        => 1,
            good_sale_min => 75,
        },
        22 => {
            period_type   => 'Q',
            priority      => 22,
            active        => 1,
            good_sale_min => 75,
        },
        23 => {
            period_type   => 'Q',
            priority      => 23,
            active        => 1,
            good_sale_min => 75,
        },
        24 => {
            period_type   => 'Q',
            priority      => 24,
            active        => 1,
            good_sale_min => 75,
        },
        25 => {
            period_type   => 'Q',
            priority      => 25,
            active        => 1,
            good_sale_min => 75,
        },
        26 => {
            period_type   => 'Q',
            priority      => 26,
            active        => 1,
            good_sale_min => 75,
        },
        27 => {
            period_type   => 'Q',
            priority      => 27,
            active        => 1,
            good_sale_min => 75,
        },
        28 => {
            period_type   => 'Q',
            priority      => 28,
            active        => 1,
            good_sale_min => 75,
        },
        29 => {
            period_type   => 'Q',
            priority      => 29,
            active        => 1,
            good_sale_min => 75,
        },
        30 => {
            period_type   => 'Q',
            priority      => 30,
            active        => 1,
            good_sale_min => 75,
        },
        31 => {
            period_type   => 'Q',
            priority      => 31,
            active        => 1,
            good_sale_min => 75,
        },
        32 => {
            period_type   => 'Q',
            priority      => 32,
            active        => 1,
            good_sale_min => 75,
        },
        33 => {
            period_type   => 'Q',
            priority      => 33,
            active        => 1,
            good_sale_min => 75,
        },
        34 => {
            period_type   => 'Q',
            priority      => 34,
            active        => 1,
            good_sale_min => 75,
        },
        35 => {
            period_type   => 'Q',
            priority      => 35,
            active        => 1,
            good_sale_min => 75,
        },
        36 => {
            period_type   => 'Q',
            priority      => 36,
            active        => 1,
            good_sale_min => 75,
        },
        37 => {
            period_type   => 'Q',
            priority      => 37,
            active        => 1,
            good_sale_min => 75,
        },
        38 => {
            period_type   => 'Q',
            priority      => 38,
            active        => 1,
            good_sale_min => 75,
        },
        39 => {
            period_type   => 'Q',
            priority      => 39,
            active        => 1,
            good_sale_min => 75,
        },
        40 => {
            period_type   => 'Q',
            priority      => 40,
            active        => 1,
            good_sale_min => 75,
        },
        41 => {
            period_type   => 'Q',
            priority      => 41,
            active        => 1,
            good_sale_min => 75,
        },
        42 => {
            period_type   => 'Q',
            priority      => 42,
            active        => 1,
            good_sale_min => 75,
        },
        43 => {
            period_type   => 'Q',
            priority      => 43,
            active        => 1,
            good_sale_min => 75,
        },
        44 => {
            period_type   => 'Q',
            priority      => 44,
            active        => 1,
            good_sale_min => 75,
        },
        45 => {
            period_type   => 'Q',
            priority      => 45,
            active        => 1,
            good_sale_min => 75,
        },
        46 => {
            period_type   => 'Q',
            priority      => 46,
            active        => 1,
            good_sale_min => 75,
        },
        47 => {
            period_type   => 'Q',
            priority      => 47,
            active        => 1,
            good_sale_min => 75,
        },
        48 => {
            period_type   => 'Q',
            priority      => 48,
            active        => 1,
            good_sale_min => 75,
        },
        49 => {
            period_type   => 'Q',
            priority      => 49,
            active        => 1,
            good_sale_min => 75,
        },
        50 => {
            period_type   => 'Q',
            priority      => 50,
            active        => 1,
            good_sale_min => 75,
        },
        51 => {
            period_type   => 'Q',
            priority      => 51,
            active        => 1,
            good_sale_min => 75,
        },
        52 => {
            period_type   => 'Q',
            priority      => 52,
            active        => 1,
            good_sale_min => 75,
        },
        53 => {
            period_type   => 'Q',
            priority      => 53,
            active        => 1,
            good_sale_min => 75,
        },
        54 => {
            period_type   => 'Q',
            priority      => 54,
            active        => 1,
            good_sale_min => 75,
        },
        55 => {
            period_type   => 'Q',
            priority      => 55,
            active        => 1,
            good_sale_min => 75,
        },
        56 => {
            period_type   => 'Q',
            priority      => 56,
            active        => 1,
            good_sale_min => 75,
        },
        57 => {
            period_type   => 'Q',
            priority      => 57,
            active        => 1,
            good_sale_min => 75,
        },
        58 => {
            period_type   => 'Q',
            priority      => 58,
            active        => 1,
            good_sale_min => 75,
        },
        59 => {
            period_type   => 'Q',
            priority      => 59,
            active        => 1,
            good_sale_min => 75,
        },
        60 => {
            period_type   => 'Q',
            priority      => 60,
            active        => 1,
            good_sale_min => 75,
        },
        61 => {
            period_type   => 'Q',
            priority      => 61,
            active        => 1,
            good_sale_min => 75,
        },
        62 => {
            period_type   => 'Q',
            priority      => 62,
            active        => 1,
            good_sale_min => 75,
        },
        63 => {
            period_type   => 'Q',
            priority      => 63,
            active        => 1,
            good_sale_min => 75,
        },
        64 => {
            period_type   => 'Q',
            priority      => 64,
            active        => 1,
            good_sale_min => 75,
        },
        65 => {
            period_type   => 'Q',
            priority      => 65,
            active        => 1,
            good_sale_min => 75,
        },
        66 => {
            period_type   => 'Q',
            priority      => 66,
            active        => 1,
            good_sale_min => 75,
        },
        67 => {
            period_type   => 'Q',
            priority      => 67,
            active        => 1,
            good_sale_min => 75,
        },
        68 => {
            period_type   => 'Q',
            priority      => 68,
            active        => 1,
            good_sale_min => 75,
        },
        69 => {
            period_type   => 'Q',
            priority      => 69,
            active        => 1,
            good_sale_min => 75,
        },
        70 => {
            period_type   => 'Q',
            priority      => 70,
            active        => 1,
            good_sale_min => 75,
        },
        71 => {
            period_type   => 'Q',
            priority      => 71,
            active        => 1,
            good_sale_min => 75,
        },
        72 => {
            period_type   => 'Q',
            priority      => 72,
            active        => 1,
            good_sale_min => 75,
        },
        73 => {
            period_type   => 'Q',
            priority      => 73,
            active        => 1,
            good_sale_min => 75,
        },
        74 => {
            period_type   => 'Q',
            priority      => 74,
            active        => 1,
            good_sale_min => 75,
        },
        75 => {
            period_type   => 'Q',
            priority      => 75,
            active        => 1,
            good_sale_min => 75,
        },
        76 => {
            period_type   => 'Q',
            priority      => 76,
            active        => 1,
            good_sale_min => 75,
        },
        77 => {
            period_type   => 'Q',
            priority      => 77,
            active        => 1,
            good_sale_min => 75,
        },
        79 => {
            period_type   => 'Q',
            priority      => 79,
            active        => 1,
            good_sale_min => 75,
        },
        80 => {
            period_type   => 'Q',
            priority      => 80,
            active        => 1,
            good_sale_min => 75,
        },
        81 => {
            period_type   => 'Q',
            priority      => 81,
            active        => 1,
            good_sale_min => 75,
        },
        82 => {
            period_type   => 'Q',
            priority      => 82,
            active        => 1,
            good_sale_min => 75,
        },
        83 => {
            period_type   => 'Q',
            priority      => 83,
            active        => 1,
            good_sale_min => 75,
        },
        84 => {
            period_type   => 'Q',
            priority      => 84,
            active        => 1,
            good_sale_min => 75,
        },
        86 => {
            period_type   => 'Q',
            priority      => 86,
            active        => 1,
            good_sale_min => 75,
        },
        87 => {
            period_type   => 'Q',
            priority      => 87,
            active        => 1,
            good_sale_min => 75,
        },
        88 => {
            period_type   => 'Q',
            priority      => 88,
            active        => 1,
            good_sale_min => 75,
        },
        89 => {
            period_type   => 'Q',
            priority      => 89,
            active        => 1,
            good_sale_min => 75,
        },
        90 => {
            period_type   => 'Q',
            priority      => 90,
            active        => 1,
            good_sale_min => 75,
        },
        91 => {
            period_type   => 'Q',
            priority      => 91,
            active        => 1,
            good_sale_min => 75,
        },
        92 => {
            period_type   => 'Q',
            priority      => 92,
            active        => 1,
            good_sale_min => 75,
        },
        93 => {
            period_type   => 'Q',
            priority      => 93,
            active        => 1,
            good_sale_min => 75,
        },
        94 => {
            period_type   => 'Q',
            priority      => 94,
            active        => 1,
            good_sale_min => 75,
        },
        95 => {
            period_type   => 'Q',
            priority      => 95,
            active        => 1,
            good_sale_min => 75,
        },
        96 => {
            period_type   => 'Q',
            priority      => 96,
            active        => 1,
            good_sale_min => 75,
        },
        97 => {
            period_type   => 'Q',
            priority      => 97,
            active        => 1,
            good_sale_min => 75,
        },
        98 => {
            period_type   => 'Q',
            priority      => 98,
            active        => 1,
            good_sale_min => 75,
        },
        99 => {
            period_type   => 'Q',
            priority      => 99,
            active        => 1,
            good_sale_min => 75,
        },
        100 => {
            period_type   => 'Q',
            priority      => 100,
            active        => 1,
            good_sale_min => 75,
        },
        101 => {
            period_type   => 'Q',
            priority      => 101,
            active        => 1,
            good_sale_min => 75,
        },
        102 => {
            period_type   => 'Q',
            priority      => 102,
            active        => 1,
            good_sale_min => 75,
        },
        103 => {
            period_type   => 'Q',
            priority      => 103,
            active        => 1,
            good_sale_min => 75,
        },
        104 => {
            period_type   => 'Q',
            priority      => 104,
            active        => 1,
            good_sale_min => 75,
        },
        105 => {
            period_type   => 'Q',
            priority      => 105,
            active        => 1,
            good_sale_min => 75,
        },
        106 => {
            period_type   => 'Q',
            priority      => 106,
            active        => 1,
            good_sale_min => 75,
        },
        107 => {
            period_type   => 'Q',
            priority      => 107,
            active        => 1,
            good_sale_min => 75,
        },
        108 => {
            period_type   => 'Q',
            priority      => 108,
            active        => 1,
            good_sale_min => 75,
        },
        109 => {
            period_type   => 'Q',
            priority      => 109,
            active        => 1,
            good_sale_min => 75,
        },
        110 => {
            period_type   => 'Q',
            priority      => 110,
            active        => 1,
            good_sale_min => 75,
        },
        111 => {
            period_type   => 'Q',
            priority      => 111,
            active        => 1,
            good_sale_min => 75,
        },
        112 => {
            period_type   => 'Q',
            priority      => 112,
            active        => 1,
            good_sale_min => 75,
        },
        113 => {
            period_type   => 'Q',
            priority      => 113,
            active        => 1,
            good_sale_min => 75,
        },
        114 => {
            period_type   => 'Q',
            priority      => 114,
            active        => 1,
            good_sale_min => 75,
        },
        115 => {
            period_type   => 'Q',
            priority      => 115,
            active        => 1,
            good_sale_min => 75,
        },
        116 => {
            period_type   => 'Q',
            priority      => 116,
            active        => 1,
            good_sale_min => 75,
        },
        117 => {
            period_type   => 'Q',
            priority      => 117,
            active        => 1,
            good_sale_min => 75,
        },
        118 => {
            period_type   => 'Q',
            priority      => 118,
            active        => 1,
            good_sale_min => 75,
        },
        119 => {
            period_type   => 'Q',
            priority      => 119,
            active        => 1,
            good_sale_min => 75,
        },
        120 => {
            period_type   => 'Q',
            priority      => 120,
            active        => 1,
            good_sale_min => 75,
        },
        121 => {
            period_type   => 'Q',
            priority      => 121,
            active        => 1,
            good_sale_min => 75,
        },
        122 => {
            period_type   => 'Q',
            priority      => 122,
            active        => 1,
            good_sale_min => 75,
        },
        123 => {
            period_type   => 'Q',
            priority      => 123,
            active        => 1,
            good_sale_min => 75,
        },
        124 => {
            period_type   => 'Q',
            priority      => 124,
            active        => 1,
            good_sale_min => 75,
        },
        125 => {
            period_type   => 'Q',
            priority      => 125,
            active        => 1,
            good_sale_min => 75,
        },
        126 => {
            period_type   => 'Q',
            priority      => 126,
            active        => 1,
            good_sale_min => 75,
        },
        127 => {
            period_type   => 'Q',
            priority      => 127,
            active        => 1,
            good_sale_min => 75,
        },
        128 => {
            period_type   => 'Q',
            priority      => 128,
            active        => 1,
            good_sale_min => 75,
        },
        129 => {
            period_type   => 'Q',
            priority      => 129,
            active        => 1,
            good_sale_min => 75,
        },
        130 => {
            period_type   => 'Q',
            priority      => 130,
            active        => 1,
            good_sale_min => 75,
        },
        131 => {
            period_type   => 'Q',
            priority      => 131,
            active        => 1,
            good_sale_min => 75,
        },
        132 => {
            period_type   => 'Q',
            priority      => 132,
            active        => 1,
            good_sale_min => 75,
        },
        133 => {
            period_type   => 'Q',
            priority      => 133,
            active        => 1,
            good_sale_min => 75,
        },
        134 => {
            period_type   => 'Q',
            priority      => 134,
            active        => 1,
            good_sale_min => 75,
        },
        135 => {
            period_type   => 'Q',
            priority      => 135,
            active        => 1,
            good_sale_min => 75,
        },
        136 => {
            period_type   => 'Q',
            priority      => 136,
            active        => 1,
            good_sale_min => 75,
        },
        137 => {
            period_type   => 'Q',
            priority      => 137,
            active        => 1,
            good_sale_min => 75,
        },
        138 => {
            period_type   => 'Q',
            priority      => 138,
            active        => 1,
            good_sale_min => 75,
        },
        139 => {
            period_type   => 'Q',
            priority      => 139,
            active        => 1,
            good_sale_min => 75,
        },
        140 => {
            period_type   => 'Q',
            priority      => 140,
            active        => 1,
            good_sale_min => 75,
        },
        141 => {
            period_type   => 'Q',
            priority      => 141,
            active        => 1,
            good_sale_min => 75,
        },
        142 => {
            period_type   => 'Q',
            priority      => 142,
            active        => 1,
            good_sale_min => 75,
        },
        143 => {
            period_type   => 'Q',
            priority      => 143,
            active        => 1,
            good_sale_min => 75,
        },
        144 => {
            period_type   => 'Q',
            priority      => 144,
            active        => 1,
            good_sale_min => 75,
        },
        145 => {
            period_type   => 'Q',
            priority      => 145,
            active        => 1,
            good_sale_min => 75,
        },
        146 => {
            period_type   => 'Q',
            priority      => 146,
            active        => 1,
            good_sale_min => 75,
        },
        147 => {
            period_type   => 'Q',
            priority      => 147,
            active        => 1,
            good_sale_min => 75,
        },
        148 => {
            period_type   => 'Q',
            priority      => 148,
            active        => 1,
            good_sale_min => 75,
        },
        149 => {
            period_type   => 'Q',
            priority      => 149,
            active        => 1,
            good_sale_min => 75,
        },
        150 => {
            period_type   => 'Q',
            priority      => 150,
            active        => 1,
            good_sale_min => 75,
        },
        151 => {
            period_type   => 'Q',
            priority      => 151,
            active        => 1,
            good_sale_min => 75,
        },
        152 => {
            period_type   => 'Q',
            priority      => 152,
            active        => 1,
            good_sale_min => 75,
        },
        153 => {
            period_type   => 'Q',
            priority      => 153,
            active        => 1,
            good_sale_min => 75,
        },
        154 => {
            period_type   => 'Q',
            priority      => 154,
            active        => 1,
            good_sale_min => 75,
        },
        155 => {
            period_type   => 'Q',
            priority      => 155,
            active        => 1,
            good_sale_min => 75,
        },
        156 => {
            period_type   => 'Q',
            priority      => 156,
            active        => 1,
            good_sale_min => 75,
        },
        157 => {
            period_type   => 'Q',
            priority      => 157,
            active        => 1,
            good_sale_min => 75,
        },
        158 => {
            period_type   => 'Q',
            priority      => 158,
            active        => 1,
            good_sale_min => 75,
        },
        159 => {
            period_type   => 'Q',
            priority      => 159,
            active        => 1,
            good_sale_min => 75,
        },
        160 => {
            period_type   => 'Q',
            priority      => 160,
            active        => 1,
            good_sale_min => 75,
        },
        161 => {
            period_type   => 'Q',
            priority      => 161,
            active        => 1,
            good_sale_min => 75,
        },
        162 => {
            period_type   => 'Q',
            priority      => 162,
            active        => 1,
            good_sale_min => 75,
        },
        163 => {
            period_type   => 'Q',
            priority      => 163,
            active        => 1,
            good_sale_min => 75,
        },
        164 => {
            period_type   => 'Q',
            priority      => 164,
            active        => 1,
            good_sale_min => 75,
        },
        165 => {
            period_type   => 'Q',
            priority      => 165,
            active        => 1,
            good_sale_min => 75,
        },
        166 => {
            period_type   => 'Q',
            priority      => 166,
            active        => 1,
            good_sale_min => 75,
        },
        167 => {
            period_type   => 'Q',
            priority      => 167,
            active        => 1,
            good_sale_min => 75,
        },
        168 => {
            period_type   => 'Q',
            priority      => 168,
            active        => 1,
            good_sale_min => 75,
        },
        169 => {
            period_type   => 'Q',
            priority      => 169,
            active        => 1,
            good_sale_min => 75,
        },
        170 => {
            period_type   => 'Q',
            priority      => 170,
            active        => 1,
            good_sale_min => 75,
        },
        171 => {
            period_type   => 'Q',
            priority      => 171,
            active        => 1,
            good_sale_min => 75,
        },
        172 => {
            period_type   => 'Q',
            priority      => 172,
            active        => 1,
            good_sale_min => 75,
        },
        173 => {
            period_type   => 'Q',
            priority      => 173,
            active        => 1,
            good_sale_min => 75,
        },
        174 => {
            period_type   => 'Q',
            priority      => 174,
            active        => 1,
            good_sale_min => 75,
        },
        175 => {
            period_type   => 'Q',
            priority      => 175,
            active        => 1,
            good_sale_min => 75,
        },
        176 => {
            period_type   => 'Q',
            priority      => 176,
            active        => 1,
            good_sale_min => 75,
        },
        177 => {
            period_type   => 'Q',
            priority      => 177,
            active        => 1,
            good_sale_min => 75,
        },
        178 => {
            period_type   => 'Q',
            priority      => 178,
            active        => 1,
            good_sale_min => 75,
        },
        179 => {
            period_type   => 'Q',
            priority      => 179,
            active        => 1,
            good_sale_min => 75,
        },
        180 => {
            period_type   => 'Q',
            priority      => 180,
            active        => 1,
            good_sale_min => 75,
        },
        181 => {
            period_type   => 'Q',
            priority      => 181,
            active        => 1,
            good_sale_min => 75,
        },
        182 => {
            period_type   => 'Q',
            priority      => 182,
            active        => 1,
            good_sale_min => 75,
        },
        183 => {
            period_type   => 'Q',
            priority      => 183,
            active        => 1,
            good_sale_min => 75,
        },
        184 => {
            period_type   => 'Q',
            priority      => 184,
            active        => 1,
            good_sale_min => 75,
        },
        185 => {
            period_type   => 'Q',
            priority      => 185,
            active        => 1,
            good_sale_min => 75,
        },
        186 => {
            period_type   => 'Q',
            priority      => 186,
            active        => 1,
            good_sale_min => 75,
        },
        187 => {
            period_type   => 'Q',
            priority      => 187,
            active        => 1,
            good_sale_min => 75,
        },
        188 => {
            period_type   => 'Q',
            priority      => 188,
            active        => 1,
            good_sale_min => 75,
        },
        189 => {
            period_type   => 'Q',
            priority      => 189,
            active        => 1,
            good_sale_min => 75,
        },
        190 => {
            period_type   => 'Q',
            priority      => 190,
            active        => 1,
            good_sale_min => 75,
        },
        191 => {
            period_type   => 'Q',
            priority      => 191,
            active        => 1,
            good_sale_min => 75,
        },
        192 => {
            period_type   => 'Q',
            priority      => 192,
            active        => 1,
            good_sale_min => 75,
        },
        193 => {
            period_type   => 'Q',
            priority      => 193,
            active        => 1,
            good_sale_min => 75,
        },
        194 => {
            period_type   => 'Q',
            priority      => 194,
            active        => 1,
            good_sale_min => 75,
        },
        195 => {
            period_type   => 'Q',
            priority      => 195,
            active        => 1,
            good_sale_min => 75,
        },
        196 => {
            period_type   => 'Q',
            priority      => 196,
            active        => 1,
            good_sale_min => 75,
        },
        197 => {
            period_type   => 'Q',
            priority      => 197,
            active        => 1,
            good_sale_min => 75,
        },
        198 => {
            period_type   => 'Q',
            priority      => 198,
            active        => 1,
            good_sale_min => 75,
        },
        199 => {
            period_type   => 'Q',
            priority      => 199,
            active        => 1,
            good_sale_min => 75,
        },
        200 => {
            period_type   => 'Q',
            priority      => 200,
            active        => 1,
            good_sale_min => 75,
        },
        201 => {
            period_type   => 'Q',
            priority      => 201,
            active        => 1,
            good_sale_min => 75,
        },
        202 => {
            period_type   => 'Q',
            priority      => 202,
            active        => 1,
            good_sale_min => 75,
        },
        203 => {
            period_type   => 'Q',
            priority      => 203,
            active        => 1,
            good_sale_min => 75,
        },
        204 => {
            period_type   => 'Q',
            priority      => 204,
            active        => 1,
            good_sale_min => 75,
        },
        205 => {
            period_type   => 'Q',
            priority      => 205,
            active        => 1,
            good_sale_min => 75,
        },
        206 => {
            period_type   => 'Q',
            priority      => 206,
            active        => 1,
            good_sale_min => 75,
        },
        207 => {
            period_type   => 'Q',
            priority      => 207,
            active        => 1,
            good_sale_min => 75,
        },
        208 => {
            period_type   => 'Q',
            priority      => 208,
            active        => 1,
            good_sale_min => 75,
        },
        209 => {
            period_type   => 'Q',
            priority      => 209,
            active        => 1,
            good_sale_min => 75,
        },
        210 => {
            period_type   => 'Q',
            priority      => 210,
            active        => 1,
            good_sale_min => 75,
        },
        211 => {
            period_type   => 'Q',
            priority      => 211,
            active        => 1,
            good_sale_min => 75,
        },
        212 => {
            period_type   => 'Q',
            priority      => 212,
            active        => 1,
            good_sale_min => 75,
        },
        213 => {
            period_type   => 'Q',
            priority      => 213,
            active        => 1,
            good_sale_min => 75,
        },
        214 => {
            period_type   => 'Q',
            priority      => 214,
            active        => 1,
            good_sale_min => 75,
        },
        215 => {
            period_type   => 'Q',
            priority      => 215,
            active        => 1,
            good_sale_min => 75,
        },
        216 => {
            period_type   => 'Q',
            priority      => 216,
            active        => 1,
            good_sale_min => 75,
        },
        217 => {
            period_type   => 'Q',
            priority      => 217,
            active        => 1,
            good_sale_min => 75,
        },
        218 => {
            period_type   => 'Q',
            priority      => 218,
            active        => 1,
            good_sale_min => 75,
        },
        219 => {
            period_type   => 'Q',
            priority      => 219,
            active        => 1,
            good_sale_min => 75,
        },
        221 => {
            period_type   => 'Q',
            priority      => 221,
            active        => 1,
            good_sale_min => 75,
        },
        222 => {
            period_type   => 'Q',
            priority      => 222,
            active        => 1,
            good_sale_min => 75,
        },
        223 => {
            period_type   => 'Q',
            priority      => 223,
            active        => 1,
            good_sale_min => 75,
        },
        225 => {
            period_type   => 'Q',
            priority      => 225,
            active        => 1,
            good_sale_min => 75,
        },
        226 => {
            period_type   => 'Q',
            priority      => 226,
            active        => 1,
            good_sale_min => 75,
        },
        227 => {
            period_type   => 'Q',
            priority      => 227,
            active        => 1,
            good_sale_min => 75,
        },
        228 => {
            period_type   => 'Q',
            priority      => 228,
            active        => 1,
            good_sale_min => 75,
        },
        229 => {
            period_type   => 'Q',
            priority      => 229,
            active        => 1,
            good_sale_min => 75,
        },
        231 => {
            period_type   => 'Q',
            priority      => 231,
            active        => 1,
            good_sale_min => 75,
        },
        233 => {
            period_type   => 'Q',
            priority      => 233,
            active        => 1,
            good_sale_min => 75,
        },
        234 => {
            period_type   => 'Q',
            priority      => 234,
            active        => 1,
            good_sale_min => 75,
        },
        235 => {
            period_type   => 'Q',
            priority      => 235,
            active        => 1,
            good_sale_min => 75,
        },
        236 => {
            period_type   => 'Q',
            priority      => 236,
            active        => 1,
            good_sale_min => 75,
        },
        237 => {
            period_type   => 'Q',
            priority      => 237,
            active        => 1,
            good_sale_min => 75,
        },
        238 => {
            period_type   => 'Q',
            priority      => 238,
            active        => 1,
            good_sale_min => 75,
        },
        241 => {
            period_type   => 'Q',
            priority      => 241,
            active        => 1,
            good_sale_min => 75,
        },
        243 => {
            period_type   => 'Q',
            priority      => 243,
            active        => 1,
            good_sale_min => 75,
        },
        244 => {
            period_type   => 'Q',
            priority      => 244,
            active        => 1,
            good_sale_min => 75,
        },
        245 => {
            period_type   => 'Q',
            priority      => 245,
            active        => 1,
            good_sale_min => 75,
        },
        246 => {
            period_type   => 'Q',
            priority      => 246,
            active        => 1,
            good_sale_min => 75,
        },
        247 => {
            period_type   => 'Q',
            priority      => 247,
            active        => 1,
            good_sale_min => 75,
        },
        248 => {
            period_type   => 'Q',
            priority      => 248,
            active        => 1,
            good_sale_min => 75,
        },
        249 => {
            period_type   => 'Q',
            priority      => 249,
            active        => 1,
            good_sale_min => 75,
        },
        250 => {
            period_type   => 'Q',
            priority      => 250,
            active        => 1,
            good_sale_min => 75,
        },
        251 => {
            period_type   => 'Q',
            priority      => 251,
            active        => 1,
            good_sale_min => 75,
        },
        252 => {
            period_type   => 'Q',
            priority      => 252,
            active        => 1,
            good_sale_min => 75,
        },
        253 => {
            period_type   => 'Q',
            priority      => 253,
            active        => 1,
            good_sale_min => 75,
        },
        254 => {
            period_type   => 'Q',
            priority      => 254,
            active        => 1,
            good_sale_min => 75,
        },
        255 => {
            period_type   => 'Q',
            priority      => 255,
            active        => 1,
            good_sale_min => 75,
        },
        256 => {
            period_type   => 'Q',
            priority      => 256,
            active        => 1,
            good_sale_min => 75,
        },
        257 => {
            period_type   => 'Q',
            priority      => 257,
            active        => 1,
            good_sale_min => 75,
        },
        258 => {
            period_type   => 'Q',
            priority      => 258,
            active        => 1,
            good_sale_min => 75,
        },
        259 => {
            period_type   => 'Q',
            priority      => 259,
            active        => 1,
            good_sale_min => 75,
        },
        260 => {
            period_type   => 'Q',
            priority      => 260,
            active        => 1,
            good_sale_min => 75,
        },
        261 => {
            period_type   => 'Q',
            priority      => 261,
            active        => 1,
            good_sale_min => 75,
        },
        262 => {
            period_type   => 'Q',
            priority      => 262,
            active        => 1,
            good_sale_min => 75,
        },
        263 => {
            period_type   => 'Q',
            priority      => 263,
            active        => 1,
            good_sale_min => 75,
        },
        264 => {
            period_type   => 'Q',
            priority      => 264,
            active        => 1,
            good_sale_min => 75,
        },
        265 => {
            period_type   => 'Q',
            priority      => 265,
            active        => 1,
            good_sale_min => 75,
        },
        266 => {
            period_type   => 'Q',
            priority      => 266,
            active        => 1,
            good_sale_min => 75,
        },
        267 => {
            period_type   => 'Q',
            priority      => 267,
            active        => 1,
            good_sale_min => 75,
        },
        268 => {
            period_type   => 'Q',
            priority      => 268,
            active        => 1,
            good_sale_min => 75,
        },
        269 => {
            period_type   => 'Q',
            priority      => 269,
            active        => 1,
            good_sale_min => 75,
        },
        270 => {
            period_type   => 'Q',
            priority      => 270,
            active        => 1,
            good_sale_min => 75,
        },
        272 => {
            period_type   => 'Q',
            priority      => 272,
            active        => 1,
            good_sale_min => 75,
        },
        273 => {
            period_type   => 'Q',
            priority      => 273,
            active        => 1,
            good_sale_min => 75,
        },
        274 => {
            period_type   => 'Q',
            priority      => 274,
            active        => 1,
            good_sale_min => 75,
        },
        275 => {
            period_type   => 'Q',
            priority      => 275,
            active        => 1,
            good_sale_min => 75,
        },
        276 => {
            period_type   => 'Q',
            priority      => 276,
            active        => 1,
            good_sale_min => 75,
        },
        277 => {
            period_type   => 'Q',
            priority      => 277,
            active        => 1,
            good_sale_min => 75,
        },
        278 => {
            period_type   => 'Q',
            priority      => 278,
            active        => 1,
            good_sale_min => 75,
        },
        279 => {
            period_type   => 'Q',
            priority      => 279,
            active        => 1,
            good_sale_min => 75,
        },
        280 => {
            period_type   => 'Q',
            priority      => 280,
            active        => 1,
            good_sale_min => 75,
        },
        281 => {
            period_type   => 'Q',
            priority      => 281,
            active        => 1,
            good_sale_min => 75,
        },
        282 => {
            period_type   => 'Q',
            priority      => 282,
            active        => 1,
            good_sale_min => 75,
        },
        283 => {
            period_type   => 'Q',
            priority      => 283,
            active        => 1,
            good_sale_min => 75,
        },
        284 => {
            period_type   => 'Q',
            priority      => 284,
            active        => 1,
            good_sale_min => 75,
        },
        285 => {
            period_type   => 'Q',
            priority      => 285,
            active        => 1,
            good_sale_min => 75,
        },
        286 => {
            period_type   => 'Q',
            priority      => 286,
            active        => 1,
            good_sale_min => 75,
        },
        287 => {
            period_type   => 'Q',
            priority      => 287,
            active        => 1,
            good_sale_min => 75,
        },
        288 => {
            period_type   => 'Q',
            priority      => 288,
            active        => 1,
            good_sale_min => 75,
        },
        289 => {
            period_type   => 'Q',
            priority      => 289,
            active        => 1,
            good_sale_min => 75,
        },
        290 => {
            period_type   => 'Q',
            priority      => 290,
            active        => 1,
            good_sale_min => 75,
        },
        291 => {
            period_type   => 'Q',
            priority      => 291,
            active        => 1,
            good_sale_min => 75,
        },
        292 => {
            period_type   => 'Q',
            priority      => 292,
            active        => 1,
            good_sale_min => 75,
        },
        293 => {
            period_type   => 'Q',
            priority      => 293,
            active        => 1,
            good_sale_min => 75,
        },
        294 => {
            period_type   => 'Q',
            priority      => 294,
            active        => 1,
            good_sale_min => 75,
        },
        295 => {
            period_type   => 'Q',
            priority      => 295,
            active        => 1,
            good_sale_min => 75,
        },
        296 => {
            period_type   => 'Q',
            priority      => 296,
            active        => 1,
            good_sale_min => 75,
        },
        297 => {
            period_type   => 'Q',
            priority      => 297,
            active        => 1,
            good_sale_min => 75,
        },
        298 => {
            period_type   => 'Q',
            priority      => 298,
            active        => 1,
            good_sale_min => 75,
        },
        299 => {
            period_type   => 'Q',
            priority      => 299,
            active        => 1,
            good_sale_min => 75,
        },
        300 => {
            period_type   => 'Q',
            priority      => 300,
            active        => 1,
            good_sale_min => 75,
        },
        301 => {
            period_type   => 'Q',
            priority      => 301,
            active        => 1,
            good_sale_min => 75,
        },
        302 => {
            period_type   => 'Q',
            priority      => 302,
            active        => 1,
            good_sale_min => 75,
        },
        303 => {
            period_type   => 'Q',
            priority      => 303,
            active        => 1,
            good_sale_min => 75,
        },
        304 => {
            period_type   => 'Q',
            priority      => 304,
            active        => 1,
            good_sale_min => 75,
        },
        305 => {
            period_type   => 'Q',
            priority      => 305,
            active        => 1,
            good_sale_min => 75,
        },
        306 => {
            period_type   => 'Q',
            priority      => 306,
            active        => 1,
            good_sale_min => 75,
        },
        307 => {
            period_type   => 'Q',
            priority      => 307,
            active        => 1,
            good_sale_min => 75,
        },
        308 => {
            period_type   => 'Q',
            priority      => 308,
            active        => 1,
            good_sale_min => 75,
        },
        309 => {
            period_type   => 'Q',
            priority      => 309,
            active        => 1,
            good_sale_min => 75,
        },
        310 => {
            period_type   => 'Q',
            priority      => 310,
            active        => 0,
            good_sale_min => 75,
        },
        311 => {
            period_type   => 'Q',
            priority      => 311,
            active        => 1,
            good_sale_min => 75,
        },
        312 => {
            period_type   => 'Q',
            priority      => 312,
            active        => 1,
            good_sale_min => 75,
        },
        313 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        314 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        315 => {
            period_type   => 'Q',
            priority      => 315,
            active        => 1,
            good_sale_min => 75,
        },
        316 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        317 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        318 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        319 => {
            period_type   => 'Q',
            priority      => 319,
            active        => 1,
            good_sale_min => 75,
        },
        320 => {
            period_type   => 'Q',
            priority      => 319,
            active        => 1,
            good_sale_min => 75,
        },
        321 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        322 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        323 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        324 => {
            period_type   => 'Q',
            priority      => 313,
            active        => 1,
            good_sale_min => 75,
        },
        325 => {
            period_type   => 'Q',
            priority      => 325,
            active        => 1,
            good_sale_min => 75,
        },
        326 => {
            period_type   => 'Q',
            priority      => 325,
            active        => 1,
            good_sale_min => 75,
        },
        327 => {
            period_type   => 'Q',
            priority      => 325,
            active        => 1,
            good_sale_min => 75,
        },
        328 => {
            period_type   => 'Q',
            priority      => 325,
            active        => 1,
            good_sale_min => 75,
        },
        329 => {
            period_type   => 'Q',
            priority      => 325,
            active        => 1,
            good_sale_min => 75,
        },
        330 => {
            period_type   => 'Q',
            priority      => 330,
            active        => 1,
            good_sale_min => 75,
        },
        331 => {
            period_type   => 'Q',
            priority      => 331,
            active        => 1,
            good_sale_min => 75,
        },
        332 => {
            period_type   => 'Q',
            priority      => 332,
            active        => 1,
            good_sale_min => 75,
        },
        333 => {
            period_type   => 'Q',
            priority      => 333,
            active        => 1,
            good_sale_min => 75,
        },
        334 => {
            period_type   => 'Q',
            priority      => 334,
            active        => 1,
            good_sale_min => 75,
        },
        335 => {
            period_type   => 'Q',
            priority      => 335,
            active        => 1,
            good_sale_min => 75,
        },
        336 => {
            period_type   => 'Q',
            priority      => 336,
            active        => 1,
            good_sale_min => 75,
        },
        337 => {
            period_type   => 'Q',
            priority      => 337,
            active        => 1,
            good_sale_min => 75,
        },
        339 => {
            period_type   => 'Q',
            priority      => 339,
            active        => 1,
            good_sale_min => 75,
        },
        340 => {
            period_type   => 'Q',
            priority      => 340,
            active        => 1,
            good_sale_min => 75,
        },
        341 => {
            period_type   => 'Q',
            priority      => 341,
            active        => 1,
            good_sale_min => 75,
        },
        342 => {
            period_type   => 'Q',
            priority      => 342,
            active        => 1,
            good_sale_min => 75,
        },
        343 => {
            period_type   => 'Q',
            priority      => 343,
            active        => 1,
            good_sale_min => 75,
        },
        344 => {
            period_type   => 'Q',
            priority      => 344,
            active        => 1,
            good_sale_min => 75,
        },
        345 => {
            period_type   => 'Q',
            priority      => 345,
            active        => 1,
            good_sale_min => 75,
        },
        346 => {
            period_type   => 'Q',
            priority      => 346,
            active        => 1,
            good_sale_min => 75,
        },
        347 => {
            period_type   => 'Q',
            priority      => 347,
            active        => 1,
            good_sale_min => 75,
        },
        348 => {
            period_type   => 'Q',
            priority      => 348,
            active        => 1,
            good_sale_min => 75,
        },
        349 => {
            period_type   => 'Q',
            priority      => 349,
            active        => 1,
            good_sale_min => 75,
        },
        350 => {
            period_type   => 'Q',
            priority      => 350,
            active        => 1,
            good_sale_min => 75,
        },
        351 => {
            period_type   => 'Q',
            priority      => 351,
            active        => 1,
            good_sale_min => 75,
        },
        352 => {
            period_type   => 'Q',
            priority      => 352,
            active        => 1,
            good_sale_min => 75,
        },
        353 => {
            period_type   => 'Q',
            priority      => 353,
            active        => 1,
            good_sale_min => 75,
        },
        354 => {
            period_type   => 'Q',
            priority      => 354,
            active        => 1,
            good_sale_min => 75,
        },
        355 => {
            period_type   => 'Q',
            priority      => 355,
            active        => 1,
            good_sale_min => 75,
        },
        356 => {
            period_type   => 'Q',
            priority      => 356,
            active        => 1,
            good_sale_min => 75,
        },
        357 => {
            period_type   => 'Q',
            priority      => 357,
            active        => 1,
            good_sale_min => 75,
        },
        358 => {
            period_type   => 'Q',
            priority      => 358,
            active        => 1,
            good_sale_min => 75,
        },
        359 => {
            period_type   => 'Q',
            priority      => 359,
            active        => 1,
            good_sale_min => 75,
        },
        360 => {
            period_type   => 'Q',
            priority      => 360,
            active        => 1,
            good_sale_min => 75,
        },
        361 => {
            period_type   => 'Q',
            priority      => 361,
            active        => 1,
            good_sale_min => 75,
        },
        362 => {
            period_type   => 'Q',
            priority      => 362,
            active        => 1,
            good_sale_min => 75,
        },
        363 => {
            period_type   => 'Q',
            priority      => 363,
            active        => 1,
            good_sale_min => 75,
        },
        364 => {
            period_type   => 'Q',
            priority      => 364,
            active        => 1,
            good_sale_min => 75,
        },
        365 => {
            period_type   => 'Q',
            priority      => 365,
            active        => 1,
            good_sale_min => 75,
        },
        366 => {
            period_type   => 'Q',
            priority      => 366,
            active        => 1,
            good_sale_min => 75,
        },
        367 => {
            period_type   => 'Q',
            priority      => 367,
            active        => 1,
            good_sale_min => 75,
        },
        368 => {
            period_type   => 'Q',
            priority      => 368,
            active        => 1,
            good_sale_min => 75,
        },
        369 => {
            period_type   => 'Q',
            priority      => 369,
            active        => 1,
            good_sale_min => 75,
        },
        370 => {
            period_type   => 'Q',
            priority      => 370,
            active        => 1,
            good_sale_min => 75,
        },
        371 => {
            period_type   => 'Q',
            priority      => 371,
            active        => 1,
            good_sale_min => 75,
        },
        372 => {
            period_type   => 'Q',
            priority      => 372,
            active        => 1,
            good_sale_min => 75,
        },
        373 => {
            period_type   => 'Q',
            priority      => 373,
            active        => 1,
            good_sale_min => 75,
        },
        374 => {
            period_type   => 'Q',
            priority      => 374,
            active        => 1,
            good_sale_min => 75,
        },
        375 => {
            period_type   => 'Q',
            priority      => 375,
            active        => 1,
            good_sale_min => 75,
        },
        376 => {
            period_type   => 'Q',
            priority      => 376,
            active        => 1,
            good_sale_min => 75,
        },
        377 => {
            period_type   => 'Q',
            priority      => 377,
            active        => 1,
            good_sale_min => 75,
        },
        378 => {
            period_type   => 'Q',
            priority      => 378,
            active        => 1,
            good_sale_min => 75,
        },
        379 => {
            period_type   => 'Q',
            priority      => 379,
            active        => 1,
            good_sale_min => 75,
        },
        380 => {
            period_type   => 'Q',
            priority      => 380,
            active        => 1,
            good_sale_min => 75,
        },
        381 => {
            period_type   => 'Q',
            priority      => 381,
            active        => 1,
            good_sale_min => 75,
        },
        382 => {
            period_type   => 'Q',
            priority      => 382,
            active        => 1,
            good_sale_min => 75,
        },
        383 => {
            period_type   => 'Q',
            priority      => 383,
            active        => 1,
            good_sale_min => 75,
        },
        384 => {
            period_type   => 'Q',
            priority      => 384,
            active        => 1,
            good_sale_min => 75,
        },
        385 => {
            period_type   => 'Q',
            priority      => 385,
            active        => 1,
            good_sale_min => 75,
        },
        386 => {
            period_type   => 'Q',
            priority      => 386,
            active        => 1,
            good_sale_min => 75,
        },
        387 => {
            period_type   => 'Q',
            priority      => 387,
            active        => 1,
            good_sale_min => 75,
        },
        388 => {
            period_type   => 'Q',
            priority      => 388,
            active        => 1,
            good_sale_min => 75,
        },
        389 => {
            period_type   => 'Q',
            priority      => 389,
            active        => 1,
            good_sale_min => 75,
        },
        390 => {
            period_type   => 'Q',
            priority      => 390,
            active        => 1,
            good_sale_min => 75,
        },
        391 => {
            period_type   => 'Q',
            priority      => 391,
            active        => 1,
            good_sale_min => 75,
        },
        392 => {
            period_type   => 'Q',
            priority      => 392,
            active        => 1,
            good_sale_min => 75,
        },
        393 => {
            period_type   => 'Q',
            priority      => 393,
            active        => 1,
            good_sale_min => 75,
        },
        394 => {
            period_type   => 'Q',
            priority      => 394,
            active        => 1,
            good_sale_min => 75,
        },
        395 => {
            period_type   => 'Q',
            priority      => 395,
            active        => 1,
            good_sale_min => 75,
        },
        396 => {
            period_type   => 'Q',
            priority      => 396,
            active        => 1,
            good_sale_min => 75,
        },
        397 => {
            period_type   => 'Q',
            priority      => 397,
            active        => 1,
            good_sale_min => 75,
        },
        398 => {
            period_type   => 'Q',
            priority      => 398,
            active        => 1,
            good_sale_min => 75,
        },
        399 => {
            period_type   => 'Q',
            priority      => 399,
            active        => 1,
            good_sale_min => 75,
        },
        400 => {
            period_type   => 'Q',
            priority      => 400,
            active        => 1,
            good_sale_min => 75,
        },
        401 => {
            period_type   => 'Q',
            priority      => 401,
            active        => 1,
            good_sale_min => 75,
        },
        402 => {
            period_type   => 'Q',
            priority      => 402,
            active        => 1,
            good_sale_min => 75,
        },
        403 => {
            period_type   => 'Q',
            priority      => 403,
            active        => 1,
            good_sale_min => 75,
        },
        404 => {
            period_type   => 'Q',
            priority      => 404,
            active        => 1,
            good_sale_min => 75,
        },
        405 => {
            period_type   => 'Q',
            priority      => 405,
            active        => 1,
            good_sale_min => 75,
        },
        406 => {
            period_type   => 'Q',
            priority      => 406,
            active        => 1,
            good_sale_min => 75,
        },
        407 => {
            period_type   => 'Q',
            priority      => 407,
            active        => 1,
            good_sale_min => 75,
        },
        408 => {
            period_type   => 'Q',
            priority      => 408,
            active        => 1,
            good_sale_min => 75,
        },
        409 => {
            period_type   => 'Q',
            priority      => 409,
            active        => 1,
            good_sale_min => 75,
        },
        410 => {
            period_type   => 'Q',
            priority      => 410,
            active        => 1,
            good_sale_min => 75,
        },
        411 => {
            period_type   => 'Q',
            priority      => 411,
            active        => 1,
            good_sale_min => 75,
        },
        412 => {
            period_type   => 'Q',
            priority      => 412,
            active        => 1,
            good_sale_min => 75,
        },
        413 => {
            period_type   => 'Q',
            priority      => 413,
            active        => 1,
            good_sale_min => 75,
        },
        414 => {
            period_type   => 'Q',
            priority      => 414,
            active        => 1,
            good_sale_min => 75,
        },
        415 => {
            period_type   => 'Q',
            priority      => 415,
            active        => 1,
            good_sale_min => 75,
        },
        416 => {
            period_type   => 'Q',
            priority      => 416,
            active        => 1,
            good_sale_min => 75,
        },
        417 => {
            period_type   => 'Q',
            priority      => 417,
            active        => 1,
            good_sale_min => 75,
        },
        418 => {
            period_type   => 'Q',
            priority      => 418,
            active        => 1,
            good_sale_min => 75,
        },
        419 => {
            period_type   => 'Q',
            priority      => 419,
            active        => 1,
            good_sale_min => 75,
        },
        420 => {
            period_type   => 'Q',
            priority      => 420,
            active        => 1,
            good_sale_min => 75,
        },
        421 => {
            period_type   => 'Q',
            priority      => 421,
            active        => 1,
            good_sale_min => 75,
        },
        422 => {
            period_type   => 'Q',
            priority      => 422,
            active        => 1,
            good_sale_min => 75,
        },
        423 => {
            period_type   => 'Q',
            priority      => 423,
            active        => 1,
            good_sale_min => 75,
        },
        424 => {
            period_type   => 'Q',
            priority      => 424,
            active        => 1,
            good_sale_min => 75,
        },
        425 => {
            period_type   => 'Q',
            priority      => 425,
            active        => 1,
            good_sale_min => 75,
        },
        426 => {
            period_type   => 'Q',
            priority      => 426,
            active        => 1,
            good_sale_min => 75,
        },
        427 => {
            period_type   => 'Q',
            priority      => 427,
            active        => 1,
            good_sale_min => 75,
        },
        428 => {
            period_type   => 'Q',
            priority      => 428,
            active        => 1,
            good_sale_min => 75,
        },
        429 => {
            period_type   => 'Q',
            priority      => 429,
            active        => 1,
            good_sale_min => 75,
        },
        430 => {
            period_type   => 'Q',
            priority      => 430,
            active        => 1,
            good_sale_min => 75,
        },
        431 => {
            period_type   => 'Q',
            priority      => 431,
            active        => 1,
            good_sale_min => 75,
        },
        432 => {
            period_type   => 'Q',
            priority      => 432,
            active        => 1,
            good_sale_min => 75,
        },
        433 => {
            period_type   => 'Q',
            priority      => 433,
            active        => 1,
            good_sale_min => 75,
        },
        434 => {
            period_type   => 'Q',
            priority      => 434,
            active        => 1,
            good_sale_min => 75,
        },
        435 => {
            period_type   => 'Q',
            priority      => 435,
            active        => 1,
            good_sale_min => 75,
        },
        436 => {
            period_type   => 'Q',
            priority      => 436,
            active        => 1,
            good_sale_min => 75,
        },
        437 => {
            period_type   => 'Q',
            priority      => 437,
            active        => 1,
            good_sale_min => 75,
        },
        438 => {
            period_type   => 'Q',
            priority      => 438,
            active        => 1,
            good_sale_min => 75,
        },
        439 => {
            period_type   => 'Q',
            priority      => 439,
            active        => 1,
            good_sale_min => 75,
        },
        440 => {
            period_type   => 'Q',
            priority      => 440,
            active        => 1,
            good_sale_min => 75,
        },
        441 => {
            period_type   => 'Q',
            priority      => 441,
            active        => 1,
            good_sale_min => 75,
        },
        442 => {
            period_type   => 'Q',
            priority      => 442,
            active        => 1,
            good_sale_min => 75,
        },
        443 => {
            period_type   => 'Q',
            priority      => 443,
            active        => 1,
            good_sale_min => 75,
        },
        444 => {
            period_type   => 'Q',
            priority      => 444,
            active        => 1,
            good_sale_min => 75,
        },
        445 => {
            period_type   => 'Q',
            priority      => 445,
            active        => 1,
            good_sale_min => 75,
        },
        446 => {
            period_type   => 'Q',
            priority      => 446,
            active        => 1,
            good_sale_min => 75,
        },
        447 => {
            period_type   => 'Q',
            priority      => 447,
            active        => 1,
            good_sale_min => 75,
        },
        448 => {
            period_type   => 'Q',
            priority      => 448,
            active        => 1,
            good_sale_min => 75,
        },
        449 => {
            period_type   => 'Q',
            priority      => 449,
            active        => 1,
            good_sale_min => 75,
        },
        450 => {
            period_type   => 'Q',
            priority      => 450,
            active        => 1,
            good_sale_min => 75,
        },
        451 => {
            period_type   => 'Q',
            priority      => 451,
            active        => 1,
            good_sale_min => 75,
        },
        452 => {
            period_type   => 'Q',
            priority      => 452,
            active        => 1,
            good_sale_min => 75,
        },
        453 => {
            period_type   => 'Q',
            priority      => 453,
            active        => 1,
            good_sale_min => 75,
        },
        454 => {
            period_type   => 'Q',
            priority      => 454,
            active        => 1,
            good_sale_min => 75,
        },
        455 => {
            period_type   => 'Q',
            priority      => 455,
            active        => 1,
            good_sale_min => 75,
        },
        456 => {
            period_type   => 'Q',
            priority      => 456,
            active        => 1,
            good_sale_min => 75,
        },
        457 => {
            period_type   => 'Q',
            priority      => 457,
            active        => 1,
            good_sale_min => 75,
        },
        458 => {
            period_type   => 'Q',
            priority      => 458,
            active        => 1,
            good_sale_min => 75,
        },
        459 => {
            period_type   => 'Q',
            priority      => 459,
            active        => 1,
            good_sale_min => 75,
        },
        460 => {
            period_type   => 'Q',
            priority      => 460,
            active        => 1,
            good_sale_min => 75,
        },
        461 => {
            period_type   => 'Q',
            priority      => 461,
            active        => 1,
            good_sale_min => 75,
        },
        462 => {
            period_type   => 'Q',
            priority      => 462,
            active        => 1,
            good_sale_min => 75,
        },
        463 => {
            period_type   => 'Q',
            priority      => 463,
            active        => 1,
            good_sale_min => 75,
        },
        464 => {
            period_type   => 'Q',
            priority      => 464,
            active        => 1,
            good_sale_min => 75,
        },
        465 => {
            period_type   => 'Q',
            priority      => 465,
            active        => 1,
            good_sale_min => 75,
        },
        466 => {
            period_type   => 'Q',
            priority      => 466,
            active        => 1,
            good_sale_min => 75,
        },
        467 => {
            period_type   => 'Q',
            priority      => 467,
            active        => 1,
            good_sale_min => 75,
        },
        468 => {
            period_type   => 'Q',
            priority      => 468,
            active        => 1,
            good_sale_min => 75,
        },
        469 => {
            period_type   => 'Q',
            priority      => 469,
            active        => 1,
            good_sale_min => 75,
        },
        470 => {
            period_type   => 'Q',
            priority      => 470,
            active        => 1,
            good_sale_min => 75,
        },
        471 => {
            period_type   => 'Q',
            priority      => 471,
            active        => 1,
            good_sale_min => 75,
        },
        472 => {
            period_type   => 'Q',
            priority      => 472,
            active        => 1,
            good_sale_min => 75,
        },
        473 => {
            period_type   => 'Q',
            priority      => 473,
            active        => 1,
            good_sale_min => 75,
        },
        474 => {
            period_type   => 'Q',
            priority      => 474,
            active        => 1,
            good_sale_min => 75,
        },
        475 => {
            period_type   => 'Q',
            priority      => 475,
            active        => 1,
            good_sale_min => 75,
        },
        476 => {
            period_type   => 'Q',
            priority      => 476,
            active        => 1,
            good_sale_min => 75,
        },
        477 => {
            period_type   => 'Q',
            priority      => 477,
            active        => 1,
            good_sale_min => 75,
        },
        478 => {
            period_type   => 'Q',
            priority      => 478,
            active        => 1,
            good_sale_min => 75,
        },
        479 => {
            period_type   => 'Q',
            priority      => 479,
            active        => 1,
            good_sale_min => 75,
        },
        480 => {
            period_type   => 'Q',
            priority      => 480,
            active        => 1,
            good_sale_min => 75,
        },
        481 => {
            period_type   => 'Q',
            priority      => 481,
            active        => 1,
            good_sale_min => 75,
        },
        482 => {
            period_type   => 'Q',
            priority      => 482,
            active        => 1,
            good_sale_min => 75,
        },
        483 => {
            period_type   => 'Q',
            priority      => 483,
            active        => 1,
            good_sale_min => 75,
        },
        484 => {
            period_type   => 'Q',
            priority      => 484,
            active        => 1,
            good_sale_min => 75,
        },
        485 => {
            period_type   => 'Q',
            priority      => 485,
            active        => 1,
            good_sale_min => 75,
        },
        486 => {
            period_type   => 'Q',
            priority      => 486,
            active        => 1,
            good_sale_min => 75,
        },
        487 => {
            period_type   => 'Q',
            priority      => 487,
            active        => 1,
            good_sale_min => 75,
        },
        488 => {
            period_type   => 'Q',
            priority      => 488,
            active        => 1,
            good_sale_min => 75,
        },
        489 => {
            period_type   => 'Q',
            priority      => 489,
            active        => 1,
            good_sale_min => 75,
        },
        490 => {
            period_type   => 'Q',
            priority      => 490,
            active        => 1,
            good_sale_min => 75,
        },
        491 => {
            period_type   => 'Q',
            priority      => 491,
            active        => 1,
            good_sale_min => 75,
        },
        492 => {
            period_type   => 'Q',
            priority      => 492,
            active        => 1,
            good_sale_min => 75,
        },
        493 => {
            period_type   => 'Q',
            priority      => 493,
            active        => 1,
            good_sale_min => 75,
        },
        494 => {
            period_type   => 'Q',
            priority      => 494,
            active        => 1,
            good_sale_min => 75,
        },
        495 => {
            period_type   => 'Q',
            priority      => 495,
            active        => 1,
            good_sale_min => 75,
        },
        496 => {
            period_type   => 'Q',
            priority      => 496,
            active        => 1,
            good_sale_min => 75,
        },
        497 => {
            period_type   => 'Q',
            priority      => 497,
            active        => 1,
            good_sale_min => 75,
        },
        498 => {
            period_type   => 'Q',
            priority      => 498,
            active        => 1,
            good_sale_min => 75,
        },
        499 => {
            period_type   => 'Q',
            priority      => 499,
            active        => 1,
            good_sale_min => 75,
        },
        500 => {
            period_type   => 'Q',
            priority      => 500,
            active        => 1,
            good_sale_min => 75,
        },
        501 => {
            period_type   => 'Q',
            priority      => 501,
            active        => 1,
            good_sale_min => 75,
        },
        502 => {
            period_type   => 'Q',
            priority      => 502,
            active        => 1,
            good_sale_min => 75,
        },
        503 => {
            period_type   => 'Q',
            priority      => 503,
            active        => 1,
            good_sale_min => 75,
        },
        504 => {
            period_type   => 'Q',
            priority      => 504,
            active        => 1,
            good_sale_min => 75,
        },
        505 => {
            period_type   => 'Q',
            priority      => 505,
            active        => 1,
            good_sale_min => 75,
        },
        506 => {
            period_type   => 'Q',
            priority      => 506,
            active        => 1,
            good_sale_min => 75,
        },
        507 => {
            period_type   => 'Q',
            priority      => 507,
            active        => 1,
            good_sale_min => 75,
        },
        508 => {
            period_type   => 'Q',
            priority      => 508,
            active        => 1,
            good_sale_min => 75,
        },
        509 => {
            period_type   => 'Q',
            priority      => 509,
            active        => 1,
            good_sale_min => 75,
        },
        510 => {
            period_type   => 'Q',
            priority      => 510,
            active        => 1,
            good_sale_min => 75,
        },
        511 => {
            period_type   => 'Q',
            priority      => 511,
            active        => 1,
            good_sale_min => 75,
        },
        512 => {
            period_type   => 'Q',
            priority      => 512,
            active        => 1,
            good_sale_min => 75,
        },
        513 => {
            period_type   => 'Q',
            priority      => 513,
            active        => 1,
            good_sale_min => 75,
        },
        514 => {
            period_type   => 'Q',
            priority      => 514,
            active        => 1,
            good_sale_min => 75,
        },
        515 => {
            period_type   => 'Q',
            priority      => 515,
            active        => 1,
            good_sale_min => 75,
        },
        516 => {
            period_type   => 'Q',
            priority      => 516,
            active        => 1,
            good_sale_min => 75,
        },
        517 => {
            period_type   => 'Q',
            priority      => 517,
            active        => 1,
            good_sale_min => 75,
        },
        518 => {
            period_type   => 'Q',
            priority      => 518,
            active        => 1,
            good_sale_min => 75,
        },
        519 => {
            period_type   => 'Q',
            priority      => 519,
            active        => 1,
            good_sale_min => 75,
        },
        520 => {
            period_type   => 'Q',
            priority      => 520,
            active        => 1,
            good_sale_min => 75,
        },
        521 => {
            period_type   => 'Q',
            priority      => 521,
            active        => 1,
            good_sale_min => 75,
        },
        522 => {
            period_type   => 'Q',
            priority      => 522,
            active        => 1,
            good_sale_min => 75,
        },
        523 => {
            period_type   => 'Q',
            priority      => 523,
            active        => 1,
            good_sale_min => 75,
        },
        524 => {
            period_type   => 'Q',
            priority      => 524,
            active        => 1,
            good_sale_min => 75,
        },
        525 => {
            period_type   => 'Q',
            priority      => 525,
            active        => 1,
            good_sale_min => 75,
        },
        526 => {
            period_type   => 'Q',
            priority      => 526,
            active        => 1,
            good_sale_min => 75,
        },
        527 => {
            period_type   => 'Q',
            priority      => 527,
            active        => 1,
            good_sale_min => 75,
        },
        528 => {
            period_type   => 'Q',
            priority      => 528,
            active        => 1,
            good_sale_min => 75,
        },
        529 => {
            period_type   => 'Q',
            priority      => 529,
            active        => 1,
            good_sale_min => 75,
        },
        530 => {
            period_type   => 'Q',
            priority      => 530,
            active        => 1,
            good_sale_min => 75,
        },
        531 => {
            period_type   => 'Q',
            priority      => 531,
            active        => 1,
            good_sale_min => 75,
        },
        532 => {
            period_type   => 'Q',
            priority      => 532,
            active        => 1,
            good_sale_min => 75,
        },
        533 => {
            period_type   => 'Q',
            priority      => 533,
            active        => 1,
            good_sale_min => 75,
        },
        534 => {
            period_type   => 'Q',
            priority      => 534,
            active        => 1,
            good_sale_min => 75,
        },
        535 => {
            period_type   => 'Q',
            priority      => 535,
            active        => 1,
            good_sale_min => 75,
        },
        536 => {
            period_type   => 'Q',
            priority      => 536,
            active        => 1,
            good_sale_min => 75,
        },
        537 => {
            period_type   => 'Q',
            priority      => 537,
            active        => 1,
            good_sale_min => 75,
        },
        538 => {
            period_type   => 'Q',
            priority      => 538,
            active        => 1,
            good_sale_min => 75,
        },
        539 => {
            period_type   => 'Q',
            priority      => 539,
            active        => 1,
            good_sale_min => 75,
        },
        540 => {
            period_type   => 'Q',
            priority      => 540,
            active        => 1,
            good_sale_min => 75,
        },
        541 => {
            period_type   => 'Q',
            priority      => 541,
            active        => 1,
            good_sale_min => 75,
        },
        542 => {
            period_type   => 'Q',
            priority      => 542,
            active        => 1,
            good_sale_min => 75,
        },
        543 => {
            period_type   => 'Q',
            priority      => 543,
            active        => 1,
            good_sale_min => 75,
        },
        544 => {
            period_type   => 'Q',
            priority      => 544,
            active        => 1,
            good_sale_min => 75,
        },
        545 => {
            period_type   => 'Q',
            priority      => 545,
            active        => 1,
            good_sale_min => 75,
        },
        546 => {
            period_type   => 'Q',
            priority      => 546,
            active        => 1,
            good_sale_min => 75,
        },
        547 => {
            period_type   => 'Q',
            priority      => 547,
            active        => 1,
            good_sale_min => 75,
        },
        548 => {
            period_type   => 'Q',
            priority      => 548,
            active        => 1,
            good_sale_min => 75,
        },
        549 => {
            period_type   => 'Q',
            priority      => 549,
            active        => 1,
            good_sale_min => 75,
        },
        550 => {
            period_type   => 'Q',
            priority      => 550,
            active        => 1,
            good_sale_min => 75,
        },
        551 => {
            period_type   => 'Q',
            priority      => 551,
            active        => 1,
            good_sale_min => 75,
        },
        552 => {
            period_type   => 'Q',
            priority      => 552,
            active        => 1,
            good_sale_min => 75,
        },
        553 => {
            period_type   => 'Q',
            priority      => 553,
            active        => 1,
            good_sale_min => 75,
        },
        554 => {
            period_type   => 'Q',
            priority      => 554,
            active        => 1,
            good_sale_min => 75,
        },
        555 => {
            period_type   => 'Q',
            priority      => 555,
            active        => 1,
            good_sale_min => 75,
        },
        556 => {
            period_type   => 'Q',
            priority      => 556,
            active        => 1,
            good_sale_min => 75,
        },
        557 => {
            period_type   => 'Q',
            priority      => 557,
            active        => 1,
            good_sale_min => 75,
        },
        558 => {
            period_type   => 'Q',
            priority      => 558,
            active        => 1,
            good_sale_min => 75,
        },
        559 => {
            period_type   => 'Q',
            priority      => 559,
            active        => 1,
            good_sale_min => 75,
        },
        560 => {
            period_type   => 'Q',
            priority      => 560,
            active        => 1,
            good_sale_min => 75,
        },
        561 => {
            period_type   => 'Q',
            priority      => 561,
            active        => 1,
            good_sale_min => 75,
        },
        562 => {
            period_type   => 'Q',
            priority      => 562,
            active        => 1,
            good_sale_min => 75,
        },
        563 => {
            period_type   => 'Q',
            priority      => 563,
            active        => 1,
            good_sale_min => 75,
        },
        564 => {
            period_type   => 'Q',
            priority      => 564,
            active        => 1,
            good_sale_min => 75,
        },
        565 => {
            period_type   => 'Q',
            priority      => 565,
            active        => 1,
            good_sale_min => 75,
        },
        566 => {
            period_type   => 'Q',
            priority      => 566,
            active        => 1,
            good_sale_min => 75,
        },
        567 => {
            period_type   => 'Q',
            priority      => 567,
            active        => 1,
            good_sale_min => 75,
        },
        568 => {
            period_type   => 'Q',
            priority      => 568,
            active        => 1,
            good_sale_min => 75,
        },
        569 => {
            period_type   => 'Q',
            priority      => 569,
            active        => 1,
            good_sale_min => 75,
        },
        570 => {
            period_type   => 'Q',
            priority      => 570,
            active        => 1,
            good_sale_min => 75,
        },
        571 => {
            period_type   => 'Q',
            priority      => 571,
            active        => 1,
            good_sale_min => 75,
        },
        572 => {
            period_type   => 'Q',
            priority      => 572,
            active        => 1,
            good_sale_min => 75,
        },
        573 => {
            period_type   => 'Q',
            priority      => 573,
            active        => 1,
            good_sale_min => 75,
        },
        574 => {
            period_type   => 'Q',
            priority      => 574,
            active        => 1,
            good_sale_min => 75,
        },
        575 => {
            period_type   => 'Q',
            priority      => 575,
            active        => 1,
            good_sale_min => 75,
        },
        576 => {
            period_type   => 'Q',
            priority      => 576,
            active        => 1,
            good_sale_min => 75,
        },
        577 => {
            period_type   => 'Q',
            priority      => 577,
            active        => 1,
            good_sale_min => 75,
        },
        578 => {
            period_type   => 'Q',
            priority      => 578,
            active        => 1,
            good_sale_min => 75,
        },
        579 => {
            period_type   => 'Q',
            priority      => 579,
            active        => 1,
            good_sale_min => 75,
        },
        580 => {
            period_type   => 'Q',
            priority      => 580,
            active        => 1,
            good_sale_min => 75,
        },
        581 => {
            period_type   => 'Q',
            priority      => 581,
            active        => 1,
            good_sale_min => 75,
        },
        582 => {
            period_type   => 'Q',
            priority      => 582,
            active        => 1,
            good_sale_min => 75,
        },
        583 => {
            period_type   => 'Q',
            priority      => 583,
            active        => 1,
            good_sale_min => 75,
        },
        584 => {
            period_type   => 'Q',
            priority      => 584,
            active        => 1,
            good_sale_min => 75,
        },
        585 => {
            period_type   => 'Q',
            priority      => 585,
            active        => 1,
            good_sale_min => 75,
        },
        586 => {
            period_type   => 'Q',
            priority      => 586,
            active        => 1,
            good_sale_min => 75,
        },
        587 => {
            period_type   => 'Q',
            priority      => 587,
            active        => 1,
            good_sale_min => 75,
        },
        588 => {
            period_type   => 'Q',
            priority      => 588,
            active        => 1,
            good_sale_min => 75,
        },
        589 => {
            period_type   => 'Q',
            priority      => 589,
            active        => 1,
            good_sale_min => 75,
        },
        590 => {
            period_type   => 'Q',
            priority      => 590,
            active        => 1,
            good_sale_min => 75,
        },
        591 => {
            period_type   => 'Q',
            priority      => 591,
            active        => 1,
            good_sale_min => 75,
        },
        592 => {
            period_type   => 'Q',
            priority      => 592,
            active        => 1,
            good_sale_min => 75,
        },
        593 => {
            period_type   => 'Q',
            priority      => 593,
            active        => 1,
            good_sale_min => 75,
        },
        594 => {
            period_type   => 'Q',
            priority      => 594,
            active        => 1,
            good_sale_min => 75,
        },
        595 => {
            period_type   => 'Q',
            priority      => 595,
            active        => 1,
            good_sale_min => 75,
        },
        596 => {
            period_type   => 'Q',
            priority      => 596,
            active        => 1,
            good_sale_min => 75,
        },
        597 => {
            period_type   => 'Q',
            priority      => 597,
            active        => 1,
            good_sale_min => 75,
        },
        598 => {
            period_type   => 'Q',
            priority      => 598,
            active        => 1,
            good_sale_min => 75,
        },
        599 => {
            period_type   => 'Q',
            priority      => 599,
            active        => 1,
            good_sale_min => 75,
        },
        600 => {
            period_type   => 'Q',
            priority      => 600,
            active        => 1,
            good_sale_min => 75,
        },
        601 => {
            period_type   => 'Q',
            priority      => 601,
            active        => 1,
            good_sale_min => 75,
        },
        602 => {
            period_type   => 'Q',
            priority      => 602,
            active        => 1,
            good_sale_min => 75,
        },
        603 => {
            period_type   => 'Q',
            priority      => 603,
            active        => 1,
            good_sale_min => 75,
        },
        604 => {
            period_type   => 'Q',
            priority      => 604,
            active        => 1,
            good_sale_min => 75,
        },
        605 => {
            period_type   => 'Q',
            priority      => 605,
            active        => 1,
            good_sale_min => 75,
        },
        606 => {
            period_type   => 'Q',
            priority      => 606,
            active        => 1,
            good_sale_min => 75,
        },
        607 => {
            period_type   => 'Q',
            priority      => 607,
            active        => 1,
            good_sale_min => 75,
        },
        608 => {
            period_type   => 'Q',
            priority      => 608,
            active        => 1,
            good_sale_min => 75,
        },
        609 => {
            period_type   => 'Q',
            priority      => 609,
            active        => 1,
            good_sale_min => 75,
        },
        610 => {
            period_type   => 'Q',
            priority      => 610,
            active        => 1,
            good_sale_min => 75,
        },
        611 => {
            period_type   => 'Q',
            priority      => 611,
            active        => 1,
            good_sale_min => 75,
        },
        612 => {
            period_type   => 'Q',
            priority      => 612,
            active        => 1,
            good_sale_min => 75,
        },
        613 => {
            period_type   => 'Q',
            priority      => 613,
            active        => 1,
            good_sale_min => 75,
        },
        614 => {
            period_type   => 'Q',
            priority      => 614,
            active        => 1,
            good_sale_min => 75,
        },
        615 => {
            period_type   => 'Q',
            priority      => 615,
            active        => 1,
            good_sale_min => 75,
        },
        616 => {
            period_type   => 'Q',
            priority      => 616,
            active        => 1,
            good_sale_min => 75,
        },
        617 => {
            period_type   => 'Q',
            priority      => 617,
            active        => 1,
            good_sale_min => 75,
        },
        618 => {
            period_type   => 'Q',
            priority      => 618,
            active        => 1,
            good_sale_min => 75,
        },
        619 => {
            period_type   => 'Q',
            priority      => 619,
            active        => 1,
            good_sale_min => 75,
        },
        620 => {
            period_type   => 'Q',
            priority      => 620,
            active        => 1,
            good_sale_min => 75,
        },
        621 => {
            period_type   => 'Q',
            priority      => 621,
            active        => 1,
            good_sale_min => 75,
        },
        622 => {
            period_type   => 'Q',
            priority      => 622,
            active        => 1,
            good_sale_min => 75,
        },
        623 => {
            period_type   => 'Q',
            priority      => 623,
            active        => 1,
            good_sale_min => 75,
        },
        624 => {
            period_type   => 'Q',
            priority      => 624,
            active        => 1,
            good_sale_min => 75,
        },
        625 => {
            period_type   => 'Q',
            priority      => 625,
            active        => 1,
            good_sale_min => 75,
        },
        626 => {
            period_type   => 'Q',
            priority      => 626,
            active        => 1,
            good_sale_min => 75,
        },
        627 => {
            period_type   => 'Q',
            priority      => 627,
            active        => 1,
            good_sale_min => 75,
        },
        628 => {
            period_type   => 'Q',
            priority      => 628,
            active        => 1,
            good_sale_min => 75,
        },
        629 => {
            period_type   => 'Q',
            priority      => 629,
            active        => 1,
            good_sale_min => 75,
        },
        630 => {
            period_type   => 'Q',
            priority      => 630,
            active        => 1,
            good_sale_min => 75,
        },
        631 => {
            period_type   => 'Q',
            priority      => 631,
            active        => 1,
            good_sale_min => 75,
        },
        632 => {
            period_type   => 'Q',
            priority      => 632,
            active        => 1,
            good_sale_min => 75,
        },
        633 => {
            period_type   => 'Q',
            priority      => 633,
            active        => 1,
            good_sale_min => 75,
        },
        634 => {
            period_type   => 'Q',
            priority      => 634,
            active        => 1,
            good_sale_min => 75,
        },
        635 => {
            period_type   => 'Q',
            priority      => 635,
            active        => 1,
            good_sale_min => 75,
        },
        636 => {
            period_type   => 'Q',
            priority      => 636,
            active        => 1,
            good_sale_min => 75,
        },
        637 => {
            period_type   => 'Q',
            priority      => 637,
            active        => 1,
            good_sale_min => 75,
        },
        638 => {
            period_type   => 'Q',
            priority      => 638,
            active        => 1,
            good_sale_min => 75,
        },
        639 => {
            period_type   => 'Q',
            priority      => 639,
            active        => 1,
            good_sale_min => 75,
        },
        640 => {
            period_type   => 'Q',
            priority      => 640,
            active        => 1,
            good_sale_min => 75,
        },
        641 => {
            period_type   => 'Q',
            priority      => 641,
            active        => 1,
            good_sale_min => 75,
        },
        642 => {
            period_type   => 'Q',
            priority      => 642,
            active        => 1,
            good_sale_min => 75,
        },
        643 => {
            period_type   => 'Q',
            priority      => 643,
            active        => 1,
            good_sale_min => 75,
        },
        644 => {
            period_type   => 'Q',
            priority      => 644,
            active        => 1,
            good_sale_min => 75,
        },
        645 => {
            period_type   => 'Q',
            priority      => 645,
            active        => 1,
            good_sale_min => 75,
        },
        646 => {
            period_type   => 'Q',
            priority      => 646,
            active        => 1,
            good_sale_min => 75,
        },

        # !!! Beta 1 == hbg beta.  This is intended to be temporary.
        2000000001 => {
            period_type   => 'Q',
            priority      => 325,
            active        => 1,
            good_sale_min => 75,
        },
    );

    # Hardcoded urls:
    %URLS = (
        www           => 'http://www.royaltyshare.com/',
        access_denied => '/access_denied.html',
        home          => '/',
        error         => '/notfound.html',
        login         => '/app/login',
        logout        => '/app/logout',

        # jpk - pointing raptor to use the appuser code,
        #       to see if that works...
        #login         => '/rps/login',
        #logout        => '/rps/logout',
    );

    # Currency codes by country code
    %CURRENCY_CODE = (
        'AU' => 'AUD',
        'CA' => 'CAD',
        'DE' => 'EUR',
        'GB' => 'GBP',
        'JP' => 'JPY',
        'NZ' => 'NZD',
        'US' => 'USD',
    );
    map { $CURRENCY_TO_COUNTRY{ $CURRENCY_CODE{$_} } = $_ } keys %CURRENCY_CODE;

    # Country codes
    %COUNTRY_CODE = (
        'abw'                                                          => 'AW',
        'afg'                                                          => 'AF',
        'afghanistan'                                                  => 'AF',
        'ago'                                                          => 'AO',
        'ala'                                                          => 'AX',
        'aland islands'                                                => 'AX',
        'alb'                                                          => 'AL',
        'albania'                                                      => 'AL',
        'algeria'                                                      => 'DZ',
        'american samoa'                                               => 'AS',
        'andorra'                                                      => 'AD',
        'and'                                                          => 'AD',
        'angola'                                                       => 'AO',
        'angola (republic of)'                                         => 'AO',
        'anguilla'                                                     => 'AI',
        'antarctica'                                                   => 'AQ',
        'atg'                                                          => 'AG',
        'antigua and barbuda'                                          => 'AG',
        'are'                                                          => 'AE',
        'arg'                                                          => 'AR',
        'argentina'                                                    => 'AR',
        'arm'                                                          => 'AM',
        'armenia'                                                      => 'AM',
        'aruba'                                                        => 'AW',
        'aus'                                                          => 'AU',
        'australia'                                                    => 'AU',
        'australia, commonwealth of'                                   => 'AU',
        'austria'                                                      => 'AT',
        'aut'                                                          => 'AT',
        'azerbaijan'                                                   => 'AZ',
        'aze'                                                          => 'AZ',
        'bahamas'                                                      => 'BS',
        'bahrain'                                                      => 'BH',
        'bgd'                                                          => 'BD',
        'bangladesh'                                                   => 'BD',
        'barbados'                                                     => 'BB',
        'bel'                                                          => 'BE',
        'belarus'                                                      => 'BY',
        'belgium'                                                      => 'BE',
        'belize'                                                       => 'BZ',
        'benin'                                                        => 'BJ',
        'bermuda'                                                      => 'BM',
        'bgr'                                                          => 'BG',
        'bhr'                                                          => 'BH',
        'bhs'                                                          => 'BS',
        'bhutan'                                                       => 'BT',
        'blr'                                                          => 'BY',
        'bmu'                                                          => 'BM',
        'bol'                                                          => 'BO',
        'bolivia'                                                      => 'BO',
        'bosnia and herzegovina'                                       => 'BA',
        'bosnia-herzegovina'                                           => 'BA',
        'bih'                                                          => 'BA',
        'botswana'                                                     => 'BW',
        'bouvet island'                                                => 'BV',
        'bra'                                                          => 'BR',
        'brazil'                                                       => 'BR',
        'brb'                                                          => 'BB',
        'british indian ocean territory'                               => 'IO',
        'brn'                                                          => 'BN',
        'brunei darussalam'                                            => 'BN',
        'bulgaria'                                                     => 'BG',
        'burkina faso'                                                 => 'BF',
        'burma'                                                        => 'MM',
        'burundi'                                                      => 'BI',
        'khm'                                                          => 'KH',
        'cambodia'                                                     => 'KH',
        'cameroon'                                                     => 'CM',
        'cameroon, united republic of'                                 => 'CM',
        'can'                                                          => 'CA',
        'canada'                                                       => 'CA',
        'cape verde'                                                   => 'CV',
        'caraibes'                                                     => 'FR',
        'cym'                                                          => 'KY',
        'cayman'                                                       => 'KY',
        'cayman islands'                                               => 'KY',
        'central african republic'                                     => 'CF',
        'chad'                                                         => 'TD',
        'che'                                                          => 'CH',
        'chile'                                                        => 'CL',
        'china'                                                        => 'CN',
        'chl'                                                          => 'CL',
        'chn'                                                          => 'CN',
        'christmas island'                                             => 'CX',
        'cocos'                                                        => 'AU',
        'cocos (keeling) islands'                                      => 'AU',
        'col'                                                          => 'CO',
        'colombia'                                                     => 'CO',
        'comoros'                                                      => 'KM',
        'congo'                                                        => 'CG',
        'congo, the democratic republic of the'                        => 'CD',
        'cook islands'                                                 => 'CI',
        'costa rica'                                                   => 'CR',
        'corsica'                                                      => 'VP',
        'civ'                                                          => 'CI',
        'cote d\'ivoire'                                               => 'CI',
        'cri'                                                          => 'CR',
        'croatia'                                                      => 'HR',
        'cuba'                                                         => 'CU',
        'curaçao'                                                     => 'CW',
        'cyp'                                                          => 'CY',
        'cyprus'                                                       => 'CY',
        'cze'                                                          => 'CZ',
        'czech republic'                                               => 'CZ',
        'de'                                                           => 'DE',
        'denmark'                                                      => 'DK',
        'deu'                                                          => 'DE',
        'djibouti'                                                     => 'DJ',
        'dma'                                                          => 'DM',
        'dnk'                                                          => 'DK',
        'dom'                                                          => 'DO',
        'dominica'                                                     => 'DM',
        'dominican republic'                                           => 'DO',
        'east timor'                                                   => 'TP',
        'ecu'                                                          => 'EC',
        'ecuador'                                                      => 'EC',
        'egy'                                                          => 'EG',
        'egypt'                                                        => 'EG',
        'eire'                                                         => 'IE',
        'el salvador'                                                  => 'SV',
        'england'                                                      => 'GB',
        'equatorial guinea'                                            => 'GQ',
        'eritrea'                                                      => 'ER',
        'esp'                                                          => 'ES',
        'est'                                                          => 'EE',
        'estonia'                                                      => 'EE',
        'ethiopia'                                                     => 'ET',
        'eu'                                                           => 'EU',
        'eur'                                                          => 'EU',
        'european union'                                               => 'EU',
        'europe'                                                       => 'EU',
        'falkland islands (islas malvinas)'                            => 'FK',
        'falkland islands (malvinas)'                                  => 'FK',
        'fro'                                                          => 'FO',
        'faroe islands'                                                => 'FO',
        'fiji'                                                         => 'FJ',
        'fin'                                                          => 'FI',
        'finland'                                                      => 'FI',
        'fra'                                                          => 'FR',
        'france'                                                       => 'FR',
        'france,metropolitan'                                          => 'FR',
        'french guiana'                                                => 'GF',
        'french polynesia'                                             => 'PF',
        'french southern territories'                                  => 'TF',
        'fx'                                                           => 'FR',
        'fxx'                                                          => 'FR',
        'gabon'                                                        => 'GA',
        'gambia'                                                       => 'GM',
        'gb'                                                           => 'GB',
        'gbr'                                                          => 'GB',
        'geo'                                                          => 'GE',
        'georgia'                                                      => 'GE',
        'germany'                                                      => 'DE',
        'ghana'                                                        => 'GH',
        'gib'                                                          => 'GI',
        'gibraltar'                                                    => 'GI',
        'glp'                                                          => 'GP',
        'grc'                                                          => 'GR',
        'great britain'                                                => 'GB',
        'greece'                                                       => 'GR',
        'grl'                                                          => 'GL',
        'greenland'                                                    => 'GL',
        'grd'                                                          => 'WG',
        'grenada'                                                      => 'WG',
        'gtm'                                                          => 'GT',
        'guadeloupe'                                                   => 'GP',
        'guadeloupe (fr.)'                                             => 'GP',
        'gum'                                                          => 'GU',
        'guam'                                                         => 'GU',
        'guatemala'                                                    => 'GT',
        'ggy'                                                          => 'GG',
        'guernsey'                                                     => 'GG',
        'guernsey (channel islands)'                                   => 'GB',
        'guinea'                                                       => 'GN',
        'guinea-bissau'                                                => 'GW',
        'guyana'                                                       => 'GY',
        'haiti'                                                        => 'RH',
        'heard island and mcdonald islands'                            => 'HM',
        'hkg'                                                          => 'HK',
        'holland'                                                      => 'NL',
        'holy see (vatican city state)'                                => 'VA',
        'hnd'                                                          => 'HN',
        'honduras'                                                     => 'HN',
        'hong kong'                                                    => 'HK',
        'hong kong s.a.r.'                                             => 'HK',
        'hrv'                                                          => 'HR',
        'hun'                                                          => 'HU',
        'hungary'                                                      => 'HU',
        'iceland'                                                      => 'IS',
        'idn'                                                          => 'ID',
        'ind'                                                          => 'IN',
        'india'                                                        => 'IN',
        'indonesia'                                                    => 'ID',
        'irn'                                                          => 'IR',
        'iran'                                                         => 'IR',
        'iran, islamic republic of'                                    => 'IR',
        'iraq'                                                         => 'IQ',
        'irq'                                                          => 'IQ',
        'ireland'                                                      => 'IE',
        'irish republic'                                               => 'IE',
        'irl'                                                          => 'IE',
        'isl'                                                          => 'IS',
        'imn'                                                          => 'IM',
        'isle of man'                                                  => 'IM',
        'isr'                                                          => 'IL',
        'israel'                                                       => 'IL',
        'ita'                                                          => 'IT',
        'italy'                                                        => 'IT',
        'ja'                                                           => 'JM',
        'jam'                                                          => 'JM',
        'jamaica'                                                      => 'JM',
        'japan'                                                        => 'JP',
        'jersey'                                                       => 'JE',
        'jersey (ch. isl.)'                                            => 'JE',
        'jey'                                                          => 'JE',
        'jor'                                                          => 'JO',
        'jordan'                                                       => 'JO',
        'jpn'                                                          => 'JP',
        'kaz'                                                          => 'KZ',
        'kazakhstan'                                                   => 'KZ',
        'ken'                                                          => 'KE',
        'kenya'                                                        => 'KE',
        'kiribati'                                                     => 'KI',
        'kor'                                                          => 'KR',
        'korea, democratic people\'s republic of'                      => 'KR',
        'korea, republic of'                                           => 'KP',
        'korea'                                                        => 'KP',
        'kuwait'                                                       => 'KW',
        'kwt'                                                          => 'KW',
        'kyrgyzstan'                                                   => 'KG',
        'lao people\'s democratic republic'                            => 'LA',
        'latvia'                                                       => 'LV',
        'lbn'                                                          => 'LB',
        'lebanon'                                                      => 'LB',
        'lesotho'                                                      => 'LS',
        'liberia'                                                      => 'LR',
        'libyan arab jamahiriya'                                       => 'LY',
        'liechtenstein'                                                => 'LI',
        'lithuania'                                                    => 'LT',
        'ltu'                                                          => 'LT',
        'lux'                                                          => 'LU',
        'luxembourg'                                                   => 'LU',
        'lva'                                                          => 'LV',
        'mac'                                                          => 'MO',
        'macao'                                                        => 'MO',
        'macau'                                                        => 'MO',
        'macedonia'                                                    => 'MK',
        'macedonia (frm yugoslavia)'                                   => 'MK',
        'macedonia, the former yugoslav republic of'                   => 'MK',
        'madagascar'                                                   => 'RM',
        'madeira'                                                      => 'PT',
        'malawi'                                                       => 'MW',
        'malaysia'                                                     => 'MY',
        'mdv'                                                          => 'MV',
        'maldives'                                                     => 'MV',
        'mali'                                                         => 'ML',
        'malta'                                                        => 'MT',
        'mar'                                                          => 'MA',
        'marshall islands'                                             => 'MH',
        'martinique'                                                   => 'MQ',
        'martinique (fr.)'                                             => 'MQ',
        'mauritania'                                                   => 'MR',
        'mauritius'                                                    => 'MU',
        'mayotte'                                                      => 'YT',
        'mco'                                                          => 'MC',
        'mex'                                                          => 'MX',
        'mexico'                                                       => 'MX',
        'micronesia,federated states of'                               => 'FM',
        'mkd'                                                          => 'MK',
        'mlt'                                                          => 'MT',
        'mda'                                                          => 'MD',
        'moldova'                                                      => 'MD',
        'republic of moldova'                                          => 'MD',
        'moldova, republic of'                                         => 'MD',
        'monaco'                                                       => 'MC',
        'mongolia'                                                     => 'MN',
        'montenegro'                                                   => 'ME',
        'mne'                                                          => 'ME',
        'montserrat'                                                   => 'MS',
        'morocco'                                                      => 'MA',
        'mozambique'                                                   => 'MZ',
        'mus'                                                          => 'MU',
        'mmr'                                                          => 'MM',
        'myanmar'                                                      => 'MM',
        'mys'                                                          => 'MY',
        'nam'                                                          => 'NA',
        'namibia'                                                      => 'NA',
        'nauru'                                                        => 'NR',
        'ncl'                                                          => 'NC',
        'nepal'                                                        => 'NP',
        'netherlands'                                                  => 'NL',
        'ant'                                                          => 'AN',
        'netherlands antilles'                                         => 'AN',
        'new caledonia'                                                => 'NC',
        'new caledonia (fr.)'                                          => 'NC',
        'new zealand'                                                  => 'NZ',
        'nic'                                                          => 'NI',
        'nicaragua'                                                    => 'NI',
        'niger'                                                        => 'RN',
        'nigeria'                                                      => 'NG',
        'niue'                                                         => 'NU',
        'nld'                                                          => 'NL',
        'nor'                                                          => 'NO',
        'norfolk island'                                               => 'NF',
        'northern ireland'                                             => 'IE',
        'northern mariana islands'                                     => 'MP',
        'norway'                                                       => 'NO',
        'nzl'                                                          => 'NZ',
        'omn'                                                          => 'OM',
        'oman'                                                         => 'OM',
        'pak'                                                          => 'PK',
        'pakistan'                                                     => 'PK',
        'palau'                                                        => 'PW',
        'palestinian territory, occupied'                              => 'PS',
        'pan'                                                          => 'PA',
        'panama'                                                       => 'PA',
        'papua new guinea'                                             => 'PG',
        'paraguay'                                                     => 'PY',
        'pry'                                                          => 'PY',
        'per'                                                          => 'PE',
        'peru'                                                         => 'PE',
        'philippines'                                                  => 'PH',
        'phl'                                                          => 'PH',
        'pitcairn'                                                     => 'PN',
        'pol'                                                          => 'PL',
        'poland'                                                       => 'PL',
        'polynesia (fr.)'                                              => 'PF',
        'portugal'                                                     => 'PT',
        'pri'                                                          => 'US',
        'prt'                                                          => 'PT',
        'puerto rico'                                                  => 'US',
        'puerto rico (us)'                                             => 'US',
        'pyf'                                                          => 'PF',
        'qat'                                                          => 'QA',
        'qatar'                                                        => 'QA',
        'reu'                                                          => 'RE',
        'rom'                                                          => 'RO',
        'romania'                                                      => 'RO',
        'rou'                                                          => 'RO',
        'rus'                                                          => 'RU',
        'russia'                                                       => 'RU',
        'russian federation'                                           => 'RU',
        'rwanda'                                                       => 'RW',
        'reunion'                                                      => 'RE',
        'saint barthelemy'                                             => 'BL',
        'saint helena'                                                 => 'SH',
        'saint kitts and nevis'                                        => 'KN',
        'saint lucia'                                                  => 'WL',
        'saint martin'                                                 => 'MF',
        'saint pierre and miquelon'                                    => 'PM',
        'saint vincent'                                                => 'WV',
        'saint vincent and the grenadines'                             => 'VC',
        'st.vincent & grenadines'                                      => 'VC',
        'samoa'                                                        => 'WS',
        'smr'                                                          => 'SM',
        'san marino'                                                   => 'SM',
        'sant helena'                                                  => 'SH',
        'sao tome and principe'                                        => 'ST',
        'sau'                                                          => 'SA',
        'saudi arabia'                                                 => 'SA',
        'scg'                                                          => 'CS',
        'scotland'                                                     => 'UK',
        'sen'                                                          => 'SN',
        'senegal'                                                      => 'SN',
        'serbia'                                                       => 'RS',
        'srb'                                                          => 'RS',
        'serbia and montenegro'                                        => 'CS',
        'seychelles'                                                   => 'SC',
        'sgp'                                                          => 'SG',
        'sierra leone'                                                 => 'SL',
        'singapore'                                                    => 'SG',
        'slovakia'                                                     => 'SK',
        'slovakia (slovak republic)'                                   => 'SK',
        'slovenia'                                                     => 'SI',
        'slv'                                                          => 'SV',
        'solomon islands'                                              => 'SB',
        'somalia'                                                      => 'SO',
        'south africa'                                                 => 'ZA',
        'south georgia and the south sandwich islands'                 => 'GS',
        'south korea'                                                  => 'KR',
        'spain'                                                        => 'ES',
        'lka'                                                          => 'LK',
        'sri lanka'                                                    => 'LK',
        'sudan'                                                        => 'SD',
        'suriname'                                                     => 'SR',
        'svalbard and jan mayen'                                       => 'SJ',
        'svk'                                                          => 'SK',
        'svn'                                                          => 'SI',
        'sint maarten'                                                 => 'SX',
        'swaziland'                                                    => 'SZ',
        'swe'                                                          => 'SE',
        'sweden'                                                       => 'SE',
        'switzerland'                                                  => 'CH',
        'syr'                                                          => 'SY',
        'syria'                                                        => 'SY',
        'syrian arab republic'                                         => 'SY',
        'taiwan'                                                       => 'TW',
        'taiwan, province of china'                                    => 'TW',
        'tajikistan'                                                   => 'TJ',
        'tanzania'                                                     => 'TZ',
        'tanzania, united republic of'                                 => 'TZ',
        'tha'                                                          => 'TH',
        'thailand'                                                     => 'TH',
        'the caribbean netherlands (bonaire, sint eustatius and saba)' => 'BQ',
        'the netherlands'                                              => 'NL',
        'timor-leste'                                                  => 'TL',
        'togo'                                                         => 'TG',
        'tokelau'                                                      => 'TK',
        'tonga'                                                        => 'TO',
        'trinidad and tobago'                                          => 'TT',
        'tto'                                                          => 'TT',
        'tun'                                                          => 'TN',
        'tunisia'                                                      => 'TN',
        'tur'                                                          => 'TR',
        'turkey'                                                       => 'TR',
        'turkmenistan'                                                 => 'TM',
        'turks and caicos islands'                                     => 'TC',
        'tuvalu'                                                       => 'TV',
        'twn'                                                          => 'TW',
        'uganda'                                                       => 'UG',
        'uk'                                                           => 'GB',
        'ukr'                                                          => 'UA',
        'ukraine'                                                      => 'UA',
        'united arab'                                                  => 'AE',
        'united arab emirates'                                         => 'AE',
        'united kingdom'                                               => 'GB',
        'united kingdom of great britain and n. ireland'               => 'GB',
        'united states'                                                => 'US',
        'united states minor outlying islands'                         => 'UM',
        'united states of america'                                     => 'US',
        'uruguay'                                                      => 'UY',
        'ury'                                                          => 'UY',
        'us'                                                           => 'US',
        'usa'                                                          => 'US',
        'usa minor'                                                    => 'UM',
        'usa minor outlaying islands'                                  => 'UM',
        'us minor outlying islands'                                    => 'UM',
        'ussr'                                                         => 'SU',
        'utd arab emirates'                                            => 'AE',
        'uzbekistan'                                                   => 'UZ',
        'vanuatu'                                                      => 'VU',
        'vct'                                                          => 'VC',
        'ven'                                                          => 'VE',
        'venezuela'                                                    => 'VE',
        'venezuela, bolivarian republic of'                            => 'VE',
        'viet nam'                                                     => 'VN',
        'vietnam'                                                      => 'VN',
        'virgin islands'                                               => 'VI',
        'virgin islands, british'                                      => 'VG',
        'virgin islands, u.s.'                                         => 'VI',
        'vnm'                                                          => 'VN',
        'wallis and'                                                   => 'WF',
        'wallis and futuna'                                            => 'WF',
        'wallis and futuna islands'                                    => 'WF',
        'western europe'                                               => 'EU',
        'western sahara'                                               => 'EH',
        'yemen'                                                        => 'YE',
        'yu'                                                           => 'MK',
        'yugoslavia'                                                   => 'MK',
        'zaf'                                                          => 'ZA',
        'zaire'                                                        => 'CD',
        'zambia'                                                       => 'ZM',
        'zimbabwe'                                                     => 'ZW',

        'n/a' => 'US'    ## ???

    );

    %CODE_TO_COUNTRY = (
        'AD' => 'Andorra',
        'AE' => 'United Arab Emirates',
        'AF' => 'Afghanistan',
        'AG' => 'Antigua And Barbuda',
        'AI' => 'Anguilla',
        'AL' => 'Albania',
        'AM' => 'Armenia',
        'AN' => 'Netherlands Antilles',
        'AO' => 'Angola',
        'AQ' => 'Antarctica',
        'AR' => 'Argentina',
        'AS' => 'American Samoa',
        'AT' => 'Austria',
        'AU' => 'Australia',
        'AW' => 'Aruba',
        'AX' => 'Aland Islands',
        'AZ' => 'Azerbaijan',
        'BA' => 'Bosnia And Herzegovina',
        'BB' => 'Barbados',
        'BD' => 'Bangladesh',
        'BE' => 'Belgium',
        'BF' => 'Burkina Faso',
        'BG' => 'Bulgaria',
        'BH' => 'Bahrain',
        'BI' => 'Burundi',
        'BJ' => 'Benin',
        'BL' => 'Saint Barthelemy',
        'BM' => 'Bermuda',
        'BN' => 'Brunei Darussalam',
        'BO' => 'Bolivia',
        'BQ' => 'The Caribbean Netherlands (Bonaire, Sint Eustatius and Saba)',
        'BR' => 'Brazil',
        'BS' => 'Bahamas',
        'BT' => 'Bhutan',

        #'BU' => 'Burma', Outdated, now Myanmar MM
        'BV' => 'Bouvet Island',
        'BW' => 'Botswana',
        'BY' => 'Belarus',
        'BZ' => 'Belize',
        'CA' => 'Canada',
        'CC' => 'Cocos (keeling) Islands',
        'CD' => 'Congo, The Democratic Republic Of The',
        'CF' => 'Central African Republic',
        'CG' => 'Congo',
        'CH' => 'Switzerland',
        'CI' => 'Cote D\'ivoire',
        'CK' => 'Cook Islands',
        'CL' => 'Chile',
        'CM' => 'Cameroon',
        'CN' => 'China',
        'CO' => 'Colombia',

        #'CP' => 'Clipperton Island', Uninhabited
        'CR' => 'Costa Rica',
        'CS' => 'Serbia And Montenegro',
        'CU' => 'Cuba',
        'CV' => 'Cape Verde',
        'CW' => 'Curaçao',
        'CX' => 'Christmas Island',
        'CY' => 'Cyprus',
        'CZ' => 'Czech Republic',
        'DE' => 'Germany',

        #'DG' => 'Diego Garcia', non-civilian only
        'DJ' => 'Djibouti',
        'DK' => 'Denmark',
        'DM' => 'Dominica',
        'DO' => 'Dominican Republic',
        'DZ' => 'Algeria',

        #'EA' => 'Ceuta, Melilla', contested as part of morocco
        'EC' => 'Ecuador',
        'EE' => 'Estonia',
        'EG' => 'Egypt',
        'EH' => 'Western Sahara',
        'ER' => 'Eritrea',
        'ES' => 'Spain',
        'ET' => 'Ethiopia',
        'EU' => 'European Union',
        'FI' => 'Finland',
        'FJ' => 'Fiji',
        'FK' => 'Falkland Islands (malvinas)',
        'FM' => 'Micronesia, Federated States Of',
        'FO' => 'Faroe Islands',
        'FR' => 'France',

        #'FX' => 'France, Metropolitan', translates to France
        'GA' => 'Gabon',
        'GB' => 'United Kingdom',
        'GD' => 'Grenada',
        'GE' => 'Georgia',
        'GF' => 'French Guiana',
        'GG' => 'Guernsey',
        'GH' => 'Ghana',
        'GI' => 'Gibraltar',
        'GL' => 'Greenland',
        'GM' => 'Gambia',
        'GN' => 'Guinea',
        'GP' => 'Guadeloupe',
        'GQ' => 'Equatorial Guinea',
        'GR' => 'Greece',
        'GS' => 'South Georgia And The South Sandwich Islands',
        'GT' => 'Guatemala',
        'GU' => 'Guam',
        'GW' => 'Guinea-bissau',
        'GY' => 'Guyana',
        'HK' => 'Hong Kong',
        'HM' => 'Heard Island And Mcdonald Islands',
        'HN' => 'Honduras',
        'HR' => 'Croatia',
        'HT' => 'Haiti',
        'HU' => 'Hungary',

        #'IC' => 'Canary Islands', part of spain
        'ID' => 'Indonesia',
        'IE' => 'Ireland',
        'IL' => 'Israel',
        'IM' => 'Isle Of Man',
        'IN' => 'India',
        'IO' => 'British Indian Ocean Territory',
        'IQ' => 'Iraq',
        'IR' => 'Iran, Islamic Republic Of',
        'IS' => 'Iceland',
        'IT' => 'Italy',

        #'JA' => 'Jamaica', outdated now JM
        'JE' => 'Jersey',
        'JM' => 'Jamaica',
        'JO' => 'Jordan',
        'JP' => 'Japan',
        'KE' => 'Kenya',
        'KG' => 'Kyrgyzstan',
        'KH' => 'Cambodia',
        'KI' => 'Kiribati',
        'KM' => 'Comoros',
        'KN' => 'Saint Kitts And Nevis',
        'KP' => 'Korea, Democratic People\'s Republic Of',
        'KR' => 'Korea, Republic Of',
        'KW' => 'Kuwait',
        'KY' => 'Cayman Islands',
        'KZ' => 'Kazakhstan',
        'LA' => 'Lao People\'s Democratic Republic',
        'LB' => 'Lebanon',
        'LC' => 'Saint Lucia',

        #'LF' => 'Libya Fezzan', parts of 3 different countries
        'LI' => 'Liechtenstein',
        'LK' => 'Sri Lanka',
        'LR' => 'Liberia',
        'LS' => 'Lesotho',
        'LT' => 'Lithuania',
        'LU' => 'Luxembourg',
        'LV' => 'Latvia',
        'LY' => 'Libyan Arab Jamahiriya',
        'MA' => 'Morocco',
        'MC' => 'Monaco',
        'MD' => 'Moldova',
        'ME' => 'Montenegro',
        'MF' => 'Saint Martin',
        'MG' => 'Madagascar',
        'MH' => 'Marshall Islands',
        'MK' => 'Macedonia, The Former Yugoslav Republic Of',
        'ML' => 'Mali',
        'MM' => 'Myanmar',
        'MN' => 'Mongolia',
        'MO' => 'Macao',
        'MP' => 'Northern Mariana Islands',
        'MQ' => 'Martinique',
        'MR' => 'Mauritania',
        'MS' => 'Montserrat',
        'MT' => 'Malta',
        'MU' => 'Mauritius',
        'MV' => 'Maldives',
        'MW' => 'Malawi',
        'MX' => 'Mexico',
        'MY' => 'Malaysia',
        'MZ' => 'Mozambique',
        'NA' => 'Namibia',
        'NC' => 'New Caledonia',
        'NE' => 'Niger',
        'NF' => 'Norfolk Island',
        'NG' => 'Nigeria',
        'NI' => 'Nicaragua',
        'NL' => 'Netherlands',
        'NO' => 'Norway',
        'NP' => 'Nepal',
        'NR' => 'Nauru',

        #'NT' => 'Neutral Zone', romulans only -> area between saudi arabia and iraq treated in 1922
        'NU' => 'Niue',
        'NZ' => 'New Zealand',
        'OM' => 'Oman',
        'PA' => 'Panama',
        'PE' => 'Peru',
        'PF' => 'French Polynesia',
        'PG' => 'Papua New Guinea',
        'PH' => 'Philippines',
        'PK' => 'Pakistan',
        'PL' => 'Poland',
        'PM' => 'Saint Pierre And Miquelon',
        'PN' => 'Pitcairn',
        'PR' => 'Puerto Rico',
        'PS' => 'Palestinian Territory, Occupied',
        'PT' => 'Portugal',
        'PW' => 'Palau',
        'PY' => 'Paraguay',
        'QA' => 'Qatar',
        'RE' => 'Reunion',
        'RO' => 'Romania',
        'RS' => 'Serbia',
        'RU' => 'Russian Federation',
        'RW' => 'Rwanda',
        'SA' => 'Saudi Arabia',
        'SB' => 'Solomon Islands',
        'SC' => 'Seychelles',
        'SD' => 'Sudan',
        'SE' => 'Sweden',

        #'SF' => 'Finland', now FI
        'SG' => 'Singapore',
        'SH' => 'Saint Helena',
        'SI' => 'Slovenia',
        'SJ' => 'Svalbard And Jan Mayen',
        'SK' => 'Slovakia',
        'SL' => 'Sierra Leone',
        'SM' => 'San Marino',
        'SN' => 'Senegal',
        'SO' => 'Somalia',
        'SR' => 'Suriname',
        'ST' => 'Sao Tome And Principe',

        #'SU' => 'Ussr', no longer exists
        'SV' => 'El Salvador',
        'SY' => 'Syrian Arab Republic',
        'SX' => 'Sint Maarten',
        'SZ' => 'Swaziland',

        #'TA' => 'Tristan Da Cunha', undef british protectorate
        'TC' => 'Turks And Caicos Islands',
        'TD' => 'Chad',
        'TF' => 'French Southern Territories',
        'TG' => 'Togo',
        'TH' => 'Thailand',
        'TJ' => 'Tajikistan',
        'TK' => 'Tokelau',
        'TL' => 'Timor-leste',
        'TM' => 'Turkmenistan',
        'TN' => 'Tunisia',
        'TO' => 'Tonga',

        #'TP' => 'East Timor', becoming a sovereign state
        'TR' => 'Turkey',
        'TT' => 'Trinidad And Tobago',
        'TV' => 'Tuvalu',
        'TW' => 'Taiwan, Province Of China',
        'TZ' => 'Tanzania, United Republic Of',
        'UA' => 'Ukraine',
        'UG' => 'Uganda',

        #'UK' => 'United Kingdom', this is GB not UK
        'UM' => 'United States Minor Outlying Islands',
        'US' => 'United States',
        'UY' => 'Uruguay',
        'UZ' => 'Uzbekistan',
        'VA' => 'Holy See (vatican City State)',
        'VC' => 'Saint Vincent And The Grenadines',
        'VE' => 'Venezuela',
        'VG' => 'Virgin Islands, British',
        'VI' => 'Virgin Islands, U.s.',
        'VN' => 'Viet Nam',
        'VP' => 'Corsica',
        'VU' => 'Vanuatu',
        'WF' => 'Wallis And Futuna',
        'WS' => 'Samoa',
        'XU' => 'Non US',
        'YE' => 'Yemen',
        'YT' => 'Mayotte',

        #'YU' => 'Yugoslavia', now Macedonia
        'ZA' => 'South Africa',
        'ZM' => 'Zambia',

        #'ZR' => 'Zaire', now Democratic Republic of Congo
        'ZW' => 'Zimbabwe',

        '??' => 'Unknown',    ## we try not to use this any longer...
    );

    map { $COUNTRY_TO_CODE{ lc $CODE_TO_COUNTRY{$_} } = $_ } keys %CODE_TO_COUNTRY;

    # other mappings with the same 2 letter code
    $COUNTRY_TO_CODE{'usa minor outlying islands'} = 'US';
    $COUNTRY_TO_CODE{'usa minor'}                  = 'US';
    $COUNTRY_TO_CODE{'puerto rico'}                = 'US';

    # !!! These can just be added to %COUNTRY_CODE above.
    #
    # some three code mappings
    #$CODE_TO_COUNTRY{'JAM'} = 'jamaica';
    #$CODE_TO_COUNTRY{'MDV'} = 'maldives';
    #$CODE_TO_COUNTRY{'IRN'} = 'iran, islamic republic of';
    #$CODE_TO_COUNTRY{'MMR'} = 'myanmar';
    #$CODE_TO_COUNTRY{'GRL'} = 'greenland';
    #$CODE_TO_COUNTRY{'ALA'} = 'aland islands';
    #$CODE_TO_COUNTRY{'OMN'} = 'oman';
    #$CODE_TO_COUNTRY{'MDA'} = 'moldova, republic of';
    #$CODE_TO_COUNTRY{'KEN'} = 'kenya';
    #$CODE_TO_COUNTRY{'ANT'} = 'netherlands antilles';
    #$CODE_TO_COUNTRY{'GUM'} = 'guam';
    #$CODE_TO_COUNTRY{'NAM'} = 'namibia';
    #$CODE_TO_COUNTRY{'KHM'} = 'cambodia';

    %FRENCH_MONTH_MAP = (
        'janvier'   => 1,
        'février'  => 2,
        'fevrier'   => 2,
        'mars'      => 3,
        'avril'     => 4,
        'mai'       => 5,
        'juin'      => 6,
        'juillet'   => 7,
        'août'     => 8,
        'aout'      => 8,
        'septembre' => 9,
        'octobre'   => 10,
        'novembre'  => 11,
        'décembre' => 12,
        'decembre'  => 12,
    );
}

###
1;    # Play nicely.
###
