Table | Columns | CSpace destination | Cleaned? | Migrated? | Mapping | Notes |
---|---|---|---|---|---|---|
BeginISODate | • Custom field needed? | |||||
Associations | ||||||
| no | |||||
| no | |||||
| no | |||||
Custom field needed? | ||||||
Custom field needed? | ||||||
ConDates | ||||||
use as FK to Constituents.ConstituentID to get person info. | ||||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. | |
—?— |
| no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. | |
Name Authority: Person information: Person's birth date |
| no | WHERE ConstituentTypeID=1 | |||
Name Authority: Person information: Person's death date | WHERE ConstituentTypeID=1 | |||||
Exhibitions | ||||||
(research & class visits) | ||||||
(research & class visits) | ||||||
(research & class visits) | ||||||
(research & class visits) | ||||||
Cataloging:Object History and Association Information:Associated event name (verify) |
| may need to add "reign of" or other context | no | |||
ObjContext | ||||||
Cataloging:Object History and Association Information:Associated date note |
| may need to add "reign of" or other context | no | |||
ObjDates | ||||||
Object collection information: Field collection date: date information: Date - earliest/single (part: year) |
| Needs cleaning |
WHERE EventType="Date Collected" | |||
Object collection information: Field collection date: date information: Date - earliest/single (part: year) |
| Needs cleaning | WHERE EventType=" | |||
Object collection information: Field collection date: date information: Date - earliest/single (part: year) |
| Needs cleaning | WHERE EventType="tertiary | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
Object collection information: Field collection date: date information: Date - latest (part: year) |
| Needs cleaning | WHERE EventType=" | |||
Object collection information: Field collection date: date information: Date - latest (part: year) |
| Needs cleaning | WHERE EventType="secondary | |||
Object collection information: Field collection date: date information: Date - latest (part: year) |
| Needs cleaning | WHERE EventType="tertiary collection | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
Object collection information: Field collection date: date information: Date text |
| Needs cleaning | WHERE EventType="Date Collected" | |||
Object collection information: Field collection date: date information: Date text |
| Needs cleaning | WHERE EventType="secondary collection date" | |||
Object collection information: Field collection date: date information: Date text |
| Needs cleaning | WHERE EventType="tertiary collection date" | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
Object collection information: Field collection date: date information: Date - earliest/single (part: day) |
| Needs cleaning | WHERE | |||
Object collection information: Field collection date: date information: Date - earliest/single (part: day) |
| Needs cleaning | WHERE EventType=" | |||
Object collection information: Field collection date: date information: Date - earliest/single (part: day) |
| Needs cleaning | WHERE EventType="tertiary | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
Object collection information: Field collection date: date information: Date - latest (part: day) |
| Needs cleaning | WHERE EventType=" | |||
Object collection information: Field collection date: date information: Date - latest (part: day) |
| Needs cleaning | WHERE EventType="secondary | |||
Object collection information: Field collection date: date information: Date - latest (part: day) |
| Needs cleaning | WHERE EventType="tertiary collection | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
—?— |
| ———— | no | WHERE EventType="Date Collected" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="secondary collection date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="tertiary collection date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="date made" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="minting" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="ruler date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="material date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="patent date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="conservation date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="recatalogued date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="destruction date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="deaccession date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="date used" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="date received" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="accessioned" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="published" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="immured" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="mounted" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="date photographed" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="date of analysis" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="date missing" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="agency mail date" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType="[not entered]" | Only if useful for versioning context. | |
—?— |
| ———— | no | WHERE EventType IS NULL | Only if useful for versioning context. | |
Object collection information: Field collection date: date information: Date - association |
| change to "collection date" | WHERE EventType=" | |||
Object collection information: Field collection date: date information: Date - association | WHERE EventType="secondary collection date" | |||||
Object collection information: Field collection date: date information: Date - association | WHERE EventType="tertiary collection date" | |||||
| change to "manufacture date" ? | WHERE EventType="date made" | ||||
| change to "mint date" | WHERE EventType="minting" | ||||
WHERE EventType="ruler date" | ||||||
WHERE EventType="material date" | ||||||
WHERE EventType="patent date" | ||||||
| change to "treatment date" ? | WHERE EventType="conservation date" | ||||
| change to "recataloging date" | WHERE EventType="recatalogued date" | ||||
WHERE EventType="destruction date" | ||||||
WHERE EventType="deaccession date" | ||||||
WHERE EventType="date used" | ||||||
WHERE EventType="date received" | ||||||
| change to "accession date" ? | WHERE EventType="accessioned" | ||||
| change to "publication date" | WHERE EventType="published" | ||||
WHERE EventType="immured" | ||||||
WHERE EventType="mounted" | ||||||
WHERE EventType="date photographed" | ||||||
WHERE EventType="date of analysis" | ||||||
WHERE EventType="date missing" | ||||||
WHERE EventType="agency mail date" | ||||||
| parse, if possible | WHERE EventType="[not entered]" | ||||
| parse, if possible | WHERE EventType IS NULL | ||||
—?— |
| no | no | WHERE EventType="Date Collected": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="secondary collection date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="tertiary collection date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="date made": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="minting": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="ruler date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="material date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="patent date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="conservation date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="recatalogued date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="destruction date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="deaccession date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="date used": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="date received": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="accessioned": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="published": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="immured": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="mounted": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="date photographed": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="date of analysis": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="date missing": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="agency mail date": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType="[not entered]": use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents. | Only if useful for attribution content. | |
—?— |
| no | no | WHERE EventType IS NULL: use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get | Only if useful for attribution content. | |
Object collection information: Field collection date: date information: Date - earliest/single (part: month) |
| Needs cleaning | WHERE | |||
Object collection information: Field collection date: date information: Date - earliest/single (part: month) |
| Needs cleaning | WHERE EventType=" | |||
Object collection information: Field collection date: date information: Date - earliest/single (part: month) |
| Needs cleaning | WHERE EventType="tertiary | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
Object collection information: Field collection date: date information: Date - latest (part: month) |
| Needs cleaning | WHERE | |||
Object collection information: Field collection date: date information: Date - latest (part: month) |
| Needs cleaning | WHERE EventType="secondary | |||
Object collection information: Field collection date: date information: Date - latest (part: month) |
| Needs cleaning | WHERE EventType="tertiary | |||
| Needs cleaning | WHERE EventType="date made" | ||||
| Needs cleaning | WHERE EventType="minting" | ||||
| Needs cleaning | WHERE EventType="ruler date" | ||||
| Needs cleaning | WHERE EventType="material date" | ||||
| Needs cleaning | WHERE EventType="patent date" | ||||
| Needs cleaning | WHERE EventType="conservation date" | ||||
| Needs cleaning | WHERE EventType="recatalogued date" | ||||
| Needs cleaning | WHERE EventType="destruction date" | ||||
| Needs cleaning | WHERE EventType="deaccession date" | ||||
| Needs cleaning | WHERE EventType="date used" | ||||
| Needs cleaning | WHERE EventType="date received" | ||||
| Needs cleaning | WHERE EventType="accessioned" | ||||
| Needs cleaning | WHERE EventType="published" | ||||
| Needs cleaning | WHERE EventType="immured" | ||||
| Needs cleaning | WHERE EventType="mounted" | ||||
| Needs cleaning | WHERE EventType="date photographed" | ||||
| Needs cleaning | WHERE EventType="date of analysis" | ||||
| Needs cleaning | WHERE EventType="date missing" | ||||
| Needs cleaning | WHERE EventType="agency mail date" | ||||
| Needs cleaning | WHERE EventType="[not entered]" | ||||
| Needs cleaning | WHERE EventType IS NULL | ||||
• Schema extension/ custom field needed? |
| is ok? | WHERE EventType="Date Collected" | |||
• Schema extension/ custom field needed? |
| is ok? | WHERE EventType="secondary collection date" | |||
• Schema extension/ custom field needed? |
| is ok? | WHERE EventType="tertiary collection date" | |||
| is ok? | WHERE EventType="date made" | ||||
| is ok? | WHERE EventType="minting" | ||||
| is ok? | WHERE EventType="ruler date" | ||||
| is ok? | WHERE EventType="material date" | ||||
| is ok? | WHERE EventType="material date" | ||||
| is ok? | WHERE EventType="conservation date" | ||||
| is ok? | WHERE EventType="recatalogued date" | ||||
| is ok? | WHERE EventType="destruction date" | ||||
| is ok? | WHERE EventType="deaccession date" | ||||
| is ok? | WHERE EventType="date used" | ||||
| is ok? | WHERE EventType="date received" | ||||
| is ok? | WHERE EventType="accessioned" | ||||
| is ok? | WHERE EventType="published" | ||||
| is ok? | WHERE EventType="immured" | ||||
| is ok? | WHERE EventType="mounted" | ||||
| is ok? | WHERE EventType="date photographed" | ||||
| is ok? | WHERE EventType="date of analysis" | ||||
| is ok? | WHERE EventType="date missing" | ||||
| is ok? | WHERE EventType="agency mail date" | ||||
| is ok? | WHERE EventType="[not entered]" | ||||
| is ok? | WHERE EventType IS NULL | ||||
—?— |
| ———— | ———— | WHERE EventType="Date Collected" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="secondary collection date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="tertiary collection date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="date made" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="minting" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="ruler date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="material date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="material date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="conservation date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="recatalogued date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="destruction date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="deaccession date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="date used" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="date received" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="accessioned" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="published" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="immured" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="mounted" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="date photographed" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="date of analysis" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="date missing" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="agency mail date" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType="[not entered]" | Only if useful for versioning context. | |
—?— |
| ———— | ———— | WHERE EventType IS NULL | Only if useful for versioning context. | |
_____:Acquisition date |
| Many different date types — needs parsing | verify | |||
WHERE DateOut <> '12/31/9999' | If DateOut = "12/31/9999", it means that the component is still at this location | |||||
RefDates | ||||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. | |
—?— |
| no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. | |
SiteDates | ||||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. | |
—?— |
| no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
—?— |
| ———— | ———— | ———— | Only if useful for versioning context. | |
TermMasterDates | ||||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. | |
—?— |
| no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
Object Description Information:Inscription content:Inscription date | WHERE TextTypeID IN (19,20,22,78) | note possible overlap with | ||||
———— |
| yes | WHERE TextTypeID NOT IN (19,20,22,78) | mistake if TextTypeID=193850 ? | ||
———— |
| check | WHERE TextTypeID NOT IN (19,20,22,78) | |||
TMTypeXrefDates | ||||||
—?— |
| ———— | no | —?— | Only if useful for versioning context. | |
—?— |
| no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
Manage space
Manage content
Integrations