BKCC_Patron_Mapping_Spreadsheet

	A	B	C	E
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
4	borrowernumber			Patron ID
5	cardnumber	Primary Barcode		Primary Barcode
6	surname	Last Name		Home Library
7	firstname	First Name		First Name
8	title			Last Name
9	othernames			Address 1: Street 1
10	initials			Street 2
11	streetnumber			City
12	streettype			State
13	address	Address 1: Street 1	Column 5	Zip Code
14	address2	Street 2	Column 6	Address 2: Street 1
15	city	City	Column 7	Street 2
16	state	State	Column 8	City
17	zipcode	Zip Code	Column 9	State
18	email	Email Address		Zip Code
19	phone	Daytime Phone	Need to get mobile phone for final migration	Email Address
20	mobile	Evening Phone		Daytime Phone
21	fax			Evening Phone
22	emailpro (work e-mail)			DOB
23	phonepro (work phone)			Permission Group
24	B_streetnumber			Date Created
25	B_streettype			Expire Date
26	B_address	Address 2: Street 1	Column 10	Primary ID Value
27	B_address2	Street 2	Column 11	Secondary ID Value
28	B_city	City	Column 12	Alert Message
29	B_zipcode	State	Column 13	Gender
30	B_country	Zip Code	Column 14
31	B_email			Patron ID
32	B_phone			Primary Barcode
33	dateofbirth	DOB		Note Title
34	branchcode	Home Library	should be bkcc in HELM	Note Body
35	categorycode	Permission Group		Message
36	dateenrolled	Date Created
37	dateexpiry	Expire Date
38	gonenoaddress
39	lost
40	debarred
41	debarredcomment
42	contactname
43	contactfirstname
44	contacttitle
45	guarantorid
46	borrowernotes	Alert Message, Note Title, Note Body, Message
47	relationship
48	sex	Gender
49	password	Last Name (All Caps)	need default
50	userid	Primary Barcode	updated 12/3 per Nathan, JWS
51	opacnote
52	contactnote
53	sort1
54	sort2	Patron ID	Keep for now per Nathan 12/3, JWS
55	altcontactfirstname
56	altcontactsurname
57	altcontactaddress1
58	altcontactaddress2
59	altcontactaddress3
60	altcontactstate
61	altcontactzipcode
62	altcontactcountry
63	altcontactphone
64	Patron Attribute
65	collegeid	Primary ID Value	Yes, but hopefully Nathan will get permission for it to be the college ID
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