TMS to CSpace Cataloging crosswalk
| AltNums | AltNum | Object Identification Information:Other number | no | |||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| Object identification information:Object name | WHERE TableID=108, use as FK to Objects.ObjectID to get object info. | Import as non-primary repeating group, with (Object name type="Alternate") | ||||
| LoginID | —?— | 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. | |
| Remarks | • Custom field needed? | |||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| ———— | WHERE TableID=108, use as FK to Objects.ObjectID to get object info. | |||||
| ———— | WHERE TableID=108, use as FK to Objects.ObjectID to get object info. | |||||
| LoginID | —?— | 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. | |
| WHERE TableID=108 | Is this parent (ID__) the primary parent object? | |||||
| RelationshipID | use as FK to Relationships.Relationship | |||||
| Remarks | Can CSpace handle free associations between objects (and other entities besides accessions?) | |||||
| TableID | ———— | ———— | ———— | used with ID1 (above) | ||
| AuditTrail | Approvals | —?— | —?— | Only if useful for attribution and/or versioning info. | ||
| ColumnName | —?— | Only if useful for versioning context. | ||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| Explanation | —?— | —?— | Only if useful for versioning context. | |||
| LoginID | —?— | 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. | |
| ModuleID | —?— | use as FK to ____ | Only if useful for versioning context. | |||
| NewValue | —?— | —?— | Only if useful for versioning context. | |||
| OldValue | —?— | —?— | Only if useful for versioning context. | |||
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| TableName | —?— | Only if useful for versioning context. | ||||
| HistObjXrefs | EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. |
| HistEventID | ||||||
| LoginID | —?— | 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. | |
| Remarks | ||||||
| Subevent1 | ||||||
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| InsurancePolicies | EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. |
| LoginID | —?— | 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. | |
| Dynasty | ||||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| Flag1 | What is this? Two values: “0” (646886) and “1” (732) | |||||
| Flag2 | What is this? Two values: “0” (647605) and “1” (13) | |||||
| Integer1 | ||||||
| Integer2 | ||||||
| Integer3 | ||||||
| Integer4 | ||||||
| LoginID | —?— | 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. | |
| LongText1 | ||||||
| LongText2 | ||||||
| LongText3 | ||||||
| LongText4 | ||||||
| LongText5 | ||||||
| LongText6 | ||||||
| LongText7 | ||||||
| LongText8 | ||||||
| LongText9 | ||||||
| LongText10 | ||||||
| N_CuratorRemarks | ||||||
| N_Description | ||||||
| N_Inscription | ||||||
| N_Markings | ||||||
| N_Name | ||||||
| N_Notes | ||||||
| N_Title | ||||||
| School | ||||||
| ShortText1 | ||||||
| ShortText2 | ||||||
| ShortText3 | ||||||
| ShortText4 | ||||||
| ShortText5 | ||||||
| ShortText6 | ||||||
| ShortText7 | ||||||
| ShortText8 | ||||||
| ShortText9 | ||||||
| ShortText10 | ||||||
| Style | ||||||
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| ObjDates | DateBegSearch | 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=” secondary collection date” | ||||
| Object collection information: Field collection date: date information: Date - earliest/single (part: year) | 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 | |||||
| DateEndSearch | Object collection information: Field collection date: date information: Date - latest (part: year) | Needs cleaning | WHERE EventType=” Date Collected” | |||
| Object collection information: Field collection date: date information: Date - latest (part: year) | Needs cleaning | WHERE EventType=”secondary collection date” | ||||
| Object collection information: Field collection date: date information: Date - latest (part: year) | 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 | |||||
| DateText | 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 | |||||
| DayBegSearch | Object collection information: Field collection date: date information: Date - earliest/single (part: day) | Needs cleaning | WHERE EventType=”Date Collected” | |||
| Object collection information: Field collection date: date information: Date - earliest/single (part: day) | Needs cleaning | WHERE EventType=” secondary collection date” | ||||
| Object collection information: Field collection date: date information: Date - earliest/single (part: day) | 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 | |||||
| DayEndSearch | Object collection information: Field collection date: date information: Date - latest (part: day) | Needs cleaning | WHERE EventType=” Date Collected” | |||
| Object collection information: Field collection date: date information: Date - latest (part: day) | Needs cleaning | WHERE EventType=”secondary collection date” | ||||
| Object collection information: Field collection date: date information: Date - latest (part: day) | 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 | |||||
| EnteredDate | —?— | ———— | 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. | ||
| EventType | Object collection information: Field collection date: date information: Date - association | change to “collection date” | WHERE EventType=” Date Collected” | |||
| 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 | |||||
| LoginID | —?— | no | no | WHERE EventType=”Date Collected”: 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. | |
| —?— | no | no | WHERE EventType=”secondary collection date”: 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. | ||
| —?— | no | no | WHERE EventType=”tertiary collection date”: 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. | ||
| —?— | no | no | WHERE EventType=”date made”: 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. | ||
| —?— | no | no | WHERE EventType=”minting”: 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. | ||
| —?— | no | no | WHERE EventType=”ruler date”: 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. | ||
| —?— | no | no | WHERE EventType=”material date”: 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. | ||
| —?— | no | no | WHERE EventType=”patent date”: 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. | ||
| —?— | no | no | WHERE EventType=”conservation date”: 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. | ||
| —?— | no | no | WHERE EventType=”recatalogued date”: 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. | ||
| —?— | no | no | WHERE EventType=”destruction date”: 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. | ||
| —?— | no | no | WHERE EventType=”deaccession date”: 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. | ||
| —?— | no | no | WHERE EventType=”date used”: 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. | ||
| —?— | no | no | WHERE EventType=”date received”: 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. | ||
| —?— | no | no | WHERE EventType=”accessioned”: 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. | ||
| —?— | no | no | WHERE EventType=”published”: 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. | ||
| —?— | no | no | WHERE EventType=”immured”: 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. | ||
| —?— | no | no | WHERE EventType=”mounted”: 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. | ||
| —?— | no | no | WHERE EventType=”date photographed”: 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. | ||
| —?— | no | no | WHERE EventType=”date of analysis”: 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. | ||
| —?— | no | no | WHERE EventType=”date missing”: 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. | ||
| —?— | no | no | WHERE EventType=”agency mail date”: 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. | ||
| —?— | no | no | WHERE EventType=”[not entered]”: 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. | ||
| —?— | no | no | WHERE EventType IS NULL: 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. | ||
| MonthBegSearch | Object collection information: Field collection date: date information: Date - earliest/single (part: month) | Needs cleaning | WHERE EventType=”Date Collected” | |||
| Object collection information: Field collection date: date information: Date - earliest/single (part: month) | Needs cleaning | WHERE EventType=” secondary collection date” | ||||
| Object collection information: Field collection date: date information: Date - earliest/single (part: month) | 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 | |||||
| MonthEndSearch | Object collection information: Field collection date: date information: Date - latest (part: month) | Needs cleaning | WHERE EventType=”Date Collected” | |||
| Object collection information: Field collection date: date information: Date - latest (part: month) | Needs cleaning | WHERE EventType=”secondary collection date” | ||||
| Object collection information: Field collection date: date information: Date - latest (part: month) | 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 | |||||
| Remarks | • 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 | |||||
| SysTimeStamp | —?— | ———— | ———— | 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. | ||
| ObjectNames | Active | —?— | —?— | |||
| DisplayOrder | ||||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| LanguageID | ||||||
| LoginID | —?— | 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. | |
| ObjectName | ||||||
| ObjectNameTypeID | ||||||
| Remarks | ||||||
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| Objects | Bibliography | |||||
| Cataloguer | no | no | use as FK to ____ | Map to constituents | ||
| CatRais | ||||||
| ClassificationID | ||||||
| CreditLine | move elsewhere | Primarily info about memorial gifts | ||||
| Curator | ||||||
| CuratorApproved | ||||||
| CuratorialRemarks | ||||||
| _____:Accession date | WHERE IsVirtual=1 AND IsTemplate=0 AND ObjectNumber LIKE ?Acc.%? | verify | ||||
| DepartmentID | ||||||
| Description | Object Identification Information:Brief description | |||||
| DimensionRemarks | ||||||
| Dimensions | needs lots of work (ideally parsing to Dimensions table) | Can be either a denormalized, formulated expression of parsed dimensions already present in DimItemElemXrefs/Dimensions, or can be a free-text entry of data not entered elsewhere | ||||
| Edition | ||||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| Exhibitions | Should be merely a denormalized, formulated expression of exhibits featuring this object | |||||
| HistAttributions | ||||||
| Inscribed | ||||||
| LoginID | —?— | 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. | |
| Markings | Object Identification Information:Distinguishing features | Most of the entries seem to be about specific marks/markings on object, but not all. Is a mention of a single usually distinctive mark/marking the same as a statement of distinguishing features? I don?t think so, but it?s a start. | ||||
| Medium | Object description information:Material | |||||
| MTB_ObjectName | Object Identification Information:Object name | An attempt to regularize object names | ||||
| MTB_ObjectNameState | Object Identification Information:Object name ? | To be concatenated with MTB_ObjectName to produce a display object name | ||||
| Notes | Object Identification Information:Comments | Will often need to be concatenated with other fields | ||||
| ObjectCount | Object Identification Information:Number of objects | NB: There is also an inventoried object count that will need to be included somehow/somewhere | ||||
| ObjectID | Alt number? | ———— | ———— | ———— | Do not import — use as PK for table | |
| ObjectLevelID | ||||||
| ObjectName | Object Identification Information:Object name | WHERE O.IsVirtual=0 AND IsTemplate=0 | There are also object names coming from ObjectNames:ObjectName | |||
| ObjectNameAltID | ||||||
| ObjectNameID | ||||||
| ObjectNumber | _____:Acquisition reference number | WHERE IsVirtual=1 AND IsTemplate=0 AND ObjectNumber LIKE ?Acc.%? | ||||
| Object Identification Information:Object number | WHERE IsVirtual=0 AND IsTemplate=0 | |||||
| ObjectScreenID | ||||||
| ObjectStatusID | ||||||
| ObjectTypeID | ||||||
| OnView | ||||||
| Portfolio | ||||||
| PubReferences | ||||||
| Signed | ||||||
| State | 1.0 | import as controlled list | NAGPRA burial association code | |||
| SubClassID | ||||||
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| TextSearchID | ||||||
| Title | Object Identification Information:Title | WHERE IsVirtual=0 AND IsTemplate=0 | NB: There may also be a title coming from ObjTitles | |||
| UserNumber1 | ||||||
| UserNumber2 | ||||||
| UserNumber3 | ||||||
| ObjInsurance | AppraiserID | |||||
| Code | ||||||
| CurrencyID | ||||||
| CurrencyRate2 | ||||||
| CurrencyValue | ||||||
| DealerPrice | ||||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| FrameCurrencyPrice | ||||||
| FrameMountPrice | ||||||
| LoginID | —?— | 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. | |
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| ValuationPurposeID | ||||||
| Value | ||||||
| ValueISODate | ||||||
| ValueNotes | ||||||
| ObjTitles | Active | —?— | —?— | |||
| DisplayOrder | ||||||
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| LanguageID | ||||||
| LoginID | —?— | 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. | |
| Remarks | ||||||
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| Title | ||||||
| TitleTypeID | ||||||
| ObjUserFields | EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. |
| FieldTypeID | use as FK to UserFieldTypes.____ to get UserFieldType | make into controlled list? | ||||
| FieldValue | Custom field needed? ("Data Error") | WHERE FieldTypeID=10 | 4844 records marked "DUP_ERR": useful info, or outdated? | |||
| Custom field needed? ("Control Possible") | WHERE FieldTypeID=11 | 11310 records with either "0"(11085) or "1"(225) | ||||
| Custom field needed? (\NAGPRA HSR] "Phase Completed") | WHERE FieldTypeID=12 | 1038 records with either "1"(641) or "2"(397). Useful info, or outdated? | ||||
| Custom field: "Photo roll" | WHERE FieldTypeID=13 | 737 records with values, often multiple-valued | ||||
| Custom field needed? ("Axes Orient/clock: Reverse") | WHERE FieldTypeID=14 | 121 records with time-like values: 8:00, 12:00, etc. Useful info, or outdated? | ||||
| Custom field: "CD ID" | WHERE FieldTypeID=15 | What is this? 27449 records with values, so should migrate, even if not sure what it indicates | ||||
| Custom field: "File Code" | WHERE FieldTypeID=17 | 12220 string values indicating the primary intended use of an ethnographic object (from a controlled list) | ||||
| Custom field: "ACC File Code" | WHERE FieldTypeID=19 | 349 string values indicating the ___________ (some are multiple-valued) | ||||
| LoginID | —?— | 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. | |
| SysTimeStamp | —?— | ———— | ———— | ———— | Only if useful for versioning context. | |
| EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
| WHERE TableID=94, use as FK to ObjComponents.ComponentID | ||||||
| WHERE TableID=108, use as FK to Objects.ObjectID to get object info. | ||||||
| WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info. | ||||||
| ———— | yes | WHERE TextTypeID NOT IN (19,20,22,78) | mistake if TextTypeID=193850 ? | |||
| MTB_Inscription | Object Description Information:Inscription content | WHERE TextTypeID IN (19,20,22,78) | For unicode inscriptions | |||
| ———— | yes | WHERE TextTypeID NOT IN (19,20,22,78) | mistake if TextTypeID=193850 ? | |||
| MTB_InscriptionMethod | Object Description Information:Inscription content:Inscription method | WHERE TextTypeID IN (19,20,22,78) | ||||
| ———— | ———— | WHERE TextTypeID NOT IN (19,20,22,78) | clean as of 2011-01-18 | |||
| MTB_InscriptionPosition | Object Description Information:Inscription content:Inscription position | WHERE TextTypeID IN (19,20,22,78) | ||||
| ———— | ———— | WHERE TextTypeID NOT IN (19,20,22,78) | clean as of 2011-01-18 | |||
| MTB_Interpretation | Object Description Information:Inscription content:Inscription interpretation | WHERE TextTypeID IN (19,20,22,78) | ||||
| ———— | ———— | WHERE TextTypeID NOT IN (19,20,22,78) | clean as of 2011-01-18 | |||
| MTB_Language | Object Description Information:Inscription content:Inscription language | WHERE TextTypeID IN (19,20,22,78) | ||||
| ———— | yes | WHERE TextTypeID NOT IN (19,20,22,78) | mistake if TextTypeID=193850 | |||
| MTB_Notes | ||||||
| MTB_Script | Object Description Information:Inscription content:Inscription script | WHERE TextTypeID IN (19,20,22,78) | is currently empty, but should map | |||
| ———— | as of 2011-01-18 | WHERE TextTypeID NOT IN (19,20,22,78) | is currently empty, but should map | |||
| MTB_Translation | Object Description Information:Inscription content:Inscription translation | WHERE TextTypeID IN (19,20,22,78) | mistake if TextTypeID=193850 | |||
| ———— | yes | WHERE TextTypeID NOT IN (19,20,22,78) | ||||
| MTB_Transliteration | Object Description Information:Inscription content:Inscription transliteration | WHERE TextTypeID IN (19,20,22,78) | mistake if TextTypeID=193850 | |||
| ———— | yes | WHERE TextTypeID NOT IN (19,20,22,78) | ||||
| ———— | check | WHERE TextTypeID NOT IN (19,20,22,78) | ||||
| Object Description Information:Inscription content | WHERE TextTypeID IN (19,20,22,78) | why is this different from MTB_Inscription? | ||||
| WHERE TextTypeID=2 | NSF Grant Osteology Data | |||||
| WHERE TextTypeID=5 | Curation modification notes | |||||
| WHERE TextTypeID=6 | NAGPRA artifact description | |||||
| WHERE TextTypeID=7 | NAGPRA faunal remains description | |||||
| WHERE TextTypeID=10 | Materials Found with HSR | |||||
| WHERE TextTypeID=11 | NAGPRA cultural modification notes | |||||
| WHERE TextTypeID=12 | Attributions | |||||
| WHERE TextTypeID=13 | Collection Type | |||||
| WHERE TextTypeID=16 | Coin: Minting | |||||
| WHERE TextTypeID=17 | Coin: obverse type | |||||
| WHERE TextTypeID=18 | Coin: reverse type | |||||
| WHERE TextTypeID=21 | Catalog card information | |||||
| WHERE TextTypeID=23 | Alternate object description | |||||
| WHERE TextTypeID=24 | Original Ledger Comments | |||||
| WHERE TextTypeID=25 | NAGPRA Bioevaluation Data | |||||
| (storage location) | WHERE TextTypeID=26 | NAGPRA location comment | ||||
| WHERE TextTypeID=27 | General object comment | |||||
| WHERE TextTypeID=28 | NAGPRA updated curation summary | |||||
| WHERE TextTypeID=29 | NAGPRA research comments | |||||
| WHERE TextTypeID=30 | Data Entry Remarks | |||||
| WHERE TextTypeID=31 | Ledger Redline Data | |||||
| WHERE TextTypeID=32 | Culture Note | |||||
| WHERE TextTypeID=33 | Culture groups on Tape | |||||
| WHERE TextTypeID=36 | Special Collection | |||||
| WHERE TextTypeID=37 | Probable Materials | |||||
| WHERE TextTypeID=38 | Fabrication technology | |||||
| WHERE TextTypeID=39 | [NAGPRA correspondance]: outgoing | |||||
| WHERE TextTypeID=40 | [NAGPRA correspondance]: incoming | |||||
| WHERE TextTypeID=44 | Inventory Remarks | |||||
| Object collection information: Field collection note | WHERE TextTypeID=46 | Provenience comments | ||||
| WHERE TextTypeID=49 | NAGPRA cultural determination | |||||
| WHERE TextTypeID=50 | NAGPRA cover text | |||||
| WHERE TextTypeID=51 | NAGPRA background statement | |||||
| WHERE TextTypeID=53 | [NAGPRA] boiler plate | |||||
| WHERE TextTypeID=54 | [NAGPRA] synopsis | |||||
| WHERE TextTypeID=55 | Verbatim Ledger | |||||
| WHERE TextTypeID=56 | Accession Envelope | |||||
| WHERE TextTypeID=57 | Comment | |||||
| Object collection information: Field collection note | WHERE TextTypeID=58 | Locality | ||||
| WHERE TextTypeID=63 | Deaccession Comments | |||||
| WHERE TextTypeID=64 | Researcher Comments | |||||
| WHERE TextTypeID=65 | NAGPRA background statement | |||||
| WHERE TextTypeID=66 | NAGPRA archaeological evidence | |||||
| WHERE TextTypeID=67 | NSF recataloging data | |||||
| WHERE TextTypeID=68 | Registration Remark | |||||
| WHERE TextTypeID=69 | Study Collection Note | |||||
| WHERE TextTypeID=70 | Curator Tim White evaluation | |||||
| WHERE TextTypeID=71 | Research: destructive sample comments | |||||
| WHERE TextTypeID=72 | Supplemental Information | |||||
| WHERE TextTypeID=73 | Current Condition | |||||
| WHERE TextTypeID=74 | Coin: denomination | |||||
| WHERE TextTypeID=75 | Literature | |||||
| WHERE TextTypeID=76 | Researcher's note | |||||
| TextTypeID | ||||||
| Object Description Information:Inscription content:Inscription type | "Reverse legend" (WHERE TextTypeID=19) | |||||
| "Obverse legend" (WHERE TextTypeID=20) | ||||||
| "Reverse exergue" (WHERE TextTypeID=22) |