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 and publicationPeriod.start/publicationPeriod.end 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 “Contributors”“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 nullSort properties: Interpret as 0000 in both start and end, unless dates are provided, and if so, add dates separated by comma

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

• comma

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

• comma

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

• (if Date 2 is provided, separate by comma)

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

, if date 2 is provided add after hyphen

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

• and if included, the Date 2 value

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

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

b

No dates given; BC date involved

Null

0000

0000(if not null, utilize comma as delimiter)

c

Continuing resource currently published

Date 1-Date 12

d

Continuing resource ceased publication

Date 1-Date 2

Date 1

Date 2

e

Detailed date

Date 1, Date 2

Date 1

i

Inclusive dates of collection

Date 1-Date 2Date 1

Date 2

k

Range of years of bulk of collection

Date 1-Date2

Date 1

Date 2

m

Multiple dates

Date 1, Date 2

Date 1

Date 2

n

Dates unknown

Null

0000

0000

(if not null, utilize comma as delimiter)

p

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

Date 1, Date 2Date 1

q

Questionable date

Date 1, Date 2Date 1

Date 2

r

Reprint/reissue date and original date

Date 1, Date 2Date 1

s

Single known date/probable date

Date 1, Date 12

t

Publication date and copyright date

Date 1, Date 2Date 1

u

Continuing resource status unknown

Date 1-Date 1

No attempt to code

Null

0000

0000(if not null, utilize comma as delimiter)

Poppy HRID

008

Date type

Date 1

Date 2

Results list

publicationPeriod.start

publicationPeriod.end

From

To

Scenario

in4611687

nxxxx____

n - Dates unknown

null

null

null

0000

0000

0000

1901

No dates included

ins00006934620

_2010____

| - No attempt to code

null

null

null

0000

0000

0000

1000

No attempt to code, but date - do not utilize date because we don’t know how to interpret

No example found

b________

b - No dates given; B.C. date involved

null

null

null

0000

0000

0000

1641

No dates included

in3151255

e15020515

e - Detailed date

1502

0515

1502, 0515

1502null

1502

1900

Another date included but not related to sorting/filtering

in11441687

k17uu1uuu

k -Range of years of bulk of collection

1700

1uuu

17uu1700-1uuu

1700

0000

1700

1852

Only one digit known in end date and more than one known in start date

in1908098

i18uu9999

i - Inclusive dates of collection

18uu

9999

18uu-

1800

null9999

1800

2018

End date of 9999

in1601779

m18701887

m - Multiple dates

1870

1887

1870-1887

1870

,1887

1870

1875

Multiple dates in range

in1601368

q19001994

q - Questionable date

1900

1994

1900-1994

1900

1994

1900

1901

Multiple dates in range

in1633443

i191u1918

i - Inclusive dates of collection

191u

1918

191u-1918

1910

1918

1910

1912

Example “u”, replacing with “0000” for sorting

in6321275

19131941

d - Continuing resource ceased publication

1931

1941

1931-1941

1931

1941

1931

1948

Multiple dates in range

in7096349

s196u____

s - Single known date/probable date

196u

null

196u-

1960null

1960

1970

Example “u”, replacing with “0000” for sorting, only one date

in4252195

u1969uuuu

u - Continuing resource status unknown

1969

uuuu

1969-uuuu

1969-

null

1969

2024

Date 2 is unknown, dates represent range

in7452110

r19961855

r - Reprint/reissue date and original date

1996

null

1996

1996

null

1996

1997

Two dates, unrelated to range, but second date is unknown

in8835594

t20082008

t - Publication date and copyright date

2008

null2008, 2008

2008null

2008

2015

Two dates, unrelated to range

in6092439

c20019999

c - Continuing resource currently published

2001

9999

2001-

2001

9999

2001

2004

End date of 9999

in10080443

p20142008

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

2014

2008

2014, 2008

2014

null

2014

2023

Two dates unrelated to range