Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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
  • No labels