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


--
-- Dumping data for table `tierone`
--
-- WHERE:  tierone_company_id=28

INSERT INTO `tierone` VALUES (851,'KERB','Kerbstone','4','654','2018-05-24',28,1,''),(852,'MARL','Marl Capping Protection','4','654','2018-05-25',28,1,''),(853,'RIPR','Rip Rap Rock Armour','4','654','2018-05-25',28,1,''),(854,'WALK','Walkways and Medians','4','654','2018-05-24',28,1,''),(855,'CMUW','Concrete Masonry Unit Wall','4','655','2018-04-25',28,1,''),(856,'RBMW','Red Brick Masonry Wall','4','655','2018-04-25',28,1,''),(857,'RCMW','Reinforced Concrete Masonry Unit Wall','4','655','2018-04-25',28,1,''),(858,'PCC','Plain Cement Concrete','4','656','2018-04-25',28,1,''),(859,'RCC','Reinforced Cement Concrete','4','656','2018-04-25',28,1,''),(860,'ASPH','Asphaltic Works Contractor','5','657','2018-04-25',28,1,''),(861,'CARP','Carpeting Contractor','5','657','2018-04-25',28,1,''),(862,'COMM','Communications Works Contractor','5','657','2018-04-25',28,1,''),(863,'CONC','Concrete Works Contractor','5','657','2018-04-25',28,1,''),(864,'EART','Earthworks Contractor','5','657','2018-05-24',28,1,''),(865,'HVAC','HVAC Contractor','5','657','2018-04-25',28,1,''),(866,'PACO','Painting Coating Contractor','5','657','2018-04-25',28,1,''),(867,'PIPE','Piping Works Contractor','5','657','2018-04-25',28,1,''),(868,'SOFT','Software Development Contractor','5','657','2018-04-25',28,1,''),(869,'SSTR','Structural Steel Contractor','5','657','2018-04-25',28,1,''),(870,'WOOD','Woodworks Contractor','5','657','2018-05-24',28,1,''),(871,'G001','General Contractor (001.00 MM)','5','658','2018-04-25',28,1,''),(872,'G005','General Contractor (005.00 MM)','5','658','2018-04-25',28,1,''),(873,'G010','General Contractor (010.00 MM)','5','658','2018-04-25',28,1,''),(874,'G025','General Contractor (025.00 MM)','5','658','2018-04-25',28,1,''),(875,'G050','General Contractor (050.00 MM)','5','658','2018-04-25',28,1,''),(876,'G100','General Contractor (100.00 MM)','5','658','2018-04-25',28,1,''),(877,'G200','General Contractor (200.00 MM)','5','658','2018-04-25',28,1,''),(878,'G500','General Contractor (500.00 MM)','5','658','2018-04-25',28,1,''),(879,'ELEL','Electrical Manufacturer','5','660','2018-04-25',28,1,''),(880,'HVAC','HVAC manufacturer','5','660','2018-04-25',28,1,''),(881,'PREC','Precast Concrete Manufacturer','5','660','2018-04-25',28,1,''),(882,'EMTS','Execution Management Team (EMTS)','1','661','2018-06-23',28,1,''),(883,'SMTS','Safety Management Team (SMTS)','1','661','2018-06-23',28,1,''),(884,'DMTT','Design Management Team (TMPE)','1','662','2018-04-25',28,1,''),(885,'EMTT','Execution Management Team (TMPE)','1','662','2018-04-25',28,1,''),(886,'PMTT','Project Management Team (TMPE)','1','662','2018-04-25',28,1,''),(887,'QMTT','Quality Management Team (TMPE)','1','662','2018-04-25',28,1,''),(888,'SMTT','Safety Management Team (TMPE)','1','662','2018-05-25',28,1,''),(889,'DMTP','Design Management Team (PRME)','1','663','2018-04-25',28,1,''),(890,'EMTP','Execution Management Team (PRME)','1','663','2018-04-25',28,1,''),(891,'PMTP','Project Management Team (PRME)','1','663','2018-04-25',28,1,''),(892,'QMTP','Quality Management Team (PRME)','1','663','2018-04-25',28,1,''),(893,'SMTP','Safety Management Team (PRME)','1','663','2018-04-25',28,1,''),(894,'CBDC','Commercial Building Construction','4','666','2018-04-25',28,1,''),(895,'RBDC','Residential Building Construction','4','666','2018-04-25',28,1,''),(896,'AGG','Aggregates','2','667','2018-04-25',28,1,''),(897,'CABL','Cables','2','667','2018-04-25',28,1,''),(898,'CEME','Cementitious Materials','2','667','2018-04-25',28,1,''),(899,'DUCT','Ducting Materials','2','667','2018-04-25',28,1,''),(900,'EAR','Earthfil','2','667','2018-04-25',28,1,''),(901,'PIPE','Pipes and fittings','2','667','2018-04-25',28,1,''),(902,'STEL','Steel Bars and Sections','2','667','2018-04-25',28,1,''),(903,'SPA','Spares','2','668','2018-04-25',28,1,''),(904,'ELL','Electrical','2','669','2018-04-25',28,1,''),(905,'PLU','Plumbing','2','669','2018-04-25',28,1,''),(906,'ELTM','Electronic Technology Machines','3','670','2018-04-25',28,1,''),(907,'FIRE','Fire Supression and Prevention','3','670','2018-04-25',28,1,''),(908,'ITHW','Information Technology Hardware','3','670','2018-04-25',28,1,''),(909,'AGRI','Agricultural Equipment','3','671','2018-04-25',28,1,''),(910,'CONC','Concrete Works Equipment','3','671','2018-04-25',28,1,''),(911,'EART','Earthworks Equipment','3','671','2018-04-25',28,1,''),(912,'FURN','Furniture','3','671','2018-06-24',28,1,''),(913,'INFO','Information Technology Equipment','3','671','2018-04-25',28,1,''),(914,'LIFT','Lifting Equipment','3','671','2018-04-25',28,1,''),(915,'TRPT','Transportation','3','671','2018-04-25',28,1,''),(916,'WELD','Welding Equipment','3','671','2018-04-25',28,1,''),(917,'OBLD','Owned Buildings Works Equipment','3','672','2018-04-25',28,1,''),(918,'OEAR','Owned Earthworks Equipment','3','672','2018-06-25',28,1,''),(919,'OELT','Owned Electronic Technology Machines','3','672','2018-04-25',28,1,''),(920,'OITH','Owned IT Hardware','3','672','2018-04-25',28,1,''),(921,'OTRP','Owned Transportation','3','672','2018-04-25',28,1,''),(922,'COMM','Commercial Land','6','676','2018-04-25',28,1,''),(923,'INDU','Industrial Land','6','676','2018-04-25',28,1,''),(924,'RESI','Residential','6','676','2018-04-25',28,1,''),(925,'HOBG','Head Office Building','6','677','2018-04-25',28,1,''),(926,'RESI','Residential Building','6','677','2018-04-25',28,1,''),(927,'WARE','Warehouse','6','677','2018-04-25',28,1,''),(928,'WKSP','Workshop','6','677','2018-04-25',28,1,''),(929,'SPLI','Split Units','4','681','2018-04-25',28,1,''),(930,'DRED','Dredging Underwater Excavation','4','682','2018-04-26',28,1,''),(931,'EXBG','Excavations for Buildings','4','682','2018-04-25',28,1,''),(932,'EXIF','Excavations for Infrastructure','4','682','2018-04-25',28,1,''),(933,'ROUG','Rough Grading','4','682','2018-05-25',28,1,''),(934,'LVCL','Low Voltage Cable Laying','4','683','2018-04-25',28,1,''),(935,'MVCL','Medium Voltage Cable Laying','4','683','2018-04-25',28,1,''),(936,'OPSC','Outside Plant Cabling','4','684','2018-04-25',28,1,''),(937,'FLEX','Flexible Pavements','4','686','2018-05-25',28,1,''),(938,'RIGI','Rigid Pavements','4','686','2018-05-25',28,1,''),(939,'CMPL','Cement Mortar Plastering','4','687','2018-04-25',28,1,''),(940,'GYBO','Gypsum Board Works','4','687','2018-04-25',28,1,''),(941,'TILE','Tiling Works','4','687','2018-04-25',28,1,''),(942,'CBCN','Commercial Bath Construction','4','688','2018-04-25',28,1,''),(943,'RBCN','Residential Bath Construction','4','688','2018-04-25',28,1,'');


