The Morgan uses TMS alongside a library system (ILS), as such some of our
records exist in TMS and can be edited in TMS, and others are from the ILS
and can only be edited in the ILS. So for every curatorial department,
there are two departments in TMS, one for their objects and one for their
ILS objects (They have different rights for each department).

[image: image.png]

We use an Authority field on the ObjContext table called "Standardized
Department" that has the curatorial department names, and developed a
trigger that updates this value whenever the object's department is
changed. The Authority field does not appear on any data entry forms.

[image: image.png]

We replaced the Department field in Query Assistant with the ObjContext
Authority field; curators can search their entire collection without
worrying about where the records come from.


On Tue, Jun 25, 2019 at 12:23 PM BADIE MODIRI Elsa <
[log in to unmask]> wrote:

> Good afternoon everyone,
>
>
>
> Here is how we structured our collections for the moment (still a little
> bit of tidying up):
>
>
>
> Department
>
> Classification
>
> Autre collection
>
>
>
> Musée d'orsay
>
>
>
>
>
> architecture et arts décoratifs
>
>
>
> architecture et arts décoratifs-autre
>
>
>
> architecture et arts décoratifs-dessin
>
>
>
> architecture et arts décoratifs-objet
>
>
>
> arts graphiques
>
>
>
> autres oeœuvres-archives
>
>
>
> autres oeœuvres-objet et maquette
>
>
>
> autres oeœuvres-oeuvre diverse
>
>
>
> peintures et pastels-autre
>
>
>
> peintures et pastels-élément de décor & décor
>
>
>
> peintures et pastels-pastel
>
>
>
> peintures et pastels-tableau
>
>
>
> photographies-autres
>
>
>
> photographies-négatif
>
>
>
> photographies-positif
>
>
>
> photographies-procédé direct
>
>
>
> sculptures et médailles-autre
>
>
>
> sculptures et médailles-médaille
>
>
>
> sculptures et médailles-sculpture
>
> Musée de l'Orangerie
>
>
>
> Musée national Ernest Hébert
>
>
>
>
>
> This is not satisfactory because:
>
> -          it respects alphabetical order and doesn’t follow our
> traditional hierarchy of Classification
>
> -          has one level only for the Classification
>
> -          part of our staff would like to make the distinction between
> category in which the object falls (Photographies) and section who is in
> charge of the object (Archives) in the case for example of archives from a
> photograph’s studio at the time of the renovation of the building (see
> attached file). So two Classification could be necessary for some objects…
>
> -          We still have to figure out how to categorize and document
> works that are:
>
> o   in depot in our museums from other collections (not in jurisdiction,
> history and owner of the work and so on)
>
> o   destroyed and no longer on our inventory books but still interesting
> to consider from an historian point of view
>
>
>
> We would like to have it closer to this below with a classification and a
> sub-classification for each object (classification and sub- applicable to
> any department but not repeated here for the sake of your eyes):
>
>
>
> Department
>
> Classification
>
> Sub-classification
>
> Autre collection
>
>
>
>
>
> Musée d'orsay
>
>
>
>
>
>
>
> architecture et arts décoratifs
>
> architecture et arts décoratifs
>
>
>
>
>
> architecture et arts décoratifs-autre
>
>
>
>
>
> architecture et arts décoratifs-dessin
>
>
>
>
>
> architecture et arts décoratifs-objet
>
>
>
> arts graphiques
>
> arts graphiques
>
>
>
> autres œuvres
>
> autres oeuvres-archives
>
>
>
>
>
> autres oeuvres-objet et maquette
>
>
>
>
>
> autres oeuvres-oeuvre diverse
>
>
>
> peintures et pastels
>
> peintures et pastels-autre
>
>
>
>
>
> peintures et pastels-élément de décor & décor
>
>
>
>
>
> peintures et pastels-pastel
>
>
>
>
>
> peintures et pastels-tableau
>
>
>
> photographies
>
> photographies-autres
>
>
>
>
>
> photographies-négatif
>
>
>
>
>
> photographies-positif
>
>
>
>
>
> photographies-procédé direct
>
>
>
> sculptures et médailles
>
> sculptures et médailles-autre
>
>
>
>
>
> sculptures et médailles-médaille
>
>
>
>
>
> sculptures et médailles-sculpture
>
> Musée de l'Orangerie
>
>
>
>
>
> Musée national Ernest Hébert
>
>
>
>
>
>
>
> Was it the sense of your question Caitlin?
>
>
>
> Does it appeal to you all or does it sounds awkward?
>
> Thanks for your sharing,
>
>
>
> Elsa
>
>
>
> Elsa Badie Modiri
>
> Chargée de projet – Administrateur de la base de données M’Osaïque
>
> Pôle des données patrimoniales digitales – Direction de la Conservation et
> des Collections
>
> Musée d’Orsay
>
> 62, rue de Lille
>
> 75343 Paris Cedex 07
>
> Tél. : + 33 (0)1 40 49 49 87 – Fax : + 33 (0)1 45 49 05 54
>
> Email : [log in to unmask]
>
>
>
> Consultez le catalogue complet des 97 000 oeuvres du musée d'Orsay
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.musee-orsay.fr%2Ffr%2Fcollections%2Fbienvenue.html%3FS%3D0&amp;data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7C77f72a36c7ed4ea240dd08d6f9a078f5%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C636970864958781258&amp;sdata=Qjcksg1d1kY3GzTnd3rt4aTjOLQcKuin4cY6AYnFpco%3D&amp;reserved=0>
>
>
>
>
>
> *De :* The Museum System (TMS) Users [mailto:[log in to unmask]] *De
> la part de* Christine Droll
> *Envoyé :* mardi 25 juin 2019 15:39
> *À :* [log in to unmask]
> *Objet :* Re: Multiple collection areas
>
>
>
> Caitlin,
>
>
>
> We also use thesaurus terms (in the Attributes section of the object
> record) to search on what we’ve termed “Culture-Nationality”. We’ve
> recently had to parcel out a (defunct) Department’s collection into several
> other Departments, and being able to segregate by this term has helped
> tremendously!
>
>
>
> *From:* The Museum System (TMS) Users <[log in to unmask]> *On
> Behalf Of *Smith, Jeffrey
> *Sent:* Tuesday, June 25, 2019 8:34 AM
> *To:* [log in to unmask]
> *Subject:* Re: Multiple collection areas
>
>
>
> Caitlin,
>
>
>
> We use thesaurus keywords with the dedicated ThesXref type “Web
> Collections Area.” While not as fundamental to TMS as Departments, it does
> allow us to have two “areas” for objects, which is particularly useful  for
> contemporary art. It can be used for search both within TMS and online.
>
>
>
> *From:* The Museum System (TMS) Users <[log in to unmask]> *On
> Behalf Of *Caitlin Draayer
> *Sent:* Tuesday, June 25, 2019 9:29 AM
> *To:* ListServ tmsusers <[log in to unmask]>
> *Subject:* Multiple collection areas
>
>
>
> Good morning everyone,
>
> Has anyone implemented the use of multiple collection areas? And would you
> be willing to share any details?
>
> We are considering using this to further refine our Painting and Sculpture
> department and better sort what is American and what is European. Currently
> we are basing that sort off the artist’s nationality.
>
> Thanks!
>
> Caitlin
>
>
>
> Caitlin Draayer
> Associate Registrar, Database Administration and Exhibitions
> The Baltimore Museum of Art
> 10 Museum Drive
> Baltimore, MD 21218
> 443-573-1737
>
> [log in to unmask]
>
>
>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.