...
Table | Columns | CSpace destination schema | Mapping | Cleaning needed? | Migrated ? | Notes | ||||
---|---|---|---|---|---|---|---|---|---|---|
AltNums | AltNum | Cataloging:Object Identification Information:Other number |
|
|
|
| ||||
| BeginISODate | custom field? |
|
|
|
| ||||
| Description | Cataloging:Object Identification Information:Other number type |
|
|
| Cleaned free-text field masquerading as a controlled vocabulary | ||||
| Remarks | custom field? |
|
|
|
| ||||
Associations | DateBegin |
|
|
|
| Can CSpace handle free associations between objects (and other entities besides accessions?) | ||||
| DateEnd |
|
|
|
|
| ||||
| DisplayDate |
|
|
|
|
| ||||
| ID1 |
|
|
|
|
| ||||
| ID2 |
|
|
|
|
| ||||
| PrimaryParent |
|
|
|
|
| ||||
| Remarks |
|
|
|
|
| ||||
AuditTrail | Approvals | where? |
|
|
|
| ||||
| ColumnName | where? |
|
|
|
| ||||
| Explanation | where? |
|
|
|
| ||||
| LoginID | where? |
|
|
|
| ||||
| NewValue | where? |
|
|
|
| ||||
| ObjectID | where? |
|
|
|
| ||||
| OldValue | where? |
|
|
|
| ||||
| TableName | where? |
|
|
|
| ||||
ColThesXrefs | DisplayOrder |
|
|
|
| prob. not—just specifies which fields must use which CV | ||||
| DisplayText |
|
|
|
|
| ||||
| Include |
|
|
|
|
| ||||
| ModifiedBy |
|
|
|
|
| ||||
| ModifiedDate |
|
|
|
|
| ||||
ConAddress | Active | where? |
|
|
|
| ||||
| BeginDate | custom field? |
|
|
|
| ||||
| City | Name Authority Schema:Contact Information:Address - city/town/municipality | CLEAN |
|
|
| ||||
| DefaultBilling | Name Authority Schema:Contact Information:Address type |
|
|
|
| ||||
| DefaultMailing | Name Authority Schema:Contact Information:Address type |
|
|
|
| ||||
| DefaultShipping | Name Authority Schema:Contact Information:Address type |
|
|
|
| ||||
| DisplayAddress |
|
|
|
| just reformat of data? | ||||
| DisplayName1 | Name Authority Schema:Contact Information:Address - place1 ? |
|
|
|
| ||||
| DisplayName2 | Name Authority Schema:Contact Information:Address - place1 ? |
|
|
|
| ||||
| EndDate | custom field? |
|
|
|
| ||||
| Rank | custom field? |
|
|
|
| ||||
| Remarks | custom field? |
|
|
|
| ||||
| State | Name Authority Schema:Contact Information:Address - province/territory/state |
|
|
|
| ||||
| StreetLine1 | Name Authority Schema:Contact Information:Address - place1 |
|
|
|
| ||||
| StreetLine2 | Name Authority Schema:Contact Information:Address - place2 |
|
|
| concatenate with next | ||||
| StreetLine3 | Name Authority Schema:Contact Information:Address - place2 |
|
|
| concatenate with previous | ||||
| ZipCode | Name Authority Schema:Contact Information:Address - postcode |
|
|
|
| ||||
ConAltNames | CultureGroup | how are alt alternate culture groups handled in CSpace? |
|
|
|
| ||||
| FirstName | how are alt alternate person names handled in CSpace? |
|
|
|
| ||||
| Institution | how are alt alternate organization names handled in CSpace? |
|
|
|
| ||||
| LastName | how are alt alternate person names handled in CSpace? |
|
|
|
| ||||
| MiddleName | how are alt alternate person names handled in CSpace? |
|
|
|
| ||||
| NameTitle | how are alt alternate person names handled in CSpace? |
|
|
|
| ||||
| NameType |
|
|
|
|
| ||||
| Position | how are alt alternate positions handled in CSpace? |
|
|
|
| ||||
| Remarks |
|
|
|
|
| ||||
| Suffix | how are alt alternate person names handled in CSpace? |
|
|
|
| ||||
ConDates | 8 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
Conditions | 10 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
CondLineItems | 8 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ConEmail | Description | Name Authority Schema:Contact Information:Email type |
|
|
| make into a CV | ||||
| EMailAddress | Name Authority Schema:Contact Information:Email |
|
|
|
| ||||
ConPhones | Description | Name Authority Schema:Contact Information:Telephone number type |
|
|
| make into a CV | ||||
| PhoneNumber | Name Authority Schema:Contact Information:Telephone number |
|
|
|
| ||||
Constituents | Active | Name Authority Schema :Person Information:Term status (verify) | WHERE ConstituentTypeID = ___ |
|
|
| ||||
| AlphaSort | can be ignored? |
|
|
| replaced by CSpace functionality? | ||||
| Approved | ignore? |
|
|
|
| ||||
| BeginDate |
| Name Authority Schema:Person Information:Person's birth date | WHERE ConstituentTypeID = ___ |
|
|
| |||
| Biography |
| Name Authority Schema:Person Information:Person's biographical note | WHERE ConstituentTypeID = ___ |
|
|
| |||
| Code |
|
|
|
|
| ||||
| CultureGroup | Name Authority Schema:Person Information:Person's group | WHERE ConstituentTypeID = ___ |
|
|
| ||||
|
| Name Authority Schema:Organization Information:Organizations's group | WHERE ConstituentTypeID = ___ |
|
|
| ||||
| DisplayDate |
| replaced by CSpace functionality? |
|
|
|
| |||
| DisplayName | replaced by CSpace functionality? |
|
|
|
| ||||
| EndDate | Name Authority Schema:Person Information:Person's death date | WHERE ConstituentTypeID = ___ |
|
|
| ||||
| FirstName | Name Authority Schema:Person Information:Person's forenames | WHERE ConstituentTypeID = ___ |
| FirstName | will be concatenated with middle name | ||||
| Institution |
| WHERE ConstituentTypeID = ___ |
|
|
| ||||
| Institution |
| WHERE ConstituentTypeID = ___ |
|
|
| ||||
| LastName |
| Name Authority Schema:Person Information:Person's surname | WHERE ConstituentTypeID = ___ |
|
|
| |||
| MiddleName |
| Name Authority Schema:Person Information:Person's forenames | WHERE ConstituentTypeID = ___ |
|
| will be concatenated with first name | |||
| MTB_BirthPlace |
| Name Authority Schema:Person Information:Person's birth date | WHERE ConstituentTypeID = ___ |
|
|
| |||
| MTB_DeathPlace | Name Authority Schema:Person Information:Person's death date | WHERE ConstituentTypeID = ___ |
|
|
| ||||
|
|
| MTB_Gender |
| MTB_Gender | Name Authority Schema:Person Information:Person's gender | WHERE ConstituentTypeID = ___ |
|
|
|
| MTB_Occupation |
| Name Authority Schema:Person Information:Person's occupation | WHERE ConstituentTypeID = ___ |
|
|
| |||
| N_DisplayName | _replaced by CSpace functionality? |
|
|
|
| ||||
| N_DisplayDate | replaced by CSpace functionality? |
|
|
|
| ||||
| NameTitle |
| Name Authority Schema:Person Information:Person's title (verify) | WHERE ConstituentTypeID = ___ |
|
|
| |||
| Nationality |
| Name Authority Schema:Person Information:Person's nationality | WHERE ConstituentTypeID = ___ |
|
|
| |||
| [Position] |
|
|
|
|
| ||||
| PublicAccess | can be ignored? |
|
|
|
| ||||
| PublicAccessOld | can be ignored? |
|
|
|
| ||||
| Remarks | Name Authority Schema:Person Information:Person's name notes |
|
|
|
| ||||
| Suffix |
|
|
|
|
| ||||
ConXrefs | Active |
|
|
|
|
| ||||
| Amount |
|
|
|
|
| ||||
| ConStatement |
|
|
|
|
| ||||
| ConstituentID |
| WHERE TableID = 47 |
|
| use as FK for Constituents | ||||
|
|
| WHERE TableID = 81 |
|
| use as FK for Constituents | ||||
|
|
| WHERE TableID = 108 |
|
| use as FK for Constituents | ||||
|
|
| WHERE TableID = 143 |
|
| use as FK for Constituents | ||||
|
|
| WHERE TableID = 187 |
|
| use as FK for Constituents | ||||
|
|
| WHERE TableID = 189 |
|
| use as FK for Constituents | ||||
|
|
| WHERE TableID = 322 |
|
| use as FK for Constituents | ||||
| DateBegin |
|
|
|
|
| ||||
| DateEnd |
|
|
|
|
| ||||
| DisplayDate |
|
|
|
|
| ||||
| DisplayOrder |
|
|
|
|
| ||||
| ID |
| WHERE TableID = 47 |
|
| use as FK for Exhibitions | ||||
|
|
| WHERE TableID = 81 |
|
| use as FK for Loans | ||||
|
|
| WHERE TableID = 108 |
|
| use as FK for Objects | ||||
|
|
| WHERE TableID = 143 |
|
| use as FK for ReferenceMaster | ||||
|
|
| WHERE TableID = 187 |
|
| use as FK for HistEvents | ||||
|
|
| WHERE TableID = 189 |
|
| use as FK for Sites | ||||
|
|
| WHERE TableID = 322 |
|
| use as FK for MediaRenditions | ||||
| Prefix |
|
|
|
|
| ||||
| Remarks |
|
|
|
|
| ||||
| Suffix |
|
|
|
|
| ||||
Crates | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
Dimensions | xxxxxxxxxxx |
|
|
|
| |||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
DimItemElemXrefs | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
Exhibitions | 16 columns |
|
|
|
| |||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ExhObjXrefs | xxxxxxxxxxx |
|
|
|
| |||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ExhVenueXrefs | xxxxxxxxxxx |
|
|
|
| |||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
HistEvents | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
HistObjXrefs | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
LoanObjXrefs | ConservationFee |
|
|
|
|
| ||||
| LenderObjectNumber | WHERE LoanIn = 1 |
|
|
| |||||
| LoanFee | WHERE LoanIn = 0 |
|
| ||||||
| Remarks | WHERE LoanIn = 1 |
|
|
| |||||
|
| WHERE LoanIn = 0 |
|
|
| |||||
Loans | ApprovedBy |
|
|
|
|
| ||||
| ApprovedDate | Loans In Schema:Lender's authorization date | WHERE LoanIn = 1 |
|
|
| ||||
| BeginISODate |
|
|
|
|
| ||||
| Contact |
|
|
|
|
| ||||
| Description |
|
|
|
|
| ||||
| DispBegISODate |
|
|
|
|
| ||||
| DispEndISODate |
|
|
|
|
| ||||
| EndISODate |
|
|
|
|
| ||||
| LoanNumber | Loans Out Schema:Loan out number | WHERE LoanIn = 0 |
|
|
| ||||
|
| Loans In Schema:Loan in number | WHERE LoanIn = 1 |
|
|
| ||||
| OrigLoanEndDate |
|
|
|
|
| ||||
| Remarks | Loans In Schema:Loan in note | WHERE LoanIn = 1 |
|
|
| ||||
| RequestDate |
|
|
|
|
| ||||
| RequestedBy |
|
|
|
|
| ||||
Locations | Active |
|
|
|
| |||||
| Description |
|
|
|
|
| ||||
| LocationString |
|
|
|
|
| ||||
| PublicAccess |
|
|
|
|
| ||||
| Room |
|
|
|
|
| ||||
| RoomOld |
|
|
|
|
| ||||
| SecurityCode |
|
|
|
|
| ||||
| Site |
|
|
|
|
| ||||
| SiteOld |
|
|
|
|
| ||||
| UnitDepthCM |
|
|
|
|
| ||||
| UnitHeightCM |
|
|
|
|
| ||||
| UnitMaxLevels |
|
|
|
|
| ||||
| UnitNumber |
|
|
|
|
| ||||
| UnitPosition |
|
|
|
|
| ||||
| UnitSizeCode |
|
|
|
|
| ||||
| UnitType |
|
|
|
|
| ||||
| UnitWidthCM |
|
|
|
|
| ||||
LocHandlers | Active | Name Authority Schema (verify) |
|
|
|
| ||||
| Handler |
|
|
|
| should not be needed—MTB to parse into NameFull fields | ||||
| MTB_NameFull1 |
|
|
|
|
| ||||
| MTB_NameFull2 |
|
|
|
|
| ||||
| MTB_NameFull3 |
|
|
|
|
| ||||
| MTB_NameFull4 |
|
|
|
|
| ||||
| MTB_NameFull5 |
|
|
|
|
| ||||
| MTB_Notes |
|
|
|
|
| ||||
LoginRecords | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
MediaCounts | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
MediaFiles | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
MediaMaster | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
MediaPaths | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
MediaRenditions | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
MediaXrefs | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjAccession | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjComponents | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjContext | 140 columns | multiple locations (expand) |
|
|
| are some of these FKs? | ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| to be continued |
|
|
|
|
| ||||
ObjDates | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjDeaccession | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjectNames | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjectPackages | xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
Objects | Bibliography | xxxxxxxxxxxx |
|
|
|
| ||||
| CatRais |
|
|
|
|
| ||||
| Curator |
|
|
|
|
| ||||
| CuratorApproved |
|
|
|
|
| ||||
| CuratorialRemarks |
|
|
|
|
| ||||
| DateBegin |
|
|
|
|
| ||||
| Dated | _____:Acquisition date |
|
|
|
| ||||
|
| _____:Accession date | WHERE IsVirtual = 1 AND |
|
|
| ||||
| DateEnd |
|
|
|
|
| ||||
| Description | Cataloging:Object Identification Information:Brief description |
|
|
|
| ||||
| DimensionRemarks |
|
|
|
|
| ||||
| Dimensions |
|
|
|
| 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 |
|
|
|
|
| ||||
| Exhibitions |
|
|
|
| Should be merely a denormalized, formulated expression of exhibits featuring this object | ||||
| HistAttributions |
|
|
|
|
| ||||
| Inscribed |
|
|
|
|
| ||||
| LoanClass |
|
|
|
|
| ||||
| Markings | Cataloging: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 | _____:Material |
|
|
|
| ||||
| Notes | Cataloging:Object Identification Information:Comments |
|
|
| Will often need to be concatenated with other fields | ||||
| ObjectCount | Cataloging:Object Identification Information:Number of objects |
|
|
| NB: There is also an inventoried object count that will need to be included somehow/somewhere | ||||
| ObjectName | Cataloging:Object Identification Information:Object name | WHERE O.IsVirtual = 0 AND |
|
| There are also object names coming from ObjectNames:ObjectName | ||||
| ObjectNumber | _____:Acquisition reference number | WHERE O.IsVirtual = 1 AND |
|
|
| ||||
|
| Cataloging:Object Identification Information:Object number | WHERE O.IsVirtual = 0 AND |
|
|
| ||||
| OnView |
|
|
|
|
| ||||
| PaperFileRef |
|
|
|
|
| ||||
| Portfolio |
|
|
|
|
| ||||
| Provenance |
|
|
|
|
| ||||
| PubReferences |
|
|
|
|
| ||||
| Signed |
|
|
|
|
| ||||
| State |
|
|
|
|
| ||||
| Title | Cataloging:Object Identification Information:Title | WHERE O.IsVirtual = 0 AND |
|
| There may also be a title coming from ObjTitles | ||||
| UserNumber1 |
|
|
|
|
| ||||
| UserNumber2 |
|
|
|
|
| ||||
| UserNumber3 |
|
|
|
|
| ||||
ObjGeography | 8 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjIncoming | 7 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjInsurance | 9 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjPkgList | 3 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjPrep | 2 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjTitles | 4 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ObjUserFields | 1 column | xxxxxxxxxxxx |
|
|
|
| ||||
QuickMoves | 4 columns | Location and Movement Control Schema (verify) |
|
|
| rethink this | ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
RefDates | EventType | xxxxxxxxxxxx |
|
|
|
| ||||
| DateText |
|
|
|
|
| ||||
| DateBegSearch |
|
|
|
|
| ||||
| DateEndSearch |
|
|
|
|
| ||||
ReferenceMaster | 19 columns | xxxxxxxxxxxx |
|
|
| Bibliographic data | ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
RefObjXrefs | 4 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ShipCompXrefs | 2 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ShipConveyances | 6 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
Shipments | 14 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ShipmentSteps | StepNumber | xxxxxxxxxxxx |
|
|
|
| ||||
ShipObjXrefs | 2 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
SiteDates | 9 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
SiteGeography | 24 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
SiteObjXrefs | 5 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
Sites | Active | xxxxxxxxxxxx |
|
|
|
| ||||
| Description |
|
|
|
|
| ||||
| HistoricalNotes |
|
|
|
|
| ||||
| IsPublic |
|
|
|
|
| ||||
| LocationNotes |
|
|
|
|
| ||||
| Remarks |
|
|
|
|
| ||||
| ResearchActivity |
|
|
|
|
| ||||
| ResearcherComments |
|
|
|
|
| ||||
| SiteName |
|
|
|
|
| ||||
| SiteNumber |
|
|
|
| can prob. merge with SiteName | ||||
| SiteSortNumber |
|
|
|
| will CSpace need this? | ||||
StatusFlags | 3 columns | xxxxxxxxxxxx |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
TextEntries | 13 columns | multiple locations (expand) |
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
| xxxxxxxxxxx |
|
|
|
|
| ||||
ThesXrefs | Active | xxxxxxxxxxxx |
|
|
|
| ||||
| DisplayOrder |
|
|
|
|
| ||||
| Remarks |
|
|
|
|
| ||||
| RemovedDate |
|
|
|
|
|