--
-- Host: localhost    Database: lifesavingrules
-- ------------------------------------------------------


--
-- Table structure for table `calendar`
--

CREATE TABLE `calendar` (
  `fechas` varchar(300) NOT NULL,
  `market` varchar(300) NOT NULL,
  `objectives` text NOT NULL,
  `category` varchar(300) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calendar`
--

INSERT INTO `calendar` VALUES ('Week 2 - January 8-13','Curacao & Aruba','LSR 2 HR Training & Sales Capability Visit & EOE Lite','January 2017',1),('Week 6 - Feb 6-10','Puerto Rico','LSR 2 HR Training & Sales Capability Training','February 2017',2),('Week 15 - April 10-13','Aruba & Curacao','LSR 2 HR Training & Sales Capability Update','April 2017',3),('Week 5 - Jan 30 - Feb 3','HUSA','PICOS Bootcamp WP NY','January 2017',7),('Week 4 - January 23-26','Paraguay','Sales Capability Training','January 2017',10),('Week 7 - Feb 13-17','Puerto Rico','LSR 2 HR Training & Sales Capability Training','February 2017',11),('Week 7 - February 14	','Cayman & Turks','LSR 2 HR Training Online Meeting','February 2017',12),('','','TTT LSR Training and Sales Capability Update to the following Markets \nLocation: Honduras \nMarkets Participating - Honduras, El Salvador \nTentative Date - Week 10 ','March - April 2017 - TTT Events',14),('','','TTT LSR Training and Sales Capability Update to the following Markets \nLocation: Martinique \nMarkets Participating - French Guyana, Guadalupe and Martinique \nTentative Date - Week 14 ','March - April 2017 - TTT Events',15),('','','TTT LSR Training and Sales Capability Update to the following Markets \r\nLocation: Trinidad \r\nMarkets Participating- Barbados, Guyana, St Kitts, Grenada, Trinidad\r\nTentative Date - Week 14','March - April 2017 - TTT Events',16),('','','TTT LSR Training and Sales Capability Update to the following Markets \nLocation: Guatemala \nMarkets Participating - Guatemala, Costa Rica, Nicaragua \nTentative Date - Week 10 ','March - April 2017 - TTT Events',17);

--
-- Table structure for table `formulario`
--

CREATE TABLE `formulario` (
  `natureOfInjury` text,
  `typeOfAccident` text,
  `typeOfCollision` text,
  `breachOfRuleYes` text,
  `detailsA` date DEFAULT NULL,
  `detailsB` varchar(300) DEFAULT NULL,
  `detailsC` varchar(300) DEFAULT NULL,
  `detailsE` varchar(300) DEFAULT NULL,
  `detailsF` varchar(300) DEFAULT NULL,
  `severityB` date DEFAULT NULL,
  `severityJ` date DEFAULT NULL,
  `severityL` varchar(300) DEFAULT NULL,
  `affectedPersonA` varchar(300) DEFAULT NULL,
  `affectedPersonB` varchar(300) DEFAULT NULL,
  `affectedPersonC` varchar(300) DEFAULT NULL,
  `affectedPersonF` varchar(300) DEFAULT NULL,
  `affectedPersonG` varchar(300) DEFAULT NULL,
  `medicalTreatmentC` varchar(300) DEFAULT NULL,
  `market` varchar(300) DEFAULT NULL,
  `detailsD` varchar(300) DEFAULT NULL,
  `detailsH` varchar(300) DEFAULT NULL,
  `objectSubstance` varchar(300) DEFAULT NULL,
  `detailsG` varchar(300) DEFAULT NULL,
  `bodyPartSeverity` varchar(300) DEFAULT NULL,
  `affectedPersonD` varchar(300) DEFAULT NULL,
  `affectedPersonE` varchar(300) DEFAULT NULL,
  `detailsG1` varchar(300) DEFAULT NULL,
  `fatality` varchar(300) DEFAULT NULL,
  `severityA` varchar(300) DEFAULT NULL,
  `severityC` varchar(300) DEFAULT NULL,
  `severityD` varchar(300) DEFAULT NULL,
  `severityE` varchar(300) DEFAULT NULL,
  `severityF` varchar(300) DEFAULT NULL,
  `severityG` varchar(300) DEFAULT NULL,
  `severityH` varchar(300) DEFAULT NULL,
  `severityI` varchar(300) DEFAULT NULL,
  `driverAtFault` varchar(300) DEFAULT NULL,
  `breachOfRule` varchar(300) DEFAULT NULL,
  `rootCauseA` varchar(300) DEFAULT NULL,
  `rootCauseB` varchar(300) DEFAULT NULL,
  `rootCauseC` varchar(300) DEFAULT NULL,
  `rootCauseD` varchar(300) DEFAULT NULL,
  `rootCauseE` varchar(300) DEFAULT NULL,
  `rootCauseF` varchar(300) DEFAULT NULL,
  `rootCauseG` varchar(300) DEFAULT NULL,
  `medicalTreatment` varchar(300) DEFAULT NULL,
  `medicalTreatmentB` varchar(300) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `formulario`
--


--
-- Table structure for table `keyval`
--

CREATE TABLE `keyval` (
  `nombre` varchar(200) NOT NULL,
  `humano` varchar(200) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orden` int(11) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `keyval`
--

INSERT INTO `keyval` VALUES ('detailsA','Date of case:',1,1),('detailsB','Time of case:',2,2),('detailsC','Title/subject:',3,3),('detailsD','Description of case:',4,4),('detailsE','Site:',5,5),('detailsF','OpCo:',6,6),('severityA','Involves a fatality?',7,9),('severityB','Date of death:',8,11),('severityC','Involves near fatalities involving amputation of a limb or loss of an eye? ',9,12),('severityD','Involves head injuries resulting in prolonged coma? ',10,13),('severityE','Involves unconsciousness or hospitalization for more than 24 hours? ',11,14),('severityF','Involves more than four employees being injured? ',12,15),('severityG','The number of days lost is more than 3 lost days? ',13,16),('severityI','The number of days lost is less or =3? ',15,17),('severityJ','If Yes than fill in the date of the first lost day, returned to work date and day returned to normal duties (if someone worked partially after returned to work date).',16,18),('severityL','The number of days lost is Zero and concerns personal harm/medical treatment? ',18,20),('affectedPersonA','First name: ',19,21),('affectedPersonB','Last name: ',20,22),('affectedPersonC','Job Title: ',21,23),('affectedPersonF','Age: ',22,26),('affectedPersonG','Time employee began to work: ',23,27),('natureOfInjury','Select and describe the type(s) of accident:',24,28),('typeOfCollision','Type of Collision:',25,32),('medicalTreatmentC','Physician: ',26,44),('detailsG','Location Type',27,7),('bodyPartSeverity','Body part injured:',29,10),('affectedPersonD','Gender',30,24),('affectedPersonE','Employee type:',31,25),('typeOfAccident','Select the type(s) of accident from the list',32,29),('objectSubstance','Object or substance that harmed the employee:',33,30),('detailsG1','Type of vehicle:',34,31),('breachOfRule','Was there a breach of one or more Life Saving Rule(s)',35,33),('breachOfRuleYes','If there was a breach of rules, mark at least one option',36,34),('rootCauseA','WAS THE ACTION DELIBERATE?',37,35),('rootCauseB','WAS THE ACTION WELL INTENTIONED?',38,36),('rootCauseC','WAS THE EMPLOYEE OR CONTRACTOR EVIDENCE-BASED INFORMED ABOUT PROCEDURES',39,37),('rootCauseD','ARE RULES AND PROCEDURES CLEAR AND WORKABLE?',40,38),('rootCauseE','WOULD THEIR COLLEAGUES HAVE DONE THE SAME?',41,39),('rootCauseF','ADEQUATE SELECTION, TRAINING AND EXPERIENCE FOR THE TASK?',42,40),('rootCauseG','HISTORY OF BREAKING RULES?',43,41),('medicalTreatment','Person was treated in Emergency Room?',44,42),('medicalTreatmentB','Hospitalized overnight as inpatient.',45,43),('detailsH','Location details:',46,8);

--
-- Table structure for table `markets`
--

CREATE TABLE `markets` (
  `market` varchar(18) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pass` varchar(40) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `COL 1` (`market`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `markets`
--

INSERT INTO `markets` VALUES ('Antigua/Barbuda',1,'heineken513'),('Aruba',2,'heineken547'),('Bermuda',3,'heineken487'),('Barbados',4,'heineken966'),('Belize',5,'heineken411'),('Bolivia',6,'heineken668'),('Martinique',7,'heineken226'),('Canada',8,'heineken491'),('Cayman Islands',9,'heineken788'),('Colombia',10,'heineken419'),('Costa Rica',11,'heineken753'),('Curacao',12,'heineken130'),('Dom. Republic',13,'heineken513'),('Dominica',14,'heineken127'),('Ecuador',15,'heineken723'),('El Salvador',16,'heineken714'),('Grenada',17,'heineken206'),('Guatemala',18,'heineken273'),('Guyana',19,'heineken466'),('Honduras',20,'heineken413'),('French Guiana',21,'heineken630'),('Nicaragua',22,'heineken323'),('Paraguay',23,'heineken168'),('Peru',24,'heineken482'),('Puerto Rico',25,'heineken367'),('Guadeloupe',26,'heineken734'),('St. Barths',27,'heineken360'),('St Maarten',28,'heineken127'),('St. Kitts & Nevis',29,'heineken391'),('St. Vincent',30,'heineken579'),('Trinidad & Tobaggo',31,'heineken498'),('Turks & Caicos',32,'heineken804'),('USVI',33,'heineken126'),('Uruguay',34,'heineken884');

--
-- Table structure for table `passes`
--

CREATE TABLE `passes` (
  `market` varchar(100) NOT NULL,
  `pass` varchar(300) NOT NULL,
  PRIMARY KEY (`market`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `passes`
--

INSERT INTO `passes` VALUES ('Argentina','heineken294'),('Bahamas','heineken272'),('Brazil','heineken912'),('Canada','heineken768'),('Chile','heineken647'),('Colombia','heineken839'),('Costa Rica','heineken189'),('Haiti','heineken256'),('Jamaica','heineken326'),('Mexico','heineken409'),('Panama','heineken576'),('Paraguay','heineken611'),('Puerto Rico','heineken721'),('St. Lucia','heineken899'),('Suriname','heineken948'),('United States','heineken008'),('Uruguay','heineken886');

--
-- Table structure for table `questionnaire`
--

CREATE TABLE `questionnaire` (
  `location` varchar(300) NOT NULL,
  `position` varchar(30) NOT NULL,
  `name` varchar(300) NOT NULL,
  `quest1` varchar(50) NOT NULL,
  `quest2` varchar(50) NOT NULL,
  `quest3` varchar(50) NOT NULL,
  `quest4` varchar(50) NOT NULL,
  `quest5` varchar(50) NOT NULL,
  `quest6` varchar(50) NOT NULL,
  `quest7` varchar(30) NOT NULL,
  `comments` text NOT NULL,
  `id` varchar(100) NOT NULL,
  `quest8` varchar(40) NOT NULL,
  `quest9` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `questionnaire`
--

INSERT INTO `questionnaire` VALUES ('Costa Rica','ops','Beatriz Ontillera','Sometimes','Yes','Yes','Yes','Sometimes','No','Yes','','-ops','No','Yes'),('Belize','sales','Luis Riverol','Yes','Yes','Sometimes','Yes','Yes','Yes','Yes','Employees are not to answer phones or text while driving.. If its an urgent matter they are to pull over in order to answer the phone.','-sales','Yes','Yes'),('Antigua/ Barbuda','ops','John McDonald','No','No','Sometimes','Yes','No','Yes','No','','1-ops','Sometimes','Yes'),('Antigua/ Barbuda','sales','John McDonald','No','No','No','Yes','Sometimes','Yes','Yes','','1-sales','No','N/A'),('Costa Rica','ops','Henry Garcia','Yes','No','Sometimes','Yes','No','No','No','','10-ops','No','Sometimes'),('Costa Rica','sales','Carolina Vasquez','Yes','No','Sometimes','No','Yes','Yes','Yes','Accidents did not caused injuries.','10-sales','No','Yes'),('Curacao','ops','Gianni Koreman','Yes','Yes','Yes','Yes','Yes','Yes','Yes','','11-ops','Yes','Yes'),('Curacao','sales','Laura Garcia','Yes','Yes','Yes','No','','Yes','No','','11-sales','Yes','N/A'),('Dom. Republic','ops','Carlos Diaz','Yes','Yes','Yes','Yes','Yes','Yes','No','Our Warehouse Operations are managed by a 3PL – Frederic Schad,  whom is certified in BASC ','12-ops','Yes','Yes'),('Dominica','ops','Jenevieve Bully','Yes','Yes','Yes','Yes','Yes','Yes','No','','13-ops','Yes','Yes'),('Dominica','sales','Jenevieve Bully','Yes','Yes','No','Yes','Yes','Yes','No','With regard to mobile devices , we do not have hands free devices however our drivers are not allowed to use or answer their cell phones while driving.  ','13-sales','Yes','N/A'),('Ecuador','ops','Mauricio Fabara','Yes','Yes','Sometimes','Yes','Yes','Yes','No','','14-ops','Sometimes','Yes'),('Ecuador','sales','Juan Javier Ordoñez','Yes','Yes','Yes','No','Yes','Yes','No','','14-sales','Sometimes','Yes'),('El Salvador','ops','Arturo Serrano','Yes','Yes','Yes','Yes','Yes','No','Yes','','15-ops','Yes','Yes'),('El Salvador','sales','Edgar Benitez','Yes','Yes','Sometimes','No','Yes','Yes','Yes','','15-sales','Yes','N/A'),('Grenada','ops','Lincoln Baptiste','Yes','Yes','Yes','Yes','Yes','Yes','Yes','In relation to the last question, no major accidents due to nature of work with glass, for instance small cuts.  ','16-ops','Yes','Yes'),('Grenada','sales','Lincoln Baptiste','Yes','Yes','No','Yes','Yes','Yes','Yes','','16-sales','Yes','N/A'),('Guyana','ops','Troy Cadogan','Yes','Yes','Yes','Yes','Yes','Yes','No','','18-ops','Sometimes','No'),('Guyana','sales','Kelvin Singh','Yes','Yes','Yes','Sometimes','Yes','','No','','18-sales','Yes','Yes'),('Aruba','ops','Ramon Becker','Yes','Yes','Sometimes','Sometimes','Yes','Yes','Yes','Minor accidents','2-ops','Yes','Yes'),('Aruba','sales','Carlton Croes','Yes','Yes','No','No','No','Yes','Yes','','2-sales','No','N/A'),('Honduras','ops','Maribel Membreño','No','No','Sometimes','Yes','No','Sometimes','No','In the case of forklift operation policy it is done verbally, but i will start doing it in written signs,','20-ops','No','Yes'),('Honduras','sales','Miguel Mejia','No','No','No','No','Yes','Yes','No','Our company follows very strictly the Governments rules and regulations on placing a sticker with a warning regarding alcohol abuse in every bottle . This Institution named IHADFA controls this aspect , which is duly followed by Distribuciones AM.','20-sales','No','Yes'),('HSM (French Guiana)','ops','Sandrine Tsang','No','Yes','No','Yes','Yes','Yes','No','','21-ops','No','Yes'),('HSM (French Guiana)','sales','Eric Preddhome','No','Yes','Yes','Yes','Yes','Yes','No','','21-sales','No','Yes'),('Nicaragua','ops','Hector Chávez','Yes','Yes','Yes','Yes','Yes','Sometimes','Yes','','22-ops','Yes','Yes'),('Nicaragua','sales','Luis Lacayo','Yes','Yes','Sometimes','Yes','Yes','Yes','Yes','N/A','22-sales','Yes','N/A'),('Panamá','ops','Lionel Aleman','Yes','Yes','Sometimes','No','Yes','No','No','The majority of our handling and delivery of products is given to a third party company related to us. While we understand they have strong safety procedures we are not directly involved.','23-ops','Yes','No'),('Paraguay','ops','Nestor Romero','Yes','Yes','Yes','Yes','Yes','Yes','No','','24-ops','No','Yes'),('Paraguay','sales','Cynthia Romero','Yes','Yes','No','No','Yes','Yes','Yes','3 vidas en 4 años. En moto todos.\r\nCascos y dispositivo de manos libres, a pesar de tenerlos, no existe el hábito de usarlos.\r\nFalta refuerzo y control de la Política de Alcoholemia ','24-sales','Sometimes','Yes'),('Peru','ops','Elvira Torres','Yes','Yes','Yes','Yes','Yes','Yes','No','','25-ops','Yes','Yes'),('Peru','sales','Antonio Maccera','','','','','','','','','25-sales','',''),('Sodipa (Guadeloupe)','ops','Philippe Chastanet','Yes','Yes','No','Yes','Yes','Yes','No','','27-ops','No','Yes'),('Sodipa (Guadeloupe)','sales','Théodore Didier','Yes','Yes','Yes','Yes','Yes','Yes','No','','27-sales','No','N/A'),('St. Barths','ops','Didier Greaux','No','No','No','Yes','No','Yes','No','','28-ops','No','Yes'),('St. Barths','sales','Didier Greaux','No','No','Sometimes','No','Yes','Yes','No','','28-sales','No','N/A'),('St Maarten','ops','Luis Lagos','Yes','Yes','No','No','No','No','No','We are currently working on Fork Lift Procedures ','29-ops','Sometimes','Yes'),('St Maarten','sales','Chris Moore','Yes','Sometimes','Sometimes','Yes','Yes','','Yes','','29-sales','Sometimes','Yes'),('Bermuda','ops','Marc Drew','Yes','Yes','Sometimes','Sometimes','No','No','No','','3-ops','Yes','Sometimes'),('Bermuda','sales','Marc Drew','Yes','Yes','Sometimes','No','Sometimes','Yes','Yes','','3-sales','Yes','Yes'),('St. Kitts & Nevis','ops','Andre Amritt','Yes','No','Sometimes','Yes','No','No','No','','30-ops','Yes','No'),('St. Kitts & Nevis','sales','Andre Amritt','Yes','No','No','No','Yes','Yes','Yes','','30-sales','Yes','N/A'),('St. Vincent','ops','Carlton James','Yes','Yes','No','Sometimes','No','No','Yes','','31-ops','Yes','No'),('St. Vincent','sales','Carlton James','Yes','Yes','Sometimes','Yes','Yes','Yes','No','','31-sales','Yes','Yes'),('Turks & Caicos','ops','Anthony Garland','Yes','Yes','Yes','Yes','No','Yes','No','','32-ops','Yes','Yes'),('Turks & Caicos','sales','Anthony Bell','Yes','Yes','No','No','Yes','Yes','Yes','','32-sales','Yes','N/A'),('USVI','ops','Jean-Pierre Montegut','Yes','Yes','Yes','Yes','Yes','Yes','Yes','','33-ops','Yes','Yes'),('USVI','sales','Ron George','Yes','Yes','Sometimes','No','Yes','Yes','Yes','','33-sales','Yes','N/A'),('Barbados','ops','Dwaine Williams','No','No','Yes','Yes','No','No','Yes','No alcohol and substance abuse nor forklift polices but rules which ensures workers are fit for work and only license forklift drivers can operate forklifts are in place and is presented to all employees. ','4-ops','No','Yes'),('Barbados','sales','Kathy Peters','Yes','Yes','Sometimes','No','Yes','Yes','Yes','Mobile policy being drafted and will be in effect by mid year','4-sales','Yes','N/A'),('Belize','ops','Alfredo Guemez','Yes','Yes','Yes','Yes','Yes','Yes','Yes','','5-ops','Yes','Yes'),('Belize','sales','Luis Riverol','Yes','Yes','No','Yes','Yes','Yes','Yes','Our employees do no use hands free devices because they are not supposed to answer their phone while driving.','5-sales','Yes','Yes'),('Brasserie Lorraine (Martinique)','sales','Jean-FranÂois Simon','No','Yes','Yes','No','Yes','Yes','No','','6-sales','Sometimes','N/A'),('Cayman Islands','ops','Alain Ayala','Sometimes','Yes','Sometimes','Sometimes','Sometimes','Yes','No','','7-ops','No','Yes'),('Cayman Islands','sales','Mark Schofield','Sometimes','Sometimes','Yes','No','Yes','Yes','No','','7-sales','No','N/A'),('Colombia','ops','Juan Esteban Baraya','Yes','Yes','No','Yes','No','No','No','La política de Sustancias Psicoactivas fue Publicada vía e-mail a todos los trabajadores el 16-11-2016 e incluida en la Inducción de Seguridad a partir del 01-12-2016\r\nLa política de Consumo Responsable se divulga a todos los trabajadores en la Inducción Corporativa \r\nLa compañía no opera montacargas y tiene bodegas para su uso por lo cual no cuenta con almacenes y accidentes por este motivo','8-ops','No','No'),('Colombia','sales','Monica Londoño','Yes','Yes','No','No','No','Yes','Yes','La política de Sustancias Psicoactivas fue Publicada vía e-mail a todos los trabajadores el 16-11-2016 e incluida en la Inducción de Seguridad a partir del 01-12-2016\r\nLa política de Consumo Responsable se divulga a todos los trabajadores en la Inducción Corporativa \r\nLa compañía no tiene flota de vehículos por lo cual no se ha trabajado con el manejo de dispositivos móviles y el uso de manos libres durante la conducción\r\nEn el 2016 se presentaron 22 Accidentes de trabajo los cuales 14 son por accidentes de transito como peatones o conductores de motos ','8-sales','No','Yes');

--
-- Table structure for table `survey`
--

CREATE TABLE `survey` (
  `market` varchar(30) NOT NULL,
  `0.1` int(11) NOT NULL,
  `0.2` int(11) NOT NULL,
  `0.3` int(11) NOT NULL,
  `1.1` int(11) NOT NULL,
  `1.2` int(11) NOT NULL,
  `1.3` int(11) NOT NULL,
  `1.4` int(11) NOT NULL,
  `2.1` int(11) NOT NULL,
  `2.2` int(11) NOT NULL,
  `2.3` int(11) NOT NULL,
  `3.1` int(11) NOT NULL,
  `3.2` int(11) NOT NULL,
  `3.3` int(11) NOT NULL,
  `3.4` int(11) NOT NULL,
  `3.5` int(11) NOT NULL,
  `3.6` int(11) NOT NULL,
  `4.1` int(11) NOT NULL,
  `4.2` int(11) NOT NULL,
  `4.3` int(11) NOT NULL,
  `5.1` int(11) NOT NULL,
  `5.2` int(11) NOT NULL,
  `6.1` text NOT NULL,
  `6.2` text NOT NULL,
  `6.3` text NOT NULL,
  `6.4` text NOT NULL,
  `6.5` text NOT NULL,
  `completed` tinyint(1) NOT NULL,
  PRIMARY KEY (`market`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `survey`
--

INSERT INTO `survey` VALUES ('Argentina',1,1,2,0,1,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,'Currently in discussion with a small retailer Libertad (Groupe Casino) to implement category plans & solutions','','','One thing will not be enough, everyhting needs to be done.','',1),('Bahamas',1,0,0,0,1,0,0,0,1,0,1,1,1,0,1,1,0,0,0,1,1,'N/a','lack of customer understanding\r\n','lack of expertise','have dedicate personnel','',0),('Brazil',1,1,1,2,1,1,1,1,3,1,1,2,1,1,1,2,2,1,1,2,1,'We built a great JBP with Carrefour, Casino and WalMart.\r\nWe were able to discuss the category performance and trends, and discuss the 2017 market perspective.\r\nBased on that we defined clear targets in terms of revenue, by building a strong promotional calendar and engaging all of them with our plan.','','We have a good understanding about consumers, but the same does not happend with shoppers. So we have a lack of information, we have a lack of structure to support the process as well(with the Kirin acquisition we will envolve on that).','Have the right people / structure supporting the process in the customers that are prepare to have this planning process in place.','Great assessment!',1),('Canada',1,1,1,1,1,1,1,1,2,1,1,1,1,1,1,1,0,1,0,1,1,'','Unwillingness to collaborate with one beer supplier in an extremely competitive environment.  They can risk jeopardizing the relationship with other beer suppliers.\r\n\r\nMost customers have this type of function in house, lack of desire to collaborate with an external partner.','Lack of collaboration/info sharing with MCC since it is a distributor based relationship.  ','Get better buy in from the MCC team to collaborate with Heineken in category leadership.  The process should improve in 2018 when we begin to roll out PICoS/EoE.','',1),('Chile',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'','','','','',0),('Colombia',1,1,1,1,2,1,1,1,1,1,1,1,1,0,1,1,1,0,0,2,0,'','','1. We are so new operation in Country.\r\n2. Big lack of commercial data.\r\n3. Medium knowledge of beer category. ','Our operation es very new. We must let it advance.','',1),('Costa Rica',2,1,3,1,1,2,2,1,1,1,1,2,1,0,0,1,2,1,2,1,0,'We have done annual plan meeting with Supermarket chains such as Pricesmart, Walmart, to define JTBD, Pillars and Ways of Working to develop strong bases for the future.','','The use of data to build plans.\r\nOpportunity to increase permanent visibility to build brand credentials.\r\nBreakthrough Communication to communicate brand world and engage target and broad consumers.\r\nSurprise consumers and to influence at the moment of true','Use information in order to create innovative brand execution plans, that will drive volume, equity and ROI.\r\nTake advantage of innovation to drive penetration.\r\nThink out of the box and change the one size fits all mentality. ','',1),('Haiti',0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,2,0,'We have worked with several local Supermarket operators to improve the layout of their beer aisle using a basic level of sales data, but this has been at a superficial level.','In the Supermarket channel, our customers have little or no knowledge of category management and a lot of their ways of working are based on finding space for products they import and want to sell. The rest of the trade is very informal and even basic display and merchandising principles are not in place.','Lack of data, lack of resource, lack of skills / knowledge.','Be able to obtain and use category data to influence our customers in how to effectively maximize category sales.','',1),('Jamaica',1,1,1,1,1,1,0,0,1,0,1,1,0,0,1,1,1,0,0,2,1,'Hi Lo.  Contributed to the range and space allocation for the beer category in thre of their 13 stores which were renovated.','Lack of perceived benefit.  We are also a distributor for spirits but are not the category leaders, hence our competitors are the advisors on the spirits category.','Low skills, lack of shopper research, BWC is required, no space planning software or expertise.','Capability development for the Trade Marketing/Commercial teams in the area of Category Management.','',0),('Mexico',2,3,2,2,2,3,2,1,3,2,1,2,2,3,2,1,2,0,1,3,1,'Soriana - JBP\r\nDevelopment of Impulse to increase tickets with Beer.\r\nHEB - JBP\r\nWork in progress\r\nWalmart - Strategic Plan\r\nPromotional differentiation to avoid EDLP / Review of portfolio per store format\r\nOxxo - JBP\r\nDevelopment of Impulse / Complete review of planograms / New execution measurement\r\n','Customers are extremely willing to offer us Category Leadership, yet we constrantly face lack of internal resources so we need to limit our scope.','Lack of FTE´s and lack of Category mindset to really understand the opportunity.','Run Category Vision again, very urgent and very necessary.','',1),('Panamá',1,0,0,1,0,1,1,0,0,0,0,0,0,0,1,1,1,0,0,2,0,'Grupo Rey.- commercial agreement allowing us to test leading  category management in 10 stores.\r\nMachetazo.- commercial agreement letting us to develop the category management.\r\nPuma.- Working on JBP.','Lack of perceived benefits, this is a new culture in Panamá.','Lack of Software/ low knowledge and skills.\r\n\r\n','To have the software (spaceman), and to develop the skills in the team to manage It. ','Sharing CATMAN best practices of other OpCo. ',1),('Paraguay',0,1,0,1,1,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,'None','lack of perceived benefits','lack of good data, low skills','Develop the skills with the marketing & trade marketing team and the processes to implement it','',1),('Puerto Rico',2,1,2,1,1,0,0,1,1,1,1,3,1,3,0,1,1,0,0,1,0,'','  - Lack of understanding and knowledge (Trade Marketing)\r\n  -  Lack of perceived benefits (Key Accounts)','  - Low skills\r\n  - Lack of data\r\n  - Roles and responsibilities','  - Integrate Trade Marketing under the cycle planning process and commercial structure.\r\n','  - Hybrid modern trade with National US accounts as well as strong local accounts but with lack of structure, processes and data systems ',1),('St. Lucia',1,0,0,0,1,0,0,2,2,0,1,0,0,0,1,0,1,1,0,1,1,'Massy Stores\r\n1. Joint promotion with the Strongbow brand where shoppers purchasing the products win bonus Massy loyalty points.\r\n\r\n2. Carnival Pack promotion: Joint promotion where products such as Piton, Climax are featured in the carnival pack promoted by the supermarket chain to celebrate the carnival season. Our participating products are also on the communication used to promote. \r\n','The Massy Stores control the Modern Retail channel and so the exercise lots of control on what is done in their stores. In addition the supermarket chain also brings in their own products and give priority to their own. \r\n\r\nThey have become increasingly cooperative over the last 2 years.  ','All of the above mentioned..','Training in understanding category management and leadership ','',1),('Suriname',1,2,2,1,1,1,0,1,1,1,1,0,1,1,1,0,0,0,0,2,1,'','The majority of our customers are uneducated illegal Chinese workers who are only for a short time in Suriname, but make up for 70% of our Volume and Revenue. There is no chain of Supermarkets like Albert Heyn or Tesco to work with.','','','',1),('United States',2,2,2,2,1,2,3,2,0,1,1,1,3,1,2,3,2,2,2,2,1,'','Miller/Coors & ABI Investment (people) and scale: Own the majority of the Category Captainships across Off & On Trade','Finalaizing the Category Vision that feeds our Customer Value Proposition\r\n* In the past we were doing a lot of Category Development activities but were not focused on driving the category and the HUSA portfolio growth.','Develop & Alignon Consumer/Shopper decision tree that would support the beverage shelf redesign','Continue to drive center led strategies/capabilities that we can leverage in the OpCO (e.g. EOE)',1),('Uruguay',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'Noe','unwillingness to collaborate and lack of perceived benefits','low skills, lack of data','establish skills, processes and roles','',1);

--
-- Table structure for table `valores`
--

CREATE TABLE `valores` (
  `nature` text,
  `hazard` text NOT NULL,
  `collision` text NOT NULL,
  `lsr` text NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `valores`
--

INSERT INTO `valores` VALUES ('Alcohol related case|Type of injury unknown or unspecified|Scratches, bruises, contusion|Superficial eye injury|Lacerations|Cuts|Other type of superficial injuries|Closed bone fractures|Open bone fractures|Dislocations|Sprains and strains|Loss of sight|Amputation / loss of bodyparts|Concussion|Other types of internal injuries|Thermal burns and scalds|Chemical burns|Frostbites|Acute poisoning|Acute infection|Intoxication|Not applicable','Another kind of accident|Contact with machinery|Struck by moving/flying/falling object/ collapsing material|Struck by moving vehicle|Struck against something fixed/stationary|Injured while lifting or handling|Slip, trip fall same level|Falls from height|Trapped by something collapsing/overturning|Drowned or asphyxiated|Exposed to fire/explosion/smoke|Contact with electricity/ electrical discharge|Injured by an animal|Physical assault, acts of violence (by colleague)|Physical assault, acts of violence (by third party)|Commuting|Equipment failure|Exposure to blood|Hot liquid/ gas or surface|Exposed to extreme temperatures|Traffic related/ moving vehicles|Use of equipment|Accident travelling between sites/ jobs|Alcohol abuse|Exposure to harmful substance|Use of hand tool|Striking against object|Other','Hit while parked|Collision with animals or debris|Collision due to mechanical failure|Act of nature (wind, storms, hurricane, flood, etc..)|Glass-only damage|Damage from fire, theft or vandalism|Object hit vehicle (for instance a small stone from the road)|Collision with another vehicle (cars, trucks, motorbike)|Collision involving pedestrian and/or cyclist|Sings vehicle collision (without involving any other vehicle or pedestrians or cyclist)|Vehicle rollover|Other','Be sober and free from drugs|Phone hands free only|Wear your seatbelt and helmet|Drive at the allowed speed|Operate vehicles only when authorized|Lock out, tag out before work on machines or equipment begins|Comply with CO2 procedure when required|Protect yourself when working with chemicals|Obtain authorisation before entering a confined space|Protect yourself against a fall when working at height|Obtain authorisation before starting any hot work activity|Drive forklift trucks safely',1);

--
-- Dumping events for database 'lifesavingrules'
--

--
-- Dumping routines for database 'lifesavingrules'
--


