Page Comparison

HTML Table

border	1
cellpadding	3
cellspacing	0

Table Head (th)
Table

Table Head (th)
Columns

Table Head (th)
CSpace destination

Table Head (th)
Cleaned?

Table Head (th)
Migrated?

Table Head (th)
Mapping

Table Head (th)
Notes

Table Row (tr)

Table Cell (td)
AltNums

Table Cell (td)
AltNum

Table Cell (td)
Object Identification Information:Other number

Table Cell (td)

align	center

no

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
• Custom field needed? see notes ——>

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=189, use as FK to Sites.SiteID to get place info.

Table Cell (td)
• Where would an alternate name for a place go in CSpace?

Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
Remarks

Table Cell (td)
• Custom field needed?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td)

Table Row (tr)

Table Cell (td)
ExhVenLocXrefs

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
ExhVenueXrefID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LocationID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
ExhVenueXrefID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
Approved

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
ConstituentID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to Constituents.ConstituentID to get person info.

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Contact

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
ExhibitionID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
Remarks

Table Cell (td)
Exhibition Authority Schema:_____

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr)

Table Cell (td)
GeoCodes

Table Cell (td)
EnteredDate

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — term creation info not needed

Table Row (tr) Table Cell (td)

Table Cell (td)
GeoCode

Table Cell (td)
Place Authority: Place name type

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
import as controlled list

Table Cell (td)
Only 4 terms; perhaps better to import from place concordance table

Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
————

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — term creation info not needed

Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Do not import — term creation info not needed

Table Row (tr) Table Cell (td)

Table Cell (td)
MTB_PlaceTermID

Table Cell (td)
Object collection information: Field collection place: Place Authority: Place name

Table Cell (td)

align	center

populate

Table Cell (td)

align	center

Table Cell (td)
use as FK to TMSThesaurus.Terms to get info. on position within Places Authority

Table Cell (td)
Used to align place info with TMSThesaurus.Terms

Table Row (tr) Table Cell (td)

Table Cell (td)
Provenance

Table Cell (td)

align	center

align with Terms

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr)

Table Cell (td)
ObjGeography

Table Cell (td)
Continent

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Country

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
County

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
GeoCodeID

Table Cell (td)
Place Authority: Place name type

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to GeoCodes.GeoCodeID to get GeoCode

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MTB_PlaceTermID

Table Cell (td)
Object collection information: Field collection place: Place Authority: Place name

Table Cell (td)

align	center

populate

Table Cell (td)

align	center

Table Cell (td)
use as FK to TMSThesaurus.Terms to get info. on position within Places Authority

Table Cell (td)
Used to align place info with TMSThesaurus.Terms

Table Row (tr) Table Cell (td)

Table Cell (td)
Region

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
State

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SubRegion

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr)

Table Cell (td)
SiteClassifications

Table Cell (td)
SiteClassification

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr)

Table Cell (td)
SiteDates

Table Cell (td)
DateBegSearch

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
DateEndSearch

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
DateText

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
DayBegSearch

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
DayEndSearch

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
EventType

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MonthBegSearch

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
MonthEndSearch

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Remarks

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr)

Table Cell (td)
SiteGeoCodes

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
SiteGeoCode

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr)

Table Cell (td)
SiteGeography

Table Cell (td)
City

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Concession

Table Cell (td)
————

Table Cell (td)

align	center

move 2 notes elsewhere

Table Cell (td)

align	center

no

Table Cell (td)
————

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Continent

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Country

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
County

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
CulturalRegion

Table Cell (td)
• Schema extension/ custom field needed

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
move elsewhere? only 2 entries.

Table Row (tr) Table Cell (td)

Table Cell (td)
Elevation

Table Cell (td)
Place Authority: Place coordinates ?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
GeoCodeID

Table Cell (td)
Place Authority: Place name type

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to GeoCodes.GeoCodeID to get GeoCode

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Latitude

Table Cell (td)
Place Authority: Place coordinates

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Locale

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
Longitude

Table Cell (td)
Place Authority: Place coordinates

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Lot

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
Do not import — no PAHMA data

Table Row (tr) Table Cell (td)

Table Cell (td)
MapReferenceNumber

Table Cell (td)
Place Authority: Place coordinates

Table Cell (td)

align	center

remove "29N 7E"

Table Cell (td)

align	center

————

Table Cell (td)

Table Cell (td)
contains township & range info.

Table Row (tr) Table Cell (td)

Table Cell (td)
MTB_PlaceTermID

Table Cell (td)
Object collection information: Field collection place: Place Authority: Place name

Table Cell (td)

align	center

populate

Table Cell (td)

align	center

Table Cell (td)
use as FK to TMSThesaurus.Terms to get info. on position within Places Authority

Table Cell (td)
Used to align place info with TMSThesaurus.Terms

Table Row (tr) Table Cell (td)

Table Cell (td)
Nation

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Notes

Table Cell (td)
Place Authority: Place note

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
PoliticalRegion

Table Cell (td)
• Schema extension/ custom field needed?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
name of primary map of site (usually USGS)

Table Row (tr) Table Cell (td)

Table Cell (td)
PrimaryDisplay

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Region

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
RegionalCorp

Table Cell (td)
————

Table Cell (td)

align	center

needs cleaning

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
? contains township & range info. [merge with similar]

Table Row (tr) Table Cell (td)

Table Cell (td)
River

Table Cell (td)
• Schema extension/ custom field needed?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
will usually not fit into hierarchy

Table Row (tr) Table Cell (td)

Table Cell (td)
SiteID

Table Cell (td)
————

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to Sites.SiteID to get place info

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
State

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SubContinent

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SubRegion

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
Township

Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
UTM

Table Cell (td)
Place Authority: Place coordinates ?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
VillageCorporation

Table Cell (td)
————

Table Cell (td)

align	center

merge with TMS.CulturalRegion

Table Cell (td)

align	center

no

Table Cell (td)
————

Table Cell (td)
only 1 entry

Table Row (tr)

Table Cell (td)
SiteObjXrefs

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
Remarks

Table Cell (td)
Object collection information: Field collection note

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteID

Table Cell (td)
Object collection information: Field collection place

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to Sites.SiteID to get place information

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Subsite1

Table Cell (td)
Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Subsite2

Table Cell (td)
Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Subsite3

Table Cell (td)
Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
ReferenceID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Remarks

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr)

Table Cell (td)
Sites

Table Cell (td)
Active

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Description

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
HistoricalNotes

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
IsPublic

Table Cell (td)
—?—

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LocationNotes

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MTB_PlaceTermID

Table Cell (td)
Object collection information: Field collection place: Place Authority: Place name

Table Cell (td)

align	center

populate

Table Cell (td)

align	center

Table Cell (td)
use as FK to TMSThesaurus.Terms to get info. on position within Places Authority

Table Cell (td)
Used to align place info with TMSThesaurus.Terms

Table Row (tr) Table Cell (td)

Table Cell (td)
Remarks

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
ResearchActivity

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
ResearcherComments

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteClassificationID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteName

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteNumber

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
can prob. merge with SiteName

Table Row (tr) Table Cell (td)

Table Cell (td)
SiteStatusID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SiteTypeID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
SysTimeStamp

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

————

Table Cell (td)
————

Table Cell (td)
Only if useful for versioning context.

Table Row (tr)

Table Cell (td)
SiteStatuses

Table Cell (td)
SiteStatus

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td)

Table Row (tr)

Table Cell (td)
TermMasterGeo

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td)

Table Cell (td)
Latitude

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LatitudeDirection

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LatitudeNumber

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
Longitude

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LongitudeDirection

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LongitudeNumber

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
TermMasterID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr)

Table Cell (td)
TextEntries

Table Cell (td)
AuthorConID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to Constituents.ConstituentID to get person info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Cell (td) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=189, use as FK to Sites.SiteID to get place info.

Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
LoginID

Table Cell (td)
—?—

Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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)

Table Cell (td)
MTB_PlaceTermID

Table Cell (td)
Object collection information: Field collection place: Place Authority: Place name

Table Cell (td)

align	center

populate

Table Cell (td)

align	center

Table Cell (td)
use as FK to TMSThesaurus.Terms to get info. on position within Places Authority

Table Cell (td)
Used to align place info with TMSThesaurus.Terms

Table Row (tr) Table Cell (td)

Table Cell (td)
Purpose

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
Remarks

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)

Table Cell (td)
TextDate

Table Cell (td)
Object Description Information:Inscription content:Inscription date

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID IN (19,20,22,78)

Table Cell (td)
note possible overlap with MTB_Dated (above)

Table Row (tr) Table Cell (td)

Table Cell (td)
TextEntry

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID=0

Table Cell (td)
(not assigned)

Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
Object collection information: Field collection note

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID=1

Table Cell (td)
Object/Provenience Comment

Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
Object collection information: Field collection note

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID=8

Table Cell (td)
NAGPRA Concord Comment

Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
Object collection information: Field collection place?

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID=14

Table Cell (td)
Some site names, some site notes

Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
Object collection information: Field collection place: Place Authority: Place name

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID=45

Table Cell (td)
Object Use Site

Table Row (tr) Table Cell (td) Table Cell (td)

Table Cell (td)
Object collection information: Field collection note

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TextTypeID=46

Table Cell (td)
Provenience comments

Table Row (tr) Table Cell (td)

Table Cell (td)
TextStatusID

Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)td Wiki Markup

{table:border=1|cellspacing=0|cellpadding=3}
{th} Table {th}{th} Columns {th}{th} CSpace destination {th}{th} Cleaned? {th}{th} Migrated? {th}{th} Mapping {th}{th} Notes {th}
{tr}{td}AltNums{td}{td}AltNum{td}{td}Object Identification Information:Other number{td}{td:align=center}no{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td} {td}{td}• Custom field needed? see notes ——>{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=189, use as FK to Sites.SiteID to get place info.{td}{td}• Where would an alternate name
for a place go in CSpace?{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}• Custom field needed?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}ExhVenLocXrefs{td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}ExhVenueXrefID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LocationID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}ExhVenueXrefID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}Approved{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}ConstituentID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to Constituents.ConstituentID to get person info.{td}{td}{td}{tr}
{tr}{td} {td}{td}Contact{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}ExhibitionID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}Exhibition Authority Schema:_____{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}GeoCodes{td}{td}EnteredDate{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — term creation info not needed{td}{tr}
{tr}{td} {td}{td}GeoCode{td}{td}Place Authority: Place name type{td}{td:align=center}{td}{td:align=center}{td}{td}import as controlled list{td}{td}Only 4 terms; perhaps better to import from place concordance table{td}
{tr}
{tr}{td} {td}{td}LoginID{td}{td}————{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — term creation info not needed{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Do not import — term creation info not needed{td}{tr}
{tr}{td} {td}{td}MTB_PlaceTermID{td}{td}Object collection information: Field collection place: Place Authority: Place name{td}{td:align=center}populate{td}{td:align=center}{td}{td}use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority{td}{td}Used to align place info with TMSThesaurus.Terms{td}{tr}
{tr}{td} {td}{td}Provenance{td}{td}{td}{td:align=center}align with Terms{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}ObjGeography{td}{td}Continent{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Country{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}County{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}GeoCodeID{td}{td}Place Authority: Place name type{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to GeoCodes.GeoCodeID to get GeoCode{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MTB_PlaceTermID{td}{td}Object collection information: Field collection place: Place Authority: Place name{td}{td:align=center}populate{td}{td:align=center}{td}{td}use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority{td}{td}Used to align place info with TMSThesaurus.Terms{td}{tr}
{tr}{td} {td}{td}Region{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}State{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SubRegion{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}SiteClassifications{td}{td}SiteClassification{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}SiteDates{td}{td}DateBegSearch{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}DateEndSearch{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}DateText{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}DayBegSearch{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}DayEndSearch{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}EventType{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MonthBegSearch{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}MonthEndSearch{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}SiteGeoCodes{td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}SiteGeoCode{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}SiteGeography{td}{td}City{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Concession{td}{td}————{td}{td:align=center}move 2 notes elsewhere{td}{td:align=center}no{td}{td}————{td}{td}{td}{tr}
{tr}{td} {td}{td}Continent{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Country{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}County{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}CulturalRegion{td}{td}• Schema extension/ custom field needed{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}move elsewhere? only 2 entries.{td}{tr}
{tr}{td} {td}{td}Elevation{td}{td}Place Authority: Place coordinates ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}GeoCodeID{td}{td}Place Authority: Place name type{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to GeoCodes.GeoCodeID to get GeoCode{td}{td}{td}{tr}
{tr}{td} {td}{td}Latitude{td}{td}Place Authority: Place coordinates{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Locale{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}Longitude{td}{td}Place Authority: Place coordinates{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Lot{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Do not import — no PAHMA data{td}{tr}
{tr}{td} {td}{td}MapReferenceNumber{td}{td}Place Authority: Place coordinates{td}{td:align=center}remove "29N 7E"{td}{td:align=center}————{td}{td}{td}{td}contains township & range info.{td}{tr}
{tr}{td} {td}{td}MTB_PlaceTermID{td}{td}Object collection information: Field collection place: Place Authority: Place name{td}{td:align=center}populate{td}{td:align=center}{td}{td}use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority{td}{td}Used to align place info with TMSThesaurus.Terms{td}{tr}
{tr}{td} {td}{td}Nation{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Notes{td}{td}Place Authority: Place note{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}PoliticalRegion{td}{td}• Schema extension/ custom field needed?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}name of primary map of site (usually USGS){td}{tr}
{tr}{td} {td}{td}PrimaryDisplay{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Region{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}RegionalCorp{td}{td}————{td}{td:align=center}needs cleaning{td}{td:align=center}{td}{td}{td}{td}? contains township & range info. \[merge with similar\]{td}{tr}
{tr}{td} {td}{td}River{td}{td}• Schema extension/ custom field needed?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}will usually not fit into hierarchy{td}{tr}
{tr}{td} {td}{td}SiteID{td}{td}————{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to Sites.SiteID to get place info{td}{td}{td}{tr}
{tr}{td} {td}{td}State{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SubContinent{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SubRegion{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}Township{td}{td}Place Authority: Place name (if terminal node when authority is made hierarchical){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}UTM{td}{td}Place Authority: Place coordinates ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}VillageCorporation{td}{td}————{td}{td:align=center}merge with TMS.CulturalRegion{td}{td:align=center}no{td}{td}————{td}{td}only 1 entry{td}{tr}
{tr}{td}SiteObjXrefs{td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}Object collection information: Field collection note{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteID{td}{td}Object collection information: Field collection place{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to Sites.SiteID to get place information{td}{td}{td}{tr}
{tr}{td} {td}{td}Subsite1{td}{td}Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Subsite2{td}{td}Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Subsite3{td}{td}Object collection information: Field collection place (concatenate subsites1, 2, 3 to site when not null){td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}ReferenceID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}Sites{td}{td}Active{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}{td}{tr}
{tr}{td} {td}{td}Description{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}HistoricalNotes{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}IsPublic{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}{td}{tr}
{tr}{td} {td}{td}LocationNotes{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MTB_PlaceTermID{td}{td}Object collection information: Field collection place: Place Authority: Place name{td}{td:align=center}populate{td}{td:align=center}{td}{td}use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority{td}{td}Used to align place info with TMSThesaurus.Terms{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}ResearchActivity{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}ResearcherComments{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteClassificationID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteName{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteNumber{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}can prob. merge with SiteName{td}{tr}
{tr}{td} {td}{td}SiteStatusID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SiteTypeID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}SysTimeStamp{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}————{td}{td}————{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td}SiteStatuses{td}{td}SiteStatus{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}TermMasterGeo{td}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {td}{td}Latitude{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LatitudeDirection{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LatitudeNumber{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}Longitude{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LongitudeDirection{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}LongitudeNumber{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}TermMasterID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}TextEntries{td}{td}AuthorConID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to Constituents.ConstituentID to get person info.{td}{td}{td}{tr}
{tr}{td} {td}{td} {td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=189, use as FK to Sites.SiteID to get place info.{td}{td}{td}{tr}
{tr}{td} {td}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {td}{td}MTB_PlaceTermID{td}{td}Object collection information: Field collection place: Place Authority: Place name{td}{td:align=center}populate{td}{td:align=center}{td}{td}use as FK to TMSThesaurus.Terms to
get info. on position within Places Authority{td}{td}Used to align place info with TMSThesaurus.Terms{td}{tr}
{tr}{td} {td}{td}Purpose{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}Remarks{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {td}{td}TextDate{td}{td}Object Description Information:Inscription content:Inscription date{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID IN (19,20,22,78){td}{td}note possible overlap with
MTB_Dated (above){td}{tr}
{tr}{td} {td}{td}TextEntry{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=0 {td}{td}(not assigned){td}{tr}
{tr}{td} {td}{td} {td}{td}Object collection information: Field collection note{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=1 {td}{td}Object/Provenience Comment{td}{tr}
{tr}{td} {td}{td} {td}{td}Object collection information: Field collection note{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=8 {td}{td}NAGPRA Concord Comment{td}{tr}
{tr}{td} {td}{td} {td}{td}Object collection information: Field collection place?{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=14{td}{td}Some site names, some site notes{td}{tr}
{tr}{td} {td}{td} {td}{td}Object collection information: Field collection place: Place Authority: Place name{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=45{td}{td}Object Use Site{td}{tr}
{tr}{td} {td}{td} {td}{td}Object collection information: Field collection note{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TextTypeID=46{td}{td}Provenience comments{td}{tr}
{tr}{td} {td}{td}TextStatusID{td}{td}{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{table}

Versions Compared

Old Version 8

New Version 9

Key