Disciplines (Note stat. 2)

Dans Analytics les Notes statistiques sont stockées sous forme de code. La colonne suivante permet d’ajouter les libellés aux codes.

    CASE
        WHEN "Physical Item Details"."Statistics Note 2" = 'A00' THEN 'A00 : Mathématiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'AA0' THEN 'AA0 : Mathématiques appliquées'
        WHEN "Physical Item Details"."Statistics Note 2" = 'AAA' THEN 'AAA : Mathématiques appliquées aux sciences sociales'
        WHEN "Physical Item Details"."Statistics Note 2" = 'B00' THEN 'B00 : Physique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'BA0' THEN 'BA0 : Milieu dense et matériaux'
        WHEN "Physical Item Details"."Statistics Note 2" = 'BB0' THEN 'BB0 : Constituants élémentaires'
        WHEN "Physical Item Details"."Statistics Note 2" = 'BC0' THEN 'BC0 : Milieux diluées et optiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'C00' THEN 'C00 : Chimie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'CA0' THEN 'CA0 : Chimie théorique, physique, analytique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'CB0' THEN 'CB0 : Chimie organique, minérale, industrielle'
        WHEN "Physical Item Details"."Statistics Note 2" = 'CC0' THEN 'CC0 : Chimie des matériaux'
        WHEN "Physical Item Details"."Statistics Note 2" = 'CD0' THEN 'CD0 : Génie chimique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'D00' THEN 'D00 : Sciences de la terre et de l''univers'
        WHEN "Physical Item Details"."Statistics Note 2" = 'DA0' THEN 'DA0 : Astronomie, Astrophysique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'DB0' THEN 'DB0 : Sciences de la terre'
        WHEN "Physical Item Details"."Statistics Note 2" = 'DBA' THEN 'DBA : Terre solide : géodynamique des enveloppes supérieures, paléobiosphère'
        WHEN "Physical Item Details"."Statistics Note 2" = 'DBB' THEN 'DBB : Météorologie, océanographie physique de l''environnement'
        WHEN "Physical Item Details"."Statistics Note 2" = 'E00' THEN 'E00 : Sciences de la vie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EA0' THEN 'EA0 : Biologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EAA' THEN 'EAA : Biochimie et biologie moléculaire'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EAB' THEN 'EAB : Biologie cellulaire'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EAC' THEN 'EAC : Biologie des populations et écologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EAD' THEN 'EAD : Biologie des organismes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EB0' THEN 'EB0 : Physiologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EC0' THEN 'EC0 : Neurosciences'
        WHEN "Physical Item Details"."Statistics Note 2" = 'ED0' THEN 'ED0 : Zoologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'EF0' THEN 'EF0 : Botanique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'F00' THEN 'F00 : Sciences de la santé'
        WHEN "Physical Item Details"."Statistics Note 2" = 'FA0' THEN 'FA0 : Médecine'
        WHEN "Physical Item Details"."Statistics Note 2" = 'FAA' THEN 'FAA : Sciences précliniques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'FAB' THEN 'FAB : Médecine et spécialités'
        WHEN "Physical Item Details"."Statistics Note 2" = 'FB0' THEN 'FB0 : Pharmacie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'FC0' THEN 'FC0 : Odontologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'G00' THEN 'G00 : STAPS'
        WHEN "Physical Item Details"."Statistics Note 2" = 'H00' THEN 'H00 : Sciences de l''ingénieur'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HA0' THEN 'HA0 : Mécanique, génie mécanique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HB0' THEN 'HB0 : Génie civil'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HC0' THEN 'HC0 : Génie des procédés'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HD0' THEN 'HD0 : Electronique, génie électrique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HDA' THEN 'HDA : Electronique analogique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HDB' THEN 'HDB : Electronique numérique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HE0' THEN 'HE0 : Sciences et technologies industrielles'
        WHEN "Physical Item Details"."Statistics Note 2" = 'HF0' THEN 'HF0 : Ergonomie et cognitique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'I00' THEN 'I00 : Informatique et génie informatique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'IA0' THEN 'IA0 : Informatique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'IB0' THEN 'IB0 : Génie informatique, automatique et traitement du signal'
        WHEN "Physical Item Details"."Statistics Note 2" = 'J00' THEN 'J00 : Langues et littératures'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JA0' THEN 'JA0 : Sciences du langage : linguistique et phonétique générales'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JB0' THEN 'JB0 : Langues et littératures anciennes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JBA' THEN 'JBA : Langues et littératures grecques et latines'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JBB' THEN 'JBB : Langues et littératures médiévale'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JC0' THEN 'JC0 : Littératures générales et comparées'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JD0' THEN 'JD0 : Langue et littérature françaises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JDA' THEN 'JDA : Français langue étrangère'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JDB' THEN 'JDB : Littérature francophone'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JDC' THEN 'JDC : Littérature française'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JDE' THEN 'JDE : Grammaire et linguistique française'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JE0' THEN 'JE0 : Langues et littératures anglaises et anglo-saxonnes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JEA' THEN 'JEA : Langue anglaise'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JEB' THEN 'JEB : Civilisations anglo-saxonnes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JF0' THEN 'JF0 : Langues et littératures germaniques et scandinaves'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JFA' THEN 'JFA : Langues et littératures allemandes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JFB' THEN 'JFB : Langue et littérature suédoises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JG0' THEN 'JG0 : Langues et littératures slaves'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JGA' THEN 'JGA : Langue et littérature russes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JGB' THEN 'JGB : Langues et littérature polonaises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JGC' THEN 'JGC : Langues et littératures slovaques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JGD' THEN 'JGD : Langues et littératures serbo-croates'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JGE' THEN 'JGE : Langues et littératures tchèques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JH0' THEN 'JH0 : Langues et littératures romanes : espagnol, italien, portugais, autres langues romanes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHA' THEN 'JHA : Langues et littératures espagnoles'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHB' THEN 'JHB : Langues et littératures américaines hispanophones'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHC' THEN 'JHC : Autres langues et littératures hispanophones'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHD' THEN 'JHD : Langues et littératures italiennes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHE' THEN 'JHE : Langues et littératures portugaises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHF' THEN 'JHF : Langues et littératures américaines lusophones'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHG' THEN 'JHG : Langues et littératures africaines lusophones'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHH' THEN 'JHH : Autres langues et littératures lusophones'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JHI' THEN 'JHI : Civilisations hispanophones et lusophones'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JII' THEN 'JII : Langue persane'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JI0' THEN 'JI0 : Langues et littératures arabes, chinoises, japonaises, hébraique, d''autres domaines linguistiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIA' THEN 'JIA : Langue et littérature arabes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIB' THEN 'JIB : Langue et littérature chinoises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIC' THEN 'JIC : Langue et littérature japonaises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JID' THEN 'JID : Langue et littérature hongroises'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIE' THEN 'JIE : Langue et littérature coréennes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIF' THEN 'JIF : Langue et littérature hébraïques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIG' THEN 'JIG : Langue et littérature helléniques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JIH' THEN 'JIH : Civilisation asiatique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JJ0' THEN 'JJ0 : Cultures et langues régionales'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JJA' THEN 'JJA : Culture et langue occitanes'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JK0' THEN 'JK0 : Littérature et écrits pour la jeunesse'
        WHEN "Physical Item Details"."Statistics Note 2" = 'JLO' THEN 'JL0 : LEA - matières d''application'
        WHEN "Physical Item Details"."Statistics Note 2" = 'K00' THEN 'K00 : Arts'
        WHEN "Physical Item Details"."Statistics Note 2" = 'KA0' THEN 'KA0 : Arts plastiques et arts appliqués'
        WHEN "Physical Item Details"."Statistics Note 2" = 'KB0' THEN 'KB0 : Arts du spectacle'
        WHEN "Physical Item Details"."Statistics Note 2" = 'KBA' THEN 'KBA : Cinéma'
        WHEN "Physical Item Details"."Statistics Note 2" = 'KBB' THEN 'KBB : Théatre-danse'
        WHEN "Physical Item Details"."Statistics Note 2" = 'KC0' THEN 'KC0 : Musiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'L00' THEN 'L00 : Philosophie et épistemologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'LA0' THEN 'LA0 : Epistémologie, histoire des sciences et des techniques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'LB0' THEN 'LB0 : Philosophie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'LBA' THEN 'LBA : Sciences religieuses'
        WHEN "Physical Item Details"."Statistics Note 2" = 'M00' THEN 'M00 : Histoire'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MA0' THEN 'MA0 : Histoire, civilisations, archéologie et art des mondes anciens et médiévaux'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MAA' THEN 'MAA : Histoire antique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MAB' THEN 'MAB : Histoire médiévale'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MB0' THEN 'MB0 : Histoire et civilisations : histoire des mondes modernes, histoire du monde contemporain ; de l''art ; de la musique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MBA' THEN 'MBA : Histoire moderne'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MBB' THEN 'MBB : Histoire contemporaine'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MC0' THEN 'MC0 : Histoire de l''art et sciences archéologiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MCA' THEN 'MCA : Histoire de l''art'
        WHEN "Physical Item Details"."Statistics Note 2" = 'MCB' THEN 'MCB : Sciences archéologiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'N00' THEN 'N00 : Géographie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'NA0' THEN 'NA0 : Géographie physique, humaine, économique et régionale'
        WHEN "Physical Item Details"."Statistics Note 2" = 'NB0' THEN 'NB0 : Aménagement de l''espace, urbanisme'
        WHEN "Physical Item Details"."Statistics Note 2" = 'NC0' THEN 'NC0 : Environnement'
        WHEN "Physical Item Details"."Statistics Note 2" = 'O00' THEN 'O00 : Sciences agricoles'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OA0' THEN 'OA0 : Productions végétales'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OAA' THEN 'OAA : Agronomie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OAB' THEN 'OAB : Sols'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OAC' THEN 'OAC : Cultures'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OB0' THEN 'OB0 : Productions animales'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OBA' THEN 'OBA : Zootechnie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OBB' THEN 'OBB : Elevage'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OC0' THEN 'OC0 : Forêt et filière bois'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OD0' THEN 'OD0 : Vigne et vin'
        WHEN "Physical Item Details"."Statistics Note 2" = 'ODA' THEN 'ODA : Œnologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'ODB' THEN 'ODB : Viticulture'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OE0' THEN 'OE0 : Agriculture, économie et politique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OEA' THEN 'OEA : Agriculture'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OEB' THEN 'OEB : Economie et politique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'OF0' THEN 'OF0 : Agroalimentaire'
        WHEN "Physical Item Details"."Statistics Note 2" = 'P00' THEN 'P00 : Archéologie, ethnologie, préhistoire, anthropologie biologique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'R00' THEN 'R00 : Psychologie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'S00' THEN 'S00 : Sociologie, démographie'
        WHEN "Physical Item Details"."Statistics Note 2" = 'SA0' THEN 'SA0 : Sociologie - anthropologie sociale'
        WHEN "Physical Item Details"."Statistics Note 2" = 'SAB' THEN 'SAB : Psychologie sociale'
        WHEN "Physical Item Details"."Statistics Note 2" = 'T00' THEN 'T00 : Sciences de l''éducation'
        WHEN "Physical Item Details"."Statistics Note 2" = 'U00' THEN 'U00 : Sciences de l''information et de la communication'
        WHEN "Physical Item Details"."Statistics Note 2" = 'V00' THEN 'V00 : Sciences juridiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VA0' THEN 'VA0 : Droit privé et sciences criminelles'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VAA' THEN 'VAA : Droit civil, obligations, biens, commercial'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VAB' THEN 'VAB : Droit pénal, criminologie, science pénitentiaire'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VAC' THEN 'VAC : Procédure civile et métiers du droit'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VB0' THEN 'VB0 : Droit public'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VBA' THEN 'VBA : Droits constitutionnel et administratif'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VBB' THEN 'VBB : Droit fiscal, finances publiques, économique…'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VBC' THEN 'VBC : Droit social, santé, environnement…'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VBD' THEN 'VBD : Administration'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VC0' THEN 'VC0 : Histoire du droit et des institutions'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VD0' THEN 'VD0 : Droit international et européen'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VDA' THEN 'VDA : Droit international'
        WHEN "Physical Item Details"."Statistics Note 2" = 'VDB' THEN 'VDB : Droit européen'
        WHEN "Physical Item Details"."Statistics Note 2" = 'W00' THEN 'W00 : Sciences politiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'X00' THEN 'X00 : Sciences économiques'
        WHEN "Physical Item Details"."Statistics Note 2" = 'XA0' THEN 'XA0 : Théorie et histoire économique'
        WHEN "Physical Item Details"."Statistics Note 2" = 'XB0' THEN 'XB0 : Economie financière'
        WHEN "Physical Item Details"."Statistics Note 2" = 'XC0' THEN 'XC0 : Economie appliquée'
        WHEN "Physical Item Details"."Statistics Note 2" = 'Y00' THEN 'Y00 : Gestion'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YA0' THEN 'YA0 : Ressources humaines'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YB0' THEN 'YB0 : Marketing'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YC0' THEN 'YC0 : Comptabilité'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YD0' THEN 'YD0 : Gestion de production'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YE0' THEN 'YE0 : Management'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YF0' THEN 'YF0 : Finances'
        WHEN "Physical Item Details"."Statistics Note 2" = 'YG0' THEN 'YG0 : Communication'
        WHEN "Physical Item Details"."Statistics Note 2" = 'Z00' THEN 'Z00 : Vétérinaire'
        WHEN "Physical Item Details"."Statistics Note 2" = '###' THEN '### : Aucun code de discipline attribué'
        ELSE 'AUTRE'
    END