Requirements

	Category	Requirement	Related Jira

	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: Add new date type fields to schema - Date type, Date 1, and Date 2Closed
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	MODSOURMAN-1228: Update default mapping for Date type, Date 1, and Date 2 fieldsClosed
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: Create computed fields for sorting & filtering Date 1Closed
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: Instance Detail/Edit/New: Add new section for Date type, Date 1, & Date 2Closed
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: Instance Detail/Edit/New: Add new section for Date type, Date 1, & Date 2Closed
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: Instance Detail/Edit/New: Add new section for Date type, Date 1, & Date 2Closed
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: Sort Date column by Date 1Closed
8	Filtering/ sorting	Add new “Date” column after “Publishers”	UIIN-1876: Add Date column to Inventory results listClosed
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: Add Date column to Inventory results listClosed
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)	UISINVCOMP-22: Create Date range filter in Inventory Instance toggleClosed
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, unless dates are provided, and if so, add dates separated by comma	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
15	Interpreting Date type (008/06 for MARC)	For Date type value Multiple dates (m) Results list: Combine Date 1 & Date 2 separated by comma	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
16	Interpreting Date type (008/06 for MARC)	For Date type value Questionable date (q) Results list: Combine Date 1 & Date 2 separated by comma	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
18	Interpreting Date type (008/06 for MARC)	For Date type value Single known date/probable date (s) Results list: Date 1 (if Date 2 is provided, separate by comma)	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
19	Interpreting Date type (008/06 for MARC)	For Date type value Continuing resource status unknown (u) Results list: Date 1, followed by hyphen, if date 2 is provided add after hyphen	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
22	Interpreting Date type (008/06 for MARC)	For Date type value Continuing resource currently published (c) Results list: Date 1 followed by hyphen and if included, the Date 2 value	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
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)	MODINVSTOR-1204: Map Date 1 and Date 2 to publication start & endClosed
25	Interpreting Date type (008/06 for MARC)	If dates contain “u”, probably need to replace with 0’s for sort properties	MSEARCH-806: Create computed fields for sorting & filtering Date 1Closed

Interpreting Date 1 and Date 2 on results list

008/06	Date type	Date column (note special characters)

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

Folio Development Teams

Publication date filter and sort requirements

Requirements

Interpreting Date 1 and Date 2 on results list

Example sort - Ascending