-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 12, 2020 at 10:17 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 5.6.38

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: `dvsvigov_vacdos`
--

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

--
-- Table structure for table `data_appcompany`
--

CREATE TABLE `data_appcompany` (
  `id` int(6) NOT NULL,
  `name` text NOT NULL,
  `address` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_appcompany`
--

INSERT INTO `data_appcompany` (`id`, `name`, `address`, `notes`) VALUES
(15, 'Asia Big Wave Sdn. Bhd.', '', ''),
(16, 'Dose & Dosage Sdn. Bhd.', '', ''),
(17, 'Age D Or Sdn. Bhd.', '', ''),
(18, 'Company A', 'Kuala Lumpur', '');

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

--
-- Table structure for table `data_asian`
--

CREATE TABLE `data_asian` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_asian`
--

INSERT INTO `data_asian` (`id`, `name`, `notes`) VALUES
(1, 'Thailand', 'thai'),
(2, 'Bruneii', 'brunei'),
(3, 'Laos', 'la'),
(4, 'Asian A', 'AA');

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

--
-- Table structure for table `data_disease`
--

CREATE TABLE `data_disease` (
  `id` int(6) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_disease`
--

INSERT INTO `data_disease` (`id`, `name`, `notes`) VALUES
(3, 'Newcastle Disease (avian paramyxovirus 1)', 'NDV'),
(4, 'Infectious Bronchitis (Coronavirus)', 'IB'),
(5, 'Infectious Bursal Disease (IBD)', 'IBD'),
(6, 'Disease A', '');

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

--
-- Table structure for table `data_manu`
--

CREATE TABLE `data_manu` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_manu`
--

INSERT INTO `data_manu` (`id`, `name`, `notes`) VALUES
(2, 'Formosa Biomedical Inc., Taiwan', 'Taiwan'),
(3, 'IDT Biologica GMBH, Germany', 'Germany'),
(4, 'Fatro S.P.A, Italy', 'Italy'),
(5, 'Cyberjaya A', '');

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

--
-- Table structure for table `data_refcount`
--

CREATE TABLE `data_refcount` (
  `id` int(11) NOT NULL,
  `notes` text NOT NULL,
  `name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_refcount`
--

INSERT INTO `data_refcount` (`id`, `notes`, `name`) VALUES
(1, 'Aussie', 'Australia'),
(2, 'UK', 'United Kingdom'),
(3, 'USA', 'United States of America'),
(4, 'AAA', 'Country A');

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

--
-- Table structure for table `data_source`
--

CREATE TABLE `data_source` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_source`
--

INSERT INTO `data_source` (`id`, `name`, `notes`) VALUES
(1, 'Veterinary Research Institute', 'Ipoh');

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

--
-- Table structure for table `data_species`
--

CREATE TABLE `data_species` (
  `id` int(6) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_species`
--

INSERT INTO `data_species` (`id`, `name`, `notes`) VALUES
(1, 'Poultry (Broiler)', 'chicken'),
(2, 'Poultry (Layer)', 'chicken'),
(3, 'Poultry (Layer, Breeder)', 'Ayam'),
(4, 'Species A', '');

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

--
-- Table structure for table `data_strain`
--

CREATE TABLE `data_strain` (
  `id` int(6) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_strain`
--

INSERT INTO `data_strain` (`id`, `name`, `notes`) VALUES
(1, 'VG / GA', ''),
(2, 'Clone 45', ''),
(4, 'Lasota Strain', ''),
(5, 'Strain A', '');

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

--
-- Table structure for table `data_vaccine`
--

CREATE TABLE `data_vaccine` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `notes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_vaccine`
--

INSERT INTO `data_vaccine` (`id`, `name`, `notes`) VALUES
(1, 'Inactivated', ''),
(3, 'Lyophilised', ''),
(4, 'Live Attenuated', ''),
(5, 'Vaccine A', '');

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

--
-- Table structure for table `dossierform`
--

CREATE TABLE `dossierform` (
  `id` int(6) UNSIGNED ZEROFILL NOT NULL,
  `idvac` int(6) UNSIGNED ZEROFILL NOT NULL,
  `tradename` text,
  `manufacturername` text,
  `plantaff` text,
  `mainplant` text,
  `vacctype` text,
  `Assess` text,
  `AssessNo` text,
  `statusform` text NOT NULL,
  `datesubmit` text NOT NULL,
  `Q1` int(11) DEFAULT NULL,
  `Q1comment` text NOT NULL,
  `Q1AI` text NOT NULL,
  `Q2` int(11) DEFAULT NULL,
  `Q2comment` text NOT NULL,
  `Q2AI` text NOT NULL,
  `Q3` int(11) DEFAULT NULL,
  `Q3comment` text NOT NULL,
  `Q3AI` text NOT NULL,
  `Q4` int(11) DEFAULT NULL,
  `Q4comment` text NOT NULL,
  `Q4AI` text NOT NULL,
  `Q5` int(11) DEFAULT NULL,
  `Q5comment` text NOT NULL,
  `Q5AI` text NOT NULL,
  `Q6` int(11) DEFAULT NULL,
  `Q6comment` text NOT NULL,
  `Q6AI` text NOT NULL,
  `Q7` int(11) DEFAULT NULL,
  `Q7comment` text NOT NULL,
  `Q7AI` text NOT NULL,
  `Q8` int(11) DEFAULT NULL,
  `Q8comment` text NOT NULL,
  `Q8AI` text NOT NULL,
  `Q9` int(11) DEFAULT NULL,
  `Q9comment` text NOT NULL,
  `Q9AI` text NOT NULL,
  `Q10` int(11) DEFAULT NULL,
  `Q10comment` text NOT NULL,
  `Q10AI` text NOT NULL,
  `Q11` int(11) DEFAULT NULL,
  `Q11comment` text NOT NULL,
  `Q11AI` text NOT NULL,
  `Q12` int(11) DEFAULT NULL,
  `Q12comment` text NOT NULL,
  `Q12AI` text NOT NULL,
  `Q13` int(11) DEFAULT NULL,
  `Q13comment` text NOT NULL,
  `Q13AI` text NOT NULL,
  `Q14` int(11) DEFAULT NULL,
  `Q14comment` text NOT NULL,
  `Q14AI` text NOT NULL,
  `Q15` int(11) DEFAULT NULL,
  `Q15comment` text NOT NULL,
  `Q15AI` text NOT NULL,
  `Q16` int(11) DEFAULT NULL,
  `Q16comment` text NOT NULL,
  `Q16AI` text NOT NULL,
  `Q17` int(11) DEFAULT NULL,
  `Q17comment` text NOT NULL,
  `Q17AI` text NOT NULL,
  `Q18` int(11) DEFAULT NULL,
  `Q18comment` text NOT NULL,
  `Q18AI` text NOT NULL,
  `Q19` int(11) DEFAULT NULL,
  `Q19comment` text NOT NULL,
  `Q19AI` text NOT NULL,
  `Q20` int(11) DEFAULT NULL,
  `Q20comment` text NOT NULL,
  `Q20AI` text NOT NULL,
  `Q21` int(11) DEFAULT NULL,
  `Q21comment` text NOT NULL,
  `Q21AI` text NOT NULL,
  `Q22` int(11) DEFAULT NULL,
  `Q22comment` text NOT NULL,
  `Q22AI` text NOT NULL,
  `Q23` int(11) DEFAULT NULL,
  `Q23comment` text NOT NULL,
  `Q23AI` text NOT NULL,
  `Q24` int(11) DEFAULT NULL,
  `Q24comment` text NOT NULL,
  `Q24AI` text NOT NULL,
  `Q25` int(11) DEFAULT NULL,
  `Q25comment` text NOT NULL,
  `Q25AI` text NOT NULL,
  `Q26` int(11) DEFAULT NULL,
  `Q26comment` text NOT NULL,
  `Q26AI` text NOT NULL,
  `Q27` int(11) DEFAULT NULL,
  `Q27comment` text NOT NULL,
  `Q27AI` text NOT NULL,
  `Q28` int(11) DEFAULT NULL,
  `Q28comment` text NOT NULL,
  `Q28AI` text NOT NULL,
  `Q29` int(11) DEFAULT NULL,
  `Q29comment` text NOT NULL,
  `Q29AI` text NOT NULL,
  `Q30` int(11) DEFAULT NULL,
  `Q30comment` text NOT NULL,
  `Q30AI` text NOT NULL,
  `Q31` int(11) DEFAULT NULL,
  `Q31comment` text NOT NULL,
  `Q31AI` text NOT NULL,
  `Q32` int(11) DEFAULT NULL,
  `Q32comment` text NOT NULL,
  `Q32AI` text NOT NULL,
  `Q33` int(11) DEFAULT NULL,
  `Q33comment` text NOT NULL,
  `Q33AI` text NOT NULL,
  `Q34` int(11) DEFAULT NULL,
  `Q34comment` text NOT NULL,
  `Q34AI` text NOT NULL,
  `Q35` int(11) DEFAULT NULL,
  `Q35comment` text NOT NULL,
  `Q35AI` text NOT NULL,
  `Q36` int(11) DEFAULT NULL,
  `Q36comment` text NOT NULL,
  `Q36AI` text NOT NULL,
  `Q37` int(11) DEFAULT NULL,
  `Q37comment` text NOT NULL,
  `Q37AI` text NOT NULL,
  `Q38` int(11) DEFAULT NULL,
  `Q38comment` text NOT NULL,
  `Q38AI` text NOT NULL,
  `Q39` int(11) DEFAULT NULL,
  `Q39comment` text NOT NULL,
  `Q39AI` text NOT NULL,
  `Q40` int(11) DEFAULT NULL,
  `Q40comment` text NOT NULL,
  `Q40AI` text NOT NULL,
  `Q41` int(11) DEFAULT NULL,
  `Q41comment` text NOT NULL,
  `Q41AI` text NOT NULL,
  `refQ1` text NOT NULL,
  `refQ2` text NOT NULL,
  `refQ3` text NOT NULL,
  `refQ4` text NOT NULL,
  `refQ5` text NOT NULL,
  `refQ6` text NOT NULL,
  `refQ7` text NOT NULL,
  `refQ8` text NOT NULL,
  `refQ9` text NOT NULL,
  `refQ10` text NOT NULL,
  `refQ11` text NOT NULL,
  `refQ12` text NOT NULL,
  `refQ13` text NOT NULL,
  `refQ14` text NOT NULL,
  `refQ15` text NOT NULL,
  `refQ16` text NOT NULL,
  `refQ17` text NOT NULL,
  `refQ18` text NOT NULL,
  `refQ19` text NOT NULL,
  `refQ20` text NOT NULL,
  `refQ21` text NOT NULL,
  `refQ22` text NOT NULL,
  `refQ23` text NOT NULL,
  `refQ24` text NOT NULL,
  `refQ25` text NOT NULL,
  `refQ26` text NOT NULL,
  `refQ27` text NOT NULL,
  `refQ28` text NOT NULL,
  `refQ29` text NOT NULL,
  `refQ30` text NOT NULL,
  `refQ31` text NOT NULL,
  `refQ32` text NOT NULL,
  `refQ33` text NOT NULL,
  `refQ34` text NOT NULL,
  `refQ35` text NOT NULL,
  `refQ36` text NOT NULL,
  `refQ37` text NOT NULL,
  `refQ38` text NOT NULL,
  `refQ39` text NOT NULL,
  `refQ40` text NOT NULL,
  `refQ41` text NOT NULL,
  `gencomm` text NOT NULL,
  `recomm` text NOT NULL,
  `sumA` int(11) NOT NULL,
  `sumB` int(11) NOT NULL,
  `sumC` int(11) NOT NULL,
  `sumD` int(11) NOT NULL,
  `sumE` int(11) NOT NULL,
  `sumF` int(11) NOT NULL,
  `sumG` int(11) NOT NULL,
  `sumH` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dossierform`
--

INSERT INTO `dossierform` (`id`, `idvac`, `tradename`, `manufacturername`, `plantaff`, `mainplant`, `vacctype`, `Assess`, `AssessNo`, `statusform`, `datesubmit`, `Q1`, `Q1comment`, `Q1AI`, `Q2`, `Q2comment`, `Q2AI`, `Q3`, `Q3comment`, `Q3AI`, `Q4`, `Q4comment`, `Q4AI`, `Q5`, `Q5comment`, `Q5AI`, `Q6`, `Q6comment`, `Q6AI`, `Q7`, `Q7comment`, `Q7AI`, `Q8`, `Q8comment`, `Q8AI`, `Q9`, `Q9comment`, `Q9AI`, `Q10`, `Q10comment`, `Q10AI`, `Q11`, `Q11comment`, `Q11AI`, `Q12`, `Q12comment`, `Q12AI`, `Q13`, `Q13comment`, `Q13AI`, `Q14`, `Q14comment`, `Q14AI`, `Q15`, `Q15comment`, `Q15AI`, `Q16`, `Q16comment`, `Q16AI`, `Q17`, `Q17comment`, `Q17AI`, `Q18`, `Q18comment`, `Q18AI`, `Q19`, `Q19comment`, `Q19AI`, `Q20`, `Q20comment`, `Q20AI`, `Q21`, `Q21comment`, `Q21AI`, `Q22`, `Q22comment`, `Q22AI`, `Q23`, `Q23comment`, `Q23AI`, `Q24`, `Q24comment`, `Q24AI`, `Q25`, `Q25comment`, `Q25AI`, `Q26`, `Q26comment`, `Q26AI`, `Q27`, `Q27comment`, `Q27AI`, `Q28`, `Q28comment`, `Q28AI`, `Q29`, `Q29comment`, `Q29AI`, `Q30`, `Q30comment`, `Q30AI`, `Q31`, `Q31comment`, `Q31AI`, `Q32`, `Q32comment`, `Q32AI`, `Q33`, `Q33comment`, `Q33AI`, `Q34`, `Q34comment`, `Q34AI`, `Q35`, `Q35comment`, `Q35AI`, `Q36`, `Q36comment`, `Q36AI`, `Q37`, `Q37comment`, `Q37AI`, `Q38`, `Q38comment`, `Q38AI`, `Q39`, `Q39comment`, `Q39AI`, `Q40`, `Q40comment`, `Q40AI`, `Q41`, `Q41comment`, `Q41AI`, `refQ1`, `refQ2`, `refQ3`, `refQ4`, `refQ5`, `refQ6`, `refQ7`, `refQ8`, `refQ9`, `refQ10`, `refQ11`, `refQ12`, `refQ13`, `refQ14`, `refQ15`, `refQ16`, `refQ17`, `refQ18`, `refQ19`, `refQ20`, `refQ21`, `refQ22`, `refQ23`, `refQ24`, `refQ25`, `refQ26`, `refQ27`, `refQ28`, `refQ29`, `refQ30`, `refQ31`, `refQ32`, `refQ33`, `refQ34`, `refQ35`, `refQ36`, `refQ37`, `refQ38`, `refQ39`, `refQ40`, `refQ41`, `gencomm`, `recomm`, `sumA`, `sumB`, `sumC`, `sumD`, `sumE`, `sumF`, `sumG`, `sumH`) VALUES
(000027, 000029, 'NDVAC (Testing)', 'NDVAC VRI', 'Public/Government', 'Diagnostic', 'Killed', 'SHARIL AZWAN', 'A', 'Complete', '17/07/2020', 6, '', '', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 4, '', '', 6, '', '', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 4, '', '', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 6, '', '', 4, '', '', 6, '', '', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 2, '', '', 4, '', '', 6, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Accept', 100, 67, 100, 67, 78, 88, 81, 67),
(000028, 000029, 'NDVAC (Testing)', 'NDVAC VRI', 'Public/Government', 'Diagnostic', 'Killed', 'fakhrulisham razali', 'B', 'Draft', '', 6, '<ul>\r\n<li>best</li>\r\n<li>terbaik</li>\r\n<li>awesome</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>tralala&nbsp;&Ograve;</p>', '<table style=\"height: 138px;\" width=\"181\">\r\n<tbody>\r\n<tr>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">aaaaa</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n</tr>\r\n<tr>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n<td style=\"width: 53.0078px;\">&nbsp;</td>\r\n</tr>\r\n</tbody>\r\n</table>', 6, '', '', 6, '', '', 4, '', '', 4, '', '', 4, '', '', 6, '', '', 6, '', '', 6, '', '', 2, '', '', 0, '', '', 4, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 0, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 0, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', '12', '11', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 100, 67, 100, 33, 96, 100, 100, 100),
(000029, 000029, 'NDVAC (Testing)', 'NDVAC VRI', 'Public/Government', 'Diagnostic', 'Killed', 'suhaimi', 'C', 'Draft', '', 4, '', '', 2, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 4, '', '', 2, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 4, '', '', 6, '', '', 4, '', '', 6, '', '', 4, '', '', 6, '', '', 4, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', 6, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 56, 67, 67, 33, 100, 83, 100, 100),
(000051, 000041, 'Aujeszky oilsuivax gl ', 'Fatro S.P.A. Italy', 'Private', 'Biologic Production', 'Recombinant', 'NORAZURA A. HAMID', 'A', 'Complete', '22/07/2020', 6, 'Page: Supplementary file\r\n12/2008/V\r\nDate: Oct 15, 2008', '', 6, 'Page: Supplementary file\r\nSpain', '', 4, 'Page: Supplementary file\r\nDate: July 16, 2008\r\nNo reference number provided.', '', 0, 'Page: Supplementary file\r\n1. Batch: 901521\r\n2. Batch: 801514\r\n3. Batch: 703968', 'Consecutive batch given with a year difference.', 4, 'Page: Supplementary file\r\nProduct license: A.I.C 100008010\r\n Date: Oct 10, 1993', 'Date: Oct 29, 2009\r\nLicences dated Oct 14, 1993 was not provided.', 2, 'Page: Supplementary file\r\n1. Greek', 'Certificate was provided without English translation. and only 1 registration certificate in other country was provided. ', 2, 'Based on the classification of Veterinary Biologic: Class 1 (low risk)', '', 2, 'Page: 3/98\r\nBasic vaccination: 1st and 2nd vaccination with an interval of 6 weeks.', '', 2, 'Page: 3/98\r\n1. Basic vaccination: 1st and 2nd vaccination with an interval of 6 weeks\r\n2. Sows: (formerly vaccinated before the first farrowing) repeat inoculation 4 -6 weeks before subsequent farrowings\r\n3. Boars: repeat vaccination every 6 months', '', 2, 'Page: 3/98\r\nDose: 2ml\r\nInjection via the deep intramuscular route in the neck', '', 0, 'Not relevant', '', 0, 'Page: 4/98\r\n500 doses/ 100 ml vial', '', 6, 'Page: Supplementary file\r\nOnly illustrative leaflet was provided', 'Please provide with real leaflet', 2, 'Page: 4/98\r\nStore at refrigerator at 2-8C', '', 4, 'Page: \r\n3/98\r\nIndication: for immunization of swine against Aujeszky\'s disease', '', 0, 'No side effect information provided', 'Please provide with side effect informations.', 0, 'No batch serial number and expiry date data provided.', 'Please submit real packaging box embossed with batch serial number and expiry date.', 2, 'Page: 6/98\r\nMaster seed history provided with signatory of supplier.                                                                                   ', 'Please provide full history of the master seed with approval.', 4, 'Page: 6/98\r\nStrain: AyV gI\r\nPRV (Ka)\r\nCoA was not provided', 'Please provide with CoA of strain.', 2, 'Masterseed purity providd without confirmatory testing by the relevant authority laboratory.', '', 4, 'Availability of information without CoA', '', 0, 'Not applicable', '', 2, 'CoA was not provided', '', 2, 'Inactivation kinetic, safety margin and inactivation test were not provided.', '', 4, '1. Sorbiton mono-oleate\r\n2. LIght mineral  oil\r\n3. Thiomersal\r\n4. Phosphate buffer saline\r\n\r\n', '', 2, 'Sterility test was conducted but CoA was not provided.', '', 2, 'CoA was not provided', '', 0, 'Not applicable.', '', 2, 'Page: 28/98\r\nDetermine by mean of a Brookfield Rotating Viscometer LVT', 'Please  provide with vaccine viscosity test data.', 2, 'No CoA was provided', 'Please  provide with purity test CoA.', 2, 'Page: 2/98\r\nAujesky disease virus (gI negative) inactivated not less than 10>85 TCID50\r\n', '', 2, 'Page: 28/98\r\nAppearance: white, milky liquid\r\n', '', 0, 'Page: 4 & 39/98\r\nStable at 2-8C with maintains immunogenic potency for a minimum periods of 12 months after preparation.  ', '', 2, 'Page: 42/98\r\n ', 'Please provide CoA of safety test conducted', 2, 'Appendix chapter\r\nFarm 1: no location, farm husbandry data, morbidity , mortality and production data\r\n2. Farm 2: o location, farm husbandry data, morbidity , mortality and production data\r\n3. Farm 3: act as control farm and without approval.', 'Farm: Please provide with ocation, farm husbandry data, morbidity , mortality and production data\r\n2. FArm 2: please provide location, farm husbandry data, morbidity , mortality and production data.\r\n3. Result was not provided for all safety trial conducted with approval\r\n', 0, 'Not applicable.', '', 2, 'Page: Appendix chapter\r\nNo challenge test conducted', 'Please provide ', 0, 'No data', '', 0, 'No data', '', 0, 'Not relevant', '', 2, 'Page; 41/98 \r\n12 months', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 89, 33, 33, 33, 33, 38, 22, 13),
(000052, 000041, 'Aujeszky oilsuivax gl ', 'Fatro S.P.A. Italy', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000053, 000041, 'Aujeszky oilsuivax gl ', 'Fatro S.P.A. Italy', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000054, 000042, 'BIO-VAC REO', 'FATRO S.p.A.', 'Private', 'Biologic Production', 'Live', 'AZRULNIZAM JAAFAR', 'A', 'Draft', '', 0, '', '', 6, 'ITALY', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 2, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 33, 0, 11, 0, 0, 0, 0, 0),
(000055, 000042, 'BIO-VAC REO', 'FATRO S.p.A.', 'Private', 'Biologic Production', 'Live', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000056, 000042, 'BIO-VAC REO', 'FATRO S.p.A.', 'Private', 'Biologic Production', 'Live', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000057, 000043, 'Fortegra', 'Intervet Inc, Moris Avenue', 'Private', 'Biologic Production', 'Live', 'RAZLINA RAGHAZLI', 'A', 'Draft', '', 6, 'United States Veterinary Biological Establishment License No. 165A (Dated 13 July 2017)', '', 4, 'USA', '', 6, 'Dated 23rd January 2018', '', 6, 'Batch no\r\n94320083\r\n94320084\r\n94320085', '', 6, 'Certificate no: 1801034 (Dated 15th February 2018)', '', 2, 'South Africa (Dated 25/10/2016)\r\nPhilippines (21/7/2015)', 'Need another copy or registration   certificate from another country since the copy of registration certificate from Philippines is already expired during the dossier submission. ', 4, 'This is a live coccidiosis vaccine, which is  further improved from the previous Coccivac B (TACB 60/08) vaccine and contains the same non-precocious, non-attenuated vaccine strains (E.acervulina, E.maxima, E.mivati & E.tenella) with additional E.maxima MFP. Strains used were claimed to be safe, thus no attenuation process has been performed.', 'Please provide the safety test/ results to proof the safety of strains used in this vaccine. ', 2, 'Vaccine is recommended to be administered to healthy receptive  DOC held in proper environment under good management. The revaccination program is required however it will largely depends on the degree of exposure that the flock is likely to encounter. ', 'Only general guidelines was given in the product leaflet. No data on immune response study was given to support the determination/ recommended of vaccinating schedule.  ', 2, 'Day-old chick . Revaccination program is required. However, it will will largely depends on the degree of exposure that the flock is likely to encounter. ', '', 2, 'The vaccine should be prepared (or mixed) at the rate of 210ml of distilled water per 1000 doses of vaccine. each 100 chicks shoudl receive 21ml of vaccine solution delivered by spray cabinet (dye may be added as a marker). Full directions for the use of the spray cabinet are available from the company. ', '', 2, 'Phosphate buffered saline (PBS) used to prepare the concentrated vaccine. in the field, the final preparation is diluted with water. ', 'Is normal tap water available can be used to dilute the vaccine or is there any specific  steps or procedure need to be taken before diluting the vaccine into the water (by using distilled/ deionized water). This information must appear on the vaccine leaflet. ', 4, '10 x 1,000 doses\r\n10 x 10, 000 doses ', '', 4, 'Copy of pamphlet and specimen of label provided. ', 'Need to submit specimen of label of vaccine box and bottle  (not the photocopy of label which is already submitted inside the dossier)', 2, 'Store at 2-7C', '', 2, 'Indication:\r\nFor vaccination of healthy chickens ayt one day of age by spray cabinet administration as an aid in the prevention of coccidiosis due ti E.mivati and E.tenella and as an aid on the reduction of lesions related to E.acervulina and E.maxima. This vaccine contains gentamycin as a preservative. \r\n\r\n', '', 4, 'Precautions:\r\nThis product is not ordinarily recommended for use with prestarter or starter feeds containing coccidiostats. Birds must have access to their droppings as reinfection is required to induce immunity. ', 'Precautions on human user is not provided. ', 4, 'Printed on the copy of the label ', '', 2, 'E. acervulina (Page 2: 2.C.2.1.a)\r\n- was isolated and characterized by Dr. Allen Edgar, Dept of Poultry Science, Auburn, Alabama. OOcysts were brought to MIllsboro, Delaware from Opelika, Alabama in 1985 bu Joe Kukla. These seeds were expanded in chickens to generate a viable oocyst pool for working seeds. Through the process of single oocyst isolation, Master seeds were developed. Sterwin Laboratories, Inc. Est 226 received approval from the USDA in December 1985 for a coccidiosis vaccine consisting of live oocysts (Coccivac). Later, the MS was designated: E. acervulina 051491AC.\r\n\r\nE. maxima (page 3: 2.C.2.1.b)\r\n\r\nE.maxima MFP (page 4: 2.C.3.2.C)\r\n\r\nE.  mivati (page 5: 2.C.2.1.d)\r\n\r\nE. tenella (page 6: 2.C.2.1.e)\r\n', 'The aggreement and signatory of supplier not supplied. ', 6, 'The identity of MS was confirmed by PCR. \r\nCoA from the USDA provided for each MS strain:\r\n1. E.tenella ( dated 30/6/2006)\r\n2. E.acervulina (dated 2/12/2005)\r\n3. E. maxima mfp (Dated 21/6/2007)', '', 6, 'The MS of each strain was shown to be free from extraneous agents (by HA test, tissue culture and embryo testing). The MS was free from salmonella, mycoplasma, avian lympohoid leucosis virus, CAV and reticuloendotheliosis virus.\r\nCoA from the USDA provided for each MS strain:\r\n1. E.tenella ( dated 30/6/2006)\r\n2. E.acervulina (dated 2/12/2005)\r\n3. E. maxima mfp (Dated 21/6/2007)', '', 6, 'Chickens which were sourced from fertile eggs for vaccine production \r\n\r\nChicks of birds derived from flocks tested in accordance with S.O 5-A.\r\nBirds are reared in free accomodation and prior to production are tested for absence of coccidial infection. If used, fertile eggs are hatched in coccidian free accommodation. ', '', 6, 'The testing/ determination of the fertile SPF eggs used followed the 9CFR procedure. The CoA produced (dated 23/4/2014) was validated by the USDA-APHIS-VS Center for Veterinary Biologics dated 2/5/2014)', '', 0, 'Not applicable ', '', 0, 'Not applicable', '', 6, 'CoA provided for;\r\n1. Beta-propiolactone 97% (Batch 29.4-1000/10/15 dated 29/10/2015)\r\n2. Gentamicin (Batch no. G-6336 dated 22/8/2016)\r\n3. Potassium dichromate, 10% (Batch 1604A71, dated 12/4/2016)\r\n4. 60% sucrose (Batch 0656C102, dated 11/3/2016)\r\n5. Sodium chloride (Batch 3557C510, dated 1/3/2017)\r\n6. Potassium chloride (Batch 0000150903, dated 7/7/2016)\r\n7. Potassium phosphate (Batch 3056C517, dated 12/10/2015)\r\n8. di-sodium hydrigen phosphate dihydrate (Batch K47996976, dated 14/6/2016)', '', 4, 'Tests performed in accordance with 9CFR 113.27(e)', 'Results was given in the dossier for 3 consecutive batches.  Only batch number is provided without the date of manufacture. However, results attached was not being validate by the QC department. CoA of the finished product is needed. ', 0, '', '', 0, '', '', 0, 'Not applicable', '', 0, '', '', 4, 'Live oocysts of:\r\n1. E. acervulina\r\n2. E. maxima\r\n3. E. maxima MFP\r\n4. E. mivati\r\n5. E. tenella\r\n\r\nThis vaccine contains gentamycin. ', '', 6, 'Live oocysts vaccine. The Certificate of Licensing and Inspection by the USDA-APHIS-VS dated on 15/2/2018. The certificate certified the vaccines has licensed and inspected (tested) according to the laws regulation of the USA. ', '', 2, 'The demonstration of stability study  were based on the challenge potency test. The components were said to be stable up to 17 months.', 'The manufacturing date of the 3 batches were not given.  Stability of  the physical appearance over the months was not given. \r\nPlease provide the lab worksheet results of the stability test. The worksheet need to be verified by the QC staff. ', 0, '', '', 0, '', '', 0, 'The strains are claimed to be safe and no attenuation has been performed earlier, the company claimed the reversion to virulence is considered not necessary and therefore no study has been conducted for these 4 strains.  ', 'The company has to proof that strains used were safe. ', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 89, 78, 44, 33, 56, 58, 22, 0),
(000058, 000043, 'Fortegra', 'Intervet Inc, Moris Avenue', 'Private', 'Biologic Production', 'Live', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000059, 000043, 'Fortegra', 'Intervet Inc, Moris Avenue', 'Private', 'Biologic Production', 'Live', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000060, 000044, 'FOSTERA PCV MH VACCINE', 'Zoetis Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000061, 000044, 'FOSTERA PCV MH VACCINE', 'Zoetis Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000062, 000045, 'Parvo Shield L5E', 'ELANCO US Inc. USA', 'Private', 'Biologic Production', 'Recombinant', 'ROSLINA HASSAN', 'A', 'Draft', '', 2, 'Attached File\r\nRegistered with United States Department of Agriculture,\r\nAnimal and Plant Health Inspection Service, \r\nVeterinary Services,\r\nCenter for Veterinary Biologic,\r\n1920 Dayton Avenue AMES, IOWA 50010.\r\nEstablishment License, NO.196\r\nDate: 9 Feb 2017\r\n', '', 0, 'Attached File\r\nUnited States', '', 4, 'Eli Lily (Malaysia) Sdn. Bhd\r\nLevel 7 Menara OBYU\r\nNo.4, Jalan PJU 8/8A Damansara Perdana\r\n47820 Petaling Jaya,\r\nSelangor,\r\nMalaysia\r\n', 'Letter produced by country of residence, Lyon\r\nDate : 13 Jun 2017\r\n', 0, 'Not provided', 'Information on certificate of release 3 batches is needed', 4, 'Enclosed but not from 3 consecutive batch\r\n\r\nSerial number:\r\nC646719A, Date: 22 Nov 2016\r\nC659113A, Date: 2 March 2017\r\nC696857A, Date 11 Feb.2017\r\n\r\nC696857A', '', 6, 'Attached file\r\n1.	Thailand Bangkok : 2F 11/59 (B)\r\n2.	Philippines : R-742\r\n', '', 4, 'Biological level 1, conventional vaccine development', '', 4, 'Pg 148/360\r\nThe recommended vaccination program by administer 5 mL intramuscularly to gilts and sows 4-6 week prior to breeding. Repeat for 3-4 weeks.\r\nRevaccinate with a single dose 4-6 weeks\r\n', '', 4, 'Pg 148/360\r\nsows 4-6 week prior to breeding', '', 4, 'single dose 4-6 weeks \r\nadminister 5 mL intramuscularly ', '', 0, 'NA', '', 4, 'Pg 16/360\r\nType 1: 1 bottle, 50 doses/ 250 mL\r\nType 2: 1 bottle, 10 doses/50 mL\r\n', '', 6, 'Pg 16-17/360\r\nCopy of real pamphlet and specimen of label were submitted but without batch no and expiry date \r\n\r\nReal copy of instructional pamphlet and specimen of label were not provided. \r\n', '', 6, 'Pg 13/360\r\nStored out of direct sunlight at 2Â°C-8Â°C. DO NOT FREEZE', '', 4, 'Pg 13/360\r\nFor use in healthy swine as an aid in the prevention of disease caused by porcine parvovirus, Erysipelothrix rhusiopathiae, Leptospira Canicola, grippotyphosa, hardjo, Icterohaemorrhagiae, and pomona. This product was not tested in pregnant animals.\r\n\r\ncontra-indications:\r\nDo not use in clinically ill or weakened animals.\r\n', '', 4, 'Pg 14/360\r\n1.	Side effects:\r\nAnaphylactic reactions may occur. Symtomatic treatment: Epinephrine.\r\n\r\n2.	Precautions\r\n2.1	special precautions for use in animals not applicable \r\n2.2	Special precautions to be taken by the person administering the veterinaey medical product to animal\r\n', '', 2, 'Product Code:\r\n48C5.20\r\n\r\nSerial number:\r\nC696857A\r\nExpiry date:\r\nDec 02 2019\r\n', '', 6, 'Pg 37/360\r\n1.	MSV for Parvovirus, strain TN-326.\r\nThe PPV isolate was obtained by Grand Laboratories from CE Kord Lab, Nashville, TN in January of 1981. It was isolated from a one week old scouring pig and obtained at the 2nd passage level. The virus was propagated in porcine kidney cells at Grand Laboratories to produce master seed virus 061483 at passage 24. The isolate was designated as PPV MSV X 061483.\r\n2.	MSB for Erysipelothrix rhusiopathiae\r\nThe isolate was obtained by Grand Laboratories from Dr. R.L. Wood NADC, Ames IA in October of 1082. There is no documented isolation and passage history from accession to the establishment of the master seed.\r\n3.	MSB for L. Canicola, strain Moulton\r\nThe L.Canicola, strain Moulton organism was obtained by Diamond Laboratories, Firm 213 from NVSL, Ames, IA in March of 1979. The organism was isolated from canine blood in 1952. Firm 213 was unable to provide the passage history. The material was designated as L.Canicola, strain Moultan, Lot No 10270.\r\n4.	MSB for L. Grippoyphosa, strain Shrew\r\nThe L.Grippotyphosa, strain Shrew organism was obtained by Diamond Laboratories, Firm 213 from NVSL, Ames, IA in June of 1977.The organism was isolated from a shrew in Portland, Oregon prior to 1977. Firm 213 was unable to provide the passage history. The material was designsted as L. Grippotyphosa, strain Shrew, Lot No. 10254.\r\n5.	MSB for L.Hardjo-prajitno, strain hardjoprajitno\r\nThe L.Hardjo-prajitno, strain hardjoprajitno was obtained by Diamond Laboratories, Firm 213 from Dr. Russell Bey, University of Minnesota, Minneapolis, MN in September of 1977.The organism was isolated from a human in Sumatra prior to 1938. Firm 213 was unable to provide the passage history. The material was designated as L.Hardjo-prajitno, strain hardjoprajitno, Lot No 10348.\r\n6.	MSB for L.Icterohaemorrhagiae, strain CF-1\r\nThe L.Icterohaemorrhagiae, strain CF-1 was obtained by Diamond Laboratories, Firm 213 from NVSL, Ames, IA in February of 1972. The organism was isolated from canine kidney in Puerto Rico December as L.Icterohaemorrhagiae, strain CF-1. Lot No. 10194\r\n7.	MSB for L.Pomona, strain MLS\r\nThe L.Pomona strain MLS was obtained by Diamond Laboratories, Firm 213 from Veterinary Services Biological Laboratory, Ames, IA in July of 1975 identified as VS L. Pomona 11000-54B. Diamond Laboratories re-isolated the serovar in EMJH semisolid medium in February 1976. On March 1 1976 the third liquid passage of the culture was made into Stuarts medium. After three days growth the culture was combined in equal parts with sterile 20% glycerol and dispensed into 1 ml glass ampoules as Master Seed Culture Lot No 10299 for future working seed lots.\r\n\r\n\r\nRequired MTA and CoA if obtained from third party\r\n', '', 2, 'Pg 37-39/360\r\n\r\n of masterseed virus was not provided\r\n\r\n1.	The identity test for MSV PPV, Erysipelothrix rhusiopathiae, Canicola, L. Grippoyphosa and L.Hardjo-prajitno master seed were performed but not mentioned clearly type and finding result of the test.\r\n2.	The identity test for L.Icterohaemorrhagiae and L.Pomona master seed was not mentioned. \r\n', '', 2, 'Pg 37-43/360\r\nThe purity test was carried out for MSV of PPV, MSB of Erysipelothrix rhusiopathiae, Canicola, L. Grippoyphosa, L.Hardjo-prajitno L.Icterohaemorrhagiae and L.Pomona but the result not sufficient.', '', 4, 'pg 35/360\r\n1.	EMEM and DMEM: cell growth medium for the propagation of Parvovirus\r\n2.	PK cells: for virus growth\r\n3.	No substrate information for bacterial antigen propagation\r\n', '', 0, 'Not applicable for SPF eggs\r\nUsed cell line of PK (Porcine Kidney) \r\n', '', 0, 'Not submitted', '', 2, '26-33/360\r\n\r\nAdditional\r\npg 54-60/360\r\n1.	Parvovirus, strain TN-326\r\nThe pH of harvest fluids was adjust using NaOH solution, subsequently added beta-propiolactone (BPL) solution\r\n\r\n2.	Erysipelothrix rhusiopathiae\r\nThe culture inactivated with 0.2-0.5% of 35% formaldehyde for 20 hours (Â±4 hours). The pH of inactivated fluid was adjusted.\r\n\r\n3.	L. Canicola strain Moultan\r\nThe harvest culture inactivated wih formaldehyde solution, mix for approximately 30 minutes.\r\n\r\n4.	L. Grippoyphosa, strain Shrew\r\nThe harvest culture inactivated wih formaldehyde solution, mix for approximately 30 minutes.\r\n\r\n5.	L.Hardjo-prajitno, strain hardjoprajitno\r\nThe harvest culture inactivated wih formaldehyde solution, mix for approximately 30 minutes.\r\n\r\n6.	L.Icterohaemorrhagiae, strain CF-1\r\nThe harvest culture inactivated wih formaldehyde solution, mix for approximately 30 minutes.\r\n\r\n7.	L.Pomona, strain MLS\r\nThe harvest culture inactivated wih formaldehyde solution, mix for approximately 30 minutes.\r\n\r\n\r\n', '', 4, 'Pg 46/360: \r\nInactivant: beta-propiolactone (BPL), formaldehyde \r\n\r\nAdjuvant: Aluminum Hydroxide (LV Rehydragel)\r\n\r\nPreservative:\r\n- Anti-fungal agent (Amphotericin B)\r\n-Gentamicin\r\n-Thimerosal\r\n-Thimerosal solution (10%)\r\n\r\nStabilizer: NA\r\n', '', 2, 'No protocol and CoA submitted', '', 0, 'Pg 130/360\r\nThe recommended vaccination program by administer 5 mL intramuscularly to gilts and sows 4-6 week prior to breeding. \r\n\r\nRepeat in 3-4 weeks\r\n\r\nRevaccinate with a single dose 4-6 weeks prior to each subsequent breeding\r\nVaccinate boars semiannually\r\n', '', 0, 'Not relevant (for live vaccine)', '', 2, 'Method for identifying the viscosity not submitted\r\n\r\nIngredient for Aluminium hydroxide gel\r\n', 'No CoA submitted', 0, 'Not relevant', '', 0, ' No information on composition of final product', 'Require additional information on composition of final product', 2, 'pg 6/360\r\nMultivalent inactivated viral and bacterial vaccine adjuvanted with aluminium hydroxide', '', 4, 'Pg 80-83/360\r\nPresented data on one batch shows that product is stable for a period between 32-59 months when stored at 2 to 8ÂºC.\r\nA shelf life of 36 months at 2 to 8ÂºC is justified\r\n', '', 2, 'Pg 132-136/360\r\nProtocol and summary results on Safety test in laboratory available but from previous report in November 1982:\r\n\r\ni.	Parvovirus: Protocol safety of administration of one dose and safety the repeated administration of one dose in swine \r\n\r\nii. Multivalent Bacterin: Protocol for Safety of administration of one dose and safety the repeated administration of one dose and overdose in swine \r\n', 'Required additional information on current safety test data for both Parvo and multivalent bacterin.', 2, 'Pg 140-145/360\r\n\r\ni.	Protocol and summary results on Safety test in field study for multivalent Bacterin provided but from previous report in November 1982.\r\n\r\nii.	Protocol and summary results on Safety assessment for Parvo Shield L5E in field study conducted in 1.1.2010- 3.6.2016 was provided\r\n', 'Require for latest field trial for three different region', 0, 'Not relevant.\r\nThis product as killed vaccine', '', 2, 'Pg 175-177/360\r\nPotency study was carried out in feeder pigs but report from 1988', '', 2, 'Pg 13/360\r\n per dose of 5 mL\r\n\r\n1.	Parvovirus                     : 2117 HA50U\r\n2.	Erysipelothrix rhusiopathiae \r\n                     : 2.1 O.D at 530 nm\r\n3. L. Canicola                    : 1 x 108 org\r\n4. L. Grippoyphosa           : 1 x 109 org\r\n5. L.Hardjo-prajitno          :  1 x 109 org\r\n6. L.Icterohaemorrhagiae : 1 x 108 org\r\n7. L.Pomona                       : 1 x 108 org\r\n\r\n', '', 0, 'Not submitted', '', 0, 'Not submitted', '', 0, 'Pg 15/360\r\n36 months, stored out of direct sunlight at 2-8Â°C. Use entire contents of bottle when first opened', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 33, 56, 67, 67, 63, 29, 22, 13),
(000063, 000045, 'Parvo Shield L5E', 'ELANCO US Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000064, 000045, 'Parvo Shield L5E', 'ELANCO US Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000068, 000044, 'FOSTERA PCV MH VACCINE', 'Zoetis Inc. USA', 'Private', 'Biologic Production', 'Recombinant', 'DR NURUL HUDA DATO MOHD ZAIRI', 'A', 'Draft', '', 6, 'USA APHIS Cert No: 1603200', '', 4, 'USA', '', 6, 'Letter of Authorization from Zoetic Inc (USA)', 'Dated 3rd Nov 2016', 6, 'Serial No: 278887A (Fill Date: 9/2/2018), \r\nSerial No: 278886A (Fill Date: 29/1/2018), \r\nSerial No: 205989A (Fill Date: 25/1/2017)', 'Each batch Expiration Date is 2 years after Fill Date.\r\nFrom 1st batch to 2nd batch provided is not subsequent serial no., suggesting a gap in this particular vaccine production.', 6, 'USA APHIS Cert No 1603200.\r\nProduct Code: 49K5.R5', '', 6, '1) Philippines Registration Cert: Reg No R-2147\r\n2) Thailand - Reg No: 2F/1/58 (B)\r\n3) Canada- Cert of Free Sale: File 880V2X/P18.5/S15.2', 'For Philippines, the cert provided is expired (15/6/2018) even during the submission of the TACB form (28/6/2018).\r\nFor Thailand and Canada, no cert expiration date was stated.\r\nFor Thailand, English translation of original cert and cert of translation accuracy has been duly provided.', 6, 'using killed porcine circovirus & Mycoplasma hyopneumoniae bacterin', '', 6, 'for vaccination of >3 weeks age in preventing PCV2 viraemia etc caused by PCV-2.\r\nAids in reducing pnemonia caused by M.hyopneumoniae.\r\nDuration of immunity: 23 weeks with studies attached.', '', 6, 'Data validation available', '', 6, 'Only 1 route tested: IM', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 89, 100, 100, 100, 0, 0, 0, 0),
(000069, 000044, 'FOSTERA PCV MH VACCINE', 'Zoetis Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000070, 000044, 'FOSTERA PCV MH VACCINE', 'Zoetis Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000071, 000047, 'Porcine Pili Shield +C', 'ELANCO US Inc. USA', 'Private', 'Biologic Production', 'Recombinant', 'ROSELIZA ROSLEE', 'A', 'Complete', '23/07/2020', 2, 'No: 196\r\nSep 24 2018', 'Expiry dates:  June 13, 2020', 4, '800 Fifth, St. NW, fort Dodge, Iowa', '', 6, 'Feb 4 th, 2019', '', 2, 'Product code No: 7890.00\r\nSerial or Subserial No: D001424A', 'Expiration dates: November, 26 2021', 6, '19-00914\r\nFeb 05, 2019', '', 2, 'Philipines , Registration Certificate No: R-2160\r\nColombia, Registration certificate No: 9457-BV ', 'Expiration date:\r\nPhiliphines - July, 22 2018\r\nColombia- From November 11, 2014 to indefinite', 4, 'Level 2 organism. ', '', 2, 'No validation data studies attached.', '', 2, 'No validation data studies attached.', '', 2, 'No validation data attached. ', '', 0, 'Not applicable for killed vaccine with adjuvant.', '', 4, 'Printed in English.\r\n50 doses/100 ml', '', 4, 'usage instruction.\r\nindications.\r\ndose.\r\nroute.\r\nprecautions. ', 'storage condition not provided. ', 2, '2 - 8 C', '', 2, 'No evidence provided.', '', 4, 'Not provided in the label /packaging.', '', 2, 'No information on tracibility system.', '', 2, 'History of passage not declared. The culture was passagesd for estimated 7 years. Not more than 5 time passage.', '', 2, 'Master seed identification of Clostridium perfingens and Toxin production need to re-confirm using molecular method. E. coli master seed must be re-confirmed using molecular method such as PCR to detect presence of gene related with toxin production. ', '', 2, 'confirmatory insufficient.', '', 0, 'Validation report and COA for each ingredients of In house prepared  media not included with ', '', 0, 'Not applicable ', '', 0, '', '', 0, 'No complete data on inativation kinetics test for each organism. Test use to determine inactivation step not declared.\r\nPercentage of formaldehyde used for inactivation process not declared. ', 'Request for data if available', 0, 'COA or complete relevant data not declared: \r\ncontent of antibiotics\r\nlevel of toxic components\r\nantigenic mass per dose', 'request relevant data if available', 0, 'Test result for sterility test not provided. ', 'Request for complete test result, the info provided in the dossier document was guideline. not test result. ', 0, 'Test result for inocuity test not declared. ', 'Request for test result for inocuity test. The info provided in the document was guideline, not result. ', 0, 'Not applicable for inactivated vaccine', '', 2, 'viscosity of vaccine shall determine using rotational viscometer or other relevant method. Declaration based on the low viscosity 2.0% alumimium oxide , LV Rehydragel not comply. Stability test result not declared. ', 'request validation test result for viscosity of vaccine.', 0, 'Not applicable', '', 2, '', '', 4, 'stable aluminium hydroxide product.', '', 0, 'Test must be done three months beyond the designatated epiry date:- date of test conducted not declared.\r\nStability test attached in the document not refer to finish product. ', '', 0, '', '', 2, 'No control group.\r\nNot included various breeds, 3 different locations with different husbandry system not declared. \r\nRecommended age not declared.', '', 0, 'Not applicable for inactivated vaccine.', '', 2, 'Efficacy study for clostridium perfingens do not have control group.', 'Live vaccination challenge for C. perfingens not recommended. \r\nPotency test  shall using Beta toxin neutralization  test (USDA 113.111)', 2, 'Need to re evaluate. Test report September 11, 1984.  MID shall be determine each batch. ', '', 0, '', '', 0, 'summary report provided only - Efficacy study of clostridium perfingens only.', '', 2, 'No test result attached. ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 67, 56, 44, 33, 41, 4, 19, 20),
(000072, 000047, 'Porcine Pili Shield +C', 'ELANCO US Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000073, 000047, 'Porcine Pili Shield +C', 'ELANCO US Inc. USA', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `dossierform` (`id`, `idvac`, `tradename`, `manufacturername`, `plantaff`, `mainplant`, `vacctype`, `Assess`, `AssessNo`, `statusform`, `datesubmit`, `Q1`, `Q1comment`, `Q1AI`, `Q2`, `Q2comment`, `Q2AI`, `Q3`, `Q3comment`, `Q3AI`, `Q4`, `Q4comment`, `Q4AI`, `Q5`, `Q5comment`, `Q5AI`, `Q6`, `Q6comment`, `Q6AI`, `Q7`, `Q7comment`, `Q7AI`, `Q8`, `Q8comment`, `Q8AI`, `Q9`, `Q9comment`, `Q9AI`, `Q10`, `Q10comment`, `Q10AI`, `Q11`, `Q11comment`, `Q11AI`, `Q12`, `Q12comment`, `Q12AI`, `Q13`, `Q13comment`, `Q13AI`, `Q14`, `Q14comment`, `Q14AI`, `Q15`, `Q15comment`, `Q15AI`, `Q16`, `Q16comment`, `Q16AI`, `Q17`, `Q17comment`, `Q17AI`, `Q18`, `Q18comment`, `Q18AI`, `Q19`, `Q19comment`, `Q19AI`, `Q20`, `Q20comment`, `Q20AI`, `Q21`, `Q21comment`, `Q21AI`, `Q22`, `Q22comment`, `Q22AI`, `Q23`, `Q23comment`, `Q23AI`, `Q24`, `Q24comment`, `Q24AI`, `Q25`, `Q25comment`, `Q25AI`, `Q26`, `Q26comment`, `Q26AI`, `Q27`, `Q27comment`, `Q27AI`, `Q28`, `Q28comment`, `Q28AI`, `Q29`, `Q29comment`, `Q29AI`, `Q30`, `Q30comment`, `Q30AI`, `Q31`, `Q31comment`, `Q31AI`, `Q32`, `Q32comment`, `Q32AI`, `Q33`, `Q33comment`, `Q33AI`, `Q34`, `Q34comment`, `Q34AI`, `Q35`, `Q35comment`, `Q35AI`, `Q36`, `Q36comment`, `Q36AI`, `Q37`, `Q37comment`, `Q37AI`, `Q38`, `Q38comment`, `Q38AI`, `Q39`, `Q39comment`, `Q39AI`, `Q40`, `Q40comment`, `Q40AI`, `Q41`, `Q41comment`, `Q41AI`, `refQ1`, `refQ2`, `refQ3`, `refQ4`, `refQ5`, `refQ6`, `refQ7`, `refQ8`, `refQ9`, `refQ10`, `refQ11`, `refQ12`, `refQ13`, `refQ14`, `refQ15`, `refQ16`, `refQ17`, `refQ18`, `refQ19`, `refQ20`, `refQ21`, `refQ22`, `refQ23`, `refQ24`, `refQ25`, `refQ26`, `refQ27`, `refQ28`, `refQ29`, `refQ30`, `refQ31`, `refQ32`, `refQ33`, `refQ34`, `refQ35`, `refQ36`, `refQ37`, `refQ38`, `refQ39`, `refQ40`, `refQ41`, `gencomm`, `recomm`, `sumA`, `sumB`, `sumC`, `sumD`, `sumE`, `sumF`, `sumG`, `sumH`) VALUES
(000074, 000048, 'Hipra Viar S/H120', 'Labarotorios Hipra S.A. Spain', 'Private', 'Biologic Production', 'Recombinant', 'MOHD ISWADI ISMAIL', 'A', 'Complete', '23/07/2020', 6, 'ES/101HV/16 ', '', 6, 'Laboratorios Hipra S.A., Avda. La Selva, 135 17170 Amer (Girona), Spain', '', 0, 'A copy of authorization letter not found in the dossier submitted.', 'A copy of the manufacturer authorization certificate is required. The manufacturer authorization number is provided in the dossier, 4242-E, however a copy of the letter of authorization not submitted.', 0, 'Not provided in the dossier.', 'Required a relevant assay certificate or certificate of release.', 0, 'A copy of registration certificate of vaccine in country origin not found in the dossier submitted.', 'Require a copy of registration certificate or free sale certificate of vaccine in country of origin.', 6, 'Philippines (VBPR: R 665)\r\nCambodia (FR040185/0216 MDV-DAL)', '', 6, 'Conventional derived live attenuated vaccine.', '', 0, 'Vaccination schedule not provided in the dossier.', 'Required additional information of the vaccination schedule of the vaccine.', 4, 'Target group is broiler chickens aged 1 day-old. ', '', 6, 'Dosage: 1 dose/bird, Route of vaccination: Oculonasal, oral or spray. Acceptable.\r\nHIPRAVIAR/H120\r\n9-10/317', '', 0, 'The vaccine do not require specific diluent since the vaccine is live attenuated virus.', '', 4, 'The dosage is clearly printed in English. Dose: 1,000 doses & 2,500 doses.\r\nHIPRAVIAR/H120\r\n13-14/317', '', 6, 'The instruction of the use of the vaccine can found in the pamphlet. Acceptable.', '', 6, 'The storage condition of the vaccine is mentioned at 2Â°C - 8Â°C (do not freeze) and protected from light. Acceptable.', '', 6, 'The indications of the vaccine is to prevent Newcastle disease and infectious bronchitis, however none contra-indications is mentioned. Acceptable.', '', 6, '1)	Side effect including respiratory symptom occur in vaccinated birds at 3 dpv. Acceptable.\r\n2)	The precautions of the vaccine include shelf life of the vaccine product and protection to the personnel handling for spray administration of the vaccine. Acceptable.\r\nHIPRAVIAR/H120\r\n9/317', '', 6, 'Label of the vaccine is referred. The information required for batch and expiry date of the vaccine is allocated on the label. Acceptable.', '', 4, 'NDV strain La Sota (passage 3 in chicken embryonated eggs) and IBV H120 (passage 120 in embryonated eggs) were supplied by the Central Veterinary Laboratory of Weybridge (United Kingdom). Acceptable.\r\nHIPRAVIAR/H120\r\n26/317\r\n29/317', '', 4, '1)	MSV of NDV strain La Sota was supplied by the Central Veterinary Laboratory of Weybridge (United Kingdom), however the actual origin of the master seed should briefly mentioned here. The information in the three reference papers (Tavassoli, 1974; Westbury, 1984; Westbury et al. 1984) provided did not mention the actual country origin of the master seed. Required additional information.\r\n2)	MSV of IBV H120 was supplied by the Central Veterinary Laboratory of Weybridge (United Kingdom), with the origin from the Netherlands. Acceptable.', '', 2, 'Insufficient information of the method determining the purity and C.O.A of MSV.', 'Required additional information on; (1) the description of method of determining the purity of the virus, and (2) C.O.A. of the MSV purity test.', 6, 'Acceptable.\r\nHIPRAVIAR/H120\r\n25/317', '', 6, 'The C.O.A. No.: 10590-03 & 10590-04 is referred. Acceptable.', '', 0, 'No relevant information found in the dossier submitted.', '', 0, 'Irrelevant for this vaccine. The MSV of NDV strain La Sota and IBV strain H120 were attenuated by continuous passage of the viruses in chicken embryonated eggs.', '', 4, 'The analysis of all chemical compositions was mentioned (C.O.A. No.: 31090-04, 10050-02, 31020-04, 33820-02, 9540002-04, 31010-04, 34030-04, 31900-04, 39993-04), however additional information is required for the source of the gelatine used.', '', 6, 'Acceptable.\r\nHIPRAVIAR/H120\r\n34/317', '', 2, 'The vaccines were inoculated into the chicken only. However, no relevant data of safety test is provided.', 'Required additional information of the safety test conducted on the MSV.', 6, 'Moisture content of the final freeze-dried product is <2.5%. Acceptable.', '', 0, 'Irrelevant for this vaccine. No additional information on viscosity is required since both MSV were live attenuated vaccine.', '', 4, 'HIPRAVIAR/H120\r\n34/317', '', 4, 'Acceptable.', '', 6, 'Live freeze-dried vaccine (yellowish freeze-dried tablet). Acceptable.\r\nHIPRAVIAR/H120\r\n8/317', '', 6, 'Acceptable.\r\nHIPRAVIAR/H120\r\n38-46/317', '', 6, 'Acceptable.', '', 2, 'Two trials were provided. One trial on natural outbreak of Newcastle disease (HIPRAVIAR/H120 82/317) and one trial of the vaccine against IB under field conditions (HIPRAVIAR/H120 86/317). The dossier not mentioned that the field trials were done in 3 different locations.', 'Required additional information of the 3 different locations of field trials conducted.', 2, 'PhEur is referred for testing of the increase in virulence. Results of reversion to virulence testing of both MSV are complying with the test. Acceptable.\r\nHIPRAVIAR/H120\r\n52-61/317 (NDV)\r\n62-71/317 (IBV)', 'Required additional information of the lesions observed in inoculated compared to control groups.', 2, 'Slight respiratory reactions were reported at 3 but recovered after 5 dpv, hence the vaccine able to provide effective protection (>80%) at 2-8 dpc. Acceptable.\r\nHIPRAVIAR/H120\r\n74-89/317', 'Required additional information of the effect of the vaccine on respiratory (ciliostasis test), and kidney and intestinal tract lesions observation.', 0, 'Procedure for determination of MID not provided.', 'Required additional information of the description of method/procedure of determining the MID.', 2, '1)	For NDV strain La Sota, results showed that the SNI is >2.4 and the HI titre >3.6 at the first 45 dpv (60 days of age). Acceptable.\r\n2)	For IBV strain H120, results showed that the SNI is >2.9 (acceptable cut-off is â‰¥2) and the HI titre >3.1 at the first 45 dpv (60 days of age). Acceptable.', '', 0, 'Not provided.', 'Required additional information of immune response and duration following immunization by the vaccine in progeny.', 6, 'Vaccine: 18 months from the date of manufacture date (stored at 2-8Â°C, protected from light)\r\nSolvent: 5 years from the date of manufacture date\r\nHIPRAVIAR/H120\r\n48/317', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 67, 33, 56, 100, 78, 54, 67, 33),
(000075, 000048, 'Hipra Viar S/H120', 'Labarotorios Hipra S.A. Spain', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000076, 000048, 'Hipra Viar S/H120', 'Labarotorios Hipra S.A. Spain', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000077, 000049, 'Himmvac Dalguban BN Plus Oil Vaccine', 'KBNP Inc. Korea', 'Private', 'Biologic Production', 'Recombinant', 'SURIANI MOHD NOOR', 'A', 'Draft', '', 6, 'page  237-238\r\nManufacturing license number : 6\r\n2) No expiry date stated on both  certificate GMP and Manufacturing', 'To provide latest certificate  with the valid expiry date  OR  to provide  original letter of endorsement  from the  authority  ', 0, 'Korea', '', 6, 'Page 248\r\n1) Authorization  dated on March 30 2011\r\nProduct -licence number : 6-258\r\n2) No expiry date', '', 6, 'page 130-132\r\n1) Batch : \r\nBNPK0116 \r\nBNPK0216, \r\nBNPK0316\r\n', '', 6, 'Product  license number: 6--258\r\nDate of  approve : 1 Sept 2009', '', 6, 'registered in Myanmar  and Nepal', '', 4, 'Class II', 'To  provide letter of approval by the authority related to  the biosafety for the development of recombinant MSV', 0, 'Page 11\r\nfor immunization of  breeding and laying chicken at 16-20wks of age, preimmunized with live virus', 'not stated in the pamphlet and label', 6, 'page 60\r\n3 batch vaccine tested ', '', 4, '', '', 0, 'Not relavant for killed vaccine', '', 4, 'written in English ', '', 6, '', '', 6, '', '', 6, '', '', 2, '', '', 6, '', '', 4, 'Master  seed lot management not stated ', '', 4, '', 'Please provide genetic sequence of HN and F gene of ND gVII virus 4152 strain.\r\n\r\nAnd resubmit softcopy of the original article (not scanned copy) of \r\n\r\nSun-Hee Cho, Sun-Joong Kim, Hyuk-Joon Kwon (2007). Genomic sequence of an antigen variant Newcastle disease virus isolated in Korea. Virus Gene\r\n', 4, 'page 82-85', '', 6, 'Not related ', '', 0, '', 'to provide infomation on SPF  production standard ', 0, '', '', 0, 'inactivation process was  using formalin at 0.2% final concentration for 20hrs \r\ninactivation kinetic  not provided', 'to provide inactivation kinetic curve\r\nCOA fomalin ', 4, '', '', 4, '', '', 4, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 67, 100, 56, 67, 70, 46, 0, 0),
(000078, 000049, 'Himmvac Dalguban BN Plus Oil Vaccine', 'KBNP Inc. Korea', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000079, 000049, 'Himmvac Dalguban BN Plus Oil Vaccine', 'KBNP Inc. Korea', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000080, 000050, 'NOVAMUNE', 'CEVA-PHYLAXIA Veterinary Biologicals Co. Ltd. Hungary', 'Private', 'Biologic Production', 'Recombinant', 'DR. ANI YARDI', 'A', 'Draft', '', 6, 'Licenses and GMP expiry dates : 19/2/2021', '', 6, 'Hungary', '', 6, 'Letter of Authorization valid for 5 years 05 March 2018 - 04 March 2023', '', 6, '001FRF/ 002FRF/ 003FRF', 'certifica te 001FRF/ 002FRF mempunyai tarikh pembuatan dan tarikh expiry yang sama. Sila terangkan mengapa mempunyai tarikh yang sama.   Safety tidak dinyatakan dalam COA                 ', 6, 'Ref: 5300/2263-2/2020 bertarikh 14.05.2020', '', 6, ' PHILIPPINES REF NO: R-2187 , expiry 29.01.2020              ', 'Certificate registration di Ireland tidak disertakan. Sila sertakan sijil terkini ', 6, '', 'live viral vaccine in immune complex to stimulate immunity against IBD viruses', 6, 'One injection of 0.2ml per chicken at one day of age is applied once, SQ by automatic or manual injection device', '', 6, 'Day old chick/layer chicken', '', 4, 'One injection of 0.2ml per chicken at one day of age.The vaccine should e administered by subcutaneous injection under the skin of the neck by menas of an automatic or manual injection device', 'Procedur untuk menjalankan potency test ada ditunjukkan. Result potency: ELISA dan histological lesion of bursa of fabricius tidak disertakan.', 0, 'solvent CID50%.\r\nComposition of solvent attached', 'COA solvent tidak disertakan.\r\ngambar solvent not attached', 2, 'available in 1000 and 2000 doses', 'stated in pamphlet not in packaging', 4, '', 'No 3D specimen picture attached', 6, 'stated in pamphlet', '', 4, 'for the active immunization of DOC of layer chicks to reduce mortality, clinical signs, acute lesions of bursa of fabricius and to prevent virus sheddingby classical and very virulent strains of IBD virus', 'not stated for contraindication', 4, 'general precautions stated', 'no side effects stated/declared', 6, '', '', 2, 'MSV is Avian Infectious bursal disease virus, strain 228E, commercially available', 'no MSV certificate attached.\r\nvalidation test not attached.\r\nAdakah COA yang diberi untuk MSV atau WSV?\r\nMSV didaftarkan dimana?', 0, '', 'tiada validation data attached\r\n', 0, 'Avian infectious bursal disease virus, strain SYZA26, code: 1.1.36\r\nSource, origin\r\nThe source of the MSV is a commercially available vaccine containing the 228E vaccine\r\nstrain. The IBDV SYZA26 MSV is the first passage of the original vaccine strain. Avian IBDV strain SYZA26  is the 1st passage of IBD strain 228E and used as for production for novamune vaccine.', 'COA utk master seed tidak disertakan. COA Appendix 3.1 adakah untuk Avian IBDV strain SYZA26  is the 1st passage of IBD strain 228E?', 4, 'COA SPF Egg  tarikh sijil terlalu lama', 'sila lampirkan sijil yag terkini. validation test SPF Egg test sila lampirkan', 4, '', 'COA SPF Egg...sila hantar yang terkini.\r\nValidation test tidak dilampirkan', 0, 'Starting materials of non-biological origin is not applicable. There is no chemical substance used.', '', 0, 'Soalan ini not applicable for live vaccine\r\n', '', 0, '', 'sila lampirkan attenuation process  ', 0, '', '', 0, '', '', 0, 'Tidak dinyatakan dalam COA', '', 0, 'not applicable', '', 2, 'MSV is commercially available. Preparation of WSV made up to 4 passage in SPF eggs. Control test carried out on MSV based on Ph. Eur.  \r\n', 'Diluent yang digunakan dalam MSV certificate tidak.\r\ndisertakan. Validation of MSV tidak dibuktikan.\r\nprosses passage tidak dinyatakan. Identification of MSV by sequencing tidak disertakan. Tidak dapat nak buat analisis sequencing both MSV dan WSV kerana tidak disertakan.\r\nDetermination of virus content untuk membuktikan enough infective titre tidak dilampirkan, hanya ada statement sahaja.\r\n', 0, 'COA final product attached', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 100, 100, 100, 67, 52, 17, 4, 0),
(000081, 000050, 'NOVAMUNE', 'CEVA-PHYLAXIA Veterinary Biologicals Co. Ltd. Hungary', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000082, 000050, 'NOVAMUNE', 'CEVA-PHYLAXIA Veterinary Biologicals Co. Ltd. Hungary', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000083, 000051, 'Marek-Vac Bivalent Frozen', 'F. E. Venture Sdn Bhd', 'Private', 'Biologic Production', 'Recombinant', 'DR FAIZAH HANIM MOHD SAIED', 'A', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000084, 000051, 'Marek-Vac Bivalent Frozen', 'F. E. Venture Sdn Bhd', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000085, 000051, 'Marek-Vac Bivalent Frozen', 'F. E. Venture Sdn Bhd', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000086, 000052, 'AviPro MG F', 'Lohmann Animal Health International', 'Private', 'Biologic Production', 'Recombinant', 'DR. ALIFAH ISMAIL', 'A', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000087, 000052, 'AviPro MG F', 'Lohmann Animal Health International', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000088, 000052, 'AviPro MG F', 'Lohmann Animal Health International', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000089, 000053, 'Evalon', 'Labarotorios Hipra S.A. Spain', 'Private', 'Biologic Production', 'Recombinant', 'DR. LEE CHAI HA', 'A', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000090, 000053, 'Evalon', 'Labarotorios Hipra S.A. Spain', 'Private', 'Biologic Production', 'Recombinant', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000091, 000053, 'Evalon', 'Labarotorios Hipra S.A. Spain', 'Private', 'Biologic Production', 'Recombinant', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000092, 000055, 'Hipraviar S', 'Laboratorios Hipra, S.A, Spain', 'Private', 'Biologic Production', 'Live', 'SUHAIMI DOLLAH', 'A', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000093, 000055, 'Hipraviar S', 'Laboratorios Hipra, S.A, Spain', 'Private', 'Biologic Production', 'Live', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000094, 000055, 'Hipraviar S', 'Laboratorios Hipra, S.A, Spain', 'Private', 'Biologic Production', 'Live', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000095, 000056, 'VAKSIMUNE IBH INACTIVE', 'VAKSINDO SATWA NUSANTARA, INDONESIA', 'Private', 'Biologic Production', 'Killed', 'DR. NORINA LOKMAN', 'A', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000096, 000056, 'VAKSIMUNE IBH INACTIVE', 'VAKSINDO SATWA NUSANTARA, INDONESIA', 'Private', 'Biologic Production', 'Killed', '', 'B', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000097, 000056, 'VAKSIMUNE IBH INACTIVE', 'VAKSINDO SATWA NUSANTARA, INDONESIA', 'Private', 'Biologic Production', 'Killed', '', 'C', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000125, 000066, 'Test Vaksin 30 Sept 2020', 'Asia Big Wave Sdn. Bhd.', 'Public/Government', 'Research', 'Live', 'SHARIL AZWAN', 'A', 'Complete', '01/10/2020', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 0, '', '', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020testing 30092020</p>', '<p>testing 30092020</p>', 0, '', '', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 0, '', '', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 6, '<p>testing 30092020</p>', '<p>testing 30092020</p>', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', '', 'testing 30092020', 'testing 30092020', '', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', '', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', 'testing 30092020', '<ul>\r\n<li>percubaan 1 2 3</li>\r\n<li>satu</li>\r\n<li>dua</li>\r\n<li>tiga</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>percubaan dua</p>\r\n<p>&nbsp;</p>\r\n<p><strong>percubaan tiga</strong></p>', 'KIV', 100, 100, 100, 100, 100, 100, 100, 100),
(000126, 000066, 'Test Vaksin 30 Sept 2020', 'Asia Big Wave Sdn. Bhd.', 'Public/Government', 'Research', 'Live', '', 'B', 'Draft', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000127, 000066, 'Test Vaksin 30 Sept 2020', 'Asia Big Wave Sdn. Bhd.', 'Public/Government', 'Research', 'Live', '', 'C', 'Draft', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000128, 000067, 'testing 1230', 'Asia Big Wave Sdn. Bhd.', 'Public/Government', 'Research', 'Live', 'SHARIL AZWAN', 'A', 'Draft', '', 4, '', '', 4, '', '', 4, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 4, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 67, 0, 0, 67, 0, 0, 0, 0),
(000129, 000067, 'testing 1230', 'Asia Big Wave Sdn. Bhd.', 'Public/Government', 'Research', 'Live', '', 'B', 'Draft', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000130, 000067, 'testing 1230', 'Asia Big Wave Sdn. Bhd.', 'Public/Government', 'Research', 'Live', '', 'C', 'Draft', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000131, 000068, 'Test Prescreen 12 Nov 2020', 'Dose & Dosage Sdn. Bhd.', 'Private', 'Diagnostic', 'Killed', 'SHARIL AZWAN', 'A', 'Draft', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000132, 000068, 'Test Prescreen 12 Nov 2020', 'Dose & Dosage Sdn. Bhd.', 'Private', 'Diagnostic', 'Killed', '', 'B', 'Draft', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0),
(000133, 000068, 'Test Prescreen 12 Nov 2020', 'Dose & Dosage Sdn. Bhd.', 'Private', 'Diagnostic', 'Killed', '', 'C', 'Draft', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `prescreen`
--

CREATE TABLE `prescreen` (
  `id` int(6) UNSIGNED ZEROFILL NOT NULL,
  `tradename` text NOT NULL,
  `description` text NOT NULL,
  `nature` text NOT NULL,
  `appcomp` text NOT NULL,
  `prescreendate` date NOT NULL,
  `duedate` date NOT NULL,
  `prescreenby` text NOT NULL,
  `A1` text NOT NULL,
  `A2` text NOT NULL,
  `A3` text NOT NULL,
  `A4` text NOT NULL,
  `A5` text NOT NULL,
  `A6` text NOT NULL,
  `A7` text NOT NULL,
  `Q1A1` text NOT NULL,
  `Q1A2` text NOT NULL,
  `Q1A3` text NOT NULL,
  `Q1A4` text NOT NULL,
  `Q1A5` text NOT NULL,
  `Q1A6` text NOT NULL,
  `Q1A7` text NOT NULL,
  `Q1A8` text NOT NULL,
  `Q1A9` text NOT NULL,
  `Q1A10` text NOT NULL,
  `Q1B1` text NOT NULL,
  `Q1B2` text NOT NULL,
  `Q1C1` text NOT NULL,
  `Q1D1` text NOT NULL,
  `Q1E1` text NOT NULL,
  `Q1E2` text NOT NULL,
  `Q1E3` text NOT NULL,
  `Q1E4` text NOT NULL,
  `Q1F1` text NOT NULL,
  `Q1G1` text NOT NULL,
  `Q1G2` text NOT NULL,
  `Q2A1` text NOT NULL,
  `Q2A2` text NOT NULL,
  `Q2A3` text NOT NULL,
  `Q2A4` text NOT NULL,
  `Q2A5` text NOT NULL,
  `Q2A6` text NOT NULL,
  `Q2A7` text NOT NULL,
  `Q2A8` text NOT NULL,
  `Q2A9` text NOT NULL,
  `Q2B1` text NOT NULL,
  `Q2B2` text NOT NULL,
  `Q2B3` text NOT NULL,
  `Q2B4` text NOT NULL,
  `Q2B5` text NOT NULL,
  `Q2B6` text NOT NULL,
  `Q2B7` text NOT NULL,
  `Q3A1` text NOT NULL,
  `Q3C1` text NOT NULL,
  `Q3C2` text NOT NULL,
  `Q3D1` text NOT NULL,
  `Q3D2` text NOT NULL,
  `Q3D3` text NOT NULL,
  `Q3D4` text NOT NULL,
  `Q3D5` text NOT NULL,
  `Q41` text NOT NULL,
  `Q42` text NOT NULL,
  `Q43` text NOT NULL,
  `Q44` text NOT NULL,
  `Q4A1` text NOT NULL,
  `Q4A2` text NOT NULL,
  `Q4B1` text NOT NULL,
  `Q4B2` text NOT NULL,
  `Q4B3` text NOT NULL,
  `Q4B4` text NOT NULL,
  `Q4B5` text NOT NULL,
  `Q4B6` text NOT NULL,
  `Q4B7` text NOT NULL,
  `Q4B8` text NOT NULL,
  `Q4B9` text NOT NULL,
  `Q4C1` text NOT NULL,
  `Q4D1` text NOT NULL,
  `Q4D2` text NOT NULL,
  `Q4E1` text NOT NULL,
  `Q4E2` text NOT NULL,
  `Q4F1` text NOT NULL,
  `Q4F2` text NOT NULL,
  `Q51A1` text NOT NULL,
  `Q51A2` text NOT NULL,
  `Q51A3` text NOT NULL,
  `Q51A4` text NOT NULL,
  `Q51A5` text NOT NULL,
  `Q51A6` text NOT NULL,
  `Q51B` text NOT NULL,
  `Q51C1` text NOT NULL,
  `Q51C2` text NOT NULL,
  `Q51D1` text NOT NULL,
  `Q51D2` text NOT NULL,
  `Q51E1` text NOT NULL,
  `Q51E2` text NOT NULL,
  `Q51E3` text NOT NULL,
  `Q51F1` text NOT NULL,
  `Q51F2` text NOT NULL,
  `Q51F3` text NOT NULL,
  `Q51G1` text NOT NULL,
  `Q51G2` text NOT NULL,
  `Q51G3` text NOT NULL,
  `Q51G4` text NOT NULL,
  `Q51H1` text NOT NULL,
  `Q51H2` text NOT NULL,
  `Q51I` text NOT NULL,
  `Q51J1` text NOT NULL,
  `Q51J2` text NOT NULL,
  `Q51J3` text NOT NULL,
  `Q51J4` text NOT NULL,
  `Q52K1` text NOT NULL,
  `Q52l1` text NOT NULL,
  `Q52M1` text NOT NULL,
  `Q52N1` text NOT NULL,
  `Q52O1` text NOT NULL,
  `Q52P1` text NOT NULL,
  `Q52Q1` text NOT NULL,
  `Q531` text NOT NULL,
  `Q532` text NOT NULL,
  `Q533` text NOT NULL,
  `Q534` text NOT NULL,
  `Q535` text NOT NULL,
  `Q536` text NOT NULL,
  `Q537` text NOT NULL,
  `Q538` text NOT NULL,
  `Q539` text NOT NULL,
  `Q5310` text NOT NULL,
  `Q5311` text NOT NULL,
  `Q54R1` text NOT NULL,
  `Q54S1` text NOT NULL,
  `Q55T1` text NOT NULL,
  `Q55T2` text NOT NULL,
  `Q55T3` text NOT NULL,
  `Q55U1` text NOT NULL,
  `Q55U2` text NOT NULL,
  `Q55V1` text NOT NULL,
  `Q55W1` text NOT NULL,
  `Q55X1` text NOT NULL,
  `Q6` text NOT NULL,
  `submission` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prescreen`
--

INSERT INTO `prescreen` (`id`, `tradename`, `description`, `nature`, `appcomp`, `prescreendate`, `duedate`, `prescreenby`, `A1`, `A2`, `A3`, `A4`, `A5`, `A6`, `A7`, `Q1A1`, `Q1A2`, `Q1A3`, `Q1A4`, `Q1A5`, `Q1A6`, `Q1A7`, `Q1A8`, `Q1A9`, `Q1A10`, `Q1B1`, `Q1B2`, `Q1C1`, `Q1D1`, `Q1E1`, `Q1E2`, `Q1E3`, `Q1E4`, `Q1F1`, `Q1G1`, `Q1G2`, `Q2A1`, `Q2A2`, `Q2A3`, `Q2A4`, `Q2A5`, `Q2A6`, `Q2A7`, `Q2A8`, `Q2A9`, `Q2B1`, `Q2B2`, `Q2B3`, `Q2B4`, `Q2B5`, `Q2B6`, `Q2B7`, `Q3A1`, `Q3C1`, `Q3C2`, `Q3D1`, `Q3D2`, `Q3D3`, `Q3D4`, `Q3D5`, `Q41`, `Q42`, `Q43`, `Q44`, `Q4A1`, `Q4A2`, `Q4B1`, `Q4B2`, `Q4B3`, `Q4B4`, `Q4B5`, `Q4B6`, `Q4B7`, `Q4B8`, `Q4B9`, `Q4C1`, `Q4D1`, `Q4D2`, `Q4E1`, `Q4E2`, `Q4F1`, `Q4F2`, `Q51A1`, `Q51A2`, `Q51A3`, `Q51A4`, `Q51A5`, `Q51A6`, `Q51B`, `Q51C1`, `Q51C2`, `Q51D1`, `Q51D2`, `Q51E1`, `Q51E2`, `Q51E3`, `Q51F1`, `Q51F2`, `Q51F3`, `Q51G1`, `Q51G2`, `Q51G3`, `Q51G4`, `Q51H1`, `Q51H2`, `Q51I`, `Q51J1`, `Q51J2`, `Q51J3`, `Q51J4`, `Q52K1`, `Q52l1`, `Q52M1`, `Q52N1`, `Q52O1`, `Q52P1`, `Q52Q1`, `Q531`, `Q532`, `Q533`, `Q534`, `Q535`, `Q536`, `Q537`, `Q538`, `Q539`, `Q5310`, `Q5311`, `Q54R1`, `Q54S1`, `Q55T1`, `Q55T2`, `Q55T3`, `Q55U1`, `Q55U2`, `Q55V1`, `Q55W1`, `Q55X1`, `Q6`, `submission`) VALUES
(000018, 'Test Vaksin 30 Sept 2020', 'Test Vaksin description', 'Live', 'Asia Big Wave Sdn. Bhd.', '2020-09-30', '2020-11-01', 'masrin azami 2', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Newcastle Disease (avian paramyxovirus 1)', 'Yes', 'Yes', 'VG / GA', 'Yes', 'Poultry (Broiler)', 'Yes', 'Inactivated', 'Yes', 'Formosa Biomedical Inc., Taiwan', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Australia', 'Yes', 'Thailand', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Veterinary Research Institute', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Evaluation'),
(000019, 'Test Prescreen 12 Nov 2020', 'aaaa', 'Killed', 'Dose & Dosage Sdn. Bhd.', '2020-10-02', '2020-11-02', 'masrin azami 2', 'No', 'No', 'No', 'No', 'No', 'No', 'No', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Evaluation'),
(000020, 'testing 1230', 'test1230', 'Live', 'Asia Big Wave Sdn. Bhd.', '2020-11-14', '2020-11-13', 'masrin azami 2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Evaluation');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(6) UNSIGNED ZEROFILL NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` text NOT NULL,
  `post` varchar(50) NOT NULL,
  `phone` int(11) NOT NULL,
  `pass` text NOT NULL,
  `role` text NOT NULL,
  `status` text NOT NULL,
  `addedby` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `name`, `email`, `post`, `phone`, `pass`, `role`, `status`, `addedby`) VALUES
(000001, 'masrin azami 2', 'masrin@dvs.gov.my', 'Pegawai Penyelidik', 1123456789, '123456', 'Administrator', 'Active', ''),
(000002, 'suhaimi', 'suhaimi@dvs.gov.my', 'ro', 0, '123456', 'Evaluator', 'Active', ''),
(000011, 'fakhrulisham razali', 'sham@sham.com', 'vo', 123456, '123456', 'Evaluator', 'Active', ''),
(000012, 'SHARIL AZWAN', 'sharil@sharil.com', 'RO', 999, '123456', 'Evaluator', 'Active', ''),
(000019, 'DR. ALIFAH ISMAIL', 'dralifah@gmail.com', 'VO', 123, '123456', 'Administrator', 'Active', 'masrin azami 2'),
(000020, 'DR. ALIFAH ISMAIL', 'dralifah2@gmail.com', 'VO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000021, 'DR. ANI YARDI', 'ani@dvs.gov.my', 'VO', 123, '123456', 'Administrator', 'Active', 'masrin azami 2'),
(000022, 'DR. ANI YARDI', 'ani2@dvs.gov.my', 'VO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000023, 'DR. RACHEL', 'rachelfong@dvs.gov.my', 'VO', 123, '123456', 'Administrator', 'Active', 'masrin azami 2'),
(000024, 'RAZLINA RAGHAZLI', 'razlina@dvs.gov.my', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000025, 'MOHD ISWADI ISMAIL', 'iswadi@dvs.gov.my', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000026, 'AZRULNIZAM JAAFAR', 'azrul@dvs.gov.my', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000027, 'SURIANI MOHD NOOR', 'surianivri@gmail.com', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000028, 'SUHAIMI DOLLAH', 'suhaimi.dollah@yahoo.com', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000029, 'NUR AKHMAH AHMAD KHUSHAIRI', 'akhmah@dvs.gov.my', 'VO', 123, '123456', 'Administrator', 'Active', 'masrin azami 2'),
(000030, 'NORAZURA A. HAMID', 'norazura@dvs.gov.my', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000031, 'DR. LEE CHAI HA', 'chaihalee@yahoo.com', 'VO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000032, 'ROSLINA HASSAN', 'rlina0876@yahoo.com', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000033, 'ROSELIZA ROSLEE', 'roseliza@dvs.gov.my', 'RO', 123, '123456', 'Evaluator', 'Active', 'masrin azami 2'),
(000034, 'SAMSUL BAHRI MOHDER', 'samsul@dvs.gov.my', 'RO', 123, '123456', 'Administrator', 'Active', 'masrin azami 2'),
(000035, 'DR NURUL HUDA DATO MOHD ZAIRI', 'huda@dvs.gov.my', 'VETERINAR OFFICER', 1163095099, '123456', 'Evaluator', 'Active', 'NUR AKHMAH AHMAD KHUSHAIRI'),
(000036, 'DR FAIZAH HANIM MOHD SAIED', 'faizah@dvs.gov.my', 'VETERINAR OFFICER', 134786201, '123456', 'Evaluator', 'Active', 'NUR AKHMAH AHMAD KHUSHAIRI'),
(000037, 'DR. NORINA LOKMAN', 'norina@dvs.gov.my', 'VO', 109615232, '123456', 'Evaluator', 'Active', 'NUR AKHMAH AHMAD KHUSHAIRI');

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

--
-- Table structure for table `vacc`
--

CREATE TABLE `vacc` (
  `idvac` int(6) UNSIGNED ZEROFILL NOT NULL,
  `statusform` text NOT NULL,
  `tradename` text NOT NULL,
  `manufacturername` text NOT NULL,
  `locagentadd` text NOT NULL,
  `loacagentphone` text NOT NULL,
  `plantaff` text NOT NULL,
  `mainplant` text NOT NULL,
  `vacctype` text NOT NULL,
  `dateaddtask` text NOT NULL,
  `addedby` text NOT NULL,
  `AssessA` text,
  `AssessB` text,
  `AssessC` text,
  `dateassign` text,
  `assignby` text,
  `statusassign` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vacc`
--

INSERT INTO `vacc` (`idvac`, `statusform`, `tradename`, `manufacturername`, `locagentadd`, `loacagentphone`, `plantaff`, `mainplant`, `vacctype`, `dateaddtask`, `addedby`, `AssessA`, `AssessB`, `AssessC`, `dateassign`, `assignby`, `statusassign`) VALUES
(000029, 'Draft', 'NDVAC (Testing)', 'NDVAC VRI', 'NDVAC ADD', 'NDVAC 038870', 'Public/Government', 'Diagnostic', 'Killed', '11/12/2019', 'masrin azami 2', 'SHARIL AZWAN', 'fakhrulisham razali', 'suhaimi', '11/12/2019', 'masrin azami 2', 'Yes'),
(000041, 'Draft', 'Aujeszky oilsuivax gl ', 'Fatro S.P.A. Italy', 'F. E. Venture Sdn Bhd', '', 'Private', 'Biologic Production', 'Recombinant', '21/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'NORAZURA A. HAMID', '', '', '21/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000042, 'Draft', 'BIO-VAC REO', 'FATRO S.p.A.', 'F. E. Venture Sdn Bhd', '03-56333493', 'Private', 'Biologic Production', 'Live', '21/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'AZRULNIZAM JAAFAR', '', '', '21/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000043, 'Draft', 'Fortegra', 'Intervet Inc, Moris Avenue', 'Intervet (M) Sdn Bhd', '03-74991600', 'Private', 'Biologic Production', 'Live', '21/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'RAZLINA RAGHAZLI', '', '', '21/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000044, 'Draft', 'FOSTERA PCV MH VACCINE', 'Zoetis Inc. USA', 'ZOETIS MALAYSIA SDN BHD', '0', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'DR NURUL HUDA DATO MOHD ZAIRI', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000045, 'Draft', 'Parvo Shield L5E', 'ELANCO US Inc. USA', 'Eli Lily (Malaysia) Sdn Bhd', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'ROSLINA HASSAN', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000047, 'Draft', 'Porcine Pili Shield +C', 'ELANCO US Inc. USA', 'Eli Lily (Malaysia) Sdn Bhd', '0', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'ROSELIZA ROSLEE', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000048, 'Draft', 'Hipra Viar S/H120', 'Labarotorios Hipra S.A. Spain', 'Hipra Malaysia', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'MOHD ISWADI ISMAIL', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000049, 'Draft', 'Himmvac Dalguban BN Plus Oil Vaccine', 'KBNP Inc. Korea', 'Nutripharmax', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'SURIANI MOHD NOOR', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000050, 'Draft', 'NOVAMUNE', 'CEVA-PHYLAXIA Veterinary Biologicals Co. Ltd. Hungary', 'Ceva Animal Health Malaysia', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'DR. ANI YARDI', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000051, 'Draft', 'Marek-Vac Bivalent Frozen', 'F. E. Venture Sdn Bhd', 'Fatro S.P.A via Emilia 285 Ozzano dell Emilia (bo) Italy', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'DR FAIZAH HANIM MOHD SAIED', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000052, 'Draft', 'AviPro MG F', 'Lohmann Animal Health International', 'Ritma Prestasi Sdn Bhd', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'DR. ALIFAH ISMAIL', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000053, 'Draft', 'Evalon', 'Labarotorios Hipra S.A. Spain', 'Hipra Malaysia', '', 'Private', 'Biologic Production', 'Recombinant', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'DR. LEE CHAI HA', '', '', '22/07/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000054, 'Draft', 'Test 23072020', 'Test 23072020', 'Test 23072020', '23072020', 'Public/Government', 'Research', 'Live', '23/07/2020', 'masrin azami 2', '', '', '', '07/09/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000055, 'Draft', 'Hipraviar S', 'Laboratorios Hipra, S.A, Spain', 'Hipra (M) Sdn. Bhd.', 'Dr. Rosnizam Abdul rahman/0126074569', 'Private', 'Biologic Production', 'Live', '12/08/2020', 'DR. ANI YARDI', 'SUHAIMI DOLLAH', '', '', '12/08/2020', 'DR. ANI YARDI', 'Yes'),
(000056, 'Draft', 'VAKSIMUNE IBH INACTIVE', 'VAKSINDO SATWA NUSANTARA, INDONESIA', 'BIOVICTORY SDN. BHD', '0 12-329 1854', 'Private', 'Biologic Production', 'Killed', '01/09/2020', 'DR. ANI YARDI', 'DR. NORINA LOKMAN', '', '', '01/09/2020', 'NUR AKHMAH AHMAD KHUSHAIRI', 'Yes'),
(000066, 'Complete', 'Test Vaksin 30 Sept 2020', 'Asia Big Wave Sdn. Bhd.', 'Ipoh', '0111234567890', 'Public/Government', 'Research', 'Live', '30/09/2020', 'masrin azami 2', 'SHARIL AZWAN', '', '', '30/09/2020', 'masrin azami 2', 'Yes'),
(000067, 'Draft', 'testing 1230', 'Asia Big Wave Sdn. Bhd.', 'cyberjaya', '0123', 'Public/Government', 'Research', 'Live', '12/11/2020', 'masrin azami 2', 'SHARIL AZWAN', '', '', '12/11/2020', 'masrin azami 2', 'Yes'),
(000068, 'Draft', 'Test Prescreen 12 Nov 2020', 'Dose & Dosage Sdn. Bhd.', 'presint 1', '999', 'Private', 'Diagnostic', 'Killed', '12/11/2020', 'masrin azami 2', 'SHARIL AZWAN', '', '', '12/11/2020', 'masrin azami 2', 'Yes');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `data_appcompany`
--
ALTER TABLE `data_appcompany`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_asian`
--
ALTER TABLE `data_asian`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_disease`
--
ALTER TABLE `data_disease`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_manu`
--
ALTER TABLE `data_manu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_refcount`
--
ALTER TABLE `data_refcount`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_source`
--
ALTER TABLE `data_source`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_species`
--
ALTER TABLE `data_species`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_strain`
--
ALTER TABLE `data_strain`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_vaccine`
--
ALTER TABLE `data_vaccine`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dossierform`
--
ALTER TABLE `dossierform`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `prescreen`
--
ALTER TABLE `prescreen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `vacc`
--
ALTER TABLE `vacc`
  ADD PRIMARY KEY (`idvac`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `data_appcompany`
--
ALTER TABLE `data_appcompany`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `data_asian`
--
ALTER TABLE `data_asian`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `data_disease`
--
ALTER TABLE `data_disease`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `data_manu`
--
ALTER TABLE `data_manu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `data_refcount`
--
ALTER TABLE `data_refcount`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `data_source`
--
ALTER TABLE `data_source`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `data_species`
--
ALTER TABLE `data_species`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `data_strain`
--
ALTER TABLE `data_strain`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `data_vaccine`
--
ALTER TABLE `data_vaccine`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `dossierform`
--
ALTER TABLE `dossierform`
  MODIFY `id` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=134;

--
-- AUTO_INCREMENT for table `prescreen`
--
ALTER TABLE `prescreen`
  MODIFY `id` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `vacc`
--
ALTER TABLE `vacc`
  MODIFY `idvac` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
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 */;
