UCJEPS-CollectionSpace data mapping, v0.7

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.

Data

This iteration will focus on object cataloging data, loans out, and relationships.

Object cataloging data

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


Notes

  • loc_county, loc_state, and loc_country will not be supported by dropdowns for now
  • field_collector will not be controlled by an authority in this iteration.
  • Collecting event information is being added as custom temporary fields.  CollectionSpace will have a separate authority system for collecting events and collectors, so these mappings will change in the future.

Loans Out

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 Number relates accessions in a single collection that make up a loan.
Loan ID relates loans from each collection that make up a loan.
"Loan Number" = collection + loan_num
"Loan ID" = loan_id

loan_event.curr_inst

Borrower

 

Probably should keep this as borrowing institution (organization authority)

loan_event:         
  curr_for_fname,
  curr_for_lname,
  curr_for_position

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 +
loan_detail.return_status

Loaned object status

 

smasch keeps track of two status types:
loan status ('Active' or 'Cancelled')
return status ('All in', 'All out', 'Partial', 'Discrepancy', 'Unknown')

Relationships

  • Loan Out to Object

Data sets for dropdowns and controlled lists

  1. Collection values:
    1. Jepson Herbarium
    2. University of California Herbarium
    3. University of California
  2. Form values:
    1. Illustration
    2. Mounted on Paper
    3. Photocopy
    4. Photograph
    5. Stored in a Box or Bag
  3. Phase (Phenology) values:
    1. Cone
    2. Flowering
    3. Flowering/Fruiting
    4. Fruiting
    5. Spores/Sporangia
    6. Vegetative (non-reproductive)
  4. Loaned Object Status values:
    1. Active (Unknown)
    2. Active (All Out)
    3. Active (All In)
    4. Active (Partial)
    5. Active (Discrepancy)
    6. Cancelled (Unknown)
    7. Cancelled (All Out)
    8. Cancelled (All In)
    9. Cancelled (Partial)
    10. Cancelled (Discrepancy)

Name Authority: Person

SMASCH

cSpace Person Schema

CS User Interface Title (** = different from UI)

Note

person.person_id
borrower.borrower_id

Legacy ID

 

borrower is not part of smasch; newly created to generate pk id for borrowers in loan_event table.

person.first_name +
     person.other_name +
     person.last_name
loan_event.curr_for_fname +
     loan_event.curr_for_lname

Display Name

 

 

person.first_name
loan_event.curr_for_fname

Forename

 

 

person.other_name

Middle Name

 

 

person.last_name
loan_event.curr_for_lname

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  
'borrower'

Name Note

 

 


Name Authority: Organization

SMASCH

cSpace Organization Schema

CS User Interface Title (** = different from UI)

Note

committee.committee_id
institute.inst_abbr

Legacy ID

 

 

committee.committee_abbr
institute.inst_name

Display Name

 

 

committee.committee_name
institute.inst_name

Long Name

 

 

committee.committee_abbr
institute.inst_abbr

Short Name

 

 

institute.inst_state +
    institute.inst_country

Foundation Place

 

 

committee.committee_func
'Institution'

Function

 

 

SMASCH

cSpace Contact Schema

 

CS User Interface Title (** = different from UI)

 

Note

institute.email

Email

 

 

institute.fax

Fax

 

 

institute.url

URL

 

 

institute.address1 +
institute.address2 +
institute.city +
institute.zipcode +
institute.state +
institute.country

Place

 

 

"street"

Address Type

 

 

institute.phone

Phone

 

 

CollectionSpace object screen and mapping to the user interface

TBD