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
Note : 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
Note : 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
Date de publication
Mis à jour le
Attention ! Certains établissements utilisent parfois de procédures complémentaires