sif.db

source code

# This file is required by the script that queries
# the LDAP server and converts patron records to
# the Voyager SIF format.
#Item	offset	length	format	req?	name
01	1	10	n	n	patron id
02	11	10	n+	n	patron barcode id 1
03	21	25	s	n	patron barcode 1
04	46	10	s	n	patron group 1
05	56	1	n+	n	barcode status 1
06	57	10	d	n	barcode modified date 1
07	67	10	n+	n	patron barcode id 2
08	77	25	s	n	patron barcode 2
09	102	10	s	n	patron group 2
10	112	1	n+	n	barcode status 2
11	113	10	d	n	barcode modified date 2
12	123	10	n+	n	patron barcode id 3
13	133	25	s	n	patron barcode 3
14	158	10	s	n	patron group 3
15	168	1	n+	n	barcode status 3
16	169	10	d	n	barcode modified date 3
17	179	10	d	n	registration date
18	189	10	d	y	patron expiration date
19	199	10	d	y	patron purge date
20	209	10	b	n	voyager date
21	219	10	b	n	voyager updated
22	229	10	s	n	library location code
23	239	30	s	y	institution ID
24	269	11	s	y	ssn
25	280	3	s	n	statistical category 1
26	283	3	s	n	statistical category 2
27	286	3	s	n	statistical category 3
28	289	3	s	n	statistical category 4
29	292	3	s	n	statistical category 5
30	295	3	s	n	statistical category 6
31	298	3	s	n	statistical category 7
32	301	3	s	n	statistical category 8
33	304	3	s	n	statistical category 9
34	307	3	s	n	statistical category 10
35	310	1	n	y	name type
36	311	30	s	y	surname
37	341	20	s	n	first name
38	361	20	s	n	middle name
39	381	10	s	n	title
40	391	10	n	n	historical charges
41	401	5	n	n	claims returned count
42	406	5	n	n	self-shelved count
43	411	5	n	n	lost items count
44	416	5	n	n	late media returns
45	421	5	n	n	historical bookings
46	426	5	n	n	canceled bookings
47	431	5	n	n	unclaimed bookings
48	436	5	n	n	historical callslips
49	441	5	n	n	historical distributions
50	446	5	n	n	historical short loans
51	451	5	n	n	unclaimed short loans
52	456	1	n	y	address count
53	457	10	n	n	address id
54	467	1	n	y	address type
55	468	1	s	y	address status code
56	469	10	d	y	address begin date
57	479	10	d	y	address end date
58	489	50	s	y	address line 1
59	539	40	s	n	address line 2
60	579	40	s	n	address line 3
61	619	40	s	n	address line 4
62	659	40	s	n	address line 5
63	699	40	s	n	city
64	739	7	s	n	state (province) code
65	746	10	s	n	zipcode/postal code
66	756	20	s	n	country
67	776	25	s	n	phone (primary)
68	801	25	s	n	phone (mobile)
69	826	25	s	n	phone (fax)
70	851	25	s	n	phone (other)
71	876	10	b	n	date added/updated