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 |
|
|