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


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

INSERT INTO `tierone` VALUES (968,'VACH','Valve Chambers','4','700','2018-06-27',340,1,''),(969,'WALK','Walkways and Medians','4','701','2018-05-24',340,1,''),(970,'KERB','Kerbstone','4','701','2018-05-24',340,1,''),(971,'CBDC','Commercial Building Construction','4','702','2018-04-25',340,1,''),(972,'OPSC','Outside Plant Cabling','4','703','2018-04-25',340,1,''),(973,'MVCL','Medium Voltage Cable Laying','4','704','2018-04-25',340,1,''),(974,'PCC','Plain Cement Concrete','4','705','2018-04-25',340,1,''),(975,'RCC','Reinforced Cement Concrete','4','705','2018-04-25',340,1,''),(976,'EXIF','Excavations for Infrastructure','4','706','2018-04-25',340,1,''),(977,'RBDC','Residential Building Construction','4','702','2018-04-25',340,1,''),(978,'CMUW','Concrete Masonry Unit Wall','4','707','2018-04-25',340,1,''),(979,'LVCL','Low Voltage Cable Laying','4','704','2018-04-25',340,1,''),(980,'CBCN','Commercial Bath Construction','4','708','2018-04-25',340,1,''),(981,'ROUG','Rough Grading','4','706','2018-05-25',340,1,''),(982,'RCON','Concrete Works Equipment Rented','3','709','2018-04-25',340,1,''),(983,'OTRP','Transportation Owned','3','710','2018-04-25',340,1,''),(984,'REAR','Earthworks Equipment Rental','3','709','2018-04-25',340,1,''),(985,'OEAR','Earthworks Equipment Owned','3','710','2018-06-25',340,1,''),(986,'OCON','Concrete Works Equipment Owned','3','710','2018-07-21',340,1,''),(987,'OAGR','Agricultural Equipment Owned','3','710','2018-07-21',340,1,''),(988,'OITH','Information Technology Equipment','3','710','2018-04-25',340,1,''),(989,'OBLD','Buildings Works Equipment Owned ','3','710','2018-04-25',340,1,''),(990,'OLFT','Lifting Equipment Owned','3','710','2018-07-01',340,1,''),(991,'RTRP','Transportation Rentals','3','709','2018-04-25',340,1,''),(992,'EMTP','Execution Management Team (PRME)','1','711','2018-04-25',340,1,''),(993,'SMTP','Safety Management Team (PRME)','1','711','2018-04-25',340,1,''),(994,'PIPE','Pipes and fittings','2','712','2018-04-25',340,1,''),(995,'AGG','Aggregates','2','712','2018-04-25',340,1,''),(996,'CABL','Cables and Conductors','2','712','2018-04-25',340,1,''),(997,'STEL','Steel Bars and Sections','2','712','2018-04-25',340,1,''),(998,'G001','General Contractor (001.00 MM)','5','713','2018-04-25',340,1,''),(1024,'PIPL','Pipe Laying works','4','700','2018-06-27',340,1,''),(1025,'THRU','Thrust Blocks','4','700','2018-06-27',340,1,''),(1026,'MARL','Marl Capping Protection','4','701','2018-05-25',340,1,''),(1027,'RIPR','Rip Rap Rock Armour','4','701','2018-05-25',340,1,''),(1028,'RBMW','Red Brick Masonry Wall','4','707','2018-04-25',340,1,''),(1029,'RCMW','Reinforced Concrete Masonry Unit Wall','4','707','2018-04-25',340,1,''),(1030,'ASPH','Asphaltic Works Contractor','5','750','2018-04-25',340,1,''),(1031,'CARP','Carpeting Contractor','5','750','2018-04-25',340,1,''),(1032,'COMM','Communications Works Contractor','5','750','2018-04-25',340,1,''),(1033,'CONC','Concrete Works Contractor','5','750','2018-04-25',340,1,''),(1034,'EART','Earthworks Contractor','5','750','2018-05-24',340,1,''),(1035,'HVAC','HVAC Contractor','5','750','2018-04-25',340,1,''),(1036,'PACO','Painting Coating Contractor','5','750','2018-04-25',340,1,''),(1037,'PIPE','Piping Works Contractor','5','750','2018-04-25',340,1,''),(1038,'SOFT','Software Development Contractor','5','750','2018-04-25',340,1,''),(1039,'SSTR','Structural Steel Contractor','5','750','2018-04-25',340,1,''),(1040,'WOOD','Woodworks Contractor','5','750','2018-05-24',340,1,''),(1041,'G005','General Contractor (005.00 MM)','5','713','2018-04-25',340,1,''),(1042,'G010','General Contractor (010.00 MM)','5','713','2018-04-25',340,1,''),(1043,'G025','General Contractor (025.00 MM)','5','713','2018-04-25',340,1,''),(1044,'G050','General Contractor (050.00 MM)','5','713','2018-04-25',340,1,''),(1045,'G100','General Contractor (100.00 MM)','5','713','2018-04-25',340,1,''),(1046,'G200','General Contractor (200.00 MM)','5','713','2018-04-25',340,1,''),(1047,'G500','General Contractor (500.00 MM)','5','713','2018-04-25',340,1,''),(1048,'ELEL','Electrical Manufacturer','5','752','2018-04-25',340,1,''),(1049,'HVAC','HVAC manufacturer','5','752','2018-04-25',340,1,''),(1050,'PREC','Precast Concrete Manufacturer','5','752','2018-04-25',340,1,''),(1051,'EMTS','Execution Management Team (EMTS)','1','753','2018-06-23',340,1,''),(1052,'SMTS','Safety Management Team (SMTS)','1','753','2018-06-23',340,1,''),(1053,'DMTT','Design Management Team (TMPE)','1','754','2018-04-25',340,1,''),(1054,'EMTT','Execution Management Team (TMPE)','1','754','2018-04-25',340,1,''),(1055,'PMTT','Project Management Team (TMPE)','1','754','2018-04-25',340,1,''),(1056,'QMTT','Quality Management Team (TMPE)','1','754','2018-04-25',340,1,''),(1057,'SMTT','Safety Management Team (TMPE)','1','754','2018-05-25',340,1,''),(1058,'DMTP','Design Management Team (PRME)','1','711','2018-04-25',340,1,''),(1059,'PMTP','Project Management Team (PRME)','1','711','2018-04-25',340,1,''),(1060,'QMTP','Quality Management Team (PRME)','1','711','2018-04-25',340,1,''),(1061,'CEME','Cementitious Materials','2','712','2018-04-25',340,1,''),(1062,'DUCT','Ducting Materials','2','712','2018-04-25',340,1,''),(1063,'EAR','Earthfil','2','712','2018-04-25',340,1,''),(1064,'SPA','Spares','2','757','2018-04-25',340,1,''),(1065,'ELL','Electrical','2','758','2018-04-25',340,1,''),(1066,'PLU','Plumbing','2','758','2018-04-25',340,1,''),(1067,'ELTM','Electronic Technology Machines','3','759','2018-04-25',340,1,''),(1068,'FIRE','Fire Supression and Prevention','3','759','2018-04-25',340,1,''),(1069,'ITHW','Information Technology Equipment','3','759','2018-04-25',340,1,''),(1070,'RAGR','Agricultural Equipment Rental','3','709','2018-04-25',340,1,''),(1071,'RBLD','Building Works Equipment Rented ','3','709','2018-07-21',340,1,''),(1072,'RELT','Electronic Technology Machines Rented','3','709','2018-07-21',340,1,''),(1073,'RFRN','Furniture Rental','3','709','2018-07-21',340,1,''),(1074,'RITH','Information Technology Equipment','3','709','2018-04-25',340,1,''),(1075,'RLFT','Lifting Equipment Rented','3','709','2018-04-25',340,1,''),(1076,'RWLD','Welding Equipment Rental','3','709','2018-04-25',340,1,''),(1077,'OELT','Electronic Technology Machines Owned','3','710','2018-04-25',340,1,''),(1078,'OFRN','Furniture Owned','3','710','2018-06-24',340,1,''),(1079,'OWLD','Welding Equipment Owned','3','710','2018-07-21',340,1,''),(1080,'COMM','Commercial Land','6','763','2018-04-25',340,1,''),(1081,'INDU','Industrial Land','6','763','2018-04-25',340,1,''),(1082,'RESI','Residential','6','763','2018-04-25',340,1,''),(1083,'HOBG','Head Office Building','6','764','2018-04-25',340,1,''),(1084,'RESI','Residential Building','6','764','2018-04-25',340,1,''),(1085,'WARE','Warehouse','6','764','2018-04-25',340,1,''),(1086,'WKSP','Workshop','6','764','2018-04-25',340,1,''),(1087,'SPLI','Split Units','4','768','2018-04-25',340,1,''),(1088,'DRED','Dredging Underwater Excavation','4','706','2018-04-26',340,1,''),(1089,'EXBG','Excavations for Buildings','4','706','2018-04-25',340,1,''),(1090,'FLEX','Flexible Pavements','4','770','2018-05-25',340,1,''),(1091,'RIGI','Rigid Pavements','4','770','2018-05-25',340,1,''),(1092,'CMPL','Cement Mortar Plastering','4','771','2018-04-25',340,1,''),(1093,'GYBO','Gypsum Board Works','4','771','2018-04-25',340,1,''),(1094,'TILE','Tiling Works','4','771','2018-04-25',340,1,''),(1095,'RBCN','Residential Bath Construction','4','708','2018-04-25',340,1,'');


