With CollectionSpace 0.7, the schema have changed, and therefore so will the data mapping and customizations we are employing in the UCJEPS deployment of CollectionSpace 0.7. This is not a final data mapping for the University and Jepson Herbaria. This is just an initial iteration. Changes from the previous mapping are in blue.
This iteration will focus on object cataloging data, loans out, and relationships.
See the CollectionSpace catalog schema for 0.7
SMaSCH |
CollectionSpace object schema |
CS User Interface Title (** = different from UI) |
Note |
accession.accession_id |
object_number |
Accession Number ** |
|
institution.inst_name |
collection |
Collection |
Was "responsible department" |
accession.coll_num_prefix + coll_number + coll_num_suffix |
other_number |
Number |
Calculation |
"collector number" |
other_number_type |
Number Type |
Fixed text |
accession.notes |
comments |
Notes |
|
objkind.kind |
form (Object Description Information) |
Form |
Was "brief_description" |
taxon_fullname.fullname |
title |
Taxon ** |
Field title will change |
accession.phenology (decoded) |
phase (Object Description Information) |
Phenology ** |
Was a custom field |
accession.early_jdate (calc) |
field_collection_date_earliest |
Field Collection Date Earliest |
Custom, temporary |
accession.late_jdate (calc) |
field_collection_date_latest |
Field Collection Date Latest |
Custom, temporary |
accession.datestring |
field_collection_date |
Field Collection Date |
Custom, temporary, verbatim |
committee.committee_abbr |
field_collector |
Field Collector |
Custom, temporary |
accession.loc_lat_decimal |
field_loc_lat_decimal |
Field Location Latitude Decimal |
Custom, temporary |
accession.loc_long_decimal |
field_loc_long_decimal |
Field Location Longitude Decimal |
Custom, temporary |
accession.loc_place (calc) |
field_loc_place |
Field Location Verbatim |
Custom, temporary, calculation |
accession.loc_county |
field_loc_county |
Field Location County |
Custom, temporary |
accession.loc_state |
field_loc_state |
Field Location State |
Custom, temporary |
accession.loc_country |
field_loc_country (temp custom) |
Field Location Country |
Custom, temporary |
accession.loc_elevation |
field_loc_elevation (temp custom) |
Field Location Country |
Custom, temporary |
"catalog date" |
date_association |
Date Association |
Fixed text |
accession.catalog_date |
catalog_date |
Date Text |
|
See the CollectionSpace Loans Out schema, though this does indicate which fields are disabled in 0.7
SMaSCH |
CollectionSpace loans out schema |
CS User Interface Title (** = different from UI) |
Note |
||
loan_event.uc_loan_num + loan_event.jeps_loan_num |
Loan out number |
|
smasch has two types of loan identifiers. |
||
loan_event.curr_inst |
Borrower |
|
Probably should keep this as borrowing institution (organization authority) |
||
loan_event: |
Borrower's contact |
|
Probably should keep this as borrowing agent (person authority) |
|
|
loan_event.inhouse_notes + loan_event.noteworthy_inclusions |
Loan out note |
|
|
||
loan_event.loan_status + |
Loaned object status |
|
smasch keeps track of two status types: |
SMASCH |
cSpace Person Schema |
CS User Interface Title (** = different from UI) |
Note |
---|---|---|---|
person.person_id |
Legacy ID |
|
borrower is not part of smasch; newly created to generate pk id for borrowers in loan_event table. |
person.first_name + |
Display Name |
|
|
person.first_name |
Forename |
|
|
person.other_name |
Middle Name |
|
|
person.last_name |
Surname |
|
|
person.bio_notes |
Biographical Note |
|
|
person.birth_year |
Birth Date |
|
|
person.death_year |
Death Date |
|
|
loan_event.curr_for_position |
Occupation |
|
|
loan_event.curr_inst |
Group |
|
|
'collector' + '; name source: ' + data_source.data_src_name |
Name Note |
|
|
SMASCH |
cSpace Organization Schema |
CS User Interface Title (** = different from UI) |
Note |
---|---|---|---|
committee.committee_id |
Legacy ID |
|
|
committee.committee_abbr |
Display Name |
|
|
committee.committee_name |
Long Name |
|
|
committee.committee_abbr |
Short Name |
|
|
institute.inst_state + |
Foundation Place |
|
|
committee.committee_func |
Function |
|
|
SMASCH |
cSpace Contact Schema |
|
CS User Interface Title (** = different from UI) |
|
Note |
---|---|---|---|---|---|
institute.email |
Email |
|
|
||
institute.fax |
Fax |
|
|
||
institute.url |
URL |
|
|
||
institute.address1 + |
Place |
|
|
||
"street" |
Address Type |
|
|
||
institute.phone |
Phone |
|
|
TBD