...
TMS table name | TMS field name | CSpace field name | notes |
|---|---|---|---|
Objects | ObjectNumber | exitNumber | prepended with 'EX' |
ObjDeaccession | DispositionMethod | exitReason | FK to DispositionMethods |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT d.deaccessionID objectexitID, 'EX' + o.ObjectNumber exitNumber, (CASE WHEN d.dispositionMethod NOT IN (0, 9, 10) THEN lower(m.dispositionMethod) END) exitReason FROM ObjDeaccession d JOIN DispositionMethodsObjects mo ON d.dispositionMethodobjectID = mo.dispMethodIDobjectID WHERE JOIN d.objectIDDispositionMethods INm (SELECTON od.objectiddispositionMethod FROM= objectsm.dispMethodID oWHERE WHERE o.IsVirtual = 0 AND o.IsTemplate = 0) ; |
notes
- dispositionMethod values of 0 ("not assigned"), 9 ("number not used"), and 10 ("not found") are not imported
...