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 |