STCC_Patron_Mapping_Spreadsheet

	A	B	C	D	E	G
1	Data Migration Worksheets Patron Record Mapping
2	This sheet is used to describe how information will be mapped over from your current library system's patron info into the Koha patron record. The list below describes the core patron fields in the Koha patron record. Fill in the "current system" column with as much data as you know.
3	Koha	Current System	Notes		All fields	Other Notes
4	borrowernumber				Patron ID	For patrons with 2 records, only the record with the longer Primary Barcode should be migrated. If they only have one record, migrate whatever is in that field (likely the college ID #).
5	cardnumber	Primary Barcode		FAIL	Primary Barcode
6	surname	Last Name		OK	First Name
7	firstname	First Name		OK	Last Name
8	title				Address 1: Street 1
9	othernames				Street 2
10	initials				City
11	streetnumber				State
12	streettype				Zip Code
13	address	Address 1: Street 1		OK	Address 2: Street 1
14	address2	Street 2		OK	Street 2
15	city	City		OK	City
16	state	State		OK	State
17	zipcode	Zip Code		OK	Zip Code
18	email	Email Address, Secondary ID Value	Only five patrons with data in the Secondary ID field, all are email addresses	OK	Email Address
19	phone	Daytime Phone		OK	Daytime Phone
20	mobile	Evening Phone		OK	Evening Phone
21	fax				DOB
22	emailpro (work e-mail)				Permission Group
23	phonepro (work phone)				Date Created
24	B_streetnumber				Expire Date
25	B_streettype				Primary ID Value
26	B_address	Address 2: Street 1	Column 9	OK	Secondary ID Value
27	B_address2	Street 2	Column 10	OK	Alert Message
28	B_city	City	Column 11	OK	Gender
29	B_state	State	Column 12	OK
30	B_zipcode	Zip Code	Column 13	OK
31	B_country				Patron ID
32	B_email				Primary Barcode
33	B_phone				Note Title
34	dateofbirth	DOB		FAIL	Note Body
35	branchcode				Message
36	categorycode	Permission Group		OK
37	dateenrolled	Date Created		FAIL
38	dateexpiry	Expire Date		FAIL
39	gonenoaddress
40	lost
41	debarred
42	debarredcomment
43	contactname
44	contactfirstname
45	contacttitle
46	guarantorid
47	borrowernotes	Alert Message, Note Title, Note Body, Message		FAIL
48	relationship
49	sex		Removed 12/5 per Kim
50	password	Last Name [All Caps]	need default	OK
51	userid	Primary ID Value		OK
52	opacnote
53	contactnote
54	sort1
55	sort2
56	altcontactfirstname
57	altcontactsurname
58	altcontactaddress1
59	altcontactaddress2
60	altcontactaddress3
61	altcontactstate
62	altcontactzipcode
63	altcontactcountry
64	altcontactphone
65	Patron Attribute
66	college id	Primary ID Value + ST	ST at the end or not? Probably a good idea	OK
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