Colonnes enregistrées

Dernière mise à jour de la documentation : 01/09/2020

Mise en ligne sur le blog : 20/05/2021

Regroupements de localisations IEP et BxSA

Emplacement : Alma>Community>Reports>Institutions>33PUDB>Colonnes>Regroupement de localisations IEP & BXSA (“Fulfillment”.“Item Location at time of loan”.“Location Code”)

Formule :

CASE WHEN "Item Location at time of loan"."Library Code" = '4000100000' THEN
    CASE WHEN "Item Location at time of loan"."Location Code" IN ('4000101020','4000101019','4000101022','4000101021','4000101026','4000100001','4000101007','4000101013','4000101025','4000101001','4000101002','4000101011','4000101009') THEN 'Bib. Générale'
    WHEN "Item Location at time of loan"."Location Code" IN ('4000101018','4000101016','4000101017','4000103005','4000101024') THEN 'Bib. Recherche LAM'
    WHEN "Item Location at time of loan"."Location Code" IN ('4000101015','4000101014','4000102006','4000101023') THEN 'Bib. Recherche CED'
    ELSE 'Autres' END
WHEN "Item Location at time of loan"."Library Code" = '1103500000' THEN
        CASE WHEN "Item Location at time of loan"."Location Code"  IN ('l103502002','1103502001') THEN 'Centre de recherche en économie - LAREFI' 
        ELSE 'Centre de recherche en économie - GRETHA' END
WHEN "Item Location at time of loan"."Library Code" = '1103400000' THEN
        CASE WHEN "Item Location at time of loan"."Location Code"  IN ('1103404001') THEN 'Centre de recherche en droit - ILD'
        WHEN "Item Location at time of loan"."Location Code" IN ('1103405001') THEN 'Centre de recherche en droit - CMRP'  
        ELSE 'Centre de recherche en droit - COMPTRASSEC' END
WHEN "Item Location at time of loan"."Library Code" = '5000100000' THEN
    CASE WHEN "Item Location at time of loan"."Location Code" IN ('5000100042','5000100043','5000100044','5000100045','5000100046','5000100069','5000100068','5000100071','5000100077','5000100086','5000100098','5000100099','5000100109','5000100111','5000100308','5000100309','5000100310','5000100311','5000100312','5000100313','5000100314','5000100315','5000100316','5000100317','5000100318','5000100319','5000100326','5000100327','5000100328','5000100329','5000100330','5000100332','5000100333','5000100334','5000100335','5000100336','5000100337','5000100338','5000100339','5000100340','5000100341','5000100342') THEN 'Sciences du vivant'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100047','5000100049','5000100065','5000100080','5000100083','5000100105','5000100206','5000100208','5000100209','5000100207','5000100210','5000100211','5000100213','5000100212','5000100320','5000100321','5000100322','5000100323','5000100324','5000100325','5000100331','5000100343','5000100344','5000100345') THEN 'Sciences de l''ingénieur' 
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100002','5000100003','5000100005','5000100004','5000100006','5000100037') THEN 'Accompagnement de l''étudiant'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100007','5000100008') THEN 'Accueil'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100009','5000100010','5000100011','5000100012','5000100013','5000100015','5000100014','5000100038','5000100082','5000100097','5000100115') THEN 'Agriculture' 
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100016','5000100017','5000100018','5000100019','5000100021','5000100022','5000100020','5000100023','5000100024','5000100025','5000100026','5000100028','5000100027','5000100029','5000100030','5000100031','5000100032','5000100033','5000100034','5000100035','5000100036','5000100039','5000100104') THEN 'Agroalimentaire'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100089','5000100090') THEN 'Bureaux'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100048','5000100364','5000100091','5000100092','5000100093','5000100096','5000100094','5000100095') THEN 'Collections'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100051','5000100112','5000100113','5000100114') THEN 'Documentation régionale'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100052','5000100054','5000100055','5000100056','5000100057','5000100058','5000100100','5000100101','5000100116','5000100117','5000100118','5000100119','5000100120','5000100121','5000100122','5000100123','5000100125','5000100126','5000100138','5000100139','5000100141','5000100142','5000100143','5000100140','5000100144','5000100145','5000100146','5000100148','5000100147','5000100149','5000100150','5000100151','5000100152','5000100153','5000100154','5000100156','5000100155','5000100157','5000100158','5000100159','5000100160','5000100161','5000100162','5000100163','5000100164','5000100165','5000100166','5000100167','5000100168','5000100169','5000100171','5000100170','5000100172','5000100173','5000100174','5000100175','5000100176','5000100177','5000100178','5000100179','5000100180','5000100181','5000100182','5000100081') THEN 'Economie - Droit'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100053','5000100127','5000100128','5000100129','5000100130','5000100131','5000100132','5000100133','5000100134','5000100135','5000100136','5000100137') THEN 'Economie agricole'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100062','5000100102','5000100124','5000100183','5000100184','5000100185','5000100186','5000100187','5000100188','5000100189','5000100190','5000100191','5000100192','5000100193','5000100194','5000100195') THEN 'Environnement'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100063','5000100103','5000100196','5000100197','5000100198','5000100199','5000100200','5000100201','5000100202','5000100203','5000100204','5000100205') THEN 'Forêts'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100066','5000100214','5000100215','5000100216','5000100217','5000100218','5000100219','5000100220','5000100221','5000100222','5000100223','5000100231','5000100224','5000100225','5000100226','5000100227','5000100228','5000100229','5000100230') THEN 'Langues vivantes'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100232') THEN 'Livres enseignants'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100076','5000100088','5000100307') THEN 'Loisirs'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100067','5000100233') THEN 'Mémoires'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100234','5000100235','5000100236','5000100237','5000100238','5000100239','5000100240','5000100241') THEN 'Numérique - Agriculture'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100070','5000100078','5000100106','5000100242','5000100243','5000100244','5000100245','5000100246') THEN 'Nutrition -Santé' 
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100059','5000100073','5000100087','5000100107','5000100249','5000100250','5000100251','5000100252','5000100253','5000100254','5000100255','5000100256','5000100258','5000100257','5000100259','5000100260','5000100261','5000100262','5000100263','5000100265','5000100266','5000100264','5000100267','5000100268','5000100269','5000100270') THEN 'Production animale'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100040','5000100072','5000100074','5000100108','5000100272','5000100271','5000100273','5000100274','5000100275','5000100277','5000100276','5000100279','5000100280','5000100281','5000100278','5000100282','5000100283','5000100284','5000100285','5000100286','5000100289','5000100287','5000100288','5000100290','5000100291','5000100292','5000100293','5000100295','5000100296','5000100297','5000100298','5000100299','5000100300','5000100294','5000100301','5000100302','5000100303','5000100304','5000100305') THEN 'Production Végétale'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100075','5000100306') THEN 'Revues'
    WHEN "Item Location at time of loan"."Location Code" IN ('5000100085','5000100110','5000100346','5000100347','5000100348','5000100349','5000100350','5000100351','5000100352','5000100353','5000100354','5000100355','5000100356','5000100357','5000100358','5000100359','5000100360','5000100361','5000100362') THEN 'Vigne et Vin'
    ELSE 'Autres' END
ELSE "Item Location at time of loan"."Library Name" END
Code copié le 2 mars 2020 avant modification
CASE      WHEN "Item Location at time of loan"."Library Code" = '4000100000'         THEN             CASE                 WHEN "Item Location at time of loan"."Location Code"                      IN ('4000101020','4000101019','4000101022','4000101021','4000101026','4000100001','4000101007','4000101013','4000101025','4000101001','4000101002','4000101011','4000101009') THEN 'Bib. Générale'                  WHEN "Item Location at time of loan"."Location Code"                      IN ('4000101018','4000101016','4000101017','4000103005','4000101024') THEN 'Bib. Recherche LAM'                  WHEN "Item Location at time of loan"."Location Code"                      IN ('4000101015','4000101014','4000102006','4000101023') THEN 'Bib. Recherche CED'                    ELSE 'Autres' END     WHEN "Item Location at time of loan"."Library Code" = '5000100000' THEN             CASE                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100042','5000100043','5000100044','5000100045','5000100046','5000100069','5000100068','5000100071','5000100077','5000100086','5000100098','5000100099','5000100109','5000100111','5000100308','5000100309','5000100310','5000100311','5000100312','5000100313','5000100314','5000100315','5000100316','5000100317','5000100318','5000100319','5000100326','5000100327','5000100328','5000100329','5000100330','5000100332','5000100333','5000100334','5000100335','5000100336','5000100337','5000100338','5000100339','5000100340','5000100341','5000100342') THEN 'Sciences du vivant'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100047','5000100049','5000100065','5000100080','5000100083','5000100105','5000100206','5000100208','5000100209','5000100207','5000100210','5000100211','5000100213','5000100212','5000100320','5000100321','5000100322','5000100323','5000100324','5000100325','5000100331','5000100343','5000100344','5000100345') THEN 'Sciences de l''ingénieur'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100002','5000100003','5000100005','5000100004','5000100006') THEN 'Accompagnement de l''étudiant'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100007','5000100008') THEN 'Accueil'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100009','5000100010','5000100011','5000100012','5000100013','5000100015','5000100014','5000100038','5000100082','5000100097','5000100115') THEN 'Agriculture'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100016','5000100017','5000100018','5000100019','5000100021','5000100022','5000100020','5000100023','5000100024','5000100025','5000100026','5000100028','5000100027','5000100029','5000100030','5000100031','5000100032','5000100033','5000100034','5000100035','5000100036','5000100039','5000100104') THEN 'Agroalimentaire'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100089','5000100090') THEN 'Bureaux'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100048','5000100364','5000100091','5000100092','5000100093','5000100096','5000100094','5000100095') THEN 'Collections'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100051','5000100112','5000100113','5000100114') THEN 'Documentation régionale'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100052','5000100054','5000100055','5000100056','5000100057','5000100058','5000100100','5000100101','5000100116','5000100117','5000100118','5000100119','5000100120','5000100121','5000100122','5000100123','5000100125','5000100126','5000100138','5000100139','5000100141','5000100142','5000100143','5000100140','5000100144','5000100145','5000100146','5000100148','5000100147','5000100149','5000100150','5000100151','5000100152','5000100153','5000100154','5000100156','5000100155','5000100157','5000100158','5000100159','5000100160','5000100161','5000100162','5000100163','5000100164','5000100165','5000100166','5000100167','5000100168','5000100169','5000100171','5000100170','5000100172','5000100173','5000100174','5000100175','5000100176','5000100177','5000100178','5000100179','5000100180','5000100181','5000100182') THEN 'Economie - Droit'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100053','5000100127','5000100128','5000100129','5000100130','5000100131','5000100132','5000100133','5000100134','5000100135','5000100136','5000100137') THEN 'Economie agricole'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100062','5000100102','5000100124','5000100183','5000100184','5000100185','5000100186','5000100187','5000100188','5000100189','5000100190','5000100191','5000100192','5000100193','5000100194','5000100195') THEN 'Environnement'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100063','5000100103','5000100196','5000100197','5000100198','5000100199','5000100200','5000100201','5000100202','5000100203','5000100204','5000100205') THEN 'Forêts'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100066','5000100214','5000100215','5000100216','5000100217','5000100218','5000100219','5000100220','5000100221','5000100222','5000100223','5000100231','5000100224','5000100225','5000100226','5000100227','5000100228','5000100229','5000100230') THEN 'Langues vivantes'                 WHEN "Item Location at time of loan"."Location Code" in ('5000100232') THEN 'Livres enseignants'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100076','5000100088','5000100307') THEN 'Loisirs'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100067','5000100233') THEN 'Mémoires'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100234','5000100235','5000100236','5000100237','5000100238','5000100239','5000100240','5000100241') THEN 'Numérique - Agriculture'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100070','5000100078','5000100106','5000100242','5000100243','5000100244','5000100245','5000100246') THEN 'Nutrition -Santé'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100059','5000100073','5000100087','5000100107','5000100249','5000100250','5000100251','5000100252','5000100253','5000100254','5000100255','5000100256','5000100258','5000100257','5000100259','5000100260','5000100261','5000100262','5000100263','5000100265','5000100266','5000100264','5000100267','5000100268','5000100269','5000100270') THEN 'Production animale'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100040','5000100072','5000100074','5000100108','5000100272','5000100271','5000100273','5000100274','5000100275','5000100277','5000100276','5000100279','5000100280','5000100281','5000100278','5000100282','5000100283','5000100284','5000100285','5000100286','5000100289','5000100287','5000100288','5000100290','5000100291','5000100292','5000100293','5000100295','5000100296','5000100297','5000100298','5000100299','5000100300','5000100294','5000100301','5000100302','5000100303','5000100304','5000100305') THEN 'Production Végétale'                 WHEN "Item Location at time of loan"."Location Code"                     IN ('5000100075','5000100306') THEN 'Revues'                 ELSE 'Autres'             END     ELSE "Item Location at time of loan"."Library Name" END
Version utilisée dans les filtres de rapport
CASE 
    WHEN "Item Location at time of loan"."Library Code" = '4000100000'
        THEN
            CASE
                WHEN "Item Location at time of loan"."Location Code" 
                    IN ('4000101020','4000101019','4000101022','4000101021','4000101026','4000100001','4000101007','4000101013','4000101025','4000101001','4000101002','4000101011','4000101009') THEN 'Bib. Générale' 
                WHEN "Item Location at time of loan"."Location Code" 
                    IN ('4000101018','4000101016','4000101017','4000103005','4000101024') THEN 'Bib. Recherche LAM' 
                WHEN "Item Location at time of loan"."Location Code" 
                    IN ('4000101015','4000101014','4000102006','4000101023') THEN 'Bib. Recherche CED'   
                ELSE 'Autres' END
    WHEN "Item Location at time of loan"."Library Code" = '1103500000'
        THEN
            CASE
                WHEN "Item Location at time of loan"."Location Code" 
                    IN ('l103502002','1103502001') THEN 'Centre de recherche en économie - LAREFI' 
                ELSE 'Centre de recherche en économie - GRETHA' END
    WHEN "Item Location at time of loan"."Library Code" = '1103400000'
        THEN
            CASE
                WHEN "Item Location at time of loan"."Location Code" 
                    IN ('1103404001') THEN 'Centre de recherche en droit - ILD'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('1103405001') THEN 'Centre de recherche en droit - CMRP'  
                ELSE 'Centre de recherche en droit - COMPTRASSEC' END
    WHEN "Item Location at time of loan"."Library Code" = '5000100000' THEN
            CASE
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100042','5000100043','5000100044','5000100045','5000100046','5000100069','5000100068','5000100071','5000100077','5000100086','5000100098','5000100099','5000100109','5000100111','5000100308','5000100309','5000100310','5000100311','5000100312','5000100313','5000100314','5000100315','5000100316','5000100317','5000100318','5000100319','5000100326','5000100327','5000100328','5000100329','5000100330','5000100332','5000100333','5000100334','5000100335','5000100336','5000100337','5000100338','5000100339','5000100340','5000100341','5000100342') THEN 'Sciences du vivant'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100047','5000100049','5000100065','5000100080','5000100083','5000100105','5000100206','5000100208','5000100209','5000100207','5000100210','5000100211','5000100213','5000100212','5000100320','5000100321','5000100322','5000100323','5000100324','5000100325','5000100331','5000100343','5000100344','5000100345') THEN 'Sciences de l ingénieur'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100002','5000100003','5000100005','5000100004','5000100006') THEN 'Accompagnement de l étudiant'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100007','5000100008') THEN 'Accueil'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100009','5000100010','5000100011','5000100012','5000100013','5000100015','5000100014','5000100038','5000100082','5000100097','5000100115') THEN 'Agriculture'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100016','5000100017','5000100018','5000100019','5000100021','5000100022','5000100020','5000100023','5000100024','5000100025','5000100026','5000100028','5000100027','5000100029','5000100030','5000100031','5000100032','5000100033','5000100034','5000100035','5000100036','5000100039','5000100104') THEN 'Agroalimentaire'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100089','5000100090') THEN 'Bureaux'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100048','5000100364','5000100091','5000100092','5000100093','5000100096','5000100094','5000100095') THEN 'Collections'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100051','5000100112','5000100113','5000100114') THEN 'Documentation régionale'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100052','5000100054','5000100055','5000100056','5000100057','5000100058','5000100100','5000100101','5000100116','5000100117','5000100118','5000100119','5000100120','5000100121','5000100122','5000100123','5000100125','5000100126','5000100138','5000100139','5000100141','5000100142','5000100143','5000100140','5000100144','5000100145','5000100146','5000100148','5000100147','5000100149','5000100150','5000100151','5000100152','5000100153','5000100154','5000100156','5000100155','5000100157','5000100158','5000100159','5000100160','5000100161','5000100162','5000100163','5000100164','5000100165','5000100166','5000100167','5000100168','5000100169','5000100171','5000100170','5000100172','5000100173','5000100174','5000100175','5000100176','5000100177','5000100178','5000100179','5000100180','5000100181','5000100182') THEN 'Economie - Droit'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100053','5000100127','5000100128','5000100129','5000100130','5000100131','5000100132','5000100133','5000100134','5000100135','5000100136','5000100137') THEN 'Economie agricole'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100062','5000100102','5000100124','5000100183','5000100184','5000100185','5000100186','5000100187','5000100188','5000100189','5000100190','5000100191','5000100192','5000100193','5000100194','5000100195') THEN 'Environnement'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100063','5000100103','5000100196','5000100197','5000100198','5000100199','5000100200','5000100201','5000100202','5000100203','5000100204','5000100205') THEN 'Forêts'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100066','5000100214','5000100215','5000100216','5000100217','5000100218','5000100219','5000100220','5000100221','5000100222','5000100223','5000100231','5000100224','5000100225','5000100226','5000100227','5000100228','5000100229','5000100230') THEN 'Langues vivantes'
                WHEN "Item Location at time of loan"."Location Code" in ('5000100232') THEN 'Livres enseignants'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100076','5000100088','5000100307') THEN 'Loisirs'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100067','5000100233') THEN 'Mémoires'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100234','5000100235','5000100236','5000100237','5000100238','5000100239','5000100240','5000100241') THEN 'Numérique - Agriculture'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100070','5000100078','5000100106','5000100242','5000100243','5000100244','5000100245','5000100246') THEN 'Nutrition -Santé'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100059','5000100073','5000100087','5000100107','5000100249','5000100250','5000100251','5000100252','5000100253','5000100254','5000100255','5000100256','5000100258','5000100257','5000100259','5000100260','5000100261','5000100262','5000100263','5000100265','5000100266','5000100264','5000100267','5000100268','5000100269','5000100270') THEN 'Production animale'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100040','5000100072','5000100074','5000100108','5000100272','5000100271','5000100273','5000100274','5000100275','5000100277','5000100276','5000100279','5000100280','5000100281','5000100278','5000100282','5000100283','5000100284','5000100285','5000100286','5000100289','5000100287','5000100288','5000100290','5000100291','5000100292','5000100293','5000100295','5000100296','5000100297','5000100298','5000100299','5000100300','5000100294','5000100301','5000100302','5000100303','5000100304','5000100305') THEN 'Production Végétale'
                WHEN "Item Location at time of loan"."Location Code"
                    IN ('5000100075','5000100306') THEN 'Revues'
                ELSE 'Autres'
            END
    ELSE "Item Location at time of loan"."Library Name"
END