Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

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

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

We are converting this to the structured date format

committee.committee_abbr

field_collection_collector

Field Collection Collector


accession.loc_lat_decimal

field_loc_lat_decimal

Field Location Latitude Decimal

 

accession.loc_long_decimal

field_loc_long_decimal

Field Location Longitude Decimal


accession.loc_place (calc)

field_collection_place (?)

Field Location Verbatim**

Will map to verbatim field in schema extension for now.  When the Place Authority is available, we will work on creating authority records as well.

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


committee.committee_abbr

?

Field collection collector


"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 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

 

It looks like this field is not currently active.  smasch keeps track of two status types:
loan status ('Active' or 'Cancelled')
return status ('All in', 'All out', 'Partial', 'Discrepancy', 'Unknown')

Loan date?

 

Loan Out Date

Does SMaSCH have a loan date?

SQL query

view:

Notes

MERGE: Loan Out Items (repeating group within Loan Out procedure records)

...