-- ######################################################
--
--	Leaked by pompompurin on RaidForums
--	https://raidforums.com/User-pompompurin
--	Donate BTC: 15hShZD41kwCQSX5siNSetChBzMCQ74NCV
--
-- ######################################################
--
-- --------------------------------------------------------
-- Host:                         pe-ensek-mirror-mysql-live.clri0keulv9t.eu-west-2.rds.amazonaws.com
-- Server version:               5.7.26-log - Source distribution
-- Server OS:                    Linux
-- HeidiSQL Version:             11.0.0.5919
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping data for table peoplesenergy_ppe.category: ~131 rows (approximately)
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` (`id`, `parent_category_id`, `title`, `active`, `description`, `position`, `updated_at`, `icon`, `color`, `col`) VALUES
	(2, NULL, 'Billing', 1, 'How to deal with billing and Direct Debit Queries', 2, '2020-02-01 10:00:00', 'file-invoice-dollar', '#f29b1a', 0),
	(17, 171, 'Cancel in Cool Off', 1, 'Member wants to leave within 14 days of joining', 1, NULL, 'snowflake', 'Blue', 0),
	(22, NULL, 'Tariff Change', 1, 'How to deal with a tariff change', 24, NULL, 'calendar-times', 'PaleVioletRed', 2),
	(25, NULL, 'Bereavement', 1, 'How to deal with a members death', 3, NULL, 'sad-tear', '#fa2c45', 0),
	(30, NULL, 'Metering', 1, 'How to deal with metering questions', 16, NULL, 'digital-tachograph', '#0080c0', 1),
	(33, NULL, 'Switches', 1, 'How to deal with members switching', 23, NULL, 'exchange-alt', '#004080', 2),
	(34, 233, 'New Online Portal Account', 1, 'How to set up members on the portal', 0, NULL, 'newspaper', '#29bf22', 0),
	(35, NULL, 'Objections/Rejections', 1, 'When we or another supplier objects to a switch or where we have rejected a customer\'s switch', 18, NULL, 'columns', '#ef1c10', 1),
	(46, 35, 'Rejections', 1, 'What to do when a members supply is rejected', 2, NULL, 'stop-circle', '#ef1c10', 0),
	(48, 212, 'Add to PSR', 1, 'How to flag vulnerable members', 3, NULL, 'exclamation-triangle', 'Black', 0),
	(52, 2, 'Refunds', 1, 'How to process a refund', 4, NULL, 'pound-sign', '#f0ad4e', 0),
	(59, 228, 'Move Out', 1, 'How to process a members exit', 0, NULL, 'house-damage', '#29bf22', 0),
	(63, 166, 'Complaints', 1, 'How to raise a complaint', 1, NULL, 'ambulance', 'ForestGreen', 0),
	(96, 33, 'Switching from', 1, 'How to deal with members switching away', 0, NULL, '', '#004080', 0),
	(97, 33, 'Switching to', 1, 'How to deal with members switching to us', 1, NULL, '', '#004080', 0),
	(99, 102, 'Transferring a Call to B2B Team', 1, '', 0, NULL, 'building', '#dd631a', 0),
	(100, 35, 'Objections (People\'s Energy)', 1, 'What to do when we object to a member leaving', 0, NULL, 'gavel', '#ef1c10', 0),
	(101, 35, 'Objections (Suppliers)', 1, 'What to do when a supplier objects to a member joining us', 1, NULL, 'gavel', '#ef1c10', 0),
	(102, NULL, 'B2B', 1, 'How to deal with a B2B member', 1, NULL, 'business-time', '#dd631a', 0),
	(104, 220, 'Erroneous Transfers (Gain)', 1, 'What to do when we wrongly take on someones supply', 0, NULL, 'angle-double-up', '#ef1c10', 0),
	(105, 220, 'Erroneous Transfer (Loss)', 1, 'What to do when we lose a members supply', 1, NULL, 'angle-double-down', '#ef1c10', 0),
	(106, 30, 'Emergency Meter Appointments', 1, 'How to book in an emergency meter appointment', 5, NULL, 'ambulance', '#0080c0', 0),
	(107, NULL, 'Sign ups and Quote Calls', 1, 'How to deal with sign ups and exits', 21, NULL, 'home', '#29bf22', 2),
	(112, 2, 'Billing Exceptions', 1, 'Most common Billing Exceptions explained', 3, NULL, 'paperclip', '#f0ad4e', 0),
	(116, NULL, 'Crowdfunder', 1, 'Info for initial crowdfunders', 7, NULL, 'people-carry', '#52c11c', 0),
	(118, 30, 'Meter Codes', 1, 'How to translate XOSERVE/ECOES meter codes', 7, NULL, 'laptop-code', '#0080c0', 0),
	(120, 233, 'Online Portal - Password reset not worked', 1, '', 1, NULL, 'passport', '#29bf22', 0),
	(123, NULL, 'UniHomes', 1, '', 25, NULL, 'university', '#3f80c6', 2),
	(124, 30, 'Gas Leak', 1, '', 6, NULL, 'gas-pump', '#0080c0', 0),
	(126, NULL, 'Meter Errors - Electric', 1, '', 14, NULL, 'lightbulb', 'seagreen', 1),
	(128, 126, 'Error D1-D7, D9', 1, 'Faulty Key', 1, NULL, 'exclamation-circle', 'seagreen', 0),
	(129, 126, 'Error A3', 1, '', 2, NULL, 'exclamation-triangle', 'seagreen', 0),
	(131, 126, 'Top up up not going on meter/ Balance not changing', 1, '', 3, NULL, 'balance-scale', 'seagreen', 0),
	(132, 126, 'Token NO', 1, '', 4, NULL, 'not-equal', 'seagreen', 0),
	(133, NULL, 'Meter Errors - GAS', 1, '', 15, NULL, 'gas-pump', 'CornflowerBlue', 1),
	(134, 133, 'Call Help', 1, '', 0, NULL, 'notes-medical', 'CornflowerBlue', 0),
	(135, 133, 'Card Fail', 1, '', 1, NULL, 'sim-card', 'CornflowerBlue', 0),
	(136, 133, 'Card not accepted', 1, '', 2, NULL, 'exclamation-triangle', 'CornflowerBlue', 0),
	(137, 180, 'Lost Card', 1, 'Sending out a Replacement Card or Local Pick Up', 3, NULL, 'sd-card', 'Black', 0),
	(138, 133, 'Battery B1/B2/B3/Low', 1, '', 3, NULL, 'battery-quarter', 'CornflowerBlue', 0),
	(139, 133, 'Battery Fail', 1, '', 4, NULL, 'battery-empty', 'CornflowerBlue', 0),
	(140, 133, 'Please wait', 1, '', 5, NULL, 'truck-loading', 'CornflowerBlue', 0),
	(141, 133, 'Blank Screen', 1, '', 6, NULL, 'tv', 'CornflowerBlue', 0),
	(142, 133, 'Off', 1, '', 7, NULL, 'power-off', 'CornflowerBlue', 0),
	(143, 133, 'M*****/M- - - - - fault', 1, '', 8, NULL, 'barcode', 'CornflowerBlue', 0),
	(145, 107, 'Quote/Sign up', 1, '', 1, NULL, 'quote-left', '#29bf22', 0),
	(146, 133, 'Slot Fault', 1, '', 9, NULL, 'id-card', 'CornflowerBlue', 0),
	(147, 164, 'Transfer Calls', 1, '', 0, NULL, 'arrow-right', 'Black', 0),
	(148, 22, 'East Lothian Tariff', 1, '', NULL, NULL, 'map-marked-alt', 'PaleVioletRed', 0),
	(151, 171, 'Pending Registrations', 1, 'Cancel an account from Pending Registrations', 2, NULL, 'truck-loading', 'Blue', 0),
	(155, 30, 'Credit Mode - Emergency Appointment', 1, 'How to identify if a Smart Meter is in Credit mode and next steps', 4, NULL, 'ambulance', '#0080c0', 0),
	(156, 223, 'Identifying and Raising a Dispute', 1, '', 0, NULL, 'search', 'Black', 0),
	(157, 30, 'Incorrect Meter Details', 1, 'What to do when we have the incorrect MSN/MPxN details or where we have never taken over their supply', 0, NULL, 'database', '#0080c0', 0),
	(158, 169, 'Meter Reads', 1, 'How to input Meter Reads in Ensek', 1, NULL, 'envelope-open-text', 'black', 0),
	(159, 164, 'DPA', 1, 'Going through Security on a call', 1, NULL, 'lock', 'black', 0),
	(160, 30, 'Blank Screen', 1, '', 8, NULL, 'desktop', '#0080c0', 0),
	(161, 169, 'Quarterly Readings', 1, 'How to register someone to receive Quarterly Meter Readings', 2, NULL, 'calendar-week', 'black', 0),
	(162, 164, 'Call Handling 3rd Party', 1, '', 2, NULL, 'phone-slash', 'black', 0),
	(164, NULL, 'Call Handling', 1, NULL, 4, NULL, 'headphones', 'black', 0),
	(165, 164, 'Outbound Call', 1, '', 3, NULL, 'arrow-alt-circle-right', 'black', 0),
	(166, NULL, 'Complaints, Escalations and Feedback', 1, '', 6, NULL, 'comment-dots', 'ForestGreen', 0),
	(167, 166, 'Manager Escalations', 1, 'Where a member requests to speak to a manager', 2, NULL, 'arrow-up', 'ForestGreen', 0),
	(169, NULL, 'Meter Readings', 1, NULL, 17, NULL, 'tachometer-alt', '#000000', 1),
	(171, NULL, 'Cancel a Switch', 1, '', 5, NULL, 'stop-circle', 'Blue', 0),
	(173, 2, 'Prepayment Billing', 1, '', 2, NULL, 'pound-sign', '#f0ad4e', 0),
	(174, 231, 'Assign a call to FD ticket', 1, '', 2, NULL, 'puzzle-piece', 'Purple', 0),
	(175, 169, 'Meter Read not submitting', 1, '', 3, NULL, 'exclamation-triangle', 'black', 0),
	(176, NULL, 'Smart Meters', 1, '', 20, NULL, 'brain', 'black', 2),
	(180, NULL, 'Keys and Cards', 1, '', 13, NULL, 'key', 'black', 1),
	(181, 180, 'Card not Received', 1, 'Sending out a Replacement Card or Local Pick Up', 1, NULL, 'mail-bulk', 'black', 0),
	(182, 33, 'Go Cardless', 1, 'How to check to see if there is an active subscription', NULL, NULL, 'credit-card', '#004080', 0),
	(183, 22, 'Smart Prepay to Credit', 1, '', NULL, NULL, 'exchange-alt', 'PaleVioletRed', 0),
	(184, 2, 'Paper Billing', 1, '', 1, NULL, 'file-invoice-dollar', '#f29b1a', 0),
	(185, 166, '3rd Party Feedback', 1, 'Provide feedback re third parties such as magnum, d2d sales and others.', 0, NULL, '', 'ForestGreen', 0),
	(186, 126, 'Error A1, A2, A6, A10', 1, 'Faulty Key', NULL, NULL, 'exclamation', 'seagreen', 0),
	(187, 126, 'Error 6-44', 1, 'Faulty Key', NULL, NULL, 'exclamation-circle', 'seagreen', 0),
	(188, 126, 'Error B1-B7, B9', 1, 'Faulty Key', NULL, NULL, 'exclamation-triangle', 'seagreen', 0),
	(189, 126, 'Error C4/C5 and E4/E5', 1, 'Faulty Key', NULL, NULL, 'exclamation', 'seagreen', 0),
	(190, 126, 'Blank Screen', 1, '', NULL, NULL, 'tv', 'seagreen', 0),
	(191, 30, 'Activating Emergency Credit', 1, '', 2, NULL, 'envelope-open-text', '#0080c0', 0),
	(192, 30, 'Customer Wants Credit Meters', 1, '', 3, NULL, 'comment-dollar', '#0080c0', 0),
	(193, 169, 'Traditional Meter Reading', 1, '', 0, NULL, 'book-reader', '#000000', 0),
	(194, 176, 'Meter Reading Smart', 1, 'How to get a manual meter reading from a smart meter', NULL, NULL, 'newspaper', 'black', 0),
	(195, 171, 'Gas cancel Issue', 1, 'Where a customer has cancelled in cool off and only the elec has cancelled', 0, NULL, 'fire', 'Blue', 0),
	(197, 180, 'Key Not Received', 1, 'Sending out a Replacement key or Local Pick Up', 0, NULL, 'mail-bulk', 'black', 0),
	(198, 180, 'Lost Key', 1, 'Sending out a Replacement Key or Local Pick Up', 2, NULL, 'key', 'black', 0),
	(200, NULL, 'Smart PP Error Oct 20 Comm - Specific Consultants only', 1, 'Those that have received the specific Smart PP Apology/compensation training should use this', 22, NULL, 'exclamation', 'purple', 2),
	(201, 200, 'Tariff Change', 1, '', NULL, NULL, 'exchange-alt', 'purple', 0),
	(202, 200, 'Set Up/Change Direct Debit Details', 1, '', NULL, NULL, 'credit-card', 'purple', 0),
	(203, 200, 'Take Payment', 1, '', NULL, NULL, 'apple-alt', 'purple', 0),
	(204, 200, 'Gesture Of Good Will', 1, '', NULL, NULL, 'hands-helping', 'purple', 0),
	(205, 200, 'Payment Plan', 1, '', NULL, NULL, 'calendar-plus', 'purple', 0),
	(206, 200, 'Working out what to set their DD at', 1, '', NULL, NULL, 'calculator', 'purple', 0),
	(207, 30, 'Metering Booking Forms', 1, '', 1, NULL, 'newspaper', '#0080c0', 0),
	(208, 107, 'Tariff Exceptions', 1, 'Warm Home Discount Information and other Tariff Exceptions', 0, NULL, 'id-badge', '#29bf22', 0),
	(209, 231, 'How to Set Reminders in freshdesk', 1, 'This could be used where you\'ve arranged to call back the customer at a later date or that you need to update them re a complaint. Waiting for a BO ticket reply etc..', 0, NULL, 'calendar-alt', 'Purple', 0),
	(211, 2, 'Check Direct Debit Subscription in GoCardless', 1, '', 0, NULL, 'credit-card', '#f29b1a', 0),
	(212, NULL, 'Update Member Details', 1, '', 26, NULL, 'folder-plus', 'black', 2),
	(214, 212, 'Add/Update Email Address', 1, '', 0, NULL, 'mail-bulk', 'black', 0),
	(215, 212, 'Add/Update Telephone Number', 1, '', 1, NULL, 'phone', 'black', 0),
	(216, 212, 'Change Name on the Account', 1, '', 2, NULL, 'person-booth', 'black', 0),
	(217, 212, 'Customer\'s name has Incorrect Spelling', 1, 'We should also use this process to correct where the Customer\'s forename and surname are back to front', NULL, NULL, 'file-contract', 'black', 0),
	(218, 212, 'Add a Secondary Account Holder', 1, '', NULL, NULL, 'people-carry', NULL, 0),
	(219, 212, 'Change Address', 1, '', NULL, NULL, 'warehouse', 'black', 0),
	(220, NULL, 'Erroneous Transfers', 1, '', 10, NULL, 'train', '#ef1c10', 1),
	(221, 220, 'Useful links', 1, 'Useful Websites where both ourselves and the customer can find more information on Erroneous Transfers and what it means.', 3, NULL, 'external-link-alt', '#ef1c10', 0),
	(223, NULL, 'Disputes', 1, '', 8, NULL, 'angry', 'black', NULL),
	(224, 223, 'Follow up on a Dispute', 1, '', 1, NULL, 'binoculars', 'black', 0),
	(225, NULL, 'Ability to Pay & Consumption', 1, 'If a customer is struggling to pay or top up their meter we should recognise this and support them best we can', 0, NULL, 'hands-helping', 'black', NULL),
	(226, 225, 'Energy Saving Tips', 1, 'We should always try and help the customer in reducing their energy use', 0, NULL, 'temperature-high', 'black', 0),
	(227, 225, 'Organisations for Financial Support', 1, 'useful links to organisation that can help with both financial support and Debt Support', 3, NULL, 'pound-sign', 'black', 0),
	(228, NULL, 'Home Move', 1, '', 12, NULL, 'trailer', '#29bf22', 1),
	(229, 228, 'Online move out forms', 1, 'Links to the online move out form', 1, NULL, 'desktop', '#29bf22', 0),
	(230, 228, 'Online Move in Forms', 1, 'Links to the online move in form', 2, NULL, 'desktop', '#29bf22', 0),
	(231, NULL, 'Freshdesk', 1, NULL, 11, NULL, 'ticket-alt', 'Purple', 1),
	(232, 231, 'How to Raise a Child Ticket', 1, 'Raise a child ticket for support from other departments', 1, NULL, 'child', 'Purple', 0),
	(233, NULL, 'Online Portal', 1, '', 19, NULL, 'laptop', '#29bf22', 2),
	(234, 233, 'Re-Send Portal Invite', 1, '', 2, NULL, 'route', '#29bf22', 0),
	(235, 225, 'Energy Saving Links', 1, '', 1, NULL, 'external-link-alt', 'black', 0),
	(236, 220, '1 2 3', 1, 'After recognising an ET we must follow this process. We may have to reject the ET request if not followed.', 2, NULL, 'database', '#ef1c10', 0),
	(237, 164, 'Leaving a Message', 1, 'guidelines for when we make an outbound call - We may need to leave a message with someone or a voicemail and we need to protect their data.', 4, NULL, 'voicemail', 'black', 0),
	(238, NULL, 'Ensek', 1, '', 9, NULL, 'globe-europe', 'black', 1),
	(239, 238, 'Gas Meter Account Search Guide', 1, '', 1, NULL, 'fire', 'black', 0),
	(240, 238, 'Electric Meter Account Search Guide', 1, '', 2, NULL, 'lightbulb', 'black', 0),
	(241, 238, 'MPAN Flows', 1, 'link to a full list of Ensek Electric flows (MPAN FLOWS) and what each one means', 3, NULL, 'wind', 'black', 0),
	(242, 225, 'Meter Deductions', 1, 'A member may inform us that they have topped up and their balance is showing less than the amount they topped up with.', 2, NULL, 'money-bill-wave', 'black', 0),
	(243, 247, 'Useful Numbers', 1, '', 0, NULL, 'phone-volume', 'black', 0),
	(244, 238, 'Account Health Check', 1, '7 Steps we should follow every time we check an account in Ensek on every call', 0, NULL, 'band-aid', 'black', 0),
	(245, 30, 'Meter Moves', 1, '', 9, NULL, 'remove-format', '#0080c0', 0),
	(246, 225, 'Consumption Queries', 1, 'Member advises they are using more energy than normal', 4, NULL, 'folder-open', 'black', 0),
	(247, NULL, 'Useful Info', 1, NULL, 27, NULL, 'folder-open', 'black', 2),
	(248, 247, 'Useful Links', 1, NULL, 1, NULL, NULL, NULL, 0),
	(249, 166, 'Switching Sites', 1, 'Link to Switching Site Reference codes and the companies that they refer to', 3, NULL, 'folder-open', 'ForestGreen', 0),
	(250, 166, 'Right to be Forgotten', 1, 'When a member requests to have their details removed', NULL, NULL, '', 'ForestGreen', 0),
	(251, 225, 'Discretionary Credit', 1, NULL, NULL, NULL, NULL, NULL, 0);
/*!40000 ALTER TABLE `category` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
