-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 05, 2012 at 12:05 PM
-- Server version: 5.0.77
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Database: `db_bci_current`
--

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

--
-- Table structure for table `tempPersonnelInfo_P17`
--

CREATE TABLE IF NOT EXISTS `tempPersonnelInfo_P17` (
  `QuadratName` char(12) default NULL,
  `PersonnelID` smallint(5) unsigned default NULL,
  `Role` varchar(128) default NULL,
  `RoleID` smallint(5) unsigned default NULL,
  `DateWorked` date default NULL,
  `QuadratID` int(10) unsigned default NULL,
  `CensusID` int(10) unsigned default NULL,
  `PlotCensusNumber` int(10) unsigned default NULL,
  `PlotID` int(10) unsigned default NULL,
  `Form` varchar(32) default NULL,
  `Errors` varchar(256) default NULL,
  `tempID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`tempID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=275 ;

--
-- Dumping data for table `tempPersonnelInfo_P17`
--

INSERT INTO `tempPersonnelInfo_P17` (`QuadratName`, `PersonnelID`, `Role`, `RoleID`, `DateWorked`, `QuadratID`, `CensusID`, `PlotCensusNumber`, `PlotID`, `Form`, `Errors`, `tempID`) VALUES
('0000', 4, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 1),
('0000', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 2),
('0000', 22, 'data entry technician', NULL, '2012-04-10', NULL, NULL, NULL, NULL, 'old trees', NULL, 3),
('0000', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 4),
('0001', 4, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 5),
('0001', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 6),
('0001', 22, 'data entry technician', NULL, '2012-04-10', NULL, NULL, NULL, NULL, 'old trees', NULL, 7),
('0001', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 8),
('0002', 4, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 9),
('0002', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 10),
('0002', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 11),
('0002', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 12),
('0003', 4, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 13),
('0003', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 14),
('0003', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 15),
('0003', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 16),
('0004', 4, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 17),
('0004', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 18),
('0004', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 19),
('0004', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 20),
('0100', 82, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 21),
('0100', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 22),
('0100', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 23),
('0100', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 24),
('0101', 4, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 25),
('0101', 91, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 26),
('0101', 83, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 27),
('0101', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 28),
('0101', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 29),
('0101', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 30),
('0102', 90, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 31),
('0102', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 32),
('0102', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 33),
('0102', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 34),
('0103', 82, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 35),
('0103', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 36),
('0103', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 37),
('0103', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 38),
('0104', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 39),
('0104', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 40),
('0104', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 41),
('0104', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 42),
('0200', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 43),
('0200', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 44),
('0200', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 45),
('0200', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 46),
('0201', 87, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 47),
('0201', 83, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 48),
('0201', 91, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 49),
('0201', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'old trees', NULL, 50),
('0201', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 51),
('0201', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 52),
('0202', 90, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 53),
('0202', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 54),
('0202', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 55),
('0202', 86, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'old trees', NULL, 56),
('0203', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 57),
('0203', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 58),
('0203', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 59),
('0203', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 60),
('0204', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 61),
('0204', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 62),
('0204', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 63),
('0204', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 64),
('0300', 87, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 65),
('0300', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 66),
('0300', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 67),
('0300', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 68),
('0301', 87, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 69),
('0301', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'old trees', NULL, 70),
('0301', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 71),
('0301', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 72),
('0302', 87, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 73),
('0302', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 74),
('0302', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 75),
('0302', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 76),
('0303', 87, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 77),
('0303', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 78),
('0303', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 79),
('0303', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 80),
('0304', 87, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 81),
('0304', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 82),
('0304', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 83),
('0304', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 84),
('0400', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 85),
('0400', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 86),
('0400', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 87),
('0400', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 88),
('0400', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 89),
('0401', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 90),
('0401', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 91),
('0401', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 92),
('0401', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 93),
('0401', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 94),
('0402', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 95),
('0402', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 96),
('0402', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'old trees', NULL, 97),
('0402', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 98),
('0402', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 99),
('0403', 90, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 100),
('0403', 91, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 101),
('0403', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 102),
('0403', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 103),
('0403', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 104),
('0404', 90, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 105),
('0404', 91, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 106),
('0404', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'old trees', NULL, 107),
('0404', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'old trees', NULL, 108),
('0404', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'old trees', NULL, 109),
('0000', 4, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 110),
('0000', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 111),
('0000', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 112),
('0000', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 113),
('0001', 4, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 114),
('0001', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 115),
('0001', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 116),
('0001', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 117),
('0002', 4, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 118),
('0002', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 119),
('0002', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 120),
('0002', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 121),
('0003', 4, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 122),
('0003', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 123),
('0003', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 124),
('0003', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 125),
('0004', 4, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 126),
('0004', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 127),
('0004', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 128),
('0004', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 129),
('0100', 82, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 130),
('0100', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 131),
('0100', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 132),
('0100', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 133),
('0101', 4, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 134),
('0101', 91, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 135),
('0101', 83, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 136),
('0101', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 137),
('0101', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 138),
('0101', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 139),
('0102', 90, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 140),
('0102', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 141),
('0102', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 142),
('0102', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 143),
('0103', 82, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 144),
('0103', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 145),
('0103', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 146),
('0103', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 147),
('0104', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 148),
('0104', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 149),
('0104', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 150),
('0104', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 151),
('0200', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 152),
('0200', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 153),
('0200', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 154),
('0200', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 155),
('0201', 87, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 156),
('0201', 83, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 157),
('0201', 91, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 158),
('0201', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'new plants', NULL, 159),
('0201', 22, 'data entry technician', NULL, '2012-04-11', NULL, NULL, NULL, NULL, 'new plants', NULL, 160),
('0201', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 161),
('0202', 90, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 162),
('0202', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 163),
('0202', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 164),
('0202', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 165),
('0203', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 166),
('0203', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 167),
('0203', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 168),
('0203', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 169),
('0204', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 170),
('0204', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 171),
('0204', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 172),
('0204', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 173),
('0300', 87, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 174),
('0300', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 175),
('0300', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 176),
('0300', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 177),
('0301', 87, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 178),
('0301', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'new plants', NULL, 179),
('0301', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 180),
('0301', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 181),
('0302', 87, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 182),
('0302', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 183),
('0302', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 184),
('0302', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 185),
('0303', 87, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 186),
('0303', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 187),
('0303', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 188),
('0303', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 189),
('0304', 87, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 190),
('0304', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 191),
('0304', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 192),
('0304', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 193),
('0400', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 194),
('0400', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 195),
('0400', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 196),
('0400', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 197),
('0400', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 198),
('0401', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 199),
('0401', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 200),
('0401', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 201),
('0401', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 202),
('0401', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 203),
('0402', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 204),
('0402', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 205),
('0402', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'new plants', NULL, 206),
('0402', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 207),
('0402', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 208),
('0403', 90, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 209),
('0403', 91, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 210),
('0403', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 211),
('0403', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 212),
('0403', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 213),
('0404', 90, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 214),
('0404', 91, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 215),
('0404', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'new plants', NULL, 216),
('0404', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'new plants', NULL, 217),
('0404', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'new plants', NULL, 218),
('0002', 4, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 219),
('0002', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 220),
('0002', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 221),
('0002', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 222),
('0003', 4, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 223),
('0003', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 224),
('0003', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 225),
('0003', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 226),
('0100', 82, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 227),
('0100', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 228),
('0100', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 229),
('0100', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 230),
('0101', 4, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 231),
('0101', 91, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 232),
('0101', 83, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 233),
('0101', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 234),
('0101', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 235),
('0101', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 236),
('0102', 90, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 237),
('0102', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 238),
('0102', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 239),
('0102', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 240),
('0104', 82, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 241),
('0104', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 242),
('0104', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 243),
('0104', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 244),
('0201', 87, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 245),
('0201', 83, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 246),
('0201', 91, 'field technician', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 247),
('0201', 2, 'field supervisor', NULL, '2012-01-25', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 248),
('0201', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 249),
('0201', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 250),
('0202', 90, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 251),
('0202', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 252),
('0202', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 253),
('0202', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 254),
('0301', 87, 'field technician', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 255),
('0301', 2, 'field supervisor', NULL, '2012-01-26', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 256),
('0301', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 257),
('0301', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 258),
('0400', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 259),
('0400', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 260),
('0400', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 261),
('0400', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 262),
('0400', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 263),
('0401', 91, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 264),
('0401', 83, 'field technician', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 265),
('0401', 2, 'field supervisor', NULL, '2012-01-27', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 266),
('0401', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 267),
('0401', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'multiple stems', NULL, 268),
('0000', 82, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'big trees', NULL, 269),
('0000', 83, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'big trees', NULL, 270),
('0000', 87, 'field technician', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'big trees', NULL, 271),
('0000', 2, 'field supervisor', NULL, '2012-01-30', NULL, NULL, NULL, NULL, 'big trees', NULL, 272),
('0000', 22, 'data entry technician', NULL, '2012-04-12', NULL, NULL, NULL, NULL, 'big trees', NULL, 273),
('0000', 86, 'data entry technician', NULL, '2012-04-13', NULL, NULL, NULL, NULL, 'big trees', NULL, 274);
