TMS to CSpace Places crosswalk

Table	Columns	CSpace destination	Cleaned?	Migrated?	Mapping	Notes
AltNums	AltNum	Object Identification Information:Other number	no
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
		• Custom field needed? see notes ——>			WHERE TableID=189, use as FK to Sites.SiteID to get place info.	• Where would an alternate name for a place go in CSpace?
	LoginID	—?—	no	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.
	Remarks	• Custom field needed?
ExhVenLocXrefs	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	ExhVenueXrefID
	LocationID
	LoginID	—?—	no	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.
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	ExhVenueXrefID
	LoginID	—?—	no	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.
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
	Approved
	ConstituentID				use as FK to Constituents.ConstituentID to get person info.
	Contact
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	ExhibitionID
	LoginID	—?—	no	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.
	Remarks	Exhibition Authority Schema:_____
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
GeoCodes	EnteredDate	————	————	————	————	Do not import — term creation info not needed
	GeoCode	Place Authority: Place name type			import as controlled list	Only 4 terms; perhaps better to import from place concordance table
	LoginID	————	————	————	————	Do not import — term creation info not needed
	SysTimeStamp	—?—	————	————	————	Do not import — term creation info not needed
	MTB_PlaceTermID	Object collection information: Field collection place: Place Authority: Place name	populate		use as FK to TMSThesaurus.Terms to get info. on position within Places Authority	Used to align place info with TMSThesaurus.Terms
	Provenance		align with Terms
ObjGeography	Continent	Place Authority: Place name (if terminal node when authority is made hierarchical)
	Country	Place Authority: Place name (if terminal node when authority is made hierarchical)
	County	Place Authority: Place name (if terminal node when authority is made hierarchical)
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	GeoCodeID	Place Authority: Place name type			use as FK to GeoCodes.GeoCodeID to get GeoCode
	LoginID	—?—	no	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.
	MTB_PlaceTermID	Object collection information: Field collection place: Place Authority: Place name	populate		use as FK to TMSThesaurus.Terms to get info. on position within Places Authority	Used to align place info with TMSThesaurus.Terms
	Region	Place Authority: Place name (if terminal node when authority is made hierarchical)
	State	Place Authority: Place name (if terminal node when authority is made hierarchical)
	SubRegion	Place Authority: Place name (if terminal node when authority is made hierarchical)
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
SiteClassifications	SiteClassification
SiteDates	DateBegSearch
	DateEndSearch
	DateText
	DayBegSearch
	DayEndSearch
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	EventType
	LoginID	—?—	no	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.
	MonthBegSearch
	MonthEndSearch
	Remarks
	SiteID
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
SiteGeoCodes	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	LoginID	—?—	no	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.
	SiteGeoCode
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
SiteGeography	City	Place Authority: Place name (if terminal node when authority is made hierarchical)
	Concession	————	move 2 notes elsewhere	no	————
	Continent	Place Authority: Place name (if terminal node when authority is made hierarchical)
	Country	Place Authority: Place name (if terminal node when authority is made hierarchical)
	County	Place Authority: Place name (if terminal node when authority is made hierarchical)
	CulturalRegion	• Schema extension/ custom field needed				move elsewhere? only 2 entries.
	Elevation	Place Authority: Place coordinates ?
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	GeoCodeID	Place Authority: Place name type			use as FK to GeoCodes.GeoCodeID to get GeoCode
	Latitude	Place Authority: Place coordinates
	Locale	Place Authority: Place name (if terminal node when authority is made hierarchical)
	LoginID	—?—	no	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.
	Longitude	Place Authority: Place coordinates
	Lot	————				Do not import — no PAHMA data
	MapReferenceNumber	Place Authority: Place coordinates	remove "29N 7E"	————		contains township & range info.
	MTB_PlaceTermID	Object collection information: Field collection place: Place Authority: Place name	populate		use as FK to TMSThesaurus.Terms to get info. on position within Places Authority	Used to align place info with TMSThesaurus.Terms
	Nation	Place Authority: Place name (if terminal node when authority is made hierarchical)
	Notes	Place Authority: Place note
	PoliticalRegion	• Schema extension/ custom field needed?				name of primary map of site (usually USGS)
	PrimaryDisplay
	Region	Place Authority: Place name (if terminal node when authority is made hierarchical)
	RegionalCorp	————	needs cleaning			? contains township & range info. [merge with similar]
	River	• Schema extension/ custom field needed?				will usually not fit into hierarchy
	SiteID	————			use as FK to Sites.SiteID to get place info
	State	Place Authority: Place name (if terminal node when authority is made hierarchical)
	SubContinent	Place Authority: Place name (if terminal node when authority is made hierarchical)
	SubRegion	Place Authority: Place name (if terminal node when authority is made hierarchical)
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
	Township	Place Authority: Place name (if terminal node when authority is made hierarchical)
	UTM	Place Authority: Place coordinates ?
	VillageCorporation	————	merge with TMS.CulturalRegion	no	————	only 1 entry
SiteObjXrefs	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	LoginID	—?—	no	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.
	Remarks	Object collection information: Field collection note
	SiteID	Object collection information: Field collection place			use as FK to Sites.SiteID to get place information
	Subsite1	Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)
	Subsite2	Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)
	Subsite3	Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	LoginID	—?—	no	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.
	ReferenceID
	Remarks
	SiteID
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
Sites	Active	—?—			—?—
	Description
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	HistoricalNotes
	IsPublic	—?—			—?—
	LocationNotes
	LoginID	—?—	no	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.
	MTB_PlaceTermID	Object collection information: Field collection place: Place Authority: Place name	populate		use as FK to TMSThesaurus.Terms to get info. on position within Places Authority	Used to align place info with TMSThesaurus.Terms
	Remarks
	ResearchActivity
	ResearcherComments
	SiteClassificationID
	SiteName
	SiteNumber					can prob. merge with SiteName
	SiteStatusID
	SiteTypeID
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
SiteStatuses	SiteStatus
TermMasterGeo	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	Latitude
	LatitudeDirection
	LatitudeNumber
	LoginID	—?—	no	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.
	Longitude
	LongitudeDirection
	LongitudeNumber
	TermMasterID
TextEntries	AuthorConID				use as FK to Constituents.ConstituentID to get person info.
					WHERE TableID=189, use as FK to Sites.SiteID to get place info.
	LoginID	—?—	no	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.
	MTB_PlaceTermID	Object collection information: Field collection place: Place Authority: Place name	populate		use as FK to TMSThesaurus.Terms to get info. on position within Places Authority	Used to align place info with TMSThesaurus.Terms
	Purpose
	Remarks
	TextDate	Object Description Information:Inscription content:Inscription date			WHERE TextTypeID IN (19,20,22,78)	note possible overlap with MTB_Dated (above)
	TextEntry				WHERE TextTypeID=0	(not assigned)
		Object collection information: Field collection note			WHERE TextTypeID=1	Object/Provenience Comment
		Object collection information: Field collection note			WHERE TextTypeID=8	NAGPRA Concord Comment
		Object collection information: Field collection place?			WHERE TextTypeID=14	Some site names, some site notes
		Object collection information: Field collection place: Place Authority: Place name			WHERE TextTypeID=45	Object Use Site
		Object collection information: Field collection note			WHERE TextTypeID=46	Provenience comments
	TextStatusID