This page contains information about PAHMA's data migration of Accessions and related info.
See parent page on PAHMA data migration ETL work.
Note: still under construction
Accessions extract
field mapping
TMS table name |
TMS field name |
CSpace field name |
notes |
---|---|---|---|
Objects |
ObjectID |
shortIdentifier |
|
Objects |
ObjectNumber |
acquisitionReferenceNumber |
|
sql query
view:
SELECT o.objectID acquisitionID, o.ObjectNumber acquisitionReferenceNumber FROM Objects o WHERE o.IsVirtual = 1 AND o.IsTemplate = 0 AND o.objectNumber LIKE 'Acc%' ;
notes
- objAccessions table also stores info on Accessions that are not in the Objects table