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 Row (tr)

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 Row (tr)

ID 3

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

Provenance

Table Cell (td)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

ID 7

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

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 Row (tr)

TextStatusID

Table Cell (td)

Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)

Table Row (tr)

Versions Compared

Old Version 6

New Version 7

Key