There are several data sources at PAHMA that should be mapped to CSpace:
- TMS (our primary CMS)
- TMS Thesaurus (a repository of hierarchical controlled vocabularies)
- Osteoinformatics (a Filemaker DB containing detailed information on human skeletal remains)
- Sites (a Filemaker DB with GIS information for over 10,000 sites and proveniences)
- Tribes (a Filemaker DB with rich information on native American tribes, including contact information)
TMS
There are 352 tables (comprising 3418 columns) in the PAHMA-TMS instance. Of these 3418 columns:
- 833 columns are empty or essentially empty:
- 781 are empty
- 50 are essentially empty, as they have only a single (meaningless) default value
- 3 are essentially empty, as they have only two (meaningless) default values
- 1604 columns contain internal information needed by the TMS application
- 924 columns contain either primary or foreign keys (some of which probably should be kept)
- 249 columns contain revision dates (which should be migrated as versioning/auditing data)
- 138 columns contain system timestamps (which should be migrated as versioning/auditing data)
- 110 of these are not empty, and so may need to be migrated
Besides those columns with information pertaining to attribution/revision/auditing, there are approximately 662 columns that contain data that will need to be mapped to CollectionSpace. Of these, 389 columns appear to be straight-forward mappings to existing CSpace fields, while the remaining 273 columns have been flagged as being potentially problematic.
Summary of the TMS data to be mapped:
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 |
xxxxxxxxxxxx |
|
|
|
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 |
xxxxxxxxxxxx |
|
|
|
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 |
xxxxxxxxxxxx |
|
|
|
|
|
FirstName |
|
|
|
|
|
|
Institution |
|
|
|
|
|
|
LastName |
|
|
|
|
|
|
MiddleName |
|
|
|
|
|
|
NameTitle |
|
|
|
|
|
|
NameType |
|
|
|
|
|
|
Position |
|
|
|
|
|
|
Remarks |
|
|
|
|
|
|
Suffix |
|
|
|
|
|
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 |
|
|
|
|
|
|
AlphaSort |
can be ignored? |
|
|
|
replaced by CSpace functionality? |
|
Approved |
|
|
|
|
|
|
BeginDate |
|
|
|
|
|
|
Biography |
|
|
|
|
|
|
Code |
|
|
|
|
|
|
CultureGroup |
Name Authority Schema:Person Information:Person's group |
|
|
|
|
|
|
Name Authority Schema:Organization Information:Organizations's group |
|
|
|
|
|
DisplayDate |
|
|
|
|
|
|
DisplayName |
|
|
|
|
|
|
EndDate |
|
|
|
|
|
|
FirstName |
|
|
|
|
|
|
Institution |
|
|
|
|
|
|
LastName |
|
|
|
|
|
|
MiddleName |
|
|
|
|
|
|
MTB_BirthPlace |
|
|
|
|
|
|
MTB_DeathPlace |
|
|
|
|
|
|
MTB_Gender |
|
|
|
|
|
|
MTB_Occupation |
|
|
|
|
|
|
N_DisplayName |
|
|
|
|
|
|
N_DisplayDate |
|
|
|
|
|
|
NameTitle |
|
|
|
|
|
|
Nationality |
|
|
|
|
|
|
[Position] |
|
|
|
|
|
|
PublicAccess |
can be ignored? |
|
|
|
|
|
PublicAccessOld |
can be ignored? |
|
|
|
|
|
Remarks |
|
|
|
|
|
|
Suffix |
|
|
|
|
|
ConXrefs |
10 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
Crates |
19 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
Dimensions |
2 columns |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
DimItemElemXrefs |
5 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
Exhibitions |
16 columns |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ExhObjXrefs |
5 columns |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ExhVenueXrefs |
5 columns |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
HistEvents |
9 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
HistObjXrefs |
3 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
LoanObjXrefs |
ConservationFee |
xxxxxxxxxxxx |
|
|
|
|
|
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 |
2 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
MediaCounts |
2 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
MediaFiles |
7 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
MediaMaster |
8 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
MediaPaths |
2 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
MediaRenditions |
11 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
MediaXrefs |
3 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ObjAccession |
15 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ObjComponents |
22 columns |
xxxxxxxxxxxx |
|
|
|
|
|
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 |
9 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ObjDeaccession |
12 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ObjectNames |
4 columns |
xxxxxxxxxxxx |
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
|
xxxxxxxxxxx |
|
|
|
|
|
ObjectPackages |
8 columns |
xxxxxxxxxxxx |
|
|
|
|
|
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 |
|
|
|
|
|