INSERT INTO `refsubcategory` (`CatID`, `SubCatID`, `Description`) VALUES
(1, 1, 'Abaca'),
(1, 2, 'Cassava'),
(1, 3, 'Coconut'),
(1, 4, 'Corn'),
(1, 5, 'Ecosystem'),
(1, 6, 'Education'),
(1, 7, 'Energy'),
(1, 8, 'Farming Systems'),
(1, 9, 'Forage and Pastures Management'),
(1, 10, 'Forestry'),
(1, 11, 'Fruits'),
(1, 12, 'Taro'),
(1, 13, 'Legumes'),
(1, 14, 'Livestock'),
(1, 15, 'Mangrove'),
(1, 16, 'Medicinal Plants'),
(1, 17, 'Marine Resources'),
(1, 18, 'Rootcrops'),
(1, 19, 'Rural Sociology'),
(1, 20, 'Socioeconomics'),
(1, 21, 'Soil and Water Resources'),
(1, 22, 'Sugarcane'),
(1, 23, 'Sweet Potato'),
(1, 24, 'Tikog'),
(1, 25, 'Tugui'),
(1, 26, 'Ube'),
(1, 27, 'Vegetables'),
(1, 28, 'Peanuts'),
(1, 29, 'Yam'),
(1, 30, 'Polylactics'),
(1, 31, 'Macapuno'),
(1, 32, 'Pako'),
(1, 33, 'Pig'),
(1, 34, 'Sago'),
(1, 35, 'Rice'),
(1, 36, 'Fruits & Vegetables'),
(1, 37, 'Fisheries'),
(1, 38, 'Renewable Energy'),
(1, 39, 'Jackfruit'),
(1, 40, 'Poultry & Livestock'),
(1, 41, 'Bamboo'),
(1, 42, 'Cereals & Legumes'),
(1, 43, 'Poultry'),
(1, 44, 'Cutflowers'),
(1, 45, 'Banana'),
(1, 46, 'Pineapple'),
(2, 1, 'Agricultural Engineering'),
(2, 2, 'Animal Breeding'),
(2, 3, 'Animal Health'),
(2, 4, 'Animal Physiology'),
(2, 5, 'Animal Production'),
(2, 6, 'Aqua Culture'),
(2, 7, 'Biotechnology'),
(2, 8, 'Cooperative Studies'),
(2, 9, 'Crop Improvement'),
(2, 10, 'Crop Production'),
(2, 11, 'Cultural Management'),
(2, 12, 'Ecological Management'),
(2, 13, 'Farming Systems'),
(2, 14, 'Fish Biology'),
(2, 15, 'Fish Breeding'),
(2, 16, 'Fish Nutrition'),
(2, 17, 'Fisf Production'),
(2, 18, 'Food Processing'),
(2, 19, 'Forage and Pastures Management'),
(2, 20, 'Forestry'),
(2, 21, 'Higher Education'),
(2, 22, 'Livestock Nutrition'),
(2, 23, 'Management Studies'),
(2, 24, 'Marketing Studies'),
(2, 25, 'Nutrition'),
(2, 26, 'Others'),
(2, 27, 'Pest Management'),
(2, 28, 'Postharvest Processing and Utilization'),
(2, 29, 'Rural Sociology'),
(2, 30, 'Polylactics'),
(2, 31, 'Socioeconomics'),
(2, 32, 'Soil and Water Resources'),
(2, 33, 'Soil Conservation'),
(2, 34, 'Tissue Culture'),
(2, 35, 'Tree Legumes'),
(2, 36, 'Discipline Test'),
(2, 37, 'it surely works!'),
(2, 38, 'Tropical Ecology'),
(2, 39, 'Natural Resource Management'),
(2, 40, 'Investment Studies for R & D'),
(2, 41, 'Health Research'),
(2, 42, 'Engineering'),
(2, 43, 'R & D MIS'),
(2, 44, 'Geographic Information System'),
(2, 45, 'Gender & Development'),
(2, 46, 'Agroforestry'),
(2, 47, 'Extension Project'),
(2, 48, 'Climate Change'),
(2, 49, 'Management Studies'),
(2, 50, 'Sustainable Agriculture'),
(2, 51, 'Remote Sensing'),
(2, 52, 'Commissioned Project'),
(2, 53, 'Marine Ecology'),
(2, 54, 'Development Project'),
(3, 1, 'Crops'),
(3, 2, 'Livestock'),
(3, 3, 'Fisheries'),
(3, 4, 'Fruits'),
(3, 5, 'Engineering'),
(3, 6, 'Farming System'),
(3, 7, 'Fruit Crops'),
(3, 8, 'Socio-Economics'),
(3, 9, 'Womens in Agriculture'),
(3, 10, 'Poultry'),
(3, 11, 'Farm Resources'),
(3, 12, 'Crop/Livestock'),
(3, 13, 'Development'),
(3, 14, 'Crop/Fish'),
(3, 15, 'Soil and Water Resources'),
(3, 16, 'Crops'),
(3, 55, 'IDG'),
(3, 56, 'Capability building'),
(3, 57, 'Monitoring and Evaluation '),
(3, 58, 'Networking'),
(4, 1, 'Basic Research'),
(4, 2, 'Applied research'),
(4, 3, 'Technology Verification'),
(4, 4, 'Technology Adaptation'),
(4, 5, 'Technology Generation'),
(4, 6, 'Technology Dissemination'),
(4, 7, 'Information Dissemination'),
(4, 8, 'Information Generation'),
(4, 9, 'Technology Transfer'),
(4, 10, 'Information Verification'),
(4, 11, 'Technology for Piloting'),
(5, 1, 'Waiting'),
(5, 2, 'On-going'),
(5, 3, 'Terminated'),
(5, 4, 'Completed'),
(5, 5, 'Extended'),
(5, 6, 'No data'),
(5, 7, 'New'),
(5, 8, 'Suspended');