Hi Jeffrey,
Did you check the SourceTermID in TermMaster table (not Terms table)?
select T.TermID, T.Term,
T.TermMasterID, TM.SourceTermID
as [TM.TermSourceID aka ConceptID]
from Terms T
inner
join TermMaster TM on T.TermMasterID
= TM.TermMasterID
where TermID
= 943322
TermID Term TermMasterID TM.TermSourceID aka ConceptID
943322 Detroit 663106 7013547
Best,
Christina Gibbs
Collections Database Manager
Detroit Institute of Arts
5200 Woodward AvenueDetroit, MI
313.578.1051
[log in to unmask]
From: The Museum System (TMS) Users <[log in to unmask]>
On Behalf Of Smith, Jeffrey
Sent: Friday, May 10, 2019 11:39 AM
To: [log in to unmask]
Subject: Getty TGN TermIDs and URL
Hello TMS Users,
I was hoping that the SourceTermID in the Getty’s TGN would be the same ID as that term’s online record, so I could invoke the URL to point to the authoritative source term when I needed to. I guess I was wrong, but perhaps I’ve missed
something. Perhaps someone with more experience using the TGN could explain a way to do this. Thanks for any help you might be able to provide!
Example:
Term TermID SourceTermID
Detroit 943322
236364
ID: 7013547
Page Link: http://vocab.getty.edu/page/tgn/7013547
Jeffrey Smith
Assistant Registrar for Collections Information
Freer Gallery of Art and Arthur M. Sackler Gallery
Smithsonian
202-633-0348
Experience where Asia meets America at the
Smithsonian’s Freer|Sackler
Connect with us on social media
@freersackler #freersackler
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.