Comment:
Migration of unmigrated content due to installation of a new plugin
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}
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)
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