Requirements

	Category	Requirement	Related Jira
1	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	MODINVSTOR-1188 - Getting issue details... STATUS
2	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	MODDATAIMP-1047 - Getting issue details... STATUS
3	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	MSEARCH-806 - Getting issue details... STATUS
4	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	UIIN-2849 - Getting issue details... STATUS
5	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	UIIN-2849 - Getting issue details... STATUS
6	Instance - third pane	Create separate text boxes for “Date 1” and “Date 2” as options for Date type. These fields are not required.	UIIN-2849 - Getting issue details... STATUS
7	Filtering/ sorting	~~Use publicationPeriod.start and publicationPeriod.end~~ Date 1 & Date 2 as sources for sorting and filtering; sort off start date	UIIN-2850 - Getting issue details... STATUS
8	Filtering/ sorting	Add new “Date” column after “Publishers”	UIIN-1876 - Getting issue details... STATUS
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)	UIIN-1876 - Getting issue details... STATUS
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)	UIIN-2851 - Getting issue details... STATUS
11	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	MODINVSTOR-1204 - Getting issue details... STATUS
12	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	MODINVSTOR-1204 - Getting issue details... STATUS
13	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	MODINVSTOR-1204 - Getting issue details... STATUS
14	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	MODINVSTOR-1204 - Getting issue details... STATUS
15	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	MODINVSTOR-1204 - Getting issue details... STATUS
16	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	MODINVSTOR-1204 - Getting issue details... STATUS
17	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	MODINVSTOR-1204 - Getting issue details... STATUS
18	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	MODINVSTOR-1204 - Getting issue details... STATUS
19	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	MODINVSTOR-1204 - Getting issue details... STATUS
20	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	MODINVSTOR-1204 - Getting issue details... STATUS
21	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	MODINVSTOR-1204 - Getting issue details... STATUS
22	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	MODINVSTOR-1204 - Getting issue details... STATUS
23	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	MODINVSTOR-1204 - Getting issue details... STATUS
24	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	MODINVSTOR-1204 - Getting issue details... STATUS
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)	MODINVSTOR-1204 - Getting issue details... STATUS
26	Interpreting Date type (008/06 for MARC)	If dates contain “u”, probably need to replace with 0’s for sort properties	MSEARCH-806 - Getting issue details... STATUS

Interpreting Date 1 and Date 2

008/06	Date type	Date column (note special characters)	Start	End
b	No dates given; BC date involved	Null	0000	0000
c	Continuing resource currently published	Date 1-	Date 1
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 2	Date 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
p	Date of distribution/release/issue and production/recording session when different	Date 1, Date 2	Date 1
q	Questionable date	Date 1, Date 2	Date 1	Date 2
r	Reprint/reissue date and original date	Date 1, Date 2	Date 1
s	Single known date/probable date	Date 1	Date 1
t	Publication date and copyright date	Date 1, Date 2	Date 1
u	Continuing resource status unknown	Date 1-	Date 1
	No attempt to code	Null	0000	0000

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	0000	1901	No dates included
3	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
4	No example found	b________	b - No dates given; B.C. date involved	null	null	null	0000	0000	0000	1641	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	1000	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

Publication date filter and sort requirements

Requirements

Interpreting Date 1 and Date 2

Example sort - Ascending