...
- 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
TMS table name | TMS field name | CSpace field name | notes | ConXrefs | constituentID | contentPerson | reference to Person Authority |
---|---|---|---|---|---|---|---|
Objects | Notes | comment |
| ||||
TextEntries | textEntry | comment | where textTypeID is 27 |
sql query
view: (NEEDS UPDATE)
Code Block | ||||
---|---|---|---|---|
| ||||
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 | ||||
---|---|---|---|---|
| ||||
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 | ||||
---|---|---|---|---|
| ||||
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 | ||||
---|---|---|---|---|
| ||||
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 ; |