With CollectionSpace 1.0, the schema have changed, and therefore so will the data mapping and customizations we are employing in the UCJEPS deployment of CollectionSpace 1.0. This is not a final data mapping for the University and Jepson Herbaria. This is just a next iteration. Changes from the previous mapping are in blue.
Data
This iteration will focus on object cataloging data, loans out, and relationships.
...
SMaSCH | CollectionSpace object schema | CS User Interface Title (** = different from UI) | Note |
accession.accession_id | object_number | Accession Number ** | Change field title |
institution.inst_name | collection | Collection | Dropdown (Collection values) |
accession.coll_num_prefix + coll_number + coll_num_suffix | other_number | Number | Moved to Field Collection Number. |
"collector number" | other_number_type | Number Type | Not needed if we move this to Field Collection Number. |
accession.notes | comments | Notes Comments | |
objkind.kind | form (Object Description Information) | Form | Dropdown (Form values) |
taxon_fullname.fullname | title | Taxon ** | Change field title |
accession.phenology (decoded) | phase (Object Description Information) | Phenology ** | Change field title. Dropdown (Phenology values) |
accession.early_jdate (calc) | field_collection_date_earliest | Field Collection Date Earliest | Custom |
accession.late_jdate (calc) | field_collection_date_latest | Field Collection Date Latest | Custom |
accession.datestring | field_collection_date | Field Collection Date Custom | Was a custom field but now exists in the 1.0 schema |
committee.committee_abbr | field_collection_collector (?) | Field Collection Collector | Was a custom field in 0.7 map. Field_collection_collector now exists, and is tied to Org and Person authorities. |
accession.loc_lat_decimal | field_loc_lat_decimal | Field Location Latitude Decimal | Custom |
accession.loc_long_decimal | field_loc_long_decimal | Field Location Longitude Decimal | Custom |
accession.loc_place (calc) | field_loccollection_place (?) | Field Location Verbatim Custom ** | Was a custom field in 0.7 map, but now exists in 1.0 map |
accession.loc_county | field_loc_county | Field Location County | Custom |
accession.loc_state | field_loc_state | Field Location State | Custom |
accession.loc_country | field_loc_country (temp custom) | Field Location Country | Custom |
accession.loc_elevation | field_loc_elevation (temp custom) | Field Location Country | Custom |
accession.coll_num_prefix + coll_number + coll_num_suffix | ? | Field collection number | Now available in 1.0 (was in Other Number in 0.7 map) |
committee.committee_abbr | ? | Field collection collector | Now available in 1.0 (was a custom field) and is tied to person and org authorities. |
"catalog date" | date_association | Date Association | Fixed text. Do not load into 1.0. May end up in Associated Date information eventually, or create date/modify date. |
accession.catalog_date | catalog_date | Date Text | Fixed text. Do not load into 1.0. May end up in Associated Date information eventually, or create date/modify date. |
...
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 |
| It looks like this field is not currently active. smasch keeps track of two status types: | ||
Loan date? |
| Loan Out Date | Does SMaSCH have a loan date? |
Relationships
- Loan Out to Object
...
- Collection values:
- Jepson Herbarium
- University of California Herbarium, UC Berkeley
- University of California
- Form values:
- Illustration
- Mounted on Paper
- Photocopy
- Photograph
- Stored in a Box or Bag
- Phase (Phenology) values:
- Cone
- Flowering
- Flowering/Fruiting
- Fruiting
- Spores/Sporangia
- Vegetative (non-reproductive)
- Loaned Object Status values:
- Active (Unknown)
- Active (All Out)
- Active (All In)
- Active (Partial)
- Active (Discrepancy)
- Cancelled (Unknown)
- Cancelled (All Out)
- Cancelled (All In)
- Cancelled (Partial)
- Cancelled (Discrepancy)
- Other Number Type values:
- Other herbaria accession number
- Copied from accession number
- Exsiccatae number
- Project number
- Genbank number
- Destructive sampling number
- Internal cross reference
- Miscellaneous
Name Authority: Person
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 |
|
|
...