Versions Compared

Old Version 7

changes.mady.by.user Michael T. Black

Saved on

compared with

New Version Current

changes.mady.by.user Michael T. Black

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
HTML Table
border1
cellpadding3
cellspacing0
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)
aligncenter
no
Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ID 3

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

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TableID=189, use as FK to Sites.SiteID to get place info.
Table Cell (td)
• Where would an alternate name
name
for a place go in CSpace?
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
Remarks
Table Cell (td)
• Custom field needed?
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
ExhVenLocXrefs
tr
Table Cell (td)
EnteredDate
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ExhVenueXrefID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LocationID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ExhVenueXrefID
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Approved
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ConstituentID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Contact
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ExhibitionID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
Remarks
Table Cell (td)
Exhibition Authority Schema:_____
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
GeoCodes
tr
Table Cell (td)
EnteredDate
Table Cell (td)
————
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Do not import — term creation info not needed
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
GeoCode
Table Cell (td)
Place Authority: Place name type
td
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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

Table Cell (td)
LoginID
Table Cell (td)
————
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Do not import — term creation info not needed
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Do not import — term creation info not needed
Table Row (tr)
Table Cell (td)
tr

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

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

Table Cell (td)
Provenance
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter
align with Terms
Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
ObjGeography
tr
Table Cell (td)
Continent
Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
GeoCodeID
Table Cell (td)
Place Authority: Place name type
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

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

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

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
SiteClassifications
tr
Table Cell (td)
SiteClassification
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
SiteDates
tr
Table Cell (td)
DateBegSearch
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
DateEndSearch
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
DateText
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
DayBegSearch
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
DayEndSearch
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EventType
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
MonthBegSearch
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
MonthEndSearch
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Remarks
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
SiteGeoCodes
tr
Table Cell (td)
EnteredDate
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
SiteGeoCode
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
SiteGeography
tr
Table Cell (td)
City
Table Cell (td)
Place Authority: Place name (if terminal node when authority is made hierarchical)
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Concession
Table Cell (td)
————
Table Cell (td)
Table Cell (td)
aligncenter
move 2 notes elsewhere
Table Cell (td)
aligncenter
no
Table Cell (td)
————
Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

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

Table Cell (td)
Elevation
Table Cell (td)
Place Authority: Place coordinates ?
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
GeoCodeID
Table Cell (td)
Place Authority: Place name type
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Latitude
Table Cell (td)
Place Authority: Place coordinates
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
Longitude
Table Cell (td)
Place Authority: Place coordinates
td
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Lot
Table Cell (td)
————
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

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

Table Cell (td)
MapReferenceNumber
Table Cell (td)
Place Authority: Place coordinates
Table Cell (td)
Table Cell (td)
aligncenter
remove
"29N 7E"
“29N 7E”
Table Cell (td)
aligncenter
————
Table Cell (td)

Table Cell (td)
contains township & range info.
Table Row (tr)
Table Cell (td)
tr

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

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

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Notes
Table Cell (td)
Place Authority: Place note
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

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

Table Cell (td)
PrimaryDisplay
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
RegionalCorp
Table Cell (td)
————
td
Table Cell (td)
aligncenter
needs cleaning
Table Cell (td)
aligncenter

Table Cell (td)

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

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)
will usually not fit into hierarchy
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteID
Table Cell (td)
————
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
UTM
Table Cell (td)
Place Authority: Place coordinates ?
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
VillageCorporation
Table Cell (td)
————
Table Cell (td)
Table Cell (td)
aligncenter
merge with TMS.CulturalRegion
Table Cell (td)
aligncenter
no
Table Cell (td)
————
Table Cell (td)
only 1 entry
Table Row (tr)
Table Cell (td)
SiteObjXrefs
tr
Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

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

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

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

Table Row (tr)
Table Cell (td)
tr

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)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
ReferenceID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Remarks
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteID
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
Sites
tr
Table Cell (td)
Active
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)
—?—
Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Description
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
HistoricalNotes
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
IsPublic
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)
—?—
Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LocationNotes
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

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

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

Table Cell (td)
Remarks
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ResearchActivity
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
ResearcherComments
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteClassificationID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteName
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteNumber
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)
can prob. merge with SiteName
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteStatusID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SiteTypeID
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
SysTimeStamp
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
————
Table Cell (td)
————
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
SiteStatuses
tr
Table Cell (td)
SiteStatus
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
TermMasterGeo
tr
Table Cell (td)
EnteredDate
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
————
Table Cell (td)
aligncenter
no
Table Cell (td)
—?—
Table Cell (td)
Only if useful for versioning context.
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Latitude
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LatitudeDirection
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LatitudeNumber
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LoginID
Table Cell (td)
—?—
td
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

Table Cell (td)
Longitude
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LongitudeDirection
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
LongitudeNumber
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
TermMasterID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
TextEntries
tr
Table Cell (td)
AuthorConID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

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

Table Cell (td)
LoginID
Table Cell (td)
—?—
Table Cell (td)
Table Cell (td)
aligncenter
no
Table Cell (td)
aligncenter
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)
tr

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

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

Table Cell (td)
Purpose
td
Table Cell (td)

Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
Remarks
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)

Table Row (tr)
Table Cell (td)
tr

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

Table Cell (td)
aligncenter

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

Table Cell (td)
TextEntry
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TextTypeID=0
Table Cell (td)
(not assigned)
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)

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

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TextTypeID=1
Table Cell (td)
Object/Provenience Comment
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)

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

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TextTypeID=8
Table Cell (td)
NAGPRA Concord Comment
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)

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

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TextTypeID=14
Table Cell (td)
Some site names, some site notes
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)

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

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TextTypeID=45
Table Cell (td)
Object Use Site
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)

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

Table Cell (td)
aligncenter

Table Cell (td)
WHERE TextTypeID=46
Table Cell (td)
Provenience comments
Table Row (tr)
Table Cell (td)
tr

Table Cell (td)
TextStatusID
Table Cell (td)

Table Cell (td)
Table Cell (td)
aligncenter

Table Cell (td)
aligncenter

Table Cell (td)

Table Cell (td)
tr