1. Brian Lewis Avatar Brian Lewis
  2. Untitled project
  3. pineapples
  4. Issues

Support for ISCED for Fields of Education and Training

Issue #1014 resolved
Ghislain Hachey created an issue

[Ghislain or Brian]

So if it would not be too much work to extend lkpSubjects with ISCED-F coding (http://uis.unesco.org/sites/default/files/documents/international-standard-classification-of-education-fields-of-education-and-training-2013-detailed-field-descriptions-2015-en.pdf) in the same way lkpLevels have ISCED-P. A simple way to be able to report following ISCED standard when the need will undoubt present itself.

Comments (7)

  3. Ghislain Hachey reporter

    Here is all the ISCED-F 2013 data as SQL INSERT statements. It can be loaded to any adopting Pacific EMIS country and should probably be in the DB as default. Linking with lkpSubject (the “localized” subjects) would still require a manual adjustment.

    BEGIN TRANSACTION;

INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('00','Generic programmes and qualifications');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('01','Education');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('02','Arts and humanities');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('03','Social sciences, journalism and information');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('04','Business, administration and law');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('05','Natural sciences, mathematics and statistics');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('06','Information and Communication Technologies (ICTs)');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('07','Engineering, manufacturing and construction');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('08','Agriculture, forestry, fisheries and veterinary');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('09','Health and welfare');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('10','Services');
INSERT INTO ISCEDFieldGroupBroad (ifgbID,ifgbName) VALUES ('99','Field unknown');

INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('000','Generic programmes and qualifications not further defined','00');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('001','Basic programmes and qualifications','00');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('002','Literacy and numeracy','00');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('003','Personal skills and development','00');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('009','Generic programmes and qualifications not elsewhere classified','00');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('011','Education','01');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('018','Inter-disciplinary programmes and qualifications involving education','01');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('020','Arts and humanities not further defined','02');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('021','Arts','02');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('022','Humanities (except languages)','02');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('023','Languages','02');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('028','Inter-disciplinary programmes and qualifications involving arts and humanities','02');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('029','Arts and humanities not elsewhere classified','02');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('030','Social sciences, journalism and information not further defined','03');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('031','Social and behavioural sciences','03');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('032','Journalism and information','03');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('038','Inter-disciplinary programmes and qualifications involving social sciences, journalism and information','03');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('039','Social sciences, journalism and information not elsewhere classified','03');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('040','Business, administration and law not further defined','04');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('041','Business and administration','04');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('042','Law','04');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('048','Inter-disciplinary programmes and qualifications involving business, administration and law','04');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('049','Business, administration and law not elsewhere classified','04');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('050','Natural sciences, mathematics and statistics not further defined','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('051','Biological and related sciences','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('052','Environment','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('053','Physical sciences','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('054','Mathematics and statistics','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('058','Inter-disciplinary programmes and qualifications involving natural sciences, mathematics and statistics','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('059','Natural sciences, mathematics and statistics not elsewhere classified','05');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('061','Information and Communication Technologies (ICTs)','06');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('068','Inter-disciplinary programmes and qualifications involving Information and Communication Technologies (ICTs)','06');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('070','Engineering, manufacturing and construction not further defined','07');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('071','Engineering and engineering trades','07');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('072','Manufacturing and processing','07');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('073','Architecture and construction','07');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('078','Inter-disciplinary programmes and qualifications involving engineering, manufacturing and construction','07');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('079','Engineering, manufacturing and construction not elsewhere classified','07');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('080','Agriculture, forestry, fisheries and veterinary not further defined','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('081','Agriculture','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('082','Forestry','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('083','Fisheries','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('084','Veterinary','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('088','Inter-disciplinary programmes and qualifications involving  agriculture, forestry, fisheries and veterinary','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('089','Agriculture, forestry, fisheries and veterinary not elsewhere classified','08');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('090','Health and welfare not further defined','09');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('091','Health','09');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('092','Welfare','09');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('098','Inter-disciplinary programmes and qualifications involving health and welfare','09');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('099','Health and welfare not elsewhere classified','09');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('100','Services not further defined','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('101','Personal services','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('102','Hygiene and occupational health services','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('103','Security services','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('104','Transport services','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('108','Inter-disciplinary programmes and qualifications involving services','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('109','Services not elsewhere classified','10');
INSERT INTO ISCEDFieldGroup (ifgID,ifgName,ifgbID) VALUES ('999','Field unknown','99');

INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0000','Generic programmes and qualifications not further defined','000');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0011','Basic programmes and qualifications','001');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0021','Literacy and numeracy ','002');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0031','Personal skills and development','003');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0099','Generic programmes and qualifications not elsewhere classified','009');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0110','Education not further defined','011');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0111','Education science','011');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0112','Training for pre-school teachers','011');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0113','Teacher training  without subject specialisation','011');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0114','Teacher training with subject specialisation','011');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0119','Education not elsewhere classified','011');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0188','Inter-disciplinary programmes and qualifications involving education','018');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0200','Arts and humanities not further defined','020');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0210','Arts not further defined','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0211','Audio-visual techniques and media production','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0212','Fashion, interior and industrial design','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0213','Fine arts','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0214','Handicrafts','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0215','Music and performing arts','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0219','Arts not elsewhere classified','021');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0220','Humanities (except languages) not further defined','022');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0221','Religion and theology','022');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0222','History and archaeology','022');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0223','Philosophy and ethics','022');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0229','Humanities (except languages) not elsewhere classified','022');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0230','Languages not further defined','023');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0231','Language acquisition','023');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0232','Literature and linguistics','023');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0239','Languages not elsewhere classified','023');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0288','Inter-disciplinary programmes and qualifications involving arts and humanities','028');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0299','Arts and humanities not elsewhere classified','029');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0300','Social sciences, journalism and information not further defined','030');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0310','Social and behavioural sciences not further defined','031');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0311','Economics','031');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0312','Political sciences and civics','031');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0313','Psychology','031');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0314','Sociology and cultural studies','031');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0319','Social and behavioural sciences not elsewhere classified','031');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0320','Journalism and information not further defined','032');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0321','Journalism and reporting','032');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0322','Library, information and archival studies','032');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0329','Journalism and information not elsewhere classified','032');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0388','Inter-disciplinary programmes and qualifications involving social sciences, journalism and information','038');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0399','Social sciences, journalism and information not elsewhere classified','039');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0400','Business, administration and law not further defined','040');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0410','Business and administration not further defined','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0411','Accounting and taxation','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0412','Finance, banking and insurance','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0413','Management and administration','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0414','Marketing and advertising','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0415','Secretarial and office work','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0416','Wholesale and retail sales','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0417','Work skills','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0419','Business and administration not elsewhere classified','041');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0421','Law','042');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0488','Inter-disciplinary programmes and qualifications involving business, administration and law','048');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0499','Business, administration and law not elsewhere classified','049');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0500','Natural sciences, mathematics and statistics not further defined','050');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0510','Biological and related sciences not further defined','051');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0511','Biology','051');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0512','Biochemistry','051');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0519','Biological and related sciences not elsewhere classified','051');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0520','Environment not further defined','052');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0521','Environmental sciences','052');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0522','Natural environments and wildlife','052');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0529','Environment not elsewhere classified','052');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0530','Physical sciences not further defined','053');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0531','Chemistry','053');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0532','Earth sciences','053');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0533','Physics','053');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0539','Physical sciences not elsewhere classified','053');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0540','Mathematics and statistics not further defined','054');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0541','Mathematics','054');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0542','Statistics','054');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0588','Inter-disciplinary programmes and qualifications involving natural sciences, mathematics and statistics','058');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0599','Natural sciences, mathematics and statistics not elsewhere classified','059');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0610','Information and Communication Technologies (ICTs) not further defined','061');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0611','Computer use','061');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0612','Database and network design and administration','061');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0613','Software and applications development and analysis','061');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0619','Information and Communication Technologies (ICTs) not elsewhere classified','061');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0688','Inter-disciplinary programmes and qualifications involving Information and Communication Technologies (ICTs)','068');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0700','Engineering, manufacturing and construction not further defined','070');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0710','Engineering and engineering trades not further defined','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0711','Chemical engineering and processes','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0712','Environmental protection technology','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0713','Electricity and energy','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0714','Electronics and automation','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0715','Mechanics and metal trades','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0716','Motor vehicles, ships and aircraft','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0719','Engineering and engineering trades not elsewhere classified','071');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0720','Manufacturing and processing not further defined','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0721','Food processing ','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0722','Materials (glass, paper, plastic and wood)','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0723','Textiles (clothes, footwear and leather)','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0724','Mining and extraction','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0729','Manufacturing and processing not elsewhere classified','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0730','Architecture and construction not further defined','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0731','Architecture and town planning','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0732','Building and civil engineering','072');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0788','Inter-disciplinary programmes and qualifications involving engineering, manufacturing and construction','078');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0799','Engineering, manufacturing and construction not elsewhere classified','079');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0800','Agriculture, forestry, fisheries and veterinary not further defined','080');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0810','Agriculture not further defined','081');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0811','Crop and livestock production','081');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0812','Horticulture','081');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0819','Agriculture not elsewhere classified','081');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0821','Forestry','082');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0831','Fisheries','083');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0841','Veterinary','084');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0888','Inter-disciplinary programmes and qualifications involving  agriculture, forestry, fisheries and veterinary','088');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0899','Agriculture, forestry, fisheries and veterinary not elsewhere classifie','089');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0900','Health and welfare not further defined ','090');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0910','Health not further defined','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0911','Dental studies','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0912','Medicine','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0913','Nursing and midwifery','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0914','Medical diagnostic and treatment technology','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0915','Therapy and rehabilitation','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0916','Pharmacy','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0917','Traditional and complementary medicine and therapy','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0919','Health not elsewhere classified','091');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0920','Welfare not further defined','092');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0921','Care of the elderly and of disabled adults','092');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0922','Child care and youth services','092');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0923','Social work and counselling','092');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0929','Welfare not elsewhere classified','092');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0988','Inter-disciplinary programmes and qualifications involving health and welfare','098');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('0999','Health and welfare not elsewhere classified','099');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1000','Services not further defined','100');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1010','Personal services not further defined','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1011','Domestic services','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1012','Hair and beauty services','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1013','Hotel, restaurants and catering','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1014','Sports','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1015','Travel, tourism and leisure','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1019','Personal services not elsewhere classified','101');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1020','Hygiene and occupational health services not further defined','102');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1021','Community sanitation','102');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1022','Occupational health and safety','102');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1029','Hygiene and occupational health services not elsewhere classified','102');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1030','Security services not further defined','103');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1031','Military and defence','103');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1032','Protection of persons and property','103');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1039','Security services not elsewhere classified','103');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1041','Transport services','104');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1088','Inter-disciplinary programmes and qualifications involving services','108');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('1099','Services not elsewhere classified','109');
INSERT INTO ISCEDField (ifID,ifName,ifgID) VALUES ('9999','Field unknown','999');

ROLLBACK;

    ‌

  8. Log in to comment
Assignee
Type
task
Priority
major
Status
resolved
Votes
0
Watchers
1
Jira: the preferred issue tracker for Bitbucket. Join the team!