Thanks Ian! I would have never thought to look there! Christine, you are correct. There is a Suffix in Con records, but there is also a separate Suffix (and Prefix) in ConXref Details, which is entered in the Constituent Assistant screen when linking records.

 

Best,

Christina

 

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Christine Droll
Sent: Tuesday, April 10, 2018 8:44 AM
To: [log in to unmask]
Subject: Re: manage tables/columns

 

The TMS2014 version has it in the Constituents query group. Perhaps “prefix” is also “honorific” or “name title”?

 

 

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Eckert, Ian
Sent: Monday, April 9, 2018 5:20 PM
To: [log in to unmask]
Subject: Re: manage tables/columns

 

Christina,

 

I believe these are located in the 'Others' section of Tables/Columns, under Constituent Xref Details:

 

 

All best,

 

Ian
​

 

On Mon, Apr 9, 2018 at 6:05 PM, Christina Gibbs <[log in to unmask]> wrote:

Dear ListServ,

 

Is anyone able to locate where the Prefix & Suffix fields (from ConXrefDetails) live in manage Tables/Columns? I would like these to display as a distinct list in queries for a manual data scrubbing project.

 

Thanks!

 

Christina Gibbs

Collections Database Manager

 

Detroit Institute of Arts

5200 Woodward Avenue│Detroit, MI

313.578.1051 │ [log in to unmask]

 

Discover the connection between character and costume.

Tickets are now on sale for Star Wars™ and the Power of Costume, May 20-Sept. 30

Developed by the Smithsonian Institution Traveling Exhibition Service in partnership with the Lucas Museum of Narrative Art and in consultation with Lucasfilm Ltd.

 

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.



 

--

Ian Eckert
Manager, Collection & Exhibition Technologies (CE-Tech)
The Museum of Modern Art
11 West 53rd Street  New York, NY 10019

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.