Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
HTML Table
border1
cellpadding3
cellspacing0
Table Head (th)

Table

Table Head (th)

Columns

Table Head (th)

CSpace destination

Table Head (th)

Cleaned?

Table Head (th)

Migrated?

Table Head (th)

Mapping

Table Head (th)

Notes

Table Row (tr)
Table Cell (td)

ObjAccession

Table Cell (td)

AccessionISODate

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AccessionMethodID

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AccessionValue

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AcqJustification

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AcquisitionLot

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AcquisitionNumber

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AcquisitionTerms

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

AuthDate

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

Authorizer

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

Budget

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

CurrencyAmount

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

CurrencyID

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

CurrencyRate

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

EnteredDate

Table Cell (td)

--?--

Table Cell (td)
aligncenter
Wiki Markup
{table:border=1|cellspacing=0|cellpadding=3}
{th} Table {th}{th} Columns {th}{th} CSpace destination {th}{th} Cleaned? {th}{th} Migrated? {th}{th} Mapping {th}{th} Notes {th}
{tr}{td}ObjAccession{td}{td}AccessionISODate{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AccessionMethodID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AccessionValue{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AcqJustification{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AcquisitionLot{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AcquisitionNumber{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AcquisitionTerms{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}AuthDate{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}Authorizer{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}Budget{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}CurrencyAmount{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}CurrencyID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}CurrencyRate{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}EnteredDate{td}{td}---?---{td}{td:align=center}------------
Table Cell (td)
aligncenter

no

Table Cell (td)
{td}{td:align=center}no{td}{td}---?--
Table Cell (td)

Only if useful for versioning context.

Table Row (tr) Table Cell (td)
Table Cell (td)

Initiator

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

LocalAmount

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

LoginID

Table Cell (td)

--?--

Table Cell (td)
aligncenter

no

Table Cell (td)
aligncenter

no

Table Cell (td)

use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info

Table Cell (td)

Only if useful for attribution content.

Table Row (tr) Table Cell (td)
Table Cell (td)

Source

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

SysTimeStamp

Table Cell (td)

--?--

Table Cell (td)
aligncenter
-{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}
{td}{td}Initiator{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}LocalAmount{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}LoginID{td}{td}---?---{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td}
{td}{td}Source{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}SysTimeStamp{td}{td}---?---{td}{td:align=center}------------
Table Cell (td)
aligncenter
{td}{td:align=center}------------
Table Cell (td)
{td}{td}------------
Table Cell (td)

Only if useful for versioning context.

Table Row (tr) Table Cell (td)
Table Cell (td)

ValuationNotes

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr)
Table Cell (td)

ObjDeaccession

Table Cell (td)

ApprovalDate1

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

ApprovalDate2

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

DispositionMethod

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

EnteredDate

Table Cell (td)

--?--

Table Cell (td)
aligncenter
{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}
{td}{td}ValuationNotes{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}ObjDeaccession{td}{td}ApprovalDate1{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}ApprovalDate2{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}DispositionMethod{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}EnteredDate{td}{td}---?---{td}{td:align=center}------------
Table Cell (td)
aligncenter

no

Table Cell (td)
{td}{td:align=center}no{td}{td}---?--
Table Cell (td)

Only if useful for versioning context.

Table Row (tr) Table Cell (td)
Table Cell (td)

EstimateHigh

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

EstimateLow

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

LoginID

Table Cell (td)

--?--

Table Cell (td)
aligncenter

no

Table Cell (td)
aligncenter

no

Table Cell (td)

use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info

Table Cell (td)

Only if useful for attribution content.

Table Row (tr) Table Cell (td)
Table Cell (td)

LotNumber

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

NetSaleAmount

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

OldDepartmentID

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

RecipientConID

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

Remarks

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

SaleNumber

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

SysTimeStamp

Table Cell (td)

--?--

Table Cell (td)
aligncenter
-{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}
{td}{td}EstimateHigh{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}EstimateLow{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}LoginID{td}{td}---?---{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td}
{td}{td}LotNumber{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}NetSaleAmount{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}OldDepartmentID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}RecipientConID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}Remarks{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}SaleNumber{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}SysTimeStamp{td}{td}---?---{td}{td:align=center}------------
Table Cell (td)
aligncenter
{td}{td:align=center}------------
Table Cell (td)
{td}{td}------------
Table Cell (td)

Only if useful for versioning context.

Table Row (tr) Table Cell (td)
Table Cell (td)

Terms

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr)
Table Cell (td)

ObjIncoming

Table Cell (td)

CratingActual

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

CratingEstimate

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

EnteredDate

Table Cell (td)

--?--

Table Cell (td)
aligncenter
{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}
{td}{td}Terms{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}ObjIncoming{td}{td}CratingActual{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}CratingEstimate{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}EnteredDate{td}{td}---?---{td}{td:align=center}------------
Table Cell (td)
aligncenter

no

Table Cell (td)
{td}{td:align=center}no{td}{td}---?--
Table Cell (td)

Only if useful for versioning context.

Table Row (tr) Table Cell (td)
Table Cell (td)

InInsurActual

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

InInsurEstimate

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

InInsurValue

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

InPurposeID

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

LoginID

Table Cell (td)

--?--

Table Cell (td)
aligncenter

no

Table Cell (td)
aligncenter

no

Table Cell (td)

use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info

Table Cell (td)

Only if useful for attribution content.

Table Row (tr) Table Cell (td)
Table Cell (td)

ShippingActual

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

ShippingEstimate

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

ShippingMethodID

Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)
Table Cell (td)

SysTimeStamp

Table Cell (td)

--?--

Table Cell (td)
aligncenter
-{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}
{td}{td}InInsurActual{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}InInsurEstimate{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}InInsurValue{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}InPurposeID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}LoginID{td}{td}---?---{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td}
{td}{td}ShippingActual{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}ShippingEstimate{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}ShippingMethodID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}
{td}{td}SysTimeStamp{td}{td}---?---{td}{td:align=center}------------
Table Cell (td)
aligncenter
{td}{td:align=center}------------
Table Cell (td)
{td}{td}------------
Table Cell (td)

Only if useful for versioning context.

Table Row (tr) Table Cell (td) Table Cell (td) Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td)

WHERE TextTypeID=31

Table Cell (td)

Ledger Redline Data

Table Row (tr) Table Cell (td) Table Cell (td) Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td)

WHERE TextTypeID=55

Table Cell (td)

Verbatim Ledger

Table Row (tr) Table Cell (td) Table Cell (td) Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td)

WHERE TextTypeID=56

Table Cell (td)

Accession Envelope

Table Row (tr) Table Cell (td) Table Cell (td) Table Cell (td) Table Cell (td)
aligncenter
Table Cell (td)
aligncenter
Table Cell (td)

WHERE TextTypeID=63

Table Cell (td)Deaccession Comments
{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}
{td}{td}
{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=31{td}{td}Ledger Redline Data{td}{tr}
{tr}{td}
{td}{td}
{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=55{td}{td}Verbatim Ledger{td}{tr}
{tr}{td}
{td}{td}
{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=56{td}{td}Accession Envelope{td}{tr}
{tr}{td}
{td}{td}
{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=63{td}{td}Deaccession Comments{td}{tr}
{table}