-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: assesdb.cgzhqx8raukm.us-east-1.rds.amazonaws.com
-- Generation Time: Mar 07, 2024 at 02:30 AM
-- Server version: 5.7.44-log
-- PHP Version: 5.6.40-5+ubuntu16.04.1+deb.sury.org+1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `idealtra_assesment`
--

-- --------------------------------------------------------

--
-- Table structure for table `package_mst`
--

CREATE TABLE `package_mst` (
  `package_id` int(11) NOT NULL,
  `profileoutcome_table_id` int(4) NOT NULL DEFAULT '1',
  `package_name` varchar(255) NOT NULL,
  `package_title` varchar(255) NOT NULL,
  `package_description` text,
  `package_feature` text,
  `package_logo` varchar(255) NOT NULL,
  `package_price` varchar(50) DEFAULT NULL,
  `package_per_diem` decimal(5,2) DEFAULT NULL,
  `package_level` int(4) NOT NULL,
  `package_lowcount` int(4) NOT NULL,
  `unlimited` enum('Y','N') NOT NULL DEFAULT 'N',
  `number_of_test` varchar(50) NOT NULL,
  `number_of_users` varchar(50) DEFAULT '0',
  `package_active` enum('Y','N') NOT NULL DEFAULT 'N',
  `resumeparser_active` enum('Y','N') DEFAULT 'N',
  `user_loaction_active` enum('Y','N') DEFAULT 'N',
  `sms_active` enum('Y','N') DEFAULT 'N',
  `textsms_active` enum('Y','N') DEFAULT 'N',
  `checkr_status` enum('Y','N') DEFAULT 'N',
  `custom_stage_active` enum('Y','N') NOT NULL DEFAULT 'N',
  `rps_available` enum('1','0') DEFAULT '1',
  `package_start_date` datetime DEFAULT NULL,
  `package_exp_date` datetime DEFAULT NULL,
  `package_status` enum('Y','N') NOT NULL,
  `package_delete` enum('Y','N') NOT NULL DEFAULT 'N',
  `job_post_offer` enum('Y','N') DEFAULT 'N',
  `job_share_status` enum('Y','N') NOT NULL,
  `job_advt_status` enum('Y','N') NOT NULL,
  `emailtemplate` enum('Y','N') NOT NULL,
  `emailtemplateid` varchar(10) NOT NULL,
  `post_jobs_credits` varchar(50) DEFAULT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `fullcontact_status` enum('Y','N') DEFAULT 'N',
  `agent_req` enum('Y','N') DEFAULT 'N',
  `region_req` enum('Y','N') DEFAULT 'Y',
  `expires_in_days` int(5) DEFAULT NULL,
  `chargebee_id` varchar(250) DEFAULT NULL,
  `candidateofferpage` int(11) DEFAULT NULL,
  `email_restriction_registration` text,
  `auto_renew` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL DEFAULT 'N',
  `activate_req` enum('Y','N') DEFAULT 'N',
  `indeed_sourcename` varchar(255) DEFAULT NULL,
  `insurancejobs_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `bigijobs_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `ascts_candidatepool` enum('Y','N') NOT NULL DEFAULT 'N',
  `yext_soci` enum('Y','N') NOT NULL DEFAULT 'N',
  `unitedgreen_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `automatedworkflow_package_id` int(11) DEFAULT NULL,
  `ai_job_status` enum('Y','N') DEFAULT 'Y',
  `ai_qualifying_status` enum('Y','N') DEFAULT 'Y',
  `ai_company_status` enum('Y','N') DEFAULT 'Y',
  `no_of_location` varchar(50) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package_mst`
--

INSERT INTO `package_mst` (`package_id`, `profileoutcome_table_id`, `package_name`, `package_title`, `package_description`, `package_feature`, `package_logo`, `package_price`, `package_per_diem`, `package_level`, `package_lowcount`, `unlimited`, `number_of_test`, `number_of_users`, `package_active`, `resumeparser_active`, `user_loaction_active`, `sms_active`, `textsms_active`, `checkr_status`, `custom_stage_active`, `rps_available`, `package_start_date`, `package_exp_date`, `package_status`, `package_delete`, `job_post_offer`, `job_share_status`, `job_advt_status`, `emailtemplate`, `emailtemplateid`, `post_jobs_credits`, `date_added`, `date_modified`, `fullcontact_status`, `agent_req`, `region_req`, `expires_in_days`, `chargebee_id`, `candidateofferpage`, `email_restriction_registration`, `auto_renew`, `activate_req`, `indeed_sourcename`, `insurancejobs_status`, `bigijobs_status`, `ascts_candidatepool`, `yext_soci`, `unitedgreen_status`, `automatedworkflow_package_id`, `ai_job_status`, `ai_qualifying_status`, `ai_company_status`, `no_of_location`) VALUES
(1, 1, 'BASE', '$999 - BASE', 'This is a good entry level option for smaller agencies with low turn over.  IdealTraits makes online assessing easy. Sign up now and take the guess work out of hiring.', '', '1324906712.png', '999.00', '0.00', 137, 3, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'Y', '', '', '2011-12-26 19:08:32', '2019-10-02 08:33:02', 'Y', 'N', 'N', 0, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(2, 1, 'GOLD PACKAGE', '$699 - GOLD PACKAGE', 'Growing your agency? The Gold Package is a great value to build your candidate bank of potential hires. Start today and match the best candidate to the right job.', NULL, '1324907162.png', '699.00', NULL, 136, 5, 'N', '20', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2011-12-26 19:16:02', '2014-04-14 09:22:09', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(3, 1, 'PLATINUM', '$999 - PLATINUM', 'At only $49.95 per assessment, Platinum is the best value for large or multi-location agencies. Avoid costly hiring mistakes and boost agency productivity today.', '', '1324907223.png', '999.00', '0.00', 135, 10, 'N', '20', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'Y', '', 'UNLIMITED', '2011-12-26 19:17:03', '2018-03-25 15:03:38', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(8, 1, 'Free Trial - Allstat Only', '10 Day Allstate FREE', 'Free trial to jump start your hiring efforts.  Start today and give to your current employees so you can see really understand the value of knowing what kind of employee you want to model after.', NULL, '1331045903.', '0.00', NULL, 134, 100, 'N', '5', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-03-06 09:58:23', '2012-05-09 07:27:17', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(9, 1, 'Bronze', 'Bronze', 'jfpsj', NULL, '1331657875.', '189.00', NULL, 133, 0, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-03-13 12:57:55', '2012-03-13 12:57:55', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(10, 1, 'Another Free Trial', 'Another FREE Trial', 'This is a free trial that we would have people sign up for.', NULL, '1333418662.', '100', NULL, 132, 50, 'N', '2', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-04-02 22:04:22', '2012-05-09 07:26:56', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(11, 1, 'Professional', 'Professional', 'Pay 6 month once enjoy our service', NULL, '1334645497.gif', '896', NULL, 131, 0, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-04-17 02:51:37', '2012-04-17 02:51:37', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(12, 1, 'Enterprisers', 'Enterprises123', '6 month pack available', NULL, '1334645780.png', '189', NULL, 130, 0, 'N', '12', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-04-17 02:56:20', '2012-04-17 02:57:14', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(13, 1, 'Testing123', 'Testing123', 'testing package', NULL, '1334657806.jpg', '560', NULL, 129, 20, 'N', '5', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-04-17 06:16:46', '2012-05-16 11:20:36', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(14, 1, 'test', 'test', 'testing ', NULL, '1336401471.', '150', NULL, 128, 50, 'N', '1500', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', '', '', NULL, '2012-05-07 10:37:51', '2012-08-09 01:39:15', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(15, 1, 'Free Pack', 'Free Pack', 'Free Pack', NULL, '1336562749.', '0', NULL, 127, 5, 'N', '5', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-05-09 07:25:49', '2012-05-16 11:21:22', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(16, 1, 'Buy Additional Tests', 'Additional Tests', 'Buy tests', NULL, '1342183952.', '200', NULL, 126, 10, 'N', '100', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-13 08:52:32', '2012-07-27 16:06:07', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(17, 1, 'new Pack', 'New package', 'Testing', NULL, '1342515434.', '200', NULL, 125, 50, 'Y', '500', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-17 04:57:14', '2012-07-17 06:04:05', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(18, 1, 'Test added', 'test', 'testing account', NULL, '1342520860.', '100', NULL, 124, 25, 'N', '25', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-17 06:27:40', '2012-07-17 08:33:14', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(19, 1, 'test\\\'s\\\'s\\\'\\\'\\\'', 'test\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'', 'fgdfg\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'\\\'gdfgdfgdfgdfgdfgdfgdgdfgdfgdfgdfgdfgdfgdfgdfgdfgdfgdfgdfg', NULL, '1342534568.', '1500', NULL, 123, 100, 'Y', '150', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-17 10:16:08', '2012-07-27 02:47:43', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(20, 1, 'Alimni', 'Alumni\\\'s part1', 'testing package\\\'s\\\'\\\'\\\'s', NULL, '1343379713.', '500', NULL, 122, 500, 'Y', '100', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 05:01:54', '2012-07-27 05:04:08', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(21, 1, 'test1', 'test2', 'test\\\'3\\\'\\\'\\\'\\\'s', NULL, '1343379896.', '500', NULL, 121, 500, 'Y', '500', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 05:04:56', '2012-07-27 05:05:28', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(22, 1, 'test3', 'test3', 'test3', NULL, '1343380044.', '50', NULL, 120, 500, 'N', '500', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 05:07:24', '2012-07-27 05:07:24', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(23, 1, 'aviva\\\'s', 'test\\\'s aviva\\\'s', 'package description\\\'s', NULL, '1343380292.', '500', NULL, 119, 16, 'N', '100', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 05:11:32', '2012-07-27 05:12:32', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(24, 1, 'mengento', 'mento back', 'description part ', NULL, '1343380614.', '150', NULL, 118, 56, 'N', '90', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 05:16:54', '2012-07-27 06:09:23', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(25, 1, 'Premium', 'premium', 'testing package', NULL, '1343393578.jpg', '1000', NULL, 117, 50, 'N', '500', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 07:06:27', '2012-07-27 09:29:29', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(26, 1, 'Gold Primeum', 'Gold Primeum', 'This \\\'s a test package contains unlimited test\\\'s', NULL, '1343396215.', '500', NULL, 116, 25, 'N', '200', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-27 09:36:55', '2012-07-27 16:05:50', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(27, 1, 'testing\\\'s', 'testing\\\'s', 'This is a good entry level option for smaller agencies with low turn over. IdealTraits makes online assessing easy. Sign up now and take the guess work out of hiring.testing\\\'s', NULL, '1343452759.', '500', NULL, 115, 200, 'Y', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-28 01:19:19', '2012-07-28 01:19:19', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(28, 1, 'Testing\\\'s', 'testing\\\'s', 'testing packs', NULL, '1343458060.', '500', NULL, 114, 250, 'Y', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-28 02:47:40', '2012-07-28 02:48:17', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(29, 1, 'silverpackage', 'Silver package', 'descriptive', NULL, '1343627452.', '500', NULL, 113, 500, 'Y', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-07-30 01:50:52', '2012-08-08 09:30:17', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(31, 1, 'GOLD PLUS + PACKAGE', '$999 - GOLD PLUS + PACKAGE ', '', NULL, '1344525580.', '999', NULL, 112, 5, 'N', '17', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-08-09 11:19:40', '2013-05-21 06:30:31', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(30, 1, 'BASE PLUS + PACKAGE', '$399 - BASE PLUS + PACKAGE', '', NULL, '1344525319.', '399', NULL, 111, 2, 'N', '5', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-08-09 11:15:19', '2013-05-21 06:31:09', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(32, 1, 'PLATINUM PLUS + PACKAGE', '$1799 - PLATINUM PLUS + PACKAGE', '', NULL, '1344526267.', '1799', NULL, 110, 10, 'N', '40', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-08-09 11:31:07', '2013-05-21 06:30:15', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(0, 1, 'ADD 10 CREDITS - $399', 'ADD 10 CREDITS - $399', '', NULL, '1344528679.', '399', NULL, 107, 3, 'N', '10', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-08-09 12:11:19', '2012-08-09 12:11:56', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(34, 1, 'ADD 30 CREDITS - $999', 'ADD 30 CREDITS - $999', '', NULL, '1344531712.', '999', NULL, 106, 5, 'N', '30', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-08-09 13:01:52', '2012-08-09 13:01:52', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(35, 1, 'ADD 60 CREDITS - $399', 'ADD 60 CREDITS - $399', '', NULL, '1344531748.', '1799', NULL, 105, 10, 'N', '60', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-08-09 13:02:28', '2012-08-09 13:02:28', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(36, 1, 'test', 'testing', 'this is a test package', NULL, '1344560399.', '1', NULL, 104, 1, 'N', '1', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-08-09 20:59:59', '2012-09-04 14:47:09', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(37, 1, 'BASE PACKAGE', '$399 - BASE PACKAGE', 'updated', NULL, '1344971063.', '0', NULL, 103, 3, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-08-14 15:04:23', '2012-09-05 06:17:04', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(38, 1, 'Free Pack', 'Free Pack', 'test', NULL, '1345179476.', '0', NULL, 102, 5, 'N', '50', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-08-17 00:57:56', '2012-09-04 14:46:58', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(39, 1, 'BASE PACKAGE - GPS', 'BASE PACKAGE - GPS', '', NULL, '1346851696.', '1', NULL, 101, 0, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-09-05 09:28:17', '2013-05-21 06:29:55', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(40, 1, 'FREE TRIAL OFFER', 'FREE TRIAL OFFER', '', NULL, '1346954771.', '0', NULL, 100, 1, 'N', '3', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-09-06 14:06:11', '2013-07-18 10:32:00', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(41, 1, 'Test Accounts', 'Test Accounts', '', NULL, '1348838261.', '0', NULL, 99, 0, 'N', '5', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-09-28 09:17:41', '2012-09-28 09:17:41', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(42, 1, 'Test Accounts', 'Test Accounts', '', NULL, '1348838280.', '0', NULL, 98, 0, 'N', '5', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-09-28 09:18:00', '2012-09-28 09:18:00', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(43, 1, 'Test Accounts', 'Test Accounts', '', NULL, '1348838310.', '0', NULL, 97, 0, 'N', '5', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-09-28 09:18:30', '2013-07-22 05:10:55', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(44, 1, 'NCRO - Special', 'NCRO - Special', 'NCRO - Special is a special package.', NULL, '1350309885.', '0', NULL, 96, 1, 'N', '3', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-10-15 10:04:45', '2013-05-21 06:29:10', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(45, 1, 'Cyber Monday Special BASE - 15 for $399', 'Cyber Monday Special BASE - 15 for $399', 'Cyber Monday Special 1 Day ONLY', NULL, '1353902481.', '399', NULL, 95, 5, 'N', '15', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-11-25 23:01:21', '2013-05-21 06:28:55', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(46, 1, 'Cyber Monday Special GOLD - 30 for $699', 'Cyber Monday Special GOLD - 30 for $699', 'Cyber Monday Special GOLD 1 Day ONLY', NULL, '1353903471.', '699', NULL, 94, 7, 'N', '30', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-11-25 23:17:51', '2013-05-21 06:28:43', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(47, 1, 'Lasic Store', 'Lasic Store', 'Lasic Store', NULL, '1354673363.', '1000', NULL, 93, 20, 'N', '100', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2012-12-04 21:09:23', '2012-12-04 21:09:23', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(48, 1, 'Gold Upgrade 20 + 5 free', 'Gold Package - Get 5 Free', 'Gold Package - Get 5 Free', NULL, '1356639384.', '699', NULL, 92, 10, 'N', '25', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-12-27 15:16:24', '2013-10-21 08:55:22', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(49, 1, 'Platinum Upgrade 35 + 10 free', 'Platinum Package - Get 10 Free', 'Platinum Package - Get 10 Free', NULL, '1356639518.', '999', NULL, 91, 10, 'N', '45', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2012-12-27 15:18:38', '2013-05-21 06:27:57', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(50, 3, 'Post Jobs SDI Testing', 'Post Jobs SDI Testing', NULL, NULL, '1364469575.', '1.00', '1.00', 90, 1, 'N', '10', '0', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', '1', '2019-12-01 00:00:00', NULL, 'N', 'N', 'N', 'Y', 'Y', 'N', '171', '3', '2013-03-28 07:19:35', '2024-02-16 00:39:26', 'Y', 'N', 'N', 30, '0', NULL, NULL, 'N', 'Y', 'test_indeed_sourcename', 'N', 'N', 'N', 'N', 'N', 1, 'Y', 'Y', 'Y', '0'),
(51, 1, 'Danelle', 'Danelle', 'test', NULL, '1369142965.', '0', NULL, 89, 1, 'N', '40', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2013-05-21 09:29:25', '2013-05-21 09:34:00', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(52, 1, 'Base Leaders', 'Base Leaders', 'Base plan free share from Leaders Forum 2013', NULL, '1370873273.', '499.00', NULL, 88, 2, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2013-06-10 10:07:53', '2013-06-14 09:30:43', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(53, 1, 'GOLD', '$1499 - GOLD', 'Gold Package', NULL, '1370873360.', '1499.00', NULL, 87, 2, 'N', '20', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'Y', '', '1', '2013-06-10 10:09:20', '2017-03-15 12:03:55', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(54, 1, 'TestNEWSignUP', 'TestNEWSignUP', '', NULL, '1380573959.', '0.00', NULL, 86, 2, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '33', NULL, '2013-09-30 16:45:59', '2013-10-25 18:00:55', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(55, 1, '2014 Marketing Package - Immediate Access $125', '2014 Marketing Package - Immediate Access $125', 'This package is designed for agents that want to take advantage of the IMMEDIATE ACCESS for only $125.  Agents will need to prove that they selected IdealTraits in their 2014 Marketing Package by sending a confirmation email.', NULL, '1380915490.', '125.00', NULL, 85, 1, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '32', NULL, '2013-10-04 15:38:10', '2013-10-25 17:57:41', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(56, 1, '2014 Marketing Package - Start Date Jan. 1 2014', '2014 Marketing Package - Start Date Jan. 1 2014', 'This package is designed for agents that want to take advantage of the 2014 Marketing Package that starts January 1, 2014. ', NULL, '1381783040.', '0.00', NULL, 84, 1, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '31', NULL, '2013-10-14 16:37:20', '2013-10-25 17:55:10', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(57, 1, 'newtestpack', '20', 'developer testing', NULL, '1382338519.', '100.00', NULL, 83, 2, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'N', '30', NULL, '2013-10-21 02:55:19', '2015-01-14 13:26:51', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(58, 1, '2014 Marketing Package - Immediate Access $100', '2014 Marketing Package - Immediate Access $100', '2014 Marketing Package - Immediate Access $1001', NULL, '1385488290.', '100.00', NULL, 82, 0, 'Y', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '34', NULL, '2013-11-26 12:51:30', '2013-11-26 12:56:16', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(59, 1, '2014 Marketing Package1 - Immediate Access $100', '2014 Marketing Package - Immediate Access $100', '2014 Marketing Package - Immediate Access $100', NULL, '1385488335.', '100.00', NULL, 81, 0, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '35', NULL, '2013-11-26 12:52:15', '2015-01-07 16:45:56', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(60, 1, '2014 Marketing Package - Immediate Access $75', '2014 Marketing Package - Immediate Access $75', '2014 Marketing Package - Immediate Access $75', NULL, '1386004327.', '75.00', NULL, 80, 0, 'Y', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '2015-01-03 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '36', NULL, '2013-12-02 12:12:07', '2015-01-04 10:49:55', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(61, 1, 'SW NAP', 'SW NAP', 'Southwest Region - New Agent Program will include a similar Platinum package with UNLIMITED assessing. IdealTraits will bill the region on a monthly basis for new enrollees.', NULL, '1388786249.', '0.00', NULL, 79, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '37', NULL, '2014-01-03 16:57:29', '2015-01-22 18:54:35', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(62, 1, '2014 New Agent Marketing Package', '2014 New Agent Marketing Package', '2014 New Agent Marketing Package- Unlimited Assessing and Job Postings; Expires December 31, 2014.', NULL, '1389305963.', '0.00', NULL, 78, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '38', NULL, '2014-01-09 17:19:23', '2014-02-04 12:16:59', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(63, 1, 'Ideal- 2014 Agent Unlimited', 'Ideal- 2014 Agent Unlimited', 'Annual $1040/20 weekly prorated.  expires December 2014.', NULL, '1389364333.', '1.00', NULL, 77, 1, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '39', NULL, '2014-01-10 09:32:13', '2015-01-14 13:25:40', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(64, 1, 'NAOE Offer', 'NAOE Offer', 'New agents signing up in Chicago for $100.  NAOE enrollment required within 8 weeks.  If no Blueprint enrollment comes from Allstate agent can purchase Allstate Unlimited or the account will transfer to a Base plan with zero credits.', '', '1392662757.', '100.00', '0.00', 9109, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', NULL, 'N', 'N', 'Y', 'Y', 'Y', 'Y', '', '', '2014-02-17 13:45:57', '2018-04-30 12:54:46', 'Y', 'Y', 'Y', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(65, 1, 'BASE - SAMM Consulting', 'BASE - SAMM Consulting', 'BASE - SAMM Consulting', NULL, '1395912354.', '525.00', NULL, 76, 2, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2014-03-27 05:25:54', '2015-01-14 13:24:43', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(66, 1, 'GOLD - SAMM Consulting', 'GOLD - SAMM Consulting', 'GOLD - SAMM Consulting', NULL, '1395912476.', '699.00', NULL, 75, 5, 'N', '23', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-03-27 05:27:56', '2014-03-27 10:31:06', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(67, 1, 'PLATINUM - SAMM Consulting', 'PLATINUM - SAMM Consulting', 'PLATINUM - SAMM Consulting', NULL, '1395912577.', '999.00', NULL, 74, 10, 'N', '46', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-03-27 05:29:37', '2014-03-27 10:30:38', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(68, 1, 'Texas Leaders Forum', 'Texas Leaders Forum', 'Unlimited assessments until January 1 2015. This package is designed to work in conjunction with the 2015 marketing package. IT IS A REQUIREMENT TO SIGN UP FOR THE 2015 MARKETING PACKAGE otherwise the client will be charges $500 and used assessments will be subtracted from 40.', NULL, '1403814154.', '525.00', NULL, 73, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '2015-01-04 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '40', NULL, '2014-06-26 16:22:34', '2015-01-04 10:52:02', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(69, 1, 'Webinar Special', 'Webinar Special', 'Unlimited thru December 31st 2014', NULL, '1405619212.', '500.00', NULL, 72, 1, 'N', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-07-17 13:46:52', '2015-01-14 13:27:52', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(70, 1, 'Unlimited Use Until Dec 31st 2014 ', 'Unlimited Use Until Dec 31st 2014 ', 'Start Early - 2015 Agency Marketing Blueprint - To qualify users must sign up for the 2015 Allstate Marketing Blueprint  $400 in September. $300 October. $125 during open enrollment. ', NULL, '1410138965.', '75.00', NULL, 71, 10, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '2015-01-04 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '41', NULL, '2014-09-07 21:16:05', '2015-01-22 13:21:09', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(71, 1, 'TestPackage', 'TestPackage', 'TestPackage', NULL, '1411123279.', '10.00', NULL, 70, 1234, 'N', '100000', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-09-19 06:41:19', '2015-01-14 13:24:17', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(72, 1, 'test', 'test', 'test', NULL, '1411190101.', '400.00', NULL, 69, 1567, 'Y', '34566', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-09-20 01:15:01', '2015-01-14 13:24:11', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(73, 1, 'test_users*do not use*DO NOT DELETE', 'test_users*do not use*DO NOT DELETE', 'test_users*do not use*', '', '1412260421.', '2000.00', '0.00', 68, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'Y', '', 'UNLIMITED', '2014-10-02 10:33:41', '2020-07-09 09:16:22', 'Y', 'Y', 'N', 0, '0', 0, '', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(74, 1, '$125 Early Access', '$125 Early Access', '$125 early blueprint start offer starts 10.10.2014', NULL, '1412973325.', '125.00', NULL, 67, 100, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '0000-00-00 00:00:00', '2015-01-04 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-10-10 16:35:25', '2015-01-14 13:25:07', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(75, 1, 'LATE ACTIVATED EXTEND TO MAR 2015', 'LATE ACTIVATED EXTEND TO MAR 2015', 'LATE ACTIVATED EXTEND TO MAR 2015', NULL, '1414490353.', '0.00', NULL, 66, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '2015-01-01 00:00:00', '2015-03-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-10-28 05:59:13', '2015-01-14 13:23:58', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(76, 1, 'Midwest Free Trial - 5 Free Assessments', 'Midwest Free Trial - 5 Free Assessments', 'Midwest Free Trial - 5 Free Assessments. FOR MIDWEST AGENTS ONLY. ** Must use the 5 free assessments by Dec 31 2014', NULL, '1417447398.', '0.00', NULL, 65, 1, 'N', '5', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2015-01-04 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '45', NULL, '2014-12-01 10:23:18', '2015-01-14 13:23:51', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(77, 1, 'NY - LSP Trial', 'NY - LSP Trial', 'Agreement with the NY region to provide an assessments for new LSP prospects for those who do not have an assessment tool. Ideal traits will require agents to complete a full registration and have the agent send out the link to each candidate. After the sign up and they will receive 1 complimentary assessment.', NULL, '1418231339.', '0.00', NULL, 5003, 10, 'N', '1', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'N', 'N', 'N', '68', NULL, '2014-12-10 12:08:59', '2016-01-05 12:24:03', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(78, 1, 'Transfer_Keep', 'Transfer_Keep', 'Allstate sent file to transfer from one agent to another', '', '1419439274.', '0.00', '0.00', 2015, 2, 'N', '0', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2018-01-01 00:00:00', 'N', 'N', 'Y', 'N', 'N', 'Y', '', '0', '2014-12-24 11:41:14', '2018-11-15 11:52:45', 'N', 'Y', 'Y', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(79, 1, '2015 ALLSTATE UNLIMITED', '2015 ALLSTATE UNLIMITED', 'Jan 1st package price starts $1040. Will decrease weekly by $20 thru December 31st. If agent picks up in Blueprint during the year we will refund the difference of unused amount after file is received from Allstate.', NULL, '1419439637.', '200.00', NULL, 64, 2, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', '2015-01-01 00:00:00', '2015-12-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2014-12-24 11:47:17', '2015-10-05 10:44:33', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(83, 1, 'Farmers DM Monthly Plan', 'Farmers DM Monthly Plan', 'Farmers DM Monthly Unlimited Account - $499 Down and $199 / month.', NULL, '1424891361.', '199.00', '0.00', 8002, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '112', NULL, '2015-02-25 14:09:21', '2024-02-02 08:13:52', 'Y', 'N', 'N', NULL, 'Farmers-DM-Monthly-Plan', NULL, NULL, 'N', 'N', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(80, 1, 'LATE ACTIVATED EXTEND TO MAR 2015', 'LATE ACTIVATED EXTEND TO MAR 2015', 'LATE ACTIVATED EXTEND TO MAR 2015', NULL, '1420582419.', '0.00', NULL, 63, 1, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '51', NULL, '2015-01-06 17:13:39', '2015-01-06 17:13:39', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(81, 1, 'BLUEPRINT HOLD', 'BLUEPRINT HOLD', 'Blueprint Holding', NULL, '1421253580.', '0.00', '2.60', 1150, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '', 'UNLIMITED', '2015-01-14 11:39:40', '2024-02-20 08:35:43', 'Y', 'Y', 'Y', NULL, '0', NULL, NULL, 'N', 'N', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(82, 1, 'NOT_ACTIVE', 'Non Active', 'Non Active', '', '1421260759.', '0.00', '0.00', 62, 1, 'N', '0', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2018-03-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'N', 'N', '53', '', '2015-01-14 13:39:19', '2019-11-27 10:30:36', 'Y', 'Y', 'N', 0, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(84, 1, 'Allstate Veterans Program', 'Allstate Veterans Program', '', NULL, '1425327961.', '999999.00', NULL, 61, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2015-03-02 15:26:01', '2015-03-02 15:26:54', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(85, 1, 'North Central RPS Pilot', 'North Central RPS Pilot', 'North Central RPS Pilot / EA Card Accepted', NULL, '1426177370.', '500.00', NULL, 59, 1, 'Y', 'UNLIMITED', '0', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2016-12-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '97', '', '2015-03-12 12:22:50', '2016-04-14 12:52:23', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(110, 1, 'New Agent Fast Start', 'New Agent Fast Start', 'New Agents for North Central and Florida regions', NULL, '1465244054.', '50.00', '0.00', 58, 1, 'Y', 'UNLIMITED', '0', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '101', '', '2016-06-06 16:14:14', '2017-10-05 10:14:41', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(86, 1, 'IdealTraits 3 Assessment Promo', 'IdealTraits 3 Assessment Promo', '', NULL, '1426601110.', '0.00', NULL, 57, 2, 'N', '3', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'N', 'Y', 'Y', '', NULL, '2015-03-17 10:05:10', '2015-03-17 10:05:10', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(87, 1, 'Farmers Monthly', 'Farmers Monthly', 'Monthly access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1427312596.', '99.00', '0.00', 8001, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '111', NULL, '2015-03-25 15:43:16', '2024-02-02 08:13:43', 'Y', 'N', 'N', 40, 'Monthly-99', NULL, NULL, 'N', 'N', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(88, 1, 'Farmers Unlimited 12 month PIF', 'Farmers Unlimited 12 month PIF', '12 Month Pay In Full $1089', NULL, '1431527504.', '1089.00', NULL, 8000, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '110', '', '2015-05-13 10:31:44', '2017-01-12 15:17:11', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(89, 1, 'test_may_2015', 'test_may_2015', 'test_may_2015', NULL, '1431579950.', '50.00', NULL, 55, 12, 'N', '50', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', '2015-05-14 00:00:00', NULL, 'N', 'Y', 'Y', 'N', 'N', 'Y', '', NULL, '2015-05-14 01:05:50', '2015-05-14 01:05:50', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(90, 1, 'test_may1_2015', 'test_may1_2015', '', NULL, '1431587100.', '2388.00', NULL, 54, 10, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2015-05-14 03:05:00', '2015-05-14 03:05:00', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(91, 1, 'TEST Blueprint Parser - DO NOT USE', 'TEST Blueprint Parser - DO NOT USE', 'This is a test package to test the transition to resume parsing for Blueprint', NULL, '1431599338.', '0.00', NULL, 53, 2, 'Y', 'UNLIMITED', '0', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', '1', '2014-12-27 00:00:00', '2015-12-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '2015-05-14 06:28:58', '2017-01-06 10:02:49', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(92, 1, 'test_may2_2015', 'test_may2_2015', '', NULL, '1431601121.', '10.00', NULL, 52, 10, 'N', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', NULL, '2015-05-14 06:58:41', '2015-05-14 06:58:41', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(93, 1, 'DAMM - ANNUAL $999.00 UNLIMITED', 'DAMM Annual', '$999.00', NULL, '1441163379.', '999.00', NULL, 51, 1, 'Y', 'UNLIMITED', '0', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', '0', '2015-09-01 00:00:00', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '61', NULL, '2015-09-01 23:09:39', '2015-12-03 12:04:59', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(94, 1, 'DAMM - MONTHLY $399.00 Down and $89 Monthly UNLIMITED', 'DAMM Monthly', '$399.00 Down and $89 Monthly', NULL, '1441163509.', '399.00', NULL, 50, 1, 'Y', 'UNLIMITED', '0', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', '0', '2015-09-01 00:00:00', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '62', NULL, '2015-09-01 23:11:49', '2015-12-03 12:04:48', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(95, 1, 'Merge', 'Merge', 'Accounts that are duplicated that need to be merged.', NULL, '1444318794.', '0.00', NULL, 1010, 0, 'N', '0', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'N', 'N', 'Y', '', NULL, '2015-10-08 11:39:54', '2015-10-08 11:42:44', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(96, 1, 'Farmers Pilot', 'Farmers Pilot', 'For only $98, you will have UNLIMITED assessments and full access to IdealTraits for 8 weeks', NULL, '1444764594.', '98.00', NULL, 49, 1, 'Y', 'UNLIMITED', '0', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '69', NULL, '2015-10-13 15:29:54', '2015-12-03 12:04:35', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(189, 1, 'Liberty Mutual/Safeco Quarterly', 'Liberty Mutual/Safeco Quarterly', 'Liberty Mutual/Safeco Quarterly', NULL, '', '449.00', '0.00', 48, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '195', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:46:17', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(187, 3, 'Great Clips Quarterly', 'Great Clips Quarterly', 'Great Clips Quarterly', NULL, '', '899.00', NULL, 47, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '193', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:44:54', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(98, 1, 'test1', 'test1', 'test1', NULL, '1449054214.', '999.00', NULL, 46, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2016-12-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', 'UNLIMITED', '2015-12-02 06:03:34', '2016-12-22 07:59:08', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(99, 1, 'ALLSTATE UNLIMITED', 'ALLSTATE UNLIMITED', 'ALLSTATE UNLIMITED - $780 EA ANNUAL', '', '1449684619.', '800.00', '0.00', 9003, 1, 'Y', 'UNLIMITED', '0', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '75', '', '2015-12-09 13:10:19', '2019-07-31 02:40:54', 'Y', 'Y', 'N', 0, '', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(103, 1, 'SILVER', 'SILVER', 'SILVER - 10 Pack $599', NULL, '1452804094.', '599.00', NULL, 9011, 1, 'Y', '10', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '90', '1', '2016-01-14 15:41:34', '2017-05-25 09:06:40', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(100, 1, 'Farmers Insurance UNLIMITED', 'Matt Cheever Affiliaite', 'Affiliate program for Matt Cheever', NULL, '1449851945.', '999.00', NULL, 9002, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '78', '', '2015-12-11 11:39:05', '2016-10-07 14:32:13', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(101, 1, 'STARTER PKG', 'STARTER PKG', 'STARTER PKG - $299 / 3 ASSESSMENTS', '', '1452552472.', '299.00', '0.00', 1000, 1, 'N', '3', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '87', '0', '2016-01-11 17:47:52', '2018-03-05 16:46:44', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(102, 1, 'Ideal Unlimited', 'Ideal Unlimited', 'IDEAL UNLIMITED $499 down / $199 monthly', NULL, '1452803766.', '300.00', '0.00', 9999, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'N', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '89', '5', '2016-01-14 15:36:06', '2024-02-20 08:35:22', 'Y', 'N', 'N', 40, 'ideal-unlimited-monthly', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(104, 1, 'Post job credits', 'Post job credits', 'Post job credits', NULL, '1453452696.', '123.00', NULL, 45, 12, 'Y', '', '0', 'N', 'Y', 'Y', 'N', 'N', 'N', 'N', '1', NULL, '2016-12-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', '1', '2016-01-22 03:51:36', '2016-09-20 07:08:51', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(105, 1, 'RPS Pilot', 'RPS Pilot', '', NULL, '1454763668.', '15000.00', NULL, 44, 10, 'N', 'UNLIMITED', '0', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'Y', '', 'unlimited', '2016-02-06 08:01:08', '2016-02-06 08:02:20', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(106, 1, 'Ranahan Consulting Monthly Plan', 'Ranahan Consulting Monthly Plan', 'Special monthly pricing plan for \"Ranahan Consulting\" members.', NULL, '1456431994.', '159.00', '0.00', 9100, 1, 'Y', 'UNLIMITED', '1', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '93', NULL, '2016-02-25 15:26:34', '2024-02-02 08:46:50', 'Y', 'N', 'N', 40, 'Ranahan-Consulting-Monthly-Plan', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(107, 1, 'Insurance Demo', 'Insurance Demo', 'Insurance Demo accounts', NULL, '1457971955.', '0.00', '0.00', 108, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '94', NULL, '2016-03-14 12:12:35', '2024-02-02 08:13:29', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(108, 1, 'Allstate Monthly', 'Allstate Monthly', 'Monthly access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', '', '1458135165.', '89.00', '0.00', 9005, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '95', '', '2016-03-16 09:32:45', '2019-01-04 13:56:03', 'Y', 'Y', 'Y', 0, 'Monthly-89', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(109, 1, 'New PIF', 'New PIF', 'Allstate agents that are new to IdealTraits pay in full', NULL, '1458135251.', '780.00', NULL, 43, 1, 'Y', 'UNLIMITED', '0', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '96', '', '2016-03-16 09:34:11', '2016-10-07 14:32:37', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(111, 1, 'Free Look Offer', 'Free Look Offer', 'Free Look Offer', NULL, '1475718535.', '0.00', NULL, 42, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2016-11-11 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '103', 'UNLIMITED', '2016-10-05 21:48:55', '2016-10-06 10:21:08', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(112, 1, '2017 BLUEPRINT - START EARLY', '2017 BLUEPRINT - START EARLY', '2017 ALLSTATE MARKETING BLUEPRINT', NULL, '1475778656.', '0.00', NULL, 41, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2017-12-31 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '104', 'UNLIMITED', '2016-10-06 14:30:56', '2016-10-26 16:13:36', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(113, 1, 'Dev Demo', 'Dev Demo', 'This is a demo account for Development only', '', '1479466062.', '8000.00', '0.00', 109, 1, 'Y', '', '0', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', '1', NULL, '2018-03-21 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'Y', '', '', '2016-11-18 05:47:42', '2018-03-24 08:32:43', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(114, 1, 'Allstate BP Enroll', 'Allstate BP Enroll', 'Temp package to allow blueprint hold enrollment for existing customers', '', '1481920894.png', '999.00', '0.00', 9955, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '105', 'UNLIMITED', '2016-12-16 15:41:34', '2020-07-30 11:47:49', 'Y', 'N', 'N', 0, '', 0, '', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(115, 1, 'Travelers', 'Travelers', 'Travelers', NULL, '1482249207.', '2688.00', NULL, 9050, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '106', 'UNLIMITED', '2016-12-20 10:53:27', '2017-03-14 16:17:27', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0');
INSERT INTO `package_mst` (`package_id`, `profileoutcome_table_id`, `package_name`, `package_title`, `package_description`, `package_feature`, `package_logo`, `package_price`, `package_per_diem`, `package_level`, `package_lowcount`, `unlimited`, `number_of_test`, `number_of_users`, `package_active`, `resumeparser_active`, `user_loaction_active`, `sms_active`, `textsms_active`, `checkr_status`, `custom_stage_active`, `rps_available`, `package_start_date`, `package_exp_date`, `package_status`, `package_delete`, `job_post_offer`, `job_share_status`, `job_advt_status`, `emailtemplate`, `emailtemplateid`, `post_jobs_credits`, `date_added`, `date_modified`, `fullcontact_status`, `agent_req`, `region_req`, `expires_in_days`, `chargebee_id`, `candidateofferpage`, `email_restriction_registration`, `auto_renew`, `activate_req`, `indeed_sourcename`, `insurancejobs_status`, `bigijobs_status`, `ascts_candidatepool`, `yext_soci`, `unitedgreen_status`, `automatedworkflow_package_id`, `ai_job_status`, `ai_qualifying_status`, `ai_company_status`, `no_of_location`) VALUES
(117, 1, '2017 Blueprint1', '2017 Blueprint1', '2017 Blueprint1', NULL, '1482851787.', '798.00', NULL, 40, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '108', 'UNLIMITED', '2016-12-27 10:16:27', '2016-12-27 19:15:02', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(118, 1, '2017 Blueprint', '2017 Blueprint', '2017 Blueprint', '', '1482884238.', '798.00', '0.00', 9062, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2018-01-31 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '109', 'UNLIMITED', '2016-12-27 19:17:18', '2018-06-11 08:56:19', 'Y', 'Y', 'Y', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(119, 1, 'HOLD', 'HOLD', 'TODD HOLD ACCOUNT', NULL, '1483981360.', '999.00', NULL, 39, 1, 'N', '0', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'N', 'N', 'N', '113', '0', '2017-01-09 12:02:40', '2017-01-09 12:02:40', 'Y', 'Y', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(121, 1, 'IdealRecruit', 'IdealRecruit', 'IdealRecruit Test System', '', '1487087573.', '2495.00', '0.00', 9051, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '115', 'UNLIMITED', '2017-02-14 10:52:53', '2018-01-31 10:26:39', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(122, 1, 'Allstate NP', 'Allstate NP', 'Allstate NP', NULL, '1489592599.', '0.00', NULL, 38, 0, 'N', '0', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'N', 'N', 'N', '116', '0', '2017-03-15 11:43:19', '2017-03-15 11:43:19', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(123, 1, 'Travelers TLC Special Offer', 'Travelers TLC Special Offer', 'Travelers TLC Special Offer', NULL, '1490883472.', '1344.00', NULL, 9106, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '118', 'UNLIMITED', '2017-03-30 10:17:52', '2017-03-30 10:19:41', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(124, 1, 'cxvxcv', 'vcxvcxvcxv', 'vcxvcvxcvcxv', NULL, '1490894042.', '99.00', NULL, 37, 20, 'N', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'N', 'N', 'Y', '', '', '2017-03-30 13:14:02', '2017-03-30 13:14:02', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(125, 1, 'testerror', 'testerror', 'testerror', NULL, '1491199684.', '99.00', NULL, 36, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '119', 'UNLIMITED', '2017-04-03 02:08:04', '2017-04-03 02:08:04', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(126, 1, 'NAOE Hold', 'NAOE Hold', 'NAOE agents are moved to this package on Agency Start Date.', NULL, '1494528604.', '999.00', NULL, 35, 1, 'N', '0', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2017-01-01 00:00:00', 'N', 'Y', 'Y', 'N', 'N', 'N', '120', '0', '2017-05-11 14:50:04', '2017-05-11 14:50:04', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(127, 3, 'Generic Demo', 'General Demo', 'This package has generalized outcomes for businesses that are not related to insurance.', NULL, '1496261556.', '1999.00', '0.00', 1007, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '123', 'UNLIMITED', '2017-05-31 16:12:36', '2024-02-20 08:36:15', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(128, 1, 'test Package June 2017', 'test Package June 2017', 'test Package June 2017', NULL, '1496313604.', '45.00', NULL, 34, 45, 'Y', '45', '0', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '124', '45', '2017-06-01 06:40:04', '2017-08-18 12:22:43', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(129, 1, 'test June package', 'test June package', 'test June package', NULL, '1496315270.', '454.00', NULL, 33, 435, 'Y', '4354', '0', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'N', 'N', '125', '45', '2017-06-01 07:07:50', '2017-08-18 12:22:23', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(130, 1, 'test june package2', 'test june package2', 'test june package2', NULL, '1496315401.', '3434.00', NULL, 32, 23, 'Y', '45435', '0', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '126', '53543', '2017-06-01 07:10:01', '2017-08-18 12:22:14', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(131, 1, 'Allstate 2017', 'Allstate 2017', 'ALLSTATE AGENTS BYPASS BLUEPRINT PAY IN FULL WITH IDEALTRAITS TO END OF 2017', '', '1498659638.', '', '2.19', 9110, 0, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', '2017-04-01 00:00:00', '2018-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '127', '', '2017-06-28 10:20:38', '2018-08-14 16:52:41', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(132, 1, 'fff', 'fff', '', NULL, '1503381429.', '', '2.19', 31, 0, 'N', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'N', 'Y', 'Y', 'N', 'N', 'Y', '', '', '2017-08-22 01:57:09', '2017-08-22 01:57:09', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(133, 1, '2018 Blueprint', '2018 Blueprint', '2018 Blueprint', '', '1506967328.', '$0.00', '0.00', 30, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2019-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '130', '', '2017-10-02 14:02:08', '2018-11-30 16:05:40', 'Y', 'Y', 'Y', 0, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(134, 1, '2018 Blueprint Free Look', '2018 Blueprint Free Look', 'BP Users through Oct 16th, 2017', 'Unlimited Assessments, Applicant Tracking, Instant Results', '1507036854.', '$0.00', '0.00', 29, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2017-11-01 00:00:00', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '131', '', '2017-10-03 09:20:54', '2017-10-13 03:01:38', 'Y', 'Y', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(135, 3, 'Dealer Unlimited', 'Dealer Unlimited', 'Dealer Unlimited', NULL, '1510765113.', '0.00', '0.00', 9500, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '132', NULL, '2017-11-15 11:58:33', '2024-02-02 08:12:57', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(136, 1, 'Allstate 2018', 'Allstate 2018', 'Allstate plan for $800 that expires 12/31/2018', '', '1511992605.', '', '2.19', 1002, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2019-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '133', 'UNLIMITED', '2017-11-29 16:56:45', '2018-11-28 11:46:24', 'Y', 'Y', 'Y', 0, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(137, 1, 'Allstate Quarterly Plan', 'Allstate Quarterly Plan', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1514926319.', '499.00', '0.00', 1100, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '134', 'UNLIMITED', '2018-01-02 15:51:59', '2024-02-20 08:36:39', 'Y', 'Y', 'Y', 90, NULL, NULL, '@allstate.com,@idealtraits.com', 'N', 'Y', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(138, 1, 'Ins Quarterly Plan', 'Ins Quarterly Plan', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1514926952.', '699.00', '0.00', 9961, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '135', '5', '2018-01-02 16:02:32', '2024-03-01 12:22:43', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(139, 1, 'Ins Annual Plan', 'Ins Annual Plan', '12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1514927105.', '1299', '0.00', 9962, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '136', '5', '2018-01-02 16:05:05', '2024-03-01 12:38:42', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(140, 1, 'Allstate Annual Plan', 'Allstate Annual Plan - Save 44%', '12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1514992789.', '999.00', '0.00', 1104, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '137', 'UNLIMITED', '2018-01-03 10:19:49', '2024-02-20 08:37:40', 'Y', 'Y', 'Y', 365, NULL, NULL, '@allstate.com,@idealtraits.com', 'N', 'Y', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(141, 1, 'Testing Auto Renew Plan', 'Testing Auto Renew Plan', 'Testing Auto Renew Plan', 'Testing Auto Renew Plan', '1515531005.', '1.00', '0.00', 1103, 0, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '', 'UNLIMITED', '2018-01-09 15:50:05', '2022-08-03 11:06:05', 'Y', 'Y', 'N', 9, '0', NULL, NULL, 'Y', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(142, 1, 'PAUSED', 'PAUSED', 'PAUSED', 'PAUSED', '1518018716.', '0', '0.00', 1011, 1, 'N', '0', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2030-12-31 00:00:00', 'N', 'N', 'Y', 'N', 'N', 'N', '138', '0', '2018-02-07 10:51:56', '2022-07-28 14:53:29', 'Y', 'N', 'N', NULL, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(185, 1, 'Allstate 2021', 'Allstate 2021 Annual Plan', 'Save 48%. Receive close to 2021 Blueprint pricing. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '', '830.00', NULL, 28, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', '1', NULL, '2022-01-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '190', 'UNLIMITED', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Y', 'Y', 'Y', NULL, NULL, NULL, '@allstate.com,@idealtraits.com', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(144, 3, 'INS Expired', 'INS Expired', 'Non Allstate Expired Packages', '', '1534338588.', '999', '0.00', 2000, 1, 'N', '0', '0', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2018-08-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '140', '0', '2018-08-15 09:09:48', '2018-08-15 09:09:48', 'Y', 'N', 'N', 0, '0', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(145, 3, 'Ideal Annual Unlimited', 'Ideal Annual Unlimited', 'Ideal Annual Unlimited', NULL, '1535556777.', '2495.00', '0.00', 2001, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '141', 'UNLIMITED', '2018-08-29 11:32:57', '2024-02-20 08:38:04', 'Y', 'N', 'N', 365, '0', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(146, 1, 'Big I Monthly Plan', 'Big I Monthly Plan', 'Special monthly pricing plan for \"BIGiHIRES\" members.', 'Unlimited monthly use for $69 per month. Also available to purchase a $399 \"Fast Start\" program', '1536499686.', '69.00', '0.00', 60, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '142', 'UNLIMITED', '2018-09-09 09:28:06', '2024-02-20 08:38:24', 'Y', 'Y', 'N', 40, 'big-i-monthly-plan', NULL, NULL, 'N', 'N', NULL, 'N', 'Y', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(149, 1, '2019 Blueprint', '2019 Blueprint', '2019 Blueprint', '', '1538581858.', '0.00', '0.00', 9904, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2020-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '145', 'UNLIMITED', '2018-10-03 11:50:58', '2019-09-18 05:45:00', 'Y', 'Y', 'Y', 0, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(147, 1, 'Farmers DM Quarterly Plan', 'Farmers DM Quarterly Plan', 'IdealTraits - Internet recruiting, resume searching, job posting', NULL, '1537992287.', '499.00', '0.00', 9901, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'Y', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '143', '5', '2018-09-26 16:04:47', '2024-02-20 08:38:46', 'Y', 'N', 'N', 100, 'Farmers-DM-Quarterly-Plan', NULL, '@farmersagent.com,@idealtraits.com,@farmersagency.com', 'N', 'Y', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(148, 1, 'Farmers DM Annual Plan', 'Farmers DM Annual Plan', 'IdealTraits - Internet recruiting, resume searching, job posting', NULL, '1537992367.', '999.00', '0.00', 9902, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'Y', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '144', '5', '2018-09-26 16:06:07', '2024-02-20 08:39:13', 'Y', 'N', 'N', 375, 'Farmers-DM-Annual-Plan', NULL, '@farmersagent.com,@idealtraits.com,@farmersagency.com', 'N', 'Y', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(227, 1, 'Allstate 2024', 'Allstate 2024 Annual Plan', 'Save 48%. Receive close to 2024 Blueprint pricing. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '', '950.00', NULL, 10, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, '2025-01-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '273', 'UNLIMITED', '2023-11-20 07:46:55', '2024-02-20 08:54:33', 'Y', 'Y', 'Y', NULL, NULL, NULL, '@allstate.com,@idealtraits.com', 'N', 'Y', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(174, 1, 'PIA Annual Plan2', 'PIA Annual Plan2', 'Save 50%. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', '', '1595940934.', '999.00', '0.00', 9984, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '181', 'UNLIMITED', '2020-07-28 08:55:34', '2020-07-28 08:57:15', 'Y', 'N', 'N', 365, '', 0, '', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(150, 1, '2019 BP Free Look Offer', '2019 BP Free Look Offer', '2019 Blueprint Free Look Offer ends December 1st, 2018', '', '1539609849.', '0.00', '0.00', 9950, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2018-12-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '146', '', '2018-10-15 09:24:09', '2019-01-27 10:07:03', 'Y', 'Y', 'Y', 0, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(151, 1, 'Free Trial - 7 Day', 'Free Trial - 7 Day', 'Free Trial - 7 Day', 'Free Trial - 7 Day', '1540033827.', '0.00', '0.00', 9958, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '147', NULL, '2018-10-20 07:10:27', '2022-08-31 08:34:04', 'Y', 'N', 'N', 8, '0', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(152, 1, 'Free Trial - 7 Day - Jay', 'Free Trial - 7 Day - Jay', 'Free Trial - 7 Day - Jay', '', '1540217453.', '0.00', '0.00', 9960, 0, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '148', '', '2018-10-22 10:10:53', '2019-03-13 16:38:02', 'Y', 'N', 'N', 8, '0', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(153, 1, 'Free Trial - 7 Day - DM', 'Free Trial - 7 Day - DM', 'Free Trial - 7 Day - DM', '', '1540217892.', '0.00', '0.00', 9959, 0, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '149', '', '2018-10-22 10:18:12', '2019-10-25 09:42:23', 'Y', 'N', 'N', 8, '', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(154, 1, 'Free Trial - 7 Day - Jeff', 'Free Trial - 7 Day - Jeff', 'Free Trial - 7 Day - Jeff', '', '1540305395.', '0', '0.00', 9957, 0, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '150', '', '2018-10-23 10:36:35', '2018-11-15 02:05:26', 'Y', 'N', 'N', 8, '', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(155, 1, 'Allstate 2019', 'Allstate 2019', 'Allstate unlimited until December 31st 2019', 'Save 50%. Get unlimited use until December 31st 2019. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', '1543261375.', '800.00', '0.00', 9951, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2020-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '151', 'UNLIMITED', '2018-11-26 14:42:55', '2019-03-13 16:07:59', 'Y', 'Y', 'Y', 0, '', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(156, 1, 'Big I Free Trial', 'Big I Free Trial', 'Big I Free Trial - Special 7 day free trial for \"BIGiHIRES\" members.', 'Big I Free Trial - Special 7 day free trial for \"BIGiHIRES\" members.', '1544670220.', '0.00', '0.00', 56, 1, 'Y', 'UNLIMITED', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '153', 'UNLIMITED', '2018-12-12 22:03:40', '2020-07-08 15:17:48', 'Y', 'Y', 'N', 7, '', 0, '', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(157, 1, 'Monthly $89', 'Monthly $89', 'IdealTraits - Internet recruiting, resume searching, job posting', '', '1546466203.', '89.00', '0.00', 27, 1, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '154', '', '2019-01-02 16:56:43', '2019-01-02 16:56:43', 'Y', 'N', 'N', 0, 'Monthly-89', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(158, 1, 'Monthly $99', 'Monthly $99', 'IdealTraits - Internet recruiting, resume searching, job posting', '', '1546466322.', '99.00', '0.00', 26, 1, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', '155', '', '2019-01-02 16:58:42', '2019-01-02 16:58:42', 'Y', 'N', 'N', 0, 'Monthly-99', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(159, 3, 'Hand and Stone Annual', 'Hand and Stone Annual', 'Special monthly pricing plan for \"Hand and Stone\" members.', 'Special monthly pricing plan for \"Hand and Stone\" members.', '1546982817.', '1500.00', '0.00', 9963, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '156', 'UNLIMITED', '2019-01-08 16:26:57', '2020-06-25 17:14:29', 'Y', 'N', 'N', 365, '', 0, '', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(160, 3, 'Keller Williams Monthly Plan', 'Keller Williams Monthly Plan', 'Special monthly pricing plan for \"Keller Williams\" agents. $499 Down and $199 monthly', 'Keller Williams', '1559761036.', '199.00', '0.00', 999, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '162', NULL, '2019-06-05 14:57:16', '2022-08-18 07:56:51', 'Y', 'N', 'N', 40, 'keller-williams-monthly-plan', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(161, 1, 'Allstate Free', 'Allstate Free', 'The Allstate Free package is a free look offer for agents that work with their respective Allstate regional LSP recruiting initiatives. Package upgrades are available.', 'The Allstate Free package is a free look offer for agents that work with their respective Allstate regional LSP recruiting initiatives. Package upgrades are available.', '1565019558.', '0.00', '0.00', 801, 0, 'Y', '', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '163', '', '2019-08-05 11:39:18', '2019-10-02 08:09:03', 'Y', 'Y', 'Y', 0, '', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(162, 1, '2020 BP Free Look Pilot', '2020 BP Free Look Pilot', '2020 Blueprint Free Look Pilot ends November, 1st 2019 	', '', '1566488120.', '0.00', '0.00', 9998, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2019-11-04 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '164', '3', '2019-08-22 11:35:20', '2019-10-21 08:02:07', 'Y', 'Y', 'Y', 0, '', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(163, 1, '2020 Blueprint', '2020 Blueprint', '2020 Blueprint', NULL, '1566827950.', '828.00', '0.00', 9997, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2021-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '165', 'UNLIMITED', '2019-08-26 09:59:10', '2020-09-03 08:00:18', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(164, 1, '2020 BP Free Look Offer', '2020 BP Free Look Offer', '2019 BP Free Look Offer - previously expired users can enter into this package to get a free look into 2020 BP.', '', '1568994475.', '0.00', '0.00', 9234, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2019-11-04 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '167', '', '2019-09-20 11:47:55', '2019-10-21 08:00:31', 'Y', 'Y', 'Y', 0, '', 0, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(165, 1, 'Free Trial - 7 Day DM old', 'Free Trial - 7 Day DM old', 'Free Trial - 7 Day DM', NULL, '1571078436.', '0', '0.00', 501, 0, 'Y', '', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '168', NULL, '2019-10-14 14:40:36', '2019-10-25 09:18:55', 'Y', 'N', 'N', 8, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(166, 1, 'Allstate 2020', 'Allstate 2020', 'Allstate 2020', '', '1574690771.', '830.00', '0.00', 9952, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '0', NULL, '2021-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '169', '', '2019-11-25 09:06:11', '2020-03-10 08:02:51', 'Y', 'Y', 'Y', 0, '', 0, '@allstate.com,@idealtraits.com', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(167, 1, 'PIA Quarterly Plan', 'PIA Quarterly Plan', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1583490302.', '499.00', '0.00', 9980, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '172', 'UNLIMITED', '2020-03-06 05:25:02', '2024-02-20 08:39:44', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(168, 1, 'PIA Annual Plan', 'PIA Annual Plan', '12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1583490584.', '999.00', '0.00', 9983, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '173', 'UNLIMITED', '2020-03-06 05:29:44', '2024-02-20 08:40:17', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(186, 1, 'Safeco Pilot', 'Safeco Pilot', 'Safeco Pilot', NULL, '', '499', '0.00', 25, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '1', NULL, '2021-06-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '192', 'UNLIMITED', '0000-00-00 00:00:00', '2022-08-18 07:53:58', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(170, 1, 'BIGi Annual Plan', 'BIGi Annual Plan', 'Special pricing plan for \"BIGiHIRES\" members. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1592513824.', '999.00', '0.00', 1001, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '177', 'UNLIMITED', '2020-06-18 16:57:04', '2024-02-20 08:40:45', 'Y', 'Y', 'N', 365, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'Y', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(171, 1, 'BIGi Quarterly Plan', 'BIGi Quarterly Plan', 'Special pricing plan for \"BIGiHIRES\" members. 3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1592513904.', '499.00', '0.00', 1003, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '178', 'UNLIMITED', '2020-06-18 16:58:24', '2024-02-20 08:41:16', 'Y', 'Y', 'N', 90, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'Y', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(172, 1, 'Farmers Quarterly Plan', 'Farmers Quarterly Plan', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1592832210.', '499.00', '0.00', 1004, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '179', 'UNLIMITED', '2020-06-22 09:23:30', '2024-02-20 08:41:41', 'Y', 'N', 'N', 90, NULL, NULL, '@farmersagent.com,@idealtraits.com', 'N', 'Y', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(173, 1, 'Farmers Annual Plan', 'Farmers Annual Plan', '12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1592832581.', '999.00', '0.00', 1005, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '0', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '180', 'UNLIMITED', '2020-06-22 09:29:41', '2024-02-20 08:42:06', 'Y', 'N', 'N', 365, NULL, NULL, '@farmersagent.com,@idealtraits.com', 'N', 'Y', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(175, 1, 'PIA Quarterly Plan2', 'PIA Quarterly Plan2', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', '', '1595941020.', '499.00', '0.00', 9981, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '182', 'UNLIMITED', '2020-07-28 08:57:00', '2020-07-28 08:57:00', 'Y', 'N', 'N', 90, '', NULL, '', 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(176, 1, 'Farmers Store Annual', 'Farmers Store Annual', 'Save 50%. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.\r\nHere are your exclusive benefits: \r\nASCTS Candidate Pool\r\nPlacement on Insurance Jobs \r\nYext Integration', NULL, '1596543316.', '999.00', '0.00', 9905, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '183', 'UNLIMITED', '2020-08-04 08:15:16', '2024-02-20 08:42:31', 'Y', 'Y', 'N', 365, NULL, NULL, NULL, 'Y', 'N', 'Farmers', 'Y', 'N', 'Y', 'Y', 'N', NULL, 'N', 'Y', 'Y', '0'),
(177, 1, 'Farmers Store Quarterly', 'Farmers Store Quarterly', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1596543415.', '499.00', '0.00', 9906, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '184', 'UNLIMITED', '2020-08-04 08:16:55', '2024-02-20 08:42:57', 'Y', 'Y', 'N', 90, NULL, NULL, NULL, 'Y', 'N', 'Farmers', 'Y', 'N', 'Y', 'Y', 'N', NULL, 'N', 'Y', 'Y', '0'),
(178, 1, 'Farmers DM Store Annual', 'Farmers DM Store Annual', '12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1596543516.', '999.00', '0.00', 9907, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'Y', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '185', '5', '2020-08-04 08:18:36', '2024-02-20 08:43:26', 'Y', 'Y', 'N', 365, NULL, NULL, NULL, 'Y', 'N', 'Farmers', 'Y', 'N', 'N', 'Y', 'N', NULL, 'N', 'Y', 'Y', '0'),
(179, 1, 'Farmers DM Store Quarterly', 'Farmers DM Store Quarterly', '3-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '1596543626.', '499.00', '0.00', 9908, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'Y', '0', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '186', '5', '2020-08-04 08:20:26', '2024-02-20 08:43:47', 'Y', 'Y', 'N', 90, NULL, NULL, NULL, 'Y', 'N', 'Farmers', 'Y', 'N', 'N', 'Y', 'N', NULL, 'N', 'Y', 'Y', '0'),
(181, 1, '2021 Blueprint', '2021 Blueprint', '2021 Blueprint', NULL, '', '828.00', '0.00', 24, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '1', NULL, '2022-01-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '', 'UNLIMITED', '0000-00-00 00:00:00', '2020-12-15 10:07:30', 'Y', 'Y', 'Y', NULL, NULL, 4, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(183, 1, 'Encompass Quarterly', 'Encompass Quarterly', 'Encompass Quarterly', NULL, '', '499.00', '0.00', 23, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '188', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:44:09', 'Y', 'Y', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(184, 1, 'Encompass Annual', 'Encompass Annual', 'Encompass Annual', NULL, '', '999.00', NULL, 22, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '189', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:44:34', 'Y', 'Y', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(188, 3, 'Great Clips Annual', 'Great Clips Annual', 'Great Clips Annual', NULL, '', '1500.00', NULL, 21, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '194', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:45:16', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(190, 1, 'AMFAM Quarterly Plan', 'AMFAM Quarterly Plan', 'AMFAM Quarterly Plan', NULL, '', '499.00', '0.00', 20, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:46:44', 'Y', 'N', 'N', 90, NULL, 4, '@amfam.com', 'N', 'Y', 'American', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(191, 1, 'AMFAM Annual Plan', 'AMFAM Annual Plan', 'AMFAM Annual Plan', NULL, '', '999.00', '0.00', 19, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '197', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:47:05', 'Y', 'N', 'N', 365, NULL, 4, '@amfam.com', 'N', 'Y', 'American', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(192, 3, 'Keller Williams Annual', 'Keller Williams Annual', 'Special annual pricing plan for \"Keller Williams\" agents.', NULL, '', '6999.00', NULL, 18, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'Y', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '200', 'UNLIMITED', '0000-00-00 00:00:00', '2022-08-18 07:56:45', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(193, 3, 'Mortgage Quarterly', 'Mortgage Quarterly', NULL, NULL, '', '499.00', NULL, 17, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '201', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:45:38', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(194, 3, 'Mortgage Annual', 'Mortgage Annual', 'Mortgage Annual', NULL, '', '999.00', NULL, 16, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '202', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:45:54', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(195, 1, 'Internal Team Members', 'Internal Team Members', NULL, NULL, '', '0.00', '0.00', 15, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', '2021-09-30 00:00:00', NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '209', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-19 12:44:35', 'Y', 'N', 'N', 365, NULL, NULL, '@idealtraits.com', 'N', 'N', 'IdealTraits', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(196, 1, 'FR Package - CP Access', 'FR Package - CP Access', NULL, NULL, '', '0.00', '0.00', 14, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '210', NULL, '0000-00-00 00:00:00', '2024-01-02 06:10:55', 'Y', 'Y', 'Y', 1, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'Y', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(197, 1, 'FR Package - CP Host', 'FR Package - CP Host', 'No Equal Employment Opportunity Questionnaire in assessment.', NULL, '', '0.00', '0.00', 13, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'Y', '1', NULL, '2022-10-25 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '211', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Y', 'N', 'N', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(198, 1, 'Liberty Mutual/Safeco Annual', 'Liberty Mutual/Safeco Annual', 'Liberty Mutual/Safeco Annual', NULL, '', '949.00', NULL, 12, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '213', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:47:46', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(199, 1, '2022 Blueprint', '2022 Blueprint', '2022 Blueprint Annual Package', NULL, '', '0.00', NULL, 11, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '1', NULL, '2023-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '215', 'UNLIMITED', '0000-00-00 00:00:00', '2022-12-02 07:58:16', 'Y', 'Y', 'Y', NULL, NULL, 4, NULL, 'N', 'N', 'Allstate Insurance', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(201, 1, 'Allstate 2022', 'Allstate 2022 Annual Plan', 'Save 48%. Receive close to 2021 Blueprint pricing. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '', '830.00', NULL, 10, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '1', NULL, '2023-01-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '217', 'UNLIMITED', '0000-00-00 00:00:00', '2022-12-02 07:57:51', 'Y', 'Y', 'Y', NULL, NULL, NULL, '@allstate.com,@idealtraits.com', 'N', 'Y', 'Allstate Insurance', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(200, 1, 'Farmers New Agent Promotion', 'Farmers New Agent Promotion', 'Farmers New Agent 14 Day Free Trial', NULL, '', '0.00', NULL, 9, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'Y', 'N', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '216', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-02 08:05:56', 'Y', 'Y', 'N', 14, NULL, NULL, '@farmersagent.com', 'N', 'N', 'Farmers', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(202, 1, 'GEICO Quarterly Plan', 'GEICO Quarterly Plan', NULL, NULL, '', '499.00', '0.00', 8, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '220', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:48:20', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', 'GEICO', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(203, 1, 'GEICO Annual Plan', 'GEICO Annual Plan', NULL, NULL, '', '999.00', '0.00', 7, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '221', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:48:44', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', 'GEICO', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(204, 1, 'IAOA Annual Plan', 'IAOA Annual Plan', NULL, NULL, '', '999.00', '0.00', 6, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '224', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:50:31', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(205, 1, 'IAOA Quarterly Plan', 'IAOA Quarterly Plan', NULL, NULL, '', '499.00', NULL, 5, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '225', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:50:49', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(206, 1, 'Enterprise Solutions', 'Enterprise Solutions', NULL, NULL, '', '4999.00', '0.00', 4, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '227', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:51:13', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(207, 1, 'AAA Quarterly Plan', 'AAA Quarterly Plan', NULL, NULL, '', '499.00', '0.00', 3, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '228', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:51:33', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(208, 1, 'AAA Annual Plan', 'AAA Annual Plan', NULL, NULL, '', '999.00', '0.00', 2, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '229', 'UNLIMITED', '0000-00-00 00:00:00', '2024-02-20 08:51:50', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(209, 1, 'test credits', 'test credits', NULL, NULL, '', '0.00', '0.00', 0, 0, 'N', '1', '0', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'N', 'Y', 'N', '231', '1', '2022-05-04 15:01:28', '2024-02-26 07:54:39', 'Y', 'N', 'N', 90, NULL, NULL, '@idealtraits.com', 'Y', 'N', 'Allstate1', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'N', 'Y', '5'),
(210, 1, 'Demo Package', 'Demo Package', NULL, NULL, '', '0.00', '0.00', 1, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '232', NULL, '2022-05-04 15:33:00', '2022-12-07 08:12:41', 'Y', 'N', 'N', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(211, 1, 'Farmers Direct Sales', 'Farmers Direct Sales', NULL, NULL, '', '0.00', '0.00', 0, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '233', NULL, '2022-06-17 09:18:45', '2022-06-17 09:24:30', 'Y', 'N', 'Y', 365, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(212, 6, 'Test New Profile Outcome', 'Test New Profile Outcome', 'Test New Profile Outcome', NULL, '', '0.00', NULL, 0, 0, 'N', '1', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '234', '1', '2022-06-24 13:49:51', '2022-12-12 05:37:12', 'Y', 'Y', 'Y', 365, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(214, 1, '2023 Blueprint', '2023 Blueprint', '2023 Blueprint Annual Package', NULL, '', '0.00', NULL, 11, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', '1', NULL, '2024-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '246', 'UNLIMITED', '2022-08-22 11:39:19', '2024-02-20 08:52:09', 'Y', 'Y', 'Y', NULL, NULL, 4, '@allstate.com,@idealtraits.com', 'N', 'N', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(215, 1, 'BigI State', 'BigI State', NULL, NULL, '', '0.00', NULL, 0, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'N', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '247', 'UNLIMITED', '2022-09-16 10:46:52', '2024-02-20 08:52:30', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'Y', 'N', NULL, 'N', 'Y', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(216, 1, 'Legacy Package', 'Legacy Package', NULL, NULL, '', '999.00', '0.00', 0, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2023-01-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '248', 'UNLIMITED', '2022-10-11 11:53:24', '2022-12-05 08:54:15', 'Y', 'N', 'Y', NULL, NULL, NULL, NULL, 'N', 'N', 'Allstate Insurance', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(217, 1, 'Allstate 2023', 'Allstate 2023 Annual Plan', 'Save 48%. Receive close to 2023 Blueprint pricing. 12-Month full access. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '', '950.00', NULL, 10, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'Y', 'N', 'N', 'N', '1', NULL, '2024-01-01 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '254', 'UNLIMITED', '2022-11-21 09:34:55', '2023-06-13 11:35:42', 'Y', 'Y', 'Y', NULL, NULL, NULL, '@allstate.com,@idealtraits.com', 'N', 'Y', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(218, 1, 'BIGi Limited', 'BIGi Limited', 'Limited access package for Big I agents.', 'Free package with Limited Access for Big I Agents only.', '', '0.00', '0.00', 0, 0, 'N', '0', '0', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', '1', NULL, '2030-01-01 00:00:00', 'Y', 'N', 'N', 'Y', 'Y', 'N', '255', '5', '2022-11-23 09:45:44', '2022-12-29 14:16:08', 'Y', 'N', 'N', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'Y', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(219, 1, 'Ranahan Consulting Monthly Renew', 'Ranahan Consulting Monthly Renew', 'Special monthly pricing plan for \"Ranahan Consulting\" members.', NULL, '', '159.00', '0.00', 9100, 1, 'Y', 'UNLIMITED', '1', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '256', NULL, '2022-11-30 10:42:31', '2024-02-20 08:52:46', 'Y', 'N', 'N', 40, 'Ranahan-Consulting-Monthly-Renew', NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(222, 1, 'Country Financial Quarterly Plan', 'Country Financial Quarterly Plan', NULL, NULL, '', '0.00', '0.00', 9905, 1, 'Y', 'UNLIMITED', '0', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '263', 'UNLIMITED', '2023-04-19 15:01:05', '2024-02-20 08:53:28', 'Y', 'N', 'N', 90, NULL, NULL, NULL, 'N', 'N', 'Country', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(220, 1, 'New Agent Farmers Store Hold', 'New Agent Farmers Store Hold', 'Annual package with access to ASCTS for new farmers agents who cannot yet access the candidate pool', NULL, '', '999.00', '0.00', 0, 0, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '259', 'UNLIMITED', '2022-12-06 13:07:24', '2024-02-20 08:53:03', 'Y', 'Y', 'N', 365, NULL, NULL, NULL, 'N', 'N', 'Farmers', 'Y', 'N', 'Y', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(221, 1, 'test', 'test', 'test', 'test', '', '120', '10.00', 0, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'Y', 'N', 'Y', '1', '2022-12-12 00:00:00', '2023-12-31 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '260', 'UNLIMITED', '2022-12-12 05:39:18', '2024-02-05 05:57:27', 'Y', 'N', 'Y', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'N', 'Y', 'Y', '0'),
(223, 1, 'Farmers 30 Day Trial', 'Farmers 30 Day Trial', 'Farmers 30 Day Trial', NULL, '', '0.00', NULL, 9, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '268', 'UNLIMITED', '2023-07-27 15:51:53', '2024-02-20 08:54:03', 'Y', 'Y', 'N', 30, NULL, NULL, '@farmersagent.com,@idealtraits.com', 'N', 'N', 'Farmers', 'Y', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(224, 1, 'Developer Demo', 'Developer Demo', 'For Partner / Developer use only.', NULL, '', '1.00', '0.00', 0, 1, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'Y', '1', '2022-12-12 00:00:00', '2025-12-31 00:00:00', 'Y', 'N', 'Y', 'Y', 'Y', 'N', '270', '5', '2023-09-12 12:07:38', '2024-02-15 07:57:42', 'Y', 'N', 'Y', 180, NULL, NULL, NULL, 'Y', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(225, 1, 'Ins Limited', 'Ins Limited', 'Limited access package', 'Limited access package - unlimited assessments, unlimited job posting to career page only.', '', '1299', '0.00', 0, 0, 'N', 'UNLIMITED', '0', 'Y', 'N', 'N', 'N', 'N', 'Y', 'N', '1', NULL, '2030-01-01 00:00:00', 'Y', 'N', 'N', 'Y', 'Y', 'N', '271', 'UNLIMITED', '2023-10-10 09:33:57', '2024-02-20 08:53:44', 'Y', 'N', 'N', 365, NULL, NULL, NULL, 'N', 'N', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(226, 1, '2024 Blueprint', '2024 Blueprint', '2024 Blueprint Annual Package', NULL, '', '0.00', NULL, 11, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, '2025-01-01 00:00:00', 'N', 'N', 'Y', 'Y', 'Y', 'N', '272', 'UNLIMITED', '2023-11-01 08:25:35', '2024-02-20 08:54:19', 'Y', 'Y', 'Y', NULL, NULL, 4, '@allstate.com,@idealtraits.com', 'N', 'N', 'Allstate', 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(228, 3, 'IdealTraits Generic Monthly', 'IdealTraits Generic Monthly', 'IdealTraits - Internet recruiting, resume searching, job posting', NULL, '', '325.00', '0.00', 1007, 1, 'Y', 'UNLIMITED', '2', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '275', 'UNLIMITED', '2023-11-30 14:52:29', '2024-02-20 08:55:04', 'Y', 'N', 'N', 40, 'idealtraits-generic-monthly', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(229, 1, 'Ins Annual Monthly Plan', 'Ins Annual Monthly Plan', 'IdealTraits - Internet recruiting, resume searching, job posting', NULL, '', '99.00', '0.00', 1007, 0, 'Y', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'N', 'N', 'Y', 'Y', 'Y', 'N', '276', '5', '2023-12-01 10:24:37', '2024-02-20 08:55:23', 'Y', 'N', 'N', 40, 'ins-annual-monthly-plan', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0'),
(230, 3, 'The United Green Quarterly', 'The United Green Quarterly', 'Quarterly plan for The United Green clients, powered by IdealTraits. Standard Package.', NULL, '', '699.00', '0.00', 0, 0, 'N', 'UNLIMITED', '1', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '279', '3', '2023-12-19 08:54:16', '2024-02-20 08:55:48', 'Y', 'N', 'N', 100, 'the-united-green-quarterly', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(231, 3, 'The United Green Annual', 'The United Green Annual', 'Annual plan for The United Green clients, powered by IdealTraits. Standard Package.', NULL, '', '1299.00', '0.00', 0, 0, 'N', 'UNLIMITED', '1', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '280', '3', '2023-12-19 09:10:29', '2024-02-20 08:56:04', 'Y', 'N', 'N', 375, 'the-united-green-annual', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(232, 3, 'The United Green Quarterly Gold', 'The United Green Quarterly Gold', 'Quarterly plan for The United Green clients, powered by IdealTraits. Gold Package.', NULL, '', '2699.00', '0.00', 0, 0, 'N', 'UNLIMITED', '3', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '281', '10', '2023-12-19 09:14:38', '2024-02-20 08:56:19', 'Y', 'N', 'N', 100, 'the-united-green-quarterly-gold', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'Y', NULL, 'Y', 'Y', 'Y', '0');
INSERT INTO `package_mst` (`package_id`, `profileoutcome_table_id`, `package_name`, `package_title`, `package_description`, `package_feature`, `package_logo`, `package_price`, `package_per_diem`, `package_level`, `package_lowcount`, `unlimited`, `number_of_test`, `number_of_users`, `package_active`, `resumeparser_active`, `user_loaction_active`, `sms_active`, `textsms_active`, `checkr_status`, `custom_stage_active`, `rps_available`, `package_start_date`, `package_exp_date`, `package_status`, `package_delete`, `job_post_offer`, `job_share_status`, `job_advt_status`, `emailtemplate`, `emailtemplateid`, `post_jobs_credits`, `date_added`, `date_modified`, `fullcontact_status`, `agent_req`, `region_req`, `expires_in_days`, `chargebee_id`, `candidateofferpage`, `email_restriction_registration`, `auto_renew`, `activate_req`, `indeed_sourcename`, `insurancejobs_status`, `bigijobs_status`, `ascts_candidatepool`, `yext_soci`, `unitedgreen_status`, `automatedworkflow_package_id`, `ai_job_status`, `ai_qualifying_status`, `ai_company_status`, `no_of_location`) VALUES
(233, 3, 'The United Green Annual Gold', 'The United Green Annual Gold', 'Annual plan for The United Green clients, powered by IdealTraits. Gold Package.', NULL, '', '4999.00', '0.00', 0, 0, 'N', 'UNLIMITED', '3', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '291', '10', '2024-02-13 10:15:45', '2024-02-20 08:56:36', 'Y', 'N', 'N', 375, 'the-united-green-annual-gold', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(234, 3, 'The United Green Quarterly Diamond', 'The United Green Quarterly Diamond', 'Quarterly plan for The United Green clients, powered by IdealTraits. Diamond Package.', NULL, '', '4499.00', '0.00', 0, 0, 'Y', 'UNLIMITED', '20', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '292', 'UNLIMITED', '2024-02-13 10:26:05', '2024-02-20 08:56:53', 'Y', 'N', 'N', 100, 'the-united-green-quarterly-diamond', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(235, 3, 'The United Green Annual Diamond', 'The United Green Annual Diamond', 'Annual plan for The United Green clients, powered by IdealTraits. Diamond Package.', NULL, '', '8999.00', '0.00', 0, 0, 'Y', 'UNLIMITED', '20', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '293', 'UNLIMITED', '2024-02-13 10:27:26', '2024-02-20 08:57:09', 'Y', 'N', 'N', 375, 'the-united-green-annual-diamond', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(236, 1, 'Liberty Mutual/Safeco Annual Monthly Hold', 'Liberty Mutual/Safeco Annual Monthly Hold', NULL, NULL, '', '2999.00', NULL, 0, 1, 'Y', 'UNLIMITED', '0', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '295', '0', '2024-02-19 11:42:59', '2024-02-19 11:42:59', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(237, 1, 'Tesed By Pajany', 'Tesed By Pajany', 'test', NULL, '', '1', '1.00', 0, 1, 'Y', 'UNLIMITED', NULL, 'Y', 'N', 'N', 'Y', 'N', 'Y', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'Y', '', NULL, '2024-02-19 12:06:31', '2024-02-19 12:06:31', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', '0'),
(238, 1, 'Tesed By Pajany', 'Tesed By Pajany', 'test', NULL, '', '1', '1.00', 0, 1, 'Y', 'UNLIMITED', NULL, 'Y', 'N', 'N', 'Y', 'N', 'Y', 'Y', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'Y', '', NULL, '2024-02-19 12:07:06', '2024-02-26 07:52:41', 'Y', 'Y', 'Y', NULL, NULL, NULL, NULL, 'N', 'N', NULL, 'Y', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 'Y', 'Y', 'UNLIMITED'),
(239, 3, 'Premium Annual Plan', 'Premium Annual Plan', '12-Month full access auto renewing subscription. Post your jobs on sites like Indeed and ZipRecruiter for free, send personality assessments, and manage your applicants through your hiring process.', NULL, '', '1788.00', '0.00', 1007, 1, 'Y', 'UNLIMITED', '2', 'Y', 'N', 'N', 'N', 'Y', 'Y', 'N', '1', NULL, NULL, 'Y', 'N', 'Y', 'Y', 'Y', 'N', '298', '10', '2024-02-21 12:18:33', '2024-02-21 12:18:33', 'Y', 'N', 'N', 375, 'Premium-Annual-Plan', NULL, NULL, 'N', 'Y', NULL, 'N', 'N', 'N', 'N', 'N', NULL, 'Y', 'Y', 'Y', '0');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `package_mst`
--
ALTER TABLE `package_mst`
  ADD PRIMARY KEY (`package_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `package_mst`
--
ALTER TABLE `package_mst`
  MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
