TMS to CSpace persons 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.
	ID	• Custom field needed? see notes ——>			WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information	• Where would an alternate name for a person or an organization 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?
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	ID1		————		WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information
	ID2		————		WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information
	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.
	PrimaryParent				WHERE TableID=23	Is this parent (ID__) the primary parent person?
	RelationshipID				use as FK to Relationships.Relationship
	Remarks					Can CSpace handle free associations between objects (and other entities besides accessions?)
	TableID	————	————	————	used with ID1 (above)
ConAddress	Active	—?—			—?—
	AddressFormatID				use as FK to AddressFormats to determine whether to use US (1), UK (2), or EU (3) format. 0=unassigned
	AddressTypeID					Only use if there is useful information here (physical, mailing, web, or other address; current or past address)
	BeginDate	Custom field needed?
	City	Name Authority :Contact Information: Address - city/town/municipality	no
	ConstituentID				use as FK to Constituents.ConstituentID to get person or organization info.
	CountryID				use as FK to Countries.___ to get country
	DefaultBilling	Name Authority :Contact Information: Address type
	DefaultMailing	Name Authority :Contact Information: Address type
	DefaultShipping	Name Authority :Contact Information: Address type
	DisplayAddress					Is this just a reformat of other data?
	DisplayName1	Name Authority :Contact Information: Address - place1 (verify)
	DisplayName2	Name Authority :Contact Information: Address - place1 (verify)
	EndDate	Custom field needed?
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	LastSalesTaxID
	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.
	Rank	Custom field needed?
	Remarks	Custom field needed?
	State	Name Authority :Contact Information: Address - province/territory/state
	StreetLine1	Name Authority :Contact Information: Address - place1
	StreetLine2	Name Authority :Contact Information: Address - place2				concatenate with next
	StreetLine3	Name Authority :Contact Information: Address - place2				concatenate with previous
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
	ZipCode	Name Authority :Contact Information: Address - postcode
ConAltNames	ConstituentID				use as FK to Constituents.ConstituentID to get person info.
	CultureGroup	Name Authority: Person information: Person?s group				• Where do alternate culture group affiliations belong in CSpace?
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	FirstName	see notes ——>				• Where do alternate person names belong in CSpace?
	Institution	see notes ——>				• Where do alternate organization names belong in CSpace?
	LastName	see notes ——>				• Where do alternate person names belong 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.
	MiddleName	see notes ——>				• Where do alternate person names belong in CSpace?
	NameTitle	see notes ——>				• Where do alternate person names belong in CSpace?
	NameType				import as controlled list?
	Position	see notes ——>				• Where do alternate person names belong in CSpace?
	Remarks
	Suffix	see notes ——>				• Where do alternate person names belong in CSpace?
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
ConEMail	ConstituentID				use as FK to Constituents.ConstituentID to get person info.
	Description	Name Authority :Contact Information: Email type			import as controlled list
	EMailAddress	Name Authority :Contact Information: Email
	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.
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
ConPhones	ConstituentID				use as FK to Constituents.ConstituentID to get person info.
	Description	Name Authority :Contact Information: Telephone number type			import as controlled list
	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.
	PhoneNumber	Name Authority :Contact Information: Telephone number
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
Constituents	Active	Name Authority: Person information: Term status ?			WHERE ConstituentTypeID=1	verify
	Approved					Can be ignored? No useful information?
	BeginDate	Name Authority: Person information: Person's birth date	no		WHERE ConstituentTypeID=1
		Name Authority: Organization information: Organization's founding date	no		WHERE ConstituentTypeID !=1
	Biography	Name Authority: Person information: Person's biographical note			WHERE ConstituentTypeID=1
		Name Authority: Organization information: Organization's history			WHERE ConstituentTypeID !=1
	Code
	ConstituentTypeID				WHERE ConstituentTypeID=1	Record is for an individual
					WHERE ConstituentTypeID !=1	Record is for an organization (business, tribe, museum, foundation, government agency, etc.). Should "estate" be treated as an individual or as an organization?
	CultureGroup	Name Authority: Person information: Person?s group			WHERE ConstituentTypeID=1
		Name Authority: Organization information: Organizations's group			WHERE ConstituentTypeID !=1
	DisplayDate
	DisplayName	Name Authority: Person information: Display name			WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1
	EndDate	Name Authority: Person information: Person's death date			WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	FirstName	Name Authority: Person information: Person's forenames			WHERE ConstituentTypeID=1	will be concatenated with middle name
		Name Authority: Person information: Person's forenames			WHERE ConstituentTypeID !=1	If personal name info is entered when ConstituentTypeID !=1, the record will need to be parsed into: 1) a person record; 2) an organization record; and 3) a relationship (position) between the two records.
	Institution				WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1
	LastName	Name Authority: Person information: Person's surname			WHERE ConstituentTypeID=1
		Name Authority: Person information: Person's surname			WHERE ConstituentTypeID !=1	If personal name info is entered when ConstituentTypeID !=1, the record will need to be parsed into: 1) a person record; 2) an organization record; and 3) a relationship (position) between the two records.
	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.
	MiddleName	Name Authority: Person information: Person's forenames			WHERE ConstituentTypeID=1	will be concatenated with first name
		Name Authority: Person information: Person's forenames			WHERE ConstituentTypeID !=1	If personal name info is entered when ConstituentTypeID !=1, the record will need to be parsed into: 1) a person record; 2) an organization record; and 3) a relationship (position) between the two records.
	MTB_BirthPlace	Name Authority: Person information: Person's place of birth			WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1
	MTB_DeathPlace	Name Authority: Person information: Person's place of death			WHERE ConstituentTypeID=1	is currently empty, but should map
					WHERE ConstituentTypeID !=1	is currently empty, but should map
	MTB_Gender	Name Authority: Person information: Person's gender			WHERE ConstituentTypeID=1
	MTB_Occupation	Name Authority: Person information: Person's occupation			WHERE ConstituentTypeID !=1
	NameTitle	Name Authority: Person information: Person's title (verify)			WHERE ConstituentTypeID=1
		Name Authority: Person information: Person's title (verify)			WHERE ConstituentTypeID !=1	If personal name info is entered when ConstituentTypeID !=1, the record will need to be parsed into: 1) a person record; 2) an organization record; and 3) a relationship (position) between the two records.
	Nationality	Name Authority: Person information: Person's nationality			WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1
	Position				WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1	If a position is entered when ConstituentTypeID !=1, the position should be associated with the derivative person record.
	PublicAccess					Can be ignored? No useful information?
	PublicAccessOld					Can be ignored? No useful information?
	Remarks	Name Authority: Person information: Person's name notes			WHERE ConstituentTypeID=1
					WHERE ConstituentTypeID !=1
	Salutation				WHERE ConstituentTypeID=1	is currently empty, but should map
					WHERE ConstituentTypeID !=1	If a salutation is entered when ConstituentTypeID !=1, the salutation should be associated with the derivative person record.
	School	school or style				is currently empty, but should map
	Suffix
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
ConXrefs	Active	—?—			—?—
	Amount
	ConStatement
	ConstituentID				WHERE TableID=47 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info.
					WHERE TableID=81 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info.
		(donor)			WHERE TableID=108 and RoleID= 2, use as FK to Constituents.ConstituentID to get person?s info.
		Object collection information: Field collector(s) (primary collector)			WHERE TableID=108 and RoleID=17, use as FK to Constituents.ConstituentID to get person?s info.
		Object collection information: Field collector(s) (secondary collector)			WHERE TableID=108 and RoleID=19, use as FK to Constituents. ConstituentID to get person?s info.
		Object collection information: Field collector(s) (tertiary collector)			WHERE TableID=108 and RoleID=21, use as FK to Constituents.ConstituentID to get person?s info.
		(deaccession recipient)			WHERE TableID=108 and RoleID=23, use as FK to Constituents.ConstituentID to get person?s info.
		(transferree)			WHERE TableID=108 and RoleID=29, use as FK to Constituents.ConstituentID to get person?s info.
		(transferrer)			WHERE TableID=108 and RoleID=54, use as FK to Constituents.ConstituentID to get person?s info.
		(in memoriam)			WHERE TableID=108 and RoleID=57, use as FK to Constituents.ConstituentID to get person?s info.
					WHERE TableID=143 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info.
					WHERE TableID=187 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info.
					WHERE TableID=189 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info.
					WHERE TableID=322 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info.
	DateBegin
	DateEnd
	DisplayDate
	DisplayOrder
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	ID	————			WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info.
		————			WHERE TableID=81, use as FK to Loans.LoanID to get loan info.
		————			WHERE TableID=108, use as FK to Objects.ObjectID to get object info.
		————			WHERE TableID=143, use as FK to ReferenceMaster.ReferenceID to get bibliographic reference info.
		————			WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info.
		————			WHERE TableID=189, use as FK to Sites.SiteID to get place info.
		————			WHERE TableID=322, use as FK to MediaRenditions.RenditionID
	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.
	Prefix
	Remarks				WHERE TableID=47 and RoleID=xxx
					WHERE TableID=81 and RoleID=xxx
		Object collection information: Field collection note	Parse into biographical info, collection info, other info.		WHERE TableID=108 and RoleID IN (17,19,21)
		(donor remarks)			WHERE TableID=108 and RoleID=2
		(performer remarks)			WHERE TableID=108 and RoleID=16
		(photographer remarks)			WHERE TableID=108 and RoleID=18
		(original owner remarks)			WHERE TableID=108 and RoleID=20
		(maker remarks)			WHERE TableID=108 and RoleID=22
		(deaccession recipient remarks)			WHERE TableID=108 and RoleID=23
		(informant remarks)			WHERE TableID=108 and RoleID=24
		(subject [i.e., person depicted] remarks)			WHERE TableID=108 and RoleID=27
		(inspector remarks)			WHERE TableID=108 and RoleID=28
		(transferree remarks)			WHERE TableID=108 and RoleID=29
		(in-urned remarks)			WHERE TableID=108 and RoleID=30
		(in memoriam remarks)			WHERE TableID=108 and RoleID=57
		(landownder remarks)			WHERE TableID=108 and RoleID=59
					WHERE TableID=143 and RoleID=xxx
					WHERE TableID=187 and RoleID=xxx
					WHERE TableID=189 and RoleID=xxx
					WHERE TableID=322 and RoleID=xxx
	RoleID				use as FK to Roles.RoleID to get person?s role relative to object/exhibit/loan/etc.
	RoleTypeID
	Suffix
	TableID
LocApprovers	Approver
	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.
	SysTimeStamp	—?—	————	————	————	Only if useful for versioning context.
	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	Handler					should not be needed—MTB to parse into NameFull fields
	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.
LocHandlers	MTB_Active	—?—			—?—
	MTB_ConstituentID1	Name Authority: Person information: Display name (verify)			use as FK to Constituents.ConstituentID to get person info.
	MTB_ConstituentID2	Name Authority: Person information: Display name (verify)			use as FK to Constituents.ConstituentID to get person info.
	MTB_ConstituentID3	Name Authority: Person information: Display name (verify)			use as FK to Constituents.ConstituentID to get person info.
	MTB_ConstituentID4	Name Authority: Person information: Display name (verify)			use as FK to Constituents.ConstituentID to get person info.
	MTB_ConstituentID5	Name Authority: Person information: Display name (verify)			use as FK to Constituents.ConstituentID to get person info.
ObjContext	Culture	Cataloging:Object History and Association Information:Associated Cultural affinity
	N_Signed
	Nationality
	CulturalRegion	• Schema extension/ custom field needed				move elsewhere? only 2 entries.
		Object Description Information:Inscription content:Inscriber			WHERE TextTypeID IN (19,20,22,78), use as FK to Constituents.ConstituentID
	ID				WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information
					WHERE TextTypeID=12	Attributions
					WHERE TextTypeID=32	Culture Note
					WHERE TextTypeID=33	Culture groups on Tape
					WHERE TextTypeID=49	NAGPRA cultural determination
Users	EnteredDate	—?—	————	no	—?—	Only if useful for versioning context.
	Login	import as CSpace usernames?
	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_ConstituentID				use as FK to Constituents.ConstituentID to get person's info
	MTB_Notes					Do not import — data cleaning notes