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


--
-- Dumping data for table `tierthree`
--
-- WHERE:  tierthree_company_id=28

INSERT INTO `tierthree` VALUES (454,'COBB','Cobblestone Paver',808,'2018-05-24',28,1),(455,'HOLL','Holland Pavers',808,'2018-05-24',28,1),(456,'TURF','Turfstone Paver',808,'2018-05-24',28,1),(457,'FL04','Floors 1 - 4',818,'2018-05-26',28,1),(458,'FL08','Floors 5 - 8',818,'2018-05-26',28,1),(459,'FL12','Floors 9 - 12',818,'2018-05-26',28,1),(460,'FRON','Front End Developer',832,'2018-05-24',28,1),(461,'ELE','Foreman - Electrical',857,'2018-04-26',28,1),(462,'PIPE','Foreman - Pipe Fitting',857,'2018-04-26',28,1),(463,'SCAF','Foreman - Scaffolding',857,'2018-04-26',28,1),(464,'WELD','Foreman - Welding',857,'2018-04-26',28,1),(465,'ELEL','Technician - Electrical',864,'2018-04-26',28,1),(466,'INFH','Technician - InfoTech Hardware',864,'2018-04-26',28,1),(467,'INFN','Technician - InfoTech Networking ',864,'2018-04-26',28,1),(468,'INFS','Technician - Infotech Software',864,'2018-06-23',28,1),(469,'MASO','Technician - Masonry',864,'2018-04-26',28,1),(470,'PAIN','Technician - Painting',864,'2018-04-26',28,1),(471,'PIPE','Technician - Pipe Fitter',864,'2018-04-26',28,1),(472,'REND','Technician - Rendering',864,'2018-04-26',28,1),(473,'WOOR','Technician - Rough Woodworking',864,'2018-04-26',28,1),(474,'SCAF','Technician - Scaffolding',864,'2018-04-26',28,1),(475,'TILE','Technician - Tiling',864,'2018-04-26',28,1),(476,'WELD','Technician - Welding',864,'2018-04-26',28,1),(477,'CONC','Concrete Structure',874,'2018-05-25',28,1),(478,'MIXE','Mixed Materials Buildings',874,'2018-05-25',28,1),(479,'STEE','Steel Structure',874,'2018-05-25',28,1),(480,'WOOD','Wood Construction',874,'2018-05-25',28,1),(481,'2550','AASHTO 3 (25-50mm)',882,'2018-05-22',28,1),(482,'1927','AASHTO 4 (19-27mm)',882,'2018-05-22',28,1),(483,'4725','AASHTO 57 (4.75-25.0mm)',882,'2018-05-22',28,1),(484,'4719','AASHTO 67 (4.75-19.0mm)',882,'2018-05-22',28,1),(485,'2395','AASHTO 8 (2.3-9.5mm)',882,'2018-05-22',28,1),(486,'COAR','Coarse Sand (&#8203;0.50-1.00mm)',883,'2018-05-21',28,1),(487,'FINE','Fine Sand (&#8203;0.13-&#8203;0.25mm)',883,'2018-05-21',28,1),(488,'MEDI','Medium Sand (&#8203;0.25-0.5mm)',883,'2018-05-21',28,1),(489,'VCOA','Very Coarse Sand (1.00-2.00mm)',883,'2018-05-21',28,1),(490,'VFIN','Very Fine Sand (&#8203;0.06-1.12mm)',883,'2018-05-21',28,1),(491,'CARB','Carbon Steel  Rebars',898,'2018-05-21',28,1),(492,'EPOX','Epoxy Coated Rebars',898,'2018-05-21',28,1),(493,'GALV','Galvanized Steel Rebars',898,'2018-05-21',28,1),(494,'STST','Stainless Steel Rebars',898,'2018-05-21',28,1),(495,'BROO','Broom for Finishing',902,'2018-06-03',28,1),(496,'FLOA','Floats',902,'2018-06-03',28,1),(497,'GROO','Groove Cutter',902,'2018-06-03',28,1),(498,'TRWO','Trowels',902,'2018-06-03',28,1),(499,'VIBR','Vibrators',903,'2018-06-03',28,1),(500,'WHEE','Wheel Barrow',903,'2018-06-03',28,1),(501,'CRAW','Crawler Dozer',908,'2018-05-04',28,1),(502,'WHEE','Wheeled Dozer',908,'2018-05-04',28,1),(503,'BHEX','Backhoe Excavator',909,'2018-05-04',28,1),(504,'CRAW','Crawler Excavator',909,'2018-05-04',28,1),(505,'DRAG','Dragline Excavator',909,'2018-05-04',28,1),(506,'ATCR','All Terrain Crane',910,'2018-04-25',28,1),(507,'HTCR','Hydraulic Truck Crane',910,'2018-04-25',28,1),(508,'RTCR','Rough Terrain Crane',910,'2018-04-25',28,1),(509,'TOWR','Tower Crane',910,'2018-04-25',28,1),(510,'SSLR','Skid Steer Loader',911,'2018-05-04',28,1),(511,'CHEV','Chevrolet Sedan',925,'2018-05-24',28,1),(512,'MAZD','Mazda Sedan',925,'2018-05-24',28,1),(513,'NISS','Nissan Sedan',925,'2018-05-24',28,1),(514,'TOYO','Toyota Sedan',925,'2018-05-24',28,1),(811,'10015','Valve Chamber 05CM-15CM Deep',1119,'2018-06-29',28,1),(812,'20015','Valve Chamber 05CM-15CM Deep',1120,'2018-06-29',28,1),(813,'30020','Valve Chamber 16CM-20CM Deep',1121,'2018-06-29',28,1),(814,'10020','Valve Chamber 16CM-20CM Deep',1119,'2018-06-29',28,1),(815,'20020','Valve Chamber 16CM-20CM Deep',1120,'2018-06-29',28,1),(816,'30015','Valve Chamber 05CM-15CM Deep',1121,'2018-06-29',28,1),(817,'ELMX','PM Drum Mixer Electric',1125,'2018-07-21',28,1),(818,'OATC','Cranes Owned All Terrain',1126,'2018-07-01',28,1),(819,'ALN1','Printer - All in One',923,'2018-06-27',28,1),(820,'OPGD','Drilling Machine Pistol Grip',1127,'2018-07-21',28,1),(821,'MOUS','Mouse with USB',923,'2018-06-27',28,1),(822,'C7HW','Truck US Class 7 Heavy (Max 14969kg)',1128,'2018-07-01',28,1),(823,'C8HW','Truck US Class 8 Heavy (> 14969kg)',1128,'2018-07-01',28,1),(824,'VIBR','Vibrator Needle Type',903,'2018-06-03',28,1),(825,'RC5M','Truck US Class 5 Medium (Max 8845kg)',1129,'2018-07-02',28,1),(826,'C1LT','Truck US Class 1 Light (Max 2722kg)',1128,'2018-07-01',28,1),(827,'VBRL','Roller - Vibratory',1130,'2018-07-21',28,1),(828,'OVBN','Vibrator Needle Type Owned',1131,'2018-07-21',28,1),(829,'SFRL','Roller - Sheep Foot',1130,'2018-07-21',28,1),(830,'SCUT','Sub-Compact Utility <25HP',1132,'2018-07-21',28,1),(831,'SMRL','Roller - Smooth Wheeled',1130,'2018-07-21',28,1),(832,'C2LT','Truck US Class 2 Light (Max 4536kg)',1128,'2018-07-01',28,1),(833,'CUTT','Compact Utility Tractor 25-50HP',1132,'2018-07-21',28,1),(834,'PNRL','Roller - Pneumatic',1130,'2018-07-21',28,1),(835,'C4MD','Truck US Class 4 Medium (Max 7257kg)',1128,'2018-07-01',28,1),(836,'VBRR','Roller - Vibratory',1133,'2018-07-21',28,1),(837,'C6MD','Truck US Class 6 Medium (Max 11793kg)',1128,'2018-07-01',28,1),(838,'MAIN','CPU Mainstream Desktop',920,'2018-06-27',28,1),(839,'C9HW','Truck US Class 9 Super Heavy (> 14969kg)',1128,'2018-07-01',28,1),(840,'19IN','19 inch Desktop Monitor',921,'2018-06-27',28,1),(841,'GSMX','PM Drum Mixer Gasoline',1125,'2018-07-21',28,1),(842,'ORTC','Crane Owned Rough Terrain',1126,'2018-07-01',28,1),(843,'PINK','Printer - Inkjet',923,'2018-06-27',28,1),(844,'P3DR','Printer - 3D Replicator',923,'2018-06-27',28,1),(845,'PDOT','Printer - Dot matrix',923,'2018-06-27',28,1),(846,'C5MD','Truck US Class 5 Medium (Max 8845kg)',1128,'2018-07-01',28,1),(847,'KEYB','Keyboard with USB',923,'2018-06-27',28,1),(848,'RC6M','Truck US Class 6 Medium (Max 11793kg)',1129,'2018-07-02',28,1),(849,'C3LT','Truck US Class 3 Light (Max 6350kg)',1128,'2018-07-01',28,1),(850,'20IN','20 inch Desktop Monitor',921,'2018-06-27',28,1),(851,'PLAS','Printer - Laser',923,'2018-06-27',28,1),(852,'ARMO','Armoured',1134,'2018-07-27',28,1),(853,'AACO','All Aluminum Conductor ',1135,'2018-06-28',28,1),(854,'DI20','PN 20 Nominal Pressure',1136,'2018-06-26',28,1),(855,'HD20','PN20 Nominal Pressure SDR 09',896,'2018-06-26',28,1),(856,'PV40','Schedule 40',897,'2018-06-25',28,1),(857,'UP40','Schedule 40 ',1137,'2018-06-25',28,1),(858,'ARMR','Unarmoured',1134,'2018-07-27',28,1);


