--
-- Host: pmAnywhere3.db.11472283.hostedresource.com    Database: pmAnywhere3
-- ------------------------------------------------------


--
-- Dumping data for table `tiertwo`
--
-- WHERE:  tiertwo_company_id=28

INSERT INTO `tiertwo` VALUES (803,'BULL','Bullnose Kerb',851,'','','2018-05-24',28,1),(804,'GUTT','Gutter Kerb',851,'','','2018-05-24',28,1),(805,'BATT','Half Battered Kerb',851,'','','2018-05-24',28,1),(806,'HEEL','Heel Curb Kerb',851,'','','2018-05-24',28,1),(807,'WHEE','Wheel Stopper',851,'','','2018-05-24',28,1),(808,'PAVE','Pavers',854,'','','2018-05-24',28,1),(809,'PREC','Precast Concrete Blocks',854,'','','2018-05-24',28,1),(810,'10CM','10CM thick CMU Wall',855,'','','2018-05-25',28,1),(811,'15CM','15CM thick CMU Wall',855,'','','2018-05-25',28,1),(812,'20CM','20CM thick CMU Wall',855,'','','2018-05-24',28,1),(813,'12CM','12CM thick Red Brick Masonry Wall',856,'','','2018-05-25',28,1),(814,'23CM','23CM thick Red Brick Masonry Wall',856,'','','2018-05-25',28,1),(815,'34CM','34CM thick Red Brick Masonry Wall',856,'','','2018-05-25',28,1),(816,'46CM','46CM thick Red Brick Masonry Wall',856,'','','2018-05-25',28,1),(817,'2000','PCC 2000 PSI',858,'','','2018-04-25',28,1),(818,'4000','RCC 4000 PSI',859,'','','2018-04-25',28,1),(819,'5000','RCC 5000 PSI',859,'','','2018-04-25',28,1),(820,'CMAC','Cold Mix Asphalt Concrete',860,'','','2018-04-25',28,1),(821,'HMAC','Hot Mix Asphalt Concrete',860,'','','2018-04-25',28,1),(822,'SMAC','Specialty Mix Asphalt Concrete',860,'','','2018-04-26',28,1),(823,'WMAC','Warm Mix Asphalt Concrete',860,'','','2018-04-26',28,1),(824,'BLDG','Buildings Excavations Contractor',864,'','','2018-05-24',28,1),(825,'INFR','Infrastructure Excavations Contractor',864,'','','2018-05-24',28,1),(826,'ROAD','Road Earthworks Contractor',864,'','','2018-05-24',28,1),(827,'ROCK','Rock Excavations Contractor',864,'','','2018-05-25',28,1),(828,'UGTE','Underground/ Tunnel Excavations Contractor',864,'','','2018-05-24',28,1),(829,'ANDR','Android Software Developer',868,'','','2018-05-24',28,1),(830,'DATA','Database Developer',868,'','','2018-05-24',28,1),(831,'IOSD','IOS Software Developer',868,'','','2018-05-24',28,1),(832,'WEBD','Website Designer',868,'','','2018-05-24',28,1),(833,'CABL','Cables',879,'','','2018-05-04',28,1),(834,'CIRC','Circuit Breakers',879,'','','2018-05-04',28,1),(835,'DIST','Distribution Boards',879,'','','2018-05-04',28,1),(836,'METE','Electrical Meters',879,'','','2018-05-04',28,1),(837,'SWIT','Switchboards',879,'','','2018-05-04',28,1),(838,'TRAN','Transformers',879,'','','2018-05-04',28,1),(839,'CHIL','Chilled Water HVAC System',880,'','','2018-05-04',28,1),(840,'HYBR','Hybrid HVAC System',880,'','','2018-05-04',28,1),(841,'PACK','Packaged HVAC System',880,'','','2018-05-04',28,1),(842,'SPLI','Split HVAC System',880,'','','2018-05-04',28,1),(843,'AEMTS','Associate Engineer EMTS',882,'','','2018-06-23',28,1),(844,'FEMTS','Foreman EMTS',882,'','','2018-06-23',28,1),(845,'HEMTS','Helper EMTS',882,'','','2018-06-23',28,1),(846,'MEMTS','Manager EMTS',882,'','','2018-06-23',28,1),(847,'SEMTS','Supervising Engineer EMTS',882,'','','2018-06-23',28,1),(848,'TEMTS','Technician EMTS',882,'','','2018-06-23',28,1),(849,'ACMT','Associate Engineer CMT',885,'','','2018-04-26',28,1),(850,'FCMT','Foreman CMT',885,'','','2018-04-25',28,1),(851,'HCMT','Helper CMT	',885,'','','2018-04-25',28,1),(852,'OCMT','Operator Driver CMT	',885,'','','2018-04-25',28,1),(853,'SCMT','Supervising Engineer CMT',885,'','','2018-04-25',28,1),(854,'TCMT','Technician CMT	',885,'','','2018-04-25',28,1),(855,'AEMT','Associate Engineer EMT',890,'','','2018-04-26',28,1),(856,'EEMT','Executive EMT',890,'','','2018-04-25',28,1),(857,'FEMT','Foreman EMT',890,'','','2018-04-25',28,1),(858,'HEMT','Helper EMT',890,'','','2018-04-25',28,1),(859,'JEMT','Junior Engineer EMT',890,'','','2018-06-23',28,1),(860,'LEMT','Lead Engineer LEMT',890,'','','2018-06-23',28,1),(861,'MEMT','Manager EMT',890,'','','2018-04-25',28,1),(862,'OEMT','Operator Driver EMT',890,'','','2018-04-25',28,1),(863,'SEMT','Supervising Engineer EMT',890,'','','2018-04-25',28,1),(864,'TEMT','Technician EMT',890,'','','2018-04-25',28,1),(865,'EPMT','Executive PMT',891,'','','2018-04-26',28,1),(866,'MPMT','Manager PMT',891,'','','2018-04-26',28,1),(867,'AQMT','Associate Engineer QMT',892,'','','2018-05-24',28,1),(868,'EQMT','Executive QMT',892,'','','2018-05-24',28,1),(869,'MQMT','Manager QMT',892,'','','2018-05-24',28,1),(870,'SQMT','Supervising Engineer QMT',892,'','','2018-05-24',28,1),(871,'TQMT','Technician QMT',892,'','','2018-05-24',28,1),(872,'MSMT','Manager SMT',893,'','','2018-04-26',28,1),(873,'SSMT','Supervising Engineer SMT',893,'','','2018-04-26',28,1),(874,'CBDC1','Quality of Construction Rating Q1',894,'','','2018-04-25',28,1),(875,'CBDC2','Quality of Construction Rating Q2',894,'','','2018-04-25',28,1),(876,'CBDC3','Quality of Construction Rating Q3',894,'','','2018-04-25',28,1),(877,'RBDC1','Quality of Construction Rating Q1',895,'','','2018-05-04',28,1),(878,'RBDC2','Quality of Construction Rating Q2',895,'','','2018-05-04',28,1),(879,'RBDC3','Quality of Construction Rating Q3',895,'','','2018-05-04',28,1),(880,'BOUL','Boulder (>256 mm)',896,'','','2018-04-25',28,1),(881,'COBB','Cobble (64 - 255 mm)',896,'','','2018-04-25',28,1),(882,'CRUS','Crush Stone (2 - 63 mm)',896,'','','2018-04-25',28,1),(883,'SAND','Sand (0.06 - 2.0mm)',896,'','','2018-04-25',28,1),(884,'OPC1','Ordinary Portland Cement Type 1',898,'','','2018-04-25',28,1),(885,'OPC2','Ordinary Portland Cement Type 2',898,'','','2018-04-25',28,1),(886,'EFIL','Engineered (Select) Fill',900,'','','2018-05-25',28,1),(887,'GFIL','General Fill',900,'','','2018-05-25',28,1),(888,'GEOG','Geogrid',900,'','','2018-05-25',28,1),(889,'GEOT','Geotextile Filter Fabric',900,'','','2018-05-25',28,1),(890,'SILT','Silt (0.002 - 0.063mm)',900,'','','2018-04-25',28,1),(891,'CAST','Cast Iron Pipes',901,'','','2018-04-25',28,1),(892,'CPVC','Chlorinated Polyvinyl Chloride Pipe',901,'','','2018-04-25',28,1),(893,'CONC','Concrete Pipes',901,'','','2018-04-25',28,1),(894,'COPP','Copper Pipe',901,'','','2018-04-25',28,1),(895,'GIPI','Galvanised Iron Pipe',901,'','','2018-04-25',28,1),(896,'HDPE','High Density Poly Ethylene  Pipe',901,'','','2018-04-25',28,1),(897,'PVCP','Polyvinyl Chloride Pipe',901,'','','2018-04-25',28,1),(898,'REBA','Steel Rebars',902,'','','2018-04-25',28,1),(899,'SECT','Steel Sections',902,'','','2018-04-25',28,1),(900,'TUBE','Steel Tubes',902,'','','2018-04-25',28,1),(901,'BATC','Concrete Batch Plant',910,'','','2018-05-24',28,1),(902,'FINI','Concrete Finishing Tools',910,'','','2018-06-03',28,1),(903,'LAYI','Concrete Laying Tools',910,'','','2018-06-03',28,1),(904,'PUMP','Concrete Pump',910,'','','2018-05-24',28,1),(905,'TEST','Concrete Quality Testing',910,'','','2018-06-03',28,1),(906,'TRAN','Concrete Transit Mixer Truck',910,'','','2018-05-24',28,1),(907,'FORM','Formworks',910,'','','2018-06-03',28,1),(908,'DOZR','Dozer',911,'','','2018-04-25',28,1),(909,'EXCA','Excavator',911,'','','2018-04-25',28,1),(910,'CRAN','Crane',914,'','','2018-04-25',28,1),(911,'FORK','Forklift',914,'','','2018-04-25',28,1),(912,'BUSR','Bus (16 - 100 seats)',915,'','','2018-04-25',28,1),(913,'CARR','Sedan (2-5 seats)',915,'','','2018-04-25',28,1),(914,'VANR','Van or SUV (6-15 seats)',915,'','','2018-04-25',28,1),(915,'CCSW','Concrete Cutting Saw',917,'','','2018-05-04',28,1),(916,'CMIX','Concrete Mixer',917,'','','2018-05-04',28,1),(917,'NVIB','Needle Vibrator',917,'','','2018-05-04',28,1),(918,'RBCM','Rebar Cutting Machine',917,'','','2018-05-04',28,1),(919,'SVIB','Screed Vibrator',917,'','','2018-05-04',28,1),(920,'DCPU','Desktop CPU',920,'','','2018-04-25',28,1),(921,'DMON','Desktop Monitor',920,'','','2018-04-25',28,1),(922,'NBOK','Notebook',920,'','','2018-04-25',28,1),(923,'PRNT','Printers, Copiers and Accessories',920,'','','2018-04-25',28,1),(924,'BUSO','Bus (16 - 100 seats)',921,'','','2018-04-25',28,1),(925,'CARO','Sedan (2-5 seats)',921,'','','2018-04-25',28,1),(926,'VANO','Van or SUV (6-15 seats)',921,'','','2018-04-25',28,1),(927,'ENGR','Engineer Residence',926,'','','2018-04-26',28,1),(928,'EXEC','Executive Residence',926,'','','2018-04-25',28,1),(929,'MANR','Manager Residence',926,'','','2018-04-25',28,1),(930,'AUTO','Automotive Workshop',928,'','','2018-04-25',28,1),(931,'META','Metal Workshop',928,'','','2018-05-23',28,1),(932,'WELD','Welding Workshop',928,'','','2018-04-25',28,1),(933,'WOOD','Woodworks Workshop',928,'','','2018-04-25',28,1),(934,'BMNT','Basement Excavation',931,'','','2018-05-26',28,1),(935,'STRP','Strip Footing Excavation',931,'','','2018-05-26',28,1),(936,'TREN','Trench Excavations',932,'','','2018-05-26',28,1),(937,'SCLR','Site Clearance',933,'','','2018-05-25',28,1),(938,'UGDB','Underground Direct Buried FOC',936,'','','2018-05-04',28,1),(939,'BASE','Aggregate Base Course',937,'','','2018-05-25',28,1),(940,'SUBB','Aggregate Sub-Base Course',937,'','','2018-05-25',28,1),(941,'ABAS','Asphaltic Base Course',937,'','','2018-05-25',28,1),(942,'BIND','Asphaltic Binder Course',937,'','','2018-05-25',28,1),(943,'WEAR','Asphaltic Wearing Course',937,'','','2018-05-25',28,1),(944,'PRIM','Prime Coat on Subgrade',937,'','','2018-05-25',28,1),(945,'SEAL','Seal Coat on Wearing Course',937,'','','2018-05-25',28,1),(946,'TACK','Tack Coat on Binder Course',937,'','','2018-05-25',28,1),(947,'CBCN1','Quality of Construction Rating Q1',942,'','','2018-04-25',28,1),(948,'CBCN2','Quality of Construction Rating Q2',942,'','','2018-04-25',28,1),(949,'CBCN3','Quality of Construction Rating Q3',942,'','','2018-04-25',28,1),(950,'RBCN2','Quality of Construction Rating Q2',943,'','','2018-05-23',28,1),(951,'RBCN3','Quality of Construction Rating Q3',943,'','','2018-05-23',28,1),(952,'RBCN1','Quality of Construction Rating Q1	',943,'','','2018-06-24',28,1),(1119,'100D','Valve Chamber for 100mm Pipe',1098,'4','652','2018-06-27',28,1),(1120,'200D','Valve Chamber for 200mm Pipe',1098,'4','652','2018-06-29',28,1),(1121,'300D','Valve Chamber for 300mm Pipe',1098,'4','652','2018-06-29',28,1),(1122,'BATT','Kerb Half Battered',851,'4','654','2018-05-24',28,1),(1123,'15CM','CMU Wall 15CM thick ',855,'4','655','2018-05-25',28,1),(1124,'20CM','CMU Wall 20CM thick ',855,'4','655','2018-05-24',28,1),(1125,'PMDX','Plaster Mortar Drum Mixer',1112,'3','672','2018-07-21',28,1),(1126,'OCRA','Owned Cranes',1118,'3','672','2018-07-01',28,1),(1127,'DRIL','Drill Machines',1112,'3','672','2018-07-21',28,1),(1128,'TRUC','Owned Trucks (Max 15000kg)',1119,'3','672','2018-07-01',28,1),(1129,'RTRU','Trucks Rented (Max 15000kg)',1109,'3','671','2018-07-02',28,1),(1130,'OROL','Owned Roller Compactors',1114,'3','672','2018-07-21',28,1),(1131,'LAYO','Concrete Laying Tools Owned',1113,'3','672','2018-07-21',28,1),(1132,'OTRA','Tractors Owned',1111,'3','672','2018-07-21',28,1),(1133,'RROL','Rented Roller Compactors',1104,'3','671','2018-07-21',28,1),(1134,'XPLE','Cross Linked Poly Ethylene',1099,'2','667','2018-06-28',28,1),(1135,'COND','Bare Overhead Conductors',1099,'2','667','2018-06-28',28,1),(1136,'DIPI','Ductile Iron Pipes',901,'2','667','2018-06-25',28,1),(1137,'UPVC','UnPlasticized Polyvinyl Chloride Pipes',901,'2','667','2018-06-25',28,1);


