mapping-preferences.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	property	field type	ui field name	priority	JIRA	Planned Q	MSU	Five Colleges	Cornell	UoChicago	Duke	Lehigh University	notes

2	id	string	-	0	MDEXP-210	Q3		1						Legend:
3	hrid	string	Instance HRID	0	MDEXP-210	Q3		0		0				0 - required in the instance record
4	source	string	Metadata source	0	MDEXP-210	Q3		2						1 - important
5	title	string	Resource title	0	MDEXP-210	Q3		0		0				2 - can wait
6	indexTitle							3				3		3 - not important
7	alternativeTitles	array of objects		1	MDEXP-217	Q3		0
8	editions	array of strings		1	MDEXP-210	Q3		3		0
9	series							0		0		1
10	identifiers	array of objects		1	MDEXP-217	Q3		0	0	0
11	contributors	array of objects		1	MDEXP -227	Q3		1		0
12	subjects	array of strings		1	MDEXP-210	Q3		3		1
13	classifications			??				3		1		2	Important for the libraries that use Dewey classification. Awaiting for UoCh
14	publication			0			0	0	0	0			Includes: Publisher, place, date of publication, role
15	publicationFrequency							3		2		2
16	publicationRange							3		2		2
17	electronicAccess			0	MDEXP-229	Q3	1	2		0
18	instanceTypeId	array of strings	Resource type term	0	MDEXP-217	Q3		0		0
19	instanceFormatIds							2
20	instanceFormats						1	2		1
21	physicalDescriptions			2			2	2		0
22	languages	array of strings		1	MDEXP-210	Q3		1		1
23	notes			2			1	1		0
24	modeOfIssuance	array of strings		1	MDEXP-217	Q3		0		1
25	catalogedDate			3				3				1
26	previouslyHeld			3				3
27	staffSuppress			3				0				2
28	discoverySuppress			3				0				0	We would need to filter on this, but it does not need to be included in the
29	statisticalCodeIds			3				1		2			We would want the codes themselves and not the IDs as the IDs are not meaningful outside of the system. ----- Is it possible to export the code or the name instead of the id?
30	statusIds			3				2		2		0	We would want the codes themselves and not the IDs as the IDs are not meaningful outside of the system.
31	statusUpdatedDate			3				2
32	tags							4				2
33	metadata			0	MDEXP-210	Q3		1
34	holdingsRecords2							0					I believe this is needed if we want holdings data associated with the instance data? (Laura)
35	natureOfContentTermIds							3
36	dateCreated??		Date created	0	MDEXP-210	Q3		1					Those are elements of the metadata element (row 33)
37	dateUpdated??		Date updated	0	MDEXP-210	Q3		1					Those are elements of the metadata element (row 33)
38	createdBy??		Created by	0	MDEXP-210	Q3		1					Those are elements of the metadata element (row 33)
39	updatedBy??		Updated by	0	MDEXP-210	Q3		1					Those are elements of the metadata element (row 33)
40
41
42
43	0
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100