
CREATE TABLE IF NOT EXISTS `stealth_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial_no` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `shopper_id` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `quarter` tinyint(1) DEFAULT NULL,
  `approved` tinyint(1) DEFAULT '0',
  `approved_date` datetime DEFAULT NULL,
  `sdate` date DEFAULT NULL,
  `comments` text,
  `INTNR` char(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `score_1_max` decimal(10,0) DEFAULT NULL,
  `score_2_max` decimal(10,0) DEFAULT NULL,
  `score_3_max` decimal(10,0) DEFAULT NULL,
  `score_4_max` decimal(10,0) DEFAULT NULL,
  `score_5_max` decimal(10,0) DEFAULT NULL,
  `score_6_max` decimal(10,0) DEFAULT NULL,
  `score_7_max` decimal(10,0) DEFAULT NULL,
  `score_7a_max` decimal(10,0) DEFAULT NULL,
  `score_7b_max` decimal(10,0) DEFAULT NULL,
  `total_max` decimal(10,0) DEFAULT NULL,
  `score_1_point` decimal(10,0) DEFAULT NULL,
  `score_2_point` decimal(10,0) DEFAULT NULL,
  `score_3_point` decimal(10,0) DEFAULT NULL,
  `score_4_point` decimal(10,0) DEFAULT NULL,
  `score_5_point` decimal(10,0) DEFAULT NULL,
  `score_6_point` decimal(10,0) DEFAULT NULL,
  `score_7_point` decimal(10,0) DEFAULT NULL,
  `score_7a_point` decimal(10,0) DEFAULT NULL,
  `score_7b_point` decimal(10,0) DEFAULT NULL,
  `total_point` decimal(10,0) DEFAULT NULL,
  `score_1_perc` decimal(10,0) DEFAULT NULL,
  `score_2_perc` decimal(10,0) DEFAULT NULL,
  `score_3_perc` decimal(10,0) DEFAULT NULL,
  `score_4_perc` decimal(10,0) DEFAULT NULL,
  `score_5_perc` decimal(10,0) DEFAULT NULL,
  `score_6_perc` decimal(10,0) DEFAULT NULL,
  `score_7_perc` decimal(10,0) DEFAULT NULL,
  `score_7a_perc` decimal(10,0) DEFAULT NULL,
  `score_7b_perc` decimal(10,0) DEFAULT NULL,
  `total_perc` decimal(10,0) DEFAULT NULL,
  `INTTIME` char(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `SCRCNT` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `INTERNR` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `STIME` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V9009` int(1) DEFAULT NULL,
  `V1001` int(2) DEFAULT NULL,
  `V9000` int(3) DEFAULT NULL,
  `V6_1` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V6_2` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V6_3` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V7` int(1) DEFAULT NULL,
  `V8` int(1) DEFAULT NULL,
  `V9_1` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V9110` char(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V11_1` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V12` int(1) DEFAULT NULL,
  `V13` int(1) DEFAULT NULL,
  `V913` int(1) DEFAULT NULL,
  `V14_1` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V14_2` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V14_3` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V15` int(1) DEFAULT NULL,
  `V200` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V16` int(1) DEFAULT NULL,
  `V201` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V17` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V18` int(1) DEFAULT NULL,
  `V19` int(1) DEFAULT NULL,
  `V20_1` char(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V21` int(1) DEFAULT NULL,
  `V23` int(1) DEFAULT NULL,
  `V24` char(5) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V25` int(1) DEFAULT NULL,
  `V26` int(1) DEFAULT NULL,
  `V27` int(1) DEFAULT NULL,
  `V202` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V28` int(1) DEFAULT NULL,
  `V204` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V29` int(1) DEFAULT NULL,
  `V205` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V30` int(1) DEFAULT NULL,
  `V206` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V31` int(1) DEFAULT NULL,
  `V207` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V32` int(1) DEFAULT NULL,
  `V208` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V33` int(1) DEFAULT NULL,
  `V209` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V34` int(1) DEFAULT NULL,
  `V210` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V35` int(1) DEFAULT NULL,
  `V211` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V36` int(1) DEFAULT NULL,
  `V212` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V37` int(1) DEFAULT NULL,
  `V214` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V38` int(1) DEFAULT NULL,
  `V215` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V40` int(1) DEFAULT NULL,
  `V216` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V41` int(1) DEFAULT NULL,
  `V217` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V42` int(1) DEFAULT NULL,
  `V218` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V43` int(1) DEFAULT NULL,
  `V44` int(1) DEFAULT NULL,
  `V220` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V45` int(1) DEFAULT NULL,
  `V221` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V46` int(1) DEFAULT NULL,
  `V222` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V47` int(1) DEFAULT NULL,
  `V223` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V224` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V48` int(1) DEFAULT NULL,
  `V225` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V49` int(1) DEFAULT NULL,
  `V226` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V50` int(1) DEFAULT NULL,
  `V227` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V51` int(1) DEFAULT NULL,
  `V228` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V52` int(1) DEFAULT NULL,
  `V229` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V53` int(1) DEFAULT NULL,
  `V230` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V54` int(1) DEFAULT NULL,
  `V231` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V232` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V55` int(1) DEFAULT NULL,
  `V233` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V234` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V56` int(1) DEFAULT NULL,
  `V235` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V57` int(1) DEFAULT NULL,
  `V236` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V237_1` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V237_2` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V237_3` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V237_4` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V237_5` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V237_6` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V61` int(1) DEFAULT NULL,
  `V62` int(1) DEFAULT NULL,
  `V239` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V63` int(1) DEFAULT NULL,
  `V240` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V64` int(1) DEFAULT NULL,
  `V241` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V65` int(1) DEFAULT NULL,
  `V242` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V66` int(1) DEFAULT NULL,
  `V243` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V67` int(1) DEFAULT NULL,
  `V244` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V68` int(1) DEFAULT NULL,
  `V245` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V69` int(1) DEFAULT NULL,
  `V246` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V70` int(1) DEFAULT NULL,
  `V247` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V71` int(1) DEFAULT NULL,
  `V248` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V72` int(1) DEFAULT NULL,
  `V249` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V73` int(1) DEFAULT NULL,
  `V74` int(1) DEFAULT NULL,
  `V251` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V75` int(1) DEFAULT NULL,
  `V252` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V253_1` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V253_2` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V253_3` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V253_4` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V253_5` char(2) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V76` int(1) DEFAULT NULL,
  `V254` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V77` int(1) DEFAULT NULL,
  `V255` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V78` int(1) DEFAULT NULL,
  `V256` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V79` int(1) DEFAULT NULL,
  `V257` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V80` int(1) DEFAULT NULL,
  `V258` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V81` int(1) DEFAULT NULL,
  `V259` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V82` int(1) DEFAULT NULL,
  `V260` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V83` int(1) DEFAULT NULL,
  `V261` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V84` int(1) DEFAULT NULL,
  `V262` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V85` int(1) DEFAULT NULL,
  `V263` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V86` int(1) DEFAULT NULL,
  `V264` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V87` int(1) DEFAULT NULL,
  `V88` int(1) DEFAULT NULL,
  `V265` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V89` int(1) DEFAULT NULL,
  `V266` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V90` int(1) DEFAULT NULL,
  `V267` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V91` int(1) DEFAULT NULL,
  `V268` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V92` int(1) DEFAULT NULL,
  `V269` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V93` int(1) DEFAULT NULL,
  `V270` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V94` int(1) DEFAULT NULL,
  `V271` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V95` int(1) DEFAULT NULL,
  `V272` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V96` int(1) DEFAULT NULL,
  `V273` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V97` int(1) DEFAULT NULL,
  `V274` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V98` int(1) DEFAULT NULL,
  `V275` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V276` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V99` int(1) DEFAULT NULL,
  `V277` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V100` int(1) DEFAULT NULL,
  `V278` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V101` int(1) DEFAULT NULL,
  `V279` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V102` int(1) DEFAULT NULL,
  `V280` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V103` int(1) DEFAULT NULL,
  `V281` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V104` int(1) DEFAULT NULL,
  `V282` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V105` int(1) DEFAULT NULL,
  `V283` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V284` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V106` int(1) DEFAULT NULL,
  `V285` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V107` int(1) DEFAULT NULL,
  `V286` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V108` int(1) DEFAULT NULL,
  `V287` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V109` int(1) DEFAULT NULL,
  `V288` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V289_1` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V289_2` char(4) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V289_3` varchar(76) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V110` int(1) DEFAULT NULL,
  `V290` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `V9999` int(1) DEFAULT NULL,
  `V1200` char(3) DEFAULT NULL,
  `V1201` char(3) DEFAULT NULL,
  `V1202` char(3) DEFAULT NULL,
  `V1203` char(3) DEFAULT NULL,
  `V1204` char(3) DEFAULT NULL,
  `V1205` char(3) DEFAULT NULL,
  `V1206` char(3) DEFAULT NULL,
  `V1207` char(3) DEFAULT NULL,
  `V1300` char(3) DEFAULT NULL,
  `V1301` char(3) DEFAULT NULL,
  `V1302` char(3) DEFAULT NULL,
  `V1303` char(3) DEFAULT NULL,
  `V1304` char(3) DEFAULT NULL,
  `V1305` char(3) DEFAULT NULL,
  `V1306` char(3) DEFAULT NULL,
  `V1307` char(3) DEFAULT NULL,
  `V1400` char(3) DEFAULT NULL,
  `V1401` char(3) DEFAULT NULL,
  `V1402` char(3) DEFAULT NULL,
  `V1403` char(3) DEFAULT NULL,
  `V1404` char(3) DEFAULT NULL,
  `V1405` char(3) DEFAULT NULL,
  `V1406` char(3) DEFAULT NULL,
  `V1407` char(3) DEFAULT NULL,
  `client_open` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `stealth_dmap` (
  `dfields` varchar(40) DEFAULT NULL,
  `ftype` varchar(40) DEFAULT NULL,
  `pos` int(11) DEFAULT NULL,
  `len` int(11) DEFAULT NULL,
  `fdesc` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT IGNORE INTO `stealth_dmap` (`dfields`, `ftype`, `pos`, `len`, `fdesc`) VALUES
	('INTNR', 'CHAR', 1, 8, 'Interview number'),
	('INTTIME', 'CHAR', 11, 5, 'Interview duration (sec)'),
	('SCRCNT', 'CHAR', 16, 4, 'Screen count'),
	('INTERNR', 'TEK', 21, 8, 'Interviewer number'),
	('STIME', 'TEK', 29, 12, 'Start time'),
	('V9009', 'SNG', 61, 1, 'Questionire Type'),
	('V1001', 'SNG', 62, 2, 'Q.CITY'),
	('V9000', 'SNG', 64, 3, 'BRANCH CODE'),
	('serial_no', 'TEK', 67, 15, 'Serial No.'),
	('shopper_id', 'TEK', 82, 5, 'Shopper ID NO'),
	('V6_1', 'CHAR', 87, 2, 'Date'),
	('V6_2', 'CHAR', 89, 2, 'MONTH'),
	('V6_3', 'CHAR', 91, 2, 'YEAR'),
	('V7', 'SNG', 93, 1, 'Day.'),
	('V8', 'SNG', 94, 1, 'TIMING-'),
	('V9_1', 'CHAR', 95, 4, 'Hrs -'),
	('V9110', 'CHAR', 99, 1, 'Please Select'),
	('V11_1', 'CHAR', 100, 4, 'Hrs'),
	('V12', 'SNG', 104, 1, 'Please Select'),
	('V13', 'SNG', 105, 1, 'Q1.'),
	('V913', 'SNG', 106, 1, 'Q2.'),
	('V14_1', 'TEK', 107, 100, 'Question 14'),
	('V14_2', 'TEK', 207, 100, 'Question 14'),
	('V14_3', 'TEK', 307, 100, 'Question 14'),
	('V15', 'SNG', 407, 1, '1.Environment - EXTERNAL Q1. Entrance Doors/windows were clean Free of accumulated dirt, excessive fingerprints. 0'),
	('V200', 'TEK', 408, 50, 'Notes, If any'),
	('V16', 'SNG', 458, 1, '1. Environment - EXTERNAL Q2.Working hours signboard available in entarnce (Please check the day if including Thrusday) <?>'),
	('V201', 'TEK', 459, 80, 'Notes, If any'),
	('V17', 'TEK', 539, 50, '1. Environment - EXTERNAL Q3. How many ATM machines outside the branch (Drive Through)? Record the number'),
	('V18', 'SNG', 589, 1, 'Q4.ATM machine located outside the branch (Drive Through) working & in good condition?'),
	('V19', 'SNG', 590, 1, '1. Environment - EXTERNAL Q5. ATM machine screen located outside the branch (Drive Through) was clear?'),
	('V20_1', 'CHAR', 591, 5, 'Question 20'),
	('V21', 'SNG', 596, 1, '2. ATM Machines (ATM & CDM) Q2.Withdrawal ATM machine located in the main entrance working & in good condition?'),
	('V23', 'SNG', 597, 1, '2. ATM Machines (ATM & CDM) Q3. Withdrawal ATM machine screen was clear?'),
	('V24', 'CHAR', 598, 5, '2.ATM Machines (ATM & CDM) Q4. How many ATM machine (Cash deposit machine-CDM) in the main entrance? Record the numbers'),
	('V25', 'SNG', 603, 1, '2. ATM Machines (ATM & CDM) Q5.Cash deposit ATM machine located in the main entrance working & in good condition?'),
	('V26', 'SNG', 604, 1, '2.ATM Machines (ATM & CDM) Q6.Cash deposit ATM machine screen was clear?'),
	('V27', 'SNG', 605, 1, '2. ATM Machines (ATM & CDM) Q7. Surrounding area of the ATM was clean?'),
	('V202', 'TEK', 606, 80, 'Notes, If any'),
	('V28', 'SNG', 686, 1, '2. ATM Machines (ATM & CDM) <?> Q8. Are there any posters/ stickers don\'t belong to the bank on the ATM?'),
	('V204', 'TEK', 687, 50, 'Notes, If any'),
	('V29', 'SNG', 737, 1, '2.ATM Machines (ATM & CDM) <?> Q9.Are there any clear posters/ stickers belong to the bank on the ATM?'),
	('V205', 'TEK', 738, 80, 'Notes, If any'),
	('V30', 'SNG', 818, 1, 'Q10. Banking Telephone cabin beside the ATM was available (Always located beside ATMs)? <?>'),
	('V206', 'TEK', 819, 50, 'Notes, If any'),
	('V31', 'SNG', 869, 1, 'Q11. Banking Telephone cabin beside the ATM was working & in good condition (Please picked up & tried)? <?>'),
	('V207', 'TEK', 870, 80, 'Notes, If any'),
	('V32', 'SNG', 950, 1, '3.Security Guard Q1.Security guard available in the branch?'),
	('V208', 'TEK', 951, 80, 'Notes, If any'),
	('V33', 'SNG', 1031, 1, '3.Security Guard <?> Q2. Was security guard weariny clean & suitable closths?'),
	('V209', 'TEK', 1032, 80, 'Notes, If any'),
	('V34', 'SNG', 1112, 1, '<?> Q3.Security guard offer any helps regarding your transaction?'),
	('V210', 'TEK', 1113, 80, 'Notes, If any'),
	('V35', 'SNG', 1193, 1, '4.Queue Machine System (QMS) evaluation Not available in ladies branches Please take queue number for Teller Q1.Electrical queue machine (QMS) was available? 0'),
	('V211', 'TEK', 1194, 80, 'Notes, If any'),
	('V36', 'SNG', 1274, 1, '4.Queue Machine System (QMS) evaluation Not available in ladies branches Please take queue number for Teller Q2.Electraical queue machine (QM\\'),
	('V212', 'TEK', 1275, 80, 'Notes, If any'),
	('V37', 'SNG', 1355, 1, '4.Queue Machine System (QMS) evaluation Q3. Queue machine screen was clear and in good condition? <?>'),
	('V214', 'TEK', 1356, 80, 'Notes, If any'),
	('V38', 'SNG', 1436, 1, '4.Queue Machine System (QMS) evaluation Not available in ladies branches Q4.Did you take number from QMS by yourself <?>'),
	('V215', 'TEK', 1437, 80, 'Notes, If any'),
	('V40', 'SNG', 1517, 1, '5.Environment - INTERNAL Q1.The Floors/ Carpet were clean - entryway and reception area should be free of accumulated trash. 0'),
	('V216', 'TEK', 1518, 80, 'Notes, If any'),
	('V41', 'SNG', 1598, 1, '5.Environment - INTERNAL Q2.Was the furnitures (Chairs, Tables, desks) in good condition <?>'),
	('V217', 'TEK', 1599, 80, 'Notes, If any'),
	('V42', 'SNG', 1679, 1, '5.Environment - INTERNAL Q3.Was a signs inside the main lobby well arrange <?>'),
	('V218', 'TEK', 1680, 80, 'Notes, If any'),
	('V43', 'SNG', 1760, 1, '5.Environment - INTERNAL Q4.The lights were in a good condition <?>'),
	('V44', 'SNG', 1841, 1, '5.Environment - INTERNAL Q5.The Air-conditions was working and in good condition <?>'),
	('V220', 'TEK', 1842, 80, 'Notes, If any'),
	('V45', 'SNG', 1922, 1, '5.Environment - INTERNAL Q6.Was offices / desks well arrange <?>'),
	('V221', 'TEK', 1923, 80, 'Notes, If any'),
	('V46', 'SNG', 2003, 1, '5.Environment - INTERNAL Q7.Were the Plasma screens TV available in the main lobby? <?>'),
	('V222', 'TEK', 2004, 80, 'Notes, If any'),
	('V47', 'SNG', 2084, 1, '5.Environment - INTERNAL Q8.Plasma screens TV were working & show up advertising material (for example; currency & price line in blue and red colors? <?>'),
	('V223', 'TEK', 2085, 80, 'Please discribe the advertising shows on the screen'),
	('V224', 'TEK', 2165, 80, 'Notes, If any'),
	('V48', 'SNG', 2245, 1, '5.Environment - INTERNAL Q9.Branch stands in white and blue colors was available, including brochures / flyers - from the first side (Know your rights and obligations) and from the second side (we care) - or brochures / flyers form competitors banks. <?>'),
	('V225', 'TEK', 2246, 80, 'Notes, If any'),
	('V49', 'SNG', 2326, 1, '5.Environment - INTERNAL Q10.Branch stands in white and blue colors was available and full of brochures / flyers ; <?>'),
	('V226', 'TEK', 2327, 80, 'Notes, If any'),
	('V50', 'SNG', 2407, 1, '5.Environment - INTERNAL Q11.Branch stands in white and blue colors was available and in good condition not broken; <?>'),
	('V227', 'TEK', 2408, 80, 'Notes, If any'),
	('V51', 'SNG', 2488, 1, '5.Environment - INTERNAL Q12.Screen for Token number was working in front of the Teller & CSR sections; <?>'),
	('V228', 'TEK', 2489, 80, 'Notes, If any'),
	('V52', 'SNG', 2569, 1, '5.Environment - INTERNAL Q13. Cash deposit / Cheque deposit forms available? Usually beside teller in stand <?>'),
	('V229', 'TEK', 2570, 80, 'Notes, If any'),
	('V53', 'SNG', 2650, 1, '5.Environment - INTERNAL Q14.Employees was not talking in <?>'),
	('V230', 'TEK', 2651, 80, 'Notes, If any'),
	('V54', 'SNG', 2731, 1, '5.Environment - INTERNAL Q15. Did you notice Marketing stands specially for (Personal loans, Credit cards, accounting for cards) <?>'),
	('V231', 'TEK', 2732, 80, 'Please write down which available'),
	('V232', 'TEK', 2812, 80, 'Notes, If any'),
	('V55', 'SNG', 2892, 1, '5.Environment - INTERNAL Q16. Did you notice available broucher /flyers for example (Classic credit cards, ANB rewards More and more, Personal loans, ANB electronic channels)'),
	('V233', 'TEK', 2893, 80, 'Please write down which available'),
	('V234', 'TEK', 2973, 80, 'Notes, If any'),
	('V56', 'SNG', 3053, 1, '5.Internet Zone Q1.Internet zone station was available'),
	('V235', 'TEK', 3054, 80, 'Notes, If any'),
	('V57', 'SNG', 3134, 1, '5.Internet Zone Q2. Internet zone station was working in good condition (Try to access to Arabinet.com website), Note; If main page appeared that means it working arabinet.com <?>'),
	('V236', 'TEK', 3135, 80, 'Notes, If any'),
	('V237_1', 'CHAR', 3215, 4, 'How many counters for Teller?'),
	('V237_2', 'CHAR', 3219, 2, 'How many customers waiting on the queue'),
	('V237_3', 'CHAR', 3221, 2, '1'),
	('V237_4', 'CHAR', 3223, 2, '2'),
	('V237_5', 'CHAR', 3225, 2, '3'),
	('V237_6', 'CHAR', 3227, 4, '4'),
	('V61', 'SNG', 3231, 1, '6.Teller Q1.Teller counter was clean and neat 0'),
	('V62', 'SNG', 3312, 1, 'Q2. Teller was well groomed? <?>'),
	('V239', 'TEK', 3313, 80, 'Notes, If any'),
	('V63', 'SNG', 3393, 1, 'Q3. Teller was wearing Name Tag <?>'),
	('V240', 'TEK', 3394, 80, 'Notes, If any'),
	('V64', 'SNG', 3474, 1, 'Q4. The teller greeted you in a friendly manner using words like (Al Salam Alykoom, how are you, any other greeting statement)? <?>'),
	('V241', 'TEK', 3475, 80, 'Notes, If any'),
	('V65', 'SNG', 3555, 1, 'Q5. (In case you waited in front of Teller) did he thanks you for waiting <?>'),
	('V242', 'TEK', 3556, 80, 'Notes, If any'),
	('V66', 'SNG', 3636, 1, 'Q6. Teller treat you in nice way with smile face <?>'),
	('V243', 'TEK', 3637, 80, 'Notes, If any'),
	('V67', 'SNG', 3717, 1, 'Q7. Did teller spoke to you in clear voice? <?>'),
	('V244', 'TEK', 3718, 80, 'Notes, If any'),
	('V68', 'SNG', 3798, 1, 'Q8. In case if you want to pay bill (Non-account holder) did teller refused to complete the transaction? <?> No, he complete the transaction'),
	('V245', 'TEK', 3799, 80, 'Notes, If any'),
	('V69', 'SNG', 3879, 1, 'Q9. During the implementation of the transaction did teller give you full attention (there had been no interrupt / or was talking with a col\\'),
	('V246', 'TEK', 3880, 80, 'Notes, If any'),
	('V70', 'SNG', 3960, 1, 'Q10. Did employee apologize for interruption (if happened) <?>'),
	('V247', 'TEK', 3961, 80, 'Notes, If any'),
	('V71', 'SNG', 4041, 1, 'Q11.Did Teller mentioned electronic services banking offered by bank (or other banking services in case you have account) <?>'),
	('V248', 'TEK', 4042, 80, 'Notes, If any'),
	('V72', 'SNG', 4122, 1, '6.€ ?¥€? (??¡„ € ?„?‘?) ?„ ?™ á ??? € ??€? � Q12. Teller thanked you and asked you whether he can be of further help, or says any goodbye statement after completed transaction? <?>'),
	('V249', 'TEK', 4123, 80, 'Notes, If any'),
	('V73', 'SNG', 4203, 1, '0 Q13.How long did teller complete your banking transaction, please mention the time; <?>'),
	('V74', 'SNG', 4284, 1, 'Q14. Money counting machine for customers is available? (Usually beside to the teller) <?>'),
	('V251', 'TEK', 4285, 80, 'Notes, If any'),
	('V75', 'SNG', 4365, 1, 'Q15. Check money counting machine if it\'s working & in good condition (In case any other customer use it) <?>'),
	('V252', 'TEK', 4366, 80, 'Notes, If any <?>'),
	('V253_1', 'CHAR', 4446, 4, '7'),
	('V253_2', 'CHAR', 4450, 2, ''),
	('V253_3', 'CHAR', 4452, 2, ''),
	('V253_4', 'CHAR', 4454, 2, ''),
	('V253_5', 'CHAR', 4456, 2, ''),
	('V76', 'SNG', 4458, 1, '7.CSR evaluation Q1.CSR\'s desks were clean and neat 0'),
	('V254', 'TEK', 4459, 80, 'Notes, If any'),
	('V77', 'SNG', 4539, 1, '7. CSR evaluation Q2. CSR employee was well groomed? <?>'),
	('V255', 'TEK', 4540, 80, 'Notes, If any'),
	('V78', 'SNG', 4620, 1, '7. CSR evaluation Q3. CSR employee was wearing Name Tag <?>'),
	('V256', 'TEK', 4621, 80, 'Notes, If any'),
	('V79', 'SNG', 4701, 1, '7. CSR evaluation 4.Q4. The CSR employee greeted you in a friendly manner using words like (Al Salam Alykoom, how are you, any other greeting statment)? <?>'),
	('V257', 'TEK', 4702, 80, 'Notes, If any'),
	('V80', 'SNG', 4782, 1, '7. CSR evaluation Q5. (In case you waited in front of CSR) did he thanks you for waiting <?>'),
	('V258', 'TEK', 4783, 80, 'Notes, If any'),
	('V81', 'SNG', 4863, 1, '7. CSR evaluation Q6. CSR employee treat you in nice way with smile face <?>'),
	('V259', 'TEK', 4864, 80, 'Notes, If any'),
	('V82', 'SNG', 4944, 1, '7. CSR evaluation Q7.Did CSR employee spoke to you in clear voice? <?>'),
	('V260', 'TEK', 4945, 80, 'Notes, If any'),
	('V83', 'SNG', 5025, 1, '7.CSR evaluation Q8.Did CSR employee asked you about your name? <?>'),
	('V261', 'TEK', 5026, 80, 'Notes, If any'),
	('V84', 'SNG', 5106, 1, '7.CSR evaluation Q9.Did CSR employee mention your name? <?>'),
	('V262', 'TEK', 5107, 80, 'Notes, If any'),
	('V85', 'SNG', 5187, 1, '7.CSR evaluation Q10.During the implementation of the transaction did CSR give you full attention (there had been no interrupt / or was talking with a colleague / on the phone) <?>'),
	('V263', 'TEK', 5188, 80, 'Notes, If any'),
	('V86', 'SNG', 5268, 1, '7.CSR evaluation Q11.Did CSR employee apologize for interruption (if happened) <?>'),
	('V264', 'TEK', 5269, 80, 'Notes, If any'),
	('V87', 'SNG', 5349, 1, '<?>'),
	('V88', 'SNG', 5350, 1, '7A-Personal loans (for Saudi shoppers) Salary should be above (SR.10,000 - SR.11,000) , working with Electricity company or Water company for ladies Education sector for example; 10,400 to 11,500 Please attached the printed personal loans offered to you by CSR employee with questionnaire, if he doesn\'t give to you ask him. Q1.When you are waiting on CSR area, did any employee offer you help or assist you if you need? <?>'),
	('V265', 'TEK', 5351, 80, 'Notes, If any'),
	('V89', 'SNG', 5431, 1, 'Q2.CSR employee tried to understand your needs? <?>'),
	('V266', 'TEK', 5432, 80, 'Notes, If any'),
	('V90', 'SNG', 5512, 1, 'Q3. Did CSR employee clearly explain about product for example (Ratio, Fees, monthly payment)? <?>'),
	('V267', 'TEK', 5513, 80, 'Notes, If any'),
	('V91', 'SNG', 5593, 1, 'Q4.Did CSR employee spoke about documents and papers requirements for personal loans? <?>'),
	('V268', 'TEK', 5594, 80, 'Notes, If any'),
	('V92', 'SNG', 5674, 1, 'Q5.Did CSR employee spoke about competitive features (comparing with other banks) <?>'),
	('V269', 'TEK', 5675, 80, 'Notes, If any'),
	('V93', 'SNG', 5755, 1, 'Q6.Did CSR gave you folded Know your duties and your rights? <?>'),
	('V270', 'TEK', 5756, 80, 'Notes, If any'),
	('V94', 'SNG', 5836, 1, 'Q7. Did CSR employee tried to convince you to complete the deal to take funding? <?>'),
	('V271', 'TEK', 5837, 80, 'Notes, If any'),
	('V95', 'SNG', 5917, 1, 'Q8.Did CSR employee gave you copy of the condition and ruls and encouraged you to read it before committing to the product? <?>'),
	('V272', 'TEK', 5918, 80, 'Notes, If any'),
	('V96', 'SNG', 5998, 1, 'Q9.Did CSR employee gave you his definition card or his mobile number In order to connect in the future ( or he ask about your number)? <?>'),
	('V273', 'TEK', 5999, 80, 'Notes, If any'),
	('V97', 'SNG', 6079, 1, 'Q10. Did CSR employee said "thank you" or "can I help you with something else"? <?>'),
	('V274', 'TEK', 6080, 80, 'Notes, If any'),
	('V98', 'SNG', 6160, 1, '7B - Open Account For Saudi and Arab expats, ID cards must be with you before visiting the branch. Names must be matching Arabic with English. Q1.Did one of employee tried to ask you what you need or tried to help you in waiting time in CSR area? <?>'),
	('V275', 'TEK', 6161, 80, 'Notes, If any'),
	('V276', 'TEK', 6241, 80, 'Q2. Did CSR employee rejected to serve you and open an account to you? Note that it should not reject open an account process for anyone (out of score if there is a difference in Arabic name for it in English in residence) Please if____________ yes mention the reason'),
	('V99', 'SNG', 6321, 1, 'Q2. Did CSR employee rejected to serve you and open an account to you? Note that it should not reject open an account process for anyone (out of score if there is a difference in Arabic name for it in English in residence) <?>'),
	('V277', 'TEK', 6322, 80, 'Notes, If any'),
	('V100', 'SNG', 6402, 1, '7B - Open Account Q3. Did CSR employee fill out the request procedure by himself or request you to fill it?/ open an account. <?>'),
	('V278', 'TEK', 6403, 80, 'Notes, If any Notes, If any'),
	('V101', 'SNG', 6483, 1, '7B - Open Account Q4. Did CSR employee tried to understand you needs? <?>'),
	('V279', 'TEK', 6484, 80, 'Notes, If any'),
	('V102', 'SNG', 6564, 1, '7B - Open Account Q5. Did CSR employee explain the important requirement to open an account? <?>'),
	('V280', 'TEK', 6565, 80, 'Notes, If any'),
	('V103', 'SNG', 6645, 1, '7B - Open Account 0 Q6. Did CSR employee spoke on condition that you have to entrust amount of money while you open an account? <?>'),
	('V281', 'TEK', 6646, 80, 'Notes, If any'),
	('V104', 'SNG', 6726, 1, '7B - Open Account Q7. Did CSR employee Gave you admissions and the brochures of ( aaraf huqoqak and wajebatak) <?>'),
	('V282', 'TEK', 6727, 80, 'Notes, If any'),
	('V105', 'SNG', 6807, 1, '7B - Open Account Q8. Did CSR employee explain to you the advantage of services or Arabic channels (the electronic) (Arabic net, Arabic telephone, Arabic mobile?) or offered to you services or other products (for example personal finance or credit card). <?>'),
	('V283', 'TEK', 6808, 80, 'Please mention the product or service that the CSR employee tried to give you information / details about it.'),
	('V284', 'TEK', 6888, 80, 'Notes, If any'),
	('V106', 'SNG', 6968, 1, '7B - Open Account Q9. Did CSR employee gave you an ATM card? <?>'),
	('V285', 'TEK', 6969, 80, 'Notes, If any'),
	('V107', 'SNG', 7049, 1, '7B - Open Account Q10. Did CSR explain to you the way to activate an ATM card? <?>'),
	('V286', 'TEK', 7050, 80, 'Notes, If any'),
	('V108', 'SNG', 7130, 1, '7B - Open Account Q11. Did CSR employee gave you his definition card In order to connect in the future? <?>'),
	('V287', 'TEK', 7131, 80, 'Notes, If any'),
	('V109', 'SNG', 7211, 1, '7B - Open Account Q12. Did CSR employee say "thank you" or "can I help you with something else"? <?>'),
	('V288', 'TEK', 7212, 80, 'Notes, If any'),
	('V289_1', 'CHAR', 7292, 4, ''),
	('V289_2', 'CHAR', 7296, 4, ''),
	('V289_3', 'TEK', 7300, 76, ''),
	('V110', 'SNG', 7376, 1, '7B - Open Account <?>'),
	('V290', 'TEK', 7377, 200, 'Notes if any'),
	('V9999', 'SNG', 7577, 1, 'Please, check if the figures are similar to these MAX ACT % 1<?>'),
	('V1200', 'CHAR', 7578, 3, '1.Environment - External'),
	('V1201', 'CHAR', 7581, 3, '2.ATM machines-ATM , CDM'),
	('V1202', 'CHAR', 7584, 3, '3.Security guard'),
	('V1203', 'CHAR', 7587, 3, '4.Queue machine system-QMS'),
	('V1204', 'CHAR', 7590, 3, '5.Environment - Internal'),
	('V1205', 'CHAR', 7593, 3, '6.Teller'),
	('V1206', 'CHAR', 7596, 3, '7.CSR'),
	('V1207', 'CHAR', 7599, 3, 'TOTAL.ACD'),
	('V1300', 'CHAR', 7602, 3, '1.Environment - External'),
	('V1301', 'CHAR', 7605, 3, '2.ATM machines-ATM , CDM'),
	('V1302', 'CHAR', 7608, 3, '3.Security guard'),
	('V1303', 'CHAR', 7611, 3, '4.Queue machine system-QMS'),
	('V1304', 'CHAR', 7614, 3, '5.Environment - Internal'),
	('V1305', 'CHAR', 7617, 3, '6.Teller'),
	('V1306', 'CHAR', 7620, 3, '7.CSR'),
	('V1307', 'CHAR', 7623, 3, 'TOTAL.MAX'),
	('V1400', 'CHAR', 7626, 3, '1.Environment - External'),
	('V1401', 'CHAR', 7629, 3, '2.ATM machines-ATM , CDM'),
	('V1402', 'CHAR', 7632, 3, '3.Security guard'),
	('V1403', 'CHAR', 7635, 3, '4.Queue machine system-QMS'),
	('V1404', 'CHAR', 7638, 3, '5.Environment - Internal'),
	('V1405', 'CHAR', 7641, 3, '6.Teller'),
	('V1406', 'CHAR', 7644, 3, '7.CSR'),
	('V1407', 'CHAR', 7647, 3, 'TOTAL.PER');

CREATE TABLE IF NOT EXISTS `stealth_qtr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `qrt_desc` varchar(30) DEFAULT NULL,
  `sdate` date DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `active` tinyint(3) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT IGNORE INTO `stealth_qtr` (`id`, `qrt_desc`, `sdate`, `edate`, `active`) VALUES
	(1, 'Quarter 1', '2014-01-01', '2014-12-31', 1);

