AltNums | |||||
AltNum | Object Identification Information:Other number | no | |||
—?— |
| ———— | |||
no | —?— | Only if useful for versioning context. | |||
• Custom field needed? see notes ——> | WHERE TableID=189, use as FK to Sites.SiteID to get place info. | • Where would an alternate | |||
—?— |
| 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. |
• Custom field needed? | |||||
ExhVenLocXrefs | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
use as FK to Constituents.ConstituentID to get person info. | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
Exhibition Authority Schema:_____ | |||||
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
GeoCodes | |||||
———— |
| ———— | ———— | ———— | Do not import — term creation info not needed |
Place Authority: Place name type | import as controlled list | Only 4 terms; perhaps better to import from place concordance table | |||
———— |
| ———— | ———— | ———— | Do not import — term creation info not needed |
—?— |
| ———— | ———— | ———— | Do not import — term creation info not needed |
Object collection information: Field collection place: Place Authority: Place name |
| populate | use as FK to TMSThesaurus.Terms to | Used to align place info with TMSThesaurus.Terms | |
| align with Terms | ||||
ObjGeography | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
Place Authority: Place name type | use as FK to GeoCodes.GeoCodeID to get GeoCode | ||||
—?— |
| 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. |
Object collection information: Field collection place: Place Authority: Place name |
| populate | use as FK to TMSThesaurus.Terms to | Used to align place info with TMSThesaurus.Terms | |
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
SiteClassifications | |||||
SiteDates | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
SiteGeoCodes | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
SiteGeography | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
———— |
| move 2 notes elsewhere | no | ———— | |
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
• Schema extension/ custom field needed | move elsewhere? only 2 entries. | ||||
Place Authority: Place coordinates ? | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
Place Authority: Place name type | use as FK to GeoCodes.GeoCodeID to get GeoCode | ||||
Place Authority: Place coordinates | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
—?— |
| 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. |
Place Authority: Place coordinates | |||||
———— | Do not import — no PAHMA data | ||||
Place Authority: Place coordinates |
| remove "29N 7E" | ———— | contains township & range info. | |
Object collection information: Field collection place: Place Authority: Place name |
| populate | use as FK to TMSThesaurus.Terms to | Used to align place info with TMSThesaurus.Terms | |
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place note | |||||
• Schema extension/ custom field needed? | name of primary map of site (usually USGS) | ||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
———— |
| needs cleaning | ? contains township & range info. [merge with similar] | ||
• Schema extension/ custom field needed? | will usually not fit into hierarchy | ||||
———— | use as FK to Sites.SiteID to get place info | ||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
Place Authority: Place name (if terminal node when authority is made hierarchical) | |||||
Place Authority: Place coordinates ? | |||||
———— |
| merge with TMS.CulturalRegion | no | ———— | only 1 entry |
SiteObjXrefs | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
Object collection information: Field collection note | |||||
Object collection information: Field collection place | use as FK to Sites.SiteID to get place information | ||||
Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null) | |||||
Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null) | |||||
Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null) | |||||
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
Sites | |||||
—?— | —?— | ||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— | —?— | ||||
—?— |
| 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. |
Object collection information: Field collection place: Place Authority: Place name |
| populate | use as FK to TMSThesaurus.Terms to | Used to align place info with TMSThesaurus.Terms | |
can prob. merge with SiteName | |||||
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. |
SiteStatuses | |||||
TermMasterGeo | |||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. |
—?— |
| 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. |
TextEntries | |||||
use as FK to Constituents.ConstituentID to get person info. | |||||
WHERE TableID=189, use as FK to Sites.SiteID to get place info. | |||||
—?— |
| 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. |
Object collection information: Field collection place: Place Authority: Place name |
| populate | use as FK to TMSThesaurus.Terms to | Used to align place info with TMSThesaurus.Terms | |
Object Description Information:Inscription content:Inscription date | WHERE TextTypeID IN (19,20,22,78) | note possible overlap with | |||
WHERE TextTypeID=0 | (not assigned) | ||||
Object collection information: Field collection note | WHERE TextTypeID=1 | Object/Provenience Comment | |||
Object collection information: Field collection note | WHERE TextTypeID=8 | NAGPRA Concord Comment | |||
Object collection information: Field collection place? | WHERE TextTypeID=14 | Some site names, some site notes | |||
Object collection information: Field collection place: Place Authority: Place name | WHERE TextTypeID=45 | Object Use Site | |||
Object collection information: Field collection note | WHERE TextTypeID=46 | Provenience comments | |||
Manage space
Manage content
Integrations