| Table Head (th) |
|---|
| CSpace destination |
| Table Head (th) |
|---|
| Migrated? |
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Object Identification Information:Other number |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| • Custom field needed? see notes ——> |
| Table Cell (td) |
|---|
| WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information |
| Table Cell (td) |
|---|
•
Where would an alternate name for a person or an organization go in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| • Custom field needed? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| PrimaryParent |
| Table Cell (td) |
|---|
| WHERE TableID=23 |
| Table Cell (td) |
|---|
| Is this parent (ID__) the primary parent person? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| RelationshipID |
| Table Cell (td) |
|---|
| use as FK to Relationships.Relationship |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Can CSpace handle free associations between objects (and other entities besides accessions?) |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| used with ID1 (above) |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConAddress |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| AddressFormatID |
| Table Cell (td) |
|---|
| use as FK to AddressFormats to determine whether to use US (1), UK (2), or EU (3) format. 0=unassigned |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| AddressTypeID |
| Table Cell (td) |
|---|
| Only use if there is useful information here (physical, mailing, web, or other address; current or past address) |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Custom field needed? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConstituentID |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person or organization info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Countries.___ to get country |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DefaultBilling |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DefaultMailing |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DefaultShipping |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayAddress |
| Table Cell (td) |
|---|
| Is this just a reformat of other data? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayName1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayName2 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Custom field needed? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| LastSalesTaxID |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Custom field needed? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Custom field needed? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| StreetLine1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| StreetLine2 |
| Table Cell (td) |
|---|
| concatenate with next |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| StreetLine3 |
| Table Cell (td) |
|---|
| concatenate with previous |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| SysTimeStamp |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConAltNames |
| Table Cell (td) |
|---|
| ConstituentID |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| CultureGroup |
| Table Cell (td) |
|---|
| • Where do alternate culture group affiliations belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate person names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Institution |
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate organization names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate person names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MiddleName |
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate person names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate person names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| import as controlled list? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate person names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| see notes ——> |
| Table Cell (td) |
|---|
| • Where do alternate person names belong in CSpace? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| SysTimeStamp |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConstituentID |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Description |
| Table Cell (td) |
|---|
| import as controlled list |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EMailAddress |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| SysTimeStamp |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConstituentID |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Description |
| Table Cell (td) |
|---|
| import as controlled list |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| PhoneNumber |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| SysTimeStamp |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Constituents |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Can be ignored? No useful information? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConstituentTypeID |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
| Table Cell (td) |
|---|
| Record is for an individual |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
Record is for an organization (business, tribe, museum, foundation, government agency, etc.). Should
"estate" be treated as an individual or as an organization? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| CultureGroup |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayDate |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayName |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
| Table Cell (td) |
|---|
| will be concatenated with middle name |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
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. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Institution |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
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. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MiddleName |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
| Table Cell (td) |
|---|
| will be concatenated with first name |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
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. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_BirthPlace |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_DeathPlace |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
| Table Cell (td) |
|---|
| is currently empty, but should map |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
| is currently empty, but should map |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_Gender |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_Occupation |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
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. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Nationality |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
If a position is entered when ConstituentTypeID !=1, the position should be associated with the derivative
person record. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| PublicAccess |
| Table Cell (td) |
|---|
| Can be ignored? No useful information? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| PublicAccessOld |
| Table Cell (td) |
|---|
| Can be ignored? No useful information? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Salutation |
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID=1 |
| Table Cell (td) |
|---|
| is currently empty, but should map |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE ConstituentTypeID !=1 |
| Table Cell (td) |
|---|
If a salutation is entered when ConstituentTypeID !=1, the salutation should be associated with the
derivative person record. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| school or style |
| Table Cell (td) |
|---|
| is currently empty, but should map |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| SysTimeStamp |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConStatement |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ConstituentID |
| Table Cell (td) |
|---|
| WHERE TableID=47 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=81 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID= 2, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Object collection information: Field collector(s) (primary collector) |
| Table Cell (td) |
|---|
WHERE TableID=108 and RoleID=17, use as FK to Constituents.ConstituentID to
get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Object collection information: Field collector(s) (secondary collector) |
| Table Cell (td) |
|---|
WHERE TableID=108 and RoleID=19, use as FK to Constituents.
ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Object collection information: Field collector(s) (tertiary collector) |
| Table Cell (td) |
|---|
WHERE TableID=108 and RoleID=21, use as FK to Constituents.ConstituentID to
get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (deaccession recipient) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=23, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (transferree) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=29, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (transferrer) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=54, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (in memoriam) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=57, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=143 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=187 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=189 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=322 and RoleID= xxx, use as FK to Constituents.ConstituentID to get person?s info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayDate |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| DisplayOrder |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=81, use as FK to Loans.LoanID to get loan info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=108, use as FK to Objects.ObjectID to get object info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=143, use as FK to ReferenceMaster.ReferenceID to get bibliographic reference info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=189, use as FK to Sites.SiteID to get place info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=322, use as FK to MediaRenditions.RenditionID |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=47 and RoleID=xxx |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=81 and RoleID=xxx |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Object collection information: Field collection note |
| Table Cell (td) |
|---|
| | Parse into biographical info, collection info, other info. |
| Table Cell (td) |
|---|
WHERE TableID=108 and RoleID IN
(17,19,21) |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (donor remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=2 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (performer remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=16 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (photographer remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=18 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (original owner remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=20 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (maker remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=22 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (deaccession recipient remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=23 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (informant remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=24 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (subject [i.e., person depicted] remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=27 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (inspector remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=28 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (transferree remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=29 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (in-urned remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=30 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (in memoriam remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=57 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| (landownder remarks) |
| Table Cell (td) |
|---|
| WHERE TableID=108 and RoleID=59 |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=143 and RoleID=xxx |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=187 and RoleID=xxx |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=189 and RoleID=xxx |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=322 and RoleID=xxx |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Roles.RoleID to get person?s role relative to object/exhibit/loan/etc. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| RoleTypeID |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| LocApprovers |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| SysTimeStamp |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| should not be needed—MTB to parse into NameFull fields |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| LocHandlers |
| Table Cell (td) |
|---|
| MTB_Active |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_ConstituentID1 |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_ConstituentID2 |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_ConstituentID3 |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_ConstituentID4 |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_ConstituentID5 |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person info. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| ObjContext |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Nationality |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| CulturalRegion |
| Table Cell (td) |
|---|
| • Schema extension/ custom field needed |
| Table Cell (td) |
|---|
| move elsewhere? only 2 entries. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Object Description Information:Inscription content:Inscriber |
| Table Cell (td) |
|---|
| WHERE TextTypeID IN (19,20,22,78), use as FK to Constituents.ConstituentID |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TextTypeID=12 |
| Table Cell (td) |
|---|
| Attributions |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TextTypeID=32 |
| Table Cell (td) |
|---|
| Culture Note |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TextTypeID=33 |
| Table Cell (td) |
|---|
| Culture groups on Tape |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| WHERE TextTypeID=49 |
| Table Cell (td) |
|---|
| NAGPRA cultural determination |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| import as CSpace usernames? |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| MTB_ConstituentID |
| Table Cell (td) |
|---|
| use as FK to Constituents.ConstituentID to get person's info |
|
| Table Row (tr) |
|---|
| Table Cell (td) |
|---|
| Do not import — data cleaning notes |
|
|