...
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 | CLEAN |
|
| 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 alternate culture groups handled in CSpace? |
|
|
|
|
| FirstName | how are alternate person names handled in CSpace? |
|
|
|
|
| Institution | how are alternate organization names handled in CSpace? |
|
|
|
|
| LastName | how are alternate person names handled in CSpace? |
|
|
|
|
| MiddleName | how are alternate person names handled in CSpace? |
|
|
|
|
| NameTitle | how are alternate person names handled in CSpace? |
|
|
|
|
| NameType |
|
|
|
|
|
| Position | how are alternate positions handled in CSpace? |
|
|
|
|
| Remarks |
|
|
|
|
|
| Suffix | how are 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 = 1 |
|
|
|
| AlphaSort | can be ignored? |
|
|
| replaced by CSpace functionality? |
| Approved | ignore? |
|
|
|
|
| BeginDate | Name Authority Schema:Person Information:Person's birth date | WHERE ConstituentTypeID = 1 |
|
|
|
|
| Name Authority Schema:Person Information:Organization's founding date | WHERE ConstituentTypeID <> 1 | CLEAN |
|
|
| Biography | Name Authority Schema:Person Information:Person's biographical note | WHERE ConstituentTypeID = 1 | CLEAN |
|
|
|
| Name Authority Schema:Person Information:Organization's history | WHERE ConstituentTypeID <> 1 | CLEAN |
|
|
| 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 = ___ |
|
|
|
| EnteredDate | where? |
|
|
|
|
| FirstName | Name Authority Schema:Person Information:Person's forenames | WHERE ConstituentTypeID = ___ |
|
| will be concatenated with middle name |
| Institution |
| WHERE ConstituentTypeID = ___ |
|
|
|
|
|
| WHERE ConstituentTypeID = ___ |
|
|
|
| LastName | Name Authority Schema:Person Information:Person's surname | WHERE ConstituentTypeID = ___ |
|
|
|
| LoginID | where? |
|
|
|
|
| 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 = ___ 1) |
|
|
|
| MTB_DeathPlace | Name Authority Schema:Person Information:Person's death date | (WHERE ConstituentTypeID = ___ 1) |
|
|
|
| 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 |
|
|
|
|
|
| SysTimeStamp | where? |
|
|
|
|
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 |
|
|
|
|
|