Versions Compared

Old Version 90

changes.mady.by.user John W Keller

Saved on

compared with

New Version 91

changes.mady.by.user John W Keller

Saved on

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

...

Comments extract

field mapping

reference to Person Authority

TMS table name

TMS field name

CSpace field name

notes

ConXrefs

constituentID

contentPerson

Objects

Notes

comment

 

TextEntries

textEntry

comment

where textTypeID is 27

sql query

view: (NEEDS UPDATE)

Code Block
sql
sql
SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 xo.constituentIDNotes contentPersoncomment
FROM
 Objects ConXrefso
xWHERE
 JOINo.IsVirtual roles= r0 ONAND xo.roleIDIsTemplate = r.roleID0
 JOINAND objects o.Notes ON x.ID = IS NOT NULL
UNION ALL
SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 t.TextEntry comment
FROM
 TextEntries t
 JOIN constituentsObjects co ON xt.constituentIDID = c.constituentID
WHERE
 x.tableIDo.objectID
 JOIN TextTypes tt ON t.TextTypeID = 108tt.TextTypeID
WHERE
AND xt.activetableID = 1108
 AND o.IsVirtual = 0 AND o.IsTemplate = 0
 AND ct.constituentTypeIDTextTypeID = 1
 AND lower(r.ROLE) IN ('subject')
27
;

notes

...

Person depicted extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

ThesXrefs ConXrefs

termID constituentID

contentPlace contentPerson

reference to Place Person Authority

sql query

view: (NEEDS UPDATE)

Code Block
sql
sql
SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 x.termIDconstituentID contentPlacecontentPerson
FROM
 ThesXrefsConXrefs x
 JOIN ThesXrefTypesroles tr ON x.thesXrefTypeIDroleID = tr.thesXrefTypeIDroleID
 JOIN Objectsobjects o ON x.ID = o.objectID
WHERE
 JOIN constituents c ON x.tableIDconstituentID = 108
 c.constituentID
WHERE
 x.tableID = 108
 AND x.active = 1
 AND o.IsVirtual = 0 AND o.IsTemplate = 0
 AND xc.thesXrefTableIDconstituentTypeID = 3461
 AND lower(tr.thesXrefTypeROLE) IN ('subject')
;

notes

...

Place depicted extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

Objects ThesXrefs

Notes termID

comment

 

TextEntries

textEntry

comment

where textTypeID is 27 contentPlace

reference to Place Authority

sql query

view: (NEEDS UPDATE)

Code Block
sql
sql
SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 ox.NotestermID commentcontentPlace
FROM
 Objects o
WHERE
 o.IsVirtual = 0 AND o.IsTemplate = 0
 AND o.Notes IS NOT NULL
UNION ALL
ThesXrefs x
 JOIN ThesXrefTypes t ON x.thesXrefTypeID = t.thesXrefTypeID
 JOIN Objects o ON x.ID = o.objectID
WHERE
 x.tableID = 108
 AND x.active = 1
 AND o.IsVirtual = 0 AND o.IsTemplate = 0
 AND x.thesXrefTableID = 346
 AND lower(t.thesXrefType) IN ('subject')
;

notes

Content note extract

field mapping

TMS table name

TMS field name

CSpace field name

notes

TextEntries

textEntry

contentNote

where textTypeID is 85

sql query

view: (NEEDS UPDATE)

Code Block
sql
sql

SELECT
 CAST(o.objectID AS VARCHAR) objectID,
 t.TextEntry comment,
 tt.TextType,
 t.TextDate,
 t.AuthorConID
FROM
 TextEntries t
 JOIN Objects o ON t.ID = o.objectID
 JOIN TextTypes tt ON t.TextTypeID = tt.TextTypeID
WHERE
 t.tableID = 108
 AND o.IsVirtual = 0 AND o.IsTemplate = 0
 AND t.TextTypeID = 2785
;

notes