TMS to CSpace dates crosswalk

Table

Columns

CSpace destination

Cleaned?

Migrated?

Mapping

Notes

DateBeginno

DateEndno

DisplayDateno

BeginDateCustom field needed?EndDateCustom field needed?

ConstituentIDDateBegSearchDateDescriptionDateEndSearchDayBegSearchDayEndSearchEnteredDate—?—————

LoginID—?—no

MonthBegSearchMonthEndSearchRemarksSysTimeStamp—?—————

DateCompletedBeginDateName Authority: Person information: Person's birth date
no

DisplayDateEndDateName Authority: Person information: Person's death date
DateBeginDateEndDisplayDateDateMadeDisplayDimensions

BeginISODateBeginYearDisplayDateEndISODateEndYearBeginISODateEndISODateDateLabel(research & class visits)EndSearchDay(research & class visits)EndSearchMonth(research & class visits)EndSearchYear(research & class visits)BeginISODateEndISODateISODate1ISODate2ISODate3ISODate4ISODate5ISODate6ISODate7ISODate8ISODate9ISODate10PeriodReignCataloging:Object History and Association Information:Associated event name (verify)
may need to add "reign of" or other context

Cataloging:Object History and Association Information:Associated date note
(verify)may need to add "reign of" or other context

DateBegSearchObject collection information: Field collection date: date information: Date - earliest/single (part: year)Needs cleaning

Object collection information: Field collection date: date information: Date - earliest/single (part: year)Needs cleaning

Needs cleaning

DateEndSearchObject collection information: Field collection date: date information: Date - latest (part: year)Needs cleaning

Object collection information: Field collection date: date information: Date - latest (part: year)Needs cleaning

Needs cleaning

DateTextObject collection information: Field collection date: date information: Date textNeeds cleaning

Object collection information: Field collection date: date information: Date textNeeds cleaning

Needs cleaning

DayBegSearchObject collection information: Field collection date: date information: Date - earliest/single (part: day)Needs cleaning

Object collection information: Field collection date: date information: Date - earliest/single (part: day)Needs cleaning

Needs cleaning

DayEndSearchObject collection information: Field collection date: date information: Date - latest (part: day)Needs cleaning

Object collection information: Field collection date: date information: Date - latest (part: day)Needs cleaning

Needs cleaning

EnteredDate—?—————

—?—————

EventTypeObject collection information: Field collection date: date information: Date - associationchange to "collection date"

Object collection information: Field collection date: date information: Date - association
Object collection information: Field collection date: date information: Date - associationchange to "manufacture date" ?

change to "mint date"

change to "treatment date" ?

change to "recataloging date"

change to "accession date" ?

change to "publication date"

parse, if possible

LoginID—?—no

—?—no

MonthBegSearchObject collection information: Field collection date: date information: Date - earliest/single (part: month)Needs cleaning

Object collection information: Field collection date: date information: Date - earliest/single (part: month)Needs cleaning

Needs cleaning

MonthEndSearchObject collection information: Field collection date: date information: Date - latest (part: month)Needs cleaning

Object collection information: Field collection date: date information: Date - latest (part: month)Needs cleaning

Needs cleaning

Remarks• Schema extension/ custom field needed?is ok?

• Schema extension/ custom field needed?is ok?

is ok?

SysTimeStamp—?—————

—?—————

ProceedsRcvdDateSaleDateCatalogueISODateCuratorRevISODateDateBeginDated_____:Acquisition dateMany different date types — needs parsing

DateEndDateOut

DateBegSearchDateEndSearchDateTextEnteredDate—?—————

EventTypeLoginID—?—no

ReferenceIDSysTimeStamp—?—————

BeginDateDisplayDateEndDateYearPublished

DateBegSearchDateEndSearchDateTextDayBegSearchDayEndSearchEnteredDate—?—————

EventTypeLoginID—?—no

MonthBegSearchMonthEndSearchRemarksSiteIDSysTimeStamp—?—————

DateEnteredDateModified

BeginYearEndYearEnteredDate—?—————

LoginID—?—no

TermMasterIDMTB_DatedObject Description Information:Inscription content:Inscription date————yes

————check

DateBeginDateEndDisplayDateEnteredDate—?—————

LoginID—?—no

TMTypeXrefID


BeginISODate	• Custom field needed?
Associations









ConDates
			use as FK to Constituents.ConstituentID to get person info.











		no	—?—	Only if useful for versioning context.

		no	use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.







		————	————	Only if useful for versioning context.



			WHERE ConstituentTypeID=1



			WHERE ConstituentTypeID=1










Exhibitions
















































		no
ObjContext
		no
ObjDates
			WHERE EventType="Date Collected"

			WHERE EventType=" secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

			WHERE EventType=" Date Collected"

			WHERE EventType="secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

			WHERE EventType="Date Collected"

			WHERE EventType="secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

			WHERE EventType="Date Collected"

			WHERE EventType=" secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

			WHERE EventType=" Date Collected"

			WHERE EventType="secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

		no	WHERE EventType="Date Collected"	Only if useful for versioning context.

		no	WHERE EventType="secondary collection date"	Only if useful for versioning context.

		no	WHERE EventType="tertiary collection date"	Only if useful for versioning context.

		no	WHERE EventType="date made"	Only if useful for versioning context.

		no	WHERE EventType="minting"	Only if useful for versioning context.

		no	WHERE EventType="ruler date"	Only if useful for versioning context.

		no	WHERE EventType="material date"	Only if useful for versioning context.

		no	WHERE EventType="patent date"	Only if useful for versioning context.

		no	WHERE EventType="conservation date"	Only if useful for versioning context.

		no	WHERE EventType="recatalogued date"	Only if useful for versioning context.

		no	WHERE EventType="destruction date"	Only if useful for versioning context.

		no	WHERE EventType="deaccession date"	Only if useful for versioning context.

		no	WHERE EventType="date used"	Only if useful for versioning context.

		no	WHERE EventType="date received"	Only if useful for versioning context.

		no	WHERE EventType="accessioned"	Only if useful for versioning context.

		no	WHERE EventType="published"	Only if useful for versioning context.

		no	WHERE EventType="immured"	Only if useful for versioning context.

		no	WHERE EventType="mounted"	Only if useful for versioning context.

		no	WHERE EventType="date photographed"	Only if useful for versioning context.

		no	WHERE EventType="date of analysis"	Only if useful for versioning context.

		no	WHERE EventType="date missing"	Only if useful for versioning context.

		no	WHERE EventType="agency mail date"	Only if useful for versioning context.

		no	WHERE EventType="[not entered]"	Only if useful for versioning context.

		no	WHERE EventType IS NULL	Only if useful for versioning context.

			WHERE EventType=" Date Collected"

			WHERE EventType="secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

		no	WHERE EventType="Date Collected": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="secondary collection date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="tertiary collection date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="date made": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="minting": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="ruler date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="material date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="patent date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="conservation date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="recatalogued date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="destruction date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="deaccession date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="date used": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="date received": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="accessioned": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="published": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="immured": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="mounted": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="date photographed": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="date of analysis": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="date missing": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="agency mail date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType="[not entered]": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. ConstituentID to get person's info	Only if useful for attribution content.

		no	WHERE EventType IS NULL: use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.

			WHERE EventType="Date Collected"

			WHERE EventType=" secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

			WHERE EventType="Date Collected"

			WHERE EventType="secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="patent date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

			WHERE EventType="Date Collected"

			WHERE EventType="secondary collection date"

			WHERE EventType="tertiary collection date"

			WHERE EventType="date made"

			WHERE EventType="minting"

			WHERE EventType="ruler date"

			WHERE EventType="material date"

			WHERE EventType="material date"

			WHERE EventType="conservation date"

			WHERE EventType="recatalogued date"

			WHERE EventType="destruction date"

			WHERE EventType="deaccession date"

			WHERE EventType="date used"

			WHERE EventType="date received"

			WHERE EventType="accessioned"

			WHERE EventType="published"

			WHERE EventType="immured"

			WHERE EventType="mounted"

			WHERE EventType="date photographed"

			WHERE EventType="date of analysis"

			WHERE EventType="date missing"

			WHERE EventType="agency mail date"

			WHERE EventType="[not entered]"

			WHERE EventType IS NULL

		————	WHERE EventType="Date Collected"	Only if useful for versioning context.

		————	WHERE EventType="secondary collection date"	Only if useful for versioning context.

		————	WHERE EventType="tertiary collection date"	Only if useful for versioning context.

		————	WHERE EventType="date made"	Only if useful for versioning context.

		————	WHERE EventType="minting"	Only if useful for versioning context.

		————	WHERE EventType="ruler date"	Only if useful for versioning context.

		————	WHERE EventType="material date"	Only if useful for versioning context.

		————	WHERE EventType="material date"	Only if useful for versioning context.

		————	WHERE EventType="conservation date"	Only if useful for versioning context.

		————	WHERE EventType="recatalogued date"	Only if useful for versioning context.

		————	WHERE EventType="destruction date"	Only if useful for versioning context.

		————	WHERE EventType="deaccession date"	Only if useful for versioning context.

		————	WHERE EventType="date used"	Only if useful for versioning context.

		————	WHERE EventType="date received"	Only if useful for versioning context.

		————	WHERE EventType="accessioned"	Only if useful for versioning context.

		————	WHERE EventType="published"	Only if useful for versioning context.

		————	WHERE EventType="immured"	Only if useful for versioning context.

		————	WHERE EventType="mounted"	Only if useful for versioning context.

		————	WHERE EventType="date photographed"	Only if useful for versioning context.

		————	WHERE EventType="date of analysis"	Only if useful for versioning context.

		————	WHERE EventType="date missing"	Only if useful for versioning context.

		————	WHERE EventType="agency mail date"	Only if useful for versioning context.

		————	WHERE EventType="[not entered]"	Only if useful for versioning context.

		————	WHERE EventType IS NULL	Only if useful for versioning context.











				verify



			WHERE DateOut <> '12/31/9999'	If DateOut = "12/31/9999", it means that the component is still at this location
RefDates






		no	—?—	Only if useful for versioning context.



		no	use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.



		————	————	Only if useful for versioning context.








SiteDates










		no	—?—	Only if useful for versioning context.



		no	use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.









		————	————	Only if useful for versioning context.




TermMasterDates




		no	—?—	Only if useful for versioning context.

		no	use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.



			WHERE TextTypeID IN (19,20,22,78)	note possible overlap with TextDate (below)

			WHERE TextTypeID NOT IN (19,20,22,78)	mistake if TextTypeID=193850 ?

			WHERE TextTypeID NOT IN (19,20,22,78)
TMTypeXrefDates






		no	—?—	Only if useful for versioning context.

		no	use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info	Only if useful for attribution content.