Schema

Schema change - create new fields for Date type, Date 1, Date 2

• Continue to map the 260$c/264$c to the publication date field as a string

• Remove mapping between the publication date and publicationPeriod.start/publicationPeriod.end

• Create new fields for Date type, Date 1, Date 2

• Create new mapping between 008/07-14 based on 008/06

Data mapping

Default MARC-Instance map:

• 008/06: Based on value, map to controlled list

  • b = No dates given; B.C. date involved

  • c = Continuing resource currently published

  • d = Continuing resource ceased publication

  • e = Detailed date

  • i = Inclusive dates of collection

  • k = Range of years of bulk of collection

  • m = Multiple dates

  • n = Dates unknown

  • p = Date of distribution/release/issue and production/recording session when different

  • q = Questionable date

  • r = Reprint/reissue date and original date

  • s = Single known date/probable date

  • t = Publication date and copyright date

  • u = Continuing resource status unknown

  • empty = No attempt to code

• 008/07-10 = Date 1

• 008/11-14 = Date 2

Pub start and Pub end

Map the values from Date 1 and Date 2 to the publicationPeriod.start and PublicationPeriod.end properties

Current proposal: perform mapping logic in mod-search

See above table

Instance - third pane

Create controlled list of date types to populate dropdown field for “Date type” in Instance:

• No dates given; B.C. date involved

• Continuing resource currently published

• Continuing resource ceased publication

• Detailed date

• Inclusive dates of collection

• Range of years of bulk of collection

• Multiple dates

• Dates unknown

• Date of distribution/release/issue and production/recording session when different

• Questionable date

• Reprint/reissue date and original date

• Single known date/probable date

• Publication date and copyright date

• Continuing resource status unknown

• No attempt to code

*No capability to change/add new values at this time

Instance - third pane

Create new section in “Descriptive data” accordion on the Instance record with three new non-repeatable, not required, fields:

• Date type (controlled list dropdown)

• Date 1

• Date 2

Instance - third pane

Create separate text boxes for “Date 1” and “Date 2” as options for Date type. These fields are not required.

Filtering/ sorting

Use publicationPeriod.start and publicationPeriod.end Date 1 & Date 2 as sources for sorting and filtering; sort off start date

Filtering/ sorting

Add new “Date” column after “Publishers”

Date column (second pane results)

In Date column, show Dates on UI based on interpretation of Date type (see stories and example sort table below)

Filtering/ sorting

Create a date filter on Inventory search Instance toggle “Date range” with “To” and “From”: Inclusive range of dates, four character year (only numeric values allowed)

Interpreting Date type (008/06 for MARC)

For the following Date type values: n, |, b

• Results list: Leave results list Date column value null

• Sort properties: Interpret as 0000 in both start and end

Interpreting Date type (008/06 for MARC)

For Date type value Detailed Date (e):

• Results list: Combine Date 1 & Date 2 separated by comma

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

For Date type value Range of years of bulk of collection (k):

• Results list: Combine Date 1 & Date 2 separated by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = Date 2

Interpreting Date type (008/06 for MARC)

For Date type value Inclusive dates of collection ( i )

• Results list: Combine Date 1 & Date 2 separated by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = Date 2

Interpreting Date type (008/06 for MARC)

For Date type value Multiple dates (m)

• Results list: Combine Date 1 & Date 2 separated by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = Date 2

Interpreting Date type (008/06 for MARC)

For Date type value Questionable date (q)

• Results list: Combine Date 1 & Date 2 separated by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = Date 2

Interpreting Date type (008/06 for MARC)

For Date type value Continuing resource ceased publication (d)

• Results list: Combine Date 1 & Date 2 separated by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = Date 2

Interpreting Date type (008/06 for MARC)

For Date type value Single known date/probable date (s)

• Results list: Date 1

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

For Date type value Continuing resource status unknown (u)

• Results list: Date 1, followed by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

For Date type value Reprint/reissue date and original date (r)

• Results list: Combine Date 1 & Date 2 separated by comma

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

For Date type value Publication date and copyright date (t)

• Results list: Combine Date 1 & Date 2 separated by comma

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

For Date type value Continuing resource currently published (c)

• Results list: Date 1 followed by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

For Date type value Date of distribution/release/issue and production/recording session when different (p)

• Results list: Combine Date 1 & Date 2 separated by comma

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

General rule : When the end date is 9999

• Results list: Date 1 followed by hyphen

• Sort properties:

  • Start date = Date 1

  • End date = null

Interpreting Date type (008/06 for MARC)

If date is included in either Date 1 and Date 2, but Date type = No attempt to code, do not consider the date (with no attempt to code, we don’t know how to interpret dates)

Interpreting Date type (008/06 for MARC)

If dates contain “u”, probably need to replace with 0’s for sort properties