| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
...
| 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” (Or “Type of Date”?)
...
“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
...
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 |
Current proposal: perform mapping logic in mod-search 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 |
|
| ||||||||
| 8 | Filtering/ sorting | Add new “Date” column after |
“Publishers” |
|
| |||||||||||
| 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) |
|
Date column (second pane results)
In Date column, show Dates on UI based on interpretation of Date type (see stories for details)
| 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):
|
| ||||||||
| 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)
|
|
|
|
Filtering/ sorting
| 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) | 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) |
| ||||||||
| 25 | Interpreting Date type (008/06 for MARC) | If dates contain “u”, probably need to replace with 0’s for sort properties |
|
Indexing Arabic numerals
|
Interpreting Date 1 and Date 2 on results list
008/06 | Date type | Date column (note special characters) |
|---|---|---|
b | No dates given; BC date involved | Null (if not null, utilize comma as delimiter) |
c | Continuing resource currently published | Date 1-Date 2 |
d | Continuing resource ceased publication | Date 1-Date 2 |
e | Detailed date | Date 1, Date 2 |
i | Inclusive dates of collection | Date 1-Date 2 |
k | Range of years of bulk of collection | Date 1-Date2 |
m | Multiple dates | Date 1, Date 2 |
n | Dates unknown | Null (if not null, utilize comma as delimiter) |
p | Date of distribution/release/issue and production/recording session when different | Date 1, Date 2 |
q | Questionable date | Date 1, Date 2 |
r | Reprint/reissue date and original date | Date 1, Date 2 |
s | Single known date/probable date | Date 1, Date 2 |
t | Publication date and copyright date | Date 1, Date 2 |
u | Continuing resource status unknown | Date 1- |
No attempt to code | Null (if not null, utilize comma as delimiter) |
Example sort - Ascending
| 1 | Poppy HRID | 008 | Date type | Date 1 | Date 2 | Results list | From | To | Scenario |
| 2 | in4611687 | nxxxx____ | n - Dates unknown | null | null | null | 1901 | No dates included | |
| 3 | ins00006934620 | _2010____ | | - No attempt to code | null | null | null | 1000 | 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 | 1641 | No dates included | |
| 5 | in3151255 | e15020515 | e - Detailed date | 1502 | 0515 | 1502, 0515 | 1502 | 1900 | Another date included but not related to sorting/filtering |
| 6 | in11441687 | k17uu1uuu | k -Range of years of bulk of collection | 1700 | 1uuu | 1700-1uuu | 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-9999 | 1800 | 2018 | End date of 9999 |
| 8 | in1601779 | m18701887 | m - Multiple dates | 1870 | 1887 | 1870,1887 | 1870 | 1875 | Multiple dates in range |
| 9 | in1601368 | q19001994 | q - Questionable date | 1900 | 1994 | 1900-1994 | 1900 | 1901 | Multiple dates in range |
| 10 | in1633443 | i191u1918 | i - Inclusive dates of collection | 191u | 1918 | 191u-1918 | 1910 | 1912 | Example “u”, replacing with “0000” for sorting |
| 11 | in6321275 | 19131941 | d - Continuing resource ceased publication | 1931 | 1941 | 1931-1941 | 1931 | 1948 | Multiple dates in range |
| 12 | in7096349 | s196u____ | s - Single known date/probable date | 196u | null | 196u- | 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 | 2024 | Date 2 is unknown, dates represent range |
| 14 | in7452110 | r19961855 | r - Reprint/reissue date and original date | 1996 | null | 1996 | 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 | 2015 | Two dates, unrelated to range |
| 16 | in6092439 | c20019999 | c - Continuing resource currently published | 2001 | 9999 | 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 | 2023 | Two dates unrelated to range |
| 1 | Indexing Arabic numerals |
| 2 | Keep in mind date conversion |