...
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Interpreting dates based on 008/06
...
Date type - Instance (third pane, edit screen)
...
Date 1 - Instance (third pane, edit)
...
Date 2 - instance (third pane, edit)
...
Results list - second pane
...
Sort properties (not displayed)
...
008/06
...
“Date type”
...
“Date 1” (008/07-10)
...
“Date 2” (008/11-14)
...
“Date”
...
Pub start
...
Pub end
...
b
...
No dates given; B.C. date involved
...
Null
...
0000
...
0000
...
c
...
Continuing resource currently published
...
1984
...
9999
...
1984-
...
1984
...
d
...
Continuing resource ceased publication
...
1928
...
1941
...
1928-1941
...
1928
...
1941
...
e
...
Detailed date
...
1983
...
0615
...
1983, 0615
...
1983
...
i
...
Inclusive dates of collection
...
1988
...
1988
...
1988-1988
...
1988
...
1988
...
k
...
Range of years of bulk of collection
...
1796
...
1854
...
1796-1854
...
1796
...
1854
...
m
...
Multiple dates
...
1943
...
1945
...
1943, 1945
...
1943
...
n
...
Dates unknown
...
uuuu
...
uuuu
...
Null
...
0000
...
0000
...
p
...
Date of distribution/release/issue and production/recording session when different
...
1982
...
1967
...
1982, 1967
...
1982
...
q
...
Questionable date
...
18uu
...
19uu
...
18uu-19uu
...
1800
...
1900
...
r
...
Reprint/reissue date and original date
...
1983
...
1857
...
1983, 1857
...
1983
...
s
...
Single known date/probable date
...
1977
...
1977
...
1977
...
t
...
Publication date and copyright date
...
1982
...
1949
...
1982, 1949
...
1982
...
u
...
Continuing resource status unknown
...
1948
...
uuuu
...
1948-
...
1948
...
|
...
No attempt to code
...
Null
...
0000
...
0000
Requirements
Category | Requirement | Related Jira | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Schema | Schema change - create new fields for Date type, Date 1, Date 2
|
| ||||||||
2 | Data mapping | Default MARC-Instance map:
|
| ||||||||
3 | Pub start and Pub end | Map the values from Date 1 and Date 2 to the publicationPeriod.start and PublicationPeriod.end properties See above table |
| ||||||||
4 | Instance - third pane | Create controlled list of date types to populate dropdown field for “Date type” in Instance:
*No capability to change/add new values at this time |
| ||||||||
5 | Instance - third pane | Create new section in “Descriptive data” accordion on the Instance record with three new non-repeatable, not required, fields:
|
| ||||||||
6 | Instance - third pane | Create separate text boxes for “Date 1” and “Date 2” as options for Date type. These fields are not required. |
| ||||||||
7 | Filtering/ sorting | Use publicationPeriod.start and publicationPeriod.end as sources for sorting and filtering; sort off start date |
| ||||||||
8 | Filtering/ sorting | Add new “Date” column after “Contributors” |
| ||||||||
9 | 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) |
| ||||||||||
10 | 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) |
| ||||||||
11 | Interpreting Date type (008/06 for MARC) | For the following Date type values: n, |, b
|
| ||||||||
12 | Interpreting Date type (008/06 for MARC) | For Date type value Detailed Date (e):
|
| ||||||||
13 | Interpreting Date type (008/06 for MARC) | For Date type value Range of years of bulk of collection (k):
|
|
Indexing Arabic numerals
| |||||||||||
14 | Interpreting Date type (008/06 for MARC) | For Date type value Inclusive dates of collection ( i )
|
| ||||||||
15 | Interpreting Date type (008/06 for MARC) | For Date type value Multiple dates (m)
|
| ||||||||
16 | Interpreting Date type (008/06 for MARC) | For Date type value Questionable date (q)
|
| ||||||||
17 | Interpreting Date type (008/06 for MARC) | For Date type value Continuing resource ceased publication (d)
|
| ||||||||
18 | Interpreting Date type (008/06 for MARC) | For Date type value Single known date/probable date (s)
|
| ||||||||
19 | Interpreting Date type (008/06 for MARC) | For Date type value Continuing resource status unknown (u)
|
| ||||||||
20 | Interpreting Date type (008/06 for MARC) | For Date type value Reprint/reissue date and original date (r)
|
| ||||||||
21 | Interpreting Date type (008/06 for MARC) | For Date type value Publication date and copyright date (t)
|
| ||||||||
22 | Interpreting Date type (008/06 for MARC) | For Date type value Continuing resource currently published (c)
|
| ||||||||
23 | Interpreting Date type (008/06 for MARC) | For Date type value Date of distribution/release/issue and production/recording session when different (p)
|
| ||||||||
24 | Interpreting Date type (008/06 for MARC) | General rule : When the end date is 9999
|
| ||||||||
25 | 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) |
| ||||||||
26 | Interpreting Date type (008/06 for MARC) | If dates contain “u”, probably need to replace with 0’s for sort properties |
|
Example sort - Ascending
1 | Poppy HRID | 008 | Date type | Date 1 | Date 2 | Results list | publicationPeriod.start | publicationPeriod.end | From | To | Scenario |
2 | in4611687 | nxxxx____ | n - Dates unknown | null | null | null | 0000 | 0000 | No dates included | ||
3 | ins00006934620 | _2010____ | | - No attempt to code | null | null | null | 0000 | 0000 | No attempt to code, but date - do not utilize date because we don’t know how to interpret | ||
4 | No example found | b________ | b - No dates given; B.C. date involved | null | null | null | 0000 | 0000 | No dates included | ||
5 | in3151255 | e15020515 | e - Detailed date | 1502 | 0515 | 1502, 0515 | 1502 | null | 1502 | 1900 | Another date included but not related to sorting/filtering |
6 | in11441687 | k17uu1uuu | k -Range of years of bulk of collection | 1700 | 1uuu | 17uu-1uuu | 1700 | 0000 | 1700 | 1852 | Only one digit known in end date and more than one known in start date |
7 | in1908098 | i18uu9999 | i - Inclusive dates of collection | 18uu | 9999 | 18uu- | 1800 | null | 1800 | 2018 | End date of 9999 |
8 | in1601779 | m18701887 | m - Multiple dates | 1870 | 1887 | 1870-1887 | 1870 | 1887 | 1870 | 1875 | Multiple dates in range |
9 | in1601368 | q19001994 | q - Questionable date | 1900 | 1994 | 1900-1994 | 1900 | 1994 | 1900 | 1901 | Multiple dates in range |
10 | in1633443 | i191u1918 | i - Inclusive dates of collection | 191u | 1918 | 191u-1918 | 1910 | 1918 | 1910 | 1912 | Example “u”, replacing with “0000” for sorting |
11 | in6321275 | 19131941 | d - Continuing resource ceased publication | 1931 | 1941 | 1931-1941 | 1931 | 1941 | 1931 | 1948 | Multiple dates in range |
12 | in7096349 | s196u____ | s - Single known date/probable date | 196u | null | 196u- | 1960 | null | 1960 | 1970 | Example “u”, replacing with “0000” for sorting, only one date |
13 | in4252195 | u1969uuuu | u - Continuing resource status unknown | 1969 | uuuu | 1969-uuuu | 1969- | null | 1969 | 2024 | Date 2 is unknown, dates represent range |
14 | 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 |
15 | in8835594 | t20082008 | t - Publication date and copyright date | 2008 | null | 2008, 2008 | 2008 | null | 2008 | 2015 | Two dates, unrelated to range |
16 | in6092439 | c20019999 | c - Continuing resource currently published | 2001 | 9999 | 2001- | 2001 | 9999 | 2001 | 2004 | End date of 9999 |
17 | 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 |
1 | Indexing Arabic numerals |
2 | Keep in mind date conversion |