TMS to CSpace persons crosswalk

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