Oops. Yes, thank you for the correction. It was renamed whenever Thes became a web-based app. Apparently, there is a view simply called TermMaster (in our db anyway). From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Smith, Jeffrey Sent: Friday, May 10, 2019 4:22 PM To: [log in to unmask] Subject: Re: Getty TGN TermIDs and URL Apparently not - thank you! That's in TermMasterThes in TMS 2018. From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Christina Gibbs Sent: Friday, May 10, 2019 4:07 PM To: ListServ tmsusers <[log in to unmask]<mailto:[log in to unmask]>> Subject: Re: Getty TGN TermIDs and URL 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]<mailto:[log in to unmask]> From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Smith, Jeffrey Sent: Friday, May 10, 2019 11:39 AM To: [log in to unmask]<mailto:[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: https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fvocab.getty.edu%2Fpage%2Ftgn%2F7013547&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C4d64089653cc43090b7a08d6d58c8288%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636931196810930025&sdata=VMEnfWeTJdgoIWtqEO31mIzV9UIhXOWZUVbXrIEk1Dw%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fvocab.getty.edu%2Fpage%2Ftgn%2F7013547&data=02%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C4d64089653cc43090b7a08d6d58c8288%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C1%7C0%7C636931196810940034&sdata=A2I7cMUkJVLnOrVtKoNfd4jHly%2BY8WrGK5GnXFs45tA%3D&reserved=0> Jeffrey Smith Assistant Registrar for Collections Information Freer Gallery of Art and Arthur M. Sackler Gallery Smithsonian [log in to unmask]<mailto:[log in to unmask]> 202-633-0348 [cid:image001.png@01D354C6.1F08E210] 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]<mailto:[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]<mailto:[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]<mailto:[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.