Program List

DELETE FROM `progdefinitions` WHERE `PID` = '16000101603021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101603021', 0, '15000120010302', 'Fish Processing, Quality Assurance and Marketing', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000100103031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000100103031', 0, '15000120010302', 'Aquaculture Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000100201031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000100201031', 0, '15000120010302', 'Fish Processing, Quality Assurance and Marketing', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000100401031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000100401031', 0, '15000120010302', 'Marine and Refrigeration Engineering', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000100501031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000100501031', 0, '15000120010302', 'Master Fisherman', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000100603021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000100603021', 0, '15000120010302', 'Master Fisherman', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000100703011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000100703011', 0, '15000120010302', 'Master Fisherman', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000100803011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000100803011', 0, '15000120010302', 'Aquaculture', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000100903011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000100903011', 0, '15000120010302', 'Fish Processing, Quality Assurance and Marketing', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000101003011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101003011', 0, '15000120010302', 'Marine and Refrigeration Engineering', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000101103011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101103011', 0, '15000120010302', 'Environment and Coastal Resources Management', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000101203021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101203021', 0, '15000120010302', 'Environment and Coastal Resources Management', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000101303031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101303031', 0, '15000120010302', 'Environment and Coastal Resources Management', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000101403021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101403021', 0, '15000120010302', 'Aquaculture Technology', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000101503021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000101503021', 0, '15000120010302', 'Marine and Refrigeration Engineering', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000200101031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000200101031', 0, '15000209030301', 'Wildlife Management', 'SAT', 'NTA', 'NTA6', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000200201031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000200201031', 0, '15000209030301', 'Wildlife Tourism Management', 'SAT', 'NTA', 'NTA6', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000200305051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000200305051', 0, '15000209030301', 'Bachelor Degree in Wildlife Management', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000200405051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000200405051', 0, '15000209030301', 'Bachelor Degree in Wildlife Tourism', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000200503011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000200503011', 0, '15000209030301', 'Wildlife Management', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000200603011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000200603011', 0, '15000209030301', 'WILDLIFE TOURISM', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000200703021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000200703021', 0, '15000209030301', 'Wildlife Management', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000200803021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000200803021', 0, '15000209030301', 'Wildlife Tourism', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000300203021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000300203021', 0, '15000301020302', 'Forestry', 'SAT', 'NTA', 'NTA5', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000300303031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000300303031', 0, '15000301020302', 'Forestry', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000300403011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000300403011', 0, '15000301020302', 'Forestry', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000300101031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000300101031', 0, '15000301020302', 'Forestry ', 'SAT', 'NTA', 'NTA6', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17300506031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17300506031', 0, '15000301020302', 'Forestry and Bekeeping', 'BTP', 'NON', 'NTA6', '2', '0')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400303011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400303011', 0, '15000416010301', 'Aquaculture Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400403021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400403021', 0, '15000416010301', 'Aquaculture Technology', 'SAT', 'NTA', 'NTA5', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400503011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400503011', 0, '15000416010301', 'Aquaculture Technology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400603021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400603021', 0, '15000416010301', 'Fisheries Science and Technology', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400703011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400703011', 0, '15000416010301', 'Fisheries Science and Technology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400803021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400803021', 0, '15000416010301', 'Fisheries Management and Technology', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000400903011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000400903011', 0, '15000416010301', 'Fisheries Management and Technology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000400103031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000400103031', 0, '15000416010301', 'Fisheries Management and Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000400201031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000400201031', 0, '15000416010301', 'Fisheries Science and Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000500301031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000500301031', 0, '15000502010101', 'Hospitality Management', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000500501031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000500501031', 0, '15000502010101', 'Travel and Tourism', 'BTP', 'NTA', 'NTA6', '2', '2')
DELETE FROM `progdefinitions` WHERE `PID` = '17000501501011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000501501011', 0, '15000502010101', 'Hospitality Operations-apprenticeship Programme', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000501601031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000501601031', 0, '15000502010101', 'Culinary Art', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000501701031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000501701031', 0, '15000502010101', 'Rooms Divisions', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17501801021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17501801021', 0, '15000502010101', 'Hospitality Management', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '18501901031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('18501901031', 0, '15000502010101', 'Hospitality Management ', 'BTP', 'NTA', 'NTA6', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '18502301011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('18502301011', 0, '15000502010101', 'Food and Beverage Services', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '18502401011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('18502401011', 0, '15000502010101', 'Rooms Division', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '19502501021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('19502501021', 0, '15000502010101', 'Accommodation Operations', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '19502601021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('19502601021', 0, '15000502010101', 'Rooms Division', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '19502701031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('19502701031', 0, '15000502010101', 'Food and Beverage Services', 'BTP', 'NTA', 'NTA6', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000500301011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000500301011', 0, '15000502010101', 'Hospitality Operations', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000500601021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000500601021', 0, '15000502010101', 'Hospitality Operations', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000500701021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000500701021', 0, '15000502010101', 'Food Production', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000500801021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000500801021', 0, '15000502010101', 'Food and Beverage Services', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000500901021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000500901021', 0, '15000502010101', 'Pastry and Bakery', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000501001021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000501001021', 0, '15000502010101', 'Housekeeping and Laundry', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000501101021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000501101021', 0, '15000502010101', 'Front Office Operations', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000600203011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000600203011', 0, '15000626050301', 'General Agriculture', 'SAT', 'NTA', 'NTA5', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000600403031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000600403031', 0, '15000626050301', 'General Agriculture ', 'SAT', 'NTA', 'NTA6', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000600503011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000600503011', 0, '15000626050301', 'General Agriculture', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000600103031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000600103031', 0, '15000626050301', 'General Agriculture', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700101031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700101031', 0, '15000702020101', 'Accountancy', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700201031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700201031', 0, '15000702020101', 'Banking and Finance', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700301031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700301031', 0, '15000702020101', 'Computer Science', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700403031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700403031', 0, '15000702020101', 'Information Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700503031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700503031', 0, '15000702020101', 'Insurance and Risk Management', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700601031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700601031', 0, '15000702020101', 'Social Protection', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700701031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700701031', 0, '15000702020101', 'Taxation', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700805051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700805051', 0, '15000702020101', 'Bachelor of Accounting', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000700905051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000700905051', 0, '15000702020101', 'Bachelor of Banking and Finance', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701005051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701005051', 0, '15000702020101', 'Bachelor of Science in Information Technology', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701105051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701105051', 0, '15000702020101', 'Bachelor of Science in Insurance and Risk Management', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701205051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701205051', 0, '15000702020101', 'Bachelor of Science in Social Protection', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701305051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701305051', 0, '15000702020101', 'Bachelor of Science in Tax Management', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701405051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701405051', 0, '15000702020101', 'Bachelor of Science in Computer Science', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701501011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701501011', 0, '15000702020101', 'Banking and Finance', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701601061'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701601061', 0, '15000702020101', 'Masters in Accounting and Finance', 'BTP', 'NTA', 'NTA9', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701701061'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701701061', 0, '15000702020101', 'Masters in Human Resources Management', 'BTP', 'NTA', 'NTA9', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000701801061'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000701801061', 0, '15000702020101', 'Masters in Finance and Investment', 'BTP', 'NTA', 'NTA9', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000703001021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000703001021', 0, '15000702020101', 'Taxation', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000703103021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000703103021', 0, '15000702020101', 'Computer Science', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '18703205051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('18703205051', 0, '15000702020101', 'Bachelor of Economics and Finance', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000701901011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000701901011', 0, '15000702020101', 'Insurance and Risk Management', 'BTP', 'NTA', 'NTA4', '1', '2')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702001011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702001011', 0, '15000702020101', ' Insurance and Social Protection', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702101011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702101011', 0, '15000702020101', 'Computer Science', 'SAT', 'NTA', 'NTA4', '1', '2')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702203011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702203011', 0, '15000702020101', 'Computing and Information Technology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702303011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702303011', 0, '15000702020101', 'Accountancy', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702401021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702401021', 0, '15000702020101', 'Accountancy', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702501021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702501021', 0, '15000702020101', 'Insurance and Risk Management', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702601021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702601021', 0, '15000702020101', 'Social Protection', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702701021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702701021', 0, '15000702020101', 'Banking and Finance', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702803021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702803021', 0, '15000702020101', 'Information Technology', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000702901011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000702901011', 0, '15000702020101', 'Taxation', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000801601011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000801601011', 0, '15000801030101', 'Accountancy', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000801801011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000801801011', 0, '15000801030101', 'Finance and Banking', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000802001011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000802001011', 0, '15000801030101', 'Procurement and Logistics Management', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000802201011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000802201011', 0, '15000801030101', 'Business Management', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000802401011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000802401011', 0, '15000801030101', 'Computing and Information Technology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000802501031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000802501031', 0, '15000801030101', 'Strategic Studies', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000802601051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000802601051', 0, '15000801030101', 'Bachelor in Military Science', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000802701021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000802701021', 0, '15000801030101', 'Accountancy', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000802801021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000802801021', 0, '15000801030101', 'Procurement and Logistics Management', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000802903021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000802903021', 0, '15000801030101', 'Information Technology', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000803001021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000803001021', 0, '15000801030101', 'Finance and Banking', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000803101021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000803101021', 0, '15000801030101', 'Computer Science', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000803201021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000803201021', 0, '15000801030101', 'Business Management', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800101031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800101031', 0, '15000801030101', 'Accountancy', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800201031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800201031', 0, '15000801030101', 'Business Management', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800303031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800303031', 0, '15000801030101', 'Computer Science', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800401031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800401031', 0, '15000801030101', 'Finance and Banking', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800501031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800501031', 0, '15000801030101', 'Information Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800601031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800601031', 0, '15000801030101', 'Procurement and Logistics Management', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800705051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800705051', 0, '15000801030101', 'Bachelor of Finance and Banking', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800805051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800805051', 0, '15000801030101', 'Bachelor of Business Management', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000800905051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000800905051', 0, '15000801030101', 'Bachelor of Computer Science', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000801005051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000801005051', 0, '15000801030101', 'Bachelor of Information Technology', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000801105051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000801105051', 0, '15000801030101', 'Bachelor of Procurement and Logistics Management ', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000801205051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000801205051', 0, '15000801030101', 'Bachelor of Economics and Finance ', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000801305051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000801305051', 0, '15000801030101', 'Bachelor of Accountancy ', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900101051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900101051', 0, '15000902010501', 'Accountancy', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900201051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900201051', 0, '15000902010501', 'Business Administration', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900301051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900301051', 0, '15000902010501', 'Marketing', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900401051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900401051', 0, '15000902010501', 'Procurement and Supply', 'BTP', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900505051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900505051', 0, '15000902010501', 'Bachelor Degree in Legal and Industrial Metrology', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900605051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900605051', 0, '15000902010501', 'Bachelor Degree in Information and Communication Technology', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900705051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900705051', 0, '15000902010501', 'Bachelor Degree in Business Administration', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900805051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900805051', 0, '15000902010501', 'Bachelor Degree in Marketing', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000900905051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000900905051', 0, '15000902010501', 'Bachelor Degree in Procurement and Supplies Management', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000901005051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000901005051', 0, '15000902010501', 'Bachelor Degree in Accountancy', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000901205011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000901205011', 0, '15000902010501', 'Bachelor Degree in Business Studies with Education', 'UG', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15000901403031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15000901403031', 0, '15000902010501', 'Information and Communication Technology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000902803041'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000902803041', 0, '15000902010501', 'in Legal and Industrial Metrology', 'SAT', 'NTA', 'NTA7', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17000902903021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17000902903021', 0, '15000902010501', 'Information and Communication Technology', 'SAT', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000901501011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000901501011', 0, '15000902010501', 'Accountancy', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000901601011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000901601011', 0, '15000902010501', 'Business Administration', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000901701011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000901701011', 0, '15000902010501', 'Marketing', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000901801011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000901801011', 0, '15000902010501', 'Procurement and Supply', 'BTP', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000901903011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000901903011', 0, '15000902010501', 'Information Communication Technology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902001061'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902001061', 0, '15000902010501', 'Masters Degree in Human Resource Management', 'BTP', 'NTA', 'NTA9', '1', '2')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902102021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902102021', 0, '15000902010501', 'Business Administration', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902201021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902201021', 0, '15000902010501', 'Accountancy', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902301021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902301021', 0, '15000902010501', 'Marketing', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902401021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902401021', 0, '15000902010501', 'Procurement and Supply', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902501021'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902501021', 0, '15000902010501', 'Legal and Industrial Metrology', 'BTP', 'NTA', 'NTA5', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902603031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902603031', 0, '15000902010501', 'Legal and Industrial Metrology', 'SAT', 'NTA', 'NTA6', '2', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '16000902703011'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('16000902703011', 0, '15000902010501', 'Legal and Industrial Metreology', 'SAT', 'NTA', 'NTA4', '1', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '19903005051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('19903005051', 0, '15000902010501', 'Bachelor Degree in Mathematics', 'UG', 'NTA', 'NTA8', '1', '0')
DELETE FROM `progdefinitions` WHERE `PID` = '191002203041'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('191002203041', 0, '15001003040101', 'in Information and Communication Technology', 'SAT', 'NTA', 'NTA7', '2', '0')
DELETE FROM `progdefinitions` WHERE `PID` = '191002303051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('191002303051', 0, '15001003040101', 'Bachelor Degree in Information and Communication Technology', 'SAT', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '17001002101051'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('17001002101051', 0, '15001003040101', 'Bachelor Degree in Business Studies with Education', 'BTP', 'NTA', 'NTA8', '3', '1')
DELETE FROM `progdefinitions` WHERE `PID` = '15001000101031'INSERT INTO `progdefinitions` (`PID`, `ProgCode`, `NIRID`, `Name`, `Type`, `ProgType`, `Level`, `Duration`, `Status`) VALUES ('15001000101031', 0, '15001003040101', 'Accountancy', 'BTP', 'NTA', 'NTA6', '2', '1')