INSERT INTO NSCC_CAMPUS
VALUES (1, 'Akerley Campus');

INSERT INTO NSCC_CAMPUS
VALUES (2, 'Annapolis Valley Campus');

INSERT INTO NSCC_CAMPUS
VALUES (3, 'Burridge Campus');

INSERT INTO NSCC_CAMPUS
VALUES (4, 'Cumberland Campus');

INSERT INTO NSCC_CAMPUS
VALUES (5, 'Institute of Technology Campus');

INSERT INTO NSCC_CAMPUS
VALUES (6, 'Kingstec Campus');

INSERT INTO NSCC_CAMPUS
VALUES (7, 'Lunenburg Campus');

INSERT INTO NSCC_CAMPUS
VALUES (8, 'Marconi Campus');

INSERT INTO NSCC_CAMPUS
VALUES (9, 'Pictou Campus');

INSERT INTO NSCC_CAMPUS
VALUES (10, 'Shelburne Campus');

INSERT INTO NSCC_CAMPUS
VALUES (11, 'Strait Area Campus');

INSERT INTO NSCC_CAMPUS
VALUES (12, 'Truro Campus');

INSERT INTO NSCC_CAMPUS
VALUES (13, 'Waterfront Campus');

INSERT INTO NSCC_CAMPUS
VALUES (14, 'Aviation Institute');

INSERT INTO NSCC_CAMPUS
VALUES (15, 'Centre of Geographic Sciences (COGS)');

INSERT INTO NSCC_CAMPUS
VALUES (16, 'Nautical Institute and School of Fisheries');



INSERT INTO NSCC_CITIZENSHIP
VALUES (1, 'Canadian citizen');

INSERT INTO NSCC_CITIZENSHIP
VALUES (2, 'New Canadian/permanent resident');

INSERT INTO NSCC_CITIZENSHIP
VALUES (3, 'Refugee with protected person status');

INSERT INTO NSCC_CITIZENSHIP
VALUES (4, 'Other');



INSERT INTO NSCC_COUNTRY
VALUES ('CA', 'Canada');

INSERT INTO NSCC_COUNTRY
VALUES ('US', 'United States');

INSERT INTO NSCC_COUNTRY
VALUES ('AF', 'Afghanistan');

INSERT INTO NSCC_COUNTRY
VALUES ('AL', 'Albania');

INSERT INTO NSCC_COUNTRY
VALUES ('DZ', 'Algeria');

INSERT INTO NSCC_COUNTRY
VALUES ('DS', 'American Samoa');

INSERT INTO NSCC_COUNTRY
VALUES ('AD', 'Andorra');

INSERT INTO NSCC_COUNTRY
VALUES ('AO', 'Angola');

INSERT INTO NSCC_COUNTRY
VALUES ('AI', 'Anguilla');

INSERT INTO NSCC_COUNTRY
VALUES ('AQ', 'Antarctica');

INSERT INTO NSCC_COUNTRY
VALUES ('AG', 'Antigua and/or Barbuda');

INSERT INTO NSCC_COUNTRY
VALUES ('AR', 'Argentina');

INSERT INTO NSCC_COUNTRY
VALUES ('AM', 'Armenia');

INSERT INTO NSCC_COUNTRY
VALUES ('AW', 'Aruba');

INSERT INTO NSCC_COUNTRY
VALUES ('AU', 'Australia');

INSERT INTO NSCC_COUNTRY
VALUES ('AT', 'Austria');

INSERT INTO NSCC_COUNTRY
VALUES ('AZ', 'Azerbaijan');

INSERT INTO NSCC_COUNTRY
VALUES ('BS', 'Bahamas');

INSERT INTO NSCC_COUNTRY
VALUES ('BH', 'Bahrain');

INSERT INTO NSCC_COUNTRY
VALUES ('BD', 'Bangladesh');

INSERT INTO NSCC_COUNTRY
VALUES ('BB', 'Barbados');

INSERT INTO NSCC_COUNTRY
VALUES ('BY', 'Belarus');

INSERT INTO NSCC_COUNTRY
VALUES ('BE', 'Belgium');

INSERT INTO NSCC_COUNTRY
VALUES ('BZ', 'Belize');

INSERT INTO NSCC_COUNTRY
VALUES ('BJ', 'Benin');

INSERT INTO NSCC_COUNTRY
VALUES ('BM', 'Bermuda');

INSERT INTO NSCC_COUNTRY
VALUES ('BT', 'Bhutan');

INSERT INTO NSCC_COUNTRY
VALUES ('BO', 'Bolivia');

INSERT INTO NSCC_COUNTRY
VALUES ('BA', 'Bosnia and Herzegovina');

INSERT INTO NSCC_COUNTRY
VALUES ('BW', 'Botswana');

INSERT INTO NSCC_COUNTRY
VALUES ('BV', 'Bouvet Island');

INSERT INTO NSCC_COUNTRY
VALUES ('BR', 'Brazil');

INSERT INTO NSCC_COUNTRY
VALUES ('IO', 'British lndian Ocean Territory');

INSERT INTO NSCC_COUNTRY
VALUES ('BN', 'Brunei Darussalam');

INSERT INTO NSCC_COUNTRY
VALUES ('BG', 'Bulgaria');

INSERT INTO NSCC_COUNTRY
VALUES ('BF', 'Burkina Faso');

INSERT INTO NSCC_COUNTRY
VALUES ('BI', 'Burundi');

INSERT INTO NSCC_COUNTRY
VALUES ('KH', 'Cambodia');

INSERT INTO NSCC_COUNTRY
VALUES ('CM', 'Cameroon');

INSERT INTO NSCC_COUNTRY
VALUES ('CV', 'Cape Verde');

INSERT INTO NSCC_COUNTRY
VALUES ('KY', 'Cayman Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('CF', 'Central African Republic');

INSERT INTO NSCC_COUNTRY
VALUES ('TD', 'Chad');

INSERT INTO NSCC_COUNTRY
VALUES ('CL', 'Chile');

INSERT INTO NSCC_COUNTRY
VALUES ('CN', 'China');

INSERT INTO NSCC_COUNTRY
VALUES ('CX', 'Christmas Island');

INSERT INTO NSCC_COUNTRY
VALUES ('CC', 'Cocos (Keeling) Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('CO', 'Colombia');

INSERT INTO NSCC_COUNTRY
VALUES ('KM', 'Comoros');

INSERT INTO NSCC_COUNTRY
VALUES ('CG', 'Congo');

INSERT INTO NSCC_COUNTRY
VALUES ('CK', 'Cook Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('CR', 'Costa Rica');

INSERT INTO NSCC_COUNTRY
VALUES ('HR', 'Croatia (Hrvatska)');

INSERT INTO NSCC_COUNTRY
VALUES ('CU', 'Cuba');

INSERT INTO NSCC_COUNTRY
VALUES ('CY', 'Cyprus');

INSERT INTO NSCC_COUNTRY
VALUES ('CZ', 'Czech Republic');

INSERT INTO NSCC_COUNTRY
VALUES ('DK', 'Denmark');

INSERT INTO NSCC_COUNTRY
VALUES ('DJ', 'Djibouti');

INSERT INTO NSCC_COUNTRY
VALUES ('DM', 'Dominica');

INSERT INTO NSCC_COUNTRY
VALUES ('DO', 'Dominican Republic');

INSERT INTO NSCC_COUNTRY
VALUES ('TP', 'East Timor');

INSERT INTO NSCC_COUNTRY
VALUES ('EC', 'Ecudaor');

INSERT INTO NSCC_COUNTRY
VALUES ('EG', 'Egypt');

INSERT INTO NSCC_COUNTRY
VALUES ('SV', 'El Salvador');

INSERT INTO NSCC_COUNTRY
VALUES ('GQ', 'Equatorial Guinea');

INSERT INTO NSCC_COUNTRY
VALUES ('ER', 'Eritrea');

INSERT INTO NSCC_COUNTRY
VALUES ('EE', 'Estonia');

INSERT INTO NSCC_COUNTRY
VALUES ('ET', 'Ethiopia');

INSERT INTO NSCC_COUNTRY
VALUES ('FK', 'Falkland Islands (Malvinas)');

INSERT INTO NSCC_COUNTRY
VALUES ('FO', 'Faroe Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('FJ', 'Fiji');

INSERT INTO NSCC_COUNTRY
VALUES ('FI', 'Finland');

INSERT INTO NSCC_COUNTRY
VALUES ('FR', 'France');

INSERT INTO NSCC_COUNTRY
VALUES ('FX', 'France, Metropolitan');

INSERT INTO NSCC_COUNTRY
VALUES ('GF', 'French Guiana');

INSERT INTO NSCC_COUNTRY
VALUES ('PF', 'French Polynesia');

INSERT INTO NSCC_COUNTRY
VALUES ('TF', 'French Southern Territories');

INSERT INTO NSCC_COUNTRY
VALUES ('GA', 'Gabon');

INSERT INTO NSCC_COUNTRY
VALUES ('GM', 'Gambia');

INSERT INTO NSCC_COUNTRY
VALUES ('GE', 'Georgia');

INSERT INTO NSCC_COUNTRY
VALUES ('DE', 'Germany');

INSERT INTO NSCC_COUNTRY
VALUES ('GH', 'Ghana');

INSERT INTO NSCC_COUNTRY
VALUES ('GI', 'Gibraltar');

INSERT INTO NSCC_COUNTRY
VALUES ('GR', 'Greece');

INSERT INTO NSCC_COUNTRY
VALUES ('GL', 'Greenland');

INSERT INTO NSCC_COUNTRY
VALUES ('GD', 'Grenada');

INSERT INTO NSCC_COUNTRY
VALUES ('GP', 'Guadeloupe');

INSERT INTO NSCC_COUNTRY
VALUES ('GU', 'Guam');

INSERT INTO NSCC_COUNTRY
VALUES ('GT', 'Guatemala');

INSERT INTO NSCC_COUNTRY
VALUES ('GN', 'Guinea');

INSERT INTO NSCC_COUNTRY
VALUES ('GW', 'Guinea-Bissau');

INSERT INTO NSCC_COUNTRY
VALUES ('GY', 'Guyana');

INSERT INTO NSCC_COUNTRY
VALUES ('HT', 'Haiti');

INSERT INTO NSCC_COUNTRY
VALUES ('HM', 'Heard and Mc Donald Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('HN', 'Honduras');

INSERT INTO NSCC_COUNTRY
VALUES ('HK', 'Hong Kong');

INSERT INTO NSCC_COUNTRY
VALUES ('HU', 'Hungary');

INSERT INTO NSCC_COUNTRY
VALUES ('IS', 'Iceland');

INSERT INTO NSCC_COUNTRY
VALUES ('IN', 'India');

INSERT INTO NSCC_COUNTRY
VALUES ('ID', 'Indonesia');

INSERT INTO NSCC_COUNTRY
VALUES ('IR', 'Iran (Islamic Republic of)');

INSERT INTO NSCC_COUNTRY
VALUES ('IQ', 'Iraq');

INSERT INTO NSCC_COUNTRY
VALUES ('IE', 'Ireland');

INSERT INTO NSCC_COUNTRY
VALUES ('IL', 'Israel');

INSERT INTO NSCC_COUNTRY
VALUES ('IT', 'Italy');

INSERT INTO NSCC_COUNTRY
VALUES ('CI', 'Ivory Coast');

INSERT INTO NSCC_COUNTRY
VALUES ('JM', 'Jamaica');

INSERT INTO NSCC_COUNTRY
VALUES ('JP', 'Japan');

INSERT INTO NSCC_COUNTRY
VALUES ('JO', 'Jordan');

INSERT INTO NSCC_COUNTRY
VALUES ('KZ', 'Kazakhstan');

INSERT INTO NSCC_COUNTRY
VALUES ('KE', 'Kenya');

INSERT INTO NSCC_COUNTRY
VALUES ('KI', 'Kiribati');

INSERT INTO NSCC_COUNTRY
VALUES ('KP', 'Korea, Democratic People''s Republic of');

INSERT INTO NSCC_COUNTRY
VALUES ('KR', 'Korea, Republic of');

INSERT INTO NSCC_COUNTRY
VALUES ('KW', 'Kuwait');

INSERT INTO NSCC_COUNTRY
VALUES ('KG', 'Kyrgyzstan');

INSERT INTO NSCC_COUNTRY
VALUES ('LA', 'Lao People''s Democratic Republic');

INSERT INTO NSCC_COUNTRY
VALUES ('LV', 'Latvia');

INSERT INTO NSCC_COUNTRY
VALUES ('LB', 'Lebanon');

INSERT INTO NSCC_COUNTRY
VALUES ('LS', 'Lesotho');

INSERT INTO NSCC_COUNTRY
VALUES ('LR', 'Liberia');

INSERT INTO NSCC_COUNTRY
VALUES ('LY', 'Libyan Arab Jamahiriya');

INSERT INTO NSCC_COUNTRY
VALUES ('LI', 'Liechtenstein');

INSERT INTO NSCC_COUNTRY
VALUES ('LT', 'Lithuania');

INSERT INTO NSCC_COUNTRY
VALUES ('LU', 'Luxembourg');

INSERT INTO NSCC_COUNTRY
VALUES ('MO', 'Macau');

INSERT INTO NSCC_COUNTRY
VALUES ('MK', 'Macedonia');

INSERT INTO NSCC_COUNTRY
VALUES ('MG', 'Madagascar');

INSERT INTO NSCC_COUNTRY
VALUES ('MW', 'Malawi');

INSERT INTO NSCC_COUNTRY
VALUES ('MY', 'Malaysia');

INSERT INTO NSCC_COUNTRY
VALUES ('MV', 'Maldives');

INSERT INTO NSCC_COUNTRY
VALUES ('ML', 'Mali');

INSERT INTO NSCC_COUNTRY
VALUES ('MT', 'Malta');

INSERT INTO NSCC_COUNTRY
VALUES ('MH', 'Marshall Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('MQ', 'Martinique');

INSERT INTO NSCC_COUNTRY
VALUES ('MR', 'Mauritania');

INSERT INTO NSCC_COUNTRY
VALUES ('MU', 'Mauritius');

INSERT INTO NSCC_COUNTRY
VALUES ('TY', 'Mayotte');

INSERT INTO NSCC_COUNTRY
VALUES ('MX', 'Mexico');

INSERT INTO NSCC_COUNTRY
VALUES ('FM', 'Micronesia, Federated States of');

INSERT INTO NSCC_COUNTRY
VALUES ('MD', 'Moldova, Republic of');

INSERT INTO NSCC_COUNTRY
VALUES ('MC', 'Monaco');

INSERT INTO NSCC_COUNTRY
VALUES ('MN', 'Mongolia');

INSERT INTO NSCC_COUNTRY
VALUES ('MS', 'Montserrat');

INSERT INTO NSCC_COUNTRY
VALUES ('MA', 'Morocco');

INSERT INTO NSCC_COUNTRY
VALUES ('MZ', 'Mozambique');

INSERT INTO NSCC_COUNTRY
VALUES ('MM', 'Myanmar');

INSERT INTO NSCC_COUNTRY
VALUES ('NA', 'Namibia');

INSERT INTO NSCC_COUNTRY
VALUES ('NR', 'Nauru');

INSERT INTO NSCC_COUNTRY
VALUES ('NP', 'Nepal');

INSERT INTO NSCC_COUNTRY
VALUES ('NL', 'Netherlands');

INSERT INTO NSCC_COUNTRY
VALUES ('AN', 'Netherlands Antilles');

INSERT INTO NSCC_COUNTRY
VALUES ('NC', 'New Caledonia');

INSERT INTO NSCC_COUNTRY
VALUES ('NZ', 'New Zealand');

INSERT INTO NSCC_COUNTRY
VALUES ('NI', 'Nicaragua');

INSERT INTO NSCC_COUNTRY
VALUES ('NE', 'Niger');

INSERT INTO NSCC_COUNTRY
VALUES ('NG', 'Nigeria');

INSERT INTO NSCC_COUNTRY
VALUES ('NU', 'Niue');

INSERT INTO NSCC_COUNTRY
VALUES ('NF', 'Norfork Island');

INSERT INTO NSCC_COUNTRY
VALUES ('MP', 'Northern Mariana Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('NO', 'Norway');

INSERT INTO NSCC_COUNTRY
VALUES ('OM', 'Oman');

INSERT INTO NSCC_COUNTRY
VALUES ('PK', 'Pakistan');

INSERT INTO NSCC_COUNTRY
VALUES ('PW', 'Palau');

INSERT INTO NSCC_COUNTRY
VALUES ('PA', 'Panama');

INSERT INTO NSCC_COUNTRY
VALUES ('PG', 'Papua New Guinea');

INSERT INTO NSCC_COUNTRY
VALUES ('PY', 'Paraguay');

INSERT INTO NSCC_COUNTRY
VALUES ('PE', 'Peru');

INSERT INTO NSCC_COUNTRY
VALUES ('PH', 'Philippines');

INSERT INTO NSCC_COUNTRY
VALUES ('PN', 'Pitcairn');

INSERT INTO NSCC_COUNTRY
VALUES ('PL', 'Poland');

INSERT INTO NSCC_COUNTRY
VALUES ('PT', 'Portugal');

INSERT INTO NSCC_COUNTRY
VALUES ('PR', 'Puerto Rico');

INSERT INTO NSCC_COUNTRY
VALUES ('QA', 'Qatar');

INSERT INTO NSCC_COUNTRY
VALUES ('RE', 'Reunion');

INSERT INTO NSCC_COUNTRY
VALUES ('RO', 'Romania');

INSERT INTO NSCC_COUNTRY
VALUES ('RU', 'Russian Federation');

INSERT INTO NSCC_COUNTRY
VALUES ('RW', 'Rwanda');

INSERT INTO NSCC_COUNTRY
VALUES ('KN', 'Saint Kitts and Nevis');

INSERT INTO NSCC_COUNTRY
VALUES ('LC', 'Saint Lucia');

INSERT INTO NSCC_COUNTRY
VALUES ('VC', 'Saint Vincent and the Grenadines');

INSERT INTO NSCC_COUNTRY
VALUES ('WS', 'Samoa');

INSERT INTO NSCC_COUNTRY
VALUES ('SM', 'San Marino');

INSERT INTO NSCC_COUNTRY
VALUES ('ST', 'Sao Tome and Principe');

INSERT INTO NSCC_COUNTRY
VALUES ('SA', 'Saudi Arabia');

INSERT INTO NSCC_COUNTRY
VALUES ('SN', 'Senegal');

INSERT INTO NSCC_COUNTRY
VALUES ('SC', 'Seychelles');

INSERT INTO NSCC_COUNTRY
VALUES ('SL', 'Sierra Leone');

INSERT INTO NSCC_COUNTRY
VALUES ('SG', 'Singapore');

INSERT INTO NSCC_COUNTRY
VALUES ('SK', 'Slovakia');

INSERT INTO NSCC_COUNTRY
VALUES ('SI', 'Slovenia');

INSERT INTO NSCC_COUNTRY
VALUES ('SB', 'Solomon Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('SO', 'Somalia');

INSERT INTO NSCC_COUNTRY
VALUES ('ZA', 'South Africa');

INSERT INTO NSCC_COUNTRY
VALUES ('GS', 'South Georgia South Sandwich Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('ES', 'Spain');

INSERT INTO NSCC_COUNTRY
VALUES ('LK', 'Sri Lanka');

INSERT INTO NSCC_COUNTRY
VALUES ('SH', 'St. Helena');

INSERT INTO NSCC_COUNTRY
VALUES ('PM', 'St. Pierre and Miquelon');

INSERT INTO NSCC_COUNTRY
VALUES ('SD', 'Sudan');

INSERT INTO NSCC_COUNTRY
VALUES ('SR', 'Suriname');

INSERT INTO NSCC_COUNTRY
VALUES ('SJ', 'Svalbarn and Jan Mayen Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('SZ', 'Swaziland');

INSERT INTO NSCC_COUNTRY
VALUES ('SE', 'Sweden');

INSERT INTO NSCC_COUNTRY
VALUES ('CH', 'Switzerland');

INSERT INTO NSCC_COUNTRY
VALUES ('SY', 'Syrian Arab Republic');

INSERT INTO NSCC_COUNTRY
VALUES ('TW', 'Taiwan');

INSERT INTO NSCC_COUNTRY
VALUES ('TJ', 'Tajikistan');

INSERT INTO NSCC_COUNTRY
VALUES ('TZ', 'Tanzania, United Republic of');

INSERT INTO NSCC_COUNTRY
VALUES ('TH', 'Thailand');

INSERT INTO NSCC_COUNTRY
VALUES ('TG', 'Togo');

INSERT INTO NSCC_COUNTRY
VALUES ('TK', 'Tokelau');

INSERT INTO NSCC_COUNTRY
VALUES ('TO', 'Tonga');

INSERT INTO NSCC_COUNTRY
VALUES ('TT', 'Trinidad and Tobago');

INSERT INTO NSCC_COUNTRY
VALUES ('TN', 'Tunisia');

INSERT INTO NSCC_COUNTRY
VALUES ('TR', 'Turkey');

INSERT INTO NSCC_COUNTRY
VALUES ('TM', 'Turkmenistan');

INSERT INTO NSCC_COUNTRY
VALUES ('TC', 'Turks and Caicos Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('TV', 'Tuvalu');

INSERT INTO NSCC_COUNTRY
VALUES ('UG', 'Uganda');

INSERT INTO NSCC_COUNTRY
VALUES ('UA', 'Ukraine');

INSERT INTO NSCC_COUNTRY
VALUES ('AE', 'United Arab Emirates');

INSERT INTO NSCC_COUNTRY
VALUES ('GB', 'United Kingdom');

INSERT INTO NSCC_COUNTRY
VALUES ('UM', 'United States minor outlying islands');

INSERT INTO NSCC_COUNTRY
VALUES ('UY', 'Uruguay');

INSERT INTO NSCC_COUNTRY
VALUES ('UZ', 'Uzbekistan');

INSERT INTO NSCC_COUNTRY
VALUES ('VU', 'Vanuatu');

INSERT INTO NSCC_COUNTRY
VALUES ('VA', 'Vatican City State');

INSERT INTO NSCC_COUNTRY
VALUES ('VE', 'Venezuela');

INSERT INTO NSCC_COUNTRY
VALUES ('VN', 'Vietnam');

INSERT INTO NSCC_COUNTRY
VALUES ('VG', 'Virigan Islands (British)');

INSERT INTO NSCC_COUNTRY
VALUES ('VI', 'Virgin Islands (U.S.)');

INSERT INTO NSCC_COUNTRY
VALUES ('WF', 'Wallis and Futuna Islands');

INSERT INTO NSCC_COUNTRY
VALUES ('EH', 'Western Sahara');

INSERT INTO NSCC_COUNTRY
VALUES ('YE', 'Yemen');

INSERT INTO NSCC_COUNTRY
VALUES ('YU', 'Yugoslavia');

INSERT INTO NSCC_COUNTRY
VALUES ('ZR', 'Zaire');

INSERT INTO NSCC_COUNTRY
VALUES ('ZM', 'Zambia');

INSERT INTO NSCC_COUNTRY
VALUES ('ZW', 'Zimbabwe');




INSERT INTO NSCC_CREDIT_CARD_COMPANY
VALUES ('1', 'Visa');

INSERT INTO NSCC_CREDIT_CARD_COMPANY
VALUES ('2', 'Mastercard');

INSERT INTO NSCC_CREDIT_CARD_COMPANY
VALUES ('3', 'American Express');

INSERT INTO NSCC_CREDIT_CARD_COMPANY
VALUES ('4', 'Discover');




INSERT INTO NSCC_LANGUAGE
VALUES ('1', 'Afrikaans');

INSERT INTO NSCC_LANGUAGE
VALUES ('2', 'Albanian');

INSERT INTO NSCC_LANGUAGE
VALUES ('3', 'Arabic');

INSERT INTO NSCC_LANGUAGE
VALUES ('4', 'Armenian');

INSERT INTO NSCC_LANGUAGE
VALUES ('5', 'Basque');

INSERT INTO NSCC_LANGUAGE
VALUES ('6', 'Bengali');

INSERT INTO NSCC_LANGUAGE
VALUES ('7', 'Bulgarian');

INSERT INTO NSCC_LANGUAGE
VALUES ('8', 'Catalan');

INSERT INTO NSCC_LANGUAGE
VALUES ('9', 'Cambodian');

INSERT INTO NSCC_LANGUAGE
VALUES ('10', 'Chinese');

INSERT INTO NSCC_LANGUAGE
VALUES ('11', 'Croatian');

INSERT INTO NSCC_LANGUAGE
VALUES ('12', 'Czech');

INSERT INTO NSCC_LANGUAGE
VALUES ('13', 'Danish');

INSERT INTO NSCC_LANGUAGE
VALUES ('14', 'Dutch');

INSERT INTO NSCC_LANGUAGE
VALUES ('15', 'English');

INSERT INTO NSCC_LANGUAGE
VALUES ('16', 'Estonian');

INSERT INTO NSCC_LANGUAGE
VALUES ('17', 'Fiji');

INSERT INTO NSCC_LANGUAGE
VALUES ('18', 'Finnish');

INSERT INTO NSCC_LANGUAGE
VALUES ('19', 'French');

INSERT INTO NSCC_LANGUAGE
VALUES ('20', 'Georgian');

INSERT INTO NSCC_LANGUAGE
VALUES ('21', 'German');

INSERT INTO NSCC_LANGUAGE
VALUES ('22', 'Greek');

INSERT INTO NSCC_LANGUAGE
VALUES ('23', 'Gujarati');

INSERT INTO NSCC_LANGUAGE
VALUES ('24', 'Hebrew');

INSERT INTO NSCC_LANGUAGE
VALUES ('25', 'Hindi');

INSERT INTO NSCC_LANGUAGE
VALUES ('26', 'Hungarian');

INSERT INTO NSCC_LANGUAGE
VALUES ('27', 'Icelandic');

INSERT INTO NSCC_LANGUAGE
VALUES ('28', 'Indonesian');

INSERT INTO NSCC_LANGUAGE
VALUES ('29', 'Irish');

INSERT INTO NSCC_LANGUAGE
VALUES ('30', 'Italian');

INSERT INTO NSCC_LANGUAGE
VALUES ('31', 'Japanese');

INSERT INTO NSCC_LANGUAGE
VALUES ('32', 'Javanese');

INSERT INTO NSCC_LANGUAGE
VALUES ('33', 'Korean');

INSERT INTO NSCC_LANGUAGE
VALUES ('34', 'Latin');

INSERT INTO NSCC_LANGUAGE
VALUES ('35', 'Latvian');

INSERT INTO NSCC_LANGUAGE
VALUES ('36', 'Lithuanian');

INSERT INTO NSCC_LANGUAGE
VALUES ('37', 'Macedonian');

INSERT INTO NSCC_LANGUAGE
VALUES ('38', 'Malay');

INSERT INTO NSCC_LANGUAGE
VALUES ('39', 'Malayalam');

INSERT INTO NSCC_LANGUAGE
VALUES ('40', 'Maltese');

INSERT INTO NSCC_LANGUAGE
VALUES ('41', 'Maori');

INSERT INTO NSCC_LANGUAGE
VALUES ('42', 'Marathi');

INSERT INTO NSCC_LANGUAGE
VALUES ('43', 'Mongolian');

INSERT INTO NSCC_LANGUAGE
VALUES ('44', 'Nepali');

INSERT INTO NSCC_LANGUAGE
VALUES ('45', 'Norwegian');

INSERT INTO NSCC_LANGUAGE
VALUES ('46', 'Persian');

INSERT INTO NSCC_LANGUAGE
VALUES ('47', 'Polish');

INSERT INTO NSCC_LANGUAGE
VALUES ('48', 'Portuguese');

INSERT INTO NSCC_LANGUAGE
VALUES ('49', 'Punjabi');

INSERT INTO NSCC_LANGUAGE
VALUES ('50', 'Quechua');

INSERT INTO NSCC_LANGUAGE
VALUES ('51', 'Romanian');

INSERT INTO NSCC_LANGUAGE
VALUES ('52', 'Russian');

INSERT INTO NSCC_LANGUAGE
VALUES ('53', 'Samoan');

INSERT INTO NSCC_LANGUAGE
VALUES ('54', 'Serbian');

INSERT INTO NSCC_LANGUAGE
VALUES ('55', 'Slovak');

INSERT INTO NSCC_LANGUAGE
VALUES ('56', 'Slovenian');

INSERT INTO NSCC_LANGUAGE
VALUES ('57', 'Spanish');

INSERT INTO NSCC_LANGUAGE
VALUES ('58', 'Swahili');

INSERT INTO NSCC_LANGUAGE
VALUES ('59', 'Swedish');

INSERT INTO NSCC_LANGUAGE
VALUES ('60', 'Tamil');

INSERT INTO NSCC_LANGUAGE
VALUES ('61', 'Tatar');

INSERT INTO NSCC_LANGUAGE
VALUES ('62', 'Telugu');

INSERT INTO NSCC_LANGUAGE
VALUES ('63', 'Thai');

INSERT INTO NSCC_LANGUAGE
VALUES ('64', 'Tibetan');

INSERT INTO NSCC_LANGUAGE
VALUES ('65', 'Tonga');

INSERT INTO NSCC_LANGUAGE
VALUES ('66', 'Turkish');

INSERT INTO NSCC_LANGUAGE
VALUES ('67', 'Ukrainian');

INSERT INTO NSCC_LANGUAGE
VALUES ('68', 'Urdu');

INSERT INTO NSCC_LANGUAGE
VALUES ('69', 'Uzbek');

INSERT INTO NSCC_LANGUAGE
VALUES ('70', 'Vietnamese');

INSERT INTO NSCC_LANGUAGE
VALUES ('71', 'Welsh');

INSERT INTO NSCC_LANGUAGE
VALUES ('72', 'Xhosa');



INSERT INTO NSCC_PROGRAM
VALUES (1, 'Academic & Career Connections', 1);

INSERT INTO NSCC_PROGRAM
VALUES (2, 'Addictions Community Outreach', 1);

INSERT INTO NSCC_PROGRAM
VALUES (3, 'Adult Learning Program', 1);

INSERT INTO NSCC_PROGRAM
VALUES (4, 'African Canadian Transition Program', 1);

INSERT INTO NSCC_PROGRAM
VALUES (5, 'Aircraft Maintenance Engineer (Avionics)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (6, 'Aircraft Maintenance Engineer (Mechanical)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (7, 'Aircraft Maintenance Engineer (Structures)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (8, 'American Sign Language/English Interpretation', 1);

INSERT INTO NSCC_PROGRAM
VALUES (9, 'Applied Media & Communication Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (10, 'Architectural Engineering Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (11, 'Automotive Collision Repair & Refinishing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (12, 'Automotive Service & Repair', 1);

INSERT INTO NSCC_PROGRAM
VALUES (13, 'Automotive Service Advisor', 1);

INSERT INTO NSCC_PROGRAM
VALUES (14, 'Baking & Pastry Art', 1);

INSERT INTO NSCC_PROGRAM
VALUES (15, 'Behavioural Interventions', 1);

INSERT INTO NSCC_PROGRAM
VALUES (16, 'Boulanger & Baking Art', 1);

INSERT INTO NSCC_PROGRAM
VALUES (17, 'Bricklaying Masonry', 1);

INSERT INTO NSCC_PROGRAM
VALUES (18, 'Building Systems Technician (HVAC&R)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (19, 'Business Administration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (20, 'Business Administration - Accounting Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (21, 'Business Administration - Financial Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (22, 'Business Administration - Investment Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (23, 'Business Administration - Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (24, 'Business Administration - Marketing Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (25, 'Business Administration - Software & Information Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (26, 'Cabinetmaking', 1);

INSERT INTO NSCC_PROGRAM
VALUES (27, 'CAD Technician - Mechanical', 1);

INSERT INTO NSCC_PROGRAM
VALUES (28, 'Carpentry', 1);

INSERT INTO NSCC_PROGRAM
VALUES (29, 'Civil Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (30, 'Community Disability Supports', 1);

INSERT INTO NSCC_PROGRAM
VALUES (31, 'Computer Electronics Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (32, 'Construction Management Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (33, 'Continuing Care', 1);

INSERT INTO NSCC_PROGRAM
VALUES (34, 'Cooking', 1);

INSERT INTO NSCC_PROGRAM
VALUES (35, 'Cosmetology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (36, 'Culinary Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (37, 'Deaf Studies', 1);

INSERT INTO NSCC_PROGRAM
VALUES (38, 'Dental Assisting - Level II', 1);

INSERT INTO NSCC_PROGRAM
VALUES (39, 'Diesel Repair – Industrial & Marine', 1);

INSERT INTO NSCC_PROGRAM
VALUES (40, 'Digital Animation', 1);

INSERT INTO NSCC_PROGRAM
VALUES (41, 'Drafting – Architectural', 1);

INSERT INTO NSCC_PROGRAM
VALUES (42, 'Early Childhood Education', 1);

INSERT INTO NSCC_PROGRAM
VALUES (43, 'Electrical - Construction & Industrial - Diploma', 1);

INSERT INTO NSCC_PROGRAM
VALUES (44, 'Electrical - Construction & Industrial - Certificate', 1);

INSERT INTO NSCC_PROGRAM
VALUES (45, 'Electrical Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (46, 'Electro Mechanical Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (47, 'Electronic Engineering Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (48, 'Electronic Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (49, 'Energy Sustainability Engineering Technology (ESET)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (50, 'English for Academic Purposes (EAP)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (51, 'Environmental Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (52, 'Esthetics', 1);

INSERT INTO NSCC_PROGRAM
VALUES (53, 'Funeral & Allied Health Services', 1);

INSERT INTO NSCC_PROGRAM
VALUES (54, 'Funeral Arranging & Directing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (55, 'Gas Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (56, 'Geographic Sciences', 1);

INSERT INTO NSCC_PROGRAM
VALUES (57, 'Geographic Sciences - Cartography Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (58, 'Geographic Sciences - Community & Environmental Planning Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (59, 'Geographic Sciences - Geographic Information Systems (GIS) Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (60, 'Geographic Sciences - Remote Sensing Technology Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (61, 'Geographic Sciences – Advanced Diploma', 1);

INSERT INTO NSCC_PROGRAM
VALUES (62, 'Geographic Sciences – Advanced Diploma - Geographic Information Systems (GIS) Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (63, 'Geographic Sciences – Advanced Diploma - GIS for Business Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (64, 'Geographic Sciences – Advanced Diploma - Remote Sensing Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (65, 'Geomatics Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (66, 'Graphic & Print Production', 1);

INSERT INTO NSCC_PROGRAM
VALUES (67, 'Graphic Design', 1);

INSERT INTO NSCC_PROGRAM
VALUES (68, 'Health Information Management (HIM)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (69, 'Heavy Duty Equipment /Truck and Transport Repair – Certificate', 1);

INSERT INTO NSCC_PROGRAM
VALUES (70, 'Heavy Duty Equipment /Truck and Transport Repair – Diploma', 1);

INSERT INTO NSCC_PROGRAM
VALUES (71, 'Heavy Equipment Operator', 1);

INSERT INTO NSCC_PROGRAM
VALUES (72, 'Heritage Carpentry', 1);

INSERT INTO NSCC_PROGRAM
VALUES (73, 'Horticulture & Landscape Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (74, 'Horticulture & Landscape Technology - Landscape Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (75, 'Horticulture & Landscape Technology - Operations Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (76, 'Human Resource Management', 1);

INSERT INTO NSCC_PROGRAM
VALUES (77, 'Human Services', 1);

INSERT INTO NSCC_PROGRAM
VALUES (78, 'Human Services - Child & Youth Care Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (79, 'Human Services - Community Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (80, 'Human Services - Correctional Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (81, 'Human Services - Disability Supports & Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (82, 'Human Services - Educational Support Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (83, 'Human Services - Non-profit Leadership Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (84, 'Human Services - Open Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (85, 'Human Services - Therapeutic Recreation Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (86, 'Industrial Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (87, 'Industrial Instrumentation', 1);

INSERT INTO NSCC_PROGRAM
VALUES (88, 'Industrial Mechanical', 1);

INSERT INTO NSCC_PROGRAM
VALUES (89, 'Information Technology (IT)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (90, 'Information Technology (IT) - Database Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (91, 'Information Technology (IT) - Programming Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (92, 'Information Technology (IT) - Systems Management/Networking Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (93, 'Information Technology (IT) - Web Development Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (94, 'Interactive & Motion Graphics', 1);

INSERT INTO NSCC_PROGRAM
VALUES (95, 'Interactive & Motion Graphics - 3D Modeling & Motion Capture Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (96, 'Interactive & Motion Graphics - Flash Interactive Media Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (97, 'Interactive & Motion Graphics - Game Design Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (98, 'Interactive & Motion Graphics - Visual Effects Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (99, 'International Business', 1);

INSERT INTO NSCC_PROGRAM
VALUES (100, 'Law & Security', 1);

INSERT INTO NSCC_PROGRAM
VALUES (101, 'Library & Information Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (102, 'Machining', 1);

INSERT INTO NSCC_PROGRAM
VALUES (103, 'Marine - Industrial Rigging', 1);

INSERT INTO NSCC_PROGRAM
VALUES (104, 'Marine Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (105, 'Marine Geomatics', 1);

INSERT INTO NSCC_PROGRAM
VALUES (106, 'Marine Navigation Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (107, 'Mechanical Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (108, 'Medical Laboratory Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (109, 'Medical Office Administration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (110, 'Medical Transcription', 1);

INSERT INTO NSCC_PROGRAM
VALUES (111, 'Mental Health Recovery & Promotion', 1);

INSERT INTO NSCC_PROGRAM
VALUES (112, 'Metal Fabrication', 1);

INSERT INTO NSCC_PROGRAM
VALUES (113, 'Mi''kmaw Health & Wellness', 1);

INSERT INTO NSCC_PROGRAM
VALUES (114, 'Motorcycle & Power Products Repair', 1);

INSERT INTO NSCC_PROGRAM
VALUES (115, 'Music Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (116, 'Music Business', 1);

INSERT INTO NSCC_PROGRAM
VALUES (117, 'Natural Resources Environmental Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (118, 'Occupational Health & Safety', 1);

INSERT INTO NSCC_PROGRAM
VALUES (119, 'Occupational Therapy & Physiotherapy Assistant', 1);

INSERT INTO NSCC_PROGRAM
VALUES (120, 'Office Administration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (121, 'Office Administration - Software & Information Management', 1);

INSERT INTO NSCC_PROGRAM
VALUES (122, 'Oil Heat Systems Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (123, 'Paralegal Services', 1);

INSERT INTO NSCC_PROGRAM
VALUES (124, 'Pharmacy Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (125, 'Photography', 1);

INSERT INTO NSCC_PROGRAM
VALUES (126, 'Pipe Trades', 1);

INSERT INTO NSCC_PROGRAM
VALUES (127, 'Plumbing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (128, 'Power Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (129, 'Practical Nursing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (130, 'Process Operations – 4th Class Power Engineering', 1);

INSERT INTO NSCC_PROGRAM
VALUES (131, 'Public Relations', 1);

INSERT INTO NSCC_PROGRAM
VALUES (132, 'Radio & Television Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (133, 'Radio & Television Arts - Broadcast Journalism Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (134, 'Radio & Television Arts - Radio Performance & Studio Production Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (135, 'Radio & Television Arts - Television Production Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (136, 'Recording Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (137, 'Recreation Leadership', 1);

INSERT INTO NSCC_PROGRAM
VALUES (138, 'Refrigeration & Air Conditioning', 1);

INSERT INTO NSCC_PROGRAM
VALUES (139, 'Refrigeration & Air Conditioning - Geothermal', 1);

INSERT INTO NSCC_PROGRAM
VALUES (140, 'Screen Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (141, 'Steamfitting/Pipefitting', 1);

INSERT INTO NSCC_PROGRAM
VALUES (142, 'Survey Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (143, 'Tourism Management', 1);

INSERT INTO NSCC_PROGRAM
VALUES (144, 'Utility Line Work-Construction & Maintenance', 1);

INSERT INTO NSCC_PROGRAM
VALUES (145, 'Welding', 1);

INSERT INTO NSCC_PROGRAM
VALUES (146, 'Welding – Certified', 1);

INSERT INTO NSCC_PROGRAM
VALUES (147, 'Welding Inspection & Quality Control', 1);

INSERT INTO NSCC_PROGRAM
VALUES (148, 'Wood Products Manufacturing Technology', 1);



INSERT INTO NSCC_PROVINCE_STATE
VALUES ('AL', 'Alabama');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('AK', 'Alaska');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('AZ', 'Arizona');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('AR', 'Arkansas');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('CA', 'California');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('CO', 'Colorado');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('CT', 'Connecticut');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('DE', 'Delaware');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('FL', 'Florida');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('GA', 'Georgia');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('HI', 'Hawaii');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('ID', 'Idaho');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('IL', 'Illinois');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('IN', 'Indiana');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('IA', 'Iowa');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('KS', 'Kansas');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('KY', 'Kentucky');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('LA', 'Louisiana');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('ME', 'Maine');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MD', 'Maryland');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MA', 'Massachusetts');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MI', 'Michigan');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MN', 'Minnesota');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MS', 'Mississippi');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MO', 'Missouri');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MT', 'Montana');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NE', 'Nebraska');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NV', 'Nevada');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NH', 'New Hampshire');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NJ', 'New Jersey');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NM', 'New Mexico');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NY', 'New York');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NC', 'North Carolina');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('ND', 'North Dakota');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('OH', 'Ohio');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('OK', 'Oklahoma');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('OR', 'Oregon');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('PA', 'Pennsylvania');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('RI', 'Rhode Island');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('SC', 'South Carolina');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('SD', 'South Dakota');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('TN', 'Tennessee');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('TX', 'Texas');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('UT', 'Utah');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('VT', 'Vermont');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('VA', 'Virginia');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('WA', 'Washington');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('WV', 'West Virginia');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('WI', 'Wisconsin');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('WY', 'Wyoming');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('DC', 'Washington DC');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('PR', 'Puerto Rico');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('VI', 'U.S. Virgin Islands');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('AS', 'American Samoa');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('GU', 'Guam');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MP', 'Northern Mariana Islands');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('AB', 'Alberta');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('BC', 'British Columbia');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('MB', 'Manitoba');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NB', 'New Brunswick');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NL', 'Newfoundland and Labrador');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NS', 'Nova Scotia');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('ON', 'Ontario');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('PE', 'Prince Edward Island');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('QC', 'Quebec');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('SK', 'Saskatchewan');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NT', 'Northwest Territories');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('NU', 'Nunavut');

INSERT INTO NSCC_PROVINCE_STATE
VALUES ('YT', 'Yukon Territory');


INSERT INTO NSCC_SCHOOL_TYPE
VALUES (1, 'Community College');

INSERT INTO NSCC_SCHOOL_TYPE
VALUES (2, 'GED');

INSERT INTO NSCC_SCHOOL_TYPE
VALUES (3, 'High School');

INSERT INTO NSCC_SCHOOL_TYPE
VALUES (4, 'University');

INSERT INTO NSCC_SCHOOL_TYPE
VALUES (5, 'Technical College');

INSERT INTO NSCC_SCHOOL_TYPE
VALUES (6, 'Vocational School');

INSERT INTO NSCC_SCHOOL_TYPE
VALUES (7, 'Other School Type');