Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • pahmaEthnographicFileCode is currently a static term list, but it will be changed to a Concept Authority reference once that authority is available

Person depicted extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

ConXrefs

constituentID

contentPerson

reference to Person

sql query

view:

Code Block
sql
sql

SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 x.constituentID contentPerson
FROM
 ConXrefs x
 JOIN roles r ON x.roleID = r.roleID
 JOIN objects o ON x.ID = o.objectID
 JOIN constituents c ON x.constituentID = c.constituentID
WHERE
 x.tableID = 108
 AND x.active = 1
 AND o.IsVirtual = 0 AND o.IsTemplate = 0 
 AND c.constituentTypeID = 1
 AND lower(r.ROLE) IN ('subject')
;

notes